Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.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 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 1713360 kB
MemAvailable 7234448 kB
Buffers 89340 kB
Cached 5519564 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 11:51:01
DTS_END                         2026-11-05 11:51:01.5270
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/58976
TRN_ID                          199208
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: 12190.44 928 609522
customer order: creation 589.50 53 29475
customer order: refuse 46.74 49 2337
order to supplier: creation 151.88 221 7594
order to supplier: removal 11.32 8400 566
invoice (draft): creation 153.02 349 7651
invoice (draft): removal 105.10 150 5255
invoice accept: apply 128.90 1657 6445
invoice accept: cancel 84.74 240 4237
customer reserve: creation 5861.36 31 293068
customer reserve: removal 4167.66 16 208383
realization accept: apply 270.10 39 13505
realization accept: cancel 147.76 21 7388
payment from customer: creation 196.14 34 9807
payment from customer: removal 18.98 20 949
payment to supplier: creation 161.18 31 8059
payment to supplier: removal 11.58 18 579
service: total inventory turnovers 33.24 564 1662
service: total monetary turnovers 46.86 8 2343
service: aggregate perf. data 4.34 1621 217
service: refresh index statistics 0.04 5036 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 05-11-2026 11:51:20 to 05-11-2026 11:51:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13393
TEST_TIME 2 11465
TEST_TIME 3 11316
TEST_TIME 4 10933
TEST_TIME 5 11256
TEST_TIME 6 11139
TEST_TIME 7 11279
TEST_TIME 8 11357
TEST_TIME 9 11404
TEST_TIME 10 11408
TEST_TIME 11 11339
TEST_TIME 12 11445
TEST_TIME 13 11485
TEST_TIME 14 11504
TEST_TIME 15 11519
TEST_TIME 16 11565
TEST_TIME 17 11644
TEST_TIME 18 11658
TEST_TIME 19 11699
TEST_TIME 20 11695
TEST_TIME 21 11757
TEST_TIME 22 11766
TEST_TIME 23 11796
TEST_TIME 24 11776
TEST_TIME 25 11777
TEST_TIME 26 11750
TEST_TIME 27 11736
TEST_TIME 28 11693
TEST_TIME 29 11749
TEST_TIME 30 11815
TEST_TIME 31 11794
TEST_TIME 32 11895
TEST_TIME 33 11957
TEST_TIME 34 11950
TEST_TIME 35 11999
TEST_TIME 36 12069
TEST_TIME 37 12103
TEST_TIME 38 12093
TEST_TIME 39 12094
TEST_TIME 40 12165
TEST_TIME 41 12224
TEST_TIME 42 12273
TEST_TIME 43 12265
TEST_TIME 44 12260
TEST_TIME 45 12273
TEST_TIME 46 12314
TEST_TIME 47 12355
TEST_TIME 48 12419
TEST_TIME 49 12431
TEST_TIME 50 12190

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2026 11:51:22 to 05-11-2026 11:51:25.

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 902866 902866 0 0.00 0 1326 2 0 0
doc_list_biud 902866 902866 0 0.00 0 2674 6 0 0
sp_add_invoice_to_stock 6445 6445 0 0.00 6 13938 1657 0 0
sp_cancel_adding_invoice 4237 4237 0 0.00 4 6613 241 0 0
sp_cancel_client_order 2337 2337 0 0.00 3 836 50 0 0
sp_cancel_customer_reserve 208383 208383 0 0.00 1 2674 17 0 0
sp_cancel_pay_from_customer 949 949 0 0.00 2 353 20 0 0
sp_cancel_pay_to_supplier 579 579 0 0.00 2 220 18 0 0
sp_cancel_supplier_invoice 5255 5255 0 0.00 1 1781 150 0 0
sp_cancel_supplier_order 566 566 0 0.00 9 63234 8401 0 0
sp_cancel_write_off 7388 7388 0 0.00 1 765 22 0 0
sp_client_order 29475 29475 0 0.00 4 1632 54 0 0
sp_customer_reserve 293068 293068 0 0.00 0 3078 31 0 0
sp_fill_shopping_cart 44721 44721 0 0.00 1 2189 21 0 0
sp_fill_shopping_cart_clo_res 293067 293067 0 0.00 0 1784 3 0 0
sp_get_clo_for_invoice 6445 6445 0 0.00 0 1297 36 0 0
sp_kill_cost_storno 13153 13153 0 0.00 0 754 9 0 0
sp_kill_qstorno_ret_qs2qd 429975 429975 0 0.00 0 2326 8 0 0
sp_kill_qty_storno 248116 248116 0 0.00 0 2673 19 0 0
sp_lock_selected_doc 27856 27856 0 0.00 0 536 2 0 0
sp_make_cost_storno 37816 37816 0 0.00 0 594 7 0 0
sp_multiply_rows_for_pdistr 37816 37816 0 0.00 0 703 10 0 0
sp_multiply_rows_for_qdistr 29475 29475 0 0.00 0 1056 21 0 0
sp_pay_from_customer 9807 9807 0 0.00 3 705 34 0 0
sp_pay_to_supplier 8059 8059 0 0.00 3 847 31 0 0
sp_payment_common 17866 17866 0 0.00 1 424 8 0 0
sp_qd_handle_on_cancel_clo 2337 2337 0 0.00 0 821 33 0 0
sp_qd_handle_on_invoice_upd_sts 10682 10682 0 0.00 0 1413 71 0 0
sp_qd_handle_on_reserve_upd_sts 13505 13505 0 0.00 0 1075 12 0 0
sp_reserve_write_off 13505 13505 0 0.00 3 1426 39 0 0
sp_supplier_invoice 7651 7651 0 0.00 6 4003 350 0 0
sp_supplier_order 7594 7594 0 0.00 5 3024 222 0 0
srv_aggregate_perf_data 217 217 0 0.00 23 9837 1622 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 2664 424 0 0
srv_find_qd_qs_mism 565794 565794 0 0.00 0 1326 2 0 0
srv_make_invnt_saldo 1662 1662 0 0.00 1 108593 564 0 0
srv_make_money_saldo 2343 2343 0 0.00 0 211 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 393 9680 5037 0 0
v_add_invoice_to_stock 12890 12890 0 0.00 0 1011 3 0 0
v_all_customers 45022 45022 0 0.00 0 59 1 0 0
v_all_suppliers 37010 37010 0 0.00 0 40 1 0 0
v_all_wares 58950 58950 0 0.00 0 89 1 0 0
v_cancel_adding_invoice 1234 1234 0 0.00 0 166 2 0 0
v_cancel_client_order 4674 4674 0 0.00 0 241 1 0 0
v_cancel_customer_prepayment 1898 1898 0 0.00 0 184 2 0 0
v_cancel_customer_reserve 1814 1814 0 0.00 0 31 2 0 0
v_cancel_payment_to_supplier 1158 1158 0 0.00 0 90 1 0 0
v_cancel_supplier_invoice 1162 1162 0 0.00 0 396 3 0 0
v_cancel_supplier_order 1132 1132 0 0.00 0 56 2 0 0
v_cancel_write_off 2740 2740 0 0.00 0 410 2 0 0
v_max_id_avl_res 1 1 0 0.00 2 2 2 0 0
v_max_id_clo_ord 7594 7594 0 0.00 0 49 1 0 0
v_max_id_clo_res 1307 1307 0 0.00 0 53 1 0 0
v_max_id_ord_sup 7651 7651 0 0.00 0 593 2 0 0
v_max_non_paid_invoice 4799 4799 0 0.00 0 73 2 0 0
v_max_non_paid_realizn 9390 9390 0 0.00 0 117 2 0 0
v_min_id_avl_res 1 1 0 0.00 6 6 6 0 0
v_min_id_clo_ord 7594 7594 0 0.00 0 383 3 0 0
v_min_id_clo_res 1308 1308 0 0.00 0 494 5 0 0
v_min_id_ord_sup 7651 7651 0 0.00 0 1333 7 0 0
v_min_non_paid_invoice 8059 8059 0 0.00 0 419 3 0 0
v_min_non_paid_realizn 9807 9807 0 0.00 0 326 3 0 0
v_our_firm 14764 14764 0 0.00 0 46 1 0 0
v_reserve_write_off 27010 27010 0 0.00 0 1110 2 0 0
x_lock_depdocs_on_canc_invoice 8911 8911 0 0.00 0 1565 9 0 0
x_lock_depdocs_on_canc_sup_ord 566 566 0 0.00 0 195 10 0 0
x_make_qstorno_1000_1200 7594 7594 0 0.00 1 3005 164 0 0
x_make_qstorno_1200_2000 7651 7651 0 0.00 1 3905 301 0 0
x_make_qstorno_2100_3300 293068 293068 0 0.00 0 3078 27 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 05-11-2026 11:51:25 to 05-11-2026 11:51:30.

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:06 3 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:07 200 2147483648 2605294464 2691076096 272621792 11.264 20 11 25 0 276544992 804480 3118720
11:03:07 161 2147483648 2600045312 2685046784 267553056 11.078 20 10 19 0 270398272 1286672 1558544
11:04:08 1108 2147483648 2583853152 2667745280 251668512 10.489 20 14 27 0 254832240 911440 2252288
11:05:09 128 2147483648 2604087696 2690080768 271685264 11.230 20 15 29 0 274919088 828240 2405584
11:06:10 178 2147483648 2589881392 2674679808 257903360 10.721 20 8 16 0 260620560 1012752 1704448
11:07:10 406 2147483648 2606124432 2693713920 272491536 11.260 20 13 26 0 276423712 1614592 2317584
11:08:11 163 2147483648 2598251056 2683604992 264959248 10.983 20 11 23 0 269068016 1466064 2642704
11:09:11 105 2147483648 2603554560 2690572288 270089280 11.171 20 13 26 0 274420112 1248976 3081856
11:10:12 284 2147483648 2593650816 2679488512 259577184 10.783 20 11 22 0 264308576 2100944 2630448
11:11:12 183 2147483648 2593153136 2681430016 261338032 10.849 20 6 13 0 264305040 1547888 1419120
11:12:13 127 2147483648 2596994608 2683736064 264015888 10.948 20 13 23 0 267737728 994320 2727520
11:13:13 785 2147483648 2599367360 2690080768 268237712 11.103 20 4 8 0 270060640 1190912 632016
11:14:14 1615 2147483648 2596749440 2684878848 262856576 10.905 20 13 25 0 266699136 1549728 2292832
11:15:16 278 2147483648 2597942736 2684727296 260790208 10.828 20 11 22 0 268524160 5498304 2235648
11:16:17 214 2147483648 2603205520 2691424256 268134672 11.100 20 12 24 0 272020384 1528000 2357712
11:17:17 232 2147483648 2596809408 2684022784 262184816 10.880 20 14 28 0 267167600 1932608 3050176
11:18:18 462 2147483648 2597168592 2683977728 262141920 10.878 20 13 26 0 266348368 1880944 2325504
11:19:18 369 2147483648 2596183824 2684129280 263340704 10.923 20 10 20 0 266708576 1576864 1791008
11:20:19 246 2147483648 2600538080 2686533632 264171728 10.953 20 14 28 0 268693408 1002464 3519216
11:21:19 201 2147483648 2604425568 2692857856 268350064 11.107 20 10 20 0 272908880 2221424 2337392
11:22:21 203 2147483648 2592468432 2679087104 258878080 10.758 20 12 23 0 262351744 1369616 2104048
11:23:21 176 2147483648 2594191488 2682228736 261317792 10.848 20 5 10 0 264127552 1859632 950128
11:24:21 1463 2147483648 2597761552 2687070208 263911264 10.944 20 5 10 0 267298560 2418064 969232
11:25:23 382 2147483648 2592662000 2680520704 259684608 10.787 20 8 16 0 262641056 1511456 1444992
11:26:24 164 2147483648 2565059456 2647941120 231013536 9.712 18 13 26 0 235804256 1752976 3037744
11:27:25 146 2147483648 2595033536 2682888192 260290608 10.810 20 10 20 0 264858656 2092240 2475808
11:28:25 185 2147483648 2600900752 2690174976 266654992 11.045 20 11 22 0 270404160 1682016 2067152
11:29:26 163 2147483648 2572590800 2654334976 236508656 9.920 20 16 30 0 241686960 2413424 2764880
11:30:26 213 2147483648 2593624944 2679877632 258174064 10.731 20 10 20 0 262638192 2491936 1972192
11:31:27 167 2147483648 2606078768 2694934528 270552704 11.188 20 9 18 0 275155376 2722272 1880400
11:32:27 183 2147483648 2602835712 2692505600 268300832 11.106 20 10 20 0 272959776 2193328 2465616
11:33:29 219 2147483648 2603740096 2694967296 269494528 11.150 20 8 16 0 272610656 1450544 1665584
11:34:29 406 2147483648 2601292448 2693693440 265936544 11.019 20 8 14 0 270545984 3251056 1358384
11:35:32 605 2147483648 2596185472 2686205952 263088432 10.913 20 10 20 0 266566224 1383984 2093808
11:36:34 350 2147483648 2600360064 2690990080 267536560 11.078 20 7 14 0 270227552 1577344 1113648
11:37:34 341 2147483648 2603508912 2693283840 268018304 11.095 20 8 16 0 272707472 3062896 1626272
11:38:35 580 2147483648 2588506432 2676903936 255553344 10.634 20 8 16 0 258402464 1594672 1254448
11:39:38 777 2147483648 2599706336 2688892928 264501872 10.966 20 9 17 0 269253024 3327264 1423888
11:40:39 1193 2147483648 2601274784 2692431872 268141328 11.100 20 9 19 0 271483392 1545136 1796928
11:41:40 189 2147483648 2591341216 2680242176 257799456 10.718 20 7 12 0 260876848 1542352 1535040
11:42:41 2663 2147483648 2597656448 2685501440 263024080 10.911 20 12 24 0 266535568 1074800 2436688
11:43:44 154 2147483648 2601825280 2690691072 265712320 11.010 20 11 22 1 270670080 2664256 2293504
11:44:45 313 2147483648 2594400848 2682155008 260508256 10.818 20 11 20 0 263350400 1242304 1599840
11:45:46 170 2147483648 2592905616 2682486784 258678704 10.750 20 10 20 0 262400848 1680192 2041952
11:46:46 177 2147483648 2599485696 2688466944 264859104 10.979 20 11 20 0 268584272 1826912 1898256
11:47:47 151 2147483648 2604576912 2694504448 269236512 11.140 20 11 22 0 272726976 1279136 2211328
11:48:47 446 2147483648 2591479408 2678083584 256068240 10.653 20 11 20 0 260211968 2206496 1937232
11:49:48 299 2147483648 2596307168 2687180800 263148432 10.916 20 5 10 0 266434032 2486832 798768
11:50:49 1126 2147483648 2593791424 2684571648 264752944 10.975 20 8 16 0 267589712 1514592 1322176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 05-11-2026 11:51:31 to 05-11-2026 11:51:45.

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 11:51:46 to 05-11-2026 11:51:47.

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          199207
MON$OLDEST_ACTIVE               199616
MON$OLDEST_SNAPSHOT             199616
MON$NEXT_TRANSACTION            199616
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 11:00:10.2920
MON$PAGES                       124576
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 11:51:02 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Thu Nov  5 11:51:03 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Thu Nov  5 11:51:03 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
--- end of diff output ---

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

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