Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.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 2d
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 1735560 kB
MemAvailable 7268708 kB
Buffers 82876 kB
Cached 5572072 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-02 23:51:16
DTS_END                         2026-11-02 23:51:16.9450
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/58208
TRN_ID                          191791
ATT_ID                          409
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: 11495.40 1009 574770
customer order: creation 563.56 55 28178
customer order: refuse 46.88 50 2344
order to supplier: creation 143.86 228 7193
order to supplier: removal 10.02 9069 501
invoice (draft): creation 145.74 363 7287
invoice (draft): removal 99.80 145 4990
invoice accept: apply 124.32 1695 6216
invoice accept: cancel 81.72 218 4086
customer reserve: creation 5508.14 32 275407
customer reserve: removal 3913.40 16 195670
realization accept: apply 264.50 43 13225
realization accept: cancel 140.26 24 7013
payment from customer: creation 187.54 42 9377
payment from customer: removal 18.90 22 945
payment to supplier: creation 154.00 35 7700
payment to supplier: removal 10.90 20 545
service: total inventory turnovers 32.60 563 1630
service: total monetary turnovers 44.18 7 2209
service: aggregate perf. data 5.04 1389 252
service: refresh index statistics 0.04 6169 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 02-11-2026 23:51:30 to 02-11-2026 23:51:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10330
TEST_TIME 2 9596
TEST_TIME 3 9428
TEST_TIME 4 9371
TEST_TIME 5 9324
TEST_TIME 6 9179
TEST_TIME 7 9378
TEST_TIME 8 9276
TEST_TIME 9 9390
TEST_TIME 10 9504
TEST_TIME 11 9577
TEST_TIME 12 9576
TEST_TIME 13 9719
TEST_TIME 14 9726
TEST_TIME 15 9767
TEST_TIME 16 9927
TEST_TIME 17 9888
TEST_TIME 18 9981
TEST_TIME 19 9985
TEST_TIME 20 10068
TEST_TIME 21 10141
TEST_TIME 22 10136
TEST_TIME 23 10264
TEST_TIME 24 10296
TEST_TIME 25 10389
TEST_TIME 26 10458
TEST_TIME 27 10551
TEST_TIME 28 10606
TEST_TIME 29 10558
TEST_TIME 30 10639
TEST_TIME 31 10704
TEST_TIME 32 10778
TEST_TIME 33 10879
TEST_TIME 34 10884
TEST_TIME 35 11027
TEST_TIME 36 11064
TEST_TIME 37 11097
TEST_TIME 38 11193
TEST_TIME 39 11218
TEST_TIME 40 11249
TEST_TIME 41 11356
TEST_TIME 42 11323
TEST_TIME 43 11336
TEST_TIME 44 11491
TEST_TIME 45 11465
TEST_TIME 46 11514
TEST_TIME 47 11519
TEST_TIME 48 11558
TEST_TIME 49 11551
TEST_TIME 50 11495

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-11-2026 23:51:32 to 02-11-2026 23:51:35.

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 852712 852712 0 0.00 0 817 2 0 0
doc_list_biud 852712 852712 0 0.00 0 2255 6 0 0
sp_add_invoice_to_stock 6216 6216 0 0.00 7 13265 1696 0 0
sp_cancel_adding_invoice 4086 4086 0 0.00 3 4290 218 0 0
sp_cancel_client_order 2344 2344 0 0.00 3 848 50 0 0
sp_cancel_customer_reserve 195670 195670 0 0.00 1 2036 17 0 0
sp_cancel_pay_from_customer 945 945 0 0.00 2 250 22 0 0
sp_cancel_pay_to_supplier 545 545 0 0.00 2 209 21 0 0
sp_cancel_supplier_invoice 4990 4990 0 0.00 1 1295 145 0 0
sp_cancel_supplier_order 501 501 0 0.00 4 48741 9069 0 0
sp_cancel_write_off 7013 7013 0 0.00 1 1099 24 0 0
sp_client_order 28178 28178 0 0.00 3 1538 56 0 0
sp_customer_reserve 275407 275407 0 0.00 0 2979 33 0 0
sp_fill_shopping_cart 42658 42658 0 0.00 1 1547 21 0 0
sp_fill_shopping_cart_clo_res 275407 275407 0 0.00 0 998 3 0 0
sp_get_clo_for_invoice 6216 6216 0 0.00 0 927 36 0 0
sp_kill_cost_storno 12589 12589 0 0.00 0 803 10 0 0
sp_kill_qstorno_ret_qs2qd 403844 403844 0 0.00 0 1776 8 0 0
sp_kill_qty_storno 234045 234045 0 0.00 0 2255 19 0 0
sp_lock_selected_doc 27027 27027 0 0.00 0 398 2 0 0
sp_make_cost_storno 36518 36518 0 0.00 0 671 7 0 0
sp_multiply_rows_for_pdistr 36518 36518 0 0.00 0 423 11 0 0
sp_multiply_rows_for_qdistr 28178 28178 0 0.00 0 1196 21 0 0
sp_pay_from_customer 9377 9377 0 0.00 3 754 42 0 0
sp_pay_to_supplier 7700 7700 0 0.00 3 579 35 0 0
sp_payment_common 17077 17077 0 0.00 1 526 12 0 0
sp_qd_handle_on_cancel_clo 2344 2344 0 0.00 0 818 32 0 0
sp_qd_handle_on_invoice_upd_sts 10302 10302 0 0.00 0 2253 72 0 0
sp_qd_handle_on_reserve_upd_sts 13225 13225 0 0.00 0 1275 12 0 0
sp_reserve_write_off 13225 13225 0 0.00 3 1287 43 0 0
sp_supplier_invoice 7287 7287 0 0.00 6 4085 363 0 0
sp_supplier_order 7193 7193 0 0.00 5 2448 229 0 0
srv_aggregate_perf_data 252 252 0 0.00 12 8807 1390 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1508 346 0 0
srv_find_qd_qs_mism 534095 534095 0 0.00 0 804 2 0 0
srv_make_invnt_saldo 1630 1630 0 0.00 0 85568 563 0 0
srv_make_money_saldo 2209 2209 0 0.00 0 300 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 517 11822 6170 0 0
v_add_invoice_to_stock 12432 12432 0 0.00 0 723 3 0 0
v_all_customers 42632 42632 0 0.00 0 86 1 0 0
v_all_suppliers 34844 34844 0 0.00 0 60 1 0 0
v_all_wares 56356 56356 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 1018 1018 0 0.00 0 158 2 0 0
v_cancel_client_order 4688 4688 0 0.00 0 387 2 0 0
v_cancel_customer_prepayment 1890 1890 0 0.00 0 246 2 0 0
v_cancel_customer_reserve 1898 1898 0 0.00 0 119 2 0 0
v_cancel_payment_to_supplier 1090 1090 0 0.00 0 103 2 0 0
v_cancel_supplier_invoice 1026 1026 0 0.00 0 74 3 0 0
v_cancel_supplier_order 1002 1002 0 0.00 0 364 2 0 0
v_cancel_write_off 2560 2560 0 0.00 0 215 2 0 0
v_max_id_clo_ord 7193 7193 0 0.00 0 55 1 0 0
v_max_id_clo_res 1275 1275 0 0.00 0 336 2 0 0
v_max_id_ord_sup 7287 7287 0 0.00 0 723 2 0 0
v_max_non_paid_invoice 4758 4758 0 0.00 0 93 2 0 0
v_max_non_paid_realizn 9094 9094 0 0.00 0 197 2 0 0
v_min_id_clo_ord 7193 7193 0 0.00 0 328 3 0 0
v_min_id_clo_res 1275 1275 0 0.00 0 734 8 0 0
v_min_id_ord_sup 7287 7287 0 0.00 0 1019 6 0 0
v_min_non_paid_invoice 7700 7700 0 0.00 0 316 4 0 0
v_min_non_paid_realizn 9377 9377 0 0.00 0 351 7 0 0
v_our_firm 14290 14290 0 0.00 0 47 1 0 0
v_reserve_write_off 26450 26450 0 0.00 0 658 2 0 0
x_lock_depdocs_on_canc_invoice 8563 8563 0 0.00 0 878 9 0 0
x_lock_depdocs_on_canc_sup_ord 501 501 0 0.00 0 469 11 0 0
x_make_qstorno_1000_1200 7193 7193 0 0.00 1 2231 172 0 0
x_make_qstorno_1200_2000 7287 7287 0 0.00 1 3970 314 0 0
x_make_qstorno_2100_3300 275407 275407 0 0.00 0 2978 28 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 02-11-2026 23:51:35 to 02-11-2026 23:51:40.

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:21 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:21 269 2147483648 2606084160 2691977216 273857376 11.310 20 13 22 0 277084352 889104 2337872
23:03:22 307 2147483648 2594821216 2679721984 264130576 10.952 20 4 8 0 266319984 731472 1457936
23:04:23 272 2147483648 2605503664 2693431296 274800944 11.344 20 6 12 0 276723248 959776 962528
23:05:23 217 2147483648 2599229440 2685046784 267118416 11.062 20 9 18 0 270245872 1179760 1947696
23:06:24 298 2147483648 2585728080 2668982272 254005568 10.577 20 7 14 0 256808288 956224 1846496
23:07:24 221 2147483648 2596900976 2681823232 264201472 10.955 20 9 19 0 268088208 1581312 2305424
23:08:25 605 2147483648 2604439888 2693169152 272569920 11.262 20 9 18 0 275587424 909104 2108400
23:09:26 153 2147483648 2594717296 2678681600 260742048 10.827 20 15 31 0 265752816 1580560 3430208
23:10:27 232 2147483648 2602229360 2690306048 268437232 11.111 20 9 18 0 271459184 967408 2054544
23:11:27 147 2147483648 2586614672 2671230976 252327760 10.514 20 11 21 0 256157760 1768512 2061488
23:12:28 379 2147483648 2602059920 2689978368 268558576 11.115 20 9 18 0 272382992 1254256 2570160
23:13:28 1415 2147483648 2591068384 2677182464 252685376 10.527 19 10 20 0 256000064 1120144 2194544
23:14:30 178 2147483648 2586798032 2672455680 254182752 10.583 20 10 16 0 257451696 1433584 1835360
23:15:31 899 2147483648 2600679552 2687569920 265740768 11.011 20 14 28 0 270289328 1087920 3460640
23:16:32 317 2147483648 2575426544 2656997376 238125920 9.981 18 14 27 0 242945488 2202608 2616960
23:17:34 419 2147483648 2597933888 2688258048 265970400 11.020 20 7 14 1 268402304 1019216 1412688
23:18:35 513 2147483648 2593658768 2682363904 260912848 10.833 20 12 24 0 264657808 1387744 2357216
23:19:35 137 2147483648 2602319280 2692018176 269481024 11.149 20 8 16 0 272726256 1498368 1746864
23:20:36 95 2147483648 2601942400 2690490368 268104784 11.098 20 10 20 0 271767360 1759552 1903024
23:21:36 194 2147483648 2596709584 2683461632 261922544 10.870 20 12 26 0 266682976 2119136 2641296
23:22:37 220 2147483648 2592819664 2682351616 259519504 10.781 20 8 16 0 263082240 1826144 1736592
23:23:37 220 2147483648 2599464736 2687930368 265492672 11.002 20 10 20 0 269373888 1933072 1948144
23:24:38 138 2147483648 2604827824 2692341760 268927984 11.129 20 16 32 0 274085808 2229440 2928384
23:25:38 436 2147483648 2602385184 2693693440 268766240 11.123 20 9 19 0 271929232 1617728 1545264
23:26:39 1093 2147483648 2598504032 2685853696 263037872 10.912 20 10 20 0 266416816 1447936 1931008
23:27:40 595 2147483648 2597555728 2686484480 264215792 10.955 20 8 16 0 267255504 1616576 1423136
23:28:41 141 2147483648 2600493136 2687553536 264793744 10.976 20 13 26 0 269683168 2378032 2511392
23:29:41 168 2147483648 2599136240 2688135168 265600336 11.006 20 8 16 0 268966816 1688016 1678464
23:30:42 106 2147483648 2594029504 2682556416 260832448 10.830 20 9 18 0 264025248 1592192 1600608
23:31:42 132 2147483648 2605688352 2692886528 268685568 11.120 20 16 32 1 274126272 2460096 2980608
23:32:42 170 2147483648 2596587392 2685079552 263025872 10.911 20 9 18 0 266428192 1902720 1499600
23:33:43 131 2147483648 2599085296 2687610880 265238816 10.993 20 11 23 0 269584160 1546544 2798800
23:34:43 185 2147483648 2592419904 2681663488 259901664 10.796 20 9 14 0 263091856 1386192 1804000
23:35:44 198 2147483648 2595561776 2683662336 262233024 10.882 20 9 17 0 265294464 1545760 1515680
23:36:44 333 2147483648 2600958400 2688503808 265357184 10.997 20 12 25 0 270684256 3098080 2228992
23:37:45 557 2147483648 2599717728 2689159168 265897808 11.017 20 6 13 0 268114144 1039712 1176624
23:38:46 266 2147483648 2604267248 2693255168 267564368 11.079 20 14 29 2 272924288 2640496 2719424
23:39:48 375 2147483648 2593840960 2680795136 258730784 10.752 20 13 24 0 263024784 1787936 2506064
23:40:48 217 2147483648 2598057872 2685902848 263016736 10.911 20 14 27 0 267234944 1957472 2260736
23:41:49 1507 2147483648 2602486528 2690904064 267231904 11.066 20 12 24 1 271368832 1849808 2287120
23:42:52 907 2147483648 2595954160 2683469824 261245424 10.845 20 11 22 0 264962752 1631520 2085808
23:43:53 228 2147483648 2596664528 2684452864 262463840 10.890 20 13 25 0 266399232 1701232 2234160
23:44:54 149 2147483648 2602842320 2688864256 266088464 11.024 20 13 26 0 271625664 2763120 2774080
23:45:54 247 2147483648 2603422688 2693353472 267614880 11.080 20 9 18 0 272505040 2903472 1986688
23:46:55 313 2147483648 2595879280 2683711488 259956512 10.798 20 14 28 0 264394016 1800800 2636704
23:47:55 316 2147483648 2597424128 2684170240 260373184 10.813 20 14 28 0 266883568 3362832 3147552
23:48:56 213 2147483648 2597276416 2689679360 265511872 11.003 20 5 10 0 267593440 1115904 965664
23:49:57 138 2147483648 2592643824 2679664640 257510544 10.707 20 13 26 0 262115376 2077200 2527632
23:50:57 115 2147483648 2599432576 2686287872 261669728 10.861 20 12 24 0 268594800 4054480 2870592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 02-11-2026 23:51:41 to 02-11-2026 23:51:56.

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 02-11-2026 23:51:57 to 02-11-2026 23:51:58.

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          192079
MON$OLDEST_ACTIVE               192080
MON$OLDEST_SNAPSHOT             192080
MON$NEXT_TRANSACTION            192080
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-02 23:00:10.0370
MON$PAGES                       120928
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 ---
--- end of diff output ---

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

02.11.26 23:51:59. 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-02 23:52:00 No severe PSQL-related problems occured
02.11.26 23:52:01. End of report.