Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 16.11.2026 11: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 e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+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 2w 2d
Command: who -b
bootup_info system boot 2026-11-14 21: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 8138028 kB
MemFree 2051704 kB
MemAvailable 7413976 kB
Buffers 78096 kB
Cached 5367412 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-16 11:50:54
DTS_END                         2026-11-16 11:50:54.2620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/51052
TRN_ID                          229427
ATT_ID                          465
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: 15436.98 1048 771849
customer order: creation 678.88 45 33944
customer order: refuse 55.10 46 2755
order to supplier: creation 173.68 201 8684
order to supplier: removal 13.26 8865 663
invoice (draft): creation 176.42 341 8821
invoice (draft): removal 129.08 145 6454
invoice accept: apply 151.30 1532 7565
invoice accept: cancel 106.26 215 5313
customer reserve: creation 7415.38 26 370769
customer reserve: removal 5501.50 15 275075
realization accept: apply 317.42 35 15871
realization accept: cancel 181.82 19 9091
payment from customer: creation 221.96 32 11098
payment from customer: removal 21.50 18 1075
payment to supplier: creation 182.02 29 9101
payment to supplier: removal 12.64 15 632
service: total inventory turnovers 39.56 423 1978
service: total monetary turnovers 53.92 8 2696
service: aggregate perf. data 5.24 1818 262
service: refresh index statistics 0.04 7130 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-11-2026 11:51:06 to 16-11-2026 11:51:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8363
TEST_TIME 2 10507
TEST_TIME 3 11409
TEST_TIME 4 11800
TEST_TIME 5 12416
TEST_TIME 6 12699
TEST_TIME 7 12892
TEST_TIME 8 13215
TEST_TIME 9 13369
TEST_TIME 10 13525
TEST_TIME 11 13706
TEST_TIME 12 13771
TEST_TIME 13 13813
TEST_TIME 14 13963
TEST_TIME 15 14002
TEST_TIME 16 14001
TEST_TIME 17 13918
TEST_TIME 18 14097
TEST_TIME 19 14127
TEST_TIME 20 14198
TEST_TIME 21 14286
TEST_TIME 22 14260
TEST_TIME 23 14417
TEST_TIME 24 14485
TEST_TIME 25 14459
TEST_TIME 26 14494
TEST_TIME 27 14534
TEST_TIME 28 14444
TEST_TIME 29 14526
TEST_TIME 30 14401
TEST_TIME 31 14483
TEST_TIME 32 14552
TEST_TIME 33 14604
TEST_TIME 34 14666
TEST_TIME 35 14762
TEST_TIME 36 14795
TEST_TIME 37 14891
TEST_TIME 38 14843
TEST_TIME 39 15064
TEST_TIME 40 15086
TEST_TIME 41 15138
TEST_TIME 42 15150
TEST_TIME 43 15163
TEST_TIME 44 15260
TEST_TIME 45 15287
TEST_TIME 46 15283
TEST_TIME 47 15383
TEST_TIME 48 15381
TEST_TIME 49 15400
TEST_TIME 50 15437

Performance per minute, chart


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

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 1136599 1136599 0 0.00 0 1331 2 0 0
doc_list_biud 1136599 1136599 0 0.00 0 1567 5 0 0
sp_add_invoice_to_stock 7565 7565 0 0.00 6 10899 1533 0 0
sp_cancel_adding_invoice 5313 5313 0 0.00 2 3995 216 0 0
sp_cancel_client_order 2755 2755 0 0.00 3 816 47 0 0
sp_cancel_customer_reserve 275075 275075 0 0.00 1 1568 15 0 0
sp_cancel_pay_from_customer 1075 1075 0 0.00 2 135 18 0 0
sp_cancel_pay_to_supplier 632 632 0 0.00 2 237 16 0 0
sp_cancel_supplier_invoice 6454 6454 0 0.00 2 1127 145 0 0
sp_cancel_supplier_order 663 663 0 0.00 8 59444 8866 0 0
sp_cancel_write_off 9091 9091 0 0.00 1 1006 20 0 0
sp_client_order 33944 33944 0 0.00 4 1185 45 0 0
sp_customer_reserve 370769 370769 0 0.00 0 1912 27 0 0
sp_fill_shopping_cart 51449 51449 0 0.00 1 1599 20 0 0
sp_fill_shopping_cart_clo_res 370769 370769 0 0.00 0 1215 2 0 0
sp_get_clo_for_invoice 7565 7565 0 0.00 0 1403 36 0 0
sp_kill_cost_storno 16111 16111 0 0.00 0 635 9 0 0
sp_kill_qstorno_ret_qs2qd 566358 566358 0 0.00 0 1367 8 0 0
sp_kill_qty_storno 322787 322787 0 0.00 0 1565 18 0 0
sp_lock_selected_doc 32434 32434 0 0.00 0 420 2 0 0
sp_make_cost_storno 43635 43635 0 0.00 0 652 7 0 0
sp_multiply_rows_for_pdistr 43635 43635 0 0.00 0 685 9 0 0
sp_multiply_rows_for_qdistr 33944 33944 0 0.00 0 920 18 0 0
sp_pay_from_customer 11098 11098 0 0.00 3 790 33 0 0
sp_pay_to_supplier 9101 9101 0 0.00 3 768 29 0 0
sp_payment_common 20199 20199 0 0.00 1 654 7 0 0
sp_qd_handle_on_cancel_clo 2755 2755 0 0.00 0 799 31 0 0
sp_qd_handle_on_invoice_upd_sts 12878 12878 0 0.00 0 1288 72 0 0
sp_qd_handle_on_reserve_upd_sts 15871 15871 0 0.00 0 1193 11 0 0
sp_reserve_write_off 15871 15871 0 0.00 3 1202 36 0 0
sp_supplier_invoice 8821 8821 0 0.00 6 4395 341 0 0
sp_supplier_order 8684 8684 0 0.00 5 1346 202 0 0
srv_aggregate_perf_data 262 262 0 0.00 45 11287 1819 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 857 260 0 0
srv_find_qd_qs_mism 718740 718740 0 0.00 0 1331 1 0 0
srv_make_invnt_saldo 1978 1978 0 0.00 0 49195 424 0 0
srv_make_money_saldo 2696 2696 0 0.00 0 351 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 277 13983 7130 0 0
v_add_invoice_to_stock 15130 15130 0 0.00 0 675 3 0 0
v_all_customers 51390 51390 0 0.00 0 40 1 0 0
v_all_suppliers 42672 42672 0 0.00 0 43 1 0 0
v_all_wares 67888 67888 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 1262 1262 0 0.00 0 234 2 0 0
v_cancel_client_order 5510 5510 0 0.00 0 518 1 0 0
v_cancel_customer_prepayment 2150 2150 0 0.00 0 71 1 0 0
v_cancel_customer_reserve 1992 1992 0 0.00 0 337 2 0 0
v_cancel_payment_to_supplier 1264 1264 0 0.00 0 132 1 0 0
v_cancel_supplier_invoice 1234 1234 0 0.00 0 680 4 0 0
v_cancel_supplier_order 1326 1326 0 0.00 0 32 1 0 0
v_cancel_write_off 3258 3258 0 0.00 0 197 2 0 0
v_max_id_clo_ord 8684 8684 0 0.00 0 46 1 0 0
v_max_id_clo_res 1600 1600 0 0.00 0 40 1 0 0
v_max_id_ord_sup 8821 8821 0 0.00 0 845 2 0 0
v_max_non_paid_invoice 5270 5270 0 0.00 0 123 1 0 0
v_max_non_paid_realizn 10705 10705 0 0.00 0 61 1 0 0
v_min_id_clo_ord 8684 8684 0 0.00 0 202 3 0 0
v_min_id_clo_res 1600 1600 0 0.00 0 337 4 0 0
v_min_id_ord_sup 8821 8821 0 0.00 0 703 4 0 0
v_min_non_paid_invoice 9101 9101 0 0.00 0 444 3 0 0
v_min_non_paid_realizn 11098 11098 0 0.00 0 648 2 0 0
v_our_firm 17284 17284 0 0.00 0 29 1 0 0
v_reserve_write_off 31742 31742 0 0.00 0 627 2 0 0
x_lock_depdocs_on_canc_invoice 11150 11150 0 0.00 0 961 10 0 0
x_lock_depdocs_on_canc_sup_ord 663 663 0 0.00 0 109 10 0 0
x_make_qstorno_1000_1200 8684 8684 0 0.00 1 1334 146 0 0
x_make_qstorno_1200_2000 8821 8821 0 0.00 1 4374 297 0 0
x_make_qstorno_2100_3300 370769 370769 0 0.00 0 1911 23 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 16-11-2026 11:51:12 to 16-11-2026 11:51:15.

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
11:00:58 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:01:58 163 2147483648 2574471328 2654277632 243554208 10.186 19 10 20 0 245855856 547824 1753824
11:02:58 213 2147483648 2584464624 2666921984 252497680 10.520 19 14 28 0 256388032 1391536 2498816
11:03:59 180 2147483648 2601265840 2688180224 269856800 11.163 20 9 18 0 273036784 1199472 1980512
11:04:59 161 2147483648 2577125472 2658164736 244534400 10.222 19 12 24 0 248247680 1272960 2440320
11:05:59 194 2147483648 2585519840 2669907968 253571296 10.560 19 9 18 0 256451056 1395136 1484624
11:07:00 157 2147483648 2599709888 2685050880 266082448 11.024 20 10 19 1 268854912 1206400 1566064
11:08:01 192 2147483648 2595652304 2684452864 264977376 10.983 20 4 8 0 266125280 776640 371264
11:09:01 856 2147483648 2600570128 2687864832 267069776 11.060 20 10 20 0 270379616 1632256 1677584
11:10:02 274 2147483648 2601689456 2688458752 267898912 11.091 20 13 24 0 271769168 1595792 2274464
11:11:03 256 2147483648 2591327568 2677239808 257928320 10.722 20 14 26 0 261440320 1129888 2382112
11:12:04 266 2147483648 2591321824 2677833728 257773104 10.717 20 10 20 0 261105408 1455456 1876848
11:13:04 248 2147483648 2596480528 2684854272 263243536 10.919 20 12 21 1 267480544 1794912 2442096
11:14:05 112 2147483648 2602711632 2688872448 265607856 11.006 20 16 30 0 271520816 2988544 2924416
11:15:05 265 2147483648 2602382864 2690355200 267761120 11.086 20 14 28 0 272729648 2484512 2484016
11:16:07 226 2147483648 2597615216 2685718528 263552656 10.931 20 11 22 0 266883088 1371616 1958816
11:17:08 192 2147483648 2580578064 2666672128 248223120 10.361 19 7 12 0 250439968 1103904 1112944
11:18:08 131 2147483648 2586628016 2672566272 251388656 10.479 20 11 22 1 255399056 1813504 2196896
11:19:09 269 2147483648 2597962240 2684616704 260549200 10.820 20 15 30 0 266841568 3568928 2723440
11:20:09 102 2147483648 2604189632 2693193728 269243872 11.140 20 12 24 0 273514832 2027392 2243568
11:21:09 279 2147483648 2605147552 2693988352 269480592 11.149 20 13 26 0 273995184 1812976 2701616
11:22:10 165 2147483648 2593300832 2680729600 259121584 10.767 20 13 28 0 263312720 1097552 3093584
11:23:10 180 2147483648 2604383600 2692546560 267920320 11.092 20 11 22 0 272729584 1924416 2884848
11:24:10 114 2147483648 2604601632 2693570560 269789824 11.160 20 12 25 0 274592688 1710368 3092496
11:25:11 196 2147483648 2588036976 2675732480 255357168 10.627 20 11 22 0 258427536 1028832 2041536
11:26:11 114 2147483648 2602792400 2691870720 268213056 11.102 20 13 26 1 272671024 1681888 2776080
11:27:12 340 2147483648 2600320448 2690936832 267824224 11.088 20 8 14 0 270611344 1294288 1492832
11:28:12 420 2147483648 2596036960 2684739584 263231584 10.919 20 7 12 0 267069024 2397168 1440272
11:29:13 158 2147483648 2603527616 2692796416 268335328 11.107 20 12 24 0 273082960 2431936 2315696
11:30:13 321 2147483648 2609656720 2699026432 270889952 11.201 20 11 22 0 278610096 5557632 2162512
11:31:14 139 2147483648 2592809136 2677690368 256062176 10.653 19 15 30 2 261942576 2802144 3078256
11:32:14 305 2147483648 2605336512 2694299648 268029920 11.096 20 16 32 0 274089808 3008000 3051888
11:33:15 142 2147483648 2604579200 2693644288 267775872 11.086 20 13 24 1 273985984 3004688 3205424
11:34:15 657 2147483648 2593665872 2682265600 259454528 10.779 20 11 21 0 262827696 1372176 2000992
11:35:16 624 2147483648 2605254864 2692812800 267453968 11.074 20 17 34 0 273832720 2659856 3718896
11:36:17 147 2147483648 2601749248 2691588096 267570176 11.079 20 8 16 0 270894864 1876080 1448608
11:37:17 112 2147483648 2602453856 2691641344 265932608 11.018 20 9 18 0 270876272 3372512 1571152
11:38:18 245 2147483648 2591897312 2680115200 257910224 10.722 20 11 22 1 261961200 1271536 2779440
11:39:18 181 2147483648 2602362816 2688991232 265664800 11.009 20 12 23 0 270440384 2609072 2166512
11:40:18 548 2147483648 2598065968 2686357504 263158384 10.916 20 11 20 0 266779424 1914864 1706176
11:41:19 286 2147483648 2598675600 2690826240 264231456 10.956 20 9 14 1 268388544 2673344 1483744
11:42:19 511 2147483648 2601261312 2691870720 266682464 11.046 20 3 6 1 269309552 2076992 550096
11:43:20 201 2147483648 2594082336 2684555264 261746544 10.864 20 6 13 0 263889312 1104768 1038000
11:44:20 186 2147483648 2598507488 2687791104 263095248 10.914 20 9 18 0 267197360 2272640 1829472
11:45:21 293 2147483648 2601997792 2691788800 265844592 11.015 20 10 20 0 270740304 2819904 2075808
11:46:21 431 2147483648 2599438272 2691411968 267451568 11.074 20 5 10 0 269329296 969824 907904
11:47:22 219 2147483648 2593184304 2679255040 256306784 10.662 20 11 22 0 261603856 3113312 2183760
11:48:22 431 2147483648 2602786544 2692055040 267263888 11.067 20 14 28 0 272109488 2203408 2642192
11:49:23 144 2147483648 2597015984 2684981248 261127344 10.841 20 14 27 1 265502816 1726160 2649312
11:50:23 225 2147483648 2599296496 2688397312 264460176 10.964 20 9 18 0 268026272 2061792 1504304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 16-11-2026 11:51:16 to 16-11-2026 11:51:28.

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 16-11-2026 11:51:28 to 16-11-2026 11:51:29.

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          228835
MON$OLDEST_ACTIVE               229567
MON$OLDEST_SNAPSHOT             229567
MON$NEXT_TRANSACTION            229567
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-16 11:00:08.5680
MON$PAGES                       140480
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    Mon Nov 16 11:50:55 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Mon Nov 16 11:50:55 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'

16.11.26 11:51:30. There are 6 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-16 11:51:31 No severe PSQL-related problems occured
16.11.26 11:51:32. End of report.