Issue Details (XML | Word | Printable)

Key: CORE-5416
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Kovalenko Dmitry
Votes: 0
Watchers: 4

If you were logged in you would be able to see more operations.
Firebird Core

[FB3] Memory Leaks. FB does not release memory after load tests.

Created: 09/Dec/16 06:15 PM   Updated: 05/Apr/17 08:18 AM
Component/s: None
Affects Version/s: 4.0 Initial, 3.0.0, 3.0.1, 3.0.2
Fix Version/s: 4.0 Alpha 1, 3.0.3

File Attachments: 1. Text File firebird.exe.ProcessExplorerData__DLLs.txt (21 kB)
2. Text File firebird.exe.ProcessExplorerData__Resources.txt (19 kB)
3. File IBP_TEST_FB30_D3.7z (472 kB)

Image Attachments:

1. fb_image.png
(19 kB)

2. fb_performance.png
(20 kB)
Environment: FB SuperServer x64, Win10 x64 Pro, IBProvider Test System
Issue Links:

QA Status: No test

 Description  « Hide
Firebird does not release memory after completion of load tests.

Size of each memory leaks ~ equal to size of page cache

One interest moment:
1. When I execute (sequential) two "load tests set" without pause - FB not releases memory after second set.
@call run_test_w64_local2_d3.bat
@call run_test_w32_local2_d3.bat

Memory leak (approximately) == 3.5 GB

2. When I added a pause (10 min) between runs - I see 2xLeaks.
@call run_test_w64_local2_d3.bat
sleep 10m
@call run_test_w32_local2_d3.bat

Memory leak (approximately) == 7GB

Database Page: 16KB

Changes in firebird.conf:
DefaultDbCachePages = 200000
UserManager = Srp, Legacy_UserManager
MaxUnflushedWrites = -1
MaxUnflushedWriteTime = -1
WireCrypt = Enabled

Additional information for attached screenshots - because I executed parallel tests for two databases, memory leaks was multiplied by two and equal (at current moment) to 21GB.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 11/Dec/16 08:21 AM
Did you set database linger to some non-zero value at test database ?

Kovalenko Dmitry added a comment - 11/Dec/16 08:33 AM
>Did you set database linger to some non-zero value at test database ?


Database was created with default settings.

See attached archive with test database.

Kovalenko Dmitry added a comment - 11/Dec/16 08:35 AM
Empty test database for FB3, third dialect.