Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 15.11.2026 09:50
Common Performance Final Results
  1. Hardware and OS info
  2. Firebird configuration
  3. Test configuration
  4. Test Finish details
  5. Test workload details
  6. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2w 1d
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 2114916 kB
MemAvailable 7212564 kB
Buffers 79372 kB
Cached 5145608 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
AllowUpdateOverwrite true true
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, gssauth, Legacy_Auth Srp256, Srp, gssauth, Legacy_Auth
AuthServer Srp256 Srp256
BlobTempSpace 0 0
BugcheckAbort true false [ X ] firebird.conf
ClientBatchBuffer 131072 131072
ConnectionIdleTimeout 0 0
ConnectionTimeout 180 180
CpuAffinityMask 0 0
DataTypeCompatibility
DatabaseAccess Full Full
DatabaseGrowthIncrement 134217728 134217728
DeadlockTimeout 10 10
DefaultDbCachePages 262144 2048 [ X ] firebird.conf
DefaultProfilerPlugin Default_Profiler Default_Profiler
DefaultTimeZone
DisableLogNetIOErrors true true
DummyPacketInterval 0 0
EnableMonDebug false false
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
FillMonCallStack true true
FillMonCompiledStatements true true
FillMonStatements true true
GCPolicy combined combined
GuardianOption 1 1
HQbirdVersionString true true
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_hq50SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LegacyIntForCount false false
LegacyTimeLiterals false false
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
MaxStatementCacheSize 2097152 2097152
MaxTempBlobs 1000 1000
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
MinDbCachePages 30000 30000
MonitoringPlugin [empty] [empty]
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OuterJoinConversion true true
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
RemoteServiceName gds_db gds_db
RemoteServicePort 30500 0 [ X ] firebird.conf
SecurityDatabase /opt/hq50/security5.fdb /opt/hq50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
SqlSubstDirectory subst subst
StatementTimeout 0 0
SubQueryConversion 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
TraceAll false false
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
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-hq50.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-hq50.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_50.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq50/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=blue
param=html_chart_color_memo_att, val=blue
param=html_chart_color_memo_stm, val=blue
param=html_chart_color_memo_trn, val=blue
param=html_chart_color_perf_score, val=blue
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=30500
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-hq50-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-hq50
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-15 09:50:39
DTS_END                         2026-11-15 09:50:39.3830
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/38008
TRN_ID                          219172
ATT_ID                          460
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: 14293.06 1019 714653
customer order: creation 647.12 42 32356
customer order: refuse 51.98 51 2599
order to supplier: creation 164.52 194 8226
order to supplier: removal 11.92 8528 596
invoice (draft): creation 164.78 343 8239
invoice (draft): removal 118.04 129 5902
invoice accept: apply 142.94 1365 7147
invoice accept: cancel 98.82 192 4941
customer reserve: creation 6861.82 24 343091
customer reserve: removal 5063.08 14 253154
realization accept: apply 301.08 32 15054
realization accept: cancel 163.10 18 8155
payment from customer: creation 214.38 31 10719
payment from customer: removal 20.74 16 1037
payment to supplier: creation 177.16 25 8858
payment to supplier: removal 12.62 16 631
service: total inventory turnovers 21.14 1602 1057
service: total monetary turnovers 53.12 13 2656
service: aggregate perf. data 4.66 1697 233
service: refresh index statistics 0.04 6045 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 15-11-2026 09:50:54 to 15-11-2026 09:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10421
TEST_TIME 2 11478
TEST_TIME 3 11454
TEST_TIME 4 12018
TEST_TIME 5 12168
TEST_TIME 6 12452
TEST_TIME 7 12635
TEST_TIME 8 12816
TEST_TIME 9 12955
TEST_TIME 10 12814
TEST_TIME 11 12961
TEST_TIME 12 13079
TEST_TIME 13 13103
TEST_TIME 14 13136
TEST_TIME 15 13187
TEST_TIME 16 13287
TEST_TIME 17 13353
TEST_TIME 18 13277
TEST_TIME 19 13374
TEST_TIME 20 13251
TEST_TIME 21 13363
TEST_TIME 22 13458
TEST_TIME 23 13428
TEST_TIME 24 13448
TEST_TIME 25 13343
TEST_TIME 26 13461
TEST_TIME 27 13423
TEST_TIME 28 13432
TEST_TIME 29 13405
TEST_TIME 30 13337
TEST_TIME 31 13399
TEST_TIME 32 13395
TEST_TIME 33 13533
TEST_TIME 34 13532
TEST_TIME 35 13548
TEST_TIME 36 13654
TEST_TIME 37 13695
TEST_TIME 38 13750
TEST_TIME 39 13752
TEST_TIME 40 13868
TEST_TIME 41 13988
TEST_TIME 42 14009
TEST_TIME 43 14014
TEST_TIME 44 14134
TEST_TIME 45 14160
TEST_TIME 46 14184
TEST_TIME 47 14219
TEST_TIME 48 14286
TEST_TIME 49 14357
TEST_TIME 50 14293

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 15-11-2026 09:50:56 to 15-11-2026 09:50:58.

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 1054639 1054639 0 0.00 0 1580 2 0 0
doc_list_biud 1054639 1054639 0 0.00 0 2619 5 0 0
sp_add_invoice_to_stock 7147 7147 0 0.00 4 16187 1365 0 0
sp_cancel_adding_invoice 4941 4941 0 0.00 2 5174 192 0 0
sp_cancel_client_order 2599 2599 0 0.00 2 788 52 0 0
sp_cancel_customer_reserve 253154 253154 0 0.00 1 2174 15 0 0
sp_cancel_pay_from_customer 1037 1037 0 0.00 1 248 17 0 0
sp_cancel_pay_to_supplier 631 631 0 0.00 2 317 16 0 0
sp_cancel_supplier_invoice 5902 5902 0 0.00 1 1831 129 0 0
sp_cancel_supplier_order 596 596 0 0.00 6 51114 8529 0 0
sp_cancel_write_off 8155 8155 0 0.00 1 1043 18 0 0
sp_client_order 32356 32356 0 0.00 2 3137 43 0 0
sp_customer_reserve 343091 343091 0 0.00 0 3027 24 0 0
sp_fill_shopping_cart 48821 48821 0 0.00 0 3069 18 0 0
sp_fill_shopping_cart_clo_res 343091 343091 0 0.00 0 1410 2 0 0
sp_get_clo_for_invoice 7147 7147 0 0.00 0 1496 35 0 0
sp_kill_cost_storno 14764 14764 0 0.00 0 854 8 0 0
sp_kill_qstorno_ret_qs2qd 520961 520961 0 0.00 0 2618 7 0 0
sp_kill_qty_storno 297548 297548 0 0.00 0 2619 17 0 0
sp_lock_selected_doc 30703 30703 0 0.00 0 1234 1 0 0
sp_make_cost_storno 41778 41778 0 0.00 0 1002 6 0 0
sp_multiply_rows_for_pdistr 41778 41778 0 0.00 0 987 9 0 0
sp_multiply_rows_for_qdistr 32356 32356 0 0.00 0 1397 17 0 0
sp_pay_from_customer 10719 10719 0 0.00 2 1861 31 0 0
sp_pay_to_supplier 8858 8858 0 0.00 2 1496 26 0 0
sp_payment_common 19577 19577 0 0.00 0 1007 6 0 0
sp_qd_handle_on_cancel_clo 2599 2599 0 0.00 0 773 37 0 0
sp_qd_handle_on_invoice_upd_sts 12088 12088 0 0.00 0 2152 67 0 0
sp_qd_handle_on_reserve_upd_sts 15054 15054 0 0.00 0 1129 10 0 0
sp_reserve_write_off 15054 15054 0 0.00 2 2611 33 0 0
sp_supplier_invoice 8239 8239 0 0.00 4 7632 344 0 0
sp_supplier_order 8226 8226 0 0.00 3 3422 195 0 0
srv_aggregate_perf_data 233 233 0 0.00 80 10003 1697 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 981 345 0 0
srv_find_qd_qs_mism 665471 665471 0 0.00 0 1479 1 0 0
srv_make_invnt_saldo 1057 1057 0 0.00 4 5065 1603 0 0
srv_make_money_saldo 2656 2656 0 0.00 0 386 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 602 11488 6045 0 0
v_add_invoice_to_stock 14294 14294 0 0.00 0 1140 2 0 0
v_all_customers 49374 49374 0 0.00 0 129 0 0 0
v_all_suppliers 40410 40410 0 0.00 0 39 0 0 0
v_all_wares 64712 64712 0 0.00 0 75 0 0 0
v_cancel_adding_invoice 1212 1212 0 0.00 0 166 2 0 0
v_cancel_client_order 5198 5198 0 0.00 0 315 1 0 0
v_cancel_customer_prepayment 2074 2074 0 0.00 0 240 2 0 0
v_cancel_customer_reserve 2062 2062 0 0.00 0 209 2 0 0
v_cancel_payment_to_supplier 1262 1262 0 0.00 0 67 1 0 0
v_cancel_supplier_invoice 1126 1126 0 0.00 0 131 3 0 0
v_cancel_supplier_order 1192 1192 0 0.00 0 80 2 0 0
v_cancel_write_off 2878 2878 0 0.00 0 468 2 0 0
v_max_id_clo_ord 8226 8226 0 0.00 0 249 1 0 0
v_max_id_clo_res 1506 1506 0 0.00 0 412 2 0 0
v_max_id_ord_sup 8239 8239 0 0.00 0 1275 2 0 0
v_max_non_paid_invoice 5118 5118 0 0.00 0 172 1 0 0
v_max_non_paid_realizn 10359 10359 0 0.00 0 54 1 0 0
v_min_id_clo_ord 8226 8226 0 0.00 0 522 2 0 0
v_min_id_clo_res 1506 1506 0 0.00 0 552 3 0 0
v_min_id_ord_sup 8239 8239 0 0.00 0 1756 5 0 0
v_min_non_paid_invoice 8858 8858 0 0.00 0 903 2 0 0
v_min_non_paid_realizn 10719 10719 0 0.00 0 933 2 0 0
v_our_firm 16058 16058 0 0.00 0 48 1 0 0
v_reserve_write_off 30108 30108 0 0.00 0 1099 1 0 0
x_lock_depdocs_on_canc_invoice 10280 10280 0 0.00 0 989 9 0 0
x_lock_depdocs_on_canc_sup_ord 596 596 0 0.00 0 362 11 0 0
x_make_qstorno_1000_1200 8226 8226 0 0.00 1 3386 145 0 0
x_make_qstorno_1200_2000 8239 8239 0 0.00 1 7614 299 0 0
x_make_qstorno_2100_3300 343091 343091 0 0.00 0 3025 21 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 15-11-2026 09:50:58 to 15-11-2026 09:51:01.

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
09:00:43 5 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
09:01:43 223 2147483648 2497753056 2740224000 240422304 10.068 19 8 16 0 242471840 1731088 318448
09:02:44 213 2147483648 2526570704 2779893760 270229472 11.177 20 13 26 1 272996288 2244928 521888
09:03:45 245 2147483648 2526991328 2772680704 270721696 11.195 20 8 16 0 273499616 2469616 308304
09:04:45 342 2147483648 2513183936 2736893952 255087216 10.617 20 10 20 0 259595360 4099632 408512
09:05:46 271 2147483648 2525607568 2767147008 258976896 10.761 20 9 18 0 268751536 9422224 352416
09:06:47 299 2147483648 2526030640 2759634944 269054608 11.133 20 12 24 1 272094816 2588640 451568
09:07:48 242 2147483648 2521189648 2752638976 258659744 10.749 20 12 24 0 266749904 7572080 518080
09:08:48 319 2147483648 2527393696 2763382784 265359360 10.997 20 8 16 0 272493728 6771776 362592
09:09:49 212 2147483648 2530498576 2773962752 269545664 11.151 20 17 35 0 275350768 5089488 715616
09:10:50 270 2147483648 2522254624 2756431872 263205168 10.918 20 11 23 0 268081856 4483104 393584
09:11:50 246 2147483648 2534661600 2782711808 273023136 11.279 20 10 20 0 280164064 6784544 356384
09:12:51 307 2147483648 2539516880 2789879808 271234672 11.213 20 13 26 1 284975536 13154336 586528
09:13:51 245 2147483648 2530526528 2775236608 272101568 11.245 20 7 14 0 275695376 3357488 236320
09:14:52 464 2147483648 2530110160 2772910080 268903376 11.128 20 13 26 0 276110416 6628464 578576
09:15:53 276 2147483648 2531060912 2764390400 263373968 10.924 20 10 19 0 276165584 12459296 332320
09:16:53 303 2147483648 2530161824 2774691840 272344448 11.254 20 9 18 0 278281120 5427712 508960
09:17:54 282 2147483648 2531293520 2784567296 272717152 11.268 20 13 26 0 275899328 2715120 467056
09:18:55 276 2147483648 2541549568 2787819520 273421488 11.294 20 11 22 0 287094464 13235904 437072
09:19:56 314 2147483648 2533266336 2782146560 275101616 11.355 20 11 22 0 277795328 2219424 474288
09:20:56 317 2147483648 2542331072 2786074624 272229104 11.250 20 11 21 0 288184336 15478768 476464
09:21:57 261 2147483648 2534169168 2764165120 268534416 11.114 20 10 20 0 278583632 9651424 397792
09:22:57 278 2147483648 2523560112 2761019392 263544048 10.930 19 11 22 0 267596800 3654064 398688
09:23:58 270 2147483648 2537148208 2778484736 267513296 11.077 20 6 12 0 280311200 12566704 231200
09:24:58 465 2147483648 2535093808 2776891392 268385744 11.109 20 11 22 1 278827152 9885232 556176
09:25:59 380 2147483648 2554139152 2806067200 276492800 11.406 20 14 27 0 298585888 21343664 749424
09:27:00 287 2147483648 2515583920 2742087680 247970240 10.351 18 13 26 0 258772640 10271840 530560
09:28:00 361 2147483648 2539198880 2784366592 272178992 11.248 20 11 22 0 284676480 12092736 404752
09:29:01 550 2147483648 2544300208 2786209792 272598544 11.264 20 9 18 1 287973904 15005216 370144
09:30:02 260 2147483648 2514495072 2743955456 246662048 10.302 20 12 24 0 258871280 11598672 610560
09:31:02 171 2147483648 2537771184 2768584704 268024320 11.095 20 11 20 0 282139904 13722128 393456
09:32:03 488 2147483648 2548973072 2789224448 271386448 11.219 20 12 24 0 293408064 21428576 593040
09:33:04 402 2147483648 2558824656 2808942592 271580768 11.226 20 12 24 2 303656928 31470208 605952
09:34:05 314 2147483648 2521404064 2753409024 257213824 10.696 20 8 16 0 265777440 8254608 309008
09:35:05 310 2147483648 2534514880 2779758592 265851856 11.015 20 13 26 1 279410368 13038448 520064
09:36:06 454 2147483648 2536971104 2784567296 268881280 11.127 20 11 21 0 281004880 11646528 477072
09:37:07 817 2147483648 2529033328 2770235392 264818752 10.977 20 8 16 0 271954464 6826224 309488
09:38:08 321 2147483648 2530699152 2771009536 263329008 10.922 20 11 22 0 275185712 11469408 387296
09:39:10 283 2147483648 2523831728 2759352320 259689504 10.788 20 12 25 0 266973056 6815904 467648
09:40:10 444 2147483648 2521871952 2751721472 248900800 10.386 19 13 25 0 266774128 17345936 527392
09:41:12 460 2147483648 2552413408 2792513536 267666000 11.082 20 12 23 0 295925328 27756496 502832
09:42:13 981 2147483648 2521907456 2757283840 260444080 10.816 20 4 8 0 267442272 6874480 123712
09:43:14 295 2147483648 2538682304 2795196416 268924192 11.129 20 9 18 0 282843088 13545936 372960
09:44:14 427 2147483648 2525640592 2759983104 259939952 10.797 20 12 24 1 269255696 8821312 494432
09:45:15 238 2147483648 2538089008 2775638016 263435696 10.926 20 14 28 0 279453376 15435856 581824
09:46:15 282 2147483648 2539651248 2782031872 265268944 10.994 20 6 12 0 285250800 19697008 284848
09:47:16 480 2147483648 2533541152 2776502272 264837792 10.978 20 15 30 0 277589632 12086384 665456
09:48:17 303 2147483648 2520848672 2752458752 254559552 10.597 20 11 21 0 262036048 7038624 437872
09:49:17 253 2147483648 2554158752 2800410624 269423504 11.147 20 14 28 1 298704544 28607408 673632
09:50:18 524 2147483648 2541636048 2787860480 266575904 11.042 20 10 19 1 283902816 16927200 399712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 15-11-2026 09:51:02 to 15-11-2026 09:51:13.

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 15-11-2026 09:51:13 to 15-11-2026 09:51:14.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          219316
MON$OLDEST_ACTIVE               219317
MON$OLDEST_SNAPSHOT             219317
MON$NEXT_TRANSACTION            219317
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-15 06:00:10.1970 GMT
MON$PAGES                       182308
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                        {BF5F96B1-94D2-4CD8-A0BF-4522D6FE9D1B}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             580
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1917 Firebird 5.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1917 Firebird 5.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1917 Firebird 5.0 HQbird/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1917 Firebird 5.0 HQbird/tcp (test-0)/P19:C"
on disk structure version 13.1

Database statistics


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

15.11.26 09:51:14. There are 3 logs in /var/tmp/logs.oltp-hq50 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-15 09:51:15 No severe PSQL-related problems occured
15.11.26 09:51:15. End of report.