Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.11.2026 17:51
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2d
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 1664140 kB
MemAvailable 7272096 kB
Buffers 82008 kB
Cached 5648624 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-02 17:51:02
DTS_END                         2026-11-02 17:51:02.4760
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/42948
TRN_ID                          188004
ATT_ID                          401
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: 11519.96 996 575998
customer order: creation 554.50 54 27725
customer order: refuse 44.96 53 2248
order to supplier: creation 143.74 235 7187
order to supplier: removal 10.40 8948 520
invoice (draft): creation 140.44 357 7022
invoice (draft): removal 96.74 146 4837
invoice accept: apply 119.40 1780 5970
invoice accept: cancel 79.98 223 3999
customer reserve: creation 5470.84 33 273542
customer reserve: removal 4010.12 17 200506
realization accept: apply 261.58 44 13079
realization accept: cancel 144.40 22 7220
payment from customer: creation 186.02 37 9301
payment from customer: removal 16.54 22 827
payment to supplier: creation 149.40 32 7470
payment to supplier: removal 11.28 20 564
service: total inventory turnovers 31.82 598 1591
service: total monetary turnovers 43.36 8 2168
service: aggregate perf. data 4.40 1813 220
service: refresh index statistics 0.04 5476 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13223
TEST_TIME 2 11164
TEST_TIME 3 10742
TEST_TIME 4 10439
TEST_TIME 5 10254
TEST_TIME 6 10315
TEST_TIME 7 10229
TEST_TIME 8 10205
TEST_TIME 9 10130
TEST_TIME 10 10408
TEST_TIME 11 10426
TEST_TIME 12 10428
TEST_TIME 13 10443
TEST_TIME 14 10471
TEST_TIME 15 10528
TEST_TIME 16 10706
TEST_TIME 17 10789
TEST_TIME 18 10794
TEST_TIME 19 10946
TEST_TIME 20 10949
TEST_TIME 21 11061
TEST_TIME 22 11070
TEST_TIME 23 11053
TEST_TIME 24 11115
TEST_TIME 25 11105
TEST_TIME 26 11238
TEST_TIME 27 11258
TEST_TIME 28 11238
TEST_TIME 29 11280
TEST_TIME 30 11286
TEST_TIME 31 11382
TEST_TIME 32 11363
TEST_TIME 33 11283
TEST_TIME 34 11293
TEST_TIME 35 11286
TEST_TIME 36 11380
TEST_TIME 37 11474
TEST_TIME 38 11495
TEST_TIME 39 11532
TEST_TIME 40 11475
TEST_TIME 41 11488
TEST_TIME 42 11659
TEST_TIME 43 11600
TEST_TIME 44 11605
TEST_TIME 45 11667
TEST_TIME 46 11765
TEST_TIME 47 11769
TEST_TIME 48 11734
TEST_TIME 49 11743
TEST_TIME 50 11520

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 02-11-2026 17:51:22 to 02-11-2026 17:51:24.

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 848427 848427 0 0.00 0 1603 2 0 0
doc_list_biud 848427 848427 0 0.00 0 2175 6 0 0
sp_add_invoice_to_stock 5970 5970 0 0.00 12 13509 1780 0 0
sp_cancel_adding_invoice 3999 3999 0 0.00 3 5261 223 0 0
sp_cancel_client_order 2248 2248 0 0.00 3 1494 54 0 0
sp_cancel_customer_reserve 200506 200506 0 0.00 1 2176 17 0 0
sp_cancel_pay_from_customer 827 827 0 0.00 2 219 22 0 0
sp_cancel_pay_to_supplier 564 564 0 0.00 2 182 20 0 0
sp_cancel_supplier_invoice 4837 4837 0 0.00 1 1386 147 0 0
sp_cancel_supplier_order 520 520 0 0.00 8 52586 8948 0 0
sp_cancel_write_off 7220 7220 0 0.00 1 1231 22 0 0
sp_client_order 27725 27725 0 0.00 4 1630 55 0 0
sp_customer_reserve 273542 273542 0 0.00 0 3860 33 0 0
sp_fill_shopping_cart 41934 41934 0 0.00 1 2288 22 0 0
sp_fill_shopping_cart_clo_res 273542 273542 0 0.00 0 1351 3 0 0
sp_get_clo_for_invoice 5970 5970 0 0.00 0 1043 38 0 0
sp_kill_cost_storno 12610 12610 0 0.00 0 553 10 0 0
sp_kill_qstorno_ret_qs2qd 413589 413589 0 0.00 0 1960 8 0 0
sp_kill_qty_storno 238379 238379 0 0.00 0 2175 19 0 0
sp_lock_selected_doc 26272 26272 0 0.00 0 275 2 0 0
sp_make_cost_storno 35820 35820 0 0.00 0 614 7 0 0
sp_multiply_rows_for_pdistr 35820 35820 0 0.00 0 967 11 0 0
sp_multiply_rows_for_qdistr 27725 27725 0 0.00 0 1143 22 0 0
sp_pay_from_customer 9301 9301 0 0.00 3 633 37 0 0
sp_pay_to_supplier 7470 7470 0 0.00 3 618 33 0 0
sp_payment_common 16771 16771 0 0.00 1 499 8 0 0
sp_qd_handle_on_cancel_clo 2248 2248 0 0.00 0 1473 36 0 0
sp_qd_handle_on_invoice_upd_sts 9969 9969 0 0.00 0 1791 71 0 0
sp_qd_handle_on_reserve_upd_sts 13079 13079 0 0.00 0 917 13 0 0
sp_reserve_write_off 13079 13079 0 0.00 3 1003 45 0 0
sp_supplier_invoice 7022 7022 0 0.00 6 4043 357 0 0
sp_supplier_order 7187 7187 0 0.00 4 2389 236 0 0
srv_aggregate_perf_data 220 220 0 0.00 29 14863 1814 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1253 317 0 0
srv_find_qd_qs_mism 534322 534322 0 0.00 0 1602 2 0 0
srv_make_invnt_saldo 1591 1591 0 0.00 0 72539 599 0 0
srv_make_money_saldo 2168 2168 0 0.00 0 322 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 214 10739 5477 0 0
v_add_invoice_to_stock 11940 11940 0 0.00 0 433 3 0 0
v_all_customers 42432 42432 0 0.00 0 49 1 0 0
v_all_suppliers 34198 34198 0 0.00 0 77 1 0 0
v_all_wares 55450 55450 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 986 986 0 0.00 0 176 2 0 0
v_cancel_client_order 4496 4496 0 0.00 0 331 2 0 0
v_cancel_customer_prepayment 1654 1654 0 0.00 0 70 2 0 0
v_cancel_customer_reserve 1734 1734 0 0.00 0 338 2 0 0
v_cancel_payment_to_supplier 1128 1128 0 0.00 0 54 2 0 0
v_cancel_supplier_invoice 922 922 0 0.00 0 491 3 0 0
v_cancel_supplier_order 1040 1040 0 0.00 0 28 2 0 0
v_cancel_write_off 2486 2486 0 0.00 0 159 2 0 0
v_max_id_clo_ord 7187 7187 0 0.00 0 87 2 0 0
v_max_id_clo_res 1288 1288 0 0.00 0 128 2 0 0
v_max_id_ord_sup 7022 7022 0 0.00 0 1125 2 0 0
v_max_non_paid_invoice 4580 4580 0 0.00 0 161 2 0 0
v_max_non_paid_realizn 8955 8955 0 0.00 0 298 2 0 0
v_min_id_clo_ord 7187 7187 0 0.00 0 312 3 0 0
v_min_id_clo_res 1288 1288 0 0.00 0 449 5 0 0
v_min_id_ord_sup 7022 7022 0 0.00 0 1186 7 0 0
v_min_non_paid_invoice 7470 7470 0 0.00 0 335 3 0 0
v_min_non_paid_realizn 9301 9301 0 0.00 0 492 3 0 0
v_our_firm 13710 13710 0 0.00 0 46 1 0 0
v_reserve_write_off 26158 26158 0 0.00 0 399 2 0 0
x_lock_depdocs_on_canc_invoice 8375 8375 0 0.00 0 889 9 0 0
x_lock_depdocs_on_canc_sup_ord 520 520 0 0.00 0 344 10 0 0
x_make_qstorno_1000_1200 7187 7187 0 0.00 1 2359 173 0 0
x_make_qstorno_1200_2000 7022 7022 0 0.00 1 4025 306 0 0
x_make_qstorno_2100_3300 273542 273542 0 0.00 0 3858 28 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2026 17:51:25 to 02-11-2026 17: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
17:01:07 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:08 299 2147483648 2604036960 2691145728 272355680 11.255 20 8 16 0 274955904 798480 1801744
17:03:08 273 2147483648 2596049232 2679992320 263566720 10.931 20 11 21 0 266438128 1170672 1700736
17:04:09 166 2147483648 2571679408 2651140096 239597568 10.037 20 9 18 1 242459536 1159360 1702608
17:05:10 118 2147483648 2597069568 2682941440 265430688 11.000 20 6 13 0 267616016 985056 1200272
17:06:10 334 2147483648 2575034080 2656841728 243389440 10.179 19 7 12 0 245862848 843472 1629936
17:07:11 336 2147483648 2597180144 2685030400 266646736 11.045 20 4 8 0 268621392 837424 1137232
17:08:11 292 2147483648 2584284512 2668392448 251931952 10.499 20 10 18 0 254785616 858320 1995344
17:09:12 175 2147483648 2599643680 2686164992 266583760 11.042 20 12 24 0 270740224 1449232 2707232
17:10:12 544 2147483648 2595344480 2682216448 262491424 10.891 20 10 20 0 266564048 1390736 2681888
17:11:13 175 2147483648 2592441472 2679922688 259898672 10.795 20 8 16 0 263054992 1328928 1827392
17:12:14 1024 2147483648 2604139760 2692345856 269701520 11.157 20 13 25 0 273681424 1740000 2239904
17:13:15 247 2147483648 2596249360 2686287872 264545744 10.967 20 9 16 0 267258768 1274080 1438944
17:14:15 425 2147483648 2597539248 2685956096 265183472 10.991 20 6 12 0 267981376 1164864 1633040
17:15:16 320 2147483648 2603284960 2691796992 270052432 11.170 20 11 23 0 274197184 1838928 2305824
17:16:17 181 2147483648 2595342704 2681495552 260927696 10.834 20 16 29 0 265760048 1951888 2880464
17:17:18 227 2147483648 2599294912 2686115840 263753808 10.938 20 12 25 0 267988480 1822960 2411712
17:18:19 190 2147483648 2597254288 2684329984 262661152 10.898 20 12 22 0 266647984 2016592 1970240
17:19:19 267 2147483648 2597190224 2687979520 266040464 11.022 20 5 11 0 267870224 869264 960496
17:20:20 334 2147483648 2599811104 2687930368 266389824 11.035 20 12 26 1 269904512 1132464 2382224
17:21:21 142 2147483648 2600924784 2689708032 267533984 11.077 20 9 18 0 271297392 1832688 1930720
17:22:21 805 2147483648 2597834496 2684907520 264345232 10.960 20 14 29 0 268332144 1221104 2765808
17:23:23 379 2147483648 2595056048 2682368000 260835248 10.830 20 6 12 0 263882256 1741696 1305312
17:24:24 292 2147483648 2594047328 2683281408 261509344 10.855 20 11 19 1 265007440 1171200 2326896
17:25:25 191 2147483648 2590997776 2678738944 258258864 10.735 20 13 25 0 262279376 1252576 2767936
17:26:25 227 2147483648 2596915040 2685898752 263628144 10.933 20 10 20 0 267231600 1173904 2429552
17:27:26 166 2147483648 2601897504 2689912832 265565616 11.005 20 14 28 0 271147200 2849824 2731760
17:28:26 152 2147483648 2599844848 2689708032 266742112 11.048 20 10 20 0 269865792 1150960 1972720
17:29:27 156 2147483648 2586522080 2672259072 251540352 10.485 20 8 16 0 256388176 3316064 1531760
17:30:31 1253 2147483648 2598234896 2686545920 263729024 10.937 20 11 22 0 268039136 2052672 2257440
17:31:32 295 2147483648 2602109952 2692571136 269344608 11.144 20 8 17 0 272329616 898848 2086160
17:32:33 436 2147483648 2601197632 2690048000 265741536 11.011 20 10 20 0 270934368 3377072 1815760
17:33:34 123 2147483648 2603521504 2692562944 268463568 11.112 20 13 27 0 273240848 1971392 2805888
17:34:34 656 2147483648 2598156512 2688241664 265256608 10.993 20 8 16 0 268077856 766944 2054304
17:35:35 107 2147483648 2591262048 2679152640 256214032 10.659 20 11 22 0 260461856 1867888 2379936
17:36:35 118 2147483648 2589466240 2676555776 254291616 10.587 20 12 24 0 259076576 2238016 2546944
17:37:36 366 2147483648 2593778320 2681217024 258223872 10.733 20 12 24 0 262894704 2564512 2106320
17:38:37 433 2147483648 2596079664 2684076032 261447200 10.853 20 11 22 0 265158544 1558416 2152928
17:39:37 246 2147483648 2579828384 2666860544 246865936 10.310 19 6 12 0 249656672 1764752 1025984
17:40:38 441 2147483648 2600424496 2688700416 263275376 10.920 20 13 26 0 269473856 3421232 2777248
17:41:39 236 2147483648 2596288640 2682003456 259116688 10.766 20 16 32 0 264758464 2375024 3266752
17:42:39 261 2147483648 2599888032 2688901120 265258400 10.994 20 13 25 0 269523632 1900704 2364528
17:43:40 182 2147483648 2592189360 2680401920 256729488 10.678 20 8 16 0 261678016 3433328 1515200
17:44:40 140 2147483648 2595193920 2684121088 261956192 10.872 20 12 25 1 265594256 1003536 2634528
17:45:41 689 2147483648 2602943408 2692128768 268238928 11.103 20 11 22 0 272074400 1965072 1870400
17:46:43 201 2147483648 2593118288 2683068416 259676128 10.787 20 6 12 0 262723936 2102784 945024
17:47:43 242 2147483648 2603895104 2694754304 268226240 11.103 20 14 28 0 272761984 2079328 2456416
17:48:44 232 2147483648 2602224384 2692767744 268203856 11.102 20 9 17 0 271412864 1456864 1752144
17:49:45 405 2147483648 2596338160 2684997632 261051184 10.838 20 14 28 0 264721616 1177456 2492976
17:50:45 190 2147483648 2594382656 2682732544 258618208 10.748 20 11 23 1 263798016 2976288 2203520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 02-11-2026 17:51:30 to 02-11-2026 17: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 02-11-2026 17:51:45 to 02-11-2026 17: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          187617
MON$OLDEST_ACTIVE               188158
MON$OLDEST_SNAPSHOT             188158
MON$NEXT_TRANSACTION            188158
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-02 17:00:11.0120
MON$PAGES                       117344
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  2 17:51:03 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Mon Nov  2 17:51:04 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Mon Nov  2 17:51:05 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
:18: 
:19: test-0    Mon Nov  2 17:51:05 2026
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:21: 
--- end of diff output ---

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

02.11.26 17: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-02 17:51:48 No severe PSQL-related problems occured
02.11.26 17:51:49. End of report.