Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 14.11.2026 23:51
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2w
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 4772020 kB
MemAvailable 7390488 kB
Buffers 71664 kB
Cached 2732900 kB
SwapCached 0 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Server and database settinfs


SERVER_MODE                     SuperServer 3.0.15
DB_NAME                         /var/db/oltp-emul/oltp-hq30.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/var/db/oltp-emul/oltp-hq30.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_30.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq30/bin
param=file_name_this_host_info, val=test-0
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=html_chart_color_memo_all, val=magenta
param=html_chart_color_memo_att, val=magenta
param=html_chart_color_memo_stm, val=magenta
param=html_chart_color_memo_trn, val=magenta
param=html_chart_color_perf_score, val=magenta
param=init_buff, val=4096
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=30300
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-hq30-results.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=50
param=tmpdir, val=/var/tmp/logs.oltp-hq30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-14 23:50:54
DTS_END                         2026-11-14 23:50:54.1020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(92:14) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/47330
TRN_ID                          231520
ATT_ID                          478
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 1000

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 50 minutes: 15455.24 980 772762
customer order: creation 682.02 46 34101
customer order: refuse 55.70 31 2785
order to supplier: creation 175.20 206 8760
order to supplier: removal 11.96 9584 598
invoice (draft): creation 174.04 358 8702
invoice (draft): removal 121.84 151 6092
invoice accept: apply 151.18 1543 7559
invoice accept: cancel 102.50 225 5125
customer reserve: creation 7527.10 26 376355
customer reserve: removal 5406.52 15 270326
realization accept: apply 318.84 35 15942
realization accept: cancel 177.90 18 8895
payment from customer: creation 227.28 32 11364
payment from customer: removal 22.00 18 1100
payment to supplier: creation 186.12 28 9306
payment to supplier: removal 13.28 15 664
service: total inventory turnovers 41.52 394 2076
service: total monetary turnovers 54.82 8 2741
service: aggregate perf. data 5.38 1779 269
service: refresh index statistics 0.04 5079 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-11-2026 23:51:10 to 14-11-2026 23:51:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9443
TEST_TIME 2 11318
TEST_TIME 3 12012
TEST_TIME 4 12594
TEST_TIME 5 12617
TEST_TIME 6 13102
TEST_TIME 7 13147
TEST_TIME 8 13271
TEST_TIME 9 13479
TEST_TIME 10 13527
TEST_TIME 11 13580
TEST_TIME 12 13594
TEST_TIME 13 13687
TEST_TIME 14 13790
TEST_TIME 15 13843
TEST_TIME 16 13825
TEST_TIME 17 13973
TEST_TIME 18 13929
TEST_TIME 19 13980
TEST_TIME 20 13998
TEST_TIME 21 14085
TEST_TIME 22 14001
TEST_TIME 23 14132
TEST_TIME 24 14223
TEST_TIME 25 14333
TEST_TIME 26 14353
TEST_TIME 27 14285
TEST_TIME 28 14436
TEST_TIME 29 14439
TEST_TIME 30 14570
TEST_TIME 31 14579
TEST_TIME 32 14554
TEST_TIME 33 14653
TEST_TIME 34 14840
TEST_TIME 35 14871
TEST_TIME 36 14874
TEST_TIME 37 14960
TEST_TIME 38 15080
TEST_TIME 39 15066
TEST_TIME 40 15128
TEST_TIME 41 15225
TEST_TIME 42 15237
TEST_TIME 43 15308
TEST_TIME 44 15285
TEST_TIME 45 15297
TEST_TIME 46 15347
TEST_TIME 47 15396
TEST_TIME 48 15466
TEST_TIME 49 15498
TEST_TIME 50 15455

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 14-11-2026 23:51:13 to 14-11-2026 23:51:15.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1141962 1141962 0 0.00 0 882 2 0 0
doc_list_biud 1141962 1141962 0 0.00 0 1871 5 0 0
sp_add_invoice_to_stock 7559 7559 0 0.00 6 14589 1544 0 0
sp_cancel_adding_invoice 5125 5125 0 0.00 2 4679 225 0 0
sp_cancel_client_order 2785 2785 0 0.00 3 867 32 0 0
sp_cancel_customer_reserve 270326 270326 0 0.00 1 1883 16 0 0
sp_cancel_pay_from_customer 1100 1100 0 0.00 2 452 19 0 0
sp_cancel_pay_to_supplier 664 664 0 0.00 2 90 16 0 0
sp_cancel_supplier_invoice 6092 6092 0 0.00 1 1125 151 0 0
sp_cancel_supplier_order 598 598 0 0.00 8 54528 9585 0 0
sp_cancel_write_off 8895 8895 0 0.00 1 870 19 0 0
sp_client_order 34101 34101 0 0.00 4 1061 46 0 0
sp_customer_reserve 376355 376355 0 0.00 0 2010 27 0 0
sp_fill_shopping_cart 51563 51563 0 0.00 1 1568 21 0 0
sp_fill_shopping_cart_clo_res 376355 376355 0 0.00 0 1086 2 0 0
sp_get_clo_for_invoice 7559 7559 0 0.00 0 1839 37 0 0
sp_kill_cost_storno 15784 15784 0 0.00 0 503 9 0 0
sp_kill_qstorno_ret_qs2qd 556237 556237 0 0.00 0 1743 8 0 0
sp_kill_qty_storno 317322 317322 0 0.00 0 1868 18 0 0
sp_lock_selected_doc 32522 32522 0 0.00 0 454 2 0 0
sp_make_cost_storno 44171 44171 0 0.00 0 739 7 0 0
sp_multiply_rows_for_pdistr 44171 44171 0 0.00 0 509 9 0 0
sp_multiply_rows_for_qdistr 34101 34101 0 0.00 0 1050 18 0 0
sp_pay_from_customer 11364 11364 0 0.00 3 599 32 0 0
sp_pay_to_supplier 9306 9306 0 0.00 3 652 29 0 0
sp_payment_common 20670 20670 0 0.00 1 477 7 0 0
sp_qd_handle_on_cancel_clo 2785 2785 0 0.00 0 863 20 0 0
sp_qd_handle_on_invoice_upd_sts 12684 12684 0 0.00 0 1266 74 0 0
sp_qd_handle_on_reserve_upd_sts 15942 15942 0 0.00 0 784 10 0 0
sp_reserve_write_off 15942 15942 0 0.00 3 890 35 0 0
sp_supplier_invoice 8702 8702 0 0.00 6 4090 359 0 0
sp_supplier_order 8760 8760 0 0.00 5 1713 207 0 0
srv_aggregate_perf_data 269 269 0 0.00 55 13286 1779 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1663 266 0 0
srv_find_qd_qs_mism 718425 718425 0 0.00 0 881 1 0 0
srv_make_invnt_saldo 2076 2076 0 0.00 0 27251 394 0 0
srv_make_money_saldo 2741 2741 0 0.00 0 237 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 257 9902 5080 0 0
v_add_invoice_to_stock 15118 15118 0 0.00 0 472 2 0 0
v_all_customers 51970 51970 0 0.00 0 31 1 0 0
v_all_suppliers 42612 42612 0 0.00 0 36 1 0 0
v_all_wares 68202 68202 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 1270 1270 0 0.00 0 195 2 0 0
v_cancel_client_order 5570 5570 0 0.00 0 466 1 0 0
v_cancel_customer_prepayment 2200 2200 0 0.00 0 437 1 0 0
v_cancel_customer_reserve 2168 2168 0 0.00 0 246 2 0 0
v_cancel_payment_to_supplier 1328 1328 0 0.00 0 47 1 0 0
v_cancel_supplier_invoice 1226 1226 0 0.00 0 245 3 0 0
v_cancel_supplier_order 1196 1196 0 0.00 0 338 2 0 0
v_cancel_write_off 3084 3084 0 0.00 0 477 2 0 0
v_max_id_clo_ord 8760 8760 0 0.00 0 132 1 0 0
v_max_id_clo_res 1581 1581 0 0.00 0 640 2 0 0
v_max_id_ord_sup 8702 8702 0 0.00 0 395 2 0 0
v_max_non_paid_invoice 5462 5462 0 0.00 0 44 1 0 0
v_max_non_paid_realizn 10972 10972 0 0.00 0 78 1 0 0
v_min_id_clo_ord 8760 8760 0 0.00 0 300 3 0 0
v_min_id_clo_res 1581 1581 0 0.00 0 339 4 0 0
v_min_id_ord_sup 8702 8702 0 0.00 0 649 4 0 0
v_min_non_paid_invoice 9306 9306 0 0.00 0 474 3 0 0
v_min_non_paid_realizn 11364 11364 0 0.00 0 288 2 0 0
v_our_firm 17016 17016 0 0.00 0 25 1 0 0
v_reserve_write_off 31884 31884 0 0.00 0 305 1 0 0
x_lock_depdocs_on_canc_invoice 10604 10604 0 0.00 0 957 10 0 0
x_lock_depdocs_on_canc_sup_ord 598 598 0 0.00 0 116 11 0 0
x_make_qstorno_1000_1200 8760 8760 0 0.00 1 1680 150 0 0
x_make_qstorno_1200_2000 8702 8702 0 0.00 1 4075 314 0 0
x_make_qstorno_2100_3300 376355 376355 0 0.00 0 2009 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2026 23:51:15 to 14-11-2026 23:51:19.

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, bytes
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = size of cache for metadata, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:00:57 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:01:57 185 2147483648 2541243792 2614153216 211256432 8.956 19 9 15 0 213016000 522224 1237344
23:02:58 148 2147483648 2603330336 2688655360 269883264 11.164 20 12 23 0 273385984 1100128 2402592
23:03:58 136 2147483648 2602504896 2688180224 269965120 11.167 20 12 25 0 277018768 4471456 2582192
23:04:59 259 2147483648 2593449504 2678177792 259991552 10.799 20 12 23 0 263246896 1022416 2232928
23:05:59 174 2147483648 2593320752 2678419456 260665808 10.824 20 14 28 0 264779712 1442176 2671728
23:07:00 196 2147483648 2595891872 2680975360 262621536 10.896 20 14 28 0 266526176 1343616 2561024
23:08:00 169 2147483648 2601834352 2691133440 270274848 11.178 20 8 14 0 272401840 935120 1191872
23:09:01 95 2147483648 2596720832 2681966592 261683728 10.861 20 13 24 1 266459584 2072688 2703168
23:10:01 224 2147483648 2594263040 2681049088 260809840 10.829 20 11 23 0 264214928 1373088 2032000
23:11:02 133 2147483648 2597189328 2683416576 262440208 10.889 20 11 22 0 266853008 2270112 2142688
23:12:02 169 2147483648 2599762368 2688897024 266882496 11.053 20 10 20 0 270769792 1958416 1928880
23:13:02 834 2147483648 2589086192 2674245632 251842608 10.496 19 12 24 0 255947536 1815232 2289696
23:14:03 224 2147483648 2596869312 2683998208 262974032 10.909 20 8 16 0 266436832 1827344 1635456
23:15:04 217 2147483648 2599675424 2687565824 265174064 10.990 20 11 22 0 269266736 1976368 2116304
23:16:05 137 2147483648 2570220816 2655129600 237774240 9.968 18 12 22 1 241283040 1327696 2181104
23:17:05 174 2147483648 2601648656 2688864256 265817184 11.014 20 10 20 0 271076304 2834256 2424864
23:18:06 1663 2147483648 2597954464 2686283776 263372144 10.924 20 7 14 0 266416496 1699808 1344544
23:19:08 206 2147483648 2596611840 2686746624 263177840 10.917 20 7 14 0 266669264 1633296 1858128
23:20:08 140 2147483648 2602948080 2691895296 266428144 11.037 20 16 32 0 271779120 2056112 3294864
23:21:08 206 2147483648 2600373488 2687537152 265370000 10.998 20 14 29 0 269866288 1724464 2771824
23:22:09 457 2147483648 2598507536 2686685184 263681504 10.935 20 12 24 0 268120768 2240656 2198608
23:23:09 104 2147483648 2602652416 2691481600 267210320 11.066 20 11 22 0 272255440 2718400 2326720
23:24:10 144 2147483648 2594282624 2679992320 259255584 10.772 20 15 26 1 263142592 1602128 2284880
23:25:10 490 2147483648 2599600640 2689708032 265854544 11.016 20 7 14 0 268518992 1418256 1246192
23:26:11 149 2147483648 2602635664 2690711552 267033136 11.059 20 15 30 0 271341184 1642096 2665952
23:27:11 308 2147483648 2597571136 2689302528 265527472 11.003 20 7 14 0 268263696 1043232 1692992
23:28:12 100 2147483648 2598867584 2686681088 262167104 10.879 20 12 24 0 268256176 3582784 2506288
23:29:12 442 2147483648 2602121456 2692308992 269017312 11.132 20 8 16 1 272517872 1713376 1787184
23:30:13 107 2147483648 2602461168 2689912832 265418608 10.999 20 12 24 0 271386432 3397200 2570624
23:31:13 136 2147483648 2600597328 2687455232 264946640 10.982 20 17 33 0 269856800 1927696 2982464
23:32:14 106 2147483648 2600828080 2690887680 267456128 11.075 20 9 18 0 270502080 1178192 1867760
23:33:14 70 2147483648 2592779296 2681683968 259679488 10.787 20 10 20 0 262761712 1419136 1663088
23:34:14 145 2147483648 2600158928 2690166784 264629936 10.970 20 8 16 0 268582192 2420256 1532000
23:35:14 125 2147483648 2601296336 2692198400 266799904 11.050 20 11 22 0 270407568 1294512 2313152
23:36:15 141 2147483648 2588990416 2674778112 252496768 10.520 20 14 28 0 257266288 2010112 2759408
23:37:15 150 2147483648 2603296992 2691465216 265638880 11.008 20 12 24 0 272521440 4117952 2764608
23:38:15 155 2147483648 2600299600 2689355776 264247424 10.956 20 13 24 1 269715552 2844224 2623904
23:39:16 79 2147483648 2592698672 2681507840 258405520 10.740 20 11 23 0 261996240 1693008 1897712
23:40:16 455 2147483648 2599812768 2688204800 263832240 10.941 20 14 30 0 268915232 1749104 3333888
23:41:17 154 2147483648 2605146864 2692399104 267584992 11.079 20 16 31 1 273639840 3098128 2956720
23:42:17 414 2147483648 2598861840 2691969024 266834560 11.052 20 5 10 0 268811840 1087712 889568
23:43:18 889 2147483648 2584328320 2670764032 245816000 10.271 19 12 25 0 249687824 1564240 2307584
23:44:19 176 2147483648 2586864256 2673020928 251334144 10.477 20 12 23 1 256561312 2879216 2347952
23:45:19 182 2147483648 2599043696 2688536576 264928864 10.981 20 7 14 0 268353440 1994848 1429728
23:46:20 801 2147483648 2598223568 2688180224 265026416 10.985 20 8 16 0 268031344 1625040 1379888
23:47:21 103 2147483648 2601388944 2689638400 264160864 10.953 20 12 24 0 269824400 2998800 2664736
23:48:21 430 2147483648 2598177088 2685444096 260704480 10.825 20 18 34 0 269424800 5107968 3612352
23:49:21 134 2147483648 2602259184 2694811648 267107328 11.062 20 11 21 0 271209664 1616656 2485680
23:50:22 235 2147483648 2601812160 2690961408 265435632 11.000 20 10 20 0 269826784 2575136 1816016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 14-11-2026 23:51:19 to 14-11-2026 23:51:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 14-11-2026 23:51:31 to 14-11-2026 23:51:32.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq30.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          229394
MON$OLDEST_ACTIVE               231644
MON$OLDEST_SNAPSHOT             231644
MON$NEXT_TRANSACTION            231644
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-14 23:00:08.5400
MON$PAGES                       145408
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.15.33893 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33893 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
on disk structure version 12.0

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: test-0    Sat Nov 14 23:50:55 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Sat Nov 14 23:50:56 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Sat Nov 14 23:50:56 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
:18: 
:19: test-0    Sat Nov 14 23:50:56 2026
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:21: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs.oltp-hq30 according to config parameter 'remove_isql_logs'

14.11.26 23:51:33. There are 3 logs in /var/tmp/logs.oltp-hq30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2026-11-14 23:51:34 No severe PSQL-related problems occured
14.11.26 23:51:35. End of report.