Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 11.11.2026 05: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 4d
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 1933488 kB
MemAvailable 7318716 kB
Buffers 79840 kB
Cached 5425244 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-11 05:50:55
DTS_END                         2026-11-11 05:50:56.0100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/45870
TRN_ID                          233049
ATT_ID                          480
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: 15545.52 848 777276
customer order: creation 692.70 44 34635
customer order: refuse 57.86 49 2893
order to supplier: creation 173.48 199 8674
order to supplier: removal 12.64 8844 632
invoice (draft): creation 174.20 344 8710
invoice (draft): removal 122.74 143 6137
invoice accept: apply 151.50 1533 7575
invoice accept: cancel 103.36 215 5168
customer reserve: creation 7568.24 26 378412
customer reserve: removal 5426.42 15 271321
realization accept: apply 325.24 34 16262
realization accept: cancel 187.42 18 9371
payment from customer: creation 227.56 30 11378
payment from customer: removal 21.06 18 1053
payment to supplier: creation 188.38 33 9419
payment to supplier: removal 13.80 16 690
service: total inventory turnovers 39.26 465 1963
service: total monetary turnovers 54.48 8 2724
service: aggregate perf. data 5.14 1987 257
service: refresh index statistics 0.04 2936 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2026 05:51:10 to 11-11-2026 05:51:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8233
TEST_TIME 2 10107
TEST_TIME 3 10818
TEST_TIME 4 11759
TEST_TIME 5 11964
TEST_TIME 6 12220
TEST_TIME 7 12074
TEST_TIME 8 12372
TEST_TIME 9 12621
TEST_TIME 10 12815
TEST_TIME 11 13073
TEST_TIME 12 13187
TEST_TIME 13 13392
TEST_TIME 14 13333
TEST_TIME 15 13380
TEST_TIME 16 13491
TEST_TIME 17 13647
TEST_TIME 18 13733
TEST_TIME 19 13913
TEST_TIME 20 14025
TEST_TIME 21 14091
TEST_TIME 22 14135
TEST_TIME 23 14172
TEST_TIME 24 14198
TEST_TIME 25 14301
TEST_TIME 26 14276
TEST_TIME 27 14399
TEST_TIME 28 14443
TEST_TIME 29 14478
TEST_TIME 30 14508
TEST_TIME 31 14605
TEST_TIME 32 14574
TEST_TIME 33 14706
TEST_TIME 34 14736
TEST_TIME 35 14869
TEST_TIME 36 14910
TEST_TIME 37 14943
TEST_TIME 38 14988
TEST_TIME 39 15005
TEST_TIME 40 15046
TEST_TIME 41 15161
TEST_TIME 42 15147
TEST_TIME 43 15261
TEST_TIME 44 15272
TEST_TIME 45 15422
TEST_TIME 46 15421
TEST_TIME 47 15466
TEST_TIME 48 15513
TEST_TIME 49 15564
TEST_TIME 50 15546

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 11-11-2026 05:51:13 to 11-11-2026 05:51:15.

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 1148937 1148937 0 0.00 0 2346 2 0 0
doc_list_biud 1148937 1148937 0 0.00 0 1660 5 0 0
sp_add_invoice_to_stock 7575 7575 0 0.00 5 13588 1533 0 0
sp_cancel_adding_invoice 5168 5168 0 0.00 2 4528 215 0 0
sp_cancel_client_order 2893 2893 0 0.00 3 937 50 0 0
sp_cancel_customer_reserve 271321 271321 0 0.00 1 1416 15 0 0
sp_cancel_pay_from_customer 1053 1053 0 0.00 2 187 18 0 0
sp_cancel_pay_to_supplier 690 690 0 0.00 2 340 16 0 0
sp_cancel_supplier_invoice 6137 6137 0 0.00 2 2445 144 0 0
sp_cancel_supplier_order 632 632 0 0.00 9 59085 8844 0 0
sp_cancel_write_off 9371 9371 0 0.00 1 773 18 0 0
sp_client_order 34635 34635 0 0.00 4 1270 45 0 0
sp_customer_reserve 378412 378412 0 0.00 0 2363 26 0 0
sp_fill_shopping_cart 52019 52019 0 0.00 1 1760 20 0 0
sp_fill_shopping_cart_clo_res 378412 378412 0 0.00 0 1021 2 0 0
sp_get_clo_for_invoice 7575 7575 0 0.00 0 1040 36 0 0
sp_kill_cost_storno 16282 16282 0 0.00 0 331 8 0 0
sp_kill_qstorno_ret_qs2qd 558782 558782 0 0.00 0 1198 7 0 0
sp_kill_qty_storno 319359 319359 0 0.00 0 1654 17 0 0
sp_lock_selected_doc 32908 32908 0 0.00 0 246 2 0 0
sp_make_cost_storno 44634 44634 0 0.00 0 668 6 0 0
sp_multiply_rows_for_pdistr 44634 44634 0 0.00 0 608 9 0 0
sp_multiply_rows_for_qdistr 34635 34635 0 0.00 0 1253 18 0 0
sp_pay_from_customer 11378 11378 0 0.00 3 661 30 0 0
sp_pay_to_supplier 9419 9419 0 0.00 3 456 33 0 0
sp_payment_common 20797 20797 0 0.00 1 651 10 0 0
sp_qd_handle_on_cancel_clo 2893 2893 0 0.00 0 929 33 0 0
sp_qd_handle_on_invoice_upd_sts 12743 12743 0 0.00 0 1651 69 0 0
sp_qd_handle_on_reserve_upd_sts 16262 16262 0 0.00 0 917 10 0 0
sp_reserve_write_off 16262 16262 0 0.00 3 924 35 0 0
sp_supplier_invoice 8710 8710 0 0.00 5 3986 345 0 0
sp_supplier_order 8674 8674 0 0.00 6 1719 199 0 0
srv_aggregate_perf_data 257 257 0 0.00 9 25046 1988 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 2269 346 0 0
srv_find_qd_qs_mism 722878 722878 0 0.00 0 2346 1 0 0
srv_make_invnt_saldo 1963 1963 0 0.00 0 48144 466 0 0
srv_make_money_saldo 2724 2724 0 0.00 0 323 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 298 5574 2936 0 0
v_add_invoice_to_stock 15150 15150 0 0.00 0 369 3 0 0
v_all_customers 52904 52904 0 0.00 0 37 1 0 0
v_all_suppliers 42586 42586 0 0.00 0 65 1 0 0
v_all_wares 69270 69270 0 0.00 0 44 1 0 0
v_cancel_adding_invoice 1268 1268 0 0.00 0 295 2 0 0
v_cancel_client_order 5786 5786 0 0.00 0 311 1 0 0
v_cancel_customer_prepayment 2106 2106 0 0.00 0 129 1 0 0
v_cancel_customer_reserve 1994 1994 0 0.00 0 96 1 0 0
v_cancel_payment_to_supplier 1380 1380 0 0.00 0 309 2 0 0
v_cancel_supplier_invoice 1188 1188 0 0.00 0 119 3 0 0
v_cancel_supplier_order 1264 1264 0 0.00 0 349 2 0 0
v_cancel_write_off 3156 3156 0 0.00 0 214 2 0 0
v_max_id_clo_ord 8674 8674 0 0.00 0 32 1 0 0
v_max_id_clo_res 1557 1557 0 0.00 0 146 1 0 0
v_max_id_ord_sup 8710 8710 0 0.00 0 660 2 0 0
v_max_non_paid_invoice 5510 5510 0 0.00 0 46 2 0 0
v_max_non_paid_realizn 11028 11028 0 0.00 0 107 1 0 0
v_min_id_clo_ord 8674 8674 0 0.00 0 378 3 0 0
v_min_id_clo_res 1557 1557 0 0.00 0 598 4 0 0
v_min_id_ord_sup 8710 8710 0 0.00 0 602 5 0 0
v_min_non_paid_invoice 9419 9419 0 0.00 0 403 8 0 0
v_min_non_paid_realizn 11378 11378 0 0.00 0 644 3 0 0
v_our_firm 17066 17066 0 0.00 0 26 1 0 0
v_reserve_write_off 32524 32524 0 0.00 0 368 1 0 0
x_lock_depdocs_on_canc_invoice 10711 10711 0 0.00 0 974 9 0 0
x_lock_depdocs_on_canc_sup_ord 632 632 0 0.00 0 102 9 0 0
x_make_qstorno_1000_1200 8674 8674 0 0.00 1 1596 145 0 0
x_make_qstorno_1200_2000 8710 8710 0 0.00 1 3888 299 0 0
x_make_qstorno_2100_3300 378412 378412 0 0.00 0 2361 23 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2026 05:51:15 to 11-11-2026 05:51:19.

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
05:00:59 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:02:00 218 2147483648 2580675584 2662461440 249827520 10.421 19 8 17 0 252164976 635504 1701952
05:03:00 451 2147483648 2601866544 2687340544 269541456 11.151 20 16 30 0 273429344 824128 3063760
05:04:01 230 2147483648 2603779872 2688430080 268112064 11.099 20 14 28 0 272774736 1910144 2752528
05:05:02 512 2147483648 2589952000 2676731904 257728992 10.715 20 11 20 1 260770400 1369264 1672144
05:06:02 465 2147483648 2589042976 2674294784 256054672 10.653 20 8 16 0 258706000 1202128 1449200
05:07:03 210 2147483648 2602121328 2688933888 265780512 11.013 20 11 22 0 272223568 4271728 2171328
05:08:04 467 2147483648 2591837872 2680537088 256282624 10.661 20 9 18 0 259632560 1688768 1661168
05:09:05 160 2147483648 2600301968 2685775872 263814528 10.940 20 13 26 0 269839504 3141200 2883776
05:10:05 140 2147483648 2599277632 2686627840 265227856 10.992 20 11 22 0 270010032 1663280 3118896
05:11:06 149 2147483648 2582491136 2665959424 249780320 10.419 19 11 20 1 253284416 1525888 1978208
05:12:06 167 2147483648 2600969712 2687447040 265243936 10.993 20 13 26 0 269343520 1567008 2532576
05:13:07 223 2147483648 2593028528 2681958400 261656400 10.860 20 7 12 0 264385632 1467712 1261520
05:14:07 937 2147483648 2596257264 2684743680 262404352 10.888 20 13 26 0 266642736 1843312 2395072
05:15:08 275 2147483648 2594436320 2682228736 261821776 10.867 20 7 14 0 264494768 1271568 1401424
05:16:09 1056 2147483648 2599538560 2685833216 262036176 10.875 20 15 30 0 266567232 1505440 3025616
05:17:10 184 2147483648 2606168624 2695819264 271780432 11.234 20 11 22 0 275527872 1483968 2263472
05:18:10 120 2147483648 2595978992 2682769408 260035600 10.800 20 11 22 0 264765968 2091296 2639072
05:19:10 733 2147483648 2596524176 2689007616 264539136 10.967 20 8 16 0 267568176 1460240 1568800
05:20:11 216 2147483648 2604910544 2693062656 268652480 11.119 20 14 28 1 273984912 2362416 2970016
05:21:12 98 2147483648 2598608992 2686578688 263592000 10.932 20 11 22 0 267554496 1996384 1966112
05:22:12 139 2147483648 2605895680 2692538368 269970592 11.167 20 16 32 0 275654880 2438000 3246288
05:23:13 218 2147483648 2607222208 2696581120 270476208 11.186 20 13 26 0 276572208 3707152 2388848
05:24:13 198 2147483648 2602889360 2691883008 267372976 11.072 20 11 22 0 271709616 2078544 2258096
05:25:14 313 2147483648 2598791408 2686107648 263949776 10.945 20 9 18 0 268818080 2988464 1879840
05:26:14 528 2147483648 2597135616 2685902848 261107808 10.840 20 7 14 0 266476784 4296704 1072272
05:27:15 151 2147483648 2590739296 2676830208 254563936 10.597 20 14 28 0 259352368 2007232 2781200
05:28:15 166 2147483648 2591307776 2678239232 257467680 10.705 20 10 20 0 260716528 1667824 1581024
05:29:16 486 2147483648 2601520736 2690478080 265984176 11.020 20 10 20 0 271291824 3394416 1913232
05:30:17 156 2147483648 2582460800 2668486656 246916032 10.312 20 13 25 0 251448400 2131472 2400896
05:31:17 270 2147483648 2589450480 2678075392 256986880 10.687 19 6 12 0 260151056 1892224 1271952
05:32:18 486 2147483648 2602756096 2692485120 269943824 11.166 20 11 22 0 273128736 1316016 1868896
05:33:19 163 2147483648 2601919344 2689556480 265553632 11.004 20 13 25 0 270442144 2597264 2291248
05:34:19 221 2147483648 2598987296 2688524288 264619552 10.970 20 9 17 0 267814880 1663728 1531600
05:35:20 245 2147483648 2593206976 2682601472 260638400 10.823 20 9 16 0 263397968 1188288 1571280
05:36:20 656 2147483648 2598071200 2686595072 262167872 10.879 20 11 22 1 267371696 2780800 2423024
05:37:21 159 2147483648 2600593088 2690924544 267211904 11.066 20 12 23 1 270537648 1066656 2259088
05:38:22 723 2147483648 2598958912 2689654784 265306112 10.995 20 6 12 0 268361936 1803232 1252592
05:39:23 198 2147483648 2600815872 2690539520 266988288 11.057 20 11 21 1 270913152 2164320 1760544
05:40:23 2269 2147483648 2585219408 2670379008 246790304 10.307 19 11 22 0 250787728 1762368 2235056
05:41:25 238 2147483648 2599963520 2691219456 265603184 11.006 20 10 20 0 268886512 1459088 1824240
05:42:26 129 2147483648 2601856592 2692182016 267792736 11.087 20 10 20 0 271344064 1581648 1969680
05:43:26 227 2147483648 2597647264 2689163264 264441280 10.963 20 9 18 0 267633376 1617712 1574384
05:44:26 275 2147483648 2599321056 2689609728 264955376 10.982 20 7 14 0 269091408 2788384 1347648
05:45:28 198 2147483648 2601727504 2690625536 266282608 11.031 20 11 22 0 271001376 2256576 2462192
05:46:28 729 2147483648 2596091216 2686873600 262466896 10.890 20 7 14 0 265216000 1596288 1152816
05:47:29 121 2147483648 2597136480 2685300736 262909744 10.907 20 9 16 0 266106112 1544272 1652096
05:48:29 183 2147483648 2585258304 2674479104 249207520 10.397 19 9 18 2 251837664 971456 1658688
05:49:29 142 2147483648 2601618992 2691727360 266260240 11.031 20 11 21 0 270665296 1946480 2458576
05:50:30 124 2147483648 2602622768 2689146880 264790752 10.976 20 16 31 0 270376032 2430128 3155152

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 11-11-2026 05:51:32 to 11-11-2026 05:51:33.

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          231060
MON$OLDEST_ACTIVE               233274
MON$OLDEST_SNAPSHOT             233274
MON$NEXT_TRANSACTION            233274
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-11 05:00:09.3540
MON$PAGES                       146176
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    Wed Nov 11 05:50:57 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
:10: 
:11: test-0    Wed Nov 11 05:50:57 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'

11.11.26 05:51:33. 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-11 05:51:35 No severe PSQL-related problems occured
11.11.26 05:51:35. End of report.