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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 5d
Command: who -b
bootup_info system boot 2026-11-09 10:54
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 8138016 kB
MemFree 1745344 kB
MemAvailable 7286460 kB
Buffers 80808 kB
Cached 5583900 kB
SwapCached 12 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-12 17:51:00
DTS_END                         2026-11-12 17:51:00.3490
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/34402
TRN_ID                          210264
ATT_ID                          432
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: 13480.50 878 674025
customer order: creation 624.52 49 31226
customer order: refuse 49.44 50 2472
order to supplier: creation 158.66 217 7933
order to supplier: removal 11.66 8967 583
invoice (draft): creation 157.00 369 7850
invoice (draft): removal 112.28 152 5614
invoice accept: apply 133.78 1642 6689
invoice accept: cancel 91.98 239 4599
customer reserve: creation 6494.08 29 324704
customer reserve: removal 4696.88 16 234844
realization accept: apply 293.08 38 14654
realization accept: cancel 162.00 21 8100
payment from customer: creation 209.28 38 10464
payment from customer: removal 18.26 20 913
payment to supplier: creation 167.90 33 8395
payment to supplier: removal 11.92 18 596
service: total inventory turnovers 34.94 502 1747
service: total monetary turnovers 47.58 7 2379
service: aggregate perf. data 5.22 1548 261
service: refresh index statistics 0.04 3601 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2026 17:51:14 to 12-11-2026 17:51:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 16387
TEST_TIME 2 13619
TEST_TIME 3 12985
TEST_TIME 4 12614
TEST_TIME 5 12576
TEST_TIME 6 12745
TEST_TIME 7 12811
TEST_TIME 8 12785
TEST_TIME 9 12795
TEST_TIME 10 12719
TEST_TIME 11 12894
TEST_TIME 12 12891
TEST_TIME 13 12915
TEST_TIME 14 12919
TEST_TIME 15 12879
TEST_TIME 16 12943
TEST_TIME 17 12913
TEST_TIME 18 12929
TEST_TIME 19 12869
TEST_TIME 20 12940
TEST_TIME 21 12901
TEST_TIME 22 12923
TEST_TIME 23 12908
TEST_TIME 24 12954
TEST_TIME 25 13048
TEST_TIME 26 13011
TEST_TIME 27 13061
TEST_TIME 28 13032
TEST_TIME 29 13062
TEST_TIME 30 13012
TEST_TIME 31 13041
TEST_TIME 32 13096
TEST_TIME 33 13054
TEST_TIME 34 13175
TEST_TIME 35 13211
TEST_TIME 36 13158
TEST_TIME 37 13341
TEST_TIME 38 13357
TEST_TIME 39 13413
TEST_TIME 40 13465
TEST_TIME 41 13528
TEST_TIME 42 13551
TEST_TIME 43 13594
TEST_TIME 44 13640
TEST_TIME 45 13692
TEST_TIME 46 13656
TEST_TIME 47 13769
TEST_TIME 48 13733
TEST_TIME 49 13732
TEST_TIME 50 13480

Performance per minute, chart


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

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 994727 994727 0 0.00 0 1605 2 0 0
doc_list_biud 994727 994727 0 0.00 0 2374 6 0 0
sp_add_invoice_to_stock 6689 6689 0 0.00 6 14452 1642 0 0
sp_cancel_adding_invoice 4599 4599 0 0.00 3 5462 239 0 0
sp_cancel_client_order 2472 2472 0 0.00 3 935 50 0 0
sp_cancel_customer_reserve 234844 234844 0 0.00 1 2378 16 0 0
sp_cancel_pay_from_customer 913 913 0 0.00 2 364 20 0 0
sp_cancel_pay_to_supplier 596 596 0 0.00 2 264 19 0 0
sp_cancel_supplier_invoice 5614 5614 0 0.00 1 1065 152 0 0
sp_cancel_supplier_order 583 583 0 0.00 6 50635 8968 0 0
sp_cancel_write_off 8100 8100 0 0.00 1 609 21 0 0
sp_client_order 31226 31226 0 0.00 4 1058 49 0 0
sp_customer_reserve 324704 324704 0 0.00 0 2404 29 0 0
sp_fill_shopping_cart 47009 47009 0 0.00 1 2062 21 0 0
sp_fill_shopping_cart_clo_res 324704 324704 0 0.00 0 1285 3 0 0
sp_get_clo_for_invoice 6689 6689 0 0.00 0 1696 35 0 0
sp_kill_cost_storno 14208 14208 0 0.00 0 530 10 0 0
sp_kill_qstorno_ret_qs2qd 483985 483985 0 0.00 0 1752 8 0 0
sp_kill_qty_storno 277555 277555 0 0.00 0 2374 19 0 0
sp_lock_selected_doc 29573 29573 0 0.00 0 297 2 0 0
sp_make_cost_storno 40202 40202 0 0.00 0 430 7 0 0
sp_multiply_rows_for_pdistr 40202 40202 0 0.00 0 791 11 0 0
sp_multiply_rows_for_qdistr 31226 31226 0 0.00 0 1052 19 0 0
sp_pay_from_customer 10464 10464 0 0.00 3 637 39 0 0
sp_pay_to_supplier 8395 8395 0 0.00 3 802 33 0 0
sp_payment_common 18859 18859 0 0.00 1 444 11 0 0
sp_qd_handle_on_cancel_clo 2472 2472 0 0.00 0 930 33 0 0
sp_qd_handle_on_invoice_upd_sts 11288 11288 0 0.00 0 1181 70 0 0
sp_qd_handle_on_reserve_upd_sts 14654 14654 0 0.00 0 1191 11 0 0
sp_reserve_write_off 14654 14654 0 0.00 3 1255 38 0 0
sp_supplier_invoice 7850 7850 0 0.00 5 6033 370 0 0
sp_supplier_order 7933 7933 0 0.00 5 2204 217 0 0
srv_aggregate_perf_data 261 261 0 0.00 28 12146 1549 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 966 279 0 0
srv_find_qd_qs_mism 625957 625957 0 0.00 0 1604 2 0 0
srv_make_invnt_saldo 1747 1747 0 0.00 1 65181 503 0 0
srv_make_money_saldo 2379 2379 0 0.00 0 183 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 357 6846 3602 0 0
v_add_invoice_to_stock 13378 13378 0 0.00 0 552 3 0 0
v_all_customers 47460 47460 0 0.00 0 57 1 0 0
v_all_suppliers 38660 38660 0 0.00 0 52 1 0 0
v_all_wares 62452 62452 0 0.00 0 51 1 0 0
v_cancel_adding_invoice 1320 1320 0 0.00 0 93 2 0 0
v_cancel_client_order 4944 4944 0 0.00 0 270 2 0 0
v_cancel_customer_prepayment 1826 1826 0 0.00 0 237 2 0 0
v_cancel_customer_reserve 2004 2004 0 0.00 0 388 2 0 0
v_cancel_payment_to_supplier 1192 1192 0 0.00 0 31 2 0 0
v_cancel_supplier_invoice 1182 1182 0 0.00 0 190 3 0 0
v_cancel_supplier_order 1166 1166 0 0.00 0 91 2 0 0
v_cancel_write_off 2826 2826 0 0.00 0 314 2 0 0
v_max_id_clo_ord 7933 7933 0 0.00 0 63 1 0 0
v_max_id_clo_res 1412 1412 0 0.00 0 413 2 0 0
v_max_id_ord_sup 7850 7850 0 0.00 0 660 2 0 0
v_max_non_paid_invoice 4848 4848 0 0.00 0 172 2 0 0
v_max_non_paid_realizn 10145 10145 0 0.00 0 181 2 0 0
v_min_id_clo_ord 7933 7933 0 0.00 0 353 3 0 0
v_min_id_clo_res 1412 1412 0 0.00 0 714 5 0 0
v_min_id_ord_sup 7850 7850 0 0.00 0 830 7 0 0
v_min_non_paid_invoice 8395 8395 0 0.00 0 282 4 0 0
v_min_non_paid_realizn 10464 10464 0 0.00 0 433 7 0 0
v_our_firm 15630 15630 0 0.00 0 45 1 0 0
v_reserve_write_off 29308 29308 0 0.00 0 555 2 0 0
x_lock_depdocs_on_canc_invoice 9622 9622 0 0.00 0 1377 9 0 0
x_lock_depdocs_on_canc_sup_ord 583 583 0 0.00 0 239 11 0 0
x_make_qstorno_1000_1200 7933 7933 0 0.00 1 2140 161 0 0
x_make_qstorno_1200_2000 7850 7850 0 0.00 1 5060 323 0 0
x_make_qstorno_2100_3300 324704 324704 0 0.00 0 2404 25 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2026 17:51:19 to 12-11-2026 17:51:23.

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, bytes
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = size of cache for metadata, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:01:04 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:05 375 2147483648 2606604736 2692964352 274520144 11.334 20 11 22 1 277268512 667760 2080608
17:03:05 252 2147483648 2606412576 2690555904 273077264 11.281 20 18 34 0 277261552 1075680 3108608
17:04:06 196 2147483648 2593664800 2676477952 258779088 10.754 20 15 32 0 263354432 1464608 3110736
17:05:06 154 2147483648 2587504176 2672316416 254624272 10.600 19 9 18 0 257624256 1284608 1715376
17:06:07 276 2147483648 2598556064 2684260352 264738736 10.974 20 11 22 0 268360176 1557872 2063568
17:07:08 324 2147483648 2586569872 2672308224 254883504 10.609 20 10 19 0 258220448 1308368 2028576
17:08:08 194 2147483648 2606003520 2693718016 268256688 11.104 20 12 24 0 275975360 5548288 2170384
17:09:09 99 2147483648 2577737056 2664251392 246930368 10.312 19 7 10 2 249231904 933952 1367584
17:10:09 199 2147483648 2594628304 2683207680 262950464 10.908 20 6 12 0 265007424 1032016 1024944
17:11:10 171 2147483648 2594348992 2681626624 258897776 10.758 20 11 18 1 261378736 934592 1546368
17:12:10 965 2147483648 2593507328 2680590336 260318480 10.811 20 11 22 0 263777168 1534464 1924224
17:13:11 809 2147483648 2603062080 2690940928 268459568 11.111 20 8 16 0 273209200 1607984 3141648
17:14:12 124 2147483648 2597312080 2684784640 262524272 10.893 20 11 22 0 267306064 2336336 2445456
17:15:13 255 2147483648 2594946768 2682691584 262599664 10.895 20 11 20 0 265067392 1017120 1450608
17:16:14 144 2147483648 2599264304 2687152128 264924656 10.981 20 11 22 0 269226288 1448080 2853552
17:17:14 168 2147483648 2587428464 2671865856 253183264 10.546 19 11 22 0 258036160 2636656 2216240
17:18:15 252 2147483648 2595017152 2683674624 261920112 10.870 20 9 18 0 265601392 1930624 1750656
17:19:15 339 2147483648 2600003776 2688651264 264286528 10.958 20 7 12 1 267763584 2134608 1342448
17:20:16 165 2147483648 2587359552 2671300608 252437792 10.518 20 15 30 0 256913664 1795712 2680160
17:21:16 253 2147483648 2603625456 2691588096 267316896 11.069 20 10 20 0 271998416 2760256 1921264
17:22:18 99 2147483648 2604090448 2692857856 269598896 11.153 20 10 20 0 273564736 1841456 2124384
17:23:18 200 2147483648 2599318448 2687270912 265521616 11.003 20 14 25 1 269884112 1907792 2454704
17:24:18 338 2147483648 2597165376 2686672896 264065584 10.950 20 5 10 0 266754368 1762640 926144
17:25:19 180 2147483648 2599351136 2688397312 264770624 10.976 20 13 25 1 269195360 1869648 2555088
17:26:19 197 2147483648 2595891632 2683740160 260943088 10.834 20 12 24 0 265794112 2441456 2409568
17:27:21 410 2147483648 2600000384 2688995328 266428864 11.037 20 6 12 0 268749472 1381952 938656
17:28:21 175 2147483648 2603475488 2691694592 267021424 11.059 20 16 31 0 271604800 1983824 2599552
17:29:22 474 2147483648 2594770240 2684452864 261426768 10.852 20 12 23 0 264909520 1358112 2124640
17:30:23 294 2147483648 2591457232 2680004608 257627712 10.711 20 10 20 0 260635904 1161888 1846304
17:31:23 114 2147483648 2607576048 2698526720 272884832 11.274 20 9 20 0 277153984 2106496 2162656
17:32:24 224 2147483648 2596932288 2685104128 261312272 10.848 20 15 29 1 265952896 1789200 2851424
17:33:24 549 2147483648 2598034944 2686353408 262555136 10.894 20 11 22 0 268080304 3442560 2082608
17:34:25 154 2147483648 2601073168 2691526656 267480272 11.075 20 11 21 0 270462176 1137904 1844000
17:35:25 288 2147483648 2599005248 2689232896 263813824 10.940 20 8 16 0 268077264 2830816 1432624
17:36:26 253 2147483648 2589619520 2681413632 258337312 10.738 20 5 8 0 260251840 824720 1089808
17:37:27 156 2147483648 2597454176 2688176128 263888416 10.943 20 9 18 0 267112224 1350464 1873344
17:38:27 140 2147483648 2602073488 2690170880 264349344 10.960 20 14 28 1 270576352 3418160 2808848
17:39:28 334 2147483648 2598604336 2690658304 266844720 11.052 20 8 16 0 269400912 1444640 1111552
17:40:29 767 2147483648 2595104976 2685935616 252190976 10.509 19 7 14 0 255278736 1729408 1358352
17:41:30 191 2147483648 2603408448 2693681152 268984864 11.131 20 9 18 0 273745664 2150800 2610000
17:42:30 178 2147483648 2602112336 2690678784 266253088 11.030 20 13 24 0 271971744 3309568 2409088
17:43:30 204 2147483648 2599568784 2690310144 265258320 10.994 20 10 20 0 268280656 987696 2034640
17:44:31 194 2147483648 2582610096 2669924352 248456000 10.369 19 11 22 0 252730000 2154368 2119632
17:45:32 476 2147483648 2602793536 2692665344 266635152 11.044 20 12 24 0 271585024 2628656 2321216
17:46:32 200 2147483648 2593043856 2681069568 256584704 10.672 20 13 26 0 261484608 2479264 2420640
17:47:33 372 2147483648 2599596128 2691313664 266666544 11.045 20 7 14 0 269192464 1212608 1313312
17:48:33 234 2147483648 2601174480 2691407872 266707584 11.047 20 10 20 0 270455584 1885696 1862304
17:49:34 180 2147483648 2589794496 2677321728 255138048 10.619 20 14 26 0 258962128 1076336 2747744
17:50:34 469 2147483648 2602373920 2692460544 267762848 11.086 20 10 19 0 270754208 1489056 1502304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 12-11-2026 17:51:24 to 12-11-2026 17:51:37.

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 12-11-2026 17:51:38 to 12-11-2026 17:51:39.

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          207883
MON$OLDEST_ACTIVE               210411
MON$OLDEST_SNAPSHOT             210411
MON$NEXT_TRANSACTION            210411
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-12 17:00:09.3180
MON$PAGES                       126624
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.33893 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33893 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33893 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    Thu Nov 12 17:51:01 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
--- end of diff output ---

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

12.11.26 17:51:40. 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-12 17:51:41 No severe PSQL-related problems occured
12.11.26 17:51:41. End of report.