Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.11.2026 16: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 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 2d
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 1790976 kB
MemAvailable 7276600 kB
Buffers 77280 kB
Cached 5546136 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-09 16:50:53
DTS_END                         2026-11-09 16:50:53.2190
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/48236
TRN_ID                          209523
ATT_ID                          432
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: 13658.84 932 682942
customer order: creation 614.74 49 30737
customer order: refuse 53.22 46 2661
order to supplier: creation 159.58 210 7979
order to supplier: removal 11.44 8230 572
invoice (draft): creation 156.94 340 7847
invoice (draft): removal 111.88 133 5594
invoice accept: apply 133.64 1484 6682
invoice accept: cancel 91.82 190 4591
customer reserve: creation 6590.14 25 329507
customer reserve: removal 4796.66 14 239833
realization accept: apply 288.62 37 14431
realization accept: cancel 168.18 20 8409
payment from customer: creation 205.98 35 10299
payment from customer: removal 20.04 19 1002
payment to supplier: creation 167.90 31 8395
payment to supplier: removal 12.26 18 613
service: total inventory turnovers 20.94 1588 1047
service: total monetary turnovers 49.84 12 2492
service: aggregate perf. data 4.96 1529 248
service: refresh index statistics 0.06 4624 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8123
TEST_TIME 2 9302
TEST_TIME 3 10005
TEST_TIME 4 10487
TEST_TIME 5 10743
TEST_TIME 6 11255
TEST_TIME 7 11455
TEST_TIME 8 11609
TEST_TIME 9 11802
TEST_TIME 10 12074
TEST_TIME 11 12186
TEST_TIME 12 12391
TEST_TIME 13 12477
TEST_TIME 14 12570
TEST_TIME 15 12457
TEST_TIME 16 12522
TEST_TIME 17 12599
TEST_TIME 18 12491
TEST_TIME 19 12507
TEST_TIME 20 12458
TEST_TIME 21 12530
TEST_TIME 22 12569
TEST_TIME 23 12478
TEST_TIME 24 12585
TEST_TIME 25 12656
TEST_TIME 26 12821
TEST_TIME 27 12854
TEST_TIME 28 12852
TEST_TIME 29 12812
TEST_TIME 30 12783
TEST_TIME 31 12812
TEST_TIME 32 12860
TEST_TIME 33 12856
TEST_TIME 34 12979
TEST_TIME 35 12949
TEST_TIME 36 12999
TEST_TIME 37 13029
TEST_TIME 38 13130
TEST_TIME 39 13188
TEST_TIME 40 13171
TEST_TIME 41 13238
TEST_TIME 42 13237
TEST_TIME 43 13365
TEST_TIME 44 13452
TEST_TIME 45 13580
TEST_TIME 46 13566
TEST_TIME 47 13640
TEST_TIME 48 13699
TEST_TIME 49 13694
TEST_TIME 50 13659

Performance per minute, chart


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

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 1007598 1007598 0 0.00 0 2838 2 0 0
doc_list_biud 1007598 1007598 0 0.00 0 2949 5 0 0
sp_add_invoice_to_stock 6682 6682 0 0.00 8 14713 1485 0 0
sp_cancel_adding_invoice 4591 4591 0 0.00 3 4358 190 0 0
sp_cancel_client_order 2661 2661 0 0.00 2 1460 47 0 0
sp_cancel_customer_reserve 239833 239833 0 0.00 1 1908 14 0 0
sp_cancel_pay_from_customer 1002 1002 0 0.00 2 530 19 0 0
sp_cancel_pay_to_supplier 613 613 0 0.00 2 335 18 0 0
sp_cancel_supplier_invoice 5594 5594 0 0.00 1 2965 133 0 0
sp_cancel_supplier_order 572 572 0 0.00 7 51242 8230 0 0
sp_cancel_write_off 8409 8409 0 0.00 1 1469 20 0 0
sp_client_order 30737 30737 0 0.00 3 1863 49 0 0
sp_customer_reserve 329507 329507 0 0.00 0 3285 26 0 0
sp_fill_shopping_cart 46563 46563 0 0.00 1 2507 20 0 0
sp_fill_shopping_cart_clo_res 329507 329507 0 0.00 0 1643 2 0 0
sp_get_clo_for_invoice 6682 6682 0 0.00 0 2002 32 0 0
sp_kill_cost_storno 14615 14615 0 0.00 0 626 10 0 0
sp_kill_qstorno_ret_qs2qd 494241 494241 0 0.00 0 2948 7 0 0
sp_kill_qty_storno 282773 282773 0 0.00 0 2949 16 0 0
sp_lock_selected_doc 29524 29524 0 0.00 0 384 1 0 0
sp_make_cost_storno 39807 39807 0 0.00 0 2835 8 0 0
sp_multiply_rows_for_pdistr 39807 39807 0 0.00 0 1122 11 0 0
sp_multiply_rows_for_qdistr 30737 30737 0 0.00 0 1622 18 0 0
sp_pay_from_customer 10299 10299 0 0.00 3 2846 36 0 0
sp_pay_to_supplier 8395 8395 0 0.00 3 2808 31 0 0
sp_payment_common 18694 18694 0 0.00 1 530 7 0 0
sp_qd_handle_on_cancel_clo 2661 2661 0 0.00 0 1411 31 0 0
sp_qd_handle_on_invoice_upd_sts 11273 11273 0 0.00 0 1661 64 0 0
sp_qd_handle_on_reserve_upd_sts 14431 14431 0 0.00 0 1264 11 0 0
sp_reserve_write_off 14431 14431 0 0.00 3 1284 38 0 0
sp_supplier_invoice 7847 7847 0 0.00 4 5109 341 0 0
sp_supplier_order 7979 7979 0 0.00 5 4689 210 0 0
srv_aggregate_perf_data 248 248 0 0.00 34 6044 1530 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1957 324 0 0
srv_find_qd_qs_mism 635031 635031 0 0.00 0 1466 1 0 0
srv_make_invnt_saldo 1047 1047 0 0.00 1 5690 1588 0 0
srv_make_money_saldo 2492 2492 0 0.00 0 248 13 0 0
srv_recalc_idx_stat 3 3 0 0.00 147 8263 4624 0 0
v_add_invoice_to_stock 13364 13364 0 0.00 0 1051 2 0 0
v_all_customers 47196 47196 0 0.00 0 50 1 0 0
v_all_suppliers 38956 38956 0 0.00 0 49 1 0 0
v_all_wares 61474 61474 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 1104 1104 0 0.00 0 100 2 0 0
v_cancel_client_order 5322 5322 0 0.00 0 1167 2 0 0
v_cancel_customer_prepayment 2004 2004 0 0.00 0 102 1 0 0
v_cancel_customer_reserve 2004 2004 0 0.00 0 309 2 0 0
v_cancel_payment_to_supplier 1226 1226 0 0.00 0 154 2 0 0
v_cancel_supplier_invoice 1108 1108 0 0.00 0 547 3 0 0
v_cancel_supplier_order 1144 1144 0 0.00 0 23 1 0 0
v_cancel_write_off 2910 2910 0 0.00 0 731 2 0 0
v_max_id_clo_ord 7979 7979 0 0.00 0 89 1 0 0
v_max_id_clo_res 1456 1456 0 0.00 0 822 3 0 0
v_max_id_ord_sup 7847 7847 0 0.00 0 1007 2 0 0
v_max_non_paid_invoice 4743 4743 0 0.00 0 59 1 0 0
v_max_non_paid_realizn 9811 9811 0 0.00 0 418 1 0 0
v_min_id_clo_ord 7979 7979 0 0.00 0 612 3 0 0
v_min_id_clo_res 1456 1456 0 0.00 0 665 5 0 0
v_min_id_ord_sup 7847 7847 0 0.00 0 1702 7 0 0
v_min_non_paid_invoice 8395 8395 0 0.00 0 490 2 0 0
v_min_non_paid_realizn 10299 10299 0 0.00 0 501 2 0 0
v_our_firm 15254 15254 0 0.00 0 28 1 0 0
v_reserve_write_off 28862 28862 0 0.00 0 530 2 0 0
x_lock_depdocs_on_canc_invoice 9631 9631 0 0.00 0 867 8 0 0
x_lock_depdocs_on_canc_sup_ord 572 572 0 0.00 0 168 9 0 0
x_make_qstorno_1000_1200 7979 7979 0 0.00 1 4589 152 0 0
x_make_qstorno_1200_2000 7847 7847 0 0.00 1 5068 296 0 0
x_make_qstorno_2100_3300 329507 329507 0 0.00 0 2960 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-11-2026 16:51:15 to 09-11-2026 16:51:19.

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:00:57 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
16:01:57 279 2147483648 2555034384 2636328960 226278768 9.532 20 11 20 0 230494784 1601376 2614640
16:02:57 286 2147483648 2550029520 2628390912 220214656 9.300 20 13 25 1 224858864 2273072 2371136
16:03:58 242 2147483648 2543366048 2620145664 212718560 9.012 20 11 23 0 216847776 1840176 2289040
16:04:59 213 2147483648 2520483152 2597928960 192912064 8.242 19 9 17 0 197948608 3421888 1614656
16:05:59 328 2147483648 2548809872 2629636096 217617520 9.201 20 10 20 1 222499280 3062256 1819504
16:07:00 280 2147483648 2531717008 2610483200 202864096 8.631 19 9 16 0 207419136 3062032 1493008
16:08:00 242 2147483648 2555381664 2638745600 221041360 9.332 20 11 20 1 229890560 7221552 1627648
16:09:01 356 2147483648 2547176912 2627178496 213324992 9.036 20 14 29 0 220354816 4680144 2349680
16:10:02 209 2147483648 2547885632 2631393280 216432912 9.155 20 9 17 0 221041632 3166688 1442032
16:11:02 190 2147483648 2554603680 2635603968 216539424 9.159 20 15 30 0 228134512 9223440 2371648
16:12:03 259 2147483648 2550773184 2630836224 213227216 9.032 20 15 29 0 223445776 7805952 2412608
16:13:03 206 2147483648 2535990256 2616729600 205749696 8.743 19 9 18 0 210789776 3691088 1348992
16:14:04 142 2147483648 2543286272 2625757184 213938560 9.059 20 10 18 1 217479008 2277040 1263408
16:15:04 249 2147483648 2554888688 2638241792 220806368 9.323 20 12 24 0 229975920 6976016 2193536
16:16:05 479 2147483648 2545203088 2627915776 212455568 9.002 20 10 19 0 221516400 7295712 1765120
16:17:05 229 2147483648 2557104112 2643111936 216860320 9.172 20 13 27 0 231043184 11904016 2278848
16:18:06 267 2147483648 2557560096 2640625664 220594480 9.315 20 13 26 0 228314992 5789568 1930944
16:19:07 294 2147483648 2545745200 2627969024 205105136 8.718 19 6 12 0 216513760 10184064 1224560
16:20:07 354 2147483648 2541071936 2620772352 206015712 8.753 20 13 26 0 214004112 5903888 2084512
16:21:08 800 2147483648 2551275536 2642776064 216878016 9.172 20 5 10 0 231333840 13170064 1285760
16:22:10 346 2147483648 2549002416 2633097216 217736768 9.205 20 10 18 0 222565296 2957360 1871168
16:23:11 103 2147483648 2539768752 2623066112 211533056 8.967 20 7 12 1 214366480 1627456 1205968
16:24:11 165 2147483648 2558124016 2638376960 214985888 9.100 20 15 29 0 230914992 13542928 2386176
16:25:12 174 2147483648 2550823904 2634153984 218318256 9.228 20 10 16 0 224315600 4412128 1585216
16:26:12 182 2147483648 2560170736 2644062208 214373328 9.076 20 8 16 0 234589824 18884224 1332272
16:27:13 1956 2147483648 2553879536 2639818752 207244208 8.801 19 9 18 0 219430064 10797040 1388816
16:28:15 223 2147483648 2563074256 2647343104 220487136 9.311 20 11 22 0 236755008 14248704 2019168
16:29:15 558 2147483648 2536948528 2617745408 203750816 8.665 20 13 26 0 209777520 3730432 2296272
16:30:16 185 2147483648 2564420336 2646605824 219801504 9.284 20 15 31 0 238124432 15789680 2533248
16:31:16 138 2147483648 2556742992 2641317888 216864576 9.172 20 9 18 0 229707776 11454592 1388608
16:32:17 353 2147483648 2564428800 2650787840 218705856 9.242 20 8 15 0 237928992 18298144 924992
16:33:17 161 2147483648 2545457696 2623549440 203864176 8.670 19 13 24 0 218840656 12740320 2236160
16:34:18 602 2147483648 2558881072 2641506304 218382928 9.230 20 9 18 0 233539488 13651008 1505552
16:35:19 359 2147483648 2561353408 2645889024 219853296 9.286 20 13 25 1 235390528 13192688 2344544
16:36:20 184 2147483648 2550427824 2636513280 215558720 9.122 20 9 18 0 226060832 9176864 1325248
16:37:21 108 2147483648 2550823712 2634485760 214131456 9.067 20 11 22 0 223967424 8027440 1808528
16:38:21 357 2147483648 2570542976 2654273536 221467840 9.348 20 13 26 0 243321744 19640496 2213408
16:39:22 315 2147483648 2563571072 2650796032 220531184 9.312 20 7 14 0 237242304 15670256 1040864
16:40:23 321 2147483648 2552759664 2636259328 208994352 8.868 20 12 24 0 225598688 14566096 2038240
16:41:23 150 2147483648 2553369312 2638946304 215804736 9.131 20 9 16 0 226974912 9920352 1249824
16:42:24 178 2147483648 2553070656 2637074432 217872432 9.210 20 11 22 0 225485360 5995312 1617616
16:43:24 160 2147483648 2576049376 2658906112 216791424 9.169 20 13 26 0 247696784 28294960 2610400
16:44:25 89 2147483648 2546938240 2631737344 213743808 9.052 20 7 14 0 220344368 5469824 1130736
16:45:25 741 2147483648 2576206656 2659491840 216359680 9.152 20 12 24 0 248795408 30264832 2170896
16:46:26 726 2147483648 2533883104 2614841344 203526224 8.656 19 8 16 0 207552976 2585728 1441024
16:47:27 282 2147483648 2558414496 2645692416 212194512 8.992 20 10 20 0 231389520 17533568 1661440
16:48:28 240 2147483648 2568472128 2650976256 222178816 9.375 20 14 28 0 239801200 15131680 2490704
16:49:28 578 2147483648 2548983216 2634944512 218202352 9.223 20 11 20 0 223356176 3026128 2127696
16:50:29 149 2147483648 2556869200 2642587648 216341632 9.152 20 9 18 0 229657808 11782432 1533744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 09-11-2026 16:51:19 to 09-11-2026 16:51:33.

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 09-11-2026 16:51:33 to 09-11-2026 16:51:34.

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          209510
MON$OLDEST_ACTIVE               209753
MON$OLDEST_SNAPSHOT             209753
MON$NEXT_TRANSACTION            209753
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-09 13:00:11.7010 GMT
MON$PAGES                       142936
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                        {AF7157DE-7CC3-4F44-99DF-0DA543D93225}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             551
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    Mon Nov  9 16:50:54 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Mon Nov  9 16:50:57 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
--- end of diff output ---

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

09.11.26 16:51:35. 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-09 16:51:36 No severe PSQL-related problems occured
09.11.26 16:51:36. End of report.