Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 1w 2d
Command: who -b
bootup_info system boot 2026-11-09 10: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 8138016 kB
MemFree 1849152 kB
MemAvailable 7271328 kB
Buffers 77904 kB
Cached 5480168 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-09 17:50:57
DTS_END                         2026-11-09 17:50:57.4520
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/59502
TRN_ID                          215013
ATT_ID                          448
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: 13460.60 982 673030
customer order: creation 635.84 48 31792
customer order: refuse 51.50 49 2575
order to supplier: creation 164.42 213 8221
order to supplier: removal 11.32 9231 566
invoice (draft): creation 163.16 351 8158
invoice (draft): removal 113.76 148 5688
invoice accept: apply 138.54 1600 6927
invoice accept: cancel 93.16 228 4658
customer reserve: creation 6445.18 29 322259
customer reserve: removal 4682.70 16 234135
realization accept: apply 296.30 36 14815
realization accept: cancel 157.72 20 7886
payment from customer: creation 210.52 33 10526
payment from customer: removal 18.72 20 936
payment to supplier: creation 172.28 31 8614
payment to supplier: removal 11.68 19 584
service: total inventory turnovers 37.14 442 1857
service: total monetary turnovers 51.28 8 2564
service: aggregate perf. data 5.34 1802 267
service: refresh index statistics 0.04 5319 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-11-2026 17:51:11 to 09-11-2026 17:51:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7343
TEST_TIME 2 8957
TEST_TIME 3 9929
TEST_TIME 4 10468
TEST_TIME 5 10755
TEST_TIME 6 11054
TEST_TIME 7 11180
TEST_TIME 8 11339
TEST_TIME 9 11533
TEST_TIME 10 11545
TEST_TIME 11 11564
TEST_TIME 12 11598
TEST_TIME 13 11786
TEST_TIME 14 11901
TEST_TIME 15 11885
TEST_TIME 16 11954
TEST_TIME 17 12024
TEST_TIME 18 12046
TEST_TIME 19 12141
TEST_TIME 20 12202
TEST_TIME 21 12284
TEST_TIME 22 12376
TEST_TIME 23 12369
TEST_TIME 24 12339
TEST_TIME 25 12390
TEST_TIME 26 12428
TEST_TIME 27 12427
TEST_TIME 28 12563
TEST_TIME 29 12586
TEST_TIME 30 12613
TEST_TIME 31 12617
TEST_TIME 32 12700
TEST_TIME 33 12742
TEST_TIME 34 12891
TEST_TIME 35 12876
TEST_TIME 36 12893
TEST_TIME 37 13000
TEST_TIME 38 13066
TEST_TIME 39 13101
TEST_TIME 40 13072
TEST_TIME 41 13168
TEST_TIME 42 13173
TEST_TIME 43 13186
TEST_TIME 44 13219
TEST_TIME 45 13303
TEST_TIME 46 13366
TEST_TIME 47 13381
TEST_TIME 48 13426
TEST_TIME 49 13415
TEST_TIME 50 13461

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 09-11-2026 17:51:14 to 09-11-2026 17:51:16.

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 995652 995652 0 0.00 0 1475 2 0 0
doc_list_biud 995652 995652 0 0.00 0 2124 6 0 0
sp_add_invoice_to_stock 6927 6927 0 0.00 5 13690 1601 0 0
sp_cancel_adding_invoice 4658 4658 0 0.00 3 4857 228 0 0
sp_cancel_client_order 2575 2575 0 0.00 3 1173 50 0 0
sp_cancel_customer_reserve 234135 234135 0 0.00 1 1725 16 0 0
sp_cancel_pay_from_customer 936 936 0 0.00 2 506 20 0 0
sp_cancel_pay_to_supplier 584 584 0 0.00 2 381 19 0 0
sp_cancel_supplier_invoice 5688 5688 0 0.00 2 2131 149 0 0
sp_cancel_supplier_order 566 566 0 0.00 7 59758 9231 0 0
sp_cancel_write_off 7886 7886 0 0.00 1 827 21 0 0
sp_client_order 31792 31792 0 0.00 4 1727 49 0 0
sp_customer_reserve 322259 322259 0 0.00 0 2307 30 0 0
sp_fill_shopping_cart 48171 48171 0 0.00 1 1815 21 0 0
sp_fill_shopping_cart_clo_res 322259 322259 0 0.00 0 1050 3 0 0
sp_get_clo_for_invoice 6927 6927 0 0.00 0 1509 37 0 0
sp_kill_cost_storno 14064 14064 0 0.00 0 529 9 0 0
sp_kill_qstorno_ret_qs2qd 482410 482410 0 0.00 0 2122 8 0 0
sp_kill_qty_storno 277250 277250 0 0.00 0 2123 19 0 0
sp_lock_selected_doc 30098 30098 0 0.00 0 400 2 0 0
sp_make_cost_storno 40882 40882 0 0.00 0 532 7 0 0
sp_multiply_rows_for_pdistr 40882 40882 0 0.00 0 652 10 0 0
sp_multiply_rows_for_qdistr 31792 31792 0 0.00 0 1122 19 0 0
sp_pay_from_customer 10526 10526 0 0.00 3 669 33 0 0
sp_pay_to_supplier 8614 8614 0 0.00 3 714 31 0 0
sp_payment_common 19140 19140 0 0.00 1 611 8 0 0
sp_qd_handle_on_cancel_clo 2575 2575 0 0.00 0 1156 33 0 0
sp_qd_handle_on_invoice_upd_sts 11585 11585 0 0.00 0 1227 70 0 0
sp_qd_handle_on_reserve_upd_sts 14815 14815 0 0.00 0 963 10 0 0
sp_reserve_write_off 14815 14815 0 0.00 3 974 37 0 0
sp_supplier_invoice 8158 8158 0 0.00 5 3972 352 0 0
sp_supplier_order 8221 8221 0 0.00 6 2771 213 0 0
srv_aggregate_perf_data 267 267 0 0.00 35 45516 1803 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1570 347 0 0
srv_find_qd_qs_mism 626121 626121 0 0.00 0 1475 2 0 0
srv_make_invnt_saldo 1857 1857 0 0.00 2 84454 443 0 0
srv_make_money_saldo 2564 2564 0 0.00 0 1343 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 331 10307 5319 0 0
v_add_invoice_to_stock 13854 13854 0 0.00 0 415 3 0 0
v_all_customers 48322 48322 0 0.00 0 47 1 0 0
v_all_suppliers 39426 39426 0 0.00 0 59 1 0 0
v_all_wares 63584 63584 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 1210 1210 0 0.00 0 182 2 0 0
v_cancel_client_order 5150 5150 0 0.00 0 458 1 0 0
v_cancel_customer_prepayment 1872 1872 0 0.00 0 293 2 0 0
v_cancel_customer_reserve 2046 2046 0 0.00 0 148 2 0 0
v_cancel_payment_to_supplier 1168 1168 0 0.00 0 312 2 0 0
v_cancel_supplier_invoice 1156 1156 0 0.00 0 86 3 0 0
v_cancel_supplier_order 1132 1132 0 0.00 0 232 2 0 0
v_cancel_write_off 2978 2978 0 0.00 0 146 2 0 0
v_max_id_clo_ord 8221 8221 0 0.00 0 49 1 0 0
v_max_id_clo_res 1501 1501 0 0.00 0 164 1 0 0
v_max_id_ord_sup 8158 8158 0 0.00 0 460 2 0 0
v_max_non_paid_invoice 5280 5280 0 0.00 0 57 2 0 0
v_max_non_paid_realizn 10226 10226 0 0.00 0 91 2 0 0
v_min_id_clo_ord 8221 8221 0 0.00 0 387 3 0 0
v_min_id_clo_res 1501 1501 0 0.00 0 915 7 0 0
v_min_id_ord_sup 8158 8158 0 0.00 0 896 5 0 0
v_min_non_paid_invoice 8614 8614 0 0.00 0 364 3 0 0
v_min_non_paid_realizn 10526 10526 0 0.00 0 328 2 0 0
v_our_firm 15862 15862 0 0.00 0 45 1 0 0
v_reserve_write_off 29630 29630 0 0.00 0 307 2 0 0
x_lock_depdocs_on_canc_invoice 9768 9768 0 0.00 0 835 10 0 0
x_lock_depdocs_on_canc_sup_ord 566 566 0 0.00 0 293 12 0 0
x_make_qstorno_1000_1200 8221 8221 0 0.00 1 2730 154 0 0
x_make_qstorno_1200_2000 8158 8158 0 0.00 1 3758 305 0 0
x_make_qstorno_2100_3300 322259 322259 0 0.00 0 2303 25 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 09-11-2026 17:51:17 to 09-11-2026 17:51:20.

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:01 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:01 119 2147483648 2607741184 2693799936 275843872 11.382 20 10 20 1 278341856 592160 1905824
17:03:02 298 2147483648 2602163888 2688704512 271081472 11.208 20 9 18 0 274976208 1146912 2747824
17:04:02 137 2147483648 2597669344 2682937344 265834512 11.015 20 12 23 1 269105120 1204512 2066096
17:05:03 109 2147483648 2572108352 2653302784 240553488 10.073 19 9 18 0 243592960 1163152 1876320
17:06:03 195 2147483648 2599070208 2686611456 267016896 11.058 20 11 22 1 270141456 1246832 1877728
17:07:04 219 2147483648 2578537520 2662227968 246787072 10.307 20 10 19 0 249903776 908224 2208480
17:08:04 165 2147483648 2596089136 2682765312 263049952 10.912 20 12 24 0 266963760 1420368 2493440
17:09:05 152 2147483648 2589833088 2676133888 256878256 10.683 20 9 18 0 260034496 1150528 2005712
17:10:05 257 2147483648 2598229248 2686611456 265936736 11.019 20 7 14 0 268813376 1549664 1326976
17:11:06 405 2147483648 2596912848 2684735488 263408752 10.925 20 7 14 0 266247408 1501760 1336896
17:12:06 173 2147483648 2600221424 2686484480 266041408 11.022 20 11 22 0 270161040 1614480 2505152
17:13:07 311 2147483648 2599346256 2688258048 266577904 11.042 20 8 16 0 269703040 1663584 1461552
17:14:07 1336 2147483648 2589227584 2678087680 257569008 10.709 20 6 12 0 259904800 1365904 969888
17:15:09 1570 2147483648 2600980656 2689617920 268244240 11.104 20 7 14 0 270858928 1283968 1330720
17:16:11 781 2147483648 2605782880 2695413760 269878832 11.164 20 12 24 0 276977872 4985856 2113184
17:17:12 1523 2147483648 2602696832 2689794048 264754384 10.975 20 11 22 0 271812832 4642576 2415872
17:18:14 137 2147483648 2599093392 2689568768 266176160 11.027 20 5 10 0 269021104 1680128 1164816
17:19:14 189 2147483648 2602638672 2691723264 266203584 11.028 20 14 28 0 272567440 3512384 2851472
17:20:15 189 2147483648 2596552592 2684067840 260824528 10.830 20 13 26 0 266345856 2432912 3088416
17:21:15 117 2147483648 2597853856 2686287872 264125984 10.952 20 8 16 0 266899952 1281824 1492144
17:22:15 198 2147483648 2604713504 2691342336 267141328 11.063 20 10 20 1 273833744 4079824 2612592
17:23:16 141 2147483648 2598067648 2686943232 264479104 10.965 20 8 16 0 267356832 1624064 1253664
17:24:16 181 2147483648 2592059168 2676649984 255342720 10.626 20 14 25 0 260524752 2338800 2843232
17:25:17 156 2147483648 2601216768 2689630208 267846368 11.089 20 7 14 0 270505776 1174816 1484592
17:26:17 523 2147483648 2593953216 2682880000 261230896 10.845 20 10 20 0 264447968 1611568 1605504
17:27:18 181 2147483648 2596166912 2683068416 260437920 10.815 20 12 24 0 265469872 2832000 2199952
17:28:18 181 2147483648 2601241936 2688221184 264662432 10.972 20 14 28 0 269855824 2428544 2764848
17:29:19 209 2147483648 2592315072 2678968320 258295216 10.736 20 12 22 1 261497712 1255488 1947008
17:30:19 216 2147483648 2593230096 2680475648 258726640 10.752 20 14 27 1 263350576 1897920 2726016
17:31:20 118 2147483648 2600027472 2688905216 265956544 11.019 20 9 18 0 269484000 1884864 1642592
17:32:20 240 2147483648 2603966736 2693349376 267249904 11.067 20 11 21 0 272479520 2873728 2355888
17:33:21 201 2147483648 2600872624 2690641920 266037200 11.022 20 13 25 0 270737616 2069744 2630672
17:34:21 266 2147483648 2603345280 2693103616 268165568 11.101 20 10 20 0 272389648 2316384 1907696
17:35:22 276 2147483648 2592334608 2679734272 256838288 10.682 20 10 20 1 261818144 2933952 2045904
17:36:23 640 2147483648 2585238800 2671644672 253517280 10.558 19 10 21 0 256906288 1100352 2288656
17:37:24 220 2147483648 2600105040 2689613824 265307856 10.995 20 11 22 0 269075072 1689872 2077344
17:38:24 563 2147483648 2598867072 2688589824 264512192 10.966 20 10 20 0 268863728 1799840 2551696
17:39:25 192 2147483648 2597821424 2688249856 263689024 10.936 20 9 18 0 267407952 2012640 1706288
17:40:25 167 2147483648 2600905232 2691063808 268055728 11.097 20 10 19 0 270777168 1334240 1387200
17:41:26 218 2147483648 2601963312 2690342912 265388464 10.998 20 11 21 0 270992752 3512736 2091552
17:42:26 512 2147483648 2591362976 2682003456 259179968 10.769 20 6 9 1 261003856 919392 904496
17:43:27 307 2147483648 2594103760 2685952000 261066624 10.839 20 8 16 0 264295008 1789120 1439264
17:44:27 588 2147483648 2598160816 2688393216 263994704 10.947 20 11 22 0 267886816 1287280 2604832
17:45:28 177 2147483648 2587645840 2674872320 252587776 10.524 20 10 20 0 256676368 1938736 2149856
17:46:29 367 2147483648 2602443472 2688565248 264348800 10.960 20 15 28 0 269373872 2137808 2887264
17:47:29 193 2147483648 2601362336 2690502656 265432384 11.000 20 11 20 0 268883296 1595024 1855888
17:48:30 1207 2147483648 2593466256 2680287232 237456320 9.956 18 13 26 0 241375088 1368656 2550112
17:49:32 179 2147483648 2603316576 2692268032 268453792 11.111 20 14 27 0 272236880 1496688 2286400
17:50:33 203 2147483648 2602990496 2694922240 266536176 11.041 20 12 22 1 273385232 4635104 2213952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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:00, from 09-11-2026 17:51:35 to 09-11-2026 17:51:35.

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          215213
MON$OLDEST_ACTIVE               215214
MON$OLDEST_SNAPSHOT             215214
MON$NEXT_TRANSACTION            215214
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-09 17:00:09.4130
MON$PAGES                       135744
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    Mon Nov  9 17:50:59 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'

09.11.26 17:51:36. 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-09 17:51:37 No severe PSQL-related problems occured
09.11.26 17:51:38. End of report.