Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 17.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 e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+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 2w 3d
Command: who -b
bootup_info system boot 2026-11-14 21: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 8138028 kB
MemFree 2051432 kB
MemAvailable 7311448 kB
Buffers 79228 kB
Cached 5262984 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-17 04:50:46
DTS_END                         2026-11-17 04:50:46.3450
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/34284
TRN_ID                          242935
ATT_ID                          480
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: 16289.24 1003 814462
customer order: creation 715.90 42 35795
customer order: refuse 57.68 43 2884
order to supplier: creation 185.12 192 9256
order to supplier: removal 13.66 8023 683
invoice (draft): creation 183.58 329 9179
invoice (draft): removal 130.78 134 6539
invoice accept: apply 156.86 1306 7843
invoice accept: cancel 107.60 193 5380
customer reserve: creation 7858.88 22 392944
customer reserve: removal 5785.30 13 289265
realization accept: apply 336.48 34 16824
realization accept: cancel 192.54 18 9627
payment from customer: creation 241.04 31 12052
payment from customer: removal 22.28 17 1114
payment to supplier: creation 198.48 27 9924
payment to supplier: removal 13.14 17 657
service: total inventory turnovers 25.86 1255 1293
service: total monetary turnovers 58.20 13 2910
service: aggregate perf. data 5.80 1654 290
service: refresh index statistics 0.06 6700 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11857
TEST_TIME 2 12631
TEST_TIME 3 12698
TEST_TIME 4 13126
TEST_TIME 5 13382
TEST_TIME 6 13659
TEST_TIME 7 13778
TEST_TIME 8 14205
TEST_TIME 9 14193
TEST_TIME 10 14280
TEST_TIME 11 14395
TEST_TIME 12 14408
TEST_TIME 13 14430
TEST_TIME 14 14587
TEST_TIME 15 14707
TEST_TIME 16 14719
TEST_TIME 17 14729
TEST_TIME 18 14768
TEST_TIME 19 14787
TEST_TIME 20 14942
TEST_TIME 21 14852
TEST_TIME 22 14960
TEST_TIME 23 14958
TEST_TIME 24 14925
TEST_TIME 25 14990
TEST_TIME 26 15022
TEST_TIME 27 15043
TEST_TIME 28 15102
TEST_TIME 29 15078
TEST_TIME 30 15171
TEST_TIME 31 15282
TEST_TIME 32 15357
TEST_TIME 33 15438
TEST_TIME 34 15504
TEST_TIME 35 15517
TEST_TIME 36 15592
TEST_TIME 37 15696
TEST_TIME 38 15641
TEST_TIME 39 15754
TEST_TIME 40 15898
TEST_TIME 41 15878
TEST_TIME 42 15933
TEST_TIME 43 16020
TEST_TIME 44 16025
TEST_TIME 45 16182
TEST_TIME 46 16207
TEST_TIME 47 16210
TEST_TIME 48 16318
TEST_TIME 49 16300
TEST_TIME 50 16289

Performance per minute, chart


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

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 1200894 1200894 0 0.00 0 1137 2 0 0
doc_list_biud 1200894 1200894 0 0.00 0 2403 5 0 0
sp_add_invoice_to_stock 7843 7843 0 0.00 7 11559 1307 0 0
sp_cancel_adding_invoice 5380 5380 0 0.00 3 4628 193 0 0
sp_cancel_client_order 2884 2884 0 0.00 3 1983 43 0 0
sp_cancel_customer_reserve 289265 289265 0 0.00 1 2404 14 0 0
sp_cancel_pay_from_customer 1114 1114 0 0.00 2 673 18 0 0
sp_cancel_pay_to_supplier 657 657 0 0.00 2 635 17 0 0
sp_cancel_supplier_invoice 6539 6539 0 0.00 1 1831 134 0 0
sp_cancel_supplier_order 683 683 0 0.00 5 44985 8023 0 0
sp_cancel_write_off 9627 9627 0 0.00 1 1302 18 0 0
sp_client_order 35795 35795 0 0.00 3 1486 43 0 0
sp_customer_reserve 392944 392944 0 0.00 0 2043 22 0 0
sp_fill_shopping_cart 54230 54230 0 0.00 1 3296 20 0 0
sp_fill_shopping_cart_clo_res 392944 392944 0 0.00 0 1290 2 0 0
sp_get_clo_for_invoice 7843 7843 0 0.00 0 1849 33 0 0
sp_kill_cost_storno 16778 16778 0 0.00 0 698 9 0 0
sp_kill_qstorno_ret_qs2qd 595379 595379 0 0.00 0 2026 7 0 0
sp_kill_qty_storno 339045 339045 0 0.00 0 2402 16 0 0
sp_lock_selected_doc 34037 34037 0 0.00 0 628 1 0 0
sp_make_cost_storno 46643 46643 0 0.00 0 796 7 0 0
sp_multiply_rows_for_pdistr 46643 46643 0 0.00 0 768 10 0 0
sp_multiply_rows_for_qdistr 35795 35795 0 0.00 0 1214 17 0 0
sp_pay_from_customer 12052 12052 0 0.00 3 858 32 0 0
sp_pay_to_supplier 9924 9924 0 0.00 3 987 28 0 0
sp_payment_common 21976 21976 0 0.00 1 604 6 0 0
sp_qd_handle_on_cancel_clo 2884 2884 0 0.00 0 1969 28 0 0
sp_qd_handle_on_invoice_upd_sts 13223 13223 0 0.00 0 2334 65 0 0
sp_qd_handle_on_reserve_upd_sts 16824 16824 0 0.00 0 1202 10 0 0
sp_reserve_write_off 16824 16824 0 0.00 3 1218 34 0 0
sp_supplier_invoice 9179 9179 0 0.00 6 5726 329 0 0
sp_supplier_order 9256 9256 0 0.00 5 2463 192 0 0
srv_aggregate_perf_data 290 290 0 0.00 5 20293 1654 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 539 220 0 0
srv_find_qd_qs_mism 758096 758096 0 0.00 0 1136 1 0 0
srv_make_invnt_saldo 1293 1293 0 0.00 0 4234 1255 0 0
srv_make_money_saldo 2910 2910 0 0.00 0 246 14 0 0
srv_recalc_idx_stat 3 3 0 0.00 180 12143 6700 0 0
v_add_invoice_to_stock 15686 15686 0 0.00 0 392 2 0 0
v_all_customers 54582 54582 0 0.00 0 39 1 0 0
v_all_suppliers 45652 45652 0 0.00 0 33 1 0 0
v_all_wares 71590 71590 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 1354 1354 0 0.00 0 185 2 0 0
v_cancel_client_order 5768 5768 0 0.00 0 604 1 0 0
v_cancel_customer_prepayment 2228 2228 0 0.00 0 280 1 0 0
v_cancel_customer_reserve 2174 2174 0 0.00 0 99 1 0 0
v_cancel_payment_to_supplier 1314 1314 0 0.00 0 272 1 0 0
v_cancel_supplier_invoice 1250 1250 0 0.00 0 240 2 0 0
v_cancel_supplier_order 1366 1366 0 0.00 0 272 2 0 0
v_cancel_write_off 3286 3286 0 0.00 0 397 2 0 0
v_max_id_clo_ord 9256 9256 0 0.00 0 454 1 0 0
v_max_id_clo_res 1684 1684 0 0.00 0 126 1 0 0
v_max_id_ord_sup 9179 9179 0 0.00 0 1093 2 0 0
v_max_non_paid_invoice 5533 5533 0 0.00 0 39 1 0 0
v_max_non_paid_realizn 11714 11714 0 0.00 0 28 1 0 0
v_min_id_clo_ord 9256 9256 0 0.00 0 435 2 0 0
v_min_id_clo_res 1684 1684 0 0.00 0 671 3 0 0
v_min_id_ord_sup 9179 9179 0 0.00 0 844 4 0 0
v_min_non_paid_invoice 9924 9924 0 0.00 0 381 2 0 0
v_min_non_paid_realizn 12052 12052 0 0.00 0 400 2 0 0
v_our_firm 17684 17684 0 0.00 0 22 1 0 0
v_reserve_write_off 33648 33648 0 0.00 0 527 1 0 0
x_lock_depdocs_on_canc_invoice 11294 11294 0 0.00 0 1701 10 0 0
x_lock_depdocs_on_canc_sup_ord 683 683 0 0.00 0 115 10 0 0
x_make_qstorno_1000_1200 9256 9256 0 0.00 1 2382 136 0 0
x_make_qstorno_1200_2000 9179 9179 0 0.00 1 5087 286 0 0
x_make_qstorno_2100_3300 392944 392944 0 0.00 0 1992 19 0 0

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

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:49 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
04:01:50 222 2147483648 2528059504 2600415232 197018400 8.403 20 12 25 0 202030240 2431984 2579856
04:02:50 150 2147483648 2523792704 2597367808 193359296 8.260 20 17 36 1 198404416 2174288 2870832
04:03:50 260 2147483648 2550880320 2631143424 219569664 9.276 20 13 25 1 224024048 2295584 2158800
04:04:51 239 2147483648 2553808672 2635673600 219593072 9.276 20 10 21 0 227423504 6017792 1812640
04:05:52 233 2147483648 2543896048 2624319488 214357328 9.075 20 15 30 1 218951408 2188128 2405952
04:06:52 140 2147483648 2541483088 2622664704 212630288 9.009 20 12 23 0 216417232 1648496 2138448
04:07:52 312 2147483648 2553828368 2637426688 214767008 9.091 20 11 22 0 227317232 10628624 1921600
04:08:53 182 2147483648 2557751456 2641166336 219779152 9.284 20 10 20 0 231682912 10353216 1550544
04:09:53 218 2147483648 2552449776 2634788864 215554176 9.121 20 13 26 0 226449008 8781328 2113504
04:10:54 224 2147483648 2548666352 2633740288 218822240 9.247 20 8 16 1 222680656 2374624 1483792
04:11:54 199 2147483648 2552967712 2636587008 217635376 9.201 20 14 27 0 227291264 7712160 1943728
04:12:54 295 2147483648 2548673120 2632896512 217952064 9.214 20 11 22 2 224650256 4070928 2627264
04:13:55 175 2147483648 2543615456 2623160320 210056960 8.910 20 10 20 0 216728432 5105824 1565648
04:14:55 220 2147483648 2563446048 2645454848 218515104 9.235 20 14 27 0 238197520 17086080 2596336
04:15:55 158 2147483648 2553187584 2634215424 217543760 9.198 20 15 32 0 226181776 5896224 2741792
04:16:56 166 2147483648 2546130000 2626375680 211906672 8.981 20 13 24 1 219244992 5267856 2070464
04:17:56 164 2147483648 2550058976 2638921728 213719936 9.051 20 7 14 0 224675056 9791824 1163296
04:18:57 154 2147483648 2557119600 2639343616 215384048 9.115 20 11 20 0 230112768 12702432 2026288
04:19:57 159 2147483648 2562413792 2650566656 215057632 9.102 20 12 24 0 235322848 18090848 2174368
04:20:57 144 2147483648 2558062416 2642862080 220320864 9.304 20 11 22 0 230952512 8921440 1710208
04:21:57 504 2147483648 2566332992 2651623424 219753328 9.283 20 11 22 0 239516400 18144816 1618256
04:22:58 162 2147483648 2545565088 2626965504 210656304 8.933 20 12 25 0 220105056 7619072 1829680
04:23:59 184 2147483648 2548156784 2628833280 213483488 9.042 20 13 26 0 221457408 5275744 2698176
04:24:59 143 2147483648 2548897472 2626801664 206961616 8.790 20 16 31 0 218608960 8855440 2791904
04:25:59 142 2147483648 2562466160 2644271104 216793328 9.169 20 15 30 0 235746800 16026016 2927456
04:27:00 175 2147483648 2567414752 2647724032 217875728 9.211 20 14 26 0 239656480 19623120 2157632
04:28:00 195 2147483648 2551435536 2637406208 212202896 8.992 20 14 29 0 222045232 7357280 2485056
04:29:01 190 2147483648 2549624480 2633625600 215144080 9.106 20 9 16 0 223548160 6889536 1514544
04:30:01 234 2147483648 2573353184 2656133120 217749280 9.206 20 8 16 0 245994240 26713392 1531568
04:31:01 151 2147483648 2556986288 2639802368 218550912 9.237 20 10 20 0 231021904 10904432 1566560
04:32:02 533 2147483648 2560782624 2648887296 220340336 9.305 20 12 23 0 233886048 11639808 1905904
04:33:02 428 2147483648 2552156688 2635911168 216875008 9.172 20 9 18 0 226300560 7472976 1952576
04:34:04 153 2147483648 2557339024 2653798400 216840704 9.171 20 11 21 0 230923728 12303360 1779664
04:35:05 171 2147483648 2542134352 2630672384 211387792 8.961 20 9 18 0 215818896 2744800 1686304
04:36:05 157 2147483648 2572618464 2655367168 218756944 9.244 20 13 27 0 245343872 24483472 2103456
04:37:06 193 2147483648 2569867888 2654887936 217160976 9.183 20 9 18 0 242350592 23645056 1544560
04:38:06 117 2147483648 2557163568 2639077376 216100480 9.142 20 12 24 0 228881280 10817440 1963360
04:39:07 157 2147483648 2554278128 2636693504 217561776 9.199 20 15 30 0 225355200 5303232 2490192
04:40:07 279 2147483648 2555473312 2638237696 212370192 8.999 20 13 25 0 227456304 13159760 1926352
04:41:08 240 2147483648 2550154336 2632826880 215525696 9.120 20 13 26 0 223592944 6252336 1814912
04:42:08 214 2147483648 2552334944 2634117120 214293472 9.073 20 16 34 0 224356320 6941200 3121648
04:43:09 359 2147483648 2562571504 2649210880 216190480 9.146 20 4 8 0 235009872 18052928 766464
04:44:10 196 2147483648 2552816592 2636374016 214626048 9.086 20 9 19 0 226279776 9794816 1858912
04:45:10 284 2147483648 2569521680 2656051200 207892080 8.826 20 8 16 0 243100080 33827024 1380976
04:46:10 235 2147483648 2554103376 2639925248 216709136 9.166 20 9 18 0 227002032 8820400 1472496
04:47:11 227 2147483648 2546435680 2629808128 211780832 8.976 20 7 14 0 220733840 7881104 1071904
04:48:11 182 2147483648 2574713552 2656354304 215771072 9.130 20 13 26 0 246998352 28913664 2313616
04:49:12 375 2147483648 2560973936 2645237760 214928768 9.097 20 10 20 0 232034720 15143168 1962784
04:50:14 235 2147483648 2577577472 2662055936 215883504 9.134 20 12 24 0 249634560 31894880 1856176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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

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          242506
MON$OLDEST_ACTIVE               243195
MON$OLDEST_SNAPSHOT             243195
MON$NEXT_TRANSACTION            243195
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-17 01:00:09.1470 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                        {9E981B9D-06FF-4E85-827D-6E766A414595}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             603
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 ---
--- end of diff output ---

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

17.11.26 04:51:25. 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-17 04:51:26 No severe PSQL-related problems occured
17.11.26 04:51:27. End of report.