Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 14.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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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-09 10: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 8138016 kB
MemFree 1957464 kB
MemAvailable 7279804 kB
Buffers 81420 kB
Cached 5358600 kB
SwapCached 12 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 05:50:54
DTS_END                         2026-11-14 05:50:54.2150
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/57796
TRN_ID                          237253
ATT_ID                          476
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: 16844.94 873 842247
customer order: creation 705.70 43 35285
customer order: refuse 58.54 46 2927
order to supplier: creation 181.44 192 9072
order to supplier: removal 12.96 9063 648
invoice (draft): creation 178.42 341 8921
invoice (draft): removal 132.80 144 6640
invoice accept: apply 152.86 1538 7643
invoice accept: cancel 110.36 209 5518
customer reserve: creation 8107.78 24 405389
customer reserve: removal 6107.48 13 305374
realization accept: apply 331.54 33 16577
realization accept: cancel 201.40 18 10070
payment from customer: creation 236.02 36 11801
payment from customer: removal 22.50 17 1125
payment to supplier: creation 188.02 29 9401
payment to supplier: removal 14.06 16 703
service: total inventory turnovers 40.98 433 2049
service: total monetary turnovers 57.08 8 2854
service: aggregate perf. data 4.96 2094 248
service: refresh index statistics 0.04 3162 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 14-11-2026 05:51:08 to 14-11-2026 05:51:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10688
TEST_TIME 2 12091
TEST_TIME 3 13229
TEST_TIME 4 13924
TEST_TIME 5 14306
TEST_TIME 6 14498
TEST_TIME 7 14752
TEST_TIME 8 14887
TEST_TIME 9 15139
TEST_TIME 10 15135
TEST_TIME 11 15419
TEST_TIME 12 15405
TEST_TIME 13 15502
TEST_TIME 14 15461
TEST_TIME 15 15581
TEST_TIME 16 15668
TEST_TIME 17 15699
TEST_TIME 18 15772
TEST_TIME 19 15787
TEST_TIME 20 15794
TEST_TIME 21 15788
TEST_TIME 22 15706
TEST_TIME 23 15872
TEST_TIME 24 15881
TEST_TIME 25 15892
TEST_TIME 26 15874
TEST_TIME 27 15923
TEST_TIME 28 15906
TEST_TIME 29 15961
TEST_TIME 30 15974
TEST_TIME 31 15982
TEST_TIME 32 16003
TEST_TIME 33 15964
TEST_TIME 34 16144
TEST_TIME 35 16163
TEST_TIME 36 16192
TEST_TIME 37 16319
TEST_TIME 38 16314
TEST_TIME 39 16367
TEST_TIME 40 16425
TEST_TIME 41 16492
TEST_TIME 42 16567
TEST_TIME 43 16666
TEST_TIME 44 16616
TEST_TIME 45 16651
TEST_TIME 46 16782
TEST_TIME 47 16743
TEST_TIME 48 16786
TEST_TIME 49 16833
TEST_TIME 50 16845

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-11-2026 05:51:10 to 14-11-2026 05:51:13.

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 1236667 1236667 0 0.00 0 1169 2 0 0
doc_list_biud 1236667 1236667 0 0.00 0 1561 5 0 0
sp_add_invoice_to_stock 7643 7643 0 0.00 10 11117 1538 0 0
sp_cancel_adding_invoice 5518 5518 0 0.00 2 4309 209 0 0
sp_cancel_client_order 2927 2927 0 0.00 2 922 46 0 0
sp_cancel_customer_reserve 305374 305374 0 0.00 1 1563 14 0 0
sp_cancel_pay_from_customer 1125 1125 0 0.00 2 249 18 0 0
sp_cancel_pay_to_supplier 703 703 0 0.00 2 314 16 0 0
sp_cancel_supplier_invoice 6640 6640 0 0.00 1 1029 145 0 0
sp_cancel_supplier_order 648 648 0 0.00 4 53693 9063 0 0
sp_cancel_write_off 10070 10070 0 0.00 1 810 18 0 0
sp_client_order 35285 35285 0 0.00 4 1325 43 0 0
sp_customer_reserve 405389 405389 0 0.00 0 2013 25 0 0
sp_fill_shopping_cart 53278 53278 0 0.00 1 1289 20 0 0
sp_fill_shopping_cart_clo_res 405389 405389 0 0.00 0 886 2 0 0
sp_get_clo_for_invoice 7643 7643 0 0.00 0 1516 38 0 0
sp_kill_cost_storno 17416 17416 0 0.00 0 454 9 0 0
sp_kill_qstorno_ret_qs2qd 628106 628106 0 0.00 0 1551 7 0 0
sp_kill_qty_storno 355397 355397 0 0.00 0 1560 16 0 0
sp_lock_selected_doc 33617 33617 0 0.00 0 282 2 0 0
sp_make_cost_storno 45422 45422 0 0.00 0 476 6 0 0
sp_multiply_rows_for_pdistr 45422 45422 0 0.00 0 682 9 0 0
sp_multiply_rows_for_qdistr 35285 35285 0 0.00 0 1038 17 0 0
sp_pay_from_customer 11801 11801 0 0.00 3 841 37 0 0
sp_pay_to_supplier 9401 9401 0 0.00 3 1352 29 0 0
sp_payment_common 21202 21202 0 0.00 1 822 11 0 0
sp_qd_handle_on_cancel_clo 2927 2927 0 0.00 0 892 30 0 0
sp_qd_handle_on_invoice_upd_sts 13161 13161 0 0.00 0 1431 71 0 0
sp_qd_handle_on_reserve_upd_sts 16577 16577 0 0.00 0 1045 9 0 0
sp_reserve_write_off 16577 16577 0 0.00 3 1288 33 0 0
sp_supplier_invoice 8921 8921 0 0.00 4 3760 341 0 0
sp_supplier_order 9072 9072 0 0.00 5 1685 193 0 0
srv_aggregate_perf_data 248 248 0 0.00 12 19725 2094 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1005 286 0 0
srv_find_qd_qs_mism 784517 784517 0 0.00 0 958 1 0 0
srv_make_invnt_saldo 2049 2049 0 0.00 0 72515 434 0 0
srv_make_money_saldo 2854 2854 0 0.00 0 229 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 282 6042 3162 0 0
v_add_invoice_to_stock 15286 15286 0 0.00 0 391 2 0 0
v_all_customers 54292 54292 0 0.00 0 50 1 0 0
v_all_suppliers 44310 44310 0 0.00 0 26 1 0 0
v_all_wares 70570 70570 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 1326 1326 0 0.00 0 34 2 0 0
v_cancel_client_order 5854 5854 0 0.00 0 168 1 0 0
v_cancel_customer_prepayment 2250 2250 0 0.00 0 127 1 0 0
v_cancel_customer_reserve 2270 2270 0 0.00 0 1283 2 0 0
v_cancel_payment_to_supplier 1406 1406 0 0.00 0 199 1 0 0
v_cancel_supplier_invoice 1224 1224 0 0.00 0 102 3 0 0
v_cancel_supplier_order 1296 1296 0 0.00 0 156 2 0 0
v_cancel_write_off 3168 3168 0 0.00 0 175 2 0 0
v_max_id_clo_ord 9072 9072 0 0.00 0 102 1 0 0
v_max_id_clo_res 1741 1741 0 0.00 0 304 1 0 0
v_max_id_ord_sup 8921 8921 0 0.00 0 478 2 0 0
v_max_non_paid_invoice 5239 5239 0 0.00 0 163 2 0 0
v_max_non_paid_realizn 11182 11182 0 0.00 0 182 2 0 0
v_min_id_clo_ord 9072 9072 0 0.00 0 284 3 0 0
v_min_id_clo_res 1741 1741 0 0.00 0 646 4 0 0
v_min_id_ord_sup 8921 8921 0 0.00 0 606 4 0 0
v_min_non_paid_invoice 9401 9401 0 0.00 0 461 4 0 0
v_min_non_paid_realizn 11801 11801 0 0.00 0 807 7 0 0
v_our_firm 17516 17516 0 0.00 0 28 1 0 0
v_reserve_write_off 33154 33154 0 0.00 0 1273 1 0 0
x_lock_depdocs_on_canc_invoice 11546 11546 0 0.00 0 1007 10 0 0
x_lock_depdocs_on_canc_sup_ord 648 648 0 0.00 0 171 11 0 0
x_make_qstorno_1000_1200 9072 9072 0 0.00 1 1557 137 0 0
x_make_qstorno_1200_2000 8921 8921 0 0.00 1 3691 301 0 0
x_make_qstorno_2100_3300 405389 405389 0 0.00 0 2011 21 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 14-11-2026 05:51:13 to 14-11-2026 05:51:16.

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:00:57 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:01:57 115 2147483648 2562719536 2637447168 230103344 9.678 19 13 25 0 233767120 1255968 2407808
05:02:58 240 2147483648 2578072832 2658361344 245151120 10.246 19 13 26 0 249104656 1172688 2780848
05:03:58 192 2147483648 2604987488 2690621440 271230768 11.213 20 12 25 1 274648528 885968 2531792
05:04:59 325 2147483648 2604837040 2688643072 268397184 11.109 20 17 34 0 273440688 1623232 3420272
05:05:59 319 2147483648 2597649728 2682363904 264313296 10.959 20 13 24 0 268419376 1349584 2756496
05:07:00 194 2147483648 2601743776 2686447616 266276480 11.031 20 16 30 0 271230976 1608016 3346480
05:08:00 106 2147483648 2599543776 2685714432 265008544 10.984 20 11 22 0 269580336 2176912 2394880
05:09:01 405 2147483648 2602087904 2691330048 269040576 11.133 20 8 16 0 272467472 1762272 1664624
05:10:01 953 2147483648 2594588400 2683785216 264063024 10.949 20 6 12 0 265973744 1090192 820528
05:11:03 109 2147483648 2600896768 2689138688 266706720 11.047 20 12 24 0 270655088 1480192 2468176
05:12:03 751 2147483648 2596939344 2684465152 262526736 10.893 20 11 18 1 266527328 1924880 2075712
05:13:04 330 2147483648 2603668448 2693361664 269391232 11.146 20 11 23 3 273857728 2424880 2041616
05:14:04 213 2147483648 2598340560 2685775872 263724928 10.937 20 11 22 0 267885040 1659248 2500864
05:15:05 259 2147483648 2586027184 2671558656 250921952 10.462 20 13 26 0 254929120 1665920 2341248
05:16:05 153 2147483648 2595169568 2682957824 261093824 10.840 20 13 25 0 265359248 1451264 2814160
05:17:06 124 2147483648 2601606416 2691776512 268518768 11.114 20 7 15 0 271575504 1716992 1339744
05:18:06 98 2147483648 2604166912 2692210688 268427120 11.110 20 13 25 2 273500096 2364368 2708608
05:19:08 146 2147483648 2597022064 2684481536 260649216 10.823 20 14 27 0 265660368 2382224 2628928
05:20:08 805 2147483648 2595488016 2683940864 260921936 10.833 20 12 22 0 264374688 1225360 2227392
05:21:09 248 2147483648 2598936896 2686373888 263251872 10.919 20 15 30 0 268177872 1916016 3009984
05:22:10 1003 2147483648 2591811056 2682015744 260357520 10.812 20 6 12 0 262630800 1156992 1116288
05:23:11 171 2147483648 2609779632 2697199616 271102464 11.209 20 13 26 0 277866592 4113632 2650496
05:24:11 134 2147483648 2600241568 2688610304 263387936 10.925 20 16 32 0 270415536 3697792 3329808
05:25:11 271 2147483648 2598308208 2687016960 263648288 10.934 20 11 22 0 268146496 2185952 2312256
05:26:12 262 2147483648 2596149264 2685513728 263226240 10.919 20 10 18 0 265779872 1191776 1361856
05:27:12 140 2147483648 2601118768 2688827392 262032896 10.874 20 15 30 0 268642048 3533568 3075584
05:28:13 239 2147483648 2589486832 2677411840 254537232 10.596 20 10 20 0 258486848 2132416 1817200
05:29:14 529 2147483648 2600730896 2688356352 264906032 10.981 20 14 26 0 269187952 2052064 2229856
05:30:15 208 2147483648 2600907168 2688983040 264268928 10.957 20 12 24 0 269890576 3094416 2527232
05:31:15 210 2147483648 2601455744 2690797568 266518848 11.040 20 10 20 0 269633984 1320752 1794384
05:32:16 140 2147483648 2592321872 2681118720 257716176 10.714 20 9 18 0 261636048 2076112 1843760
05:33:16 305 2147483648 2597319680 2685009920 261629216 10.859 20 14 27 0 266195360 1557168 3008976
05:34:17 265 2147483648 2593242400 2681860096 259711712 10.788 20 10 17 0 263201952 1599712 1890528
05:35:17 285 2147483648 2596566288 2686464000 264206608 10.955 20 8 16 0 266633504 1077680 1349216
05:36:18 282 2147483648 2591622944 2682150912 259763728 10.790 20 5 10 0 261882752 1112032 1006992
05:37:18 151 2147483648 2590980480 2685222912 259087616 10.765 20 4 8 0 260781696 1211248 482832
05:38:18 158 2147483648 2596834144 2686562304 262498160 10.892 20 9 18 0 265931392 1650032 1783200
05:39:19 270 2147483648 2594401616 2685616128 262468416 10.891 20 6 12 0 265040256 1520768 1051072
05:40:19 160 2147483648 2601846288 2691530752 266678320 11.046 20 11 23 0 271186032 2107280 2400432
05:41:20 233 2147483648 2586821936 2671923200 251430128 10.480 19 12 24 0 255033168 1386576 2216464
05:42:20 209 2147483648 2602584368 2694066176 268836528 11.125 20 8 16 0 272159504 1489488 1833488
05:43:20 875 2147483648 2586600704 2675027968 249909664 10.424 19 5 10 0 252753520 1742496 1101360
05:44:21 149 2147483648 2600477440 2690248704 266663472 11.045 20 14 27 0 270488080 1353728 2470880
05:45:22 181 2147483648 2591966672 2681327616 250835520 10.458 19 17 33 1 257343136 3241696 3265920
05:46:22 253 2147483648 2606730784 2694864896 266245888 11.030 20 12 24 0 275769952 6724832 2799232
05:47:22 237 2147483648 2604195136 2693255168 267738112 11.085 20 11 22 0 272109968 2000816 2371040
05:48:23 507 2147483648 2599945888 2687647744 262573888 10.894 20 14 28 0 267374256 2091456 2708912
05:49:23 103 2147483648 2600766624 2691387392 266269680 11.031 20 9 18 0 269862432 2240528 1352224
05:50:24 172 2147483648 2608585840 2698051584 270972032 11.204 20 11 22 0 277077168 3878128 2227008

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 05:51:17 to 14-11-2026 05:51:29.

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 05:51:29 to 14-11-2026 05:51:30.

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          237252
MON$OLDEST_ACTIVE               239568
MON$OLDEST_SNAPSHOT             239568
MON$NEXT_TRANSACTION            239568
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 05:00:08.8160
MON$PAGES                       147072
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 05:50:55 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Sat Nov 14 05:50:55 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'

14.11.26 05:51:31. 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 05:51:32 No severe PSQL-related problems occured
14.11.26 05:51:32. End of report.