Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 03.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 3d
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 1618436 kB
MemAvailable 7305444 kB
Buffers 84264 kB
Cached 5722300 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-03 17:51:09
DTS_END                         2026-11-03 17:51:09.5610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/44408
TRN_ID                          166338
ATT_ID                          363
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: 9685.52 866 484276
customer order: creation 483.74 62 24187
customer order: refuse 39.12 41 1956
order to supplier: creation 127.30 260 6365
order to supplier: removal 9.58 8601 479
invoice (draft): creation 126.72 404 6336
invoice (draft): removal 88.40 152 4420
invoice accept: apply 106.12 1883 5306
invoice accept: cancel 72.02 221 3601
customer reserve: creation 4578.84 37 228942
customer reserve: removal 3307.02 17 165351
realization accept: apply 228.62 46 11431
realization accept: cancel 124.10 25 6205
payment from customer: creation 163.38 45 8169
payment from customer: removal 15.32 22 766
payment to supplier: creation 134.90 40 6745
payment to supplier: removal 10.02 20 501
service: total inventory turnovers 27.72 671 1386
service: total monetary turnovers 38.98 8 1949
service: aggregate perf. data 3.58 1520 179
service: refresh index statistics 0.04 3242 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-11-2026 17:51:26 to 03-11-2026 17:51:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9665
TEST_TIME 2 8522
TEST_TIME 3 8088
TEST_TIME 4 8178
TEST_TIME 5 8151
TEST_TIME 6 8214
TEST_TIME 7 8389
TEST_TIME 8 8461
TEST_TIME 9 8519
TEST_TIME 10 8642
TEST_TIME 11 8658
TEST_TIME 12 8700
TEST_TIME 13 8819
TEST_TIME 14 8935
TEST_TIME 15 9046
TEST_TIME 16 9177
TEST_TIME 17 9192
TEST_TIME 18 9230
TEST_TIME 19 9108
TEST_TIME 20 9085
TEST_TIME 21 8993
TEST_TIME 22 8946
TEST_TIME 23 9145
TEST_TIME 24 9170
TEST_TIME 25 9099
TEST_TIME 26 9145
TEST_TIME 27 9150
TEST_TIME 28 9060
TEST_TIME 29 9100
TEST_TIME 30 9100
TEST_TIME 31 9146
TEST_TIME 32 9246
TEST_TIME 33 9231
TEST_TIME 34 9228
TEST_TIME 35 9354
TEST_TIME 36 9443
TEST_TIME 37 9490
TEST_TIME 38 9530
TEST_TIME 39 9551
TEST_TIME 40 9639
TEST_TIME 41 9651
TEST_TIME 42 9638
TEST_TIME 43 9662
TEST_TIME 44 9683
TEST_TIME 45 9725
TEST_TIME 46 9744
TEST_TIME 47 9786
TEST_TIME 48 9764
TEST_TIME 49 9838
TEST_TIME 50 9686

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 03-11-2026 17:51:29 to 03-11-2026 17:51:31.

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 714708 714708 0 0.00 0 2880 3 0 0
doc_list_biud 714708 714708 0 0.00 0 3669 6 0 0
sp_add_invoice_to_stock 5306 5306 0 0.00 5 14790 1884 0 0
sp_cancel_adding_invoice 3601 3601 0 0.00 3 4562 221 0 0
sp_cancel_client_order 1956 1956 0 0.00 3 1533 42 0 0
sp_cancel_customer_reserve 165351 165351 0 0.00 1 3670 18 0 0
sp_cancel_pay_from_customer 766 766 0 0.00 2 348 22 0 0
sp_cancel_pay_to_supplier 501 501 0 0.00 2 244 20 0 0
sp_cancel_supplier_invoice 4420 4420 0 0.00 2 2589 152 0 0
sp_cancel_supplier_order 479 479 0 0.00 7 47591 8602 0 0
sp_cancel_write_off 6205 6205 0 0.00 1 1618 26 0 0
sp_client_order 24187 24187 0 0.00 4 3621 63 0 0
sp_customer_reserve 228942 228942 0 0.00 0 4378 38 0 0
sp_fill_shopping_cart 36888 36888 0 0.00 1 2695 24 0 0
sp_fill_shopping_cart_clo_res 228942 228942 0 0.00 0 1352 4 0 0
sp_get_clo_for_invoice 5306 5306 0 0.00 0 1339 39 0 0
sp_kill_cost_storno 11073 11073 0 0.00 0 784 11 0 0
sp_kill_qstorno_ret_qs2qd 341806 341806 0 0.00 0 2581 9 0 0
sp_kill_qty_storno 198749 198749 0 0.00 0 3668 21 0 0
sp_lock_selected_doc 23247 23247 0 0.00 0 563 2 0 0
sp_make_cost_storno 31651 31651 0 0.00 0 834 8 0 0
sp_multiply_rows_for_pdistr 31651 31651 0 0.00 0 550 13 0 0
sp_multiply_rows_for_qdistr 24187 24187 0 0.00 0 1667 25 0 0
sp_pay_from_customer 8169 8169 0 0.00 3 935 46 0 0
sp_pay_to_supplier 6745 6745 0 0.00 3 882 40 0 0
sp_payment_common 14914 14914 0 0.00 1 754 13 0 0
sp_qd_handle_on_cancel_clo 1956 1956 0 0.00 0 1520 27 0 0
sp_qd_handle_on_invoice_upd_sts 8907 8907 0 0.00 0 2689 74 0 0
sp_qd_handle_on_reserve_upd_sts 11431 11431 0 0.00 0 2383 14 0 0
sp_reserve_write_off 11431 11431 0 0.00 3 2399 46 0 0
sp_supplier_invoice 6336 6336 0 0.00 5 7352 404 0 0
sp_supplier_order 6365 6365 0 0.00 5 4812 261 0 0
srv_aggregate_perf_data 179 179 0 0.00 80 6609 1520 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1550 345 0 0
srv_find_qd_qs_mism 448638 448638 0 0.00 0 2880 2 0 0
srv_make_invnt_saldo 1386 1386 0 0.00 1 106789 672 0 0
srv_make_money_saldo 1949 1949 0 0.00 0 191 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 303 6181 3242 0 0
v_add_invoice_to_stock 10612 10612 0 0.00 0 592 3 0 0
v_all_customers 36806 36806 0 0.00 0 89 1 0 0
v_all_suppliers 30720 30720 0 0.00 0 66 1 0 0
v_all_wares 48374 48374 0 0.00 0 87 1 0 0
v_cancel_adding_invoice 942 942 0 0.00 0 246 3 0 0
v_cancel_client_order 3912 3912 0 0.00 0 333 2 0 0
v_cancel_customer_prepayment 1532 1532 0 0.00 0 119 2 0 0
v_cancel_customer_reserve 1440 1440 0 0.00 0 174 2 0 0
v_cancel_payment_to_supplier 1002 1002 0 0.00 0 98 2 0 0
v_cancel_supplier_invoice 798 798 0 0.00 0 253 4 0 0
v_cancel_supplier_order 958 958 0 0.00 0 345 3 0 0
v_cancel_write_off 2436 2436 0 0.00 0 375 3 0 0
v_max_id_clo_ord 6365 6365 0 0.00 0 63 2 0 0
v_max_id_clo_res 1136 1136 0 0.00 0 588 2 0 0
v_max_id_ord_sup 6336 6336 0 0.00 0 634 3 0 0
v_max_non_paid_invoice 4086 4086 0 0.00 0 135 2 0 0
v_max_non_paid_realizn 7878 7878 0 0.00 0 407 2 0 0
v_min_id_clo_ord 6365 6365 0 0.00 0 214 3 0 0
v_min_id_clo_res 1136 1136 0 0.00 0 1139 7 0 0
v_min_id_ord_sup 6336 6336 0 0.00 0 1166 10 0 0
v_min_non_paid_invoice 6745 6745 0 0.00 0 753 5 0 0
v_min_non_paid_realizn 8169 8169 0 0.00 0 682 7 0 0
v_our_firm 12150 12150 0 0.00 0 44 1 0 0
v_reserve_write_off 22862 22862 0 0.00 0 944 2 0 0
x_lock_depdocs_on_canc_invoice 7622 7622 0 0.00 0 1658 9 0 0
x_lock_depdocs_on_canc_sup_ord 479 479 0 0.00 0 187 9 0 0
x_make_qstorno_1000_1200 6365 6365 0 0.00 1 4744 198 0 0
x_make_qstorno_1200_2000 6336 6336 0 0.00 1 6928 346 0 0
x_make_qstorno_2100_3300 228942 228942 0 0.00 0 4032 32 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-11-2026 17:51:32 to 03-11-2026 17:51:36.

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:15 154 2147483648 2604364320 2689789952 269260112 11.141 20 13 21 1 275053856 3948048 1845696
17:03:15 169 2147483648 2591887840 2675412992 257493296 10.706 20 10 20 2 263388384 4152368 1742720
17:04:16 163 2147483648 2603968560 2690863104 272549728 11.262 20 9 18 0 275260816 1036160 1674928
17:05:16 234 2147483648 2584599216 2668199936 252465376 10.519 20 11 21 0 255790288 1494240 1830672
17:06:17 171 2147483648 2603879056 2691932160 271824912 11.235 20 9 16 1 274438608 830608 1783088
17:07:18 157 2147483648 2589888512 2675277824 257982304 10.724 20 9 17 0 260604032 903280 1718448
17:08:18 1548 2147483648 2596959424 2684911616 265488384 11.002 20 7 14 0 268117152 1177536 1451232
17:09:20 303 2147483648 2599206208 2685841408 265539776 11.004 20 13 27 0 269327456 1224848 2562832
17:10:21 544 2147483648 2592576048 2677243904 258910688 10.759 20 11 22 0 262568480 1629200 2028592
17:11:21 104 2147483648 2604411280 2691719168 272132848 11.246 20 12 23 0 276300224 1825280 2342096
17:12:22 676 2147483648 2595473904 2682748928 262849792 10.905 20 11 18 1 266980800 1482320 2648688
17:13:23 199 2147483648 2593735472 2679877632 260375376 10.813 20 12 24 0 263894176 1428544 2090256
17:14:24 342 2147483648 2605472752 2693771264 270436336 11.184 20 10 20 1 275150448 2610144 2103968
17:15:24 459 2147483648 2602206736 2690691072 269225408 11.140 20 10 20 0 272410800 1296976 1888416
17:16:25 209 2147483648 2591699376 2675847168 255807296 10.644 20 16 31 0 260779360 1998192 2973872
17:17:26 115 2147483648 2595089552 2683330560 262233280 10.882 20 10 19 1 265390848 1493280 1664288
17:18:26 519 2147483648 2596598720 2686681088 263950560 10.945 20 6 12 0 266247952 1332928 964464
17:19:27 652 2147483648 2598693472 2688053248 264996256 10.984 20 6 12 0 268470080 2081984 1391840
17:20:29 289 2147483648 2598299488 2684141568 263348528 10.923 20 14 26 0 267388448 1637552 2402368
17:21:29 226 2147483648 2602780240 2692186112 269715808 11.158 20 9 15 0 272796960 1745888 1335264
17:22:30 225 2147483648 2598039072 2686873600 265012912 10.985 20 7 14 0 267735984 1274352 1448720
17:23:31 176 2147483648 2591316320 2679930880 258660880 10.750 20 6 12 0 260910768 1195952 1053936
17:24:31 166 2147483648 2596335520 2683539456 261466688 10.853 20 10 20 0 266256736 2817568 1972480
17:25:32 190 2147483648 2599659792 2687475712 264773008 10.976 20 8 16 0 269352928 2344176 2235744
17:26:32 344 2147483648 2602008256 2693033984 269898224 11.164 20 7 12 0 272309792 1137344 1274224
17:27:33 282 2147483648 2601312624 2689769472 267497040 11.076 20 10 20 0 271051696 1483952 2070704
17:28:34 296 2147483648 2597028400 2685509632 263791168 10.939 20 9 18 1 266871712 1267440 1813104
17:29:34 294 2147483648 2588682784 2677985280 256755376 10.679 20 8 15 1 258891136 1195328 940432
17:30:35 141 2147483648 2601600304 2689568768 267718976 11.084 20 11 22 0 271353120 1624368 2009776
17:31:36 338 2147483648 2597846432 2684899328 263190032 10.917 20 12 23 0 266934912 2001344 1743536
17:32:38 115 2147483648 2592821120 2681786368 261143360 10.842 20 7 10 0 262777008 770896 862752
17:33:39 565 2147483648 2602936976 2691350528 267117280 11.062 20 15 27 1 271680096 1516544 3046272
17:34:40 509 2147483648 2602777680 2690506752 267206512 11.065 20 12 24 0 270720912 1380400 2134000
17:35:41 152 2147483648 2595261760 2684440576 261912288 10.870 20 10 20 0 265460096 1405760 2142048
17:36:42 267 2147483648 2594477296 2684018688 260953808 10.834 20 6 12 0 262980080 1047200 979072
17:37:42 1284 2147483648 2599019568 2688630784 263628944 10.933 20 9 17 0 267407392 2278560 1499888
17:38:44 183 2147483648 2603606048 2691317760 267983248 11.094 20 17 36 1 273254768 1886880 3384640
17:39:45 298 2147483648 2600374896 2690146304 265523184 11.003 20 10 20 0 270182160 2545088 2113888
17:40:45 314 2147483648 2602603872 2692268032 268055904 11.097 20 10 20 1 271777376 1528688 2192784
17:41:46 175 2147483648 2597337152 2685235200 263372768 10.924 20 9 18 0 266654320 1246400 2035152
17:42:47 157 2147483648 2597472032 2686992384 264122848 10.952 20 6 12 0 266292144 1056464 1112832
17:43:47 261 2147483648 2596032224 2687188992 263517520 10.929 20 8 16 0 266711152 1177456 2016176
17:44:48 247 2147483648 2596269424 2686009344 262139360 10.878 20 9 18 0 265413488 1619344 1654784
17:45:49 277 2147483648 2599115168 2687758336 262903488 10.907 20 9 18 0 268318416 3287568 2127360
17:46:52 879 2147483648 2596013056 2684432384 261985584 10.873 20 8 16 0 265516032 2106016 1424432
17:47:53 400 2147483648 2598294992 2686926848 261352448 10.849 20 8 16 0 267620640 4499408 1768784
17:48:53 301 2147483648 2591511616 2679336960 257821360 10.718 20 9 17 0 260348176 1040496 1486320
17:49:54 593 2147483648 2604616512 2694082560 270185680 11.175 20 10 19 0 273908544 2186368 1536496
17:50:55 442 2147483648 2596036928 2684014592 260321104 10.811 20 13 24 0 264443792 1912768 2209920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 03-11-2026 17:51:54 to 03-11-2026 17:51:55.

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          165916
MON$OLDEST_ACTIVE               166514
MON$OLDEST_SNAPSHOT             166514
MON$NEXT_TRANSACTION            166514
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-03 17:00:11.3920
MON$PAGES                       103392
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    Tue Nov  3 17:51:10 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'

03.11.26 17:51:55. 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-03 17:51:57 No severe PSQL-related problems occured
03.11.26 17:51:57. End of report.