Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.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 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 2002712 kB
MemAvailable 7236216 kB
Buffers 90096 kB
Cached 5229084 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 04:50:48
DTS_END                         2026-11-07 04:50:48.7010
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/53410
TRN_ID                          232122
ATT_ID                          472
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: 15434.90 837 771745
customer order: creation 684.98 45 34249
customer order: refuse 54.76 43 2738
order to supplier: creation 179.00 208 8950
order to supplier: removal 13.36 7840 668
invoice (draft): creation 171.30 351 8565
invoice (draft): removal 121.86 134 6093
invoice accept: apply 148.50 1419 7425
invoice accept: cancel 102.76 206 5138
customer reserve: creation 7419.14 24 370957
customer reserve: removal 5500.06 13 275003
realization accept: apply 320.74 35 16037
realization accept: cancel 181.00 18 9050
payment from customer: creation 229.20 32 11460
payment from customer: removal 22.08 18 1104
payment to supplier: creation 187.26 28 9363
payment to supplier: removal 13.12 16 656
service: total inventory turnovers 25.06 1334 1253
service: total monetary turnovers 54.98 14 2749
service: aggregate perf. data 5.70 1648 285
service: refresh index statistics 0.04 3314 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10094
TEST_TIME 2 11007
TEST_TIME 3 11815
TEST_TIME 4 12453
TEST_TIME 5 12548
TEST_TIME 6 12753
TEST_TIME 7 13171
TEST_TIME 8 13273
TEST_TIME 9 13405
TEST_TIME 10 13443
TEST_TIME 11 13507
TEST_TIME 12 13727
TEST_TIME 13 13728
TEST_TIME 14 13931
TEST_TIME 15 13911
TEST_TIME 16 14033
TEST_TIME 17 14067
TEST_TIME 18 14160
TEST_TIME 19 14200
TEST_TIME 20 14311
TEST_TIME 21 14297
TEST_TIME 22 14292
TEST_TIME 23 14318
TEST_TIME 24 14383
TEST_TIME 25 14374
TEST_TIME 26 14425
TEST_TIME 27 14416
TEST_TIME 28 14548
TEST_TIME 29 14516
TEST_TIME 30 14526
TEST_TIME 31 14566
TEST_TIME 32 14711
TEST_TIME 33 14748
TEST_TIME 34 14729
TEST_TIME 35 14804
TEST_TIME 36 14905
TEST_TIME 37 14936
TEST_TIME 38 15002
TEST_TIME 39 15040
TEST_TIME 40 15052
TEST_TIME 41 15134
TEST_TIME 42 15083
TEST_TIME 43 15227
TEST_TIME 44 15221
TEST_TIME 45 15302
TEST_TIME 46 15328
TEST_TIME 47 15316
TEST_TIME 48 15393
TEST_TIME 49 15493
TEST_TIME 50 15435

Performance per minute, chart


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

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 1137331 1137331 0 0.00 0 1430 2 0 0
doc_list_biud 1137331 1137331 0 0.00 0 3018 5 0 0
sp_add_invoice_to_stock 7425 7425 0 0.00 6 14840 1419 0 0
sp_cancel_adding_invoice 5138 5138 0 0.00 2 4873 206 0 0
sp_cancel_client_order 2738 2738 0 0.00 2 1255 43 0 0
sp_cancel_customer_reserve 275003 275003 0 0.00 1 2720 14 0 0
sp_cancel_pay_from_customer 1104 1104 0 0.00 2 510 19 0 0
sp_cancel_pay_to_supplier 656 656 0 0.00 2 131 16 0 0
sp_cancel_supplier_invoice 6093 6093 0 0.00 1 1629 135 0 0
sp_cancel_supplier_order 668 668 0 0.00 5 45766 7841 0 0
sp_cancel_write_off 9050 9050 0 0.00 1 1268 19 0 0
sp_client_order 34249 34249 0 0.00 4 3767 45 0 0
sp_customer_reserve 370957 370957 0 0.00 0 3419 24 0 0
sp_fill_shopping_cart 51764 51764 0 0.00 1 2159 21 0 0
sp_fill_shopping_cart_clo_res 370957 370957 0 0.00 0 1631 2 0 0
sp_get_clo_for_invoice 7425 7425 0 0.00 0 1224 33 0 0
sp_kill_cost_storno 15948 15948 0 0.00 0 896 9 0 0
sp_kill_qstorno_ret_qs2qd 565817 565817 0 0.00 0 2717 7 0 0
sp_kill_qty_storno 322152 322152 0 0.00 0 3017 16 0 0
sp_lock_selected_doc 32504 32504 0 0.00 0 570 2 0 0
sp_make_cost_storno 44285 44285 0 0.00 0 1027 7 0 0
sp_multiply_rows_for_pdistr 44285 44285 0 0.00 0 459 10 0 0
sp_multiply_rows_for_qdistr 34249 34249 0 0.00 0 1155 18 0 0
sp_pay_from_customer 11460 11460 0 0.00 3 834 33 0 0
sp_pay_to_supplier 9363 9363 0 0.00 3 786 29 0 0
sp_payment_common 20823 20823 0 0.00 1 503 6 0 0
sp_qd_handle_on_cancel_clo 2738 2738 0 0.00 0 1245 29 0 0
sp_qd_handle_on_invoice_upd_sts 12563 12563 0 0.00 0 3017 69 0 0
sp_qd_handle_on_reserve_upd_sts 16037 16037 0 0.00 0 1461 11 0 0
sp_reserve_write_off 16037 16037 0 0.00 3 1465 36 0 0
sp_supplier_invoice 8565 8565 0 0.00 5 4968 351 0 0
sp_supplier_order 8950 8950 0 0.00 4 3735 209 0 0
srv_aggregate_perf_data 285 285 0 0.00 9 23389 1649 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 467 208 0 0
srv_find_qd_qs_mism 718450 718450 0 0.00 0 1429 1 0 0
srv_make_invnt_saldo 1253 1253 0 0.00 0 4090 1335 0 0
srv_make_money_saldo 2749 2749 0 0.00 0 286 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 300 6329 3315 0 0
v_add_invoice_to_stock 14850 14850 0 0.00 0 591 2 0 0
v_all_customers 52268 52268 0 0.00 0 52 1 0 0
v_all_suppliers 43338 43338 0 0.00 0 41 1 0 0
v_all_wares 68498 68498 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 1252 1252 0 0.00 0 60 2 0 0
v_cancel_client_order 5476 5476 0 0.00 0 587 1 0 0
v_cancel_customer_prepayment 2208 2208 0 0.00 0 252 1 0 0
v_cancel_customer_reserve 2154 2154 0 0.00 0 565 2 0 0
v_cancel_payment_to_supplier 1312 1312 0 0.00 0 42 1 0 0
v_cancel_supplier_invoice 1168 1168 0 0.00 0 234 2 0 0
v_cancel_supplier_order 1336 1336 0 0.00 0 30 1 0 0
v_cancel_write_off 3178 3178 0 0.00 0 418 2 0 0
v_max_id_clo_ord 8950 8950 0 0.00 0 43 1 0 0
v_max_id_clo_res 1594 1594 0 0.00 0 101 1 0 0
v_max_id_ord_sup 8565 8565 0 0.00 0 424 1 0 0
v_max_non_paid_invoice 5209 5209 0 0.00 0 48 1 0 0
v_max_non_paid_realizn 11072 11072 0 0.00 0 40 1 0 0
v_min_id_clo_ord 8950 8950 0 0.00 0 468 2 0 0
v_min_id_clo_res 1594 1594 0 0.00 0 603 3 0 0
v_min_id_ord_sup 8565 8565 0 0.00 0 970 4 0 0
v_min_non_paid_invoice 9363 9363 0 0.00 0 254 2 0 0
v_min_non_paid_realizn 11460 11460 0 0.00 0 227 2 0 0
v_our_firm 17006 17006 0 0.00 0 28 1 0 0
v_reserve_write_off 32074 32074 0 0.00 0 731 1 0 0
x_lock_depdocs_on_canc_invoice 10647 10647 0 0.00 0 1778 10 0 0
x_lock_depdocs_on_canc_sup_ord 668 668 0 0.00 0 140 11 0 0
x_make_qstorno_1000_1200 8950 8950 0 0.00 1 3707 150 0 0
x_make_qstorno_1200_2000 8565 8565 0 0.00 2 4938 308 0 0
x_make_qstorno_2100_3300 370957 370957 0 0.00 0 3389 21 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-11-2026 04:51:08 to 07-11-2026 04:51:12.

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:52 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
04:01:52 186 2147483648 2495364000 2559848448 169503648 7.315 18 9 21 1 171850272 912480 1434144
04:02:53 393 2147483648 2548647520 2626801664 216240288 9.148 20 10 21 0 219560576 2224288 1096000
04:03:53 207 2147483648 2551848240 2631663616 220767392 9.321 20 13 25 2 226747024 3813440 2166192
04:04:54 242 2147483648 2546423664 2626576384 212142112 8.990 20 14 27 0 221270928 6180608 2948208
04:05:55 196 2147483648 2534165648 2614063104 206767264 8.782 19 11 25 0 210845584 1791552 2286768
04:06:55 230 2147483648 2551789056 2632015872 216366736 9.153 20 14 28 0 225957584 6626720 2964128
04:07:55 262 2147483648 2552352352 2634084352 216272320 9.149 20 12 24 0 225968080 7662672 2033088
04:08:56 229 2147483648 2557164688 2639446016 213413888 9.039 20 14 28 0 230219840 14145328 2660624
04:09:56 299 2147483648 2549374976 2630914048 216784336 9.169 20 12 24 0 223543360 4872432 1886592
04:10:57 164 2147483648 2543254544 2622644224 210364080 8.921 20 12 25 0 216181392 3537472 2279840
04:11:57 276 2147483648 2551059280 2634227712 213158816 9.029 20 8 16 0 225638240 11310896 1168528
04:12:58 206 2147483648 2554445632 2636120064 212628128 9.009 20 11 22 0 226152848 11684784 1839936
04:13:59 299 2147483648 2558744912 2643791872 219408784 9.269 20 9 18 0 232899792 12062416 1428592
04:14:59 191 2147483648 2537072832 2616713216 202748720 8.626 19 15 30 0 212430640 7261504 2420416
04:16:00 119 2147483648 2560200160 2643382272 216446560 9.156 20 10 20 0 233766432 15564112 1755760
04:17:00 237 2147483648 2554867680 2638336000 219534560 9.274 20 11 22 0 229103136 7221136 2347440
04:18:00 140 2147483648 2548756976 2629193728 211907360 8.981 20 12 24 0 221928544 7972176 2049008
04:19:01 250 2147483648 2546318256 2625318912 210034032 8.909 20 13 26 0 219407280 7292384 2080864
04:20:01 165 2147483648 2558670352 2642231296 217901168 9.212 20 12 20 2 232071824 12460448 1710208
04:21:02 139 2147483648 2546953200 2628042752 214340128 9.075 20 14 28 1 219529328 2863488 2325712
04:22:02 268 2147483648 2559426896 2644525056 219416224 9.270 20 7 14 0 233501568 12642432 1442912
04:23:03 161 2147483648 2564484144 2650103808 217524448 9.197 20 12 24 0 238014512 18442336 2047728
04:24:03 186 2147483648 2563611840 2645528576 214400528 9.077 20 12 24 0 236076464 19641824 2034112
04:25:04 183 2147483648 2560164240 2643349504 215468592 9.118 20 8 16 0 233646656 16528896 1649168
04:26:04 236 2147483648 2560447616 2643701760 216435408 9.155 20 13 26 0 234260656 15234592 2590656
04:27:05 170 2147483648 2562435072 2644725760 220014736 9.293 20 15 29 0 236702112 14031648 2655728
04:28:06 126 2147483648 2553245632 2635788288 212561344 9.006 20 13 25 0 226196992 11516784 2118864
04:29:06 200 2147483648 2546014608 2629734400 211328576 8.959 20 9 17 1 218854928 6232400 1293952
04:30:08 361 2147483648 2561416848 2646192128 219315712 9.266 20 7 14 0 233297680 12941024 1040944
04:31:09 161 2147483648 2552955504 2635407360 214005440 9.062 20 15 29 1 225200704 8635312 2559952
04:32:09 333 2147483648 2567200928 2650750976 215721808 9.128 20 8 16 0 239030496 21915872 1392816
04:33:10 198 2147483648 2557716928 2653646848 214997392 9.100 20 7 14 0 230937392 14924240 1015760
04:34:10 194 2147483648 2559398608 2642452480 218230832 9.224 20 14 29 0 230843728 10271280 2341616
04:35:11 185 2147483648 2550142320 2632794112 216476112 9.157 20 14 26 0 222489760 3906464 2107184
04:36:11 174 2147483648 2587688672 2671415296 216053952 9.141 20 13 26 0 259334368 40942528 2337888
04:37:13 167 2147483648 2553289424 2634170368 214337968 9.075 20 12 24 0 225579424 9078832 2162624
04:38:13 174 2147483648 2539727504 2619494400 202046736 8.599 19 12 24 0 212652592 8314512 2291344
04:39:14 118 2147483648 2545710448 2628411392 211565280 8.968 20 11 22 0 218100224 4455040 2079904
04:40:15 148 2147483648 2545879344 2630930432 214152400 9.067 20 10 20 0 218888592 3152912 1583280
04:41:15 464 2147483648 2558527184 2643595264 215835072 9.132 20 8 15 0 231331888 14321984 1174832
04:42:15 199 2147483648 2549197200 2630451200 213633424 9.047 20 13 26 0 219498128 3777936 2086768
04:43:16 125 2147483648 2559035200 2643226624 218104128 9.219 20 13 25 0 230572992 10843104 1625760
04:44:16 181 2147483648 2557672256 2641141760 216335872 9.151 20 12 24 0 229341232 10624560 2380800
04:45:17 139 2147483648 2588762288 2674708480 218787760 9.246 20 11 22 0 260553840 39486576 2279504
04:46:18 159 2147483648 2563261680 2646839296 214313104 9.074 20 11 21 0 234519120 18574816 1631200
04:47:18 222 2147483648 2554028976 2636709888 217276256 9.188 20 12 24 0 225351760 5968240 2107264
04:48:18 143 2147483648 2561970576 2655240192 218462048 9.233 20 9 18 0 234785424 14791056 1532320
04:49:19 190 2147483648 2565369008 2646171648 217778320 9.207 20 15 29 0 236989584 16946400 2264864
04:50:19 178 2147483648 2559636992 2643075072 215635792 9.125 20 12 24 0 231549808 14072944 1841072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 04:51:25 to 07-11-2026 04:51:26.

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          231887
MON$OLDEST_ACTIVE               232460
MON$OLDEST_SNAPSHOT             232460
MON$NEXT_TRANSACTION            232460
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 01:00:10.0170 GMT
MON$PAGES                       161432
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                        {A34E8737-7951-45C4-AB4C-6B05CF160D00}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             589
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 04:50:49 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Sat Nov  7 04:50:50 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
:14: 
:15: test-0    Sat Nov  7 04:50:50 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'

07.11.26 04:51:26. 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 04:51:28 No severe PSQL-related problems occured
07.11.26 04:51:28. End of report.