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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID 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 2w
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 1854836 kB
MemAvailable 7272356 kB
Buffers 81536 kB
Cached 5454192 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-14 11:50:55
DTS_END                         2026-11-14 11:50:55.1860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(37:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/46888
TRN_ID                          232290
ATT_ID                          469
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: 15603.58 774 780179
customer order: creation 684.32 45 34216
customer order: refuse 55.82 47 2791
order to supplier: creation 175.62 205 8781
order to supplier: removal 13.40 8526 670
invoice (draft): creation 174.90 354 8745
invoice (draft): removal 123.46 152 6173
invoice accept: apply 150.22 1590 7511
invoice accept: cancel 102.12 209 5106
customer reserve: creation 7651.26 26 382563
customer reserve: removal 5420.02 14 271001
realization accept: apply 323.78 39 16189
realization accept: cancel 182.30 19 9115
payment from customer: creation 226.38 39 11319
payment from customer: removal 22.74 18 1137
payment to supplier: creation 185.32 30 9266
payment to supplier: removal 12.96 17 648
service: total inventory turnovers 39.96 446 1998
service: total monetary turnovers 53.36 8 2668
service: aggregate perf. data 5.60 1670 280
service: refresh index statistics 0.04 2030 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 14-11-2026 11:51:07 to 14-11-2026 11:51:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9093
TEST_TIME 2 10974
TEST_TIME 3 11680
TEST_TIME 4 12200
TEST_TIME 5 12515
TEST_TIME 6 12858
TEST_TIME 7 13105
TEST_TIME 8 13139
TEST_TIME 9 13591
TEST_TIME 10 13497
TEST_TIME 11 13740
TEST_TIME 12 13942
TEST_TIME 13 14012
TEST_TIME 14 14066
TEST_TIME 15 14189
TEST_TIME 16 14126
TEST_TIME 17 14210
TEST_TIME 18 14281
TEST_TIME 19 14352
TEST_TIME 20 14288
TEST_TIME 21 14382
TEST_TIME 22 14334
TEST_TIME 23 14412
TEST_TIME 24 14446
TEST_TIME 25 14418
TEST_TIME 26 14592
TEST_TIME 27 14571
TEST_TIME 28 14629
TEST_TIME 29 14627
TEST_TIME 30 14667
TEST_TIME 31 14716
TEST_TIME 32 14733
TEST_TIME 33 14763
TEST_TIME 34 14759
TEST_TIME 35 14944
TEST_TIME 36 14931
TEST_TIME 37 14972
TEST_TIME 38 15031
TEST_TIME 39 15181
TEST_TIME 40 15212
TEST_TIME 41 15218
TEST_TIME 42 15278
TEST_TIME 43 15341
TEST_TIME 44 15459
TEST_TIME 45 15489
TEST_TIME 46 15533
TEST_TIME 47 15597
TEST_TIME 48 15602
TEST_TIME 49 15591
TEST_TIME 50 15604

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-11-2026 11:51:09 to 14-11-2026 11:51:12.

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 1152702 1152702 0 0.00 0 1112 2 0 0
doc_list_biud 1152702 1152702 0 0.00 0 1572 5 0 0
sp_add_invoice_to_stock 7511 7511 0 0.00 6 12974 1591 0 0
sp_cancel_adding_invoice 5106 5106 0 0.00 3 5732 210 0 0
sp_cancel_client_order 2791 2791 0 0.00 3 969 47 0 0
sp_cancel_customer_reserve 271001 271001 0 0.00 1 1574 15 0 0
sp_cancel_pay_from_customer 1137 1137 0 0.00 2 263 19 0 0
sp_cancel_pay_to_supplier 648 648 0 0.00 2 263 17 0 0
sp_cancel_supplier_invoice 6173 6173 0 0.00 1 1202 153 0 0
sp_cancel_supplier_order 670 670 0 0.00 8 63240 8526 0 0
sp_cancel_write_off 9115 9115 0 0.00 1 644 20 0 0
sp_client_order 34216 34216 0 0.00 4 1532 46 0 0
sp_customer_reserve 382563 382563 0 0.00 0 2658 26 0 0
sp_fill_shopping_cart 51742 51742 0 0.00 1 1482 21 0 0
sp_fill_shopping_cart_clo_res 382563 382563 0 0.00 0 1520 2 0 0
sp_get_clo_for_invoice 7511 7511 0 0.00 0 1855 39 0 0
sp_kill_cost_storno 16006 16006 0 0.00 0 387 9 0 0
sp_kill_qstorno_ret_qs2qd 557960 557960 0 0.00 0 1501 7 0 0
sp_kill_qty_storno 318556 318556 0 0.00 0 1571 17 0 0
sp_lock_selected_doc 32828 32828 0 0.00 0 251 2 0 0
sp_make_cost_storno 44285 44285 0 0.00 0 685 7 0 0
sp_multiply_rows_for_pdistr 44285 44285 0 0.00 0 687 10 0 0
sp_multiply_rows_for_qdistr 34216 34216 0 0.00 0 785 18 0 0
sp_pay_from_customer 11319 11319 0 0.00 3 818 39 0 0
sp_pay_to_supplier 9266 9266 0 0.00 3 787 31 0 0
sp_payment_common 20585 20585 0 0.00 1 766 12 0 0
sp_qd_handle_on_cancel_clo 2791 2791 0 0.00 0 958 31 0 0
sp_qd_handle_on_invoice_upd_sts 12617 12617 0 0.00 0 1345 73 0 0
sp_qd_handle_on_reserve_upd_sts 16189 16189 0 0.00 0 1131 10 0 0
sp_reserve_write_off 16189 16189 0 0.00 3 1150 40 0 0
sp_supplier_invoice 8745 8745 0 0.00 5 4717 354 0 0
sp_supplier_order 8781 8781 0 0.00 5 1671 205 0 0
srv_aggregate_perf_data 280 280 0 0.00 51 12119 1671 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 1211 247 0 0
srv_find_qd_qs_mism 724444 724444 0 0.00 0 1111 1 0 0
srv_make_invnt_saldo 1998 1998 0 0.00 0 70345 447 0 0
srv_make_money_saldo 2668 2668 0 0.00 0 563 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 253 3808 2031 0 0
v_add_invoice_to_stock 15022 15022 0 0.00 0 254 3 0 0
v_all_customers 52072 52072 0 0.00 0 36 1 0 0
v_all_suppliers 43078 43078 0 0.00 0 36 1 0 0
v_all_wares 68432 68432 0 0.00 0 49 1 0 0
v_cancel_adding_invoice 1192 1192 0 0.00 0 239 2 0 0
v_cancel_client_order 5582 5582 0 0.00 0 341 1 0 0
v_cancel_customer_prepayment 2274 2274 0 0.00 0 243 1 0 0
v_cancel_customer_reserve 2202 2202 0 0.00 0 195 2 0 0
v_cancel_payment_to_supplier 1296 1296 0 0.00 0 126 2 0 0
v_cancel_supplier_invoice 1234 1234 0 0.00 0 230 3 0 0
v_cancel_supplier_order 1340 1340 0 0.00 0 82 2 0 0
v_cancel_write_off 3136 3136 0 0.00 0 449 2 0 0
v_max_id_clo_ord 8781 8781 0 0.00 0 53 1 0 0
v_max_id_clo_res 1659 1659 0 0.00 0 391 2 0 0
v_max_id_ord_sup 8745 8745 0 0.00 0 772 2 0 0
v_max_non_paid_invoice 5253 5253 0 0.00 0 96 2 0 0
v_max_non_paid_realizn 10964 10964 0 0.00 0 236 2 0 0
v_min_id_clo_ord 8781 8781 0 0.00 0 408 3 0 0
v_min_id_clo_res 1659 1659 0 0.00 0 710 4 0 0
v_min_id_ord_sup 8745 8745 0 0.00 0 777 4 0 0
v_min_non_paid_invoice 9266 9266 0 0.00 0 552 4 0 0
v_min_non_paid_realizn 11319 11319 0 0.00 0 760 7 0 0
v_our_firm 17070 17070 0 0.00 0 36 1 0 0
v_reserve_write_off 32378 32378 0 0.00 0 648 1 0 0
x_lock_depdocs_on_canc_invoice 10662 10662 0 0.00 0 736 10 0 0
x_lock_depdocs_on_canc_sup_ord 670 670 0 0.00 0 133 10 0 0
x_make_qstorno_1000_1200 8781 8781 0 0.00 1 1385 149 0 0
x_make_qstorno_1200_2000 8745 8745 0 0.00 1 4177 309 0 0
x_make_qstorno_2100_3300 382563 382563 0 0.00 0 2658 23 0 0

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

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 4 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
11:01:59 298 2147483648 2582965840 2662944768 250474512 10.445 20 17 33 1 254875952 716432 3685008
11:02:59 200 2147483648 2603607872 2691256320 272570832 11.263 20 8 17 0 274607488 671584 1365072
11:04:00 148 2147483648 2603660800 2689318912 269474704 11.149 20 12 24 0 273400304 1308800 2616800
11:05:00 491 2147483648 2592856160 2676719616 259111296 10.766 20 11 22 1 262713712 1437056 2165360
11:06:01 299 2147483648 2572796560 2655858688 242121200 10.132 20 7 12 0 244720816 673728 1925888
11:07:01 373 2147483648 2598467984 2684575744 262679568 10.898 20 14 28 1 266907328 1690464 2537296
11:08:02 184 2147483648 2596626304 2684391424 264270800 10.957 20 12 24 1 267226544 989296 1966448
11:09:02 119 2147483648 2600085248 2685759488 264055072 10.949 20 13 24 1 270519792 3381552 3083168
11:10:03 889 2147483648 2599432912 2686676992 265157120 10.990 20 8 17 0 268296624 1169648 1969856
11:11:04 411 2147483648 2592353968 2679685120 259154208 10.768 20 10 20 0 262933552 1770416 2008928
11:12:05 152 2147483648 2600789312 2688720896 267147840 11.063 20 12 24 0 271035392 1054096 2833456
11:13:05 209 2147483648 2597504336 2686287872 263559824 10.931 20 10 21 0 267681168 1694720 2426624
11:14:05 122 2147483648 2595725488 2683486208 261059968 10.838 20 11 22 0 265945616 1766016 3119632
11:15:06 138 2147483648 2602238896 2689392640 266103968 11.025 20 13 26 0 271817952 2553312 3160672
11:16:06 480 2147483648 2592553024 2678886400 257973648 10.724 20 13 24 0 262591168 2011600 2605920
11:17:07 171 2147483648 2598891504 2686693376 263995200 10.947 20 10 21 0 268840016 2482944 2361872
11:18:07 176 2147483648 2598712624 2687397888 265005664 10.984 20 9 18 0 268422288 1582752 1833872
11:19:07 170 2147483648 2591756320 2678419456 256934480 10.685 20 11 22 0 260171680 1211680 2025520
11:20:08 134 2147483648 2603670464 2692329472 268102336 11.098 20 9 18 0 272471808 2605120 1764352
11:21:08 206 2147483648 2595778176 2681716736 260098304 10.803 20 12 24 0 265274592 2631504 2544784
11:22:09 371 2147483648 2597556784 2687459328 264767328 10.975 20 7 15 0 267771136 1663328 1340480
11:23:09 217 2147483648 2605199456 2696065024 271887024 11.237 20 8 16 0 275578064 1961424 1729616
11:24:10 432 2147483648 2598394592 2687541248 264348880 10.960 20 7 13 0 267247168 1382400 1515888
11:25:11 201 2147483648 2600344016 2688593920 265822400 11.014 20 9 18 0 269884640 2485328 1576912
11:26:11 670 2147483648 2609280048 2696912896 273964704 11.314 20 11 22 0 279269088 3022352 2282032
11:27:12 247 2147483648 2609809808 2698444800 270439952 11.184 20 15 30 0 277567504 3968560 3158992
11:28:13 131 2147483648 2584148272 2669383680 248414640 10.368 19 14 28 0 254314544 2860416 3039488
11:29:14 139 2147483648 2602907680 2692489216 267497968 11.076 20 12 24 1 272153104 2062240 2592896
11:30:14 129 2147483648 2602889504 2692440064 268016096 11.095 20 14 28 0 272369920 1761200 2592624
11:31:15 175 2147483648 2598871040 2687627264 265296768 10.995 20 15 28 1 269823952 1335984 3191200
11:32:15 104 2147483648 2583551104 2669637632 250279856 10.438 19 9 14 1 254103328 1770688 2052784
11:33:15 107 2147483648 2601765824 2693177344 268280112 11.105 20 8 16 0 271071136 1294416 1496608
11:34:16 240 2147483648 2603535408 2693181440 269288864 11.142 20 8 16 0 272838768 2082784 1467120
11:35:16 234 2147483648 2600575424 2691133440 266207888 11.029 20 12 22 1 270995552 2509680 2277984
11:36:16 111 2147483648 2600724064 2690801664 267429472 11.074 20 10 20 0 271389888 1425008 2535408
11:37:17 111 2147483648 2598718688 2687950848 263834512 10.941 20 13 25 0 267334272 1283632 2216128
11:38:17 183 2147483648 2595609552 2684338176 261487696 10.854 20 12 22 1 265814304 1314448 3012160
11:39:18 1211 2147483648 2595548800 2685816832 262467104 10.890 20 8 15 0 265057504 1280912 1309488
11:40:20 85 2147483648 2596482048 2685497344 261790112 10.865 20 9 18 0 265778960 2454576 1534272
11:41:21 214 2147483648 2593681296 2683658240 261111904 10.840 20 12 23 1 264461488 875120 2474464
11:42:21 246 2147483648 2601794432 2692194304 267655280 11.082 20 10 20 0 271044496 1410032 1979184
11:43:21 178 2147483648 2596182320 2686021632 262075632 10.876 20 7 14 0 265640208 2119120 1445456
11:44:22 176 2147483648 2599652256 2687832064 263714752 10.937 20 11 20 0 268160224 2384112 2061360
11:45:24 262 2147483648 2597056400 2686410752 261909408 10.870 20 9 18 0 266275872 2605296 1761168
11:46:24 113 2147483648 2602472528 2691158016 263704096 10.936 20 11 22 0 271324384 5361840 2258448
11:47:25 84 2147483648 2592503456 2680459264 257293376 10.699 20 12 23 0 261350672 2086848 1970448
11:48:25 204 2147483648 2600345008 2687627264 263233296 10.919 20 16 33 0 268450368 1922880 3294192
11:49:26 111 2147483648 2599241232 2688335872 264005328 10.947 20 14 27 0 268435536 1764864 2665344
11:50:26 122 2147483648 2593167056 2681360384 258962304 10.761 20 12 24 0 263018816 1601248 2455264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 14-11-2026 11:51:16 to 14-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 14-11-2026 11:51:29 to 14-11-2026 11:51:30.

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          232438
MON$OLDEST_ACTIVE               232439
MON$OLDEST_SNAPSHOT             232439
MON$NEXT_TRANSACTION            232439
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-14 11:00:08.5390
MON$PAGES                       143936
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    Sat Nov 14 11:50:56 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'

14.11.26 11:51:30. 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-14 11:51:31 No severe PSQL-related problems occured
14.11.26 11:51:32. End of report.