Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 10: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 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 3d
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 1826556 kB
MemAvailable 7306584 kB
Buffers 79680 kB
Cached 5524276 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-10 10:50:55
DTS_END                         2026-11-10 10:50:55.7880
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/55544
TRN_ID                          204693
ATT_ID                          423
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: 13208.72 935 660436
customer order: creation 605.72 50 30286
customer order: refuse 48.20 51 2410
order to supplier: creation 154.18 222 7709
order to supplier: removal 11.44 8390 572
invoice (draft): creation 153.20 373 7660
invoice (draft): removal 107.22 142 5361
invoice accept: apply 130.64 1532 6532
invoice accept: cancel 87.82 217 4391
customer reserve: creation 6441.12 25 322056
customer reserve: removal 4555.24 15 227762
realization accept: apply 284.14 42 14207
realization accept: cancel 158.28 21 7914
payment from customer: creation 203.02 42 10151
payment from customer: removal 19.18 22 959
payment to supplier: creation 163.72 33 8186
payment to supplier: removal 10.98 20 549
service: total inventory turnovers 20.64 1586 1032
service: total monetary turnovers 49.02 14 2451
service: aggregate perf. data 4.92 1650 246
service: refresh index statistics 0.04 4249 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 10-11-2026 10:51:12 to 10-11-2026 10:51:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6630
TEST_TIME 2 8066
TEST_TIME 3 8708
TEST_TIME 4 9398
TEST_TIME 5 9619
TEST_TIME 6 9995
TEST_TIME 7 10223
TEST_TIME 8 10410
TEST_TIME 9 10557
TEST_TIME 10 10729
TEST_TIME 11 11109
TEST_TIME 12 11107
TEST_TIME 13 11306
TEST_TIME 14 11411
TEST_TIME 15 11392
TEST_TIME 16 11615
TEST_TIME 17 11627
TEST_TIME 18 11801
TEST_TIME 19 11880
TEST_TIME 20 11911
TEST_TIME 21 12030
TEST_TIME 22 12099
TEST_TIME 23 12114
TEST_TIME 24 12183
TEST_TIME 25 12324
TEST_TIME 26 12359
TEST_TIME 27 12378
TEST_TIME 28 12415
TEST_TIME 29 12478
TEST_TIME 30 12458
TEST_TIME 31 12487
TEST_TIME 32 12504
TEST_TIME 33 12612
TEST_TIME 34 12652
TEST_TIME 35 12676
TEST_TIME 36 12673
TEST_TIME 37 12792
TEST_TIME 38 12844
TEST_TIME 39 12958
TEST_TIME 40 13036
TEST_TIME 41 13022
TEST_TIME 42 12992
TEST_TIME 43 13062
TEST_TIME 44 13173
TEST_TIME 45 13173
TEST_TIME 46 13165
TEST_TIME 47 13178
TEST_TIME 48 13215
TEST_TIME 49 13213
TEST_TIME 50 13209

Performance per minute, chart


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

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 978818 978818 0 0.00 0 1215 2 0 0
doc_list_biud 978818 978818 0 0.00 0 2215 5 0 0
sp_add_invoice_to_stock 6532 6532 0 0.00 15 12620 1532 0 0
sp_cancel_adding_invoice 4391 4391 0 0.00 2 4470 217 0 0
sp_cancel_client_order 2410 2410 0 0.00 3 1433 51 0 0
sp_cancel_customer_reserve 227762 227762 0 0.00 1 2011 15 0 0
sp_cancel_pay_from_customer 959 959 0 0.00 2 857 23 0 0
sp_cancel_pay_to_supplier 549 549 0 0.00 2 317 21 0 0
sp_cancel_supplier_invoice 5361 5361 0 0.00 1 1938 142 0 0
sp_cancel_supplier_order 572 572 0 0.00 9 46014 8390 0 0
sp_cancel_write_off 7914 7914 0 0.00 1 1165 22 0 0
sp_client_order 30286 30286 0 0.00 4 1595 51 0 0
sp_customer_reserve 322056 322056 0 0.00 0 2105 26 0 0
sp_fill_shopping_cart 45655 45655 0 0.00 1 1836 21 0 0
sp_fill_shopping_cart_clo_res 322056 322056 0 0.00 0 1727 2 0 0
sp_get_clo_for_invoice 6532 6532 0 0.00 0 2560 35 0 0
sp_kill_cost_storno 13813 13813 0 0.00 0 1081 10 0 0
sp_kill_qstorno_ret_qs2qd 469371 469371 0 0.00 0 2001 8 0 0
sp_kill_qty_storno 269149 269149 0 0.00 0 2215 18 0 0
sp_lock_selected_doc 28685 28685 0 0.00 0 687 2 0 0
sp_make_cost_storno 39076 39076 0 0.00 0 1203 7 0 0
sp_multiply_rows_for_pdistr 39076 39076 0 0.00 0 686 11 0 0
sp_multiply_rows_for_qdistr 30286 30286 0 0.00 0 1416 19 0 0
sp_pay_from_customer 10151 10151 0 0.00 3 990 43 0 0
sp_pay_to_supplier 8186 8186 0 0.00 3 1032 34 0 0
sp_payment_common 18337 18337 0 0.00 1 1009 11 0 0
sp_qd_handle_on_cancel_clo 2410 2410 0 0.00 0 1419 34 0 0
sp_qd_handle_on_invoice_upd_sts 10923 10923 0 0.00 0 2215 73 0 0
sp_qd_handle_on_reserve_upd_sts 14207 14207 0 0.00 0 1018 12 0 0
sp_reserve_write_off 14207 14207 0 0.00 3 1209 43 0 0
sp_supplier_invoice 7660 7660 0 0.00 5 5366 374 0 0
sp_supplier_order 7709 7709 0 0.00 6 3963 222 0 0
srv_aggregate_perf_data 246 246 0 0.00 44 20568 1651 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 756 272 0 0
srv_find_qd_qs_mism 614061 614061 0 0.00 0 942 1 0 0
srv_make_invnt_saldo 1032 1032 0 0.00 1 5168 1586 0 0
srv_make_money_saldo 2451 2451 0 0.00 0 288 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 313 8185 4249 0 0
v_add_invoice_to_stock 13064 13064 0 0.00 0 563 3 0 0
v_all_customers 46614 46614 0 0.00 0 61 1 0 0
v_all_suppliers 37778 37778 0 0.00 0 68 1 0 0
v_all_wares 60572 60572 0 0.00 0 43 1 0 0
v_cancel_adding_invoice 1112 1112 0 0.00 0 274 2 0 0
v_cancel_client_order 4820 4820 0 0.00 0 502 2 0 0
v_cancel_customer_prepayment 1918 1918 0 0.00 0 364 2 0 0
v_cancel_customer_reserve 1936 1936 0 0.00 0 300 2 0 0
v_cancel_payment_to_supplier 1098 1098 0 0.00 0 266 2 0 0
v_cancel_supplier_invoice 1106 1106 0 0.00 0 272 3 0 0
v_cancel_supplier_order 1144 1144 0 0.00 0 131 2 0 0
v_cancel_write_off 2758 2758 0 0.00 0 312 2 0 0
v_max_id_clo_ord 7709 7709 0 0.00 0 72 1 0 0
v_max_id_clo_res 1438 1438 0 0.00 0 27 1 0 0
v_max_id_ord_sup 7660 7660 0 0.00 0 905 2 0 0
v_max_non_paid_invoice 4666 4666 0 0.00 0 34 2 0 0
v_max_non_paid_realizn 9752 9752 0 0.00 0 130 2 0 0
v_min_id_clo_ord 7709 7709 0 0.00 0 624 3 0 0
v_min_id_clo_res 1438 1438 0 0.00 0 634 4 0 0
v_min_id_ord_sup 7660 7660 0 0.00 0 1137 6 0 0
v_min_non_paid_invoice 8186 8186 0 0.00 0 442 4 0 0
v_min_non_paid_realizn 10151 10151 0 0.00 0 725 7 0 0
v_our_firm 14756 14756 0 0.00 0 29 1 0 0
v_reserve_write_off 28414 28414 0 0.00 0 623 2 0 0
x_lock_depdocs_on_canc_invoice 9199 9199 0 0.00 0 956 10 0 0
x_lock_depdocs_on_canc_sup_ord 572 572 0 0.00 0 98 10 0 0
x_make_qstorno_1000_1200 7709 7709 0 0.00 1 3692 165 0 0
x_make_qstorno_1200_2000 7660 7660 0 0.00 1 4721 325 0 0
x_make_qstorno_2100_3300 322056 322056 0 0.00 0 2105 22 0 0

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

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, bytes
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = size of cache for metadata, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
10:01:00 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
10:02:00 472 2147483648 2554485040 2634883072 225007504 9.484 20 12 23 0 228837744 1973632 1856608
10:03:01 282 2147483648 2551579360 2629955584 220709024 9.319 20 12 23 0 226147504 3438592 1999888
10:04:02 329 2147483648 2528579504 2604253184 199642272 8.505 20 10 20 0 202065184 1043120 1379792
10:05:02 183 2147483648 2556007456 2638835712 222998560 9.407 20 12 23 0 229966160 4840976 2126624
10:06:03 336 2147483648 2537714416 2616131584 207879536 8.825 20 12 26 0 211817264 1999104 1938624
10:07:03 211 2147483648 2546323952 2629271552 214207584 9.070 20 11 20 1 220983072 5063904 1711584
10:08:04 158 2147483648 2522073824 2599059456 195354768 8.338 19 9 19 0 197877856 1044976 1478112
10:09:06 191 2147483648 2546150224 2629074944 217166768 9.183 20 11 22 0 220802272 1444560 2190944
10:10:07 340 2147483648 2546189824 2628587520 214360096 9.075 20 7 14 0 220585408 5063728 1161584
10:11:08 397 2147483648 2562660736 2645225472 218009568 9.216 20 9 16 2 235258240 15727520 1521152
10:12:09 271 2147483648 2547122976 2629525504 213908384 9.058 20 11 22 0 219903856 4315376 1680096
10:13:10 149 2147483648 2546006480 2626408448 211025296 8.947 20 12 24 0 219885696 6475472 2384928
10:14:10 273 2147483648 2552750736 2636226560 218008320 9.216 20 9 18 0 227206656 7125408 2072928
10:15:11 243 2147483648 2544154032 2627403776 213211440 9.031 20 14 27 0 219205840 3849776 2144624
10:16:11 361 2147483648 2552956224 2635186176 217960560 9.214 20 16 35 1 227362992 6683792 2718640
10:17:12 169 2147483648 2556853824 2639417344 220025680 9.293 20 12 21 1 229747200 7974144 1747376
10:18:12 416 2147483648 2559498288 2647384064 215134064 9.105 20 9 18 0 237396208 20756384 1505760
10:19:13 177 2147483648 2554356080 2637959168 217359696 9.191 20 11 24 0 228593536 9383376 1850464
10:20:14 755 2147483648 2550453936 2632585216 216989680 9.177 20 11 23 1 223946096 5046544 1909872
10:21:15 133 2147483648 2558180944 2638073856 212292320 8.996 20 12 26 1 231428688 17108992 2027376
10:22:16 270 2147483648 2560537856 2641399808 214042304 9.063 20 14 29 0 233521136 16863600 2615232
10:23:16 229 2147483648 2553635840 2635919360 216653424 9.164 20 13 30 0 229187888 9749888 2784576
10:24:17 346 2147483648 2564011744 2645360640 214494176 9.081 20 13 25 0 237027376 20226480 2306720
10:25:17 213 2147483648 2563292688 2644996096 217601456 9.200 20 13 27 0 236232736 16105312 2525968
10:26:18 216 2147483648 2556093168 2639425536 214483808 9.080 20 14 28 0 229790208 12696400 2610000
10:27:18 217 2147483648 2556182432 2637336576 215576768 9.122 20 12 26 0 228306336 10669728 2059840
10:28:19 664 2147483648 2562399952 2645397504 217772016 9.207 20 13 28 0 235039376 14725904 2541456
10:29:20 152 2147483648 2562147648 2644320256 219775600 9.283 20 15 30 0 235357712 13252016 2330096
10:30:21 220 2147483648 2558332016 2642669568 210916000 8.943 20 10 21 0 232330144 19825200 1588944
10:31:21 160 2147483648 2545721264 2629013504 215215376 9.108 20 9 18 0 218879008 2116128 1547504
10:32:21 184 2147483648 2560759904 2645086208 216856448 9.171 20 8 16 0 234756336 16739792 1160096
10:33:22 473 2147483648 2554078912 2644987904 213312224 9.035 20 9 18 0 227807472 12757408 1737840
10:34:23 162 2147483648 2550395088 2633752576 214652096 9.087 20 10 20 0 223466240 7266016 1548128
10:35:23 210 2147483648 2547392432 2631856128 215602944 9.123 20 10 21 0 220935776 3370800 1962032
10:36:23 217 2147483648 2559082368 2642636800 217439072 9.194 20 12 25 0 231633472 12097616 2096784
10:37:24 190 2147483648 2540816224 2638532608 205777728 8.744 19 9 18 0 215432224 7884832 1769664
10:38:24 268 2147483648 2561761216 2645053440 220264864 9.302 20 11 22 0 234781856 12592160 1924832
10:39:25 403 2147483648 2541929408 2624835584 208720208 8.858 20 11 21 0 214856576 4543152 1593216
10:40:26 315 2147483648 2561477088 2643894272 213847488 9.056 20 13 26 0 231998096 15867232 2283376
10:41:27 149 2147483648 2552132128 2636050432 212298368 8.996 20 11 21 0 225052928 11191712 1562848
10:42:27 674 2147483648 2545535168 2628820992 215960992 9.137 20 10 16 0 219026288 1881008 1184288
10:43:28 129 2147483648 2552415648 2633662464 214442784 9.079 20 12 24 0 225100112 8406480 2250848
10:44:28 319 2147483648 2591715008 2673864704 220386960 9.307 20 16 33 1 264290608 41019088 2884560
10:45:29 181 2147483648 2557435712 2641719296 214534672 9.082 20 13 27 0 229845504 13130608 2180224
10:46:29 107 2147483648 2559727280 2643927040 219718880 9.281 20 11 22 0 232191344 10596464 1876000
10:47:29 155 2147483648 2558258016 2637946880 211176464 8.953 20 16 32 1 230347488 16507648 2663376
10:48:30 174 2147483648 2559859872 2641711104 214965456 9.099 20 14 28 0 232699024 14658832 3074736
10:49:30 271 2147483648 2550603808 2634997760 217943904 9.213 20 12 25 0 223669584 3808688 1916992
10:50:31 252 2147483648 2554025328 2638135296 212543840 9.005 20 11 22 0 226327104 12057776 1725488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 10-11-2026 10:51:36 to 10-11-2026 10:51:37.

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          205544
MON$OLDEST_ACTIVE               205545
MON$OLDEST_SNAPSHOT             205545
MON$NEXT_TRANSACTION            205545
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-10 07:00:11.4280 GMT
MON$PAGES                       134470
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                        {8041367B-5A23-4028-97E7-E29E883B7069}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             546
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    Tue Nov 10 10:50:57 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Tue Nov 10 10:50:57 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
:14: 
:15: test-0    Tue Nov 10 10:50:57 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:17: 
:18: 
:19: test-0    Tue Nov 10 10:50:58 2026
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:21: 
--- end of diff output ---

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

10.11.26 10:51:37. 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-10 10:51:38 No severe PSQL-related problems occured
10.11.26 10:51:39. End of report.