Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 12.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 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 5d
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 1841504 kB
MemAvailable 7287528 kB
Buffers 81140 kB
Cached 5484200 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-12 23:51:01
DTS_END                         2026-11-12 23:51:01.6470
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/39706
TRN_ID                          212202
ATT_ID                          445
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: 14006.92 951 700346
customer order: creation 627.74 49 31387
customer order: refuse 50.80 48 2540
order to supplier: creation 159.48 214 7974
order to supplier: removal 11.72 9249 586
invoice (draft): creation 158.16 367 7908
invoice (draft): removal 112.96 149 5648
invoice accept: apply 136.06 1713 6803
invoice accept: cancel 94.16 225 4708
customer reserve: creation 6781.12 29 339056
customer reserve: removal 4907.76 16 245388
realization accept: apply 292.52 37 14626
realization accept: cancel 164.56 21 8228
payment from customer: creation 213.26 38 10663
payment from customer: removal 19.90 18 995
payment to supplier: creation 172.36 32 8618
payment to supplier: removal 11.84 19 592
service: total inventory turnovers 37.52 464 1876
service: total monetary turnovers 49.82 9 2491
service: aggregate perf. data 5.14 1651 257
service: refresh index statistics 0.04 4666 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 12-11-2026 23:51:21 to 12-11-2026 23:51:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 16754
TEST_TIME 2 14041
TEST_TIME 3 13582
TEST_TIME 4 13171
TEST_TIME 5 12896
TEST_TIME 6 13121
TEST_TIME 7 13258
TEST_TIME 8 13331
TEST_TIME 9 13169
TEST_TIME 10 13308
TEST_TIME 11 13329
TEST_TIME 12 13322
TEST_TIME 13 13379
TEST_TIME 14 13398
TEST_TIME 15 13450
TEST_TIME 16 13513
TEST_TIME 17 13476
TEST_TIME 18 13457
TEST_TIME 19 13540
TEST_TIME 20 13577
TEST_TIME 21 13551
TEST_TIME 22 13571
TEST_TIME 23 13632
TEST_TIME 24 13590
TEST_TIME 25 13618
TEST_TIME 26 13676
TEST_TIME 27 13654
TEST_TIME 28 13698
TEST_TIME 29 13759
TEST_TIME 30 13785
TEST_TIME 31 13744
TEST_TIME 32 13765
TEST_TIME 33 13786
TEST_TIME 34 13812
TEST_TIME 35 13826
TEST_TIME 36 13903
TEST_TIME 37 13984
TEST_TIME 38 13866
TEST_TIME 39 13919
TEST_TIME 40 13989
TEST_TIME 41 14004
TEST_TIME 42 14113
TEST_TIME 43 14129
TEST_TIME 44 14161
TEST_TIME 45 14157
TEST_TIME 46 14229
TEST_TIME 47 14211
TEST_TIME 48 14284
TEST_TIME 49 14282
TEST_TIME 50 14007

Performance per minute, chart


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

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 1033011 1033011 0 0.00 0 1132 2 0 0
doc_list_biud 1033011 1033011 0 0.00 0 1496 5 0 0
sp_add_invoice_to_stock 6803 6803 0 0.00 8 16765 1714 0 0
sp_cancel_adding_invoice 4708 4708 0 0.00 2 4785 226 0 0
sp_cancel_client_order 2540 2540 0 0.00 3 872 49 0 0
sp_cancel_customer_reserve 245388 245388 0 0.00 1 1490 16 0 0
sp_cancel_pay_from_customer 995 995 0 0.00 2 252 19 0 0
sp_cancel_pay_to_supplier 592 592 0 0.00 2 587 20 0 0
sp_cancel_supplier_invoice 5648 5648 0 0.00 1 1144 150 0 0
sp_cancel_supplier_order 586 586 0 0.00 6 54626 9249 0 0
sp_cancel_write_off 8228 8228 0 0.00 1 1054 22 0 0
sp_client_order 31387 31387 0 0.00 4 927 49 0 0
sp_customer_reserve 339056 339056 0 0.00 0 2012 30 0 0
sp_fill_shopping_cart 47269 47269 0 0.00 1 2631 21 0 0
sp_fill_shopping_cart_clo_res 339056 339056 0 0.00 0 1007 3 0 0
sp_get_clo_for_invoice 6803 6803 0 0.00 0 1877 37 0 0
sp_kill_cost_storno 14523 14523 0 0.00 0 444 10 0 0
sp_kill_qstorno_ret_qs2qd 505238 505238 0 0.00 0 1496 8 0 0
sp_kill_qty_storno 288527 288527 0 0.00 0 1496 18 0 0
sp_lock_selected_doc 29743 29743 0 0.00 0 199 2 0 0
sp_make_cost_storno 40710 40710 0 0.00 0 630 7 0 0
sp_multiply_rows_for_pdistr 40710 40710 0 0.00 0 463 10 0 0
sp_multiply_rows_for_qdistr 31387 31387 0 0.00 0 768 19 0 0
sp_pay_from_customer 10663 10663 0 0.00 3 869 39 0 0
sp_pay_to_supplier 8618 8618 0 0.00 3 906 32 0 0
sp_payment_common 19281 19281 0 0.00 1 522 11 0 0
sp_qd_handle_on_cancel_clo 2540 2540 0 0.00 0 855 32 0 0
sp_qd_handle_on_invoice_upd_sts 11511 11511 0 0.00 0 1299 74 0 0
sp_qd_handle_on_reserve_upd_sts 14626 14626 0 0.00 0 1480 10 0 0
sp_reserve_write_off 14626 14626 0 0.00 3 1543 37 0 0
sp_supplier_invoice 7908 7908 0 0.00 5 4221 367 0 0
sp_supplier_order 7974 7974 0 0.00 6 3227 215 0 0
srv_aggregate_perf_data 257 257 0 0.00 104 8766 1652 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 2916 369 0 0
srv_find_qd_qs_mism 650335 650335 0 0.00 0 1131 1 0 0
srv_make_invnt_saldo 1876 1876 0 0.00 0 136232 464 0 0
srv_make_money_saldo 2491 2491 0 0.00 0 1260 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 205 9127 4666 0 0
v_add_invoice_to_stock 13606 13606 0 0.00 0 275 3 0 0
v_all_customers 47984 47984 0 0.00 0 50 1 0 0
v_all_suppliers 39374 39374 0 0.00 0 47 1 0 0
v_all_wares 62774 62774 0 0.00 0 61 1 0 0
v_cancel_adding_invoice 1212 1212 0 0.00 0 64 2 0 0
v_cancel_client_order 5080 5080 0 0.00 0 219 1 0 0
v_cancel_customer_prepayment 1990 1990 0 0.00 0 246 1 0 0
v_cancel_customer_reserve 1896 1896 0 0.00 0 76 2 0 0
v_cancel_payment_to_supplier 1184 1184 0 0.00 0 579 2 0 0
v_cancel_supplier_invoice 1146 1146 0 0.00 0 129 3 0 0
v_cancel_supplier_order 1172 1172 0 0.00 0 108 2 0 0
v_cancel_write_off 2948 2948 0 0.00 0 189 2 0 0
v_max_id_clo_ord 7974 7974 0 0.00 0 130 1 0 0
v_max_id_clo_res 1429 1429 0 0.00 0 95 1 0 0
v_max_id_ord_sup 7908 7908 0 0.00 0 751 2 0 0
v_max_non_paid_invoice 4813 4813 0 0.00 0 203 2 0 0
v_max_non_paid_realizn 10317 10317 0 0.00 0 313 2 0 0
v_min_id_clo_ord 7974 7974 0 0.00 0 465 3 0 0
v_min_id_clo_res 1429 1429 0 0.00 0 332 4 0 0
v_min_id_ord_sup 7908 7908 0 0.00 0 680 5 0 0
v_min_non_paid_invoice 8618 8618 0 0.00 0 391 4 0 0
v_min_non_paid_realizn 10663 10663 0 0.00 0 512 6 0 0
v_our_firm 15482 15482 0 0.00 0 36 1 0 0
v_reserve_write_off 29252 29252 0 0.00 0 511 2 0 0
x_lock_depdocs_on_canc_invoice 9783 9783 0 0.00 0 813 9 0 0
x_lock_depdocs_on_canc_sup_ord 586 586 0 0.00 0 215 12 0 0
x_make_qstorno_1000_1200 7974 7974 0 0.00 1 3179 158 0 0
x_make_qstorno_1200_2000 7908 7908 0 0.00 1 4008 322 0 0
x_make_qstorno_2100_3300 339056 339056 0 0.00 0 2012 25 0 0

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

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:05 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:06 179 2147483648 2605886672 2692972544 274393408 11.329 20 8 18 0 276883536 1010160 1479968
23:03:06 533 2147483648 2602200384 2688512000 270040768 11.170 20 12 25 2 273651984 797856 2813360
23:04:07 145 2147483648 2599606528 2683908096 264523680 10.966 20 16 32 0 268720304 1617008 2579616
23:05:08 266 2147483648 2583723024 2669498368 253265056 10.549 20 7 14 0 256178176 1053296 1859824
23:06:08 374 2147483648 2604425552 2692325376 270973392 11.204 20 8 16 0 274201552 1379664 1848496
23:07:09 236 2147483648 2581366112 2663735296 247896496 10.348 20 14 27 0 252408864 1938688 2573680
23:08:10 404 2147483648 2604655232 2692849664 271184848 11.212 20 11 22 0 274636592 969488 2482256
23:09:10 188 2147483648 2579024128 2660519936 243508960 10.184 20 16 31 0 248863712 2605760 2748992
23:10:11 646 2147483648 2596614768 2684452864 264053296 10.949 20 9 18 0 267159168 1353504 1752368
23:11:12 218 2147483648 2598604048 2685710336 264341616 10.960 20 11 22 1 268916848 2353296 2221936
23:12:12 163 2147483648 2601946944 2688094208 266677344 11.046 20 16 31 0 270636256 1134528 2824384
23:13:13 158 2147483648 2594810736 2682159104 261595552 10.858 20 10 21 0 265052592 1622992 1834048
23:14:13 500 2147483648 2594787936 2679681024 260568416 10.820 20 12 22 1 264222544 1431312 2222816
23:15:14 260 2147483648 2599080400 2688708608 267174688 11.064 20 5 10 0 269128688 1032256 921744
23:16:14 131 2147483648 2603853776 2691747840 269083408 11.134 20 14 27 0 273566224 1904976 2577840
23:17:14 179 2147483648 2603237584 2690392064 267539216 11.078 20 14 28 0 272451792 1816032 3096544
23:18:15 92 2147483648 2609845376 2697908224 270594160 11.190 20 12 24 0 279868112 6665520 2608432
23:19:15 98 2147483648 2596444864 2684596224 261858896 10.868 20 10 20 0 266115312 1732912 2523504
23:20:16 171 2147483648 2597996784 2685149184 261411936 10.851 20 13 26 0 266768624 2797936 2558752
23:21:16 207 2147483648 2604955904 2695073792 271040976 11.206 20 5 10 0 274029696 2090464 898256
23:22:16 126 2147483648 2602291792 2689818624 265647728 11.008 20 16 32 0 270699488 1851712 3200048
23:23:17 147 2147483648 2596803440 2684272640 261597760 10.858 20 13 24 0 266506832 2509552 2399520
23:24:17 2914 2147483648 2601618608 2692775936 268904720 11.128 20 8 16 0 271701248 1229456 1567072
23:25:20 172 2147483648 2603230512 2693373952 268362384 11.108 20 13 26 1 272999552 2070832 2566336
23:26:21 171 2147483648 2594608976 2681589760 259061504 10.764 20 14 28 1 264112096 2053584 2997008
23:27:22 734 2147483648 2602224992 2690617344 267454624 11.075 20 8 16 0 271168880 1990288 1723968
23:28:23 229 2147483648 2606490208 2694307840 269326416 11.143 20 14 28 0 275350752 2653920 3370416
23:29:24 254 2147483648 2578710032 2662088704 243097312 10.168 20 15 31 0 247754864 1719376 2938176
23:30:25 140 2147483648 2599228896 2688843776 266201120 11.028 20 6 10 0 269233120 2087648 944352
23:31:25 466 2147483648 2610736816 2699403264 273696752 11.304 20 9 18 1 279344160 3662768 1984640
23:32:26 1365 2147483648 2597329424 2688438272 265217168 10.992 20 11 22 0 269115680 1442816 2455696
23:33:27 203 2147483648 2596615152 2687021056 264062912 10.949 20 8 16 0 266852592 1298784 1490896
23:34:28 308 2147483648 2603590848 2691874816 268031472 11.096 20 11 22 0 271846640 1603056 2212112
23:35:29 101 2147483648 2602595200 2691936256 267353552 11.071 20 11 22 0 272031120 2488672 2188896
23:36:29 307 2147483648 2591942320 2678964224 255802640 10.643 20 13 26 0 259509328 1305440 2401248
23:37:30 147 2147483648 2600558192 2688929792 263734416 10.937 20 14 28 0 268994560 2691280 2568864
23:38:30 343 2147483648 2597521392 2684534784 260921824 10.833 20 14 26 0 266736800 3022144 2792832
23:39:31 1779 2147483648 2597742816 2687651840 264382976 10.961 20 8 17 0 266890128 1066736 1440416
23:40:33 177 2147483648 2604202112 2693312512 267241024 11.067 20 12 23 0 273390992 3484064 2665904
23:41:33 227 2147483648 2593680272 2679975936 256335168 10.663 20 18 36 1 263801696 3475104 3991424
23:42:34 400 2147483648 2598692880 2688380928 263799040 10.940 20 12 24 0 267936864 1821344 2316480
23:43:34 751 2147483648 2583384528 2670157824 249429936 10.406 19 12 21 0 253284800 1429248 2425616
23:44:35 235 2147483648 2599453440 2688868352 263489216 10.928 20 13 26 0 267912720 2208240 2215264
23:45:37 179 2147483648 2588875344 2677592064 254527536 10.596 20 13 26 0 259157552 1867040 2762976
23:46:38 208 2147483648 2600905600 2688512000 264205264 10.955 20 14 28 0 269512576 2511136 2796176
23:47:38 239 2147483648 2599488416 2690224128 264971376 10.983 20 11 23 1 269686400 1792048 2922976
23:48:38 236 2147483648 2595481888 2681933824 259619936 10.785 20 15 30 0 264314608 1905200 2789472
23:49:39 268 2147483648 2602126672 2690048000 266192112 11.028 20 14 29 0 270449648 1751248 2506288
23:50:40 187 2147483648 2602231312 2691276800 266619216 11.044 20 15 31 0 271550160 2159856 2771088

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 12-11-2026 23:51:31 to 12-11-2026 23:51:44.

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 12-11-2026 23:51:44 to 12-11-2026 23:51:45.

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          211400
MON$OLDEST_ACTIVE               213424
MON$OLDEST_SNAPSHOT             213424
MON$NEXT_TRANSACTION            213424
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-12 23:00:09.5430
MON$PAGES                       132416
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    Thu Nov 12 23:51:03 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'

12.11.26 23:51:46. 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-12 23:51:47 No severe PSQL-related problems occured
12.11.26 23:51:48. End of report.