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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 1w 5d
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 1815764 kB
MemAvailable 7304096 kB
Buffers 80792 kB
Cached 5526612 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-12 16:50:56
DTS_END                         2026-11-12 16:50:56.3310
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/32890
TRN_ID                          203178
ATT_ID                          428
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: 12748.78 933 637439
customer order: creation 599.06 51 29953
customer order: refuse 47.84 50 2392
order to supplier: creation 154.56 226 7728
order to supplier: removal 11.46 8247 573
invoice (draft): creation 153.84 378 7692
invoice (draft): removal 109.36 142 5468
invoice accept: apply 131.40 1496 6570
invoice accept: cancel 90.50 207 4525
customer reserve: creation 6084.68 27 304234
customer reserve: removal 4452.64 15 222632
realization accept: apply 281.86 41 14093
realization accept: cancel 162.52 20 8126
payment from customer: creation 201.06 35 10053
payment from customer: removal 19.00 21 950
payment to supplier: creation 164.26 30 8213
payment to supplier: removal 10.56 20 528
service: total inventory turnovers 20.26 1664 1013
service: total monetary turnovers 49.34 13 2467
service: aggregate perf. data 4.54 1986 227
service: refresh index statistics 0.04 3982 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7356
TEST_TIME 2 8012
TEST_TIME 3 7975
TEST_TIME 4 8392
TEST_TIME 5 8871
TEST_TIME 6 9114
TEST_TIME 7 9692
TEST_TIME 8 9763
TEST_TIME 9 9855
TEST_TIME 10 10039
TEST_TIME 11 10181
TEST_TIME 12 10295
TEST_TIME 13 10534
TEST_TIME 14 10631
TEST_TIME 15 10785
TEST_TIME 16 10889
TEST_TIME 17 11029
TEST_TIME 18 11183
TEST_TIME 19 11262
TEST_TIME 20 11379
TEST_TIME 21 11398
TEST_TIME 22 11395
TEST_TIME 23 11445
TEST_TIME 24 11489
TEST_TIME 25 11564
TEST_TIME 26 11543
TEST_TIME 27 11529
TEST_TIME 28 11627
TEST_TIME 29 11661
TEST_TIME 30 11716
TEST_TIME 31 11700
TEST_TIME 32 11843
TEST_TIME 33 11892
TEST_TIME 34 11843
TEST_TIME 35 12006
TEST_TIME 36 12089
TEST_TIME 37 12157
TEST_TIME 38 12206
TEST_TIME 39 12204
TEST_TIME 40 12199
TEST_TIME 41 12361
TEST_TIME 42 12396
TEST_TIME 43 12446
TEST_TIME 44 12513
TEST_TIME 45 12549
TEST_TIME 46 12602
TEST_TIME 47 12652
TEST_TIME 48 12676
TEST_TIME 49 12730
TEST_TIME 50 12749

Performance per minute, chart


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

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 940223 940223 0 0.00 0 1922 2 0 0
doc_list_biud 940223 940223 0 0.00 0 1971 5 0 0
sp_add_invoice_to_stock 6570 6570 0 0.00 8 11824 1496 0 0
sp_cancel_adding_invoice 4525 4525 0 0.00 3 5465 208 0 0
sp_cancel_client_order 2392 2392 0 0.00 3 1750 50 0 0
sp_cancel_customer_reserve 222632 222632 0 0.00 1 1809 16 0 0
sp_cancel_pay_from_customer 950 950 0 0.00 2 630 22 0 0
sp_cancel_pay_to_supplier 528 528 0 0.00 2 330 20 0 0
sp_cancel_supplier_invoice 5468 5468 0 0.00 1 1591 142 0 0
sp_cancel_supplier_order 573 573 0 0.00 6 44444 8248 0 0
sp_cancel_write_off 8126 8126 0 0.00 1 951 21 0 0
sp_client_order 29953 29953 0 0.00 4 2665 52 0 0
sp_customer_reserve 304234 304234 0 0.00 0 2721 27 0 0
sp_fill_shopping_cart 45373 45373 0 0.00 1 1510 21 0 0
sp_fill_shopping_cart_clo_res 304234 304234 0 0.00 0 1358 2 0 0
sp_get_clo_for_invoice 6570 6570 0 0.00 0 1471 34 0 0
sp_kill_cost_storno 14129 14129 0 0.00 0 1045 10 0 0
sp_kill_qstorno_ret_qs2qd 459431 459431 0 0.00 0 1808 8 0 0
sp_kill_qty_storno 264379 264379 0 0.00 0 1971 18 0 0
sp_lock_selected_doc 28511 28511 0 0.00 0 680 2 0 0
sp_make_cost_storno 38929 38929 0 0.00 0 1450 8 0 0
sp_multiply_rows_for_pdistr 38929 38929 0 0.00 0 606 11 0 0
sp_multiply_rows_for_qdistr 29953 29953 0 0.00 0 2145 20 0 0
sp_pay_from_customer 10053 10053 0 0.00 3 1145 36 0 0
sp_pay_to_supplier 8213 8213 0 0.00 3 841 31 0 0
sp_payment_common 18266 18266 0 0.00 1 709 7 0 0
sp_qd_handle_on_cancel_clo 2392 2392 0 0.00 0 1741 34 0 0
sp_qd_handle_on_invoice_upd_sts 11095 11095 0 0.00 0 1971 69 0 0
sp_qd_handle_on_reserve_upd_sts 14093 14093 0 0.00 0 1423 12 0 0
sp_reserve_write_off 14093 14093 0 0.00 3 1438 42 0 0
sp_supplier_invoice 7692 7692 0 0.00 6 5286 378 0 0
sp_supplier_order 7728 7728 0 0.00 5 3836 226 0 0
srv_aggregate_perf_data 227 227 0 0.00 18 73360 1986 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 623 244 0 0
srv_find_qd_qs_mism 592429 592429 0 0.00 0 1899 1 0 0
srv_make_invnt_saldo 1013 1013 0 0.00 1 5528 1665 0 0
srv_make_money_saldo 2467 2467 0 0.00 0 324 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 564 7401 3983 0 0
v_add_invoice_to_stock 13140 13140 0 0.00 0 510 2 0 0
v_all_customers 45694 45694 0 0.00 0 35 1 0 0
v_all_suppliers 37704 37704 0 0.00 0 37 1 0 0
v_all_wares 59906 59906 0 0.00 0 46 1 0 0
v_cancel_adding_invoice 1198 1198 0 0.00 0 147 2 0 0
v_cancel_client_order 4784 4784 0 0.00 0 479 2 0 0
v_cancel_customer_prepayment 1900 1900 0 0.00 0 483 2 0 0
v_cancel_customer_reserve 1880 1880 0 0.00 0 371 2 0 0
v_cancel_payment_to_supplier 1056 1056 0 0.00 0 25 1 0 0
v_cancel_supplier_invoice 1018 1018 0 0.00 0 273 2 0 0
v_cancel_supplier_order 1146 1146 0 0.00 0 46 1 0 0
v_cancel_write_off 2714 2714 0 0.00 0 393 2 0 0
v_max_id_clo_ord 7728 7728 0 0.00 0 192 1 0 0
v_max_id_clo_res 1374 1374 0 0.00 0 325 2 0 0
v_max_id_ord_sup 7692 7692 0 0.00 0 1223 3 0 0
v_max_non_paid_invoice 4781 4781 0 0.00 0 34 1 0 0
v_max_non_paid_realizn 9675 9675 0 0.00 0 600 1 0 0
v_min_id_clo_ord 7728 7728 0 0.00 0 534 3 0 0
v_min_id_clo_res 1374 1374 0 0.00 0 764 4 0 0
v_min_id_ord_sup 7692 7692 0 0.00 0 1187 6 0 0
v_min_non_paid_invoice 8213 8213 0 0.00 0 518 2 0 0
v_min_non_paid_realizn 10053 10053 0 0.00 0 479 2 0 0
v_our_firm 14968 14968 0 0.00 0 44 1 0 0
v_reserve_write_off 28186 28186 0 0.00 0 751 2 0 0
x_lock_depdocs_on_canc_invoice 9484 9484 0 0.00 0 1146 9 0 0
x_lock_depdocs_on_canc_sup_ord 573 573 0 0.00 0 142 11 0 0
x_make_qstorno_1000_1200 7728 7728 0 0.00 1 3806 168 0 0
x_make_qstorno_1200_2000 7692 7692 0 0.00 1 4912 333 0 0
x_make_qstorno_2100_3300 304234 304234 0 0.00 0 2556 24 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 12-11-2026 16:51:20 to 12-11-2026 16: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
16:01:00 3 2147483648 2309550144 2313269248 3168864 0.147 1 1 2 0 3266304 61664 35776
16:02:00 261 2147483648 2552732672 2633412608 225397712 9.498 20 15 27 0 228605072 1144096 2063264
16:03:01 337 2147483648 2551390272 2632060928 221981696 9.368 20 9 19 0 225918576 2590624 1346256
16:04:01 199 2147483648 2521497472 2595155968 193091616 8.249 20 8 16 0 196228576 1333440 1803520
16:05:02 286 2147483648 2551963776 2634088448 219812352 9.285 20 10 21 0 226466448 4822560 1831536
16:06:03 198 2147483648 2537789200 2617245696 208541504 8.851 20 7 14 0 212459264 2473072 1444688
16:07:03 205 2147483648 2555569408 2636652544 221694672 9.357 20 12 25 0 229572112 5583456 2293984
16:08:04 196 2147483648 2535484736 2615787520 206833200 8.785 20 8 16 0 210729296 2350848 1545248
16:09:04 118 2147483648 2552358944 2637045760 220020944 9.293 20 9 18 0 227193232 5086400 2085888
16:10:05 238 2147483648 2542851552 2624180224 209590320 8.891 20 11 21 0 218368832 6709600 2068912
16:11:05 170 2147483648 2550075536 2632085504 218325920 9.228 20 14 26 0 223372048 2827184 2218944
16:12:06 231 2147483648 2539194608 2621497344 209449360 8.886 20 9 18 0 213403088 2647952 1305776
16:13:07 300 2147483648 2557456288 2638172160 217454800 9.194 20 13 27 0 232128000 12578656 2094544
16:14:07 568 2147483648 2544509008 2626125824 215084544 9.103 20 15 29 1 218942352 1313792 2544016
16:15:11 203 2147483648 2554772528 2636058624 213777616 9.053 20 14 28 0 227993920 11970400 2245904
16:16:11 105 2147483648 2549050224 2633601024 218299488 9.227 20 9 18 0 222846000 3185104 1361408
16:17:12 183 2147483648 2552743216 2635612160 216924640 9.174 20 11 22 0 225936672 6839872 2172160
16:18:13 135 2147483648 2545797088 2628517888 208900352 8.865 20 11 22 0 221507424 10955904 1651168
16:19:13 219 2147483648 2549636128 2631815168 216608288 9.162 20 17 36 0 223313472 3889968 2815216
16:20:13 295 2147483648 2554979488 2644123648 212600080 9.008 20 7 14 0 228650400 14760016 1290304
16:21:15 232 2147483648 2549787152 2633314304 216949056 9.175 20 11 24 0 223980880 5272016 1759808
16:22:15 234 2147483648 2547024288 2627219456 213685024 9.049 20 11 22 0 219989456 4465056 1839376
16:23:16 99 2147483648 2561062192 2643181568 213786272 9.053 20 12 21 1 236053664 20455552 1811840
16:24:16 413 2147483648 2556455456 2638667776 215086864 9.103 20 12 26 0 231415248 13888528 2439856
16:25:17 205 2147483648 2576020160 2659811328 218735904 9.244 20 12 24 1 249838608 28777680 2325024
16:26:17 133 2147483648 2546398176 2628177920 215403888 9.116 20 15 28 0 221388304 3127280 2857136
16:27:18 132 2147483648 2549444592 2630643712 213845728 9.056 20 12 26 1 222746592 6545424 2355440
16:28:18 188 2147483648 2551253344 2631245824 210789600 8.938 20 16 33 0 223483488 9706720 2987168
16:29:19 487 2147483648 2554614384 2643488768 204156480 8.681 19 10 20 0 223896160 18023328 1716352
16:30:20 133 2147483648 2557187872 2641117184 219048624 9.256 20 11 22 0 230645216 9315504 2281088
16:31:20 397 2147483648 2546903840 2627805184 206469504 8.771 19 10 19 0 220764512 12791680 1503328
16:32:21 174 2147483648 2544853664 2625122304 209518064 8.889 19 9 18 0 218721008 7637328 1565616
16:33:21 260 2147483648 2566041632 2650664960 215750736 9.129 20 11 22 0 238078208 20475760 1851712
16:34:22 592 2147483648 2545635248 2629570560 214492208 9.081 20 9 18 0 218279440 2495760 1291472
16:35:23 333 2147483648 2582268448 2667196416 217747040 9.206 20 10 20 0 256422096 36631744 2043312
16:36:23 248 2147483648 2557491440 2652839936 218908400 9.250 20 8 13 0 231150160 10943712 1298048
16:37:24 294 2147483648 2550677344 2635751424 211386704 8.961 20 10 20 0 224100976 11216304 1497968
16:38:25 121 2147483648 2559449280 2642743296 217611824 9.200 20 10 20 0 231936736 12670656 1654256
16:39:26 188 2147483648 2553416640 2638835712 212035776 8.986 20 11 22 0 227629792 13600800 1993216
16:40:26 194 2147483648 2553591376 2637406208 214909136 9.097 20 10 20 0 226210400 9477536 1823728
16:41:27 613 2147483648 2567903040 2650992640 218383264 9.230 20 12 24 1 238368432 17966704 2018464
16:42:28 176 2147483648 2539985696 2620698624 207156784 8.797 20 8 14 0 211565408 3240576 1168048
16:43:28 272 2147483648 2559110896 2642223104 217586000 9.199 20 12 24 0 231600112 11975120 2038992
16:44:28 161 2147483648 2560097168 2642702336 218153760 9.221 20 11 22 0 232600752 12694576 1752416
16:45:29 248 2147483648 2537395600 2617729024 200462272 8.537 20 11 22 0 209676016 7577488 1636256
16:46:30 220 2147483648 2555795056 2638749696 213628224 9.047 20 11 22 0 229581296 14018960 1934112
16:47:30 143 2147483648 2551807456 2635988992 215312144 9.112 20 11 21 0 224625024 7457280 1855600
16:48:31 214 2147483648 2556819776 2643931136 219759552 9.283 20 9 18 0 230203696 8809504 1634640
16:49:31 305 2147483648 2537690000 2619924480 204411200 8.691 20 12 22 0 212075888 6218976 1445712
16:50:32 150 2147483648 2541187296 2625314816 211024336 8.947 20 8 16 0 214288992 1903904 1360752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 12-11-2026 16:51:25 to 12-11-2026 16:51:38.

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 12-11-2026 16:51:39 to 12-11-2026 16:51:40.

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          203177
MON$OLDEST_ACTIVE               204221
MON$OLDEST_SNAPSHOT             204221
MON$NEXT_TRANSACTION            204221
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-12 13:00:11.8050 GMT
MON$PAGES                       134470
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {2205D7CF-7C16-4AE9-B77E-16BABECB48CF}
MON$FILE_ID                     0108000000000000dded070000000000
MON$NEXT_ATTACHMENT             543
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3332 Firebird 4.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3332 Firebird 4.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3332 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3332 Firebird 4.0 HQbird/tcp (test-0)/P17:C"
on disk structure version 13.0

Database statistics


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

Database validation


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

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

--- start of diff output ---
:6: 
:7: test-0    Thu Nov 12 16:50:57 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:9: 
:10: 
:11: test-0    Thu Nov 12 16:50:57 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:13: 
:14: 
:15: test-0    Thu Nov 12 16:50:57 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30400
:17: 
--- end of diff output ---

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

12.11.26 16:51:40. 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-12 16:51:41 No severe PSQL-related problems occured
12.11.26 16:51:42. End of report.