Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 08.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 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 1d
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 1623416 kB
MemAvailable 7275844 kB
Buffers 91676 kB
Cached 5647152 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-08 10:50:52
DTS_END                         2026-11-08 10:50:52.9860
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/57402
TRN_ID                          185743
ATT_ID                          391
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: 11360.56 1103 568028
customer order: creation 547.80 55 27390
customer order: refuse 44.26 51 2213
order to supplier: creation 141.02 230 7051
order to supplier: removal 10.72 8340 536
invoice (draft): creation 139.36 395 6968
invoice (draft): removal 97.10 152 4855
invoice accept: apply 117.72 1576 5886
invoice accept: cancel 80.12 219 4006
customer reserve: creation 5444.92 29 272246
customer reserve: removal 3913.12 16 195656
realization accept: apply 259.48 44 12974
realization accept: cancel 144.66 21 7233
payment from customer: creation 180.14 39 9007
payment from customer: removal 16.46 19 823
payment to supplier: creation 147.84 34 7392
payment to supplier: removal 10.36 20 518
service: total inventory turnovers 18.42 1790 921
service: total monetary turnovers 42.90 14 2145
service: aggregate perf. data 4.12 1673 206
service: refresh index statistics 0.04 7340 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-11-2026 10:51:14 to 08-11-2026 10:51:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7628
TEST_TIME 2 9119
TEST_TIME 3 10074
TEST_TIME 4 10413
TEST_TIME 5 10361
TEST_TIME 6 10765
TEST_TIME 7 10955
TEST_TIME 8 11083
TEST_TIME 9 11365
TEST_TIME 10 11416
TEST_TIME 11 11439
TEST_TIME 12 11532
TEST_TIME 13 11585
TEST_TIME 14 11611
TEST_TIME 15 11734
TEST_TIME 16 11870
TEST_TIME 17 11848
TEST_TIME 18 11943
TEST_TIME 19 11932
TEST_TIME 20 12024
TEST_TIME 21 12117
TEST_TIME 22 12073
TEST_TIME 23 12049
TEST_TIME 24 12118
TEST_TIME 25 12103
TEST_TIME 26 12056
TEST_TIME 27 12115
TEST_TIME 28 12050
TEST_TIME 29 12025
TEST_TIME 30 12044
TEST_TIME 31 11972
TEST_TIME 32 11899
TEST_TIME 33 11911
TEST_TIME 34 11933
TEST_TIME 35 11815
TEST_TIME 36 11801
TEST_TIME 37 11762
TEST_TIME 38 11775
TEST_TIME 39 11759
TEST_TIME 40 11681
TEST_TIME 41 11686
TEST_TIME 42 11658
TEST_TIME 43 11581
TEST_TIME 44 11544
TEST_TIME 45 11509
TEST_TIME 46 11476
TEST_TIME 47 11428
TEST_TIME 48 11443
TEST_TIME 49 11444
TEST_TIME 50 11361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-11-2026 10:51:16 to 08-11-2026 10:51:19.

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 840179 840179 0 0.00 0 1831 2 0 0
doc_list_biud 840179 840179 0 0.00 0 3712 6 0 0
sp_add_invoice_to_stock 5886 5886 0 0.00 7 16558 1577 0 0
sp_cancel_adding_invoice 4006 4006 0 0.00 3 8855 219 0 0
sp_cancel_client_order 2213 2213 0 0.00 3 1820 52 0 0
sp_cancel_customer_reserve 195656 195656 0 0.00 1 3714 16 0 0
sp_cancel_pay_from_customer 823 823 0 0.00 2 423 19 0 0
sp_cancel_pay_to_supplier 518 518 0 0.00 2 609 20 0 0
sp_cancel_supplier_invoice 4855 4855 0 0.00 1 1812 153 0 0
sp_cancel_supplier_order 536 536 0 0.00 7 47777 8341 0 0
sp_cancel_write_off 7233 7233 0 0.00 1 1471 22 0 0
sp_client_order 27390 27390 0 0.00 4 4131 55 0 0
sp_customer_reserve 272246 272246 0 0.00 0 3908 29 0 0
sp_fill_shopping_cart 41409 41409 0 0.00 1 2691 23 0 0
sp_fill_shopping_cart_clo_res 272246 272246 0 0.00 0 1663 2 0 0
sp_get_clo_for_invoice 5886 5886 0 0.00 0 1420 34 0 0
sp_kill_cost_storno 12580 12580 0 0.00 0 834 11 0 0
sp_kill_qstorno_ret_qs2qd 403936 403936 0 0.00 0 3705 8 0 0
sp_kill_qty_storno 233359 233359 0 0.00 0 3712 19 0 0
sp_lock_selected_doc 26037 26037 0 0.00 0 615 2 0 0
sp_make_cost_storno 35259 35259 0 0.00 0 1069 8 0 0
sp_multiply_rows_for_pdistr 35259 35259 0 0.00 0 1037 13 0 0
sp_multiply_rows_for_qdistr 27390 27390 0 0.00 0 2076 21 0 0
sp_pay_from_customer 9007 9007 0 0.00 3 1408 39 0 0
sp_pay_to_supplier 7392 7392 0 0.00 3 2067 34 0 0
sp_payment_common 16399 16399 0 0.00 1 659 7 0 0
sp_qd_handle_on_cancel_clo 2213 2213 0 0.00 0 1743 36 0 0
sp_qd_handle_on_invoice_upd_sts 9892 9892 0 0.00 0 2334 70 0 0
sp_qd_handle_on_reserve_upd_sts 12974 12974 0 0.00 0 1725 14 0 0
sp_reserve_write_off 12974 12974 0 0.00 3 1909 44 0 0
sp_supplier_invoice 6968 6968 0 0.00 6 5349 395 0 0
sp_supplier_order 7051 7051 0 0.00 4 5634 231 0 0
srv_aggregate_perf_data 206 206 0 0.00 109 10808 1673 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 971 327 0 0
srv_find_qd_qs_mism 527899 527899 0 0.00 0 1826 1 0 0
srv_make_invnt_saldo 921 921 0 0.00 1 7068 1790 0 0
srv_make_money_saldo 2145 2145 0 0.00 0 245 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 360 14321 7341 0 0
v_add_invoice_to_stock 11772 11772 0 0.00 0 606 2 0 0
v_all_customers 42022 42022 0 0.00 0 70 1 0 0
v_all_suppliers 34278 34278 0 0.00 0 66 1 0 0
v_all_wares 54780 54780 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 1014 1014 0 0.00 0 441 3 0 0
v_cancel_client_order 4426 4426 0 0.00 0 520 2 0 0
v_cancel_customer_prepayment 1646 1646 0 0.00 0 419 2 0 0
v_cancel_customer_reserve 1726 1726 0 0.00 0 131 2 0 0
v_cancel_payment_to_supplier 1036 1036 0 0.00 0 507 2 0 0
v_cancel_supplier_invoice 884 884 0 0.00 0 196 3 0 0
v_cancel_supplier_order 1072 1072 0 0.00 0 595 2 0 0
v_cancel_write_off 2550 2550 0 0.00 0 760 2 0 0
v_max_id_clo_ord 7051 7051 0 0.00 0 41 1 0 0
v_max_id_clo_res 1341 1341 0 0.00 0 830 2 0 0
v_max_id_ord_sup 6968 6968 0 0.00 0 1448 3 0 0
v_max_non_paid_invoice 4272 4272 0 0.00 0 48 1 0 0
v_max_non_paid_realizn 8601 8601 0 0.00 0 134 1 0 0
v_min_id_clo_ord 7051 7051 0 0.00 0 418 3 0 0
v_min_id_clo_res 1341 1341 0 0.00 0 1032 6 0 0
v_min_id_ord_sup 6968 6968 0 0.00 0 1644 10 0 0
v_min_non_paid_invoice 7392 7392 0 0.00 0 579 3 0 0
v_min_non_paid_realizn 9007 9007 0 0.00 0 461 3 0 0
v_our_firm 13570 13570 0 0.00 0 51 1 0 0
v_reserve_write_off 25948 25948 0 0.00 0 969 2 0 0
x_lock_depdocs_on_canc_invoice 8419 8419 0 0.00 0 2260 10 0 0
x_lock_depdocs_on_canc_sup_ord 536 536 0 0.00 0 169 10 0 0
x_make_qstorno_1000_1200 7051 7051 0 0.00 1 5532 172 0 0
x_make_qstorno_1200_2000 6968 6968 0 0.00 1 5229 339 0 0
x_make_qstorno_2100_3300 272246 272246 0 0.00 0 3896 25 0 0

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

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:00:56 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
10:01:57 426 2147483648 2550568032 2632482816 225021760 9.484 20 9 18 0 227370448 1233216 1115472
10:02:57 334 2147483648 2547863872 2629943296 220381888 9.307 20 10 16 0 222633744 1069536 1182320
10:03:58 435 2147483648 2543207936 2624978944 212563216 9.006 20 11 22 0 218227568 3304928 2359424
10:04:59 176 2147483648 2550151488 2633011200 221144544 9.336 20 13 26 0 224945456 1602896 2198016
10:05:59 243 2147483648 2544872112 2624638976 212760400 9.014 20 10 21 0 219603072 4852912 1989760
10:07:00 347 2147483648 2534025264 2613280768 196015840 8.364 19 9 17 0 203560608 5953888 1590880
10:08:01 222 2147483648 2544740512 2626473984 215425632 9.116 20 11 23 0 223044768 6085984 1533152
10:09:01 411 2147483648 2552678096 2635825152 217682144 9.203 20 11 22 0 226595792 6876384 2037264
10:10:02 138 2147483648 2540227680 2617991168 207126928 8.796 20 12 23 0 212661968 3938768 1596272
10:11:03 169 2147483648 2550674064 2633777152 219381808 9.268 20 4 8 0 226353680 5751296 1220576
10:12:03 549 2147483648 2542896128 2621603840 205631088 8.738 19 17 35 0 215924480 7425840 2867552
10:13:04 397 2147483648 2549182400 2633756672 215555248 9.121 20 8 16 0 223536064 6721232 1259584
10:14:05 291 2147483648 2547538000 2632589312 216768960 9.168 20 8 16 0 223414432 5033056 1612416
10:15:06 514 2147483648 2552029536 2632966144 212539712 9.005 20 10 19 0 226296336 11279232 2477392
10:16:08 293 2147483648 2567011424 2649395200 219657200 9.279 20 12 24 0 239295952 17643328 1995424
10:17:10 286 2147483648 2550030368 2632454144 213396064 9.038 20 8 16 1 223300592 8241968 1662560
10:18:10 117 2147483648 2548787024 2631712768 213885424 9.057 20 7 14 0 223470496 8099616 1485456
10:19:11 191 2147483648 2549462416 2630361088 212590656 9.007 20 14 26 0 222463616 7811152 2061808
10:20:11 131 2147483648 2557354496 2640187392 214167952 9.068 20 11 23 1 231278320 15263664 1846704
10:21:12 147 2147483648 2559422624 2644336640 215887120 9.134 20 7 14 0 233233808 16257680 1089008
10:22:12 116 2147483648 2551506240 2638020608 221803072 9.361 20 8 16 0 226148528 2268656 2076800
10:23:13 179 2147483648 2549473344 2635010048 218134800 9.221 20 8 16 0 223948608 4564448 1249360
10:24:14 367 2147483648 2555672640 2637701120 215192880 9.108 20 9 18 1 230084992 13035584 1856528
10:25:15 147 2147483648 2558367344 2642272256 220044096 9.294 20 10 20 0 232666272 10643904 1978272
10:26:15 170 2147483648 2551013648 2634760192 216380784 9.153 20 10 20 0 224771072 6655792 1734496
10:27:16 644 2147483648 2552640000 2634031104 215203072 9.108 20 11 22 0 225994864 8302288 2489504
10:28:17 172 2147483648 2548033456 2629926912 212848176 9.017 20 14 29 0 221238976 5924816 2465984
10:29:17 406 2147483648 2553982864 2636730368 215618464 9.124 20 11 22 0 226950704 9620000 1712240
10:30:18 279 2147483648 2561635968 2645819392 221190816 9.338 20 8 16 0 235775760 13404000 1180944
10:31:19 464 2147483648 2546117552 2628366336 214867760 9.095 20 10 16 0 219126784 2480576 1778448
10:32:20 134 2147483648 2545916336 2631254016 215528800 9.120 20 7 14 0 220247296 3596320 1122176
10:33:20 971 2147483648 2554795136 2636541952 216563008 9.160 20 12 24 0 229060976 10145232 2352736
10:34:21 620 2147483648 2561343264 2644635648 218517952 9.235 20 6 12 0 233232528 13705504 1009072
10:35:22 542 2147483648 2548191984 2635280384 210352480 8.921 20 15 30 0 222606992 9589072 2665440
10:36:23 667 2147483648 2559937904 2643603456 215642896 9.125 20 10 20 0 233268736 15332544 2293296
10:37:25 225 2147483648 2561366736 2644410368 214849664 9.094 20 11 22 0 234254128 17352656 2051808
10:38:26 171 2147483648 2548575440 2638348288 213230864 9.032 20 6 13 0 221909440 7591296 1087280
10:39:27 212 2147483648 2542494464 2626408448 212421472 9.001 20 8 16 0 216269472 2439392 1408608
10:40:27 171 2147483648 2530959200 2611961856 199390816 8.496 19 13 26 2 206201312 4482368 2328128
10:41:28 358 2147483648 2557606112 2643595264 211206176 8.954 20 8 16 0 229774736 17090736 1477824
10:42:31 247 2147483648 2562347776 2656378880 216354768 9.152 20 10 20 0 235749648 17489040 1905840
10:43:32 226 2147483648 2551144640 2636324864 219485008 9.272 20 9 18 0 224138544 3451424 1202112
10:44:33 296 2147483648 2546560608 2630881280 212319488 8.997 20 13 24 1 220346768 5268320 2758960
10:45:34 740 2147483648 2544308608 2627235840 211395696 8.961 20 8 16 0 217762384 5283408 1083280
10:46:35 335 2147483648 2556282448 2639380480 212138656 8.990 20 6 12 0 229901952 16516528 1246768
10:47:36 260 2147483648 2548266096 2629025792 211992064 8.984 20 14 29 0 220882416 6410896 2479456
10:48:36 616 2147483648 2552462224 2635386880 218989840 9.253 20 11 22 1 226527488 5673520 1864128
10:49:37 258 2147483648 2552673504 2633908224 211506064 8.965 20 14 26 0 224651536 10977984 2167488
10:50:38 245 2147483648 2549317840 2632216576 211555360 8.967 20 12 24 0 222606464 8951760 2099344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:17, from 08-11-2026 10:51:26 to 08-11-2026 10:51:43.

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 08-11-2026 10:51:43 to 08-11-2026 10:51:44.

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          185755
MON$OLDEST_ACTIVE               186001
MON$OLDEST_SNAPSHOT             186001
MON$NEXT_TRANSACTION            186001
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-08 07:00:11.0870 GMT
MON$PAGES                       119034
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                        {ED831483-6D57-4F8F-A155-6A09B22D6F75}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             512
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    Sun Nov  8 10:50:54 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'

08.11.26 10:51:45. 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-08 10:51:46 No severe PSQL-related problems occured
08.11.26 10:51:47. End of report.