Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 11.11.2026 04: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 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 2195584 kB
MemAvailable 7388260 kB
Buffers 79840 kB
Cached 5236852 kB
SwapCached 12 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-11 04:50:46
DTS_END                         2026-11-11 04:50:46.8590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/39410
TRN_ID                          237041
ATT_ID                          470
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: 16030.56 981 801528
customer order: creation 697.16 44 34858
customer order: refuse 56.84 42 2842
order to supplier: creation 181.56 200 9078
order to supplier: removal 12.84 8419 642
invoice (draft): creation 177.78 354 8889
invoice (draft): removal 124.46 137 6223
invoice accept: apply 152.94 1378 7647
invoice accept: cancel 104.36 198 5218
customer reserve: creation 7785.36 22 389268
customer reserve: removal 5674.16 13 283708
realization accept: apply 327.42 35 16371
realization accept: cancel 187.48 19 9374
payment from customer: creation 233.30 38 11665
payment from customer: removal 21.12 17 1056
payment to supplier: creation 192.46 30 9623
payment to supplier: removal 13.00 16 650
service: total inventory turnovers 25.60 1285 1280
service: total monetary turnovers 57.38 14 2869
service: aggregate perf. data 5.28 1734 264
service: refresh index statistics 0.06 5630 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2026 04:51:01 to 11-11-2026 04:51:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10823
TEST_TIME 2 11917
TEST_TIME 3 12745
TEST_TIME 4 13170
TEST_TIME 5 13362
TEST_TIME 6 13701
TEST_TIME 7 13729
TEST_TIME 8 14057
TEST_TIME 9 14205
TEST_TIME 10 14273
TEST_TIME 11 14515
TEST_TIME 12 14600
TEST_TIME 13 14639
TEST_TIME 14 14635
TEST_TIME 15 14753
TEST_TIME 16 14694
TEST_TIME 17 14657
TEST_TIME 18 14709
TEST_TIME 19 14702
TEST_TIME 20 14859
TEST_TIME 21 14892
TEST_TIME 22 14945
TEST_TIME 23 14942
TEST_TIME 24 15049
TEST_TIME 25 15050
TEST_TIME 26 15022
TEST_TIME 27 15155
TEST_TIME 28 15168
TEST_TIME 29 15189
TEST_TIME 30 15209
TEST_TIME 31 15226
TEST_TIME 32 15212
TEST_TIME 33 15298
TEST_TIME 34 15327
TEST_TIME 35 15473
TEST_TIME 36 15544
TEST_TIME 37 15601
TEST_TIME 38 15611
TEST_TIME 39 15675
TEST_TIME 40 15780
TEST_TIME 41 15827
TEST_TIME 42 15861
TEST_TIME 43 15859
TEST_TIME 44 15890
TEST_TIME 45 15914
TEST_TIME 46 15967
TEST_TIME 47 15979
TEST_TIME 48 16000
TEST_TIME 49 16106
TEST_TIME 50 16031

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 11-11-2026 04:51:04 to 11-11-2026 04:51:06.

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 1182963 1182963 0 0.00 0 786 2 0 0
doc_list_biud 1182963 1182963 0 0.00 0 3019 5 0 0
sp_add_invoice_to_stock 7647 7647 0 0.00 7 13931 1378 0 0
sp_cancel_adding_invoice 5218 5218 0 0.00 3 4299 199 0 0
sp_cancel_client_order 2842 2842 0 0.00 3 790 43 0 0
sp_cancel_customer_reserve 283708 283708 0 0.00 1 1334 14 0 0
sp_cancel_pay_from_customer 1056 1056 0 0.00 2 274 18 0 0
sp_cancel_pay_to_supplier 650 650 0 0.00 2 310 17 0 0
sp_cancel_supplier_invoice 6223 6223 0 0.00 1 3023 138 0 0
sp_cancel_supplier_order 642 642 0 0.00 3 45719 8420 0 0
sp_cancel_write_off 9374 9374 0 0.00 1 1131 19 0 0
sp_client_order 34858 34858 0 0.00 3 1331 44 0 0
sp_customer_reserve 389268 389268 0 0.00 0 2416 23 0 0
sp_fill_shopping_cart 52825 52825 0 0.00 1 2658 20 0 0
sp_fill_shopping_cart_clo_res 389268 389268 0 0.00 0 1700 2 0 0
sp_get_clo_for_invoice 7647 7647 0 0.00 0 2027 35 0 0
sp_kill_cost_storno 16298 16298 0 0.00 0 745 9 0 0
sp_kill_qstorno_ret_qs2qd 583655 583655 0 0.00 0 3017 7 0 0
sp_kill_qty_storno 332025 332025 0 0.00 0 3018 16 0 0
sp_lock_selected_doc 33174 33174 0 0.00 0 433 2 0 0
sp_make_cost_storno 45306 45306 0 0.00 0 698 7 0 0
sp_multiply_rows_for_pdistr 45306 45306 0 0.00 0 667 11 0 0
sp_multiply_rows_for_qdistr 34858 34858 0 0.00 0 1296 17 0 0
sp_pay_from_customer 11665 11665 0 0.00 3 971 39 0 0
sp_pay_to_supplier 9623 9623 0 0.00 3 814 31 0 0
sp_payment_common 21288 21288 0 0.00 1 651 10 0 0
sp_qd_handle_on_cancel_clo 2842 2842 0 0.00 0 779 29 0 0
sp_qd_handle_on_invoice_upd_sts 12865 12865 0 0.00 0 2125 68 0 0
sp_qd_handle_on_reserve_upd_sts 16371 16371 0 0.00 0 1475 10 0 0
sp_reserve_write_off 16371 16371 0 0.00 3 1480 36 0 0
sp_supplier_invoice 8889 8889 0 0.00 5 4931 355 0 0
sp_supplier_order 9078 9078 0 0.00 5 2454 200 0 0
srv_aggregate_perf_data 264 264 0 0.00 7 9498 1735 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1663 234 0 0
srv_find_qd_qs_mism 745997 745997 0 0.00 0 785 1 0 0
srv_make_invnt_saldo 1280 1280 0 0.00 1 4429 1285 0 0
srv_make_money_saldo 2869 2869 0 0.00 0 233 14 0 0
srv_recalc_idx_stat 3 3 0 0.00 312 11267 5631 0 0
v_add_invoice_to_stock 15294 15294 0 0.00 0 708 2 0 0
v_all_customers 53260 53260 0 0.00 0 43 1 0 0
v_all_suppliers 44642 44642 0 0.00 0 29 1 0 0
v_all_wares 69716 69716 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 1318 1318 0 0.00 0 20 1 0 0
v_cancel_client_order 5684 5684 0 0.00 0 389 1 0 0
v_cancel_customer_prepayment 2112 2112 0 0.00 0 234 1 0 0
v_cancel_customer_reserve 2152 2152 0 0.00 0 281 2 0 0
v_cancel_payment_to_supplier 1300 1300 0 0.00 0 264 1 0 0
v_cancel_supplier_invoice 1190 1190 0 0.00 0 60 2 0 0
v_cancel_supplier_order 1284 1284 0 0.00 0 612 2 0 0
v_cancel_write_off 3272 3272 0 0.00 0 126 1 0 0
v_max_id_clo_ord 9078 9078 0 0.00 0 29 1 0 0
v_max_id_clo_res 1630 1630 0 0.00 0 461 2 0 0
v_max_id_ord_sup 8889 8889 0 0.00 0 933 2 0 0
v_max_non_paid_invoice 5269 5269 0 0.00 0 30 2 0 0
v_max_non_paid_realizn 11197 11197 0 0.00 0 155 2 0 0
v_min_id_clo_ord 9078 9078 0 0.00 0 272 2 0 0
v_min_id_clo_res 1630 1630 0 0.00 0 734 2 0 0
v_min_id_ord_sup 8889 8889 0 0.00 0 823 5 0 0
v_min_non_paid_invoice 9623 9623 0 0.00 0 610 4 0 0
v_min_non_paid_realizn 11665 11665 0 0.00 0 596 6 0 0
v_our_firm 17392 17392 0 0.00 0 34 1 0 0
v_reserve_write_off 32742 32742 0 0.00 0 623 1 0 0
x_lock_depdocs_on_canc_invoice 10846 10846 0 0.00 0 2280 10 0 0
x_lock_depdocs_on_canc_sup_ord 642 642 0 0.00 0 197 11 0 0
x_make_qstorno_1000_1200 9078 9078 0 0.00 1 2393 144 0 0
x_make_qstorno_1200_2000 8889 8889 0 0.00 2 4892 312 0 0
x_make_qstorno_2100_3300 389268 389268 0 0.00 0 2230 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2026 04:51:06 to 11-11-2026 04:51:10.

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
04:00:50 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
04:01:50 166 2147483648 2486630384 2550919168 162946608 7.052 17 7 15 0 165965216 935296 2083312
04:02:51 269 2147483648 2548693184 2627723264 218316704 9.228 20 13 24 0 221818624 1743312 1758608
04:03:51 166 2147483648 2556447120 2637189120 223149840 9.413 20 13 27 1 231168720 5007216 3011664
04:04:52 163 2147483648 2546253856 2626031616 211540064 8.967 20 12 20 1 217429008 3897520 1991424
04:05:52 208 2147483648 2536546144 2618105856 206596480 8.776 20 10 20 0 211073888 2833040 1644368
04:06:53 152 2147483648 2552229696 2635218944 218302400 9.227 20 15 28 0 225459712 4996080 2161232
04:07:53 206 2147483648 2545647456 2630017024 214536080 9.082 20 11 22 0 220037472 3805568 1695824
04:08:54 232 2147483648 2553604096 2635964416 220281632 9.303 20 14 29 0 227571440 5181568 2108240
04:09:54 194 2147483648 2541587840 2623168512 208427872 8.847 20 10 20 0 215179952 5219664 1532416
04:10:54 187 2147483648 2551924496 2634571776 220041872 9.294 20 15 30 1 225695728 2840528 2813328
04:11:55 206 2147483648 2546109280 2626535424 208352032 8.844 20 15 23 2 220317040 9974800 1990208
04:12:55 224 2147483648 2546319488 2626768896 213104528 9.027 20 17 35 0 219227760 3396368 2726864
04:13:56 222 2147483648 2547079088 2630787072 217076656 9.180 20 12 25 0 222401856 3005648 2319552
04:14:56 240 2147483648 2550303024 2632515584 208575376 8.852 20 13 26 0 224314448 12936304 2802768
04:15:57 167 2147483648 2552095616 2634190848 216045744 9.140 20 15 30 0 225939936 7478368 2415824
04:16:57 162 2147483648 2549051232 2632904704 218867248 9.249 20 10 22 0 222696096 2199584 1629264
04:17:58 154 2147483648 2553800320 2634506240 213900816 9.058 20 14 28 0 226279600 10335120 2043664
04:18:58 316 2147483648 2553392480 2635694080 215579136 9.122 20 13 26 0 226716496 8981904 2155456
04:19:58 189 2147483648 2564729840 2647715840 216106192 9.143 20 10 20 0 237510592 19671280 1733120
04:20:59 131 2147483648 2553909712 2636218368 219108784 9.258 20 16 32 0 227204400 5434576 2661040
04:21:59 232 2147483648 2551949584 2634559488 215065936 9.103 20 14 28 0 224981344 7557408 2358000
04:23:00 143 2147483648 2552579152 2632884224 209820448 8.900 20 13 26 0 224240720 12441312 1978960
04:24:01 178 2147483648 2564529088 2647089152 213570736 9.045 20 14 28 0 240169536 23653136 2945664
04:25:01 300 2147483648 2553857648 2636050432 217302704 9.189 20 11 23 0 226599520 7267712 2029104
04:26:02 168 2147483648 2555687888 2637721600 212070816 8.987 20 12 24 0 229409424 15120032 2218576
04:27:03 165 2147483648 2561814912 2652561408 215594448 9.123 20 8 15 0 235466528 18440432 1431648
04:28:04 258 2147483648 2554977664 2634203136 213753008 9.052 20 18 36 0 226856512 10188720 2914784
04:29:05 111 2147483648 2555044768 2640461824 213934096 9.059 20 8 14 0 228800448 13627280 1239072
04:30:05 174 2147483648 2563728976 2643140608 220145056 9.298 20 17 30 0 236345824 13887936 2312832
04:31:06 117 2147483648 2570857136 2657263616 222534368 9.389 20 12 24 0 243926464 19567408 1824688
04:32:06 214 2147483648 2561507872 2643701760 213795328 9.054 20 14 28 0 233578688 17587472 2195888
04:33:06 156 2147483648 2568660768 2652364800 218274784 9.226 20 14 28 0 240917600 20034112 2608704
04:34:07 309 2147483648 2561230688 2646126592 214702752 9.089 20 14 28 1 233627936 16426928 2498256
04:35:08 248 2147483648 2584489824 2673528832 215567536 9.122 20 13 26 0 257512720 39574944 2370240
04:36:10 167 2147483648 2550310512 2631749632 206616496 8.776 20 14 27 0 222984144 14163280 2204368
04:37:10 496 2147483648 2564076464 2647465984 217740896 9.205 20 12 24 0 237549040 17611024 2197120
04:38:11 158 2147483648 2547076832 2628657152 214193728 9.069 20 13 26 0 220059040 3413632 2451680
04:39:11 1663 2147483648 2558953088 2649722880 217715520 9.204 20 10 20 0 232134640 12452144 1966976
04:40:13 133 2147483648 2555982768 2637651968 212009984 8.985 20 14 29 0 228397536 13968912 2418640
04:41:13 208 2147483648 2558509488 2643165184 218124144 9.220 20 12 24 0 232270016 11946704 2199168
04:42:14 115 2147483648 2559683424 2645692416 217793648 9.207 20 15 29 0 231819936 11804352 2221936
04:43:14 289 2147483648 2551100688 2634035200 215724432 9.128 20 13 24 0 224916144 7206544 1985168
04:44:15 323 2147483648 2545481584 2628853760 212687024 9.011 20 10 18 0 220379872 4923728 2769120
04:45:15 141 2147483648 2561282912 2646466560 214551952 9.083 20 9 17 0 234819632 18501376 1766304
04:46:16 232 2147483648 2537523312 2618183680 202974944 8.635 19 10 19 0 211043280 6577264 1491072
04:47:17 140 2147483648 2555082512 2638987264 214154016 9.068 20 12 22 0 227584496 10829504 2600976
04:48:17 133 2147483648 2550100528 2630815744 211020432 8.947 20 14 29 0 223242528 9777552 2444544
04:49:18 150 2147483648 2566441872 2649235456 212841344 9.017 20 9 18 0 239393280 25044688 1507248
04:50:18 348 2147483648 2563544208 2649186304 216944288 9.175 20 10 20 0 238027184 19397568 1685328

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 11-11-2026 04:51:11 to 11-11-2026 04:51:22.

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 04:51:22 to 11-11-2026 04:51:23.

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          236587
MON$OLDEST_ACTIVE               237249
MON$OLDEST_SNAPSHOT             237249
MON$NEXT_TRANSACTION            237249
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 01:00:09.5980 GMT
MON$PAGES                       171564
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                        {D157E809-7DA2-4682-9776-571BB9145C1D}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             595
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3332 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3332 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3332 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3332 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    Wed Nov 11 04:50:47 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Wed Nov 11 04:50:47 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
:14: 
:15: test-0    Wed Nov 11 04:50:47 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:17: 
--- end of diff output ---

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

11.11.26 04:51:24. 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-11 04:51:25 No severe PSQL-related problems occured
11.11.26 04:51:26. End of report.