Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 08: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 3d
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 1780980 kB
MemAvailable 7306692 kB
Buffers 79288 kB
Cached 5568616 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
BugcheckAbort true false [ X ] firebird.conf
ClearGTTAtRetaining false false
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
DefaultTimeZone
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb40SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OutputRedirectionFile /dev/null /dev/null
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 3400 0 [ X ] firebird.conf
SecurityDatabase /opt/fb40/security4.fdb /opt/fb40/security4.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
TcpLoopbackFastPath false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
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
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-fb40.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-fb40.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/fb40/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=3400
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-fb40-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-fb40
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-10 08:50:50
DTS_END                         2026-11-10 08:50:50.9760
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/59496
TRN_ID                          223933
ATT_ID                          462
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: 14412.66 930 720633
customer order: creation 661.42 46 33071
customer order: refuse 53.78 46 2689
order to supplier: creation 167.46 210 8373
order to supplier: removal 13.00 7781 650
invoice (draft): creation 167.10 350 8355
invoice (draft): removal 118.62 133 5931
invoice accept: apply 144.50 1441 7225
invoice accept: cancel 99.90 201 4995
customer reserve: creation 6946.68 25 347334
customer reserve: removal 5033.68 14 251684
realization accept: apply 310.28 36 15514
realization accept: cancel 179.32 20 8966
payment from customer: creation 219.02 40 10951
payment from customer: removal 22.48 19 1124
payment to supplier: creation 179.92 32 8996
payment to supplier: removal 12.90 17 645
service: total inventory turnovers 24.38 1343 1219
service: total monetary turnovers 53.38 13 2669
service: aggregate perf. data 4.80 1821 240
service: refresh index statistics 0.04 5008 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9398
TEST_TIME 2 10567
TEST_TIME 3 10981
TEST_TIME 4 11404
TEST_TIME 5 11475
TEST_TIME 6 12008
TEST_TIME 7 12229
TEST_TIME 8 12408
TEST_TIME 9 12561
TEST_TIME 10 12851
TEST_TIME 11 12881
TEST_TIME 12 13021
TEST_TIME 13 13144
TEST_TIME 14 13106
TEST_TIME 15 13106
TEST_TIME 16 13175
TEST_TIME 17 13076
TEST_TIME 18 13040
TEST_TIME 19 13085
TEST_TIME 20 13051
TEST_TIME 21 13025
TEST_TIME 22 12936
TEST_TIME 23 12961
TEST_TIME 24 13122
TEST_TIME 25 13090
TEST_TIME 26 13191
TEST_TIME 27 13269
TEST_TIME 28 13351
TEST_TIME 29 13357
TEST_TIME 30 13456
TEST_TIME 31 13590
TEST_TIME 32 13585
TEST_TIME 33 13713
TEST_TIME 34 13741
TEST_TIME 35 13850
TEST_TIME 36 13932
TEST_TIME 37 13992
TEST_TIME 38 13965
TEST_TIME 39 14012
TEST_TIME 40 14047
TEST_TIME 41 14103
TEST_TIME 42 14181
TEST_TIME 43 14246
TEST_TIME 44 14226
TEST_TIME 45 14357
TEST_TIME 46 14459
TEST_TIME 47 14472
TEST_TIME 48 14428
TEST_TIME 49 14450
TEST_TIME 50 14413

Performance per minute, chart


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

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 1064044 1064044 0 0.00 0 1605 2 0 0
doc_list_biud 1064044 1064044 0 0.00 0 2487 5 0 0
sp_add_invoice_to_stock 7225 7225 0 0.00 5 12407 1441 0 0
sp_cancel_adding_invoice 4995 4995 0 0.00 4 4386 202 0 0
sp_cancel_client_order 2689 2689 0 0.00 3 1214 47 0 0
sp_cancel_customer_reserve 251684 251684 0 0.00 1 2489 15 0 0
sp_cancel_pay_from_customer 1124 1124 0 0.00 2 665 19 0 0
sp_cancel_pay_to_supplier 645 645 0 0.00 2 500 18 0 0
sp_cancel_supplier_invoice 5931 5931 0 0.00 2 1963 134 0 0
sp_cancel_supplier_order 650 650 0 0.00 4 55578 7781 0 0
sp_cancel_write_off 8966 8966 0 0.00 1 1123 20 0 0
sp_client_order 33071 33071 0 0.00 3 1911 46 0 0
sp_customer_reserve 347334 347334 0 0.00 0 2546 26 0 0
sp_fill_shopping_cart 49799 49799 0 0.00 1 2943 20 0 0
sp_fill_shopping_cart_clo_res 347334 347334 0 0.00 0 1517 2 0 0
sp_get_clo_for_invoice 7225 7225 0 0.00 0 1234 34 0 0
sp_kill_cost_storno 15730 15730 0 0.00 0 1104 10 0 0
sp_kill_qstorno_ret_qs2qd 518915 518915 0 0.00 0 1975 7 0 0
sp_kill_qty_storno 297654 297654 0 0.00 0 2487 17 0 0
sp_lock_selected_doc 31642 31642 0 0.00 0 511 1 0 0
sp_make_cost_storno 42686 42686 0 0.00 0 656 7 0 0
sp_multiply_rows_for_pdistr 42686 42686 0 0.00 0 935 11 0 0
sp_multiply_rows_for_qdistr 33071 33071 0 0.00 0 1906 18 0 0
sp_pay_from_customer 10951 10951 0 0.00 3 909 40 0 0
sp_pay_to_supplier 8996 8996 0 0.00 3 946 33 0 0
sp_payment_common 19947 19947 0 0.00 1 870 11 0 0
sp_qd_handle_on_cancel_clo 2689 2689 0 0.00 0 1205 32 0 0
sp_qd_handle_on_invoice_upd_sts 12220 12220 0 0.00 0 2444 66 0 0
sp_qd_handle_on_reserve_upd_sts 15514 15514 0 0.00 0 1408 11 0 0
sp_reserve_write_off 15514 15514 0 0.00 3 1425 37 0 0
sp_supplier_invoice 8355 8355 0 0.00 5 5796 351 0 0
sp_supplier_order 8373 8373 0 0.00 5 2661 211 0 0
srv_aggregate_perf_data 240 240 0 0.00 53 15115 1821 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 628 260 0 0
srv_find_qd_qs_mism 669991 669991 0 0.00 0 1605 1 0 0
srv_make_invnt_saldo 1219 1219 0 0.00 0 4272 1343 0 0
srv_make_money_saldo 2669 2669 0 0.00 0 255 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 144 9872 5008 0 0
v_add_invoice_to_stock 14450 14450 0 0.00 0 574 2 0 0
v_all_customers 50164 50164 0 0.00 0 51 1 0 0
v_all_suppliers 41042 41042 0 0.00 0 48 1 0 0
v_all_wares 66142 66142 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 1300 1300 0 0.00 0 181 2 0 0
v_cancel_client_order 5378 5378 0 0.00 0 381 1 0 0
v_cancel_customer_prepayment 2248 2248 0 0.00 0 180 1 0 0
v_cancel_customer_reserve 2078 2078 0 0.00 0 147 1 0 0
v_cancel_payment_to_supplier 1290 1290 0 0.00 0 479 2 0 0
v_cancel_supplier_invoice 1138 1138 0 0.00 0 212 2 0 0
v_cancel_supplier_order 1300 1300 0 0.00 0 25 1 0 0
v_cancel_write_off 3074 3074 0 0.00 0 463 2 0 0
v_max_id_clo_ord 8373 8373 0 0.00 0 65 1 0 0
v_max_id_clo_res 1479 1479 0 0.00 0 600 2 0 0
v_max_id_ord_sup 8355 8355 0 0.00 0 928 2 0 0
v_max_non_paid_invoice 5203 5203 0 0.00 0 102 2 0 0
v_max_non_paid_realizn 10660 10660 0 0.00 0 134 2 0 0
v_min_id_clo_ord 8373 8373 0 0.00 0 690 2 0 0
v_min_id_clo_res 1479 1479 0 0.00 0 762 4 0 0
v_min_id_ord_sup 8355 8355 0 0.00 0 1504 6 0 0
v_min_non_paid_invoice 8996 8996 0 0.00 0 357 4 0 0
v_min_non_paid_realizn 10951 10951 0 0.00 0 568 6 0 0
v_our_firm 16560 16560 0 0.00 0 39 1 0 0
v_reserve_write_off 31028 31028 0 0.00 0 657 1 0 0
x_lock_depdocs_on_canc_invoice 10357 10357 0 0.00 0 1074 9 0 0
x_lock_depdocs_on_canc_sup_ord 650 650 0 0.00 0 157 12 0 0
x_make_qstorno_1000_1200 8373 8373 0 0.00 1 2526 155 0 0
x_make_qstorno_1200_2000 8355 8355 0 0.00 1 5658 304 0 0
x_make_qstorno_2100_3300 347334 347334 0 0.00 0 2541 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-11-2026 08:51:11 to 10-11-2026 08:51:15.

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
08:00:55 2 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
08:01:55 279 2147483648 2538504608 2615250944 212159600 8.991 20 12 23 0 217143984 2460112 2524272
08:02:56 214 2147483648 2550443344 2630795264 224513280 9.465 20 15 31 1 228279136 1303296 2462560
08:03:56 251 2147483648 2545796912 2623123456 218259824 9.225 20 15 34 0 222906944 1635200 3011920
08:04:57 286 2147483648 2530637328 2608635904 203775984 8.666 20 14 27 0 208385056 2223632 2385440
08:05:57 295 2147483648 2554181360 2635132928 221120288 9.335 20 16 30 0 230236720 6677312 2439120
08:06:58 230 2147483648 2538480128 2618654720 208773104 8.860 20 10 20 0 215637232 5146576 1717552
08:07:58 479 2147483648 2541450192 2621820928 213647312 9.048 20 14 28 0 219024880 3342016 2035552
08:08:59 213 2147483648 2540184208 2620903424 213852144 9.056 20 12 24 0 217650160 1781152 2016864
08:09:59 209 2147483648 2555433424 2636251136 218356432 9.229 20 15 30 1 232893280 11786544 2750304
08:11:00 208 2147483648 2544843088 2626338816 214264880 9.072 20 12 25 0 221820944 5115792 2440272
08:12:01 255 2147483648 2548671488 2630664192 214611136 9.085 20 12 23 0 224950816 8415696 1923984
08:13:01 471 2147483648 2534915232 2614673408 204548272 8.696 19 12 23 0 209427024 2881408 1997344
08:14:02 164 2147483648 2549535776 2631585792 219949808 9.290 20 15 29 0 225734672 3312000 2472864
08:15:02 322 2147483648 2551395424 2637606912 213947328 9.060 20 12 22 0 227677888 11551952 2178608
08:16:03 173 2147483648 2562665184 2644111360 219398576 9.269 20 13 24 1 238926464 17426400 2101488
08:17:04 213 2147483648 2552171760 2633699328 219564016 9.275 20 12 22 0 228733136 7231776 1937344
08:18:04 191 2147483648 2543644400 2624430080 210203248 8.915 20 10 19 0 219992160 8457728 1331184
08:19:05 218 2147483648 2553400448 2634727424 215392464 9.115 20 11 19 0 230473696 13456656 1624576
08:20:05 165 2147483648 2529928032 2607108096 196470544 8.382 19 11 22 0 206915232 8470608 1974080
08:21:06 211 2147483648 2547542576 2628124672 212543840 9.005 20 12 23 0 223295568 8817968 1933760
08:22:07 231 2147483648 2551654256 2634088448 216692976 9.165 20 13 28 0 228278160 9347216 2237968
08:23:08 284 2147483648 2547746176 2631495680 218095008 9.219 20 9 18 0 224532240 5246928 1190304
08:24:08 240 2147483648 2553029344 2640674816 214069872 9.064 20 15 30 0 227436592 10780320 2586400
08:25:09 188 2147483648 2543221472 2629980160 213551424 9.044 20 5 10 0 219738096 5480784 705888
08:26:10 145 2147483648 2552962784 2644103168 216686752 9.165 20 8 16 1 230336400 12398352 1251296
08:27:10 125 2147483648 2555529280 2635726848 212515152 9.004 20 15 31 0 231150416 16234784 2400480
08:28:11 117 2147483648 2552178272 2635780096 214949920 9.098 20 11 21 0 228635776 11581616 2104240
08:29:11 502 2147483648 2553291456 2635390976 218198848 9.223 20 12 24 0 227926656 7893792 1834016
08:30:12 116 2147483648 2566947680 2649993216 219394992 9.269 20 11 22 0 243440608 22242144 1803472
08:31:12 104 2147483648 2557785488 2640633856 209838192 8.901 20 11 21 0 233820544 22049152 1933200
08:32:12 193 2147483648 2548622656 2632044544 218416592 9.231 20 10 18 1 224406000 4510032 1479376
08:33:13 335 2147483648 2555367344 2636124160 213817744 9.055 20 16 33 1 231891136 15062864 3010528
08:34:13 331 2147483648 2546454368 2632892416 214288752 9.073 20 10 20 0 224977456 8709856 1978848
08:35:14 158 2147483648 2551716784 2632318976 216391888 9.154 20 14 28 0 226607312 8111648 2103776
08:36:14 155 2147483648 2558600080 2640515072 217493536 9.196 20 14 26 0 233912672 14140496 2278640
08:37:15 257 2147483648 2543966288 2622967808 207547040 8.812 20 15 29 1 219052048 9250432 2254576
08:38:15 153 2147483648 2556182960 2646863872 216089344 9.142 20 10 20 0 233437008 15235200 2112464
08:39:16 183 2147483648 2550366416 2632790016 216291536 9.150 20 12 25 0 226643680 8049840 2302304
08:40:16 161 2147483648 2552060736 2636087296 219565632 9.275 20 9 18 0 227644128 6616912 1461584
08:41:17 324 2147483648 2551839872 2632708096 216584368 9.161 20 13 24 0 226530208 7901552 2044288
08:42:18 215 2147483648 2558567440 2640703488 216866912 9.172 20 12 23 0 235790448 16519120 2404416
08:43:18 303 2147483648 2545432656 2624397312 205802064 8.745 19 17 35 0 222150624 14029440 2319120
08:44:19 480 2147483648 2551524112 2632454144 212439376 9.001 20 15 31 0 226518192 11334256 2744560
08:45:19 288 2147483648 2571011712 2654654464 218594688 9.238 20 12 24 1 246718736 26149408 1974640
08:46:20 216 2147483648 2566196864 2647990272 213745232 9.052 20 16 32 0 241446448 24656544 3044672
08:47:20 443 2147483648 2559198240 2641154048 216823264 9.170 20 11 22 0 234305056 15284896 2196896
08:48:21 552 2147483648 2555462112 2637385728 212224352 8.993 20 10 19 0 230632736 16975616 1432768
08:49:22 291 2147483648 2534982176 2616643584 204866336 8.709 20 10 18 0 210463632 3855104 1742192
08:50:22 623 2147483648 2547093824 2631856128 212967008 9.022 20 12 24 1 224152800 9395296 1790496

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 10-11-2026 08:51:16 to 10-11-2026 08:51:28.

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

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb40.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          222713
MON$OLDEST_ACTIVE               224278
MON$OLDEST_SNAPSHOT             224278
MON$NEXT_TRANSACTION            224278
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-10 05:00:12.1230 GMT
MON$PAGES                       151912
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                        {FF7B37A4-27AD-4BBA-8B7E-BF8A6B63BA97}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             575
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3339 Firebird 4.0 b9a51aa
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3339 Firebird 4.0 b9a51aa"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3339 Firebird 4.0 b9a51aa/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3339 Firebird 4.0 b9a51aa/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    Tue Nov 10 08:50:51 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
:10: 
:11: test-0    Tue Nov 10 08:50:53 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13: 
--- end of diff output ---

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

10.11.26 08:51:30. There are 3 logs in /var/tmp/logs.oltp-fb40 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-10 08:51:31 No severe PSQL-related problems occured
10.11.26 08:51:32. End of report.