Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 18.11.2026 05: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 4d
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 1845060 kB
MemAvailable 7272740 kB
Buffers 79792 kB
Cached 5428928 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-18 05:50:55
DTS_END                         2026-11-18 05:50:55.3300
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/48196
TRN_ID                          231608
ATT_ID                          468
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: 15347.26 909 767363
customer order: creation 677.62 46 33881
customer order: refuse 56.06 46 2803
order to supplier: creation 177.18 212 8859
order to supplier: removal 12.78 9434 639
invoice (draft): creation 172.26 366 8613
invoice (draft): removal 122.24 161 6112
invoice accept: apply 149.76 1613 7488
invoice accept: cancel 103.64 238 5182
customer reserve: creation 7406.02 27 370301
customer reserve: removal 5408.00 16 270400
realization accept: apply 319.00 40 15950
realization accept: cancel 190.86 20 9543
payment from customer: creation 227.16 39 11358
payment from customer: removal 21.62 19 1081
payment to supplier: creation 185.56 31 9278
payment to supplier: removal 13.52 18 676
service: total inventory turnovers 42.00 424 2100
service: total monetary turnovers 56.40 9 2820
service: aggregate perf. data 5.54 1967 277
service: refresh index statistics 0.04 3459 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9095
TEST_TIME 2 10921
TEST_TIME 3 11802
TEST_TIME 4 12365
TEST_TIME 5 12620
TEST_TIME 6 12794
TEST_TIME 7 13223
TEST_TIME 8 13250
TEST_TIME 9 13376
TEST_TIME 10 13636
TEST_TIME 11 13635
TEST_TIME 12 13708
TEST_TIME 13 13801
TEST_TIME 14 13750
TEST_TIME 15 13842
TEST_TIME 16 13936
TEST_TIME 17 13886
TEST_TIME 18 13972
TEST_TIME 19 13986
TEST_TIME 20 14061
TEST_TIME 21 14144
TEST_TIME 22 14160
TEST_TIME 23 14192
TEST_TIME 24 14166
TEST_TIME 25 14141
TEST_TIME 26 14121
TEST_TIME 27 14209
TEST_TIME 28 14197
TEST_TIME 29 14282
TEST_TIME 30 14310
TEST_TIME 31 14327
TEST_TIME 32 14405
TEST_TIME 33 14531
TEST_TIME 34 14538
TEST_TIME 35 14663
TEST_TIME 36 14664
TEST_TIME 37 14700
TEST_TIME 38 14797
TEST_TIME 39 14882
TEST_TIME 40 14989
TEST_TIME 41 15009
TEST_TIME 42 15093
TEST_TIME 43 15099
TEST_TIME 44 15152
TEST_TIME 45 15179
TEST_TIME 46 15234
TEST_TIME 47 15296
TEST_TIME 48 15328
TEST_TIME 49 15357
TEST_TIME 50 15347

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 18-11-2026 05:51:18 to 18-11-2026 05: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 1132312 1132312 0 0.00 0 1059 2 0 0
doc_list_biud 1132312 1132312 0 0.00 0 1572 6 0 0
sp_add_invoice_to_stock 7488 7488 0 0.00 10 15017 1614 0 0
sp_cancel_adding_invoice 5182 5182 0 0.00 4 5132 238 0 0
sp_cancel_client_order 2803 2803 0 0.00 3 607 46 0 0
sp_cancel_customer_reserve 270400 270400 0 0.00 1 1574 16 0 0
sp_cancel_pay_from_customer 1081 1081 0 0.00 2 305 20 0 0
sp_cancel_pay_to_supplier 676 676 0 0.00 2 202 19 0 0
sp_cancel_supplier_invoice 6112 6112 0 0.00 2 938 162 0 0
sp_cancel_supplier_order 639 639 0 0.00 8 51402 9435 0 0
sp_cancel_write_off 9543 9543 0 0.00 1 496 21 0 0
sp_client_order 33881 33881 0 0.00 4 1134 46 0 0
sp_customer_reserve 370301 370301 0 0.00 0 2336 28 0 0
sp_fill_shopping_cart 51353 51353 0 0.00 1 1103 22 0 0
sp_fill_shopping_cart_clo_res 370301 370301 0 0.00 0 1128 2 0 0
sp_get_clo_for_invoice 7488 7488 0 0.00 0 1078 38 0 0
sp_kill_cost_storno 16482 16482 0 0.00 0 494 9 0 0
sp_kill_qstorno_ret_qs2qd 557094 557094 0 0.00 0 1566 8 0 0
sp_kill_qty_storno 318117 318117 0 0.00 0 1572 19 0 0
sp_lock_selected_doc 32647 32647 0 0.00 0 371 2 0 0
sp_make_cost_storno 44074 44074 0 0.00 0 713 7 0 0
sp_multiply_rows_for_pdistr 44074 44074 0 0.00 0 547 10 0 0
sp_multiply_rows_for_qdistr 33881 33881 0 0.00 0 785 18 0 0
sp_pay_from_customer 11358 11358 0 0.00 3 642 40 0 0
sp_pay_to_supplier 9278 9278 0 0.00 3 554 32 0 0
sp_payment_common 20636 20636 0 0.00 1 638 12 0 0
sp_qd_handle_on_cancel_clo 2803 2803 0 0.00 0 587 29 0 0
sp_qd_handle_on_invoice_upd_sts 12670 12670 0 0.00 0 1099 77 0 0
sp_qd_handle_on_reserve_upd_sts 15950 15950 0 0.00 0 774 11 0 0
sp_reserve_write_off 15950 15950 0 0.00 3 821 40 0 0
sp_supplier_invoice 8613 8613 0 0.00 7 3812 367 0 0
sp_supplier_order 8859 8859 0 0.00 6 1192 213 0 0
srv_aggregate_perf_data 277 277 0 0.00 48 15165 1967 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 2618 272 0 0
srv_find_qd_qs_mism 714018 714018 0 0.00 0 1053 1 0 0
srv_make_invnt_saldo 2100 2100 0 0.00 0 74359 425 0 0
srv_make_money_saldo 2820 2820 0 0.00 0 239 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 150 6769 3460 0 0
v_add_invoice_to_stock 14976 14976 0 0.00 0 264 3 0 0
v_all_customers 51600 51600 0 0.00 0 24 1 0 0
v_all_suppliers 43128 43128 0 0.00 0 37 1 0 0
v_all_wares 67762 67762 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 1294 1294 0 0.00 0 53 2 0 0
v_cancel_client_order 5606 5606 0 0.00 0 175 1 0 0
v_cancel_customer_prepayment 2162 2162 0 0.00 0 282 1 0 0
v_cancel_customer_reserve 2256 2256 0 0.00 0 340 2 0 0
v_cancel_payment_to_supplier 1352 1352 0 0.00 0 112 1 0 0
v_cancel_supplier_invoice 1248 1248 0 0.00 0 159 3 0 0
v_cancel_supplier_order 1278 1278 0 0.00 0 60 2 0 0
v_cancel_write_off 3222 3222 0 0.00 0 301 2 0 0
v_max_id_clo_ord 8859 8859 0 0.00 0 118 2 0 0
v_max_id_clo_res 1611 1611 0 0.00 0 297 1 0 0
v_max_id_ord_sup 8613 8613 0 0.00 0 341 2 0 0
v_max_non_paid_invoice 5186 5186 0 0.00 0 219 2 0 0
v_max_non_paid_realizn 10780 10780 0 0.00 0 94 2 0 0
v_min_id_clo_ord 8859 8859 0 0.00 0 188 3 0 0
v_min_id_clo_res 1611 1611 0 0.00 0 378 3 0 0
v_min_id_ord_sup 8613 8613 0 0.00 0 617 4 0 0
v_min_non_paid_invoice 9278 9278 0 0.00 0 496 4 0 0
v_min_non_paid_realizn 11358 11358 0 0.00 0 633 8 0 0
v_our_firm 17318 17318 0 0.00 0 31 1 0 0
v_reserve_write_off 31900 31900 0 0.00 0 306 1 0 0
x_lock_depdocs_on_canc_invoice 10670 10670 0 0.00 0 1394 11 0 0
x_lock_depdocs_on_canc_sup_ord 639 639 0 0.00 0 201 12 0 0
x_make_qstorno_1000_1200 8859 8859 0 0.00 1 1161 149 0 0
x_make_qstorno_1200_2000 8613 8613 0 0.00 1 3796 322 0 0
x_make_qstorno_2100_3300 370301 370301 0 0.00 0 2332 24 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 18-11-2026 05:51:21 to 18-11-2026 05:51:24.

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
05:00:58 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:01:59 235 2147483648 2532374960 2609352704 197782304 8.433 17 9 17 0 200126256 497424 1846528
05:02:59 205 2147483648 2592966464 2676637696 261199520 10.844 20 10 16 0 264111152 712928 2198704
05:04:00 139 2147483648 2602456768 2687787008 269101328 11.135 20 13 27 0 272863200 1483312 2278560
05:05:00 204 2147483648 2579528944 2661453824 246013680 10.278 20 13 28 0 249629776 749616 2866480
05:06:00 121 2147483648 2600870544 2687471616 267340912 11.070 20 12 25 0 271548256 878080 3329264
05:07:01 201 2147483648 2598132816 2684260352 263787152 10.939 20 11 22 0 268222560 2213696 2221712
05:08:01 396 2147483648 2599428032 2685849600 264661248 10.972 20 10 21 0 267838608 1295392 1881968
05:09:02 116 2147483648 2584220352 2669060096 250894576 10.461 19 13 26 0 255182080 1378912 2908592
05:10:03 246 2147483648 2579880096 2666405888 248048608 10.354 19 11 21 2 252206272 2043360 2114304
05:11:03 194 2147483648 2601946672 2688864256 267480880 11.075 20 14 27 0 272186192 1563936 3141376
05:12:04 126 2147483648 2596515808 2683473920 262286288 10.884 20 11 23 1 265951808 1336128 2329392
05:13:04 239 2147483648 2598862288 2685440000 265119872 10.988 20 17 33 1 269198352 1138208 2940272
05:14:05 372 2147483648 2599931072 2689245184 266644320 11.045 20 10 20 0 270355984 1428176 2283488
05:15:05 138 2147483648 2600334096 2687414272 265532976 11.004 20 14 30 0 269549264 1716416 2299872
05:16:06 193 2147483648 2594813136 2680791040 259295120 10.773 20 12 24 0 264483136 2643136 2544880
05:17:08 224 2147483648 2592475984 2682101760 259247712 10.771 20 13 26 1 263225488 1220240 2757536
05:18:08 164 2147483648 2600005264 2686574592 262810496 10.903 20 13 25 0 268618944 3240400 2568048
05:19:08 137 2147483648 2587098880 2671677440 252287872 10.512 19 12 24 0 257017232 2394048 2335312
05:20:09 136 2147483648 2589655648 2674966528 251325152 10.477 19 13 27 0 256402096 2271824 2805120
05:21:09 136 2147483648 2597676672 2685128704 263057168 10.912 20 12 24 0 267086112 1842704 2186240
05:22:10 94 2147483648 2603368608 2694168576 269882320 11.164 20 10 20 0 273654880 1851792 1920768
05:23:10 155 2147483648 2598034576 2687791104 264906976 10.981 20 9 18 0 267876048 1041184 1927888
05:24:10 191 2147483648 2599569584 2685812736 262345984 10.886 20 15 29 1 268388080 2729120 3312976
05:25:11 905 2147483648 2601677744 2689773568 266240736 11.030 20 8 16 0 269577296 1639360 1697200
05:26:12 117 2147483648 2599271216 2685587456 262415040 10.889 20 13 25 0 268059104 3065504 2578560
05:27:13 330 2147483648 2599958128 2686963712 263450528 10.927 20 13 26 0 268649312 1994272 3204512
05:28:13 227 2147483648 2597473648 2685595648 262355984 10.886 20 9 18 0 266124128 1921312 1846832
05:29:13 207 2147483648 2605235104 2693767168 270044000 11.170 20 12 24 0 274206032 2000112 2161920
05:30:14 184 2147483648 2605807488 2692718592 268485856 11.112 20 13 24 1 274639632 3696176 2457600
05:31:15 148 2147483648 2592290512 2678468608 255970704 10.650 20 12 24 0 260785552 2332016 2482832
05:32:15 348 2147483648 2600855728 2691022848 267545088 11.078 20 10 16 0 271081024 1680400 1855536
05:33:15 229 2147483648 2599879216 2689753088 265795936 11.013 20 6 12 0 269046688 1972848 1277904
05:34:16 151 2147483648 2605272560 2693013504 269309152 11.143 20 15 30 0 274608112 2232672 3066288
05:35:17 122 2147483648 2595558624 2681372672 259753408 10.790 20 12 24 0 264536128 2330496 2452224
05:36:17 122 2147483648 2592246960 2680074240 258259760 10.735 20 12 22 0 262557056 2098064 2199232
05:37:18 169 2147483648 2584637312 2671476736 250843664 10.459 19 10 21 1 254942944 1714848 2384432
05:38:18 420 2147483648 2599824240 2692100096 266752704 11.049 20 5 10 0 269418960 1599712 1066544
05:39:19 175 2147483648 2602989584 2691530752 266162256 11.027 20 11 21 0 271596448 3393424 2040768
05:40:19 206 2147483648 2603892896 2693566464 268128112 11.099 20 12 25 0 272779216 2285648 2365456
05:41:20 316 2147483648 2604607648 2694819840 268169120 11.101 20 10 20 0 272064192 1660992 2234080
05:42:20 149 2147483648 2597492736 2684342272 261022704 10.837 20 13 26 0 265521328 2117792 2380832
05:43:21 2616 2147483648 2596813472 2686894080 262305360 10.884 20 6 12 0 266065456 2372592 1387504
05:44:23 494 2147483648 2601230208 2690686976 266078352 11.024 20 10 20 0 269561168 1706800 1776016
05:45:24 391 2147483648 2602588640 2692919296 267625232 11.081 20 10 20 1 271386224 1724544 2036448
05:46:25 199 2147483648 2590606944 2678419456 252263680 10.512 20 8 16 0 258069392 4032112 1773600
05:47:25 134 2147483648 2602860528 2691219456 267045872 11.059 20 11 20 0 271511248 2009200 2456176
05:48:27 123 2147483648 2602207920 2691616768 266543744 11.041 20 11 22 0 270958928 1987520 2427664
05:49:29 220 2147483648 2601092528 2688815104 264770352 10.976 20 15 27 0 269111008 1503568 2837088
05:50:29 344 2147483648 2602466992 2692538368 267133792 11.063 20 9 18 0 271634944 2669344 1831808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 18-11-2026 05:51:25 to 18-11-2026 05: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 18-11-2026 05:51:38 to 18-11-2026 05: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          230934
MON$OLDEST_ACTIVE               231968
MON$OLDEST_SNAPSHOT             231968
MON$NEXT_TRANSACTION            231968
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-18 05:00:08.3960
MON$PAGES                       142400
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    Wed Nov 18 05:50:56 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov 18 05:50:56 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'

18.11.26 05: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-18 05:51:41 No severe PSQL-related problems occured
18.11.26 05:51:41. End of report.