IBProvider Developer's Blog

Dmitry Kovalenko  on 20 сентября, 2023

Release binary of IBProvider 32bit was tested, too:

[18.09.2023 23:10:00] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w32_prof_i.dll
[18.09.2023 23:10:00] [info] Provider Version:5.32.0.44369
[18.09.2023 23:10:00] [info] Server Name     :Firebird
[18.09.2023 23:10:00] [info] Server Version  :4.0.4.2984
[18.09.2023 23:10:00] [info] Client Name     :LCPI.IBProvider.RemoteFB
[18.09.2023 23:10:00] [info] Client Version  :5.32.0.44369
[18.09.2023 23:10:00] [info] Database ODS    :13.0
[18.09.2023 23:10:00] [info] Database Dialect:3
[18.09.2023 23:10:00] [info] ConnectionString:

provider=LCPI.IBProvider.5.Private.vc17.release;location=inet4://localhost:3070/d:\database\ram\FB40_PORT3070\ibp_test_fb40_d3_2.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;icu_library=icuuc63.dll;icuin_library=icuin63.dll;dbclient_type=fb.direct;

[18.09.2023 23:10:00] [ExecuteTests] 
[18.09.2023 23:10:00] [ExecuteTests] Enter [cancel] for interrupt execution
[18.09.2023 23:10:00] [ExecuteTests] 
[18.09.2023 23:10:00] Creation 8 thread(s)...
[18.09.2023 23:10:00] Start Thread01
[18.09.2023 23:10:00] Start Thread02
[18.09.2023 23:10:00] Start Thread03
[18.09.2023 23:10:00] Start Thread04
[18.09.2023 23:10:00] Start Thread05
[18.09.2023 23:10:00] Start Thread06
[18.09.2023 23:10:00] Start Thread07
[18.09.2023 23:10:00] Start Thread08
...
[20.09.2023 03:58:35] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[20.09.2023 03:58:35] [summary] [TESTS]
[20.09.2023 03:58:35] [summary] EXECUTED      : 744192
[20.09.2023 03:58:35] [summary] SUCCEEDED     : 744136
[20.09.2023 03:58:35] [summary] FAILED        : 0
[20.09.2023 03:58:35] [summary] WITH WARNINGS : 56 [ 89 warning(s) ]
[20.09.2023 03:58:35] [summary] 
[20.09.2023 03:58:35] [summary] - - - - - - - - - - - - - - - - - - - - - -
[20.09.2023 03:58:35] [summary] [TEST TIMES]
[20.09.2023 03:58:35] [summary] REAL          : 8268791774725 [9 day(s)13:41:19.1774725]
[20.09.2023 03:58:35] [summary] USER          : 1075392812500 [1 day(s)05:52:19.2812500]
[20.09.2023 03:58:35] [summary] KERNEL        : 420370625000  [11:40:37.0625000]
[20.09.2023 03:58:35] [summary] TOTAL         : 1495763437500 [1 day(s)17:32:56.3437500]
[20.09.2023 03:58:35] 
[20.09.2023 03:58:35] [TEST HEAP] Test heap is empty
[20.09.2023 03:58:35] [TEST HEAP] Validate ... OK
[20.09.2023 03:58:35] [TEST HEAP] Destroy ... OK
[20.09.2023 03:58:35] 
[20.09.2023 03:58:35] [summary] ------------------------------------------- [PROCESS INFORMATION]
[20.09.2023 03:58:35] [summary] [VIRTUAL MEMORY]
[20.09.2023 03:58:35] [summary] 
[20.09.2023 03:58:35] [summary] PRIVATE BYTES      : 23284 KB       [22MB 756KB]
[20.09.2023 03:58:35] [summary] PEAK PRIVATE BYTES : 1451592 KB     [1GB 393MB 584KB]
[20.09.2023 03:58:35] [summary] VIRTUAL SIZE       : 307180 KB      [299MB 1004KB]
[20.09.2023 03:58:35] [summary] PAGE FAULT COUNT   : 180455852
[20.09.2023 03:58:35] [summary] 
[20.09.2023 03:58:35] [summary] - - - - - - - - - - - - - - - - - - - - - -
[20.09.2023 03:58:35] [summary] [HANDLES]
[20.09.2023 03:58:35] [summary] 
[20.09.2023 03:58:35] [summary] HANDLES            : 597
[20.09.2023 03:58:35] [summary] 
[20.09.2023 03:58:35] [summary] - - - - - - - - - - - - - - - - - - - - - -
[20.09.2023 03:58:35] [summary] TOTAL ERRORS  : 0
[20.09.2023 03:58:35] [summary] TOTAL WARNINGS: 89
[20.09.2023 03:58:35] [summary] FULL PASSES   : 1
[20.09.2023 03:58:35] [summary] GEN TESTS     : 8338266

Dmitry Kovalenko  on 21 сентября, 2023

Here is the result of load testing of IBProvider 64bit with fbclient.dll.

We see memory leaks, an additional (to the new DTC problems) leak of handles and errors.

The errors are the result of problems in a protocol and problems in fbclient implementation. The protocol issues can also occur in RemoteFB but significantly less often.

All this was expected.

[20.09.2023 03:58:37] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_i.dll
[20.09.2023 03:58:37] [info] Provider Version:5.32.0.44369
[20.09.2023 03:58:37] [info] Server Name     :Firebird
[20.09.2023 03:58:37] [info] Server Version  :4.0.4.2984
[20.09.2023 03:58:37] [info] Client Name     :Firebird
[20.09.2023 03:58:37] [info] Client Version  :4.0.4.2984
[20.09.2023 03:58:37] [info] Database ODS    :13.0
[20.09.2023 03:58:37] [info] Database Dialect:3
[20.09.2023 03:58:37] [info] ConnectionString:

provider=LCPI.IBProvider.5.Private.vc17.release;location=inet4://localhost:3070/d:\database\ram\FB40_PORT3070\ibp_test_fb40_d3_2.gdb;user id=GAMER;password=vermut;ctype=win1251;temp_file_dir=d:\database\ram\temp;icu_library=icuuc63.dll;icuin_library=icuin63.dll;dbclient_library=fbclient_40.dll;

[20.09.2023 03:58:37] [ExecuteTests] 
[20.09.2023 03:58:37] [ExecuteTests] Enter [cancel] for interrupt execution
[20.09.2023 03:58:37] [ExecuteTests] 
[20.09.2023 03:58:37] Creation 10 thread(s)...
...
[21.09.2023 08:09:05] [summary] ------------------------------------------- [SUMMARY INFORMATION]
[21.09.2023 08:09:05] [summary] [TESTS]
[21.09.2023 08:09:05] [summary] EXECUTED      : 744206
[21.09.2023 08:09:05] [summary] SUCCEEDED     : 744141
[21.09.2023 08:09:05] [summary] FAILED        : 3 [ 3 error(s) ]
[21.09.2023 08:09:05] [summary] WITH WARNINGS : 62 [ 87 warning(s) ]
[21.09.2023 08:09:05] [summary] 
[21.09.2023 08:09:05] [summary] - - - - - - - - - - - - - - - - - - - - - -
[21.09.2023 08:09:05] [summary] [TEST TIMES]
[21.09.2023 08:09:05] [summary] REAL          : 10108577221339 [11 day(s)16:47:37.7221339]
[21.09.2023 08:09:05] [summary] USER          : 1194322031250 [1 day(s)09:10:32.2031250]
[21.09.2023 08:09:05] [summary] KERNEL        : 401840937500  [11:09:44.0937500]
[21.09.2023 08:09:05] [summary] TOTAL         : 1596162968750 [1 day(s)20:20:16.2968750]
[21.09.2023 08:09:05] 
[21.09.2023 08:09:05] [TEST HEAP] Test heap is empty
[21.09.2023 08:09:05] [TEST HEAP] Validate ... OK
[21.09.2023 08:09:05] [TEST HEAP] Destroy ... OK
[21.09.2023 08:09:05] 
[21.09.2023 08:09:05] [summary] ------------------------------------------- [PROCESS INFORMATION]
[21.09.2023 08:09:05] [summary] [VIRTUAL MEMORY]
[21.09.2023 08:09:05] [summary] 
[21.09.2023 08:09:05] [summary] PRIVATE BYTES      : 488812 KB      [477MB 364KB]
[21.09.2023 08:09:05] [summary] PEAK PRIVATE BYTES : 13172968 KB    [12GB 576MB 232KB]
[21.09.2023 08:09:05] [summary] VIRTUAL SIZE       : 5036752 KB     [4GB 822MB 720KB]
[21.09.2023 08:09:05] [summary] PAGE FAULT COUNT   : 502633159
[21.09.2023 08:09:05] [summary] 
[21.09.2023 08:09:05] [summary] - - - - - - - - - - - - - - - - - - - - - -
[21.09.2023 08:09:05] [summary] [HANDLES]
[21.09.2023 08:09:05] [summary] 
[21.09.2023 08:09:05] [summary] HANDLES            : 651
[21.09.2023 08:09:05] [summary] 
[21.09.2023 08:09:05] [summary] - - - - - - - - - - - - - - - - - - - - - -
[21.09.2023 08:09:05] [summary] TOTAL ERRORS  : 3
[21.09.2023 08:09:05] [summary] TOTAL WARNINGS: 87
[21.09.2023 08:09:05] [summary] FULL PASSES   : 1
[21.09.2023 08:09:05] [summary] GEN TESTS     : 8338268

OK.

IBProvider 32bit with fbclient are not testing, because I stopped spending time for researching the reason of different problems in fbclient — please, use fb.direct mode 🙂

So, the next test of IBProvider and D1 has been started immediately after the previous one.

[21.09.2023 08:09:06] [info] Provider DLL    :lcpi.ibprovider-v5_vc17_w64_prof_d.dll
[21.09.2023 08:09:06] [info] Provider Version:5.32.0.44369
[21.09.2023 08:09:06] [info] Server Name     :Firebird
[21.09.2023 08:09:06] [info] Server Version  :4.0.4.2984
[21.09.2023 08:09:06] [info] Client Name     :LCPI.IBProvider.RemoteFB
[21.09.2023 08:09:06] [info] Client Version  :5.32.0.44369
[21.09.2023 08:09:06] [info] Database ODS    :13.0
[21.09.2023 08:09:06] [info] Database Dialect:1
[21.09.2023 08:09:06] [info] ConnectionString:

Dmitry Kovalenko  on 29 сентября, 2023

The load test of v5.32.0.44369 has been finished today.

Everything is ok.

By fact this version has been already outdated because v5.33 looks more interesting.

The current state of FB that was used in tests: