Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.11.2026 23: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 1709060 kB
MemAvailable 7168184 kB
Buffers 88156 kB
Cached 5458676 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 23:51:05
DTS_END                         2026-11-04 23:51:05.7460
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/48044
TRN_ID                          203247
ATT_ID                          416
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: 12352.70 989 617635
customer order: creation 600.20 52 30010
customer order: refuse 47.70 51 2385
order to supplier: creation 153.66 223 7683
order to supplier: removal 10.34 9328 517
invoice (draft): creation 151.94 345 7597
invoice (draft): removal 105.14 142 5257
invoice accept: apply 131.02 1668 6551
invoice accept: cancel 88.36 217 4418
customer reserve: creation 5912.98 31 295649
customer reserve: removal 4240.52 16 212026
realization accept: apply 279.34 40 13967
realization accept: cancel 150.44 21 7522
payment from customer: creation 197.30 36 9865
payment from customer: removal 20.14 19 1007
payment to supplier: creation 167.40 32 8370
payment to supplier: removal 10.60 19 530
service: total inventory turnovers 33.02 510 1651
service: total monetary turnovers 47.74 8 2387
service: aggregate perf. data 4.82 1785 241
service: refresh index statistics 0.04 5233 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11442
TEST_TIME 2 10039
TEST_TIME 3 9483
TEST_TIME 4 9459
TEST_TIME 5 9507
TEST_TIME 6 8845
TEST_TIME 7 9044
TEST_TIME 8 9185
TEST_TIME 9 9499
TEST_TIME 10 9807
TEST_TIME 11 9983
TEST_TIME 12 10244
TEST_TIME 13 10548
TEST_TIME 14 10531
TEST_TIME 15 10845
TEST_TIME 16 11023
TEST_TIME 17 11096
TEST_TIME 18 11171
TEST_TIME 19 11288
TEST_TIME 20 11312
TEST_TIME 21 11386
TEST_TIME 22 11411
TEST_TIME 23 11448
TEST_TIME 24 11551
TEST_TIME 25 11530
TEST_TIME 26 11630
TEST_TIME 27 11647
TEST_TIME 28 11670
TEST_TIME 29 11727
TEST_TIME 30 11752
TEST_TIME 31 11822
TEST_TIME 32 11817
TEST_TIME 33 11894
TEST_TIME 34 12001
TEST_TIME 35 12032
TEST_TIME 36 12047
TEST_TIME 37 12117
TEST_TIME 38 12003
TEST_TIME 39 12099
TEST_TIME 40 12221
TEST_TIME 41 12151
TEST_TIME 42 12284
TEST_TIME 43 12312
TEST_TIME 44 12359
TEST_TIME 45 12468
TEST_TIME 46 12507
TEST_TIME 47 12596
TEST_TIME 48 12613
TEST_TIME 49 12589
TEST_TIME 50 12353

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-11-2026 23:51:22 to 04-11-2026 23:51:25.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 914699 914699 0 0.00 0 972 2 0 0
doc_list_biud 914699 914699 0 0.00 0 3021 6 0 0
sp_add_invoice_to_stock 6551 6551 0 0.00 7 15755 1668 0 0
sp_cancel_adding_invoice 4418 4418 0 0.00 3 5122 217 0 0
sp_cancel_client_order 2385 2385 0 0.00 3 1035 52 0 0
sp_cancel_customer_reserve 212026 212026 0 0.00 1 3038 17 0 0
sp_cancel_pay_from_customer 1007 1007 0 0.00 2 202 20 0 0
sp_cancel_pay_to_supplier 530 530 0 0.00 2 515 20 0 0
sp_cancel_supplier_invoice 5257 5257 0 0.00 1 1211 142 0 0
sp_cancel_supplier_order 517 517 0 0.00 4 44489 9328 0 0
sp_cancel_write_off 7522 7522 0 0.00 1 1113 21 0 0
sp_client_order 30010 30010 0 0.00 4 3037 52 0 0
sp_customer_reserve 295649 295649 0 0.00 0 5128 32 0 0
sp_fill_shopping_cart 45290 45290 0 0.00 1 1341 21 0 0
sp_fill_shopping_cart_clo_res 295649 295649 0 0.00 0 1051 3 0 0
sp_get_clo_for_invoice 6551 6551 0 0.00 0 1349 36 0 0
sp_kill_cost_storno 13477 13477 0 0.00 0 380 10 0 0
sp_kill_qstorno_ret_qs2qd 437348 437348 0 0.00 0 2010 8 0 0
sp_kill_qty_storno 252643 252643 0 0.00 0 3021 19 0 0
sp_lock_selected_doc 28349 28349 0 0.00 0 355 2 0 0
sp_make_cost_storno 38753 38753 0 0.00 0 486 7 0 0
sp_multiply_rows_for_pdistr 38753 38753 0 0.00 0 678 11 0 0
sp_multiply_rows_for_qdistr 30010 30010 0 0.00 0 1668 21 0 0
sp_pay_from_customer 9865 9865 0 0.00 3 749 36 0 0
sp_pay_to_supplier 8370 8370 0 0.00 3 851 33 0 0
sp_payment_common 18235 18235 0 0.00 1 481 8 0 0
sp_qd_handle_on_cancel_clo 2385 2385 0 0.00 0 992 34 0 0
sp_qd_handle_on_invoice_upd_sts 10969 10969 0 0.00 0 1520 70 0 0
sp_qd_handle_on_reserve_upd_sts 13967 13967 0 0.00 0 1102 11 0 0
sp_reserve_write_off 13967 13967 0 0.00 3 1108 40 0 0
sp_supplier_invoice 7597 7597 0 0.00 6 3313 345 0 0
sp_supplier_order 7683 7683 0 0.00 5 3406 224 0 0
srv_aggregate_perf_data 241 241 0 0.00 64 22133 1786 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1403 313 0 0
srv_find_qd_qs_mism 573785 573785 0 0.00 0 972 2 0 0
srv_make_invnt_saldo 1651 1651 0 0.00 1 38983 511 0 0
srv_make_money_saldo 2387 2387 0 0.00 0 231 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 302 10165 5234 0 0
v_add_invoice_to_stock 13102 13102 0 0.00 0 827 3 0 0
v_all_customers 45428 45428 0 0.00 0 74 1 0 0
v_all_suppliers 37558 37558 0 0.00 0 83 1 0 0
v_all_wares 60020 60020 0 0.00 0 84 1 0 0
v_cancel_adding_invoice 1122 1122 0 0.00 0 161 2 0 0
v_cancel_client_order 4770 4770 0 0.00 0 164 2 0 0
v_cancel_customer_prepayment 2014 2014 0 0.00 0 175 2 0 0
v_cancel_customer_reserve 1786 1786 0 0.00 0 235 2 0 0
v_cancel_payment_to_supplier 1060 1060 0 0.00 0 153 2 0 0
v_cancel_supplier_invoice 1084 1084 0 0.00 0 235 3 0 0
v_cancel_supplier_order 1034 1034 0 0.00 0 45 2 0 0
v_cancel_write_off 2792 2792 0 0.00 0 119 2 0 0
v_max_id_clo_ord 7683 7683 0 0.00 0 100 2 0 0
v_max_id_clo_res 1347 1347 0 0.00 0 246 2 0 0
v_max_id_ord_sup 7597 7597 0 0.00 0 405 2 0 0
v_max_non_paid_invoice 4871 4871 0 0.00 0 89 2 0 0
v_max_non_paid_realizn 9528 9528 0 0.00 0 141 2 0 0
v_min_id_clo_ord 7683 7683 0 0.00 0 247 3 0 0
v_min_id_clo_res 1347 1347 0 0.00 0 731 7 0 0
v_min_id_ord_sup 7597 7597 0 0.00 0 885 6 0 0
v_min_non_paid_invoice 8370 8370 0 0.00 0 243 3 0 0
v_min_non_paid_realizn 9865 9865 0 0.00 0 476 2 0 0
v_our_firm 15266 15266 0 0.00 0 54 1 0 0
v_reserve_write_off 27934 27934 0 0.00 0 814 2 0 0
x_lock_depdocs_on_canc_invoice 9133 9133 0 0.00 0 1987 10 0 0
x_lock_depdocs_on_canc_sup_ord 517 517 0 0.00 0 615 13 0 0
x_make_qstorno_1000_1200 7683 7683 0 0.00 1 3351 165 0 0
x_make_qstorno_1200_2000 7597 7597 0 0.00 1 2769 298 0 0
x_make_qstorno_2100_3300 295649 295649 0 0.00 0 4964 27 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 04-11-2026 23:51:25 to 04-11-2026 23:51:30.

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
23:01:10 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:11 253 2147483648 2602111216 2687913984 270460752 11.185 20 14 27 0 274095600 750816 2884032
23:03:11 217 2147483648 2598716912 2685038592 267554448 11.078 20 9 16 1 269675248 725120 1395680
23:04:12 260 2147483648 2599492640 2686353408 267016672 11.058 20 8 16 0 269797920 1181792 1599456
23:05:12 170 2147483648 2598727248 2686152704 267887664 11.090 20 6 12 0 269593840 915600 790576
23:06:13 226 2147483648 2593197904 2676563968 260867760 10.831 20 12 21 0 264203280 1229648 2105872
23:07:13 856 2147483648 2596180432 2682998784 263825152 10.941 20 7 14 0 266567520 1477280 1265088
23:08:15 176 2147483648 2599783440 2689421312 268874592 11.127 20 3 6 0 270513408 1017328 621488
23:09:16 211 2147483648 2580728560 2664517632 248578688 10.374 20 11 19 1 251224320 822704 1822928
23:10:16 143 2147483648 2600048896 2687197184 267627408 11.081 20 9 18 0 270612368 1337872 1647088
23:11:17 213 2147483648 2584414368 2670039040 251618496 10.488 20 11 23 0 255518240 1606848 2292896
23:12:17 153 2147483648 2601594768 2690891776 268820512 11.125 20 10 20 0 272068736 1390832 1857392
23:13:18 219 2147483648 2597489200 2685296640 265421136 11.000 20 9 18 0 269602192 1197200 2983856
23:14:18 193 2147483648 2597808080 2684198912 262155216 10.879 20 11 22 0 267718416 3288816 2274384
23:15:19 477 2147483648 2595813952 2686345216 265411504 10.999 20 5 10 1 267348624 1081200 855920
23:16:19 175 2147483648 2594576192 2682544128 259811136 10.792 20 7 14 0 264865088 3429008 1624944
23:17:20 132 2147483648 2599253104 2687094784 266164560 11.027 20 9 18 0 269356880 1081376 2110944
23:18:20 588 2147483648 2600942928 2688159744 264987680 10.984 20 13 26 0 269330176 2021136 2321360
23:19:21 155 2147483648 2589927888 2674450432 253792624 10.569 20 15 29 0 259505504 2722688 2990192
23:20:21 917 2147483648 2602835408 2692067328 268721968 11.121 20 8 16 0 272575680 2097088 1756624
23:21:23 354 2147483648 2602636992 2692997120 267679168 11.083 20 8 16 0 273512208 4581296 1251744
23:22:23 431 2147483648 2579965712 2664402944 246302256 10.289 19 11 21 0 249607856 1227232 2078368
23:23:24 345 2147483648 2593394288 2681184256 259652240 10.786 20 8 16 0 263044320 1960928 1431152
23:24:25 1370 2147483648 2601064432 2689003520 266414240 11.036 20 10 20 0 269883088 1717440 1751408
23:25:26 183 2147483648 2593448640 2679664640 256768960 10.679 20 9 18 0 262732048 3624368 2338720
23:26:28 215 2147483648 2600441488 2688782336 265979504 11.020 20 14 28 1 270575872 1833616 2762752
23:27:28 303 2147483648 2604390784 2691813376 267705728 11.084 20 16 32 0 273422608 2374928 3341952
23:28:29 302 2147483648 2602332592 2690981888 266957360 11.056 20 11 21 0 271155408 2199472 1998576
23:29:29 128 2147483648 2599261216 2688475136 264655056 10.971 20 12 22 0 268353392 1572896 2125440
23:30:30 377 2147483648 2594930304 2682617856 259577600 10.784 20 10 17 1 264633200 2449520 2606080
23:31:30 109 2147483648 2606484048 2695835648 271975056 11.241 20 14 29 0 275871136 1046240 2849840
23:32:31 412 2147483648 2597564240 2685538304 262789344 10.902 20 13 23 0 267279584 2281664 2208576
23:33:32 217 2147483648 2603846528 2693648384 269189776 11.138 20 10 20 0 273442544 2249536 2003232
23:34:32 133 2147483648 2601515392 2690387968 265504576 11.003 20 13 26 0 269809440 1260672 3044192
23:35:33 165 2147483648 2596719312 2685038592 263052528 10.912 20 10 20 0 266488336 1281504 2154304
23:36:33 195 2147483648 2587971728 2676379648 254917440 10.610 20 7 14 0 257372016 1227632 1226944
23:37:34 179 2147483648 2599199552 2688061440 264706032 10.973 20 9 18 0 268048368 1636480 1705856
23:38:34 190 2147483648 2591995856 2683187200 257990544 10.725 20 7 14 0 261257328 1836608 1430176
23:39:35 352 2147483648 2576245680 2664828928 244542240 10.223 19 5 9 0 246876464 1184128 1150096
23:40:35 330 2147483648 2596035712 2687328256 262980784 10.909 20 4 8 0 265556992 1613488 962720
23:41:36 169 2147483648 2606569392 2695487488 270480256 11.186 20 16 29 0 275542992 2066672 2996064
23:42:36 281 2147483648 2598293120 2688057344 263294592 10.921 20 9 16 1 267344112 2513152 1536368
23:43:37 195 2147483648 2594420080 2681036800 257956624 10.723 20 12 24 0 263602368 3455440 2190304
23:44:37 167 2147483648 2598835792 2687746048 263312176 10.922 20 13 26 0 267815552 1997568 2505808
23:45:38 209 2147483648 2602745328 2691665920 266673168 11.046 20 11 22 0 271807968 3068528 2066272
23:46:39 119 2147483648 2585940256 2671501312 248849856 10.384 20 14 28 0 253863760 2150720 2863184
23:47:40 176 2147483648 2603410688 2691035136 267024624 11.059 20 13 25 0 271158432 1402160 2731648
23:48:40 152 2147483648 2598141168 2690199552 263077008 10.913 20 5 10 0 267541040 3433216 1030816
23:49:41 550 2147483648 2600212112 2691407872 265669504 11.009 20 9 18 0 269513440 2261488 1582448
23:50:41 1403 2147483648 2589081840 2676117504 254120656 10.581 20 10 20 0 258395664 2265344 2009664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 04-11-2026 23:51:31 to 04-11-2026 23:51:47.

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 23:51:48 to 04-11-2026 23:51:49.

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          202681
MON$OLDEST_ACTIVE               203390
MON$OLDEST_SNAPSHOT             203390
MON$NEXT_TRANSACTION            203390
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 23:00:10.6500
MON$PAGES                       126048
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 23:51:07 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov  4 23:51:07 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:13: 
--- end of diff output ---

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

04.11.26 23:51:49. 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 23:51:50 No severe PSQL-related problems occured
04.11.26 23:51:51. End of report.