Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 17.11.2026 17: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 3d
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 1901040 kB
MemAvailable 7278504 kB
Buffers 79628 kB
Cached 5377964 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-17 17:50:56
DTS_END                         2026-11-17 17:50:56.8100
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/59314
TRN_ID                          223371
ATT_ID                          449
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: 15057.08 939 752854
customer order: creation 662.14 48 33107
customer order: refuse 54.26 52 2713
order to supplier: creation 168.64 222 8432
order to supplier: removal 12.32 10182 616
invoice (draft): creation 167.08 381 8354
invoice (draft): removal 119.38 166 5969
invoice accept: apply 145.00 1691 7250
invoice accept: cancel 101.16 240 5058
customer reserve: creation 7268.08 28 363404
customer reserve: removal 5339.58 16 266979
realization accept: apply 308.00 41 15400
realization accept: cancel 181.44 21 9072
payment from customer: creation 219.66 35 10983
payment from customer: removal 22.10 19 1105
payment to supplier: creation 180.66 31 9033
payment to supplier: removal 12.70 21 635
service: total inventory turnovers 38.70 455 1935
service: total monetary turnovers 50.92 9 2546
service: aggregate perf. data 5.22 2178 261
service: refresh index statistics 0.04 2944 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 17-11-2026 17:51:16 to 17-11-2026 17:51:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8430
TEST_TIME 2 10046
TEST_TIME 3 10896
TEST_TIME 4 11458
TEST_TIME 5 11955
TEST_TIME 6 12327
TEST_TIME 7 12535
TEST_TIME 8 12783
TEST_TIME 9 12959
TEST_TIME 10 13002
TEST_TIME 11 13151
TEST_TIME 12 13195
TEST_TIME 13 13377
TEST_TIME 14 13294
TEST_TIME 15 13516
TEST_TIME 16 13562
TEST_TIME 17 13547
TEST_TIME 18 13621
TEST_TIME 19 13599
TEST_TIME 20 13569
TEST_TIME 21 13616
TEST_TIME 22 13609
TEST_TIME 23 13666
TEST_TIME 24 13791
TEST_TIME 25 13756
TEST_TIME 26 13794
TEST_TIME 27 13903
TEST_TIME 28 13790
TEST_TIME 29 13801
TEST_TIME 30 13807
TEST_TIME 31 13880
TEST_TIME 32 13945
TEST_TIME 33 14120
TEST_TIME 34 14199
TEST_TIME 35 14313
TEST_TIME 36 14396
TEST_TIME 37 14408
TEST_TIME 38 14465
TEST_TIME 39 14549
TEST_TIME 40 14610
TEST_TIME 41 14626
TEST_TIME 42 14750
TEST_TIME 43 14740
TEST_TIME 44 14813
TEST_TIME 45 14876
TEST_TIME 46 14872
TEST_TIME 47 14965
TEST_TIME 48 14971
TEST_TIME 49 15052
TEST_TIME 50 15057

Performance per minute, chart


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

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 1109111 1109111 0 0.00 0 890 2 0 0
doc_list_biud 1109111 1109111 0 0.00 0 1544 6 0 0
sp_add_invoice_to_stock 7250 7250 0 0.00 8 11916 1691 0 0
sp_cancel_adding_invoice 5058 5058 0 0.00 4 7006 240 0 0
sp_cancel_client_order 2713 2713 0 0.00 3 826 52 0 0
sp_cancel_customer_reserve 266979 266979 0 0.00 1 1545 17 0 0
sp_cancel_pay_from_customer 1105 1105 0 0.00 2 167 20 0 0
sp_cancel_pay_to_supplier 635 635 0 0.00 2 296 21 0 0
sp_cancel_supplier_invoice 5969 5969 0 0.00 1 1060 166 0 0
sp_cancel_supplier_order 616 616 0 0.00 10 81199 10182 0 0
sp_cancel_write_off 9072 9072 0 0.00 1 693 22 0 0
sp_client_order 33107 33107 0 0.00 4 1000 49 0 0
sp_customer_reserve 363404 363404 0 0.00 0 2141 29 0 0
sp_fill_shopping_cart 49893 49893 0 0.00 1 1286 24 0 0
sp_fill_shopping_cart_clo_res 363404 363404 0 0.00 0 1207 2 0 0
sp_get_clo_for_invoice 7250 7250 0 0.00 0 1086 42 0 0
sp_kill_cost_storno 15870 15870 0 0.00 0 777 10 0 0
sp_kill_qstorno_ret_qs2qd 549615 549615 0 0.00 0 1535 8 0 0
sp_kill_qty_storno 313057 313057 0 0.00 0 1544 19 0 0
sp_lock_selected_doc 31354 31354 0 0.00 0 264 2 0 0
sp_make_cost_storno 42666 42666 0 0.00 0 852 8 0 0
sp_multiply_rows_for_pdistr 42666 42666 0 0.00 0 868 10 0 0
sp_multiply_rows_for_qdistr 33107 33107 0 0.00 0 810 19 0 0
sp_pay_from_customer 10983 10983 0 0.00 3 815 35 0 0
sp_pay_to_supplier 9033 9033 0 0.00 3 877 32 0 0
sp_payment_common 20016 20016 0 0.00 1 487 8 0 0
sp_qd_handle_on_cancel_clo 2713 2713 0 0.00 0 807 34 0 0
sp_qd_handle_on_invoice_upd_sts 12308 12308 0 0.00 0 1370 81 0 0
sp_qd_handle_on_reserve_upd_sts 15400 15400 0 0.00 0 1073 11 0 0
sp_reserve_write_off 15400 15400 0 0.00 4 1089 42 0 0
sp_supplier_invoice 8354 8354 0 0.00 6 4280 381 0 0
sp_supplier_order 8432 8432 0 0.00 7 1680 223 0 0
srv_aggregate_perf_data 261 261 0 0.00 27 29932 2179 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1153 254 0 0
srv_find_qd_qs_mism 700206 700206 0 0.00 0 826 1 0 0
srv_make_invnt_saldo 1935 1935 0 0.00 1 55813 455 0 0
srv_make_money_saldo 2546 2546 0 0.00 0 347 10 0 0
srv_recalc_idx_stat 2 2 0 0.00 548 5340 2944 0 0
v_add_invoice_to_stock 14500 14500 0 0.00 0 261 3 0 0
v_all_customers 50870 50870 0 0.00 0 35 1 0 0
v_all_suppliers 41244 41244 0 0.00 0 30 1 0 0
v_all_wares 66214 66214 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 1236 1236 0 0.00 0 72 2 0 0
v_cancel_client_order 5426 5426 0 0.00 0 148 1 0 0
v_cancel_customer_prepayment 2210 2210 0 0.00 0 144 1 0 0
v_cancel_customer_reserve 1988 1988 0 0.00 0 100 2 0 0
v_cancel_payment_to_supplier 1270 1270 0 0.00 0 293 2 0 0
v_cancel_supplier_invoice 1124 1124 0 0.00 0 137 3 0 0
v_cancel_supplier_order 1232 1232 0 0.00 0 159 2 0 0
v_cancel_write_off 2922 2922 0 0.00 0 67 2 0 0
v_max_id_clo_ord 8432 8432 0 0.00 0 36 2 0 0
v_max_id_clo_res 1505 1505 0 0.00 0 104 1 0 0
v_max_id_ord_sup 8354 8354 0 0.00 0 466 2 0 0
v_max_non_paid_invoice 5197 5197 0 0.00 0 38 2 0 0
v_max_non_paid_realizn 10498 10498 0 0.00 0 106 2 0 0
v_min_id_clo_ord 8432 8432 0 0.00 0 175 3 0 0
v_min_id_clo_res 1505 1505 0 0.00 0 928 5 0 0
v_min_id_ord_sup 8354 8354 0 0.00 0 813 4 0 0
v_min_non_paid_invoice 9033 9033 0 0.00 0 315 3 0 0
v_min_non_paid_realizn 10983 10983 0 0.00 0 480 2 0 0
v_our_firm 16314 16314 0 0.00 0 28 1 0 0
v_reserve_write_off 30800 30800 0 0.00 0 547 2 0 0
x_lock_depdocs_on_canc_invoice 10465 10465 0 0.00 0 603 11 0 0
x_lock_depdocs_on_canc_sup_ord 616 616 0 0.00 0 151 13 0 0
x_make_qstorno_1000_1200 8432 8432 0 0.00 1 1453 157 0 0
x_make_qstorno_1200_2000 8354 8354 0 0.00 1 3984 331 0 0
x_make_qstorno_2100_3300 363404 363404 0 0.00 0 2139 24 0 0

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

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
17:01:00 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:00 243 2147483648 2550018928 2621763584 218070800 9.218 20 15 24 0 220569104 573616 1924688
17:03:01 240 2147483648 2605032720 2690404352 272447216 11.258 20 9 18 1 276034848 1065824 2521808
17:04:01 380 2147483648 2600097904 2687258624 269126112 11.136 20 7 14 1 271047872 773184 1148576
17:05:02 191 2147483648 2592585536 2676973568 259752480 10.790 20 15 29 0 263631472 1138336 2740656
17:06:02 242 2147483648 2587506368 2673168384 255310064 10.625 20 10 20 0 258682672 1229728 2142880
17:07:03 166 2147483648 2600615008 2687860736 267305808 11.069 20 16 30 0 271752480 1318320 3128352
17:08:03 136 2147483648 2596544672 2684919808 264185136 10.954 20 7 14 0 266710592 1146992 1378464
17:09:04 449 2147483648 2596975024 2684727296 264526256 10.967 20 7 14 0 267353264 1595120 1231888
17:10:04 840 2147483648 2587209200 2672152576 253320928 10.551 19 12 24 0 257059184 1539664 2198592
17:11:05 117 2147483648 2600119728 2687004672 266371168 11.035 20 14 27 0 270436656 1912832 2152656
17:12:06 132 2147483648 2601511200 2690756608 268405456 11.110 20 12 24 0 272516592 1506256 2604880
17:13:07 236 2147483648 2600320576 2688593920 267002528 11.058 20 12 23 0 270840720 1217040 2621152
17:14:07 266 2147483648 2594218192 2680889344 260480512 10.817 20 10 18 0 263599296 1346656 1772128
17:15:08 212 2147483648 2606110880 2693566464 270088128 11.171 20 12 24 1 275534944 3248528 2198288
17:16:08 165 2147483648 2607091408 2694598656 270408368 11.183 20 16 31 0 275473264 2079072 2985824
17:17:09 242 2147483648 2600386976 2689196032 266831904 11.052 20 12 24 0 270752992 1571040 2350048
17:18:09 164 2147483648 2604159232 2693140480 268703616 11.120 20 14 27 0 273764016 1892576 3167824
17:19:10 174 2147483648 2601625008 2689126400 267098464 11.061 20 14 26 0 272189792 1768432 3322896
17:20:11 398 2147483648 2597742512 2685620224 262273200 10.883 20 11 22 0 266962944 2409104 2280640
17:21:11 172 2147483648 2599345552 2684780544 263360672 10.924 20 17 33 0 268953600 1891312 3701616
17:22:12 186 2147483648 2602136576 2689568768 266751552 11.049 20 15 30 0 271967552 2059568 3156432
17:23:12 164 2147483648 2587456432 2674819072 252290496 10.513 20 10 16 0 257377344 3282160 1804688
17:24:13 127 2147483648 2602201360 2688745472 264538464 10.967 20 14 29 0 271203024 3354848 3309712
17:25:13 117 2147483648 2605169872 2694234112 270080912 11.171 20 10 20 0 274415632 2194880 2139840
17:26:14 170 2147483648 2607123376 2695380992 270977104 11.204 20 15 30 0 276690320 2767808 2945408
17:27:14 150 2147483648 2596288688 2683215872 261102624 10.840 20 15 30 0 265745232 1978368 2664240
17:28:14 481 2147483648 2599798544 2689703936 266957280 11.056 20 11 21 0 269429760 855536 1616944
17:29:15 256 2147483648 2604218592 2692661248 267654160 11.082 20 12 24 0 273384752 3261824 2468768
17:30:15 134 2147483648 2603852208 2693246976 269235856 11.140 20 10 21 0 273364560 2064912 2063792
17:31:16 107 2147483648 2606376864 2694152192 269209408 11.139 20 12 24 0 275758688 4009152 2540128
17:32:16 130 2147483648 2606517888 2695630848 270899744 11.201 20 7 14 0 275767648 3097008 1770896
17:33:16 125 2147483648 2603272848 2692866048 267554592 11.078 20 11 22 0 272229712 2880464 1794656
17:34:17 433 2147483648 2598577312 2688008192 263300048 10.921 20 13 26 0 267826928 2206048 2320832
17:35:17 1153 2147483648 2598543664 2685796352 262197616 10.881 20 14 28 0 266596704 1778640 2620448
17:36:19 257 2147483648 2598747904 2687254528 263094000 10.914 20 12 24 0 267313168 1732736 2486432
17:37:19 360 2147483648 2602877808 2696302592 270785424 11.197 20 5 10 0 272708464 1239248 683792
17:38:20 121 2147483648 2595086768 2681872384 257704896 10.714 20 17 34 0 262739296 2038032 2996368
17:39:20 175 2147483648 2604493312 2695139328 267590944 11.080 20 15 30 0 273978944 3307680 3080320
17:40:20 127 2147483648 2595494736 2682683392 260254768 10.809 20 15 28 1 265394112 1836080 3303264
17:41:21 234 2147483648 2593930032 2681974784 258692032 10.751 20 11 22 0 262417232 1756336 1968864
17:42:21 167 2147483648 2606491088 2697506816 270759312 11.196 20 10 20 0 275159552 2248608 2151632
17:43:21 147 2147483648 2602341440 2692182016 266918656 11.055 20 14 27 0 270487888 1478272 2090960
17:44:22 279 2147483648 2592463152 2680913920 258146912 10.730 20 10 20 0 262267152 1749376 2370864
17:45:22 117 2147483648 2601428016 2689785856 264865584 10.979 20 12 24 0 269341040 2140336 2335120
17:46:23 152 2147483648 2598849872 2687631360 262438688 10.889 20 15 30 0 267124112 1551280 3134144
17:47:23 190 2147483648 2592585120 2679939072 257064496 10.690 20 13 26 1 261904784 1896144 2944144
17:48:23 176 2147483648 2584389056 2670485504 248686880 10.378 19 11 22 0 253401232 2470064 2244288
17:49:24 884 2147483648 2598907216 2688176128 262316080 10.885 20 8 16 0 267418592 3378320 1724192
17:50:25 196 2147483648 2595776576 2682490880 258333824 10.737 20 15 28 0 264095184 2802624 2958736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 17-11-2026 17:51:25 to 17-11-2026 17:51:37.

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 17-11-2026 17:51:38 to 17-11-2026 17:51:39.

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          222785
MON$OLDEST_ACTIVE               223843
MON$OLDEST_SNAPSHOT             223843
MON$NEXT_TRANSACTION            223843
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-17 17:00:09.3050
MON$PAGES                       146240
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    Tue Nov 17 17:50:58 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Tue Nov 17 17:50:59 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'

17.11.26 17:51:39. 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-17 17:51:41 No severe PSQL-related problems occured
17.11.26 17:51:41. End of report.