Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.11.2026 10:50
Common Performance Final Results
  1. Hardware and OS info
  2. Firebird configuration
  3. Test configuration
  4. Test Finish details
  5. Test workload details
  6. 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 1908120 kB
MemAvailable 7266604 kB
Buffers 90588 kB
Cached 5355032 kB
SwapCached 16 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

PARAM_NAME PARAM_VALUE PARAM_DEFAULT is set ? PARAM_SOURCE
AllowEncryptedSecurityDatabase false false
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
BlobTempSpace 0 0
BugcheckAbort true false [ X ] firebird.conf
ClearGTTAtRetaining false false
ClientBatchBuffer 131072 131072
ConnectionIdleTimeout 0 0
ConnectionTimeout 180 180
CpuAffinityMask 0 0
DSQLCacheSize 0 0
DataTypeCompatibility
DatabaseAccess Full Full
DatabaseGrowthIncrement 134217728 134217728
DeadlockTimeout 10 10
DefaultDbCachePages 262144 2048 [ X ] firebird.conf
DefaultTimeZone
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
ForceLockTimeoutForWaitTransactions -1 -1
GCPolicy combined combined
GuardianOption 1 1
HQbirdVersionString true true
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_hq40SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LeftJoinConversion false false
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxCountAttachments 0 0
MaxDbCachePages 2048 2048
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxParallelWorkers 1 1
MaxTempBlobs 1000 1000
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
MinDbCachePages 30000 30000
MonitoringPlugin [empty] [empty]
OnDisconnectTriggerTimeout 180 180
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
ProcessPriorityLevel 0 0
Providers Remote, Engine13, Loopback Remote, Engine13, Loopback
ReadConsistency true true
Redirection false false
RelaxedAliasChecking false false
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemotePipeName interbas interbas
RemoteServiceName gds_db gds_db
RemoteServicePort 30400 0 [ X ] firebird.conf
SecurityDatabase /opt/hq40/security4.fdb /opt/hq40/security4.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
SqlSubstDirectory subst subst
StatementTimeout 0 0
TcpLoopbackFastPath false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
TempSpaceLogThreshold 0 0
TempTableDirectory [empty] [empty]
TipCacheBlockSize 4194304 4194304
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
UseLegacyKernelObjectsNames false false
UserManager Srp Srp
WarnCountAttachments 0 0
WireCompression false false
WireCrypt Required
WireCryptPlugin ChaCha64, ChaCha, Arc4 ChaCha64, ChaCha, Arc4

Server and database settinfs


SERVER_MODE                     SuperServer
DB_NAME                         /var/db/oltp-emul/oltp-hq40.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-hq40.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_40.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq40/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=green
param=html_chart_color_memo_att, val=green
param=html_chart_color_memo_stm, val=green
param=html_chart_color_memo_trn, val=green
param=html_chart_color_perf_score, val=green
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=30400
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-hq40-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-hq40
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 10:50:52
DTS_END                         2026-11-07 10:50:52.1240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(37:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/47706
TRN_ID                          217795
ATT_ID                          441
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: 14007.60 922 700380
customer order: creation 642.44 49 32122
customer order: refuse 52.06 43 2603
order to supplier: creation 163.12 210 8156
order to supplier: removal 11.92 8188 596
invoice (draft): creation 164.66 355 8233
invoice (draft): removal 116.38 136 5819
invoice accept: apply 141.22 1421 7061
invoice accept: cancel 96.26 195 4813
customer reserve: creation 6754.18 25 337709
customer reserve: removal 4895.90 14 244795
realization accept: apply 302.28 38 15114
realization accept: cancel 168.54 20 8427
payment from customer: creation 210.22 33 10511
payment from customer: removal 20.22 18 1011
payment to supplier: creation 175.18 30 8759
payment to supplier: removal 12.44 18 622
service: total inventory turnovers 22.54 1494 1127
service: total monetary turnovers 53.48 12 2674
service: aggregate perf. data 4.52 1856 226
service: refresh index statistics 0.04 4285 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7712
TEST_TIME 2 9220
TEST_TIME 3 9966
TEST_TIME 4 10384
TEST_TIME 5 10664
TEST_TIME 6 10841
TEST_TIME 7 11099
TEST_TIME 8 11312
TEST_TIME 9 11510
TEST_TIME 10 11608
TEST_TIME 11 11770
TEST_TIME 12 11783
TEST_TIME 13 11919
TEST_TIME 14 11965
TEST_TIME 15 12129
TEST_TIME 16 12185
TEST_TIME 17 12201
TEST_TIME 18 12454
TEST_TIME 19 12453
TEST_TIME 20 12470
TEST_TIME 21 12573
TEST_TIME 22 12585
TEST_TIME 23 12577
TEST_TIME 24 12658
TEST_TIME 25 12744
TEST_TIME 26 12777
TEST_TIME 27 12825
TEST_TIME 28 12887
TEST_TIME 29 12860
TEST_TIME 30 13043
TEST_TIME 31 13045
TEST_TIME 32 13158
TEST_TIME 33 13301
TEST_TIME 34 13339
TEST_TIME 35 13368
TEST_TIME 36 13425
TEST_TIME 37 13526
TEST_TIME 38 13581
TEST_TIME 39 13647
TEST_TIME 40 13718
TEST_TIME 41 13706
TEST_TIME 42 13738
TEST_TIME 43 13777
TEST_TIME 44 13853
TEST_TIME 45 13874
TEST_TIME 46 13981
TEST_TIME 47 13981
TEST_TIME 48 13989
TEST_TIME 49 14047
TEST_TIME 50 14008

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 07-11-2026 10:51:08 to 07-11-2026 10:51:10.

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 1034843 1034843 0 0.00 0 1454 2 0 0
doc_list_biud 1034843 1034843 0 0.00 0 1871 5 0 0
sp_add_invoice_to_stock 7061 7061 0 0.00 5 12254 1422 0 0
sp_cancel_adding_invoice 4813 4813 0 0.00 3 5417 195 0 0
sp_cancel_client_order 2603 2603 0 0.00 2 2695 44 0 0
sp_cancel_customer_reserve 244795 244795 0 0.00 1 1650 14 0 0
sp_cancel_pay_from_customer 1011 1011 0 0.00 2 478 19 0 0
sp_cancel_pay_to_supplier 622 622 0 0.00 2 541 19 0 0
sp_cancel_supplier_invoice 5819 5819 0 0.00 2 1862 137 0 0
sp_cancel_supplier_order 596 596 0 0.00 3 51962 8188 0 0
sp_cancel_write_off 8427 8427 0 0.00 1 2638 21 0 0
sp_client_order 32122 32122 0 0.00 4 3030 49 0 0
sp_customer_reserve 337709 337709 0 0.00 0 2898 25 0 0
sp_fill_shopping_cart 48511 48511 0 0.00 1 3037 20 0 0
sp_fill_shopping_cart_clo_res 337709 337709 0 0.00 0 1485 2 0 0
sp_get_clo_for_invoice 7061 7061 0 0.00 0 1341 33 0 0
sp_kill_cost_storno 14873 14873 0 0.00 0 736 10 0 0
sp_kill_qstorno_ret_qs2qd 504432 504432 0 0.00 0 1870 7 0 0
sp_kill_qty_storno 289228 289228 0 0.00 0 1870 17 0 0
sp_lock_selected_doc 30742 30742 0 0.00 0 265 1 0 0
sp_make_cost_storno 41445 41445 0 0.00 0 937 7 0 0
sp_multiply_rows_for_pdistr 41445 41445 0 0.00 0 669 11 0 0
sp_multiply_rows_for_qdistr 32122 32122 0 0.00 0 3022 19 0 0
sp_pay_from_customer 10511 10511 0 0.00 3 1078 34 0 0
sp_pay_to_supplier 8759 8759 0 0.00 3 1143 30 0 0
sp_payment_common 19270 19270 0 0.00 1 556 6 0 0
sp_qd_handle_on_cancel_clo 2603 2603 0 0.00 0 1129 28 0 0
sp_qd_handle_on_invoice_upd_sts 11874 11874 0 0.00 0 1677 65 0 0
sp_qd_handle_on_reserve_upd_sts 15114 15114 0 0.00 0 1628 11 0 0
sp_reserve_write_off 15114 15114 0 0.00 3 2699 38 0 0
sp_supplier_invoice 8233 8233 0 0.00 6 6044 355 0 0
sp_supplier_order 8156 8156 0 0.00 5 2665 210 0 0
srv_aggregate_perf_data 226 226 0 0.00 32 25949 1857 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 934 258 0 0
srv_find_qd_qs_mism 651584 651584 0 0.00 0 1454 1 0 0
srv_make_invnt_saldo 1127 1127 0 0.00 1 5288 1495 0 0
srv_make_money_saldo 2674 2674 0 0.00 0 316 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 175 8396 4286 0 0
v_add_invoice_to_stock 14122 14122 0 0.00 0 971 2 0 0
v_all_customers 48996 48996 0 0.00 0 37 1 0 0
v_all_suppliers 39916 39916 0 0.00 0 49 1 0 0
v_all_wares 64244 64244 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 1158 1158 0 0.00 0 406 2 0 0
v_cancel_client_order 5206 5206 0 0.00 0 2642 2 0 0
v_cancel_customer_prepayment 2022 2022 0 0.00 0 440 2 0 0
v_cancel_customer_reserve 1972 1972 0 0.00 0 421 2 0 0
v_cancel_payment_to_supplier 1244 1244 0 0.00 0 50 1 0 0
v_cancel_supplier_invoice 1226 1226 0 0.00 0 48 2 0 0
v_cancel_supplier_order 1192 1192 0 0.00 0 198 2 0 0
v_cancel_write_off 3114 3114 0 0.00 0 2627 3 0 0
v_max_id_clo_ord 8156 8156 0 0.00 0 29 1 0 0
v_max_id_clo_res 1565 1565 0 0.00 0 298 1 0 0
v_max_id_ord_sup 8233 8233 0 0.00 0 953 2 0 0
v_max_non_paid_invoice 5190 5190 0 0.00 0 29 1 0 0
v_max_non_paid_realizn 10171 10171 0 0.00 0 554 1 0 0
v_min_id_clo_ord 8156 8156 0 0.00 0 827 3 0 0
v_min_id_clo_res 1565 1565 0 0.00 0 526 3 0 0
v_min_id_ord_sup 8233 8233 0 0.00 0 1909 6 0 0
v_min_non_paid_invoice 8759 8759 0 0.00 0 293 2 0 0
v_min_non_paid_realizn 10511 10511 0 0.00 0 489 2 0 0
v_our_firm 15928 15928 0 0.00 0 30 1 0 0
v_reserve_write_off 30228 30228 0 0.00 0 2688 2 0 0
x_lock_depdocs_on_canc_invoice 10019 10019 0 0.00 0 959 9 0 0
x_lock_depdocs_on_canc_sup_ord 596 596 0 0.00 0 143 10 0 0
x_make_qstorno_1000_1200 8156 8156 0 0.00 1 2609 154 0 0
x_make_qstorno_1200_2000 8233 8233 0 0.00 1 5842 309 0 0
x_make_qstorno_2100_3300 337709 337709 0 0.00 0 2766 22 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 07-11-2026 10:51:11 to 07-11-2026 10:51:14.

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
10:00:56 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
10:01:56 388 2147483648 2546944624 2628567040 220538352 9.313 20 8 15 0 222902496 1199280 1164864
10:02:57 256 2147483648 2549389360 2630942720 221401568 9.346 20 7 14 0 224585712 1803776 1380368
10:03:57 227 2147483648 2544728704 2623217664 211168304 8.952 20 13 25 0 219438256 6017040 2252912
10:04:58 288 2147483648 2548734832 2628722688 217930704 9.213 20 8 14 0 220460592 1315552 1214336
10:05:59 261 2147483648 2548981168 2630107136 219574112 9.276 20 11 22 0 223053360 1601232 1878016
10:06:59 167 2147483648 2535144032 2616434688 203915808 8.672 20 6 12 0 210550992 5683904 951280
10:08:00 270 2147483648 2554377792 2639179776 218968224 9.253 20 12 24 0 229985920 8877712 2139984
10:09:00 202 2147483648 2538696160 2619981824 206464512 8.770 20 8 16 0 213905696 6239696 1201488
10:10:01 271 2147483648 2549658800 2631270400 215422624 9.116 20 9 16 0 224063616 7118256 1522736
10:11:02 222 2147483648 2546668256 2627608576 211252336 8.956 20 9 18 0 219965872 7290528 1423008
10:12:02 221 2147483648 2546108800 2626564096 212701552 9.012 20 12 23 0 220368640 4903360 2763728
10:13:03 367 2147483648 2540298240 2618363904 203513280 8.656 19 13 26 0 215295712 8916528 2865904
10:14:03 247 2147483648 2553340560 2635288576 214280064 9.072 20 9 18 0 226784160 10831456 1672640
10:15:04 371 2147483648 2554354992 2639327232 213874672 9.057 20 9 18 1 229647344 14309776 1462896
10:16:04 238 2147483648 2554688608 2637516800 219612640 9.277 20 12 24 0 227831040 6266640 1951760
10:17:05 138 2147483648 2560843456 2641711104 218271120 9.226 20 15 30 0 233078240 11998032 2809088
10:18:06 162 2147483648 2572411792 2653962240 217075808 9.180 20 14 28 0 245816016 26336832 2403376
10:19:06 140 2147483648 2555560880 2638372864 218315696 9.227 20 11 20 0 227668704 7805584 1547424
10:20:07 292 2147483648 2548068736 2629275648 210257712 8.917 20 10 19 0 222084400 10413376 1413312
10:21:08 107 2147483648 2558325568 2640379904 215840320 9.132 20 9 18 0 232474064 14876320 1757424
10:22:08 321 2147483648 2544422304 2624163840 204880624 8.709 20 11 21 0 215931264 9539664 1510976
10:23:09 157 2147483648 2542617584 2625380352 211362176 8.960 20 10 20 0 216463712 3399024 1702512
10:24:09 289 2147483648 2567354896 2652086272 220023040 9.293 20 12 24 0 240639296 18305024 2311232
10:25:10 142 2147483648 2548802288 2629398528 207922416 8.827 20 10 20 0 222078384 12189136 1966832
10:26:10 104 2147483648 2551543392 2636324864 215780096 9.130 20 6 12 0 225382912 8359744 1243072
10:27:10 224 2147483648 2562644544 2646237184 219175920 9.260 20 11 22 0 235381120 13941264 2263936
10:28:11 759 2147483648 2557207504 2639462400 217392784 9.192 20 11 21 0 230049312 10990368 1666160
10:29:12 127 2147483648 2546097616 2627399680 211835824 8.978 20 13 27 0 219066240 4671968 2558448
10:30:12 366 2147483648 2576629344 2661687296 224432352 9.462 20 11 22 0 250054384 23872832 1749200
10:31:13 139 2147483648 2547435536 2629447680 211843184 8.978 20 14 29 0 222136208 7872464 2420560
10:32:13 130 2147483648 2555199584 2637201408 209585072 8.891 20 14 27 0 227231888 15278272 2368544
10:33:13 174 2147483648 2567677312 2651111424 216807632 9.170 20 13 26 0 239778064 20852928 2117504
10:34:14 241 2147483648 2566249040 2648612864 216843504 9.171 20 14 28 1 238268800 19064464 2360832
10:35:15 200 2147483648 2558611664 2647674880 207026176 8.792 20 9 16 0 231772976 23105392 1641408
10:36:15 185 2147483648 2566426032 2649124864 216644192 9.163 20 13 25 0 239374160 20376752 2353216
10:37:16 127 2147483648 2562229776 2644123648 217753696 9.206 20 15 30 1 235260784 14910064 2597024
10:38:16 364 2147483648 2548671696 2632568832 214712640 9.089 20 12 23 0 223097488 6385152 1999696
10:39:16 140 2147483648 2555852448 2638348288 214467040 9.080 20 13 25 0 228248608 11806848 1974720
10:40:17 318 2147483648 2549958544 2633580544 217129936 9.182 20 13 26 1 225410912 5761776 2519200
10:41:17 794 2147483648 2560203216 2643382272 216540096 9.159 20 15 26 0 231523744 12505904 2477744
10:42:19 181 2147483648 2542074064 2626240512 209583024 8.891 20 6 12 0 215307888 4602192 1122672
10:43:19 243 2147483648 2559445200 2659565568 215100960 9.104 20 11 22 0 231950976 14945168 1904848
10:44:20 159 2147483648 2552276048 2634711040 216610448 9.162 20 12 25 0 224096048 5632480 1853120
10:45:21 225 2147483648 2549307520 2630881280 205115312 8.718 19 13 26 0 222882000 15574720 2191968
10:46:21 141 2147483648 2567130400 2650177536 215933808 9.136 20 14 27 0 239734656 21290896 2509952
10:47:21 108 2147483648 2556683792 2647408640 215345664 9.113 20 11 21 0 228969872 11974496 1649712
10:48:22 934 2147483648 2545778048 2630328320 215595776 9.123 20 9 16 1 223599552 5284928 2718848
10:49:23 542 2147483648 2552654336 2635382784 210936720 8.943 20 9 19 0 227503200 14957968 1608512
10:50:24 85 2147483648 2558074992 2642341888 218081984 9.219 20 12 24 0 231672272 11147328 2442960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 07-11-2026 10:51:15 to 07-11-2026 10:51:28.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 07-11-2026 10:51:28 to 07-11-2026 10:51:29.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq40.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          217942
MON$OLDEST_ACTIVE               217943
MON$OLDEST_SNAPSHOT             217943
MON$NEXT_TRANSACTION            217943
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 07:00:10.7220 GMT
MON$PAGES                       151912
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {04752F63-9096-4386-A4B4-E1BBE7009A3D}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             563
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3331 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3331 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3331 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
on disk structure version 13.0

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:6: 
:7: test-0    Sat Nov  7 10:50:53 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
--- end of diff output ---

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

07.11.26 10:51:30. There are 3 logs in /var/tmp/logs.oltp-hq40 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 10:51:31 No severe PSQL-related problems occured
07.11.26 10:51:31. End of report.