Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.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 1w
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 1821716 kB
MemAvailable 7284256 kB
Buffers 90540 kB
Cached 5457928 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-07 11:50:57
DTS_END                         2026-11-07 11:50:57.6110
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/48866
TRN_ID                          210565
ATT_ID                          439
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: 13167.80 1035 658390
customer order: creation 623.12 49 31156
customer order: refuse 51.76 50 2588
order to supplier: creation 161.26 217 8063
order to supplier: removal 11.06 9351 553
invoice (draft): creation 158.52 364 7926
invoice (draft): removal 109.94 151 5497
invoice accept: apply 133.10 1658 6655
invoice accept: cancel 89.54 231 4477
customer reserve: creation 6290.56 29 314528
customer reserve: removal 4586.68 16 229334
realization accept: apply 290.24 40 14512
realization accept: cancel 166.72 21 8336
payment from customer: creation 205.96 38 10298
payment from customer: removal 19.78 20 989
payment to supplier: creation 169.54 32 8477
payment to supplier: removal 11.94 19 597
service: total inventory turnovers 34.04 551 1702
service: total monetary turnovers 49.48 8 2474
service: aggregate perf. data 4.52 1913 226
service: refresh index statistics 0.04 5940 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6339
TEST_TIME 2 8073
TEST_TIME 3 8926
TEST_TIME 4 9526
TEST_TIME 5 9924
TEST_TIME 6 10333
TEST_TIME 7 10683
TEST_TIME 8 10779
TEST_TIME 9 10877
TEST_TIME 10 11179
TEST_TIME 11 11226
TEST_TIME 12 11302
TEST_TIME 13 11339
TEST_TIME 14 11591
TEST_TIME 15 11637
TEST_TIME 16 11716
TEST_TIME 17 11761
TEST_TIME 18 11934
TEST_TIME 19 11981
TEST_TIME 20 11990
TEST_TIME 21 12072
TEST_TIME 22 12084
TEST_TIME 23 12117
TEST_TIME 24 12109
TEST_TIME 25 12223
TEST_TIME 26 12146
TEST_TIME 27 12262
TEST_TIME 28 12321
TEST_TIME 29 12368
TEST_TIME 30 12371
TEST_TIME 31 12383
TEST_TIME 32 12441
TEST_TIME 33 12471
TEST_TIME 34 12555
TEST_TIME 35 12587
TEST_TIME 36 12615
TEST_TIME 37 12656
TEST_TIME 38 12698
TEST_TIME 39 12826
TEST_TIME 40 12852
TEST_TIME 41 12915
TEST_TIME 42 12908
TEST_TIME 43 12972
TEST_TIME 44 12997
TEST_TIME 45 13100
TEST_TIME 46 13140
TEST_TIME 47 13105
TEST_TIME 48 13163
TEST_TIME 49 13212
TEST_TIME 50 13168

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-11-2026 11:51:22 to 07-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 973265 973265 0 0.00 0 1048 2 0 0
doc_list_biud 973265 973265 0 0.00 0 1914 6 0 0
sp_add_invoice_to_stock 6655 6655 0 0.00 8 13885 1659 0 0
sp_cancel_adding_invoice 4477 4477 0 0.00 3 6739 232 0 0
sp_cancel_client_order 2588 2588 0 0.00 3 976 51 0 0
sp_cancel_customer_reserve 229334 229334 0 0.00 1 1915 16 0 0
sp_cancel_pay_from_customer 989 989 0 0.00 2 836 21 0 0
sp_cancel_pay_to_supplier 597 597 0 0.00 2 212 20 0 0
sp_cancel_supplier_invoice 5497 5497 0 0.00 2 1603 151 0 0
sp_cancel_supplier_order 553 553 0 0.00 3 55076 9352 0 0
sp_cancel_write_off 8336 8336 0 0.00 1 1035 21 0 0
sp_client_order 31156 31156 0 0.00 4 1454 49 0 0
sp_customer_reserve 314528 314528 0 0.00 0 2724 30 0 0
sp_fill_shopping_cart 47145 47145 0 0.00 1 2360 22 0 0
sp_fill_shopping_cart_clo_res 314528 314528 0 0.00 0 1253 3 0 0
sp_get_clo_for_invoice 6655 6655 0 0.00 0 1264 36 0 0
sp_kill_cost_storno 14399 14399 0 0.00 0 538 10 0 0
sp_kill_qstorno_ret_qs2qd 473054 473054 0 0.00 0 1797 8 0 0
sp_kill_qty_storno 271952 271952 0 0.00 0 1914 19 0 0
sp_lock_selected_doc 29357 29357 0 0.00 0 393 2 0 0
sp_make_cost_storno 39942 39942 0 0.00 0 608 7 0 0
sp_multiply_rows_for_pdistr 39942 39942 0 0.00 0 712 10 0 0
sp_multiply_rows_for_qdistr 31156 31156 0 0.00 0 1080 19 0 0
sp_pay_from_customer 10298 10298 0 0.00 2 1094 38 0 0
sp_pay_to_supplier 8477 8477 0 0.00 3 607 33 0 0
sp_payment_common 18775 18775 0 0.00 1 394 11 0 0
sp_qd_handle_on_cancel_clo 2588 2588 0 0.00 0 959 33 0 0
sp_qd_handle_on_invoice_upd_sts 11132 11132 0 0.00 0 1174 73 0 0
sp_qd_handle_on_reserve_upd_sts 14512 14512 0 0.00 0 954 11 0 0
sp_reserve_write_off 14512 14512 0 0.00 3 1047 40 0 0
sp_supplier_invoice 7926 7926 0 0.00 6 4176 365 0 0
sp_supplier_order 8063 8063 0 0.00 5 2094 218 0 0
srv_aggregate_perf_data 226 226 0 0.00 42 29210 1913 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 3481 343 0 0
srv_find_qd_qs_mism 612428 612428 0 0.00 0 1048 2 0 0
srv_make_invnt_saldo 1702 1702 0 0.00 0 59450 552 0 0
srv_make_money_saldo 2474 2474 0 0.00 0 308 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 306 11574 5940 0 0
v_add_invoice_to_stock 13310 13310 0 0.00 0 678 3 0 0
v_all_customers 47656 47656 0 0.00 0 56 1 0 0
v_all_suppliers 39074 39074 0 0.00 0 59 1 0 0
v_all_wares 62312 62312 0 0.00 0 57 1 0 0
v_cancel_adding_invoice 1112 1112 0 0.00 0 97 2 0 0
v_cancel_client_order 5176 5176 0 0.00 0 668 2 0 0
v_cancel_customer_prepayment 1978 1978 0 0.00 0 833 2 0 0
v_cancel_customer_reserve 1944 1944 0 0.00 0 435 2 0 0
v_cancel_payment_to_supplier 1194 1194 0 0.00 0 162 2 0 0
v_cancel_supplier_invoice 1124 1124 0 0.00 0 132 3 0 0
v_cancel_supplier_order 1106 1106 0 0.00 0 69 2 0 0
v_cancel_write_off 2746 2746 0 0.00 0 207 2 0 0
v_max_id_clo_ord 8063 8063 0 0.00 0 83 1 0 0
v_max_id_clo_res 1499 1499 0 0.00 0 732 3 0 0
v_max_id_ord_sup 7926 7926 0 0.00 0 984 2 0 0
v_max_non_paid_invoice 4929 4929 0 0.00 0 126 2 0 0
v_max_non_paid_realizn 9969 9969 0 0.00 0 209 2 0 0
v_min_id_clo_ord 8063 8063 0 0.00 0 371 3 0 0
v_min_id_clo_res 1499 1499 0 0.00 0 372 4 0 0
v_min_id_ord_sup 7926 7926 0 0.00 0 865 6 0 0
v_min_non_paid_invoice 8477 8477 0 0.00 0 274 4 0 0
v_min_non_paid_realizn 10298 10298 0 0.00 0 333 7 0 0
v_our_firm 15314 15314 0 0.00 0 36 1 0 0
v_reserve_write_off 29024 29024 0 0.00 0 835 2 0 0
x_lock_depdocs_on_canc_invoice 9412 9412 0 0.00 0 720 9 0 0
x_lock_depdocs_on_canc_sup_ord 553 553 0 0.00 0 250 11 0 0
x_make_qstorno_1000_1200 8063 8063 0 0.00 1 1765 157 0 0
x_make_qstorno_1200_2000 7926 7926 0 0.00 1 4114 318 0 0
x_make_qstorno_2100_3300 314528 314528 0 0.00 0 1757 26 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2026 11:51:25 to 07-11-2026 11:51:29.

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:01 3 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:02:01 241 2147483648 2602756752 2689490944 270975872 11.204 20 9 18 0 274235808 904272 2355664
11:03:02 171 2147483648 2603827840 2689695744 270948608 11.203 20 12 23 0 274593152 1695936 1948608
11:04:02 147 2147483648 2589482224 2672685056 255692000 10.639 20 13 26 0 259239856 1229792 2318064
11:05:03 156 2147483648 2598645072 2685304832 266382048 11.035 20 9 17 0 269207296 936656 1888592
11:06:03 239 2147483648 2596950224 2685165568 265871872 11.016 20 8 16 0 268344416 1087872 1384672
11:07:04 135 2147483648 2589256016 2675339264 257203600 10.695 20 6 12 0 260127904 913248 2011056
11:08:04 358 2147483648 2599242048 2689048576 267202496 11.065 20 7 14 0 269651520 789456 1659568
11:09:05 174 2147483648 2587214784 2671996928 253741712 10.567 20 14 30 0 257329392 1087632 2500048
11:10:05 168 2147483648 2607370976 2695405568 268988784 11.131 20 14 27 1 278004848 6167088 2848976
11:11:06 150 2147483648 2592836800 2681044992 261164864 10.842 20 9 16 0 263908448 903504 1840080
11:12:06 181 2147483648 2596724992 2685444096 262656896 10.897 20 13 27 0 267741520 2229760 2854864
11:13:07 371 2147483648 2599021664 2687168512 264062800 10.949 20 9 18 0 267753504 2029904 1660800
11:14:07 219 2147483648 2600235392 2687856640 266491136 11.039 20 6 13 0 270032720 2251968 1289616
11:15:08 743 2147483648 2597464048 2685419520 264962960 10.983 20 9 18 1 268876560 1959504 1954096
11:16:09 117 2147483648 2601524768 2689794048 267500704 11.076 20 11 22 0 270859728 1198016 2161008
11:17:09 223 2147483648 2594293664 2681180160 260799472 10.829 20 13 27 0 264168000 1333424 2035104
11:18:10 195 2147483648 2600372400 2689241088 266969968 11.057 20 10 22 0 270260240 1501552 1788720
11:19:10 181 2147483648 2584501984 2669010944 248295088 10.363 19 16 31 0 253304608 1627696 3381824
11:20:11 195 2147483648 2590672592 2678095872 256544816 10.671 20 12 24 1 260517024 1487920 2484288
11:21:11 252 2147483648 2599987264 2688458752 264927312 10.981 20 10 20 0 269870992 2777920 2165760
11:22:12 239 2147483648 2602621136 2693238784 268615776 11.117 20 10 20 1 272305488 1787584 1902128
11:23:12 153 2147483648 2597406608 2683543552 260185312 10.806 20 16 35 0 266042608 2603616 3253680
11:24:13 279 2147483648 2597169536 2683875328 261871920 10.868 20 13 28 1 266374608 2006432 2496256
11:25:13 463 2147483648 2602873600 2691739648 267739280 11.085 20 10 20 0 271892880 2080224 2073376
11:26:14 188 2147483648 2596962768 2686623744 263500432 10.929 20 9 18 0 267164800 1618512 2045856
11:27:15 145 2147483648 2600390624 2688266240 262698800 10.899 20 11 22 0 269589888 4336608 2554480
11:28:16 578 2147483648 2599910656 2690224128 266513744 11.040 20 7 13 1 269074880 1321472 1239664
11:29:17 125 2147483648 2603186048 2691407872 266624592 11.044 20 14 28 0 272583104 3134016 2824496
11:30:17 450 2147483648 2583786224 2671611904 250380272 10.441 19 9 18 0 253689216 1587520 1721424
11:31:18 158 2147483648 2606083648 2695622656 268194464 11.102 20 12 25 0 275370960 4827696 2348800
11:32:19 379 2147483648 2605704192 2696765440 270870080 11.200 20 10 20 0 276374976 3361248 2143648
11:33:19 398 2147483648 2595355584 2685411328 262211264 10.881 20 6 12 0 264810928 1453632 1146032
11:34:20 1428 2147483648 2596740480 2685706240 263419504 10.926 20 11 22 0 266906864 1380000 2107360
11:35:22 177 2147483648 2599216352 2685607936 262383200 10.887 20 14 28 2 267953040 2500720 3069120
11:36:22 212 2147483648 2599265584 2688876544 266222928 11.029 20 9 19 0 269532672 1350272 1959472
11:37:23 518 2147483648 2594521136 2682961920 259985776 10.799 20 11 20 0 263732320 1439232 2307312
11:38:23 240 2147483648 2601870048 2690961408 266294352 11.032 20 12 24 0 271052896 2543536 2215008
11:39:24 3476 2147483648 2598161440 2690269184 265931200 11.018 20 4 8 0 268359728 1401344 1027184
11:40:27 150 2147483648 2599816848 2686955520 263712464 10.936 20 13 27 0 268082880 2125648 2244768
11:41:28 131 2147483648 2601672656 2692640768 267818016 11.088 20 9 18 0 271271360 1759536 1693808
11:42:29 186 2147483648 2596134848 2686668800 263376976 10.924 20 5 10 0 265408960 1087984 944000
11:43:30 188 2147483648 2594399568 2682867712 259057952 10.764 20 13 24 0 263911792 2387376 2466464
11:44:30 217 2147483648 2593338128 2682613760 259912864 10.796 20 8 16 1 263595088 1956848 1725376
11:45:31 115 2147483648 2600272272 2688880640 264132976 10.952 20 11 22 0 269082048 2525776 2423296
11:46:33 108 2147483648 2600759248 2692706304 267369424 11.071 20 9 18 0 270331840 1161232 1801184
11:47:33 183 2147483648 2595917360 2683801600 260940320 10.834 20 11 23 0 264116800 1136016 2040464
11:48:33 197 2147483648 2580004176 2664914944 244635232 10.226 19 13 26 0 249551936 1867296 3049408
11:49:35 166 2147483648 2606606416 2697105408 271327840 11.217 20 9 18 0 275402512 2255216 1819456
11:50:35 1021 2147483648 2601109904 2690125824 262947008 10.908 20 11 22 0 269952448 4793056 2212384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 07-11-2026 11:51:30 to 07-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 07-11-2026 11:51:45 to 07-11-2026 11:51:46.

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          208632
MON$OLDEST_ACTIVE               210690
MON$OLDEST_SNAPSHOT             210690
MON$NEXT_TRANSACTION            210690
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-07 11:00:09.1900
MON$PAGES                       137024
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    Sat Nov  7 11:50:59 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Sat Nov  7 11:50:59 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'

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