Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.11.2026 11: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 6d
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 1901144 kB
MemAvailable 7380664 kB
Buffers 89736 kB
Cached 5475728 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-06 11:51:07
DTS_END                         2026-11-06 11:51:07.9930
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/57074
TRN_ID                          197777
ATT_ID                          424
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: 12114.06 902 605703
customer order: creation 588.68 52 29434
customer order: refuse 46.52 34 2326
order to supplier: creation 150.12 224 7506
order to supplier: removal 11.32 8545 566
invoice (draft): creation 150.00 360 7500
invoice (draft): removal 105.04 144 5252
invoice accept: apply 125.62 1682 6281
invoice accept: cancel 83.88 220 4194
customer reserve: creation 5760.58 31 288029
customer reserve: removal 4200.52 16 210026
realization accept: apply 272.10 39 13605
realization accept: cancel 150.22 21 7511
payment from customer: creation 194.08 35 9704
payment from customer: removal 18.80 21 940
payment to supplier: creation 159.20 32 7960
payment to supplier: removal 11.48 20 574
service: total inventory turnovers 34.46 508 1723
service: total monetary turnovers 46.36 7 2318
service: aggregate perf. data 5.04 1328 252
service: refresh index statistics 0.04 4726 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-11-2026 11:51:24 to 06-11-2026 11:51:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 12435
TEST_TIME 2 10750
TEST_TIME 3 10210
TEST_TIME 4 10174
TEST_TIME 5 10148
TEST_TIME 6 10258
TEST_TIME 7 10441
TEST_TIME 8 10536
TEST_TIME 9 10528
TEST_TIME 10 10681
TEST_TIME 11 10695
TEST_TIME 12 10847
TEST_TIME 13 10875
TEST_TIME 14 10843
TEST_TIME 15 10871
TEST_TIME 16 10867
TEST_TIME 17 11012
TEST_TIME 18 11139
TEST_TIME 19 11125
TEST_TIME 20 11238
TEST_TIME 21 11331
TEST_TIME 22 11332
TEST_TIME 23 11426
TEST_TIME 24 11426
TEST_TIME 25 11480
TEST_TIME 26 11551
TEST_TIME 27 11544
TEST_TIME 28 11602
TEST_TIME 29 11561
TEST_TIME 30 11645
TEST_TIME 31 11606
TEST_TIME 32 11680
TEST_TIME 33 11833
TEST_TIME 34 11811
TEST_TIME 35 11887
TEST_TIME 36 11982
TEST_TIME 37 11994
TEST_TIME 38 11947
TEST_TIME 39 11990
TEST_TIME 40 12040
TEST_TIME 41 12054
TEST_TIME 42 12076
TEST_TIME 43 12117
TEST_TIME 44 12190
TEST_TIME 45 12173
TEST_TIME 46 12218
TEST_TIME 47 12295
TEST_TIME 48 12305
TEST_TIME 49 12307
TEST_TIME 50 12114

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 06-11-2026 11:51:27 to 06-11-2026 11:51:29.

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 894281 894281 0 0.00 0 1582 2 0 0
doc_list_biud 894281 894281 0 0.00 0 2020 6 0 0
sp_add_invoice_to_stock 6281 6281 0 0.00 8 11806 1683 0 0
sp_cancel_adding_invoice 4194 4194 0 0.00 4 4447 221 0 0
sp_cancel_client_order 2326 2326 0 0.00 3 577 34 0 0
sp_cancel_customer_reserve 210026 210026 0 0.00 1 2022 17 0 0
sp_cancel_pay_from_customer 940 940 0 0.00 2 307 21 0 0
sp_cancel_pay_to_supplier 574 574 0 0.00 2 413 21 0 0
sp_cancel_supplier_invoice 5252 5252 0 0.00 2 1824 145 0 0
sp_cancel_supplier_order 566 566 0 0.00 4 58254 8546 0 0
sp_cancel_write_off 7511 7511 0 0.00 1 830 21 0 0
sp_client_order 29434 29434 0 0.00 4 1740 53 0 0
sp_customer_reserve 288029 288029 0 0.00 0 2648 32 0 0
sp_fill_shopping_cart 44440 44440 0 0.00 1 1435 21 0 0
sp_fill_shopping_cart_clo_res 288029 288029 0 0.00 0 1362 3 0 0
sp_get_clo_for_invoice 6281 6281 0 0.00 0 1348 38 0 0
sp_kill_cost_storno 13219 13219 0 0.00 0 532 10 0 0
sp_kill_qstorno_ret_qs2qd 433381 433381 0 0.00 0 2008 8 0 0
sp_kill_qty_storno 249761 249761 0 0.00 0 2019 19 0 0
sp_lock_selected_doc 27587 27587 0 0.00 0 392 2 0 0
sp_make_cost_storno 37550 37550 0 0.00 0 1579 7 0 0
sp_multiply_rows_for_pdistr 37550 37550 0 0.00 0 688 11 0 0
sp_multiply_rows_for_qdistr 29434 29434 0 0.00 0 1402 21 0 0
sp_pay_from_customer 9704 9704 0 0.00 3 942 36 0 0
sp_pay_to_supplier 7960 7960 0 0.00 3 945 32 0 0
sp_payment_common 17664 17664 0 0.00 1 405 8 0 0
sp_qd_handle_on_cancel_clo 2326 2326 0 0.00 0 551 21 0 0
sp_qd_handle_on_invoice_upd_sts 10475 10475 0 0.00 0 1938 72 0 0
sp_qd_handle_on_reserve_upd_sts 13605 13605 0 0.00 0 1313 12 0 0
sp_reserve_write_off 13605 13605 0 0.00 3 1338 39 0 0
sp_supplier_invoice 7500 7500 0 0.00 5 3596 361 0 0
sp_supplier_order 7506 7506 0 0.00 5 2999 225 0 0
srv_aggregate_perf_data 252 252 0 0.00 19 7271 1329 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1727 406 0 0
srv_find_qd_qs_mism 562432 562432 0 0.00 0 969 2 0 0
srv_make_invnt_saldo 1723 1723 0 0.00 1 57027 508 0 0
srv_make_money_saldo 2318 2318 0 0.00 0 237 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 382 9071 4727 0 0
v_add_invoice_to_stock 12562 12562 0 0.00 0 412 3 0 0
v_all_customers 44978 44978 0 0.00 0 58 1 0 0
v_all_suppliers 36466 36466 0 0.00 0 42 1 0 0
v_all_wares 58868 58868 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 1038 1038 0 0.00 0 437 3 0 0
v_cancel_client_order 4652 4652 0 0.00 0 429 2 0 0
v_cancel_customer_prepayment 1880 1880 0 0.00 0 226 2 0 0
v_cancel_customer_reserve 1854 1854 0 0.00 0 342 2 0 0
v_cancel_payment_to_supplier 1148 1148 0 0.00 0 248 2 0 0
v_cancel_supplier_invoice 1048 1048 0 0.00 0 435 3 0 0
v_cancel_supplier_order 1132 1132 0 0.00 0 157 2 0 0
v_cancel_write_off 2650 2650 0 0.00 0 239 2 0 0
v_max_id_clo_ord 7506 7506 0 0.00 0 160 1 0 0
v_max_id_clo_res 1360 1360 0 0.00 0 244 2 0 0
v_max_id_ord_sup 7500 7500 0 0.00 0 795 2 0 0
v_max_non_paid_invoice 4733 4733 0 0.00 0 74 2 0 0
v_max_non_paid_realizn 9345 9345 0 0.00 0 159 2 0 0
v_min_id_clo_ord 7506 7506 0 0.00 0 345 3 0 0
v_min_id_clo_res 1360 1360 0 0.00 0 355 5 0 0
v_min_id_ord_sup 7500 7500 0 0.00 0 753 7 0 0
v_min_non_paid_invoice 7960 7960 0 0.00 0 312 3 0 0
v_min_non_paid_realizn 9704 9704 0 0.00 0 199 2 0 0
v_our_firm 14608 14608 0 0.00 0 62 1 0 0
v_reserve_write_off 27210 27210 0 0.00 0 514 2 0 0
x_lock_depdocs_on_canc_invoice 8922 8922 0 0.00 0 897 10 0 0
x_lock_depdocs_on_canc_sup_ord 566 566 0 0.00 0 184 10 0 0
x_make_qstorno_1000_1200 7506 7506 0 0.00 1 2957 170 0 0
x_make_qstorno_1200_2000 7500 7500 0 0.00 2 3576 312 0 0
x_make_qstorno_2100_3300 288029 288029 0 0.00 0 2646 27 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2026 11:51:30 to 06-11-2026 11:51:34.

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
11:01:13 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:13 687 2147483648 2604559040 2689740800 271513360 11.224 20 12 21 1 275191904 1055184 2623360
11:03:14 243 2147483648 2596454896 2680578048 265196272 10.991 20 10 20 0 267283584 710064 1377248
11:04:15 453 2147483648 2581780432 2665586688 250525408 10.447 20 11 18 1 253476736 1027248 1924080
11:05:15 362 2147483648 2600167984 2687197184 268740096 11.122 20 8 15 0 271242480 962272 1540112
11:06:16 307 2147483648 2577646512 2662223872 247143664 10.320 20 6 12 0 248664384 708800 811920
11:07:17 336 2147483648 2601810880 2689167360 269751952 11.159 20 8 16 0 272872144 1495696 1624496
11:08:18 210 2147483648 2596664560 2682306560 260085872 10.802 20 12 24 0 267969712 4983600 2900240
11:09:18 309 2147483648 2601465152 2689826816 269226448 11.140 20 11 21 0 272533552 1513968 1793136
11:10:19 173 2147483648 2591849360 2679398400 260286480 10.810 20 9 15 2 263144032 728112 2129440
11:11:19 445 2147483648 2599570672 2686685184 265947616 11.019 20 14 27 0 269760192 1340912 2471664
11:12:20 213 2147483648 2598751456 2686697472 264245424 10.956 20 11 22 0 267805648 1704736 1855488
11:13:20 1687 2147483648 2595860880 2681446400 261625120 10.859 20 10 21 0 265026912 1318240 2083552
11:14:22 241 2147483648 2592427744 2681307136 260731120 10.826 20 7 14 0 263430960 1272656 1427184
11:15:23 545 2147483648 2604111792 2694225920 270449696 11.185 20 8 14 1 273226848 1251792 1525360
11:16:24 106 2147483648 2601010912 2688139264 265588784 11.006 20 12 24 0 270444864 2440672 2415408
11:17:24 155 2147483648 2596462480 2684260352 264057024 10.949 20 12 24 0 267331056 848752 2425280
11:18:24 261 2147483648 2598936336 2690015232 266683104 11.046 20 8 14 0 269769616 1540384 1546128
11:19:25 144 2147483648 2591707600 2677710848 257461792 10.705 20 11 22 0 261244144 1782304 2000048
11:20:25 341 2147483648 2601190080 2691346432 268375168 11.108 20 7 14 0 270705968 1147856 1182944
11:21:26 164 2147483648 2602912800 2690498560 267436896 11.074 20 11 22 0 271904864 2287616 2180352
11:22:26 285 2147483648 2601943440 2689318912 267443600 11.074 20 14 28 0 272182208 1870880 2867728
11:23:27 183 2147483648 2598475552 2686763008 264331728 10.959 20 8 16 0 267186416 1132912 1721776
11:24:27 329 2147483648 2600986000 2689372160 265235760 10.993 20 7 12 0 269479040 2952752 1290528
11:25:28 1716 2147483648 2599306784 2688057344 266219424 11.029 20 12 23 0 269884896 1102384 2563088
11:26:30 154 2147483648 2599132384 2686963712 263565168 10.931 20 10 20 0 268292720 2666848 2060704
11:27:30 642 2147483648 2601710752 2690625536 265484832 11.002 20 11 22 1 271670224 4249504 1935888
11:28:31 219 2147483648 2597252688 2684674048 262586320 10.895 20 11 22 0 266419776 1832384 2001072
11:29:32 414 2147483648 2595660000 2685374464 262798096 10.903 20 9 18 0 266195600 1244592 2152912
11:30:32 195 2147483648 2589203840 2676473856 255693040 10.639 20 10 19 0 258966208 1252720 2020448
11:31:33 129 2147483648 2603336960 2689781760 265786448 11.013 20 14 28 0 271867472 3048384 3032640
11:32:33 194 2147483648 2598498768 2686541824 263935696 10.945 20 13 23 0 267968448 1551712 2481040
11:33:34 171 2147483648 2586905616 2675941376 254564928 10.597 20 5 10 0 256847536 1206160 1076448
11:34:34 793 2147483648 2601916544 2690760704 265668112 11.009 20 12 23 0 270346592 2493824 2184656
11:35:36 184 2147483648 2602454896 2689646592 265947296 11.019 20 15 28 0 271090064 2346624 2796144
11:36:37 689 2147483648 2596163648 2685505536 262633632 10.897 20 9 18 0 266320736 1545632 2141472
11:37:38 1249 2147483648 2600298880 2691444736 268447408 11.111 20 9 18 0 271667872 1444752 1775712
11:38:39 317 2147483648 2601901168 2689908736 265008768 10.984 20 15 30 1 270561936 2732624 2820544
11:39:40 107 2147483648 2599194112 2690465792 266826272 11.051 20 5 8 0 268643392 1202048 615072
11:40:40 133 2147483648 2591677904 2679463936 257701776 10.714 20 10 21 0 260881488 1075888 2103824
11:41:41 129 2147483648 2598645216 2686021632 262841904 10.904 20 12 24 0 267880048 2880304 2157840
11:42:41 242 2147483648 2591763392 2679918592 258090592 10.728 20 10 21 0 261940896 1325680 2524624
11:43:42 262 2147483648 2589309456 2678923264 257538784 10.708 20 6 12 0 260699312 1538976 1621552
11:44:42 202 2147483648 2596964864 2684968960 262139760 10.878 20 11 20 0 266350288 1783184 2427344
11:45:43 695 2147483648 2603449168 2692661248 267290720 11.068 20 12 24 0 271661680 2109248 2261712
11:46:44 122 2147483648 2594251568 2683416576 260009184 10.799 20 10 18 0 263835312 1636208 2189920
11:47:46 1105 2147483648 2594420144 2681896960 252943456 10.537 19 9 18 0 256023744 1602944 1477344
11:48:47 591 2147483648 2598184848 2688307200 264202288 10.955 20 8 16 0 267983552 2025856 1755408
11:49:48 252 2147483648 2602327136 2689769472 265359856 10.997 20 14 28 0 271078720 3011088 2707776
11:50:48 1021 2147483648 2603182880 2694230016 268216512 11.103 20 7 14 0 272510800 2533984 1760304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 06-11-2026 11:51:35 to 06-11-2026 11:51:50.

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 06-11-2026 11:51:50 to 06-11-2026 11:51:51.

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          197754
MON$OLDEST_ACTIVE               198486
MON$OLDEST_SNAPSHOT             198486
MON$NEXT_TRANSACTION            198486
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-06 11:00:10.2230
MON$PAGES                       125280
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    Fri Nov  6 11:51:09 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
--- end of diff output ---

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

06.11.26 11:51:52. 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-06 11:51:53 No severe PSQL-related problems occured
06.11.26 11:51:54. End of report.