Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.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 1w
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 1915716 kB
MemAvailable 7411948 kB
Buffers 91548 kB
Cached 5490124 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-07 23:51:03
DTS_END                         2026-11-07 23:51:03.0240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/38472
TRN_ID                          203737
ATT_ID                          423
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: 12328.44 844 616422
customer order: creation 600.34 52 30017
customer order: refuse 48.90 48 2445
order to supplier: creation 156.64 223 7832
order to supplier: removal 11.24 8696 562
invoice (draft): creation 154.38 365 7719
invoice (draft): removal 108.06 150 5403
invoice accept: apply 129.40 1649 6470
invoice accept: cancel 87.20 220 4360
customer reserve: creation 5892.00 31 294600
customer reserve: removal 4221.86 16 211093
realization accept: apply 280.26 38 14013
realization accept: cancel 155.04 22 7752
payment from customer: creation 200.32 39 10016
payment from customer: removal 19.08 20 954
payment to supplier: creation 165.96 34 8298
payment to supplier: removal 11.60 17 580
service: total inventory turnovers 33.32 558 1666
service: total monetary turnovers 48.32 7 2416
service: aggregate perf. data 4.48 1706 224
service: refresh index statistics 0.04 2989 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-11-2026 23:51:16 to 07-11-2026 23:51:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13145
TEST_TIME 2 11468
TEST_TIME 3 10988
TEST_TIME 4 10729
TEST_TIME 5 10493
TEST_TIME 6 10465
TEST_TIME 7 10326
TEST_TIME 8 10384
TEST_TIME 9 10451
TEST_TIME 10 10519
TEST_TIME 11 10680
TEST_TIME 12 10778
TEST_TIME 13 10990
TEST_TIME 14 11028
TEST_TIME 15 11099
TEST_TIME 16 11051
TEST_TIME 17 11124
TEST_TIME 18 11181
TEST_TIME 19 11272
TEST_TIME 20 11251
TEST_TIME 21 11295
TEST_TIME 22 11416
TEST_TIME 23 11429
TEST_TIME 24 11463
TEST_TIME 25 11453
TEST_TIME 26 11530
TEST_TIME 27 11559
TEST_TIME 28 11584
TEST_TIME 29 11677
TEST_TIME 30 11645
TEST_TIME 31 11739
TEST_TIME 32 11808
TEST_TIME 33 11870
TEST_TIME 34 11931
TEST_TIME 35 12049
TEST_TIME 36 12055
TEST_TIME 37 12157
TEST_TIME 38 12167
TEST_TIME 39 12173
TEST_TIME 40 12185
TEST_TIME 41 12289
TEST_TIME 42 12306
TEST_TIME 43 12330
TEST_TIME 44 12369
TEST_TIME 45 12421
TEST_TIME 46 12524
TEST_TIME 47 12556
TEST_TIME 48 12554
TEST_TIME 49 12573
TEST_TIME 50 12328

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 07-11-2026 23:51:19 to 07-11-2026 23:51:21.

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 912858 912858 0 0.00 0 1138 2 0 0
doc_list_biud 912858 912858 0 0.00 0 2104 6 0 0
sp_add_invoice_to_stock 6470 6470 0 0.00 8 13232 1649 0 0
sp_cancel_adding_invoice 4360 4360 0 0.00 4 4245 221 0 0
sp_cancel_client_order 2445 2445 0 0.00 3 898 49 0 0
sp_cancel_customer_reserve 211093 211093 0 0.00 1 1807 17 0 0
sp_cancel_pay_from_customer 954 954 0 0.00 2 292 20 0 0
sp_cancel_pay_to_supplier 580 580 0 0.00 2 145 18 0 0
sp_cancel_supplier_invoice 5403 5403 0 0.00 1 1488 151 0 0
sp_cancel_supplier_order 562 562 0 0.00 10 49398 8696 0 0
sp_cancel_write_off 7752 7752 0 0.00 1 1166 22 0 0
sp_client_order 30017 30017 0 0.00 4 1364 52 0 0
sp_customer_reserve 294600 294600 0 0.00 0 2673 31 0 0
sp_fill_shopping_cart 45568 45568 0 0.00 1 1848 22 0 0
sp_fill_shopping_cart_clo_res 294600 294600 0 0.00 0 1324 3 0 0
sp_get_clo_for_invoice 6470 6470 0 0.00 0 1189 36 0 0
sp_kill_cost_storno 13646 13646 0 0.00 0 435 9 0 0
sp_kill_qstorno_ret_qs2qd 435903 435903 0 0.00 0 1774 8 0 0
sp_kill_qty_storno 252098 252098 0 0.00 0 2104 19 0 0
sp_lock_selected_doc 28383 28383 0 0.00 0 361 2 0 0
sp_make_cost_storno 38797 38797 0 0.00 0 1109 7 0 0
sp_multiply_rows_for_pdistr 38797 38797 0 0.00 0 1126 10 0 0
sp_multiply_rows_for_qdistr 30017 30017 0 0.00 0 1085 21 0 0
sp_pay_from_customer 10016 10016 0 0.00 3 849 40 0 0
sp_pay_to_supplier 8298 8298 0 0.00 3 1144 34 0 0
sp_payment_common 18314 18314 0 0.00 1 548 12 0 0
sp_qd_handle_on_cancel_clo 2445 2445 0 0.00 0 895 32 0 0
sp_qd_handle_on_invoice_upd_sts 10830 10830 0 0.00 0 2103 74 0 0
sp_qd_handle_on_reserve_upd_sts 14013 14013 0 0.00 0 1672 12 0 0
sp_reserve_write_off 14013 14013 0 0.00 3 1683 39 0 0
sp_supplier_invoice 7719 7719 0 0.00 6 3697 365 0 0
sp_supplier_order 7832 7832 0 0.00 6 1881 223 0 0
srv_aggregate_perf_data 224 224 0 0.00 106 9495 1707 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1346 293 0 0
srv_find_qd_qs_mism 572554 572554 0 0.00 0 1102 2 0 0
srv_make_invnt_saldo 1666 1666 0 0.00 0 61065 558 0 0
srv_make_money_saldo 2416 2416 0 0.00 0 167 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 274 5705 2990 0 0
v_add_invoice_to_stock 12940 12940 0 0.00 0 995 3 0 0
v_all_customers 45446 45446 0 0.00 0 49 1 0 0
v_all_suppliers 37902 37902 0 0.00 0 51 1 0 0
v_all_wares 60034 60034 0 0.00 0 66 1 0 0
v_cancel_adding_invoice 1106 1106 0 0.00 0 755 3 0 0
v_cancel_client_order 4890 4890 0 0.00 0 284 1 0 0
v_cancel_customer_prepayment 1908 1908 0 0.00 0 258 2 0 0
v_cancel_customer_reserve 1848 1848 0 0.00 0 136 2 0 0
v_cancel_payment_to_supplier 1160 1160 0 0.00 0 127 2 0 0
v_cancel_supplier_invoice 1010 1010 0 0.00 0 284 3 0 0
v_cancel_supplier_order 1124 1124 0 0.00 0 130 2 0 0
v_cancel_write_off 2754 2754 0 0.00 0 406 2 0 0
v_max_id_clo_ord 7832 7832 0 0.00 0 75 1 0 0
v_max_id_clo_res 1342 1342 0 0.00 0 227 2 0 0
v_max_id_ord_sup 7719 7719 0 0.00 0 396 2 0 0
v_max_non_paid_invoice 4898 4898 0 0.00 0 94 2 0 0
v_max_non_paid_realizn 9727 9727 0 0.00 0 155 2 0 0
v_min_id_clo_ord 7832 7832 0 0.00 0 283 3 0 0
v_min_id_clo_res 1342 1342 0 0.00 0 414 5 0 0
v_min_id_ord_sup 7719 7719 0 0.00 0 1330 8 0 0
v_min_non_paid_invoice 8298 8298 0 0.00 0 547 4 0 0
v_min_non_paid_realizn 10016 10016 0 0.00 0 380 7 0 0
v_our_firm 15166 15166 0 0.00 0 43 1 0 0
v_reserve_write_off 28026 28026 0 0.00 0 434 2 0 0
x_lock_depdocs_on_canc_invoice 9258 9258 0 0.00 0 808 9 0 0
x_lock_depdocs_on_canc_sup_ord 562 562 0 0.00 0 206 10 0 0
x_make_qstorno_1000_1200 7832 7832 0 0.00 1 1852 163 0 0
x_make_qstorno_1200_2000 7719 7719 0 0.00 1 3652 315 0 0
x_make_qstorno_2100_3300 294600 294600 0 0.00 0 1952 27 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2026 23:51:22 to 07-11-2026 23:51:26.

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:08 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:08 185 2147483648 2602904464 2689818624 271518416 11.224 20 9 18 0 274266864 973184 1775264
23:03:09 269 2147483648 2599223296 2683346944 266277792 11.031 20 11 22 0 269129520 838000 2013728
23:04:09 155 2147483648 2558972624 2637905920 227476656 9.578 19 10 18 1 230151792 906320 1768816
23:05:10 168 2147483648 2604077904 2691489792 270657520 11.192 20 12 24 0 274109856 1004992 2447344
23:06:10 233 2147483648 2566066880 2646753280 234056064 9.827 19 7 14 0 237030000 1216832 1757104
23:07:11 144 2147483648 2599916704 2687848448 268872960 11.127 20 6 12 1 271143104 1063216 1206928
23:08:11 191 2147483648 2583939936 2667163648 249942208 10.425 20 14 26 1 253911136 1383856 2585072
23:09:12 235 2147483648 2599162848 2686554112 265841168 11.015 20 10 20 0 269259680 1369312 2049200
23:10:12 173 2147483648 2595829088 2683621376 262965056 10.909 20 9 18 0 266026464 1188064 1873344
23:11:13 250 2147483648 2595943088 2682941440 262484304 10.891 20 8 16 0 266353232 1657728 2211200
23:12:14 145 2147483648 2598762768 2688045056 265450656 11.001 20 8 15 0 268707264 1738816 1517792
23:13:14 203 2147483648 2584370224 2669162496 252198368 10.509 19 12 22 1 255715008 1318784 2197856
23:14:15 664 2147483648 2602776640 2689990656 267475968 11.075 20 13 23 1 271260400 1357072 2427360
23:15:16 158 2147483648 2591352800 2678161408 257625872 10.711 20 9 17 0 261070000 1683840 1760288
23:16:16 531 2147483648 2596859568 2685435904 263886816 10.943 20 7 14 0 266902720 1635024 1380880
23:17:17 243 2147483648 2591742176 2679070720 258749984 10.753 20 13 26 0 261823088 929424 2143680
23:18:17 160 2147483648 2588592224 2677112832 255379136 10.628 20 9 18 0 258834064 1340288 2114640
23:19:18 105 2147483648 2599341376 2686496768 263993360 10.947 20 12 24 0 269111520 2621392 2496768
23:20:18 147 2147483648 2606054176 2694246400 270581712 11.190 20 14 29 0 275348960 1625536 3141712
23:21:21 279 2147483648 2595103712 2683351040 260544576 10.819 20 9 19 0 263861152 1439888 1876688
23:22:21 178 2147483648 2597979632 2684723200 264535136 10.967 20 13 27 0 267973920 1325280 2113504
23:23:22 185 2147483648 2603896272 2692300800 268232320 11.103 20 11 22 0 272629872 2347936 2049616
23:24:22 210 2147483648 2594175920 2683072512 260504256 10.818 20 7 12 0 264135616 2101472 1529888
23:25:24 710 2147483648 2601721440 2690375680 266852944 11.052 20 11 22 0 270362224 1510256 1999024
23:26:25 157 2147483648 2592615776 2679599104 258975216 10.761 20 14 29 0 263158768 1211216 2972336
23:27:26 104 2147483648 2592340080 2679812096 257954016 10.723 20 9 18 0 261886864 2114992 1817856
23:28:26 181 2147483648 2606698688 2696339456 270380864 11.182 20 13 26 0 275843504 2716400 2746240
23:29:27 110 2147483648 2597803968 2686947328 265012048 10.984 20 11 23 0 268033328 917936 2103344
23:30:27 190 2147483648 2605122688 2693455872 269086528 11.135 20 12 24 0 274011504 2555136 2369840
23:31:28 175 2147483648 2605410512 2693816320 269462608 11.148 20 12 24 0 274004480 2181072 2360800
23:32:28 217 2147483648 2584615200 2668449792 248460032 10.370 19 14 28 1 252866080 1894144 2511904
23:33:28 312 2147483648 2603010128 2693693440 270777216 11.197 20 5 9 0 272555728 986080 792432
23:34:29 214 2147483648 2597943904 2688593920 263042976 10.912 20 11 22 0 267002320 2018880 1940464
23:35:29 211 2147483648 2594313728 2683662336 260906384 10.833 20 7 14 0 263639568 1518368 1214816
23:36:30 238 2147483648 2597936720 2685370368 258607600 10.748 20 10 20 0 266177472 5682336 1887536
23:37:30 303 2147483648 2599714016 2689855488 265932064 11.018 20 10 18 0 269745248 1687072 2126112
23:38:31 166 2147483648 2602269136 2694291456 267582528 11.079 20 10 21 0 271462752 1821504 2058720
23:39:32 740 2147483648 2595259744 2684542976 260748176 10.827 20 8 16 0 264521760 2187808 1585776
23:40:33 781 2147483648 2596768128 2684092416 261398272 10.851 20 13 26 0 265462928 1765248 2299408
23:41:34 108 2147483648 2602176496 2690949120 266960976 11.056 20 13 26 0 271406912 2189472 2256464
23:42:34 1346 2147483648 2599357968 2686726144 262693056 10.899 20 16 32 0 268056752 1947840 3415856
23:43:40 156 2147483648 2595014608 2682753024 260171600 10.806 20 13 26 0 264896448 1982752 2742096
23:44:41 257 2147483648 2598789712 2689933312 266208752 11.029 20 6 12 0 269233280 1913408 1111120
23:45:41 204 2147483648 2602145776 2691133440 267103808 11.062 20 10 20 1 271797952 2406592 2287552
23:46:42 1027 2147483648 2595003568 2686009344 261988528 10.873 20 8 16 0 265687248 2241040 1457680
23:47:43 277 2147483648 2591705968 2680696832 257787136 10.717 20 7 13 0 261298976 2314784 1197056
23:48:43 237 2147483648 2602015760 2690871296 266729504 11.048 20 9 17 1 270568720 2103184 1736032
23:49:44 188 2147483648 2598863648 2688192512 263461088 10.927 20 14 24 0 268384560 2236496 2686976
23:50:44 641 2147483648 2592979440 2682482688 259582656 10.784 20 7 14 0 262170960 1316432 1271872

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 07-11-2026 23:51:27 to 07-11-2026 23:51:41.

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 07-11-2026 23:51:41 to 07-11-2026 23:51:42.

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          202850
MON$OLDEST_ACTIVE               203876
MON$OLDEST_SNAPSHOT             203876
MON$NEXT_TRANSACTION            203876
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-07 23:00:11.1490
MON$PAGES                       125536
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'

07.11.26 23:51:43. 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-07 23:51:44 No severe PSQL-related problems occured
07.11.26 23:51:45. End of report.