View Issue Details

IDProjectCategoryView StatusLast Update
0008586VALENTINA SERVERDatabasepublic2019-11-06 10:12
ReporterAleksandar SpasojevicAssigned To 
PriorityurgentSeverityblockReproducibilitysometimes
Status newResolutionopen 
PlatformINTELOSWINDOWS SERVER 2019OS Version*
Product Version 
Target Version9.7.xFixed in Version 
Summary0008586: VServer takes to much virtual memory
DescriptionThe problem started with latest version of VServer, 9.3.1 . After some time, virtual memory consumed by VServer goes through roof. For example, I am posting Event viewer report where it takes 14 GB. On DB which takes about 2 GB, after 3 days of running, VServer went up to 60GB. There is no anything special I was using after Update, and only SELECT queries were executed on VServer. Also, I am always releasing cursors after task.

I don't have logs for this period, they were disabled in config. I will set it now and leave it for some time, it should take few GB in next couple hours.
Steps To Reproduce20+ connections executing any SQL queries on every few seconds (1-5).
TagsNo tags attached.

Activities

Aleksandar Spasojevic

Aleksandar Spasojevic

2019-07-26 15:03

reporter  

VServer virtual memory.png (5,380 bytes)
Ivan Smahin

Ivan Smahin

2019-07-30 07:09

manager   ~0010921

For now - no leaks detected :(
Could you please send me
- vServer log (verboosemode = 3)
- empty db
- most frequent queries to that db
?

Also, could you try http://valentina-db.com/download/beta/9.5b10/win_64/vserver_x64_9_win.exe ?
(Probably this leak was fixed silently)

Issue History

Date Modified Username Field Change
2019-07-26 15:03 Aleksandar Spasojevic New Issue
2019-07-26 15:03 Aleksandar Spasojevic File Added: VServer virtual memory.png
2019-07-30 07:09 Ivan Smahin Note Added: 0010921
2019-11-06 10:12 Ruslan Zasukhin Target Version => 9.7.x