Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 03.11.2026 16:51
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 3d
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 1536252 kB
MemAvailable 7242236 kB
Buffers 84396 kB
Cached 5744716 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-03 16:51:13
DTS_END                         2026-11-03 16:51:13.1980
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/51726
TRN_ID                          160646
ATT_ID                          357
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: 9063.82 1030 453191
customer order: creation 474.66 64 23733
customer order: refuse 38.46 57 1923
order to supplier: creation 123.08 261 6154
order to supplier: removal 9.24 8125 462
invoice (draft): creation 117.40 393 5870
invoice (draft): removal 80.42 149 4021
invoice accept: apply 99.94 1742 4997
invoice accept: cancel 65.28 226 3264
customer reserve: creation 4337.98 33 216899
customer reserve: removal 3014.70 18 150735
realization accept: apply 218.30 50 10915
realization accept: cancel 116.72 28 5836
payment from customer: creation 158.06 47 7903
payment from customer: removal 14.72 31 736
payment to supplier: creation 128.58 43 6429
payment to supplier: removal 9.28 24 464
service: total inventory turnovers 15.30 2244 765
service: total monetary turnovers 37.62 8 1881
service: aggregate perf. data 4.04 1318 202
service: refresh index statistics 0.04 5735 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-11-2026 16:51:33 to 03-11-2026 16:51:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6240
TEST_TIME 2 5472
TEST_TIME 3 5620
TEST_TIME 4 6109
TEST_TIME 5 6556
TEST_TIME 6 6971
TEST_TIME 7 7272
TEST_TIME 8 7472
TEST_TIME 9 7744
TEST_TIME 10 7715
TEST_TIME 11 8036
TEST_TIME 12 8038
TEST_TIME 13 8045
TEST_TIME 14 8057
TEST_TIME 15 8167
TEST_TIME 16 8288
TEST_TIME 17 8397
TEST_TIME 18 8471
TEST_TIME 19 8445
TEST_TIME 20 8530
TEST_TIME 21 8740
TEST_TIME 22 8739
TEST_TIME 23 8756
TEST_TIME 24 8795
TEST_TIME 25 8783
TEST_TIME 26 8871
TEST_TIME 27 8800
TEST_TIME 28 8757
TEST_TIME 29 8800
TEST_TIME 30 8794
TEST_TIME 31 8764
TEST_TIME 32 8703
TEST_TIME 33 8706
TEST_TIME 34 8659
TEST_TIME 35 8614
TEST_TIME 36 8700
TEST_TIME 37 8747
TEST_TIME 38 8781
TEST_TIME 39 8871
TEST_TIME 40 8842
TEST_TIME 41 8890
TEST_TIME 42 8911
TEST_TIME 43 8970
TEST_TIME 44 9071
TEST_TIME 45 9063
TEST_TIME 46 9181
TEST_TIME 47 9187
TEST_TIME 48 9201
TEST_TIME 49 9147
TEST_TIME 50 9064

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-11-2026 16:51:36 to 03-11-2026 16:51:39.

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 671755 671755 0 0.00 0 1699 3 0 0
doc_list_biud 671755 671755 0 0.00 0 2978 6 0 0
sp_add_invoice_to_stock 4997 4997 0 0.00 6 17586 1742 0 0
sp_cancel_adding_invoice 3264 3264 0 0.00 3 7100 227 0 0
sp_cancel_client_order 1923 1923 0 0.00 3 2757 58 0 0
sp_cancel_customer_reserve 150735 150735 0 0.00 1 2979 18 0 0
sp_cancel_pay_from_customer 736 736 0 0.00 2 1448 31 0 0
sp_cancel_pay_to_supplier 464 464 0 0.00 2 1500 25 0 0
sp_cancel_supplier_invoice 4021 4021 0 0.00 1 2523 149 0 0
sp_cancel_supplier_order 462 462 0 0.00 3 55728 8126 0 0
sp_cancel_write_off 5836 5836 0 0.00 1 2375 29 0 0
sp_client_order 23733 23733 0 0.00 4 2831 64 0 0
sp_customer_reserve 216899 216899 0 0.00 0 5307 34 0 0
sp_fill_shopping_cart 35757 35757 0 0.00 1 2617 24 0 0
sp_fill_shopping_cart_clo_res 216899 216899 0 0.00 0 2474 3 0 0
sp_get_clo_for_invoice 4997 4997 0 0.00 0 1987 36 0 0
sp_kill_cost_storno 10300 10300 0 0.00 0 1428 14 0 0
sp_kill_qstorno_ret_qs2qd 311789 311789 0 0.00 0 2977 9 0 0
sp_kill_qty_storno 182153 182153 0 0.00 0 2978 21 0 0
sp_lock_selected_doc 22193 22193 0 0.00 0 922 2 0 0
sp_make_cost_storno 30244 30244 0 0.00 0 1054 9 0 0
sp_multiply_rows_for_pdistr 30244 30244 0 0.00 0 1682 16 0 0
sp_multiply_rows_for_qdistr 23733 23733 0 0.00 0 2177 23 0 0
sp_pay_from_customer 7903 7903 0 0.00 3 1385 48 0 0
sp_pay_to_supplier 6429 6429 0 0.00 3 1701 44 0 0
sp_payment_common 14332 14332 0 0.00 1 1283 9 0 0
sp_qd_handle_on_cancel_clo 1923 1923 0 0.00 0 2717 41 0 0
sp_qd_handle_on_invoice_upd_sts 8261 8261 0 0.00 0 2637 71 0 0
sp_qd_handle_on_reserve_upd_sts 10915 10915 0 0.00 0 1684 14 0 0
sp_reserve_write_off 10915 10915 0 0.00 3 1693 51 0 0
sp_supplier_invoice 5870 5870 0 0.00 4 5782 393 0 0
sp_supplier_order 6154 6154 0 0.00 5 4622 262 0 0
srv_aggregate_perf_data 202 202 0 0.00 4 8874 1319 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1701 357 0 0
srv_find_qd_qs_mism 419188 419188 0 0.00 0 1590 2 0 0
srv_make_invnt_saldo 765 765 0 0.00 2 7725 2245 0 0
srv_make_money_saldo 1881 1881 0 0.00 0 206 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 881 10590 5736 0 0
v_add_invoice_to_stock 9994 9994 0 0.00 0 1747 3 0 0
v_all_customers 36416 36416 0 0.00 0 96 1 0 0
v_all_suppliers 29336 29336 0 0.00 0 120 1 0 0
v_all_wares 47466 47466 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 473 3 0 0
v_cancel_client_order 3846 3846 0 0.00 0 462 2 0 0
v_cancel_customer_prepayment 1472 1472 0 0.00 0 1435 5 0 0
v_cancel_customer_reserve 1500 1500 0 0.00 0 407 3 0 0
v_cancel_payment_to_supplier 928 928 0 0.00 0 1432 4 0 0
v_cancel_supplier_invoice 788 788 0 0.00 0 246 3 0 0
v_cancel_supplier_order 924 924 0 0.00 0 212 2 0 0
v_cancel_write_off 2204 2204 0 0.00 0 484 2 0 0
v_max_id_clo_ord 6154 6154 0 0.00 0 105 1 0 0
v_max_id_clo_res 1149 1149 0 0.00 0 304 2 0 0
v_max_id_ord_sup 5870 5870 0 0.00 0 1083 3 0 0
v_max_non_paid_invoice 3785 3785 0 0.00 0 70 2 0 0
v_max_non_paid_realizn 7463 7463 0 0.00 0 58 2 0 0
v_min_id_clo_ord 6154 6154 0 0.00 0 1058 4 0 0
v_min_id_clo_res 1149 1149 0 0.00 0 1464 10 0 0
v_min_id_ord_sup 5870 5870 0 0.00 0 2486 10 0 0
v_min_non_paid_invoice 6429 6429 0 0.00 0 912 3 0 0
v_min_non_paid_realizn 7903 7903 0 0.00 0 1173 3 0 0
v_our_firm 11930 11930 0 0.00 0 85 1 0 0
v_reserve_write_off 21830 21830 0 0.00 0 775 2 0 0
x_lock_depdocs_on_canc_invoice 6891 6891 0 0.00 0 1513 9 0 0
x_lock_depdocs_on_canc_sup_ord 462 462 0 0.00 0 272 11 0 0
x_make_qstorno_1000_1200 6154 6154 0 0.00 1 4577 198 0 0
x_make_qstorno_1200_2000 5870 5870 0 0.00 1 5705 335 0 0
x_make_qstorno_2100_3300 216899 216899 0 0.00 0 5172 29 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 03-11-2026 16:51:39 to 03-11-2026 16:51:44.

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
16:01:18 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
16:02:19 448 2147483648 2543376832 2625142784 217779664 9.207 20 7 14 0 220010208 1085248 1145296
16:03:20 837 2147483648 2553376496 2635051008 224891344 9.479 20 14 28 1 229621264 2533456 2196464
16:04:22 438 2147483648 2545057360 2623455232 214882672 9.096 20 8 16 0 219502368 3468768 1150928
16:05:23 172 2147483648 2548294496 2630455296 222155312 9.375 20 5 8 1 224680352 1059008 1466032
16:06:24 142 2147483648 2538197424 2616512512 208788768 8.860 20 11 22 0 213689872 2976992 1924112
16:07:24 230 2147483648 2551433056 2632572928 223215216 9.415 20 12 26 0 227530816 1772176 2543424
16:08:25 204 2147483648 2515399776 2589818880 188635056 8.074 19 7 13 0 191257664 1329344 1293264
16:09:25 757 2147483648 2549701392 2632310784 219915296 9.289 20 7 12 0 224352384 3074704 1362384
16:10:27 182 2147483648 2546329440 2629140480 219254992 9.264 20 11 21 1 222933040 2154656 1523392
16:11:27 169 2147483648 2535934640 2616246272 208394640 8.845 20 8 17 0 210977344 1249328 1333376
16:12:28 295 2147483648 2557155600 2639400960 219528512 9.274 20 10 20 0 231106016 9620112 1957392
16:13:28 184 2147483648 2549420336 2633228288 214819824 9.093 20 8 13 0 224480080 8483904 1176352
16:14:29 262 2147483648 2542084096 2625064960 210750288 8.936 20 8 17 0 216497488 4523440 1223760
16:15:30 438 2147483648 2547422800 2632613888 219459920 9.271 20 8 16 0 222605168 1908272 1236976
16:16:31 387 2147483648 2551036800 2638020608 215591904 9.123 20 6 12 0 226307856 9604288 1111664
16:17:31 325 2147483648 2542655376 2625105920 210469024 8.925 20 10 19 0 217029696 5236992 1323680
16:18:32 265 2147483648 2549440992 2633256960 215964128 9.137 20 9 18 0 224284320 5991296 2328896
16:19:33 378 2147483648 2551644016 2635124736 218948096 9.252 20 8 16 0 224923888 4561120 1414672
16:20:34 493 2147483648 2549433072 2634395648 216185408 9.146 20 9 18 0 224216992 6581904 1449680
16:21:35 152 2147483648 2543782064 2627473408 209352688 8.882 20 8 16 0 217794736 7068832 1373216
16:22:36 169 2147483648 2572769024 2659753984 220404496 9.308 20 12 24 0 246437440 23476048 2556896
16:23:36 174 2147483648 2546688128 2630938624 215602848 9.123 20 10 19 1 220921520 3910864 1407808
16:24:37 276 2147483648 2540373072 2625630208 209120032 8.873 20 6 12 1 215105808 5171888 813888
16:25:38 519 2147483648 2547868288 2628251648 210918032 8.943 20 14 28 0 220029008 6826848 2284128
16:26:39 89 2147483648 2544677856 2630008832 212071264 8.987 20 4 8 0 219664192 6802624 790304
16:27:39 246 2147483648 2572258368 2656112640 220826432 9.324 20 11 19 0 246724256 24170720 1727104
16:28:40 252 2147483648 2555430928 2638639104 217290064 9.188 20 12 24 0 229852016 10415536 2146416
16:29:40 212 2147483648 2550610608 2632622080 208622368 8.854 20 7 14 0 225337712 15109024 1606320
16:30:41 250 2147483648 2540730400 2621394944 210247408 8.917 20 14 28 0 216002336 3070304 2684624
16:31:42 235 2147483648 2554679568 2636668928 219077600 9.257 20 11 22 1 227367088 6473296 1816192
16:32:43 284 2147483648 2553688848 2635649024 219923344 9.289 20 13 25 0 226801328 4976016 1901968
16:33:45 245 2147483648 2543180992 2626691072 210385392 8.922 20 10 18 0 216965248 5067312 1512544
16:34:46 211 2147483648 2550664016 2633576448 214125920 9.066 20 11 22 0 224450224 8533296 1791008
16:35:46 372 2147483648 2543152880 2626523136 213211360 9.031 20 8 16 0 216948176 1946512 1790304
16:36:47 911 2147483648 2546682416 2631933952 215214048 9.108 20 7 12 0 220547536 4282960 1050528
16:37:48 161 2147483648 2555934944 2643943424 219740048 9.282 20 6 12 0 231274432 10501440 1032944
16:38:49 461 2147483648 2553101376 2646093824 214864128 9.095 20 12 24 0 224718208 7858800 1995280
16:39:50 243 2147483648 2556095392 2641825792 214203824 9.069 20 7 12 0 229905536 14792272 909440
16:40:52 419 2147483648 2551199248 2644185088 213118064 9.028 20 7 14 0 222785856 8383648 1284144
16:41:53 201 2147483648 2558832848 2647089152 220713488 9.319 20 6 12 0 232429056 10824720 890848
16:42:54 184 2147483648 2560071184 2645098496 217047744 9.179 20 10 20 0 233995808 14991200 1956864
16:43:54 151 2147483648 2567570832 2652258304 215656672 9.125 20 10 20 0 241087424 23744544 1686208
16:44:57 1677 2147483648 2557042400 2642657280 213926320 9.059 20 13 26 0 230426544 13510896 2989328
16:45:59 305 2147483648 2548672304 2633187328 215127392 9.105 20 7 14 0 221588768 5442720 1018656
16:46:59 717 2147483648 2561361088 2657443840 214226400 9.070 20 10 20 0 233524496 17604752 1693344
16:48:01 737 2147483648 2551504736 2635464704 217298192 9.188 20 10 20 0 225112112 5574528 2239392
16:49:02 758 2147483648 2550600528 2633121792 211909216 8.981 20 11 23 1 224622752 10753408 1960128
16:50:03 192 2147483648 2547610624 2631294976 212036160 8.986 20 12 22 2 220593760 6944736 1612864
16:51:03 239 2147483648 2564964656 2662449152 219790992 9.284 20 13 26 0 237379104 15212400 2375712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:18, from 03-11-2026 16:51:45 to 03-11-2026 16:52:03.

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 03-11-2026 16:52:03 to 03-11-2026 16:52:04.

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          159936
MON$OLDEST_ACTIVE               160808
MON$OLDEST_SNAPSHOT             160808
MON$NEXT_TRANSACTION            160808
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-03 13:00:13.6550 GMT
MON$PAGES                       105434
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                        {C35CB3E9-F2A4-4644-A58F-07BD688615DF}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             469
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    Tue Nov  3 16:51:14 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'

03.11.26 16:52:05. 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-03 16:52:06 No severe PSQL-related problems occured
03.11.26 16:52:07. End of report.