Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.11.2026 05:50
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 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 2022988 kB
MemAvailable 7259556 kB
Buffers 91524 kB
Cached 5247920 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-09 05:50:54
DTS_END                         2026-11-09 05:50:54.3330
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/36670
TRN_ID                          230275
ATT_ID                          472
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: 15336.40 986 766820
customer order: creation 687.58 43 34379
customer order: refuse 55.98 47 2799
order to supplier: creation 175.58 200 8779
order to supplier: removal 12.62 9150 631
invoice (draft): creation 173.78 343 8689
invoice (draft): removal 123.94 147 6197
invoice accept: apply 150.18 1540 7509
invoice accept: cancel 104.32 213 5216
customer reserve: creation 7336.18 27 366809
customer reserve: removal 5474.54 15 273727
realization accept: apply 319.08 34 15954
realization accept: cancel 179.28 19 8964
payment from customer: creation 230.24 30 11512
payment from customer: removal 21.06 18 1053
payment to supplier: creation 183.36 28 9168
payment to supplier: removal 13.02 16 651
service: total inventory turnovers 37.28 488 1864
service: total monetary turnovers 53.00 8 2650
service: aggregate perf. data 5.34 1734 267
service: refresh index statistics 0.04 5615 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9205
TEST_TIME 2 11023
TEST_TIME 3 11790
TEST_TIME 4 12557
TEST_TIME 5 12758
TEST_TIME 6 13055
TEST_TIME 7 13339
TEST_TIME 8 13423
TEST_TIME 9 13613
TEST_TIME 10 13700
TEST_TIME 11 13679
TEST_TIME 12 13898
TEST_TIME 13 13929
TEST_TIME 14 14029
TEST_TIME 15 14166
TEST_TIME 16 14017
TEST_TIME 17 14210
TEST_TIME 18 14217
TEST_TIME 19 14147
TEST_TIME 20 14162
TEST_TIME 21 14274
TEST_TIME 22 14252
TEST_TIME 23 14287
TEST_TIME 24 14287
TEST_TIME 25 14336
TEST_TIME 26 14309
TEST_TIME 27 14302
TEST_TIME 28 14376
TEST_TIME 29 14384
TEST_TIME 30 14391
TEST_TIME 31 14448
TEST_TIME 32 14460
TEST_TIME 33 14522
TEST_TIME 34 14695
TEST_TIME 35 14692
TEST_TIME 36 14734
TEST_TIME 37 14755
TEST_TIME 38 14862
TEST_TIME 39 14844
TEST_TIME 40 14930
TEST_TIME 41 15004
TEST_TIME 42 15037
TEST_TIME 43 15071
TEST_TIME 44 15028
TEST_TIME 45 15183
TEST_TIME 46 15203
TEST_TIME 47 15229
TEST_TIME 48 15324
TEST_TIME 49 15332
TEST_TIME 50 15336

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 09-11-2026 05:51:11 to 09-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 1130641 1130641 0 0.00 0 765 2 0 0
doc_list_biud 1130641 1130641 0 0.00 0 1826 5 0 0
sp_add_invoice_to_stock 7509 7509 0 0.00 9 12713 1540 0 0
sp_cancel_adding_invoice 5216 5216 0 0.00 3 5247 214 0 0
sp_cancel_client_order 2799 2799 0 0.00 3 617 48 0 0
sp_cancel_customer_reserve 273727 273727 0 0.00 1 1223 15 0 0
sp_cancel_pay_from_customer 1053 1053 0 0.00 2 414 19 0 0
sp_cancel_pay_to_supplier 651 651 0 0.00 2 331 16 0 0
sp_cancel_supplier_invoice 6197 6197 0 0.00 2 1651 148 0 0
sp_cancel_supplier_order 631 631 0 0.00 7 61178 9150 0 0
sp_cancel_write_off 8964 8964 0 0.00 1 891 20 0 0
sp_client_order 34379 34379 0 0.00 4 1545 44 0 0
sp_customer_reserve 366809 366809 0 0.00 0 2702 27 0 0
sp_fill_shopping_cart 51847 51847 0 0.00 1 2337 20 0 0
sp_fill_shopping_cart_clo_res 366809 366809 0 0.00 0 1038 2 0 0
sp_get_clo_for_invoice 7509 7509 0 0.00 0 1643 36 0 0
sp_kill_cost_storno 15884 15884 0 0.00 0 632 8 0 0
sp_kill_qstorno_ret_qs2qd 563246 563246 0 0.00 0 1824 8 0 0
sp_kill_qty_storno 320997 320997 0 0.00 0 1826 18 0 0
sp_lock_selected_doc 32535 32535 0 0.00 0 656 2 0 0
sp_make_cost_storno 44143 44143 0 0.00 0 455 7 0 0
sp_multiply_rows_for_pdistr 44143 44143 0 0.00 0 358 9 0 0
sp_multiply_rows_for_qdistr 34379 34379 0 0.00 0 1521 17 0 0
sp_pay_from_customer 11512 11512 0 0.00 3 515 31 0 0
sp_pay_to_supplier 9168 9168 0 0.00 3 512 28 0 0
sp_payment_common 20680 20680 0 0.00 1 490 7 0 0
sp_qd_handle_on_cancel_clo 2799 2799 0 0.00 0 610 31 0 0
sp_qd_handle_on_invoice_upd_sts 12725 12725 0 0.00 0 1303 71 0 0
sp_qd_handle_on_reserve_upd_sts 15954 15954 0 0.00 0 972 10 0 0
sp_reserve_write_off 15954 15954 0 0.00 3 983 35 0 0
sp_supplier_invoice 8689 8689 0 0.00 5 3632 344 0 0
sp_supplier_order 8779 8779 0 0.00 6 1716 201 0 0
srv_aggregate_perf_data 267 267 0 0.00 51 9747 1735 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1262 244 0 0
srv_find_qd_qs_mism 714627 714627 0 0.00 0 764 1 0 0
srv_make_invnt_saldo 1864 1864 0 0.00 0 80625 489 0 0
srv_make_money_saldo 2650 2650 0 0.00 0 651 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 375 10856 5616 0 0
v_add_invoice_to_stock 15018 15018 0 0.00 0 441 3 0 0
v_all_customers 52310 52310 0 0.00 0 55 1 0 0
v_all_suppliers 42032 42032 0 0.00 0 31 1 0 0
v_all_wares 68758 68758 0 0.00 0 44 1 0 0
v_cancel_adding_invoice 1300 1300 0 0.00 0 151 2 0 0
v_cancel_client_order 5598 5598 0 0.00 0 231 1 0 0
v_cancel_customer_prepayment 2106 2106 0 0.00 0 407 2 0 0
v_cancel_customer_reserve 2272 2272 0 0.00 0 427 2 0 0
v_cancel_payment_to_supplier 1302 1302 0 0.00 0 201 2 0 0
v_cancel_supplier_invoice 1136 1136 0 0.00 0 111 3 0 0
v_cancel_supplier_order 1262 1262 0 0.00 0 395 2 0 0
v_cancel_write_off 3168 3168 0 0.00 0 583 2 0 0
v_max_id_clo_ord 8779 8779 0 0.00 0 85 1 0 0
v_max_id_clo_res 1541 1541 0 0.00 0 28 1 0 0
v_max_id_ord_sup 8689 8689 0 0.00 0 541 2 0 0
v_max_non_paid_invoice 5620 5620 0 0.00 0 41 1 0 0
v_max_non_paid_realizn 11266 11266 0 0.00 0 35 1 0 0
v_min_id_clo_ord 8779 8779 0 0.00 0 239 3 0 0
v_min_id_clo_res 1541 1541 0 0.00 0 319 3 0 0
v_min_id_ord_sup 8689 8689 0 0.00 0 968 5 0 0
v_min_non_paid_invoice 9168 9168 0 0.00 0 328 3 0 0
v_min_non_paid_realizn 11512 11512 0 0.00 0 193 2 0 0
v_our_firm 16940 16940 0 0.00 0 24 1 0 0
v_reserve_write_off 31908 31908 0 0.00 0 641 1 0 0
x_lock_depdocs_on_canc_invoice 10845 10845 0 0.00 0 570 9 0 0
x_lock_depdocs_on_canc_sup_ord 631 631 0 0.00 0 130 11 0 0
x_make_qstorno_1000_1200 8779 8779 0 0.00 1 1707 145 0 0
x_make_qstorno_1200_2000 8689 8689 0 0.00 1 3509 300 0 0
x_make_qstorno_2100_3300 366809 366809 0 0.00 0 2700 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2026 05:51:13 to 09-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:00:58 3 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:01:58 169 2147483648 2541677312 2615341056 212560064 9.006 19 5 9 0 214472176 487312 1424800
05:02:58 130 2147483648 2581796832 2664824832 250410960 10.442 19 10 19 0 253015568 840352 1764256
05:03:59 120 2147483648 2604735792 2690555904 273591936 11.300 20 15 26 2 278281440 1240944 3448560
05:04:59 232 2147483648 2599207216 2683637760 264053792 10.949 20 16 34 1 269321344 1487040 3780512
05:05:59 106 2147483648 2591850720 2677108736 258363872 10.738 20 13 26 0 262459920 1330192 2765856
05:07:00 178 2147483648 2599235920 2687086592 265677424 11.009 20 9 18 1 269000160 1566080 1756656
05:08:00 187 2147483648 2594276848 2680918016 261489616 10.854 20 14 26 1 264575952 890352 2195984
05:09:01 509 2147483648 2597399616 2683514880 261300896 10.847 20 15 30 0 265758032 1588816 2868320
05:10:02 140 2147483648 2603927728 2692661248 269090272 11.135 20 13 24 0 273704224 2143424 2470528
05:11:02 244 2147483648 2594928432 2680791040 261133808 10.841 20 10 20 0 264845472 1967712 1743952
05:12:03 116 2147483648 2599268512 2686246912 264676704 10.972 20 13 24 0 268721024 1373296 2671024
05:13:03 137 2147483648 2592415168 2677805056 256295616 10.662 20 16 28 0 259757984 1343888 2118480
05:14:03 118 2147483648 2605751440 2693668864 269955088 11.166 20 14 28 0 274696960 1978912 2762960
05:15:04 452 2147483648 2585003232 2672005120 253060272 10.541 20 9 16 1 255439264 1161984 1217008
05:16:04 272 2147483648 2601840416 2690744320 267648592 11.082 20 9 18 0 271702832 2179536 1874704
05:17:05 230 2147483648 2606139216 2694168576 268872592 11.127 20 14 28 0 275216896 3525216 2819088
05:18:05 296 2147483648 2595573408 2680475648 259495312 10.780 20 14 28 0 263862512 1377824 2989376
05:19:06 425 2147483648 2599036048 2687754240 265496048 11.002 20 13 26 0 269270112 936976 2837088
05:20:07 808 2147483648 2600728320 2688270336 265685280 11.009 20 10 20 0 269080416 1268368 2126768
05:21:08 211 2147483648 2599226800 2686107648 263723888 10.937 20 16 32 1 269802784 2904512 3174384
05:22:08 126 2147483648 2598235584 2685526016 261579600 10.858 20 13 26 0 267107488 3052784 2475104
05:23:09 146 2147483648 2588248704 2672066560 250915200 10.461 19 16 32 0 255315408 1520048 2880160
05:24:09 421 2147483648 2597048432 2687991808 264613152 10.970 20 6 12 0 267629552 2041296 975104
05:25:10 161 2147483648 2599193712 2689171456 267293632 11.069 20 7 14 0 270375664 1629824 1452208
05:26:10 146 2147483648 2601769072 2690510848 266503584 11.039 20 13 25 0 271286384 2086192 2696608
05:27:11 126 2147483648 2599420688 2687860736 265162496 10.990 20 8 14 0 269843104 2593568 2087040
05:28:11 153 2147483648 2606963744 2693574656 269265312 11.141 20 15 30 0 276793920 4239904 3288704
05:29:13 226 2147483648 2597708304 2686492672 263805936 10.940 20 10 20 0 266888704 1497680 1585088
05:30:13 192 2147483648 2595064656 2680709120 260108048 10.803 20 14 23 0 264074112 1812112 2153952
05:31:14 180 2147483648 2603108768 2690732032 266001440 11.021 20 12 24 0 271789600 3434144 2354016
05:32:14 163 2147483648 2607433504 2698383360 273956368 11.313 20 11 22 0 277380752 1261920 2162464
05:33:14 116 2147483648 2591958304 2679439360 255343056 10.626 20 13 26 0 260175024 2199120 2632848
05:34:15 123 2147483648 2602138880 2691018752 263736960 10.937 20 10 20 0 271098912 5387104 1974848
05:35:15 414 2147483648 2599654960 2688958464 264641488 10.971 20 13 24 0 269585840 2318384 2625968
05:36:17 93 2147483648 2583494256 2669133824 248891328 10.386 19 13 26 0 252920352 1382256 2646768
05:37:18 182 2147483648 2594283600 2684051456 261073472 10.839 20 8 16 0 264394080 1512864 1807744
05:38:18 1256 2147483648 2601258224 2691145728 265934944 11.019 20 9 18 0 269753936 1899600 1919392
05:39:20 204 2147483648 2592165408 2678067200 251895536 10.498 19 17 34 0 257280384 2294768 3090080
05:40:20 183 2147483648 2593853552 2680512512 256506016 10.670 20 13 26 0 261784224 2917408 2360800
05:41:21 418 2147483648 2597318576 2686304256 261167936 10.842 20 13 26 0 266074272 2300688 2605648
05:42:21 248 2147483648 2605481552 2693976064 268802544 11.124 20 14 26 1 273191072 1582768 2805760
05:43:22 118 2147483648 2602576784 2692317184 266613952 11.044 20 12 22 1 271890768 2960432 2316384
05:44:22 162 2147483648 2582371808 2670473216 248772960 10.381 19 6 12 0 251055968 1390288 892720
05:45:23 119 2147483648 2601983104 2691801088 264459152 10.964 20 12 23 0 269501328 2904144 2138032
05:46:23 142 2147483648 2598858848 2687983616 265083312 10.987 20 8 16 0 267844752 1404928 1356512
05:47:24 165 2147483648 2599810832 2689888256 264568992 10.968 20 9 18 0 268443264 2007552 1866720
05:48:24 139 2147483648 2598402288 2688073728 262471680 10.891 20 10 18 0 267326048 3096112 1758256
05:49:24 566 2147483648 2600116208 2690273280 264855376 10.979 20 8 17 0 269495184 2438816 2200992
05:50:25 221 2147483648 2601178720 2692722688 266741440 11.048 20 10 20 0 271261680 1841568 2678672

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 09-11-2026 05:51:18 to 09-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 09-11-2026 05:51:30 to 09-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          230274
MON$OLDEST_ACTIVE               231478
MON$OLDEST_SNAPSHOT             231478
MON$NEXT_TRANSACTION            231478
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 05:00:09.3340
MON$PAGES                       157184
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 05:50:55 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Mon Nov  9 05:50:55 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Mon Nov  9 05:50:55 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'

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