Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.11.2026 05: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 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+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 2d
Command: who -b
bootup_info system boot 2026-10-26 18:11
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 8138024 kB
MemFree 1915428 kB
MemAvailable 7260640 kB
Buffers 79332 kB
Cached 5391360 kB
SwapCached 16 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-02 05:50:56
DTS_END                         2026-11-02 05:50:56.4020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/47062
TRN_ID                          223543
ATT_ID                          454
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: 15151.82 982 757591
customer order: creation 662.50 46 33125
customer order: refuse 53.34 47 2667
order to supplier: creation 169.76 204 8488
order to supplier: removal 13.14 8625 657
invoice (draft): creation 171.32 355 8566
invoice (draft): removal 125.16 151 6258
invoice accept: apply 141.64 1630 7082
invoice accept: cancel 100.26 214 5013
customer reserve: creation 7309.42 26 365471
customer reserve: removal 5389.18 15 269459
realization accept: apply 308.14 38 15407
realization accept: cancel 176.00 20 8800
payment from customer: creation 221.40 35 11070
payment from customer: removal 21.52 20 1076
payment to supplier: creation 179.90 30 8995
payment to supplier: removal 12.24 19 612
service: total inventory turnovers 38.94 461 1947
service: total monetary turnovers 52.48 7 2624
service: aggregate perf. data 5.44 1771 272
service: refresh index statistics 0.04 5920 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8365
TEST_TIME 2 10244
TEST_TIME 3 11061
TEST_TIME 4 11522
TEST_TIME 5 11794
TEST_TIME 6 12013
TEST_TIME 7 12346
TEST_TIME 8 12703
TEST_TIME 9 12564
TEST_TIME 10 12745
TEST_TIME 11 12948
TEST_TIME 12 12999
TEST_TIME 13 13201
TEST_TIME 14 13430
TEST_TIME 15 13516
TEST_TIME 16 13618
TEST_TIME 17 13705
TEST_TIME 18 13704
TEST_TIME 19 13912
TEST_TIME 20 13865
TEST_TIME 21 13952
TEST_TIME 22 14092
TEST_TIME 23 14087
TEST_TIME 24 14101
TEST_TIME 25 14217
TEST_TIME 26 14119
TEST_TIME 27 14224
TEST_TIME 28 14236
TEST_TIME 29 14259
TEST_TIME 30 14254
TEST_TIME 31 14348
TEST_TIME 32 14363
TEST_TIME 33 14530
TEST_TIME 34 14511
TEST_TIME 35 14645
TEST_TIME 36 14587
TEST_TIME 37 14604
TEST_TIME 38 14669
TEST_TIME 39 14756
TEST_TIME 40 14859
TEST_TIME 41 14805
TEST_TIME 42 14826
TEST_TIME 43 14835
TEST_TIME 44 14974
TEST_TIME 45 14969
TEST_TIME 46 15013
TEST_TIME 47 15091
TEST_TIME 48 15104
TEST_TIME 49 15168
TEST_TIME 50 15152

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 02-11-2026 05:51:15 to 02-11-2026 05:51:17.

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 1114636 1114636 0 0.00 0 1275 2 0 0
doc_list_biud 1114636 1114636 0 0.00 0 2152 5 0 0
sp_add_invoice_to_stock 7082 7082 0 0.00 8 12504 1631 0 0
sp_cancel_adding_invoice 5013 5013 0 0.00 2 4985 215 0 0
sp_cancel_client_order 2667 2667 0 0.00 3 1427 48 0 0
sp_cancel_customer_reserve 269459 269459 0 0.00 1 1533 15 0 0
sp_cancel_pay_from_customer 1076 1076 0 0.00 2 437 20 0 0
sp_cancel_pay_to_supplier 612 612 0 0.00 2 571 19 0 0
sp_cancel_supplier_invoice 6258 6258 0 0.00 1 2164 151 0 0
sp_cancel_supplier_order 657 657 0 0.00 6 59394 8625 0 0
sp_cancel_write_off 8800 8800 0 0.00 1 1239 21 0 0
sp_client_order 33125 33125 0 0.00 4 1360 46 0 0
sp_customer_reserve 365471 365471 0 0.00 0 2886 27 0 0
sp_fill_shopping_cart 50179 50179 0 0.00 1 1626 20 0 0
sp_fill_shopping_cart_clo_res 365471 365471 0 0.00 0 1330 2 0 0
sp_get_clo_for_invoice 7082 7082 0 0.00 0 1151 38 0 0
sp_kill_cost_storno 15501 15501 0 0.00 0 461 9 0 0
sp_kill_qstorno_ret_qs2qd 554633 554633 0 0.00 0 2145 8 0 0
sp_kill_qty_storno 315343 315343 0 0.00 0 2151 17 0 0
sp_lock_selected_doc 31336 31336 0 0.00 0 395 2 0 0
sp_make_cost_storno 42554 42554 0 0.00 0 424 6 0 0
sp_multiply_rows_for_pdistr 42554 42554 0 0.00 0 597 9 0 0
sp_multiply_rows_for_qdistr 33125 33125 0 0.00 0 800 18 0 0
sp_pay_from_customer 11070 11070 0 0.00 3 834 36 0 0
sp_pay_to_supplier 8995 8995 0 0.00 3 613 30 0 0
sp_payment_common 20065 20065 0 0.00 1 461 10 0 0
sp_qd_handle_on_cancel_clo 2667 2667 0 0.00 0 1381 32 0 0
sp_qd_handle_on_invoice_upd_sts 12095 12095 0 0.00 0 1282 70 0 0
sp_qd_handle_on_reserve_upd_sts 15407 15407 0 0.00 0 1051 10 0 0
sp_reserve_write_off 15407 15407 0 0.00 3 1056 38 0 0
sp_supplier_invoice 8566 8566 0 0.00 6 5062 355 0 0
sp_supplier_order 8488 8488 0 0.00 6 1754 204 0 0
srv_aggregate_perf_data 272 272 0 0.00 81 26307 1771 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 778 302 0 0
srv_find_qd_qs_mism 704113 704113 0 0.00 0 1275 1 0 0
srv_make_invnt_saldo 1947 1947 0 0.00 1 42701 461 0 0
srv_make_money_saldo 2624 2624 0 0.00 0 199 7 0 0
srv_recalc_idx_stat 2 2 0 0.00 231 11610 5921 0 0
v_add_invoice_to_stock 14164 14164 0 0.00 0 789 3 0 0
v_all_customers 50464 50464 0 0.00 0 37 1 0 0
v_all_suppliers 42250 42250 0 0.00 0 45 1 0 0
v_all_wares 66250 66250 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 1262 1262 0 0.00 0 185 2 0 0
v_cancel_client_order 5334 5334 0 0.00 0 186 1 0 0
v_cancel_customer_prepayment 2152 2152 0 0.00 0 290 2 0 0
v_cancel_customer_reserve 2038 2038 0 0.00 0 132 2 0 0
v_cancel_payment_to_supplier 1224 1224 0 0.00 0 519 2 0 0
v_cancel_supplier_invoice 1192 1192 0 0.00 0 164 3 0 0
v_cancel_supplier_order 1314 1314 0 0.00 0 248 2 0 0
v_cancel_write_off 3178 3178 0 0.00 0 133 2 0 0
v_max_id_clo_ord 8488 8488 0 0.00 0 42 1 0 0
v_max_id_clo_res 1493 1493 0 0.00 0 85 1 0 0
v_max_id_ord_sup 8566 8566 0 0.00 0 451 2 0 0
v_max_non_paid_invoice 4924 4924 0 0.00 0 105 2 0 0
v_max_non_paid_realizn 10704 10704 0 0.00 0 113 2 0 0
v_min_id_clo_ord 8488 8488 0 0.00 0 184 3 0 0
v_min_id_clo_res 1493 1493 0 0.00 0 347 4 0 0
v_min_id_ord_sup 8566 8566 0 0.00 0 865 5 0 0
v_min_non_paid_invoice 8995 8995 0 0.00 0 382 4 0 0
v_min_non_paid_realizn 11070 11070 0 0.00 0 409 6 0 0
v_our_firm 16518 16518 0 0.00 0 30 1 0 0
v_reserve_write_off 30814 30814 0 0.00 0 515 2 0 0
x_lock_depdocs_on_canc_invoice 10675 10675 0 0.00 0 630 9 0 0
x_lock_depdocs_on_canc_sup_ord 657 657 0 0.00 0 154 10 0 0
x_make_qstorno_1000_1200 8488 8488 0 0.00 1 1679 148 0 0
x_make_qstorno_1200_2000 8566 8566 0 0.00 1 4611 312 0 0
x_make_qstorno_2100_3300 365471 365471 0 0.00 0 2885 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2026 05:51:17 to 02-11-2026 05:51:21.

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
05:01:00 3 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:02:00 212 2147483648 2552340992 2626985984 221999856 9.369 19 14 23 1 225423472 656048 2767568
05:03:00 319 2147483648 2605486032 2691522560 272809216 11.271 20 12 26 0 276425904 893808 2722880
05:04:01 277 2147483648 2601496080 2688634880 269006832 11.132 20 12 17 2 271917264 895232 2015200
05:05:01 191 2147483648 2585320144 2668253184 252664800 10.527 20 7 13 0 254389488 580112 1144576
05:06:02 304 2147483648 2605602784 2693038080 272371840 11.255 20 9 18 0 275742416 1519152 1851424
05:07:02 153 2147483648 2602556352 2690621440 269365824 11.145 20 10 16 0 273495552 1887824 2241904
05:08:03 122 2147483648 2606598928 2695995392 272447536 11.258 20 12 22 0 276567120 1598512 2521072
05:09:03 386 2147483648 2592326208 2679746560 259230704 10.771 20 7 15 0 262029584 1212416 1586464
05:10:04 285 2147483648 2580660992 2666295296 248535728 10.372 19 12 21 0 251381744 1239536 1606480
05:11:04 212 2147483648 2589536144 2677047296 256850688 10.682 20 6 12 0 259886704 1763504 1272512
05:12:05 472 2147483648 2593651440 2682957824 261358160 10.849 20 9 17 2 264610432 1568848 1683424
05:13:06 748 2147483648 2597238416 2685067264 262364864 10.887 20 9 18 0 265572640 1627776 1580000
05:14:07 183 2147483648 2602876832 2691096576 267834112 11.088 20 11 22 0 272498320 2338800 2325408
05:15:07 403 2147483648 2600949456 2689839104 266435968 11.037 20 8 16 0 270140016 1990192 1713856
05:16:08 596 2147483648 2595955072 2682175488 260388960 10.814 20 13 27 1 264792672 1404800 2998912
05:17:09 108 2147483648 2602679232 2689306624 265334192 10.996 20 18 35 0 270835536 1719232 3782112
05:18:09 508 2147483648 2593218032 2683863040 261714256 10.863 20 8 16 0 264488896 1057328 1717312
05:19:10 620 2147483648 2595916368 2685378560 262368592 10.887 20 10 21 0 265975472 1692464 1914416
05:20:11 308 2147483648 2595606800 2684727296 262199360 10.881 20 10 20 0 265410976 1508576 1703040
05:21:11 142 2147483648 2601789536 2689232896 266550976 11.041 20 15 30 0 271483760 2000064 2932720
05:22:11 197 2147483648 2601577536 2687762432 263966016 10.946 20 16 31 0 270034656 2664240 3404400
05:23:12 165 2147483648 2596830688 2686611456 263339264 10.923 20 8 16 0 266561312 1677920 1544128
05:24:12 265 2147483648 2599862000 2687942656 265035456 10.985 20 10 20 0 269065632 1922208 2107968
05:25:14 87 2147483648 2596774576 2684399616 262142928 10.878 20 12 24 0 266456096 1745584 2567584
05:26:14 117 2147483648 2596425520 2684915712 262900720 10.907 20 11 19 0 266504784 1412928 2191136
05:27:14 125 2147483648 2593878960 2680725504 256652848 10.675 20 11 21 0 263100176 4142432 2304896
05:28:15 69 2147483648 2592309408 2681376768 259328032 10.774 20 8 16 0 262151840 1548544 1275264
05:29:15 139 2147483648 2604320576 2692681728 267956160 11.093 20 17 32 0 273365376 2122768 3286448
05:30:16 741 2147483648 2597917520 2686160896 263901040 10.943 20 8 16 0 266824544 1494032 1429472
05:31:17 201 2147483648 2606875248 2694758400 269366240 11.145 20 13 25 0 275357760 3062304 2929216
05:32:18 253 2147483648 2605594448 2695577600 270618528 11.191 20 11 22 0 276105168 3302816 2183824
05:33:18 123 2147483648 2601280752 2690838528 265592864 11.006 20 8 16 0 270024448 2844560 1587024
05:34:18 776 2147483648 2606119776 2697048064 269777920 11.160 20 11 22 0 272802384 1223904 1800560
05:35:19 319 2147483648 2600430752 2688909312 264100560 10.951 20 12 23 0 270179248 3395152 2683536
05:36:20 384 2147483648 2594448256 2685493248 262559280 10.894 20 9 18 0 265451792 1228992 1663520
05:37:21 404 2147483648 2595447648 2686701568 263348944 10.923 20 7 15 0 266128048 1108768 1670336
05:38:22 743 2147483648 2602520240 2693238784 268257104 11.104 20 11 22 0 272247008 1448656 2541248
05:39:23 628 2147483648 2590845632 2681024512 258354576 10.738 20 7 13 0 260399344 758016 1286752
05:40:23 141 2147483648 2600431024 2689449984 263977184 10.946 20 12 24 0 268770912 2532208 2261520
05:41:24 155 2147483648 2592754528 2681901056 258399216 10.740 20 14 28 0 262391376 1420832 2571328
05:42:27 149 2147483648 2593342240 2683949056 259681104 10.787 20 8 16 0 263158624 1811248 1666272
05:43:27 460 2147483648 2591300688 2683199488 259199712 10.769 20 5 10 0 261426688 1259568 967408
05:44:28 411 2147483648 2595330992 2686525440 262578128 10.895 20 7 12 0 265424720 1611504 1235088
05:45:29 155 2147483648 2598712320 2687721472 262256656 10.883 20 14 28 0 267323504 2240752 2826096
05:46:29 287 2147483648 2590572672 2677026816 255128992 10.618 20 17 35 0 260640192 2240560 3270640
05:47:30 198 2147483648 2605997552 2695122944 268633264 11.118 20 14 28 0 274557072 3531456 2392352
05:48:32 118 2147483648 2598682208 2686529536 262261408 10.883 20 12 24 0 267734432 2661264 2811760
05:49:33 138 2147483648 2595762352 2685087744 260890592 10.832 20 9 18 0 264875056 2025376 1959088
05:50:33 480 2147483648 2600327024 2691518464 267052992 11.060 20 11 21 0 271527840 2490000 1984848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 02-11-2026 05:51:22 to 02-11-2026 05:51:33.

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 02-11-2026 05:51:34 to 02-11-2026 05:51:35.

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          222218
MON$OLDEST_ACTIVE               224365
MON$OLDEST_SNAPSHOT             224365
MON$NEXT_TRANSACTION            224365
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-02 05:00:09.7160
MON$PAGES                       138688
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.33892 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33892 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33892 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33892 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    Mon Nov  2 05:50:58 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Mon Nov  2 05:50:58 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
--- end of diff output ---

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

02.11.26 05:51:35. 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-02 05:51:37 No severe PSQL-related problems occured
02.11.26 05:51:37. End of report.