Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.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 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 4d
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 1888368 kB
MemAvailable 7254928 kB
Buffers 86208 kB
Cached 5366976 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-04 05:50:57
DTS_END                         2026-11-04 05:50:57.1270
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/58850
TRN_ID                          224555
ATT_ID                          461
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: 15063.86 924 753193
customer order: creation 659.52 45 32976
customer order: refuse 53.88 48 2694
order to supplier: creation 171.32 201 8566
order to supplier: removal 13.24 8711 662
invoice (draft): creation 169.22 344 8461
invoice (draft): removal 125.24 146 6262
invoice accept: apply 143.54 1618 7177
invoice accept: cancel 103.64 207 5182
customer reserve: creation 7139.48 27 356974
customer reserve: removal 5459.88 15 272994
realization accept: apply 310.02 38 15501
realization accept: cancel 180.50 19 9025
payment from customer: creation 221.10 37 11055
payment from customer: removal 20.88 18 1044
payment to supplier: creation 182.04 31 9102
payment to supplier: removal 12.78 16 639
service: total inventory turnovers 38.38 427 1919
service: total monetary turnovers 53.82 7 2691
service: aggregate perf. data 5.34 1709 267
service: refresh index statistics 0.04 4817 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 04-11-2026 05:51:08 to 04-11-2026 05:51:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8110
TEST_TIME 2 9925
TEST_TIME 3 10932
TEST_TIME 4 11649
TEST_TIME 5 11860
TEST_TIME 6 12207
TEST_TIME 7 12504
TEST_TIME 8 12817
TEST_TIME 9 12970
TEST_TIME 10 13038
TEST_TIME 11 13211
TEST_TIME 12 13322
TEST_TIME 13 13454
TEST_TIME 14 13488
TEST_TIME 15 13573
TEST_TIME 16 13580
TEST_TIME 17 13780
TEST_TIME 18 13699
TEST_TIME 19 13941
TEST_TIME 20 13941
TEST_TIME 21 13964
TEST_TIME 22 14102
TEST_TIME 23 14037
TEST_TIME 24 14119
TEST_TIME 25 14035
TEST_TIME 26 14138
TEST_TIME 27 14165
TEST_TIME 28 14177
TEST_TIME 29 14214
TEST_TIME 30 14141
TEST_TIME 31 14161
TEST_TIME 32 14194
TEST_TIME 33 14337
TEST_TIME 34 14306
TEST_TIME 35 14341
TEST_TIME 36 14471
TEST_TIME 37 14551
TEST_TIME 38 14587
TEST_TIME 39 14672
TEST_TIME 40 14727
TEST_TIME 41 14728
TEST_TIME 42 14784
TEST_TIME 43 14861
TEST_TIME 44 14819
TEST_TIME 45 14916
TEST_TIME 46 14927
TEST_TIME 47 15010
TEST_TIME 48 15022
TEST_TIME 49 15087
TEST_TIME 50 15064

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2026 05:51:10 to 04-11-2026 05:51:13.

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 1105063 1105063 0 0.00 0 1287 2 0 0
doc_list_biud 1105063 1105063 0 0.00 0 1592 5 0 0
sp_add_invoice_to_stock 7177 7177 0 0.00 11 11641 1618 0 0
sp_cancel_adding_invoice 5182 5182 0 0.00 3 4449 207 0 0
sp_cancel_client_order 2694 2694 0 0.00 3 897 48 0 0
sp_cancel_customer_reserve 272994 272994 0 0.00 1 1425 15 0 0
sp_cancel_pay_from_customer 1044 1044 0 0.00 2 503 19 0 0
sp_cancel_pay_to_supplier 639 639 0 0.00 2 140 17 0 0
sp_cancel_supplier_invoice 6262 6262 0 0.00 2 1303 147 0 0
sp_cancel_supplier_order 662 662 0 0.00 7 60986 8711 0 0
sp_cancel_write_off 9025 9025 0 0.00 1 675 19 0 0
sp_client_order 32976 32976 0 0.00 4 1509 45 0 0
sp_customer_reserve 356974 356974 0 0.00 0 2314 28 0 0
sp_fill_shopping_cart 50003 50003 0 0.00 1 2944 20 0 0
sp_fill_shopping_cart_clo_res 356974 356974 0 0.00 0 1231 3 0 0
sp_get_clo_for_invoice 7177 7177 0 0.00 0 2255 38 0 0
sp_kill_cost_storno 15890 15890 0 0.00 0 555 9 0 0
sp_kill_qstorno_ret_qs2qd 561937 561937 0 0.00 0 1590 8 0 0
sp_kill_qty_storno 319497 319497 0 0.00 0 1592 17 0 0
sp_lock_selected_doc 31550 31550 0 0.00 0 336 2 0 0
sp_make_cost_storno 42835 42835 0 0.00 0 1085 6 0 0
sp_multiply_rows_for_pdistr 42835 42835 0 0.00 0 399 10 0 0
sp_multiply_rows_for_qdistr 32976 32976 0 0.00 0 1184 17 0 0
sp_pay_from_customer 11055 11055 0 0.00 3 1108 38 0 0
sp_pay_to_supplier 9102 9102 0 0.00 3 989 31 0 0
sp_payment_common 20157 20157 0 0.00 1 559 11 0 0
sp_qd_handle_on_cancel_clo 2694 2694 0 0.00 0 864 31 0 0
sp_qd_handle_on_invoice_upd_sts 12359 12359 0 0.00 0 1289 68 0 0
sp_qd_handle_on_reserve_upd_sts 15501 15501 0 0.00 0 1159 11 0 0
sp_reserve_write_off 15501 15501 0 0.00 3 1169 39 0 0
sp_supplier_invoice 8461 8461 0 0.00 6 6040 345 0 0
sp_supplier_order 8566 8566 0 0.00 5 1912 201 0 0
srv_aggregate_perf_data 267 267 0 0.00 24 18254 1710 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 1542 297 0 0
srv_find_qd_qs_mism 701360 701360 0 0.00 0 1287 1 0 0
srv_make_invnt_saldo 1919 1919 0 0.00 3 75648 427 0 0
srv_make_money_saldo 2691 2691 0 0.00 0 408 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 512 9122 4817 0 0
v_add_invoice_to_stock 14354 14354 0 0.00 0 375 3 0 0
v_all_customers 50178 50178 0 0.00 0 37 1 0 0
v_all_suppliers 42202 42202 0 0.00 0 41 1 0 0
v_all_wares 65952 65952 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 1252 1252 0 0.00 0 144 2 0 0
v_cancel_client_order 5388 5388 0 0.00 0 282 1 0 0
v_cancel_customer_prepayment 2088 2088 0 0.00 0 73 1 0 0
v_cancel_customer_reserve 2216 2216 0 0.00 0 144 2 0 0
v_cancel_payment_to_supplier 1278 1278 0 0.00 0 71 1 0 0
v_cancel_supplier_invoice 1114 1114 0 0.00 0 333 4 0 0
v_cancel_supplier_order 1324 1324 0 0.00 0 812 2 0 0
v_cancel_write_off 3084 3084 0 0.00 0 289 2 0 0
v_max_id_clo_ord 8566 8566 0 0.00 0 90 1 0 0
v_max_id_clo_res 1492 1492 0 0.00 0 135 1 0 0
v_max_id_ord_sup 8461 8461 0 0.00 0 992 2 0 0
v_max_non_paid_invoice 5028 5028 0 0.00 0 153 2 0 0
v_max_non_paid_realizn 10610 10610 0 0.00 0 179 2 0 0
v_min_id_clo_ord 8566 8566 0 0.00 0 181 3 0 0
v_min_id_clo_res 1492 1492 0 0.00 0 542 4 0 0
v_min_id_ord_sup 8461 8461 0 0.00 0 928 5 0 0
v_min_non_paid_invoice 9102 9102 0 0.00 0 379 4 0 0
v_min_non_paid_realizn 11055 11055 0 0.00 0 379 8 0 0
v_our_firm 16664 16664 0 0.00 0 30 1 0 0
v_reserve_write_off 31002 31002 0 0.00 0 416 1 0 0
x_lock_depdocs_on_canc_invoice 10887 10887 0 0.00 0 666 9 0 0
x_lock_depdocs_on_canc_sup_ord 662 662 0 0.00 0 130 9 0 0
x_make_qstorno_1000_1200 8566 8566 0 0.00 1 1888 146 0 0
x_make_qstorno_1200_2000 8461 8461 0 0.00 1 4222 304 0 0
x_make_qstorno_2100_3300 356974 356974 0 0.00 0 2308 24 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2026 05:51:13 to 04-11-2026 05:51:17.

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:01:00 4 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:02:01 235 2147483648 2570857328 2649161728 239549888 10.035 19 10 18 1 242194976 682144 1962944
05:03:01 347 2147483648 2605145248 2690830336 272227344 11.250 20 10 16 1 275138112 890352 2020416
05:04:02 151 2147483648 2603386032 2689302528 270695696 11.194 20 13 26 0 274537840 1125008 2717136
05:05:02 174 2147483648 2574662352 2658934784 244864336 10.235 19 8 18 0 247671952 1052640 1754976
05:06:03 245 2147483648 2596457520 2683248640 264308432 10.959 20 12 22 0 267489584 946112 2235040
05:07:03 250 2147483648 2598652496 2685767680 264458368 10.964 20 13 26 0 269098480 1927216 2712896
05:08:04 227 2147483648 2595575824 2682753024 262130112 10.878 20 8 16 1 265838848 1954480 1754256
05:09:05 652 2147483648 2595081584 2682179584 262369648 10.887 20 14 26 0 266323296 1394256 2559392
05:10:06 170 2147483648 2594979568 2681184256 261621472 10.859 20 11 22 0 265528688 1524288 2382928
05:11:06 215 2147483648 2594649248 2680463360 259531472 10.782 20 12 25 0 264657408 2297824 2828112
05:12:06 104 2147483648 2599095040 2685906944 264255232 10.957 20 13 26 0 268763984 1663232 2845520
05:13:07 1542 2147483648 2595051520 2679816192 249393632 10.404 19 11 22 0 252893264 1193072 2306560
05:14:09 88 2147483648 2602535120 2689974272 267573136 11.079 20 12 24 0 272290960 2310176 2407648
05:15:10 203 2147483648 2600608032 2688835584 265765936 11.012 20 13 26 0 269578048 1576688 2235424
05:16:11 258 2147483648 2583295024 2669359104 250764624 10.456 19 7 13 0 253410848 1299664 1346560
05:17:11 456 2147483648 2595517040 2681192448 260096608 10.803 20 10 20 0 263421280 1561216 1763456
05:18:12 222 2147483648 2601896864 2689093632 266888096 11.054 20 11 23 0 270012416 878048 2246272
05:19:13 133 2147483648 2603497664 2691145728 266658112 11.045 20 13 28 0 272790176 3058512 3073552
05:20:13 194 2147483648 2586452048 2672017408 252303200 10.513 20 11 22 0 256196704 1451216 2442288
05:21:14 179 2147483648 2597439088 2684215296 262026368 10.874 20 12 24 0 266573696 2326736 2220592
05:22:15 219 2147483648 2599659248 2687213568 263975456 10.946 20 12 24 0 269066272 2492080 2598736
05:23:15 261 2147483648 2598877072 2688729088 264998640 10.984 20 10 20 0 269038416 1796640 2243136
05:24:16 131 2147483648 2598368704 2685255680 260577296 10.821 20 12 25 0 267910912 5136080 2197536
05:25:17 97 2147483648 2598537248 2686369792 263598688 10.932 20 12 24 0 268377600 1927328 2851584
05:26:17 242 2147483648 2597301616 2683617280 261066720 10.839 20 14 28 0 266033008 2340000 2626288
05:27:17 406 2147483648 2596377984 2683666432 261136032 10.841 20 10 20 0 265957552 2081280 2740240
05:28:19 779 2147483648 2599783152 2689191936 264502896 10.966 20 11 22 0 269799712 2916688 2380128
05:29:21 135 2147483648 2604659632 2692284416 268283744 11.105 20 16 32 0 273302736 2209616 2809376
05:30:21 73 2147483648 2599347216 2690265088 266686672 11.046 20 6 12 0 269204672 1320880 1197120
05:31:22 199 2147483648 2603807072 2691031040 267633936 11.081 20 15 30 0 272551088 2069088 2848064
05:32:22 455 2147483648 2596386560 2685788160 263900992 10.943 20 9 20 0 267361584 1110224 2350368
05:33:23 148 2147483648 2608159680 2696273920 269885760 11.164 20 16 31 0 275294784 2615584 2793440
05:34:23 1273 2147483648 2596394384 2686648320 261981520 10.873 20 9 18 0 265725760 2016736 1727504
05:35:25 158 2147483648 2591342304 2679541760 257196192 10.695 20 10 20 1 260813552 1676384 1940976
05:36:25 514 2147483648 2599277248 2686038016 262949072 10.908 20 13 26 0 267139520 1728048 2462400
05:37:26 291 2147483648 2594573728 2682617856 260579632 10.821 20 9 18 0 263736032 1683136 1473264
05:38:27 108 2147483648 2599573536 2688184320 265249344 10.993 20 11 23 0 269039056 966368 2823344
05:39:27 127 2147483648 2602221440 2691215360 264135680 10.952 20 15 29 0 270564992 3638560 2790752
05:40:27 221 2147483648 2601118544 2689662976 263634912 10.934 20 13 26 0 268376848 2278816 2463120
05:41:28 223 2147483648 2595207072 2684776448 261132576 10.841 20 11 24 0 264090096 809312 2148208
05:42:28 455 2147483648 2603780480 2695704576 268927840 11.129 20 8 14 1 272759456 2101328 1730288
05:43:29 219 2147483648 2601405184 2690121728 263712320 10.936 20 13 26 0 269551232 3188976 2649936
05:44:29 537 2147483648 2584546144 2673307648 252423936 10.518 19 7 15 0 254825808 1181216 1220656
05:45:30 197 2147483648 2606732832 2697510912 269713888 11.158 20 10 20 0 275034432 3129152 2191392
05:46:30 150 2147483648 2595757440 2684182528 260244464 10.808 20 14 28 1 265404512 2322128 2837920
05:47:32 153 2147483648 2601229696 2691137536 264537088 10.967 20 11 22 0 270845808 3562640 2746080
05:48:32 233 2147483648 2598598816 2688143360 262880448 10.906 20 12 23 0 267048816 1946608 2221760
05:49:33 186 2147483648 2609716800 2699415552 269455840 11.148 20 15 30 0 278524896 5583552 3485504
05:50:33 494 2147483648 2595546368 2685370368 260889744 10.832 20 10 19 0 264527776 1942848 1695184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 04-11-2026 05:51:17 to 04-11-2026 05:51:29.

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 04-11-2026 05:51:30 to 04-11-2026 05:51:31.

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          222639
MON$OLDEST_ACTIVE               224730
MON$OLDEST_SNAPSHOT             224730
MON$NEXT_TRANSACTION            224730
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-04 05:00:10.2920
MON$PAGES                       137216
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    Wed Nov  4 05:50:57 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov  4 05:50:57 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Wed Nov  4 05:50:58 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
--- end of diff output ---

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

04.11.26 05:51:31. 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-04 05:51:32 No severe PSQL-related problems occured
04.11.26 05:51:33. End of report.