Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.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 6d
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 2049664 kB
MemAvailable 7377276 kB
Buffers 89536 kB
Cached 5324576 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-06 05:50:59
DTS_END                         2026-11-06 05:50:59.2790
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(229:18) ==> SP_CANCEL_SUPPLIER_INVOICE(54:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/33290
TRN_ID                          224628
ATT_ID                          456
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: 15046.48 914 752324
customer order: creation 665.18 46 33259
customer order: refuse 55.30 49 2765
order to supplier: creation 170.18 205 8509
order to supplier: removal 13.10 8678 655
invoice (draft): creation 170.82 351 8541
invoice (draft): removal 125.30 143 6265
invoice accept: apply 142.44 1604 7122
invoice accept: cancel 101.16 215 5058
customer reserve: creation 7183.32 27 359166
customer reserve: removal 5385.72 15 269286
realization accept: apply 313.24 36 15662
realization accept: cancel 183.70 19 9185
payment from customer: creation 221.64 33 11082
payment from customer: removal 19.60 20 980
payment to supplier: creation 184.82 29 9241
payment to supplier: removal 12.48 17 624
service: total inventory turnovers 39.50 457 1975
service: total monetary turnovers 54.08 8 2704
service: aggregate perf. data 4.86 2062 243
service: refresh index statistics 0.04 4263 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-11-2026 05:51:13 to 06-11-2026 05:51:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7033
TEST_TIME 2 9346
TEST_TIME 3 10542
TEST_TIME 4 11307
TEST_TIME 5 11866
TEST_TIME 6 12311
TEST_TIME 7 12704
TEST_TIME 8 12781
TEST_TIME 9 12982
TEST_TIME 10 13149
TEST_TIME 11 13281
TEST_TIME 12 13422
TEST_TIME 13 13487
TEST_TIME 14 13578
TEST_TIME 15 13606
TEST_TIME 16 13752
TEST_TIME 17 13779
TEST_TIME 18 13895
TEST_TIME 19 13848
TEST_TIME 20 13990
TEST_TIME 21 14063
TEST_TIME 22 14100
TEST_TIME 23 14080
TEST_TIME 24 14191
TEST_TIME 25 14213
TEST_TIME 26 14166
TEST_TIME 27 14219
TEST_TIME 28 14276
TEST_TIME 29 14284
TEST_TIME 30 14250
TEST_TIME 31 14259
TEST_TIME 32 14234
TEST_TIME 33 14262
TEST_TIME 34 14376
TEST_TIME 35 14394
TEST_TIME 36 14465
TEST_TIME 37 14492
TEST_TIME 38 14581
TEST_TIME 39 14688
TEST_TIME 40 14723
TEST_TIME 41 14689
TEST_TIME 42 14751
TEST_TIME 43 14777
TEST_TIME 44 14820
TEST_TIME 45 14886
TEST_TIME 46 14894
TEST_TIME 47 14976
TEST_TIME 48 14996
TEST_TIME 49 15060
TEST_TIME 50 15046

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 06-11-2026 05:51:16 to 06-11-2026 05:51:18.

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 1104707 1104707 0 0.00 0 1036 2 0 0
doc_list_biud 1104707 1104707 0 0.00 0 1561 5 0 0
sp_add_invoice_to_stock 7122 7122 0 0.00 7 13352 1605 0 0
sp_cancel_adding_invoice 5058 5058 0 0.00 2 3723 215 0 0
sp_cancel_client_order 2765 2765 0 0.00 3 1278 50 0 0
sp_cancel_customer_reserve 269286 269286 0 0.00 1 1514 15 0 0
sp_cancel_pay_from_customer 980 980 0 0.00 2 479 20 0 0
sp_cancel_pay_to_supplier 624 624 0 0.00 2 236 17 0 0
sp_cancel_supplier_invoice 6265 6265 0 0.00 2 912 143 0 0
sp_cancel_supplier_order 655 655 0 0.00 4 50361 8678 0 0
sp_cancel_write_off 9185 9185 0 0.00 1 616 19 0 0
sp_client_order 33259 33259 0 0.00 4 2186 47 0 0
sp_customer_reserve 359166 359166 0 0.00 0 2008 27 0 0
sp_fill_shopping_cart 50309 50309 0 0.00 1 1682 20 0 0
sp_fill_shopping_cart_clo_res 359166 359166 0 0.00 0 1396 2 0 0
sp_get_clo_for_invoice 7122 7122 0 0.00 0 1915 38 0 0
sp_kill_cost_storno 15847 15847 0 0.00 0 489 9 0 0
sp_kill_qstorno_ret_qs2qd 554677 554677 0 0.00 0 1508 8 0 0
sp_kill_qty_storno 315998 315998 0 0.00 0 1561 18 0 0
sp_lock_selected_doc 31589 31589 0 0.00 0 501 2 0 0
sp_make_cost_storno 43107 43107 0 0.00 0 1007 7 0 0
sp_multiply_rows_for_pdistr 43107 43107 0 0.00 0 803 10 0 0
sp_multiply_rows_for_qdistr 33259 33259 0 0.00 0 2156 18 0 0
sp_pay_from_customer 11082 11082 0 0.00 3 1281 34 0 0
sp_pay_to_supplier 9241 9241 0 0.00 3 1210 30 0 0
sp_payment_common 20323 20323 0 0.00 1 455 7 0 0
sp_qd_handle_on_cancel_clo 2765 2765 0 0.00 0 1273 33 0 0
sp_qd_handle_on_invoice_upd_sts 12180 12180 0 0.00 0 1560 71 0 0
sp_qd_handle_on_reserve_upd_sts 15662 15662 0 0.00 0 1003 10 0 0
sp_reserve_write_off 15662 15662 0 0.00 3 1200 37 0 0
sp_supplier_invoice 8541 8541 0 0.00 5 3680 352 0 0
sp_supplier_order 8509 8509 0 0.00 5 2009 205 0 0
srv_aggregate_perf_data 243 243 0 0.00 8 34025 2062 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1028 276 0 0
srv_find_qd_qs_mism 699389 699389 0 0.00 0 1036 1 0 0
srv_make_invnt_saldo 1975 1975 0 0.00 0 108079 458 0 0
srv_make_money_saldo 2704 2704 0 0.00 0 250 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 252 8274 4263 0 0
v_add_invoice_to_stock 14244 14244 0 0.00 0 498 3 0 0
v_all_customers 51086 51086 0 0.00 0 48 1 0 0
v_all_suppliers 42798 42798 0 0.00 0 30 1 0 0
v_all_wares 66518 66518 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 1282 1282 0 0.00 0 463 2 0 0
v_cancel_client_order 5530 5530 0 0.00 0 397 1 0 0
v_cancel_customer_prepayment 1960 1960 0 0.00 0 477 2 0 0
v_cancel_customer_reserve 2120 2120 0 0.00 0 191 2 0 0
v_cancel_payment_to_supplier 1248 1248 0 0.00 0 27 1 0 0
v_cancel_supplier_invoice 1182 1182 0 0.00 0 149 3 0 0
v_cancel_supplier_order 1310 1310 0 0.00 0 220 2 0 0
v_cancel_write_off 2978 2978 0 0.00 0 185 2 0 0
v_max_id_clo_ord 8509 8509 0 0.00 0 182 1 0 0
v_max_id_clo_res 1588 1588 0 0.00 0 318 2 0 0
v_max_id_ord_sup 8541 8541 0 0.00 0 338 2 0 0
v_max_non_paid_invoice 4892 4892 0 0.00 0 38 2 0 0
v_max_non_paid_realizn 10547 10547 0 0.00 0 76 2 0 0
v_min_id_clo_ord 8509 8509 0 0.00 0 321 3 0 0
v_min_id_clo_res 1588 1588 0 0.00 0 303 4 0 0
v_min_id_ord_sup 8541 8541 0 0.00 0 736 5 0 0
v_min_non_paid_invoice 9241 9241 0 0.00 0 295 3 0 0
v_min_non_paid_realizn 11082 11082 0 0.00 0 380 2 0 0
v_our_firm 16502 16502 0 0.00 0 40 1 0 0
v_reserve_write_off 31324 31324 0 0.00 0 1169 2 0 0
x_lock_depdocs_on_canc_invoice 10732 10732 0 0.00 0 1097 9 0 0
x_lock_depdocs_on_canc_sup_ord 655 655 0 0.00 0 176 11 0 0
x_make_qstorno_1000_1200 8509 8509 0 0.00 1 1922 150 0 0
x_make_qstorno_1200_2000 8541 8541 0 0.00 1 3107 310 0 0
x_make_qstorno_2100_3300 359166 359166 0 0.00 0 2004 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2026 05:51:18 to 06-11-2026 05:51:22.

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:03 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:02:03 220 2147483648 2606722976 2693750784 274463792 11.332 20 14 24 0 277544992 785648 2295552
05:03:03 231 2147483648 2602700944 2688901120 270466240 11.185 20 7 14 0 273113280 1169872 1477168
05:04:04 158 2147483648 2598532960 2686169088 266210992 11.029 20 9 18 0 269137008 1243568 1682448
05:05:05 180 2147483648 2586174848 2669649920 252886032 10.535 20 11 22 0 256446816 1333728 2227056
05:06:05 278 2147483648 2602559328 2687660032 268941840 11.129 20 10 21 0 272220656 1183344 2095472
05:07:05 254 2147483648 2598430960 2684915712 265295424 10.995 20 10 17 1 268619808 1724688 1599696
05:08:06 1027 2147483648 2600060688 2686758912 267123776 11.062 20 10 20 0 270281584 1062304 2095504
05:09:08 234 2147483648 2591279392 2680774656 260649104 10.823 20 3 6 0 262216656 1109056 458496
05:10:08 218 2147483648 2597514416 2684317696 262633616 10.897 20 9 17 0 266327776 2048528 1645632
05:11:09 154 2147483648 2589989776 2675572736 255547936 10.634 20 15 30 0 260210096 1588352 3073808
05:12:09 165 2147483648 2600166976 2687811584 266348640 11.034 20 12 22 0 269402832 1105712 1948480
05:13:10 211 2147483648 2596076048 2682310656 261152336 10.842 20 10 20 0 265388000 2201200 2034464
05:14:10 128 2147483648 2600550080 2687143936 265991744 11.021 20 12 23 2 270100256 1756528 2351984
05:15:11 188 2147483648 2595188304 2681737216 261091952 10.840 20 10 20 0 264647456 1418224 2137280
05:16:11 140 2147483648 2597810736 2683621376 260469136 10.817 20 13 26 1 266901488 3601536 2830816
05:17:12 299 2147483648 2602638672 2692055040 269665184 11.156 20 10 18 1 272587808 1318800 1603824
05:18:12 169 2147483648 2594247904 2684252160 262456608 10.890 20 7 14 0 265305680 1199696 1649376
05:19:13 174 2147483648 2603031296 2691477504 269499312 11.150 20 8 16 0 272927984 1456848 1971824
05:20:13 124 2147483648 2603250944 2691485696 267801424 11.087 20 11 22 0 271833120 1763456 2268240
05:21:13 225 2147483648 2603975200 2693713920 269430992 11.147 20 12 22 1 274810624 2480016 2899616
05:22:14 493 2147483648 2597833568 2687270912 264632352 10.970 20 9 18 0 267542256 1501696 1408208
05:23:14 665 2147483648 2589928224 2680188928 258650688 10.749 20 9 18 0 262007936 1232336 2124912
05:24:15 161 2147483648 2598715072 2687508480 264013264 10.948 20 12 24 0 268288880 2152144 2123472
05:25:16 114 2147483648 2600219424 2688786432 266069712 11.023 20 11 22 1 269176624 1079392 2027520
05:26:16 332 2147483648 2595179040 2682646528 259962272 10.798 20 12 23 0 263651376 1534848 2154256
05:27:17 283 2147483648 2596470240 2685317120 261952864 10.871 20 11 21 0 265955232 1852560 2149808
05:28:17 246 2147483648 2603616448 2690453504 266714496 11.047 20 14 28 0 272167808 2759872 2693440
05:29:18 152 2147483648 2603280304 2689839104 265863008 11.016 20 12 24 0 271191648 3112752 2215888
05:30:18 125 2147483648 2602490912 2692710400 269255984 11.141 20 10 21 1 272480736 1618304 1606448
05:31:19 194 2147483648 2601788304 2690162688 266915008 11.055 20 13 25 0 271045056 1952144 2177904
05:32:20 928 2147483648 2605980272 2696499200 272258368 11.251 20 11 22 0 275595056 1450864 1885824
05:33:21 140 2147483648 2592899696 2680250368 257636016 10.711 20 15 28 0 262023408 1306896 3080496
05:34:22 204 2147483648 2602543472 2691690496 266468560 11.038 20 13 26 1 271261296 2263968 2528768
05:35:22 151 2147483648 2597371984 2686398464 263296576 10.921 20 10 20 0 266899552 1814880 1788096
05:36:22 581 2147483648 2597053072 2684178432 261846448 10.868 20 12 21 0 266747312 3118720 1782144
05:37:23 589 2147483648 2592251504 2680832000 259016080 10.763 20 13 26 0 263646512 1884224 2746208
05:38:24 422 2147483648 2599830480 2691510272 265998128 11.021 20 6 12 0 269343648 2292000 1053520
05:39:25 115 2147483648 2601260128 2689392640 265001520 10.984 20 14 28 0 270718864 2815344 2902000
05:40:25 239 2147483648 2599867408 2690736128 267394464 11.072 20 8 16 0 270115136 1611328 1109344
05:41:25 209 2147483648 2602787280 2692595712 267477744 11.075 20 12 24 0 271648416 1449888 2720784
05:42:26 303 2147483648 2594686112 2681778176 257955776 10.723 20 10 20 0 262638784 2361856 2321152
05:43:26 153 2147483648 2602068144 2690183168 266608368 11.043 20 14 28 0 270499296 1275392 2615536
05:44:27 209 2147483648 2604562224 2693177344 264988032 10.984 20 12 24 0 272836208 5649280 2198896
05:45:27 167 2147483648 2605053216 2695544832 269608800 11.154 20 9 18 0 274238880 2772864 1857216
05:46:27 141 2147483648 2600749376 2690015232 264829696 10.978 20 13 26 0 269365072 1814096 2721280
05:47:28 401 2147483648 2596849104 2685493248 258943296 10.760 20 11 19 0 263985552 2947920 2094336
05:48:29 174 2147483648 2599346992 2689757184 265575664 11.005 20 10 20 0 268524160 1226272 1722224
05:49:29 216 2147483648 2603991568 2696581120 267337792 11.070 20 9 18 0 272659840 3456032 1866016
05:50:29 660 2147483648 2593255184 2682822656 258495328 10.743 20 9 18 0 262083728 1975632 1612768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 06-11-2026 05:51:23 to 06-11-2026 05:51:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 06-11-2026 05:51:35 to 06-11-2026 05:51:36.

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          224627
MON$OLDEST_ACTIVE               226314
MON$OLDEST_SNAPSHOT             226314
MON$NEXT_TRANSACTION            226314
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-06 05:00:10.0970
MON$PAGES                       143232
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    Fri Nov  6 05:50:59 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Fri Nov  6 05:51:00 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
:14: 
:15: test-0    Fri Nov  6 05:51:00 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:17: 
:18: 
:19: test-0    Fri Nov  6 05:51:00 2026
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:21: 
:22: 
:23: test-0    Fri Nov  6 05:51:00 2026
:24:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:25: 
:26: 
:27: test-0    Fri Nov  6 05:51:00 2026
:28:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:29: 
--- end of diff output ---

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

06.11.26 05:51:36. There are 3 logs in /var/tmp/logs.oltp-hq30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2026-11-06 05:51:38 No severe PSQL-related problems occured
06.11.26 05:51:38. End of report.