Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 09.11.2026 10: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 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 2d
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 1883656 kB
MemAvailable 7259276 kB
Buffers 35560 kB
Cached 5414876 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-09 10:50:53
DTS_END                         2026-11-09 10:50:53.0580
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/34108
TRN_ID                          210962
ATT_ID                          445
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: 14027.14 937 701357
customer order: creation 627.64 50 31382
customer order: refuse 51.86 36 2593
order to supplier: creation 158.22 211 7911
order to supplier: removal 12.22 8138 611
invoice (draft): creation 157.54 355 7877
invoice (draft): removal 112.84 138 5642
invoice accept: apply 136.70 1498 6835
invoice accept: cancel 94.74 207 4737
customer reserve: creation 6773.66 25 338683
customer reserve: removal 4964.02 14 248201
realization accept: apply 290.92 37 14546
realization accept: cancel 165.30 20 8265
payment from customer: creation 208.86 40 10443
payment from customer: removal 19.58 19 979
payment to supplier: creation 163.40 33 8170
payment to supplier: removal 12.08 17 604
service: total inventory turnovers 21.24 1553 1062
service: total monetary turnovers 51.50 12 2575
service: aggregate perf. data 4.78 1778 239
service: refresh index statistics 0.04 4554 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7515
TEST_TIME 2 8982
TEST_TIME 3 9770
TEST_TIME 4 10243
TEST_TIME 5 10826
TEST_TIME 6 11184
TEST_TIME 7 11255
TEST_TIME 8 11447
TEST_TIME 9 11572
TEST_TIME 10 11630
TEST_TIME 11 11628
TEST_TIME 12 11761
TEST_TIME 13 11942
TEST_TIME 14 11961
TEST_TIME 15 12124
TEST_TIME 16 12207
TEST_TIME 17 12314
TEST_TIME 18 12417
TEST_TIME 19 12576
TEST_TIME 20 12685
TEST_TIME 21 12789
TEST_TIME 22 12761
TEST_TIME 23 12734
TEST_TIME 24 12876
TEST_TIME 25 12904
TEST_TIME 26 12842
TEST_TIME 27 12850
TEST_TIME 28 12916
TEST_TIME 29 12908
TEST_TIME 30 12931
TEST_TIME 31 13093
TEST_TIME 32 13129
TEST_TIME 33 13248
TEST_TIME 34 13274
TEST_TIME 35 13271
TEST_TIME 36 13368
TEST_TIME 37 13431
TEST_TIME 38 13494
TEST_TIME 39 13506
TEST_TIME 40 13506
TEST_TIME 41 13563
TEST_TIME 42 13642
TEST_TIME 43 13698
TEST_TIME 44 13743
TEST_TIME 45 13849
TEST_TIME 46 13916
TEST_TIME 47 13962
TEST_TIME 48 13989
TEST_TIME 49 13990
TEST_TIME 50 14027

Performance per minute, chart


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

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 1034262 1034262 0 0.00 0 1532 2 0 0
doc_list_biud 1034262 1034262 0 0.00 0 2350 5 0 0
sp_add_invoice_to_stock 6835 6835 0 0.00 9 13681 1499 0 0
sp_cancel_adding_invoice 4737 4737 0 0.00 3 5582 208 0 0
sp_cancel_client_order 2593 2593 0 0.00 3 1860 36 0 0
sp_cancel_customer_reserve 248201 248201 0 0.00 1 1596 15 0 0
sp_cancel_pay_from_customer 979 979 0 0.00 2 423 20 0 0
sp_cancel_pay_to_supplier 604 604 0 0.00 2 173 18 0 0
sp_cancel_supplier_invoice 5642 5642 0 0.00 1 2021 139 0 0
sp_cancel_supplier_order 611 611 0 0.00 6 45100 8138 0 0
sp_cancel_write_off 8265 8265 0 0.00 1 1286 21 0 0
sp_client_order 31382 31382 0 0.00 4 1734 51 0 0
sp_customer_reserve 338683 338683 0 0.00 0 3560 26 0 0
sp_fill_shopping_cart 47170 47170 0 0.00 1 1654 19 0 0
sp_fill_shopping_cart_clo_res 338683 338683 0 0.00 0 1259 2 0 0
sp_get_clo_for_invoice 6835 6835 0 0.00 0 1930 35 0 0
sp_kill_cost_storno 14585 14585 0 0.00 0 615 10 0 0
sp_kill_qstorno_ret_qs2qd 510920 510920 0 0.00 0 2350 7 0 0
sp_kill_qty_storno 291430 291430 0 0.00 0 2350 17 0 0
sp_lock_selected_doc 29755 29755 0 0.00 0 589 2 0 0
sp_make_cost_storno 39994 39994 0 0.00 0 626 7 0 0
sp_multiply_rows_for_pdistr 39994 39994 0 0.00 0 520 11 0 0
sp_multiply_rows_for_qdistr 31382 31382 0 0.00 0 1416 19 0 0
sp_pay_from_customer 10443 10443 0 0.00 3 1121 41 0 0
sp_pay_to_supplier 8170 8170 0 0.00 3 852 34 0 0
sp_payment_common 18613 18613 0 0.00 1 839 10 0 0
sp_qd_handle_on_cancel_clo 2593 2593 0 0.00 0 1840 24 0 0
sp_qd_handle_on_invoice_upd_sts 11572 11572 0 0.00 0 1869 70 0 0
sp_qd_handle_on_reserve_upd_sts 14546 14546 0 0.00 0 1583 11 0 0
sp_reserve_write_off 14546 14546 0 0.00 3 1615 38 0 0
sp_supplier_invoice 7877 7877 0 0.00 6 5624 355 0 0
sp_supplier_order 7911 7911 0 0.00 5 2219 212 0 0
srv_aggregate_perf_data 239 239 0 0.00 99 19270 1778 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 659 253 0 0
srv_find_qd_qs_mism 652748 652748 0 0.00 0 1531 1 0 0
srv_make_invnt_saldo 1062 1062 0 0.00 1 6973 1554 0 0
srv_make_money_saldo 2575 2575 0 0.00 0 200 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 151 8957 4554 0 0
v_add_invoice_to_stock 13670 13670 0 0.00 0 508 2 0 0
v_all_customers 47778 47778 0 0.00 0 52 1 0 0
v_all_suppliers 38154 38154 0 0.00 0 49 1 0 0
v_all_wares 62764 62764 0 0.00 0 53 1 0 0
v_cancel_adding_invoice 1234 1234 0 0.00 0 323 2 0 0
v_cancel_client_order 5186 5186 0 0.00 0 323 2 0 0
v_cancel_customer_prepayment 1958 1958 0 0.00 0 101 1 0 0
v_cancel_customer_reserve 1958 1958 0 0.00 0 377 2 0 0
v_cancel_payment_to_supplier 1208 1208 0 0.00 0 125 2 0 0
v_cancel_supplier_invoice 1090 1090 0 0.00 0 410 2 0 0
v_cancel_supplier_order 1222 1222 0 0.00 0 1501 3 0 0
v_cancel_write_off 2892 2892 0 0.00 0 493 2 0 0
v_max_id_clo_ord 7911 7911 0 0.00 0 29 1 0 0
v_max_id_clo_res 1383 1383 0 0.00 0 433 2 0 0
v_max_id_ord_sup 7877 7877 0 0.00 0 1267 2 0 0
v_max_non_paid_invoice 4881 4881 0 0.00 0 341 2 0 0
v_max_non_paid_realizn 10034 10034 0 0.00 0 230 2 0 0
v_min_id_clo_ord 7911 7911 0 0.00 0 511 3 0 0
v_min_id_clo_res 1383 1383 0 0.00 0 795 5 0 0
v_min_id_ord_sup 7877 7877 0 0.00 0 1151 5 0 0
v_min_non_paid_invoice 8170 8170 0 0.00 0 476 4 0 0
v_min_non_paid_realizn 10443 10443 0 0.00 0 425 6 0 0
v_our_firm 15804 15804 0 0.00 0 42 1 0 0
v_reserve_write_off 29092 29092 0 0.00 0 1515 2 0 0
x_lock_depdocs_on_canc_invoice 9834 9834 0 0.00 0 1494 10 0 0
x_lock_depdocs_on_canc_sup_ord 611 611 0 0.00 0 178 12 0 0
x_make_qstorno_1000_1200 7911 7911 0 0.00 1 2095 158 0 0
x_make_qstorno_1200_2000 7877 7877 0 0.00 1 5607 312 0 0
x_make_qstorno_2100_3300 338683 338683 0 0.00 0 3556 22 0 0

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

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 2 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
10:01:57 344 2147483648 2537360480 2615443456 210820416 8.939 19 11 24 0 214153088 858768 2473904
10:02:57 217 2147483648 2551086432 2631188480 220852432 9.325 20 10 20 1 225568848 2998432 1717984
10:03:58 382 2147483648 2541903840 2620973056 212803968 9.016 20 8 15 0 215952656 1497248 1651440
10:04:59 199 2147483648 2542980544 2621329408 212407408 9.000 20 12 22 0 216948944 2538832 2002704
10:05:59 166 2147483648 2546432512 2627977216 216018816 9.139 20 11 22 0 221350816 3693200 1638800
10:06:59 218 2147483648 2535714048 2613235712 203600096 8.659 20 15 32 1 209834576 3651392 2583088
10:08:00 187 2147483648 2548917760 2629644288 215182432 9.107 20 12 25 0 223231120 5496432 2552256
10:09:01 300 2147483648 2544579328 2625900544 212735040 9.013 20 9 18 0 219261520 5211088 1315392
10:10:02 328 2147483648 2547479056 2627899392 214270240 9.072 20 15 30 0 220264016 3757728 2236048
10:11:02 379 2147483648 2534148224 2615201792 206018208 8.753 19 13 24 1 209285520 1231856 2035456
10:12:03 235 2147483648 2550216592 2631573504 213986256 9.061 20 12 24 0 223551408 7556096 2009056
10:13:05 659 2147483648 2565485296 2644733952 216507696 9.158 20 16 32 0 236996992 17573728 2915568
10:14:06 243 2147483648 2548288656 2629070848 213163680 9.029 20 16 34 0 222269952 6393008 2713264
10:15:07 212 2147483648 2550109008 2634727424 215427856 9.117 20 6 12 0 223612992 7604432 580704
10:16:07 354 2147483648 2563370480 2647998464 216713680 9.166 20 9 18 0 237236784 19014688 1508416
10:17:08 225 2147483648 2558960576 2642825216 215770400 9.130 20 9 18 0 232633328 15430688 1432240
10:18:09 188 2147483648 2545910976 2629177344 214397616 9.077 20 12 25 0 221710144 5300384 2012144
10:19:09 255 2147483648 2554876752 2644529152 220364432 9.306 20 17 33 0 234583984 11185936 3033616
10:20:10 323 2147483648 2566852912 2649829376 220112352 9.296 20 14 28 1 240307344 17756160 2438832
10:21:11 330 2147483648 2547559008 2638999552 215301152 9.112 20 6 13 0 221552336 5152720 1098464
10:22:12 140 2147483648 2549283792 2631413760 215441136 9.117 20 11 21 0 222598000 5521104 1635760
10:23:12 129 2147483648 2546843920 2628186112 214996464 9.100 20 13 27 0 220365984 2993728 2375792
10:24:13 172 2147483648 2553132192 2643947520 216477408 9.157 20 13 26 0 227153552 8498768 2177376
10:25:13 197 2147483648 2556450192 2639499264 215355728 9.114 20 13 27 0 229642640 12276752 2010160
10:26:14 233 2147483648 2553619904 2642329600 217397616 9.192 20 8 16 1 227685280 9098688 1188976
10:27:14 133 2147483648 2551311664 2634158080 217379776 9.192 20 15 29 0 225634272 5694064 2560432
10:28:15 141 2147483648 2553017792 2633973760 209800704 8.900 20 12 22 0 226123632 14608080 1714848
10:29:15 308 2147483648 2542524672 2624958464 208850208 8.863 20 7 14 0 216558880 6458560 1250112
10:30:16 289 2147483648 2550454528 2632318976 206939408 8.789 19 9 18 0 224189760 15512016 1738336
10:31:16 257 2147483648 2566696000 2650025984 213712176 9.051 20 11 23 0 239449408 24172144 1565088
10:32:18 162 2147483648 2573718064 2658308096 218571008 9.237 20 11 22 0 246119120 25354064 2194048
10:33:19 183 2147483648 2565163296 2648170496 218579984 9.238 20 13 26 0 239734656 18563456 2591216
10:34:20 149 2147483648 2542605904 2631020544 208580464 8.852 20 12 25 0 216091920 5667456 1844000
10:35:20 200 2147483648 2549247056 2630692864 214455920 9.079 20 15 30 0 222196784 5322800 2418064
10:36:20 162 2147483648 2579688240 2662129664 214750736 9.091 20 14 28 0 252216096 35133040 2332320
10:37:22 206 2147483648 2555120816 2639831040 215949392 9.137 20 12 24 0 226407488 8595104 1862992
10:38:23 157 2147483648 2563204368 2647203840 215090144 9.104 20 13 25 0 236102768 18982768 2029856
10:39:23 291 2147483648 2552277280 2637033472 216118624 9.143 20 8 16 0 225867536 8546480 1202432
10:40:24 290 2147483648 2539709840 2623893504 211456512 8.964 20 8 15 0 213745824 989088 1300224
10:41:25 594 2147483648 2557010640 2642567168 214427408 9.078 20 13 25 0 231379616 14102704 2849504
10:42:25 214 2147483648 2563024304 2655821824 217398928 9.192 20 14 28 0 234987696 15223968 2364800
10:43:26 153 2147483648 2542469072 2624704512 193372656 8.260 18 12 25 0 216736240 20664112 2699472
10:44:27 116 2147483648 2547351376 2635202560 214500496 9.081 20 8 16 0 220056224 4306944 1248784
10:45:27 613 2147483648 2578855728 2679545856 217343856 9.190 20 11 22 0 249825136 30568816 1912464
10:46:28 169 2147483648 2570692384 2654257152 222791184 9.399 20 11 22 0 242419440 17788432 1839824
10:47:28 296 2147483648 2554898816 2640207872 212968608 9.022 20 9 18 1 228400944 13618960 1813376
10:48:29 231 2147483648 2546983424 2628055040 203958080 8.673 19 11 22 0 221361728 15418080 1985568
10:49:30 193 2147483648 2557324176 2642239488 218683392 9.242 20 13 24 1 229928672 9596368 1648912
10:50:30 295 2147483648 2559581776 2652491776 200746624 8.548 19 8 16 0 231772528 29647280 1378624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 10:51:31 to 09-11-2026 10:51:32.

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          211139
MON$OLDEST_ACTIVE               211140
MON$OLDEST_SNAPSHOT             211140
MON$NEXT_TRANSACTION            211140
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 07:00:11.7580 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                        {6D55D4D4-6198-472B-B774-5AAED1062B1F}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             553
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 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'

09.11.26 10:51:32. 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 10:51:34 No severe PSQL-related problems occured
09.11.26 10:51:34. End of report.