Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.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 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 5d
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 1654768 kB
MemAvailable 7263712 kB
Buffers 89460 kB
Cached 5605364 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-05 17:51:09
DTS_END                         2026-11-05 17:51:09.2830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(35:5) ==> SP_ADD_INVOICE_TO_STOCK(241:26) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/48744
TRN_ID                          187663
ATT_ID                          394
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: 11490.76 1336 574538
customer order: creation 553.66 57 27683
customer order: refuse 45.52 52 2276
order to supplier: creation 142.28 236 7114
order to supplier: removal 10.86 8388 543
invoice (draft): creation 142.82 372 7141
invoice (draft): removal 99.18 123 4959
invoice accept: apply 121.76 1745 6088
invoice accept: cancel 80.90 230 4045
customer reserve: creation 5507.00 33 275350
customer reserve: removal 3954.80 17 197740
realization accept: apply 257.70 43 12885
realization accept: cancel 134.68 22 6734
payment from customer: creation 182.02 38 9101
payment from customer: removal 17.72 21 886
payment to supplier: creation 151.92 34 7596
payment to supplier: removal 10.50 19 525
service: total inventory turnovers 30.74 571 1537
service: total monetary turnovers 42.12 8 2106
service: aggregate perf. data 4.54 1714 227
service: refresh index statistics 0.04 13005 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2026 17:51:23 to 05-11-2026 17:51:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8017
TEST_TIME 2 7464
TEST_TIME 3 8482
TEST_TIME 4 8890
TEST_TIME 5 9191
TEST_TIME 6 9532
TEST_TIME 7 9688
TEST_TIME 8 9897
TEST_TIME 9 10100
TEST_TIME 10 10216
TEST_TIME 11 10453
TEST_TIME 12 10548
TEST_TIME 13 10736
TEST_TIME 14 10589
TEST_TIME 15 10692
TEST_TIME 16 10726
TEST_TIME 17 10764
TEST_TIME 18 10790
TEST_TIME 19 10861
TEST_TIME 20 10922
TEST_TIME 21 10893
TEST_TIME 22 10950
TEST_TIME 23 10953
TEST_TIME 24 10928
TEST_TIME 25 11031
TEST_TIME 26 11025
TEST_TIME 27 11022
TEST_TIME 28 11024
TEST_TIME 29 10937
TEST_TIME 30 10910
TEST_TIME 31 10958
TEST_TIME 32 11009
TEST_TIME 33 11069
TEST_TIME 34 11074
TEST_TIME 35 11201
TEST_TIME 36 11220
TEST_TIME 37 11343
TEST_TIME 38 11326
TEST_TIME 39 11392
TEST_TIME 40 11391
TEST_TIME 41 11385
TEST_TIME 42 11395
TEST_TIME 43 11439
TEST_TIME 44 11512
TEST_TIME 45 11544
TEST_TIME 46 11622
TEST_TIME 47 11569
TEST_TIME 48 11638
TEST_TIME 49 11693
TEST_TIME 50 11491

Performance per minute, chart


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

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 849046 849046 0 0.00 0 2329 3 0 0
doc_list_biud 849046 849046 0 0.00 0 2440 6 0 0
sp_add_invoice_to_stock 6088 6088 0 0.00 8 24523 1746 0 0
sp_cancel_adding_invoice 4045 4045 0 0.00 2 5431 231 0 0
sp_cancel_client_order 2276 2276 0 0.00 3 1294 53 0 0
sp_cancel_customer_reserve 197740 197740 0 0.00 1 2445 17 0 0
sp_cancel_pay_from_customer 886 886 0 0.00 2 751 21 0 0
sp_cancel_pay_to_supplier 525 525 0 0.00 2 218 19 0 0
sp_cancel_supplier_invoice 4959 4959 0 0.00 1 2323 123 0 0
sp_cancel_supplier_order 543 543 0 0.00 9 64706 8388 0 0
sp_cancel_write_off 6734 6734 0 0.00 1 785 23 0 0
sp_client_order 27683 27683 0 0.00 3 2825 57 0 0
sp_customer_reserve 275350 275350 0 0.00 0 5842 33 0 0
sp_fill_shopping_cart 41938 41938 0 0.00 1 1413 23 0 0
sp_fill_shopping_cart_clo_res 275350 275350 0 0.00 0 1282 3 0 0
sp_get_clo_for_invoice 6088 6088 0 0.00 0 995 36 0 0
sp_kill_cost_storno 12190 12190 0 0.00 0 747 10 0 0
sp_kill_qstorno_ret_qs2qd 407716 407716 0 0.00 0 2364 8 0 0
sp_kill_qty_storno 235270 235270 0 0.00 0 2440 19 0 0
sp_lock_selected_doc 26402 26402 0 0.00 0 483 2 0 0
sp_make_cost_storno 35670 35670 0 0.00 0 590 7 0 0
sp_multiply_rows_for_pdistr 35670 35670 0 0.00 0 1132 12 0 0
sp_multiply_rows_for_qdistr 27683 27683 0 0.00 0 2443 22 0 0
sp_pay_from_customer 9101 9101 0 0.00 3 1577 38 0 0
sp_pay_to_supplier 7596 7596 0 0.00 3 675 34 0 0
sp_payment_common 16697 16697 0 0.00 1 635 8 0 0
sp_qd_handle_on_cancel_clo 2276 2276 0 0.00 0 1273 35 0 0
sp_qd_handle_on_invoice_upd_sts 10133 10133 0 0.00 0 2346 74 0 0
sp_qd_handle_on_reserve_upd_sts 12885 12885 0 0.00 0 1232 13 0 0
sp_reserve_write_off 12885 12885 0 0.00 3 1244 43 0 0
sp_supplier_invoice 7141 7141 0 0.00 6 3830 373 0 0
sp_supplier_order 7114 7114 0 0.00 5 3465 237 0 0
srv_aggregate_perf_data 227 227 0 0.00 37 23942 1714 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1590 331 0 0
srv_find_qd_qs_mism 533104 533104 0 0.00 0 2329 2 0 0
srv_make_invnt_saldo 1537 1537 0 0.00 1 71600 572 0 0
srv_make_money_saldo 2106 2106 0 0.00 0 278 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 986 25025 13006 0 0
v_add_invoice_to_stock 12176 12176 0 0.00 0 369 3 0 0
v_all_customers 42140 42140 0 0.00 0 83 1 0 0
v_all_suppliers 34566 34566 0 0.00 0 96 1 0 0
v_all_wares 55366 55366 0 0.00 0 136 1 0 0
v_cancel_adding_invoice 1110 1110 0 0.00 0 152 2 0 0
v_cancel_client_order 4552 4552 0 0.00 0 299 2 0 0
v_cancel_customer_prepayment 1772 1772 0 0.00 0 89 1 0 0
v_cancel_customer_reserve 1726 1726 0 0.00 0 204 2 0 0
v_cancel_payment_to_supplier 1050 1050 0 0.00 0 112 2 0 0
v_cancel_supplier_invoice 974 974 0 0.00 0 98 3 0 0
v_cancel_supplier_order 1086 1086 0 0.00 0 171 2 0 0
v_cancel_write_off 2588 2588 0 0.00 0 394 2 0 0
v_max_id_clo_ord 7114 7114 0 0.00 0 59 2 0 0
v_max_id_clo_res 1244 1244 0 0.00 0 63 2 0 0
v_max_id_ord_sup 7141 7141 0 0.00 0 620 2 0 0
v_max_non_paid_invoice 4568 4568 0 0.00 0 60 2 0 0
v_max_non_paid_realizn 8827 8827 0 0.00 0 466 2 0 0
v_min_id_clo_ord 7114 7114 0 0.00 0 907 4 0 0
v_min_id_clo_res 1244 1244 0 0.00 0 416 5 0 0
v_min_id_ord_sup 7141 7141 0 0.00 0 1156 8 0 0
v_min_non_paid_invoice 7596 7596 0 0.00 0 456 3 0 0
v_min_non_paid_realizn 9101 9101 0 0.00 0 478 3 0 0
v_our_firm 13774 13774 0 0.00 0 181 1 0 0
v_reserve_write_off 25770 25770 0 0.00 0 800 2 0 0
x_lock_depdocs_on_canc_invoice 8517 8517 0 0.00 0 1912 9 0 0
x_lock_depdocs_on_canc_sup_ord 543 543 0 0.00 0 214 9 0 0
x_make_qstorno_1000_1200 7114 7114 0 0.00 1 3323 175 0 0
x_make_qstorno_1200_2000 7141 7141 0 0.00 2 3808 320 0 0
x_make_qstorno_2100_3300 275350 275350 0 0.00 0 5316 28 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 05-11-2026 17:51:28 to 05-11-2026 17:51:33.

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:14 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:14 182 2147483648 2602690832 2688507904 270997968 11.205 20 8 16 0 273429344 843376 1588000
17:03:15 269 2147483648 2554519872 2629451776 223424912 9.423 19 7 14 0 225638480 636048 1577520
17:04:16 258 2147483648 2601434624 2687336448 269092208 11.135 20 10 22 0 272117152 762272 2262672
17:05:17 235 2147483648 2593890528 2677899264 261778096 10.865 20 10 21 0 265066784 1023264 2265424
17:06:17 514 2147483648 2591662752 2674700288 257065760 10.690 20 15 28 0 260906624 1221136 2619728
17:07:18 141 2147483648 2597377040 2681585664 263518736 10.929 20 12 24 0 267764784 1616704 2629344
17:08:18 170 2147483648 2580456512 2666156032 249889184 10.423 19 5 10 0 251641408 871632 880592
17:09:19 250 2147483648 2590113616 2678284288 259531632 10.782 20 5 10 0 261048192 660944 855616
17:10:19 290 2147483648 2600996880 2688905216 268160608 11.100 20 8 15 1 270538192 1108464 1269120
17:11:20 131 2147483648 2596447984 2684715008 264486464 10.965 20 7 14 0 266772384 1253584 1032336
17:12:20 208 2147483648 2600748096 2686955520 265816848 11.014 20 14 28 1 270348848 1662112 2869888
17:13:21 109 2147483648 2595915312 2682445824 261640416 10.860 20 14 27 0 265428944 1189632 2598896
17:14:21 232 2147483648 2600217856 2686013440 262492096 10.891 20 16 33 0 268249936 2341200 3416640
17:15:23 1010 2147483648 2601092064 2690420736 268934112 11.129 20 11 22 0 272518320 1580096 2004112
17:16:25 429 2147483648 2591518928 2677252096 253218288 10.547 19 11 22 0 256940576 1538960 2183328
17:17:26 146 2147483648 2594555456 2683342848 262167472 10.879 20 4 8 0 265236224 1712064 1356688
17:18:26 194 2147483648 2600582128 2688073728 266767360 11.049 20 13 24 1 269966720 1326336 1873024
17:19:27 257 2147483648 2597974736 2685640704 263682192 10.935 20 12 23 0 267611120 1836192 2092736
17:20:27 215 2147483648 2593100208 2681135104 258245808 10.734 20 10 20 0 262563344 2274032 2043504
17:21:28 148 2147483648 2598210144 2687868928 264993968 10.984 20 9 18 0 268141808 1611040 1536800
17:22:28 409 2147483648 2597437312 2688516096 266342352 11.034 20 7 13 0 268413824 905744 1165728
17:23:29 102 2147483648 2594227552 2682433536 260628048 10.822 20 9 18 1 263792368 1491552 1672768
17:24:31 302 2147483648 2591413968 2680508416 259121408 10.767 20 9 14 2 262716832 1723968 1871456
17:25:32 196 2147483648 2598225040 2686038016 262974896 10.909 20 9 18 0 267846272 3082960 1788416
17:26:32 208 2147483648 2602603728 2692567040 268989136 11.131 20 9 16 0 272518096 1846160 1682800
17:27:33 141 2147483648 2604666640 2692161536 268478384 11.112 20 15 30 0 273132256 1531424 3122448
17:28:33 355 2147483648 2585537952 2672660480 252350784 10.515 19 12 24 0 256074688 952592 2771312
17:29:34 139 2147483648 2592514848 2680913920 257835856 10.719 20 11 23 0 262686160 2690624 2159680
17:30:34 191 2147483648 2600064112 2689388544 265786064 11.013 20 11 21 0 269191392 1314816 2090512
17:31:35 496 2147483648 2599897856 2688839680 265401936 10.999 20 7 14 0 269441248 2478976 1560336
17:32:36 404 2147483648 2576556352 2660552704 243832448 10.196 19 8 17 0 246661792 922592 1906752
17:33:37 552 2147483648 2601576400 2690768896 267271776 11.068 20 12 26 0 271487136 1787920 2427440
17:34:38 145 2147483648 2595847840 2685485056 262611584 10.896 20 8 16 0 267061648 2928336 1521728
17:35:38 565 2147483648 2579988880 2668040192 248386496 10.367 19 7 14 0 251581264 1573616 1621152
17:36:39 217 2147483648 2603453504 2691940352 267937056 11.092 20 13 27 1 272238496 1898848 2402592
17:37:42 608 2147483648 2585965904 2672189440 252835680 10.533 19 6 11 1 255208272 1077392 1295200
17:38:44 1589 2147483648 2602144400 2690863104 266219840 11.029 20 10 20 0 270810672 2686368 1904464
17:39:49 448 2147483648 2592514048 2680926208 258497200 10.743 20 12 24 0 262363664 1829024 2037440
17:40:50 111 2147483648 2586035360 2671415296 250756528 10.455 19 10 20 0 255735936 2827216 2152192
17:41:50 194 2147483648 2597649984 2685263872 262334576 10.886 20 10 20 0 266440448 1977424 2128448
17:42:51 644 2147483648 2596078752 2683916288 261672240 10.861 20 9 18 0 264944528 1543776 1728512
17:43:52 319 2147483648 2596100080 2682933248 261558672 10.857 20 15 25 1 265494480 1848656 2087152
17:44:52 465 2147483648 2605295248 2693165056 267900528 11.091 20 13 26 0 274724352 3863984 2959840
17:45:53 215 2147483648 2594616112 2684956672 261629392 10.859 20 9 19 0 264625600 1332016 1664192
17:46:54 759 2147483648 2594748960 2681905152 259734352 10.789 20 7 14 0 263213008 2099184 1379472
17:47:55 260 2147483648 2602834656 2690936832 267181184 11.064 20 14 28 0 272586032 2937472 2467376
17:48:56 235 2147483648 2597529424 2686296064 263783536 10.939 20 12 25 0 267337392 1166128 2387728
17:49:56 223 2147483648 2610984928 2700152832 273280816 11.289 20 13 26 0 279377600 3706688 2390096
17:50:57 441 2147483648 2590109584 2680471552 257704480 10.714 20 3 6 0 259279808 1142016 433312

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 05-11-2026 17:51:34 to 05-11-2026 17:51:47.

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

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          187056
MON$OLDEST_ACTIVE               187782
MON$OLDEST_SNAPSHOT             187782
MON$NEXT_TRANSACTION            187782
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-05 17:00:11.9030
MON$PAGES                       114912
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    Thu Nov  5 17:51:11 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'

05.11.26 17:51:49. 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-05 17:51:51 No severe PSQL-related problems occured
05.11.26 17:51:51. End of report.