Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.11.2026 14: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 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 6d
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 1709384 kB
MemAvailable 7275400 kB
Buffers 90052 kB
Cached 5562768 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
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-06 14:50:56
DTS_END                         2026-11-06 14:50:56.7700
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/51666
TRN_ID                          189507
ATT_ID                          398
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: 11610.52 925 580526
customer order: creation 558.40 52 27920
customer order: refuse 45.42 44 2271
order to supplier: creation 142.70 228 7135
order to supplier: removal 10.34 7821 517
invoice (draft): creation 144.12 363 7206
invoice (draft): removal 100.20 133 5010
invoice accept: apply 121.34 1581 6067
invoice accept: cancel 80.82 195 4041
customer reserve: creation 5570.32 29 278516
customer reserve: removal 4002.54 14 200127
realization accept: apply 258.74 42 12937
realization accept: cancel 140.98 21 7049
payment from customer: creation 188.42 37 9421
payment from customer: removal 17.82 21 891
payment to supplier: creation 149.04 33 7452
payment to supplier: removal 11.10 23 555
service: total inventory turnovers 18.92 1754 946
service: total monetary turnovers 44.60 12 2230
service: aggregate perf. data 4.66 1346 233
service: refresh index statistics 0.04 4760 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 06-11-2026 14:51:18 to 06-11-2026 14:51:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5501
TEST_TIME 2 6995
TEST_TIME 3 7379
TEST_TIME 4 6794
TEST_TIME 5 7626
TEST_TIME 6 8229
TEST_TIME 7 8524
TEST_TIME 8 8938
TEST_TIME 9 9163
TEST_TIME 10 9347
TEST_TIME 11 9543
TEST_TIME 12 9661
TEST_TIME 13 9813
TEST_TIME 14 10023
TEST_TIME 15 10191
TEST_TIME 16 10225
TEST_TIME 17 10265
TEST_TIME 18 10363
TEST_TIME 19 10308
TEST_TIME 20 10256
TEST_TIME 21 10372
TEST_TIME 22 10479
TEST_TIME 23 10525
TEST_TIME 24 10658
TEST_TIME 25 10800
TEST_TIME 26 10856
TEST_TIME 27 10902
TEST_TIME 28 10977
TEST_TIME 29 11034
TEST_TIME 30 11052
TEST_TIME 31 11102
TEST_TIME 32 11109
TEST_TIME 33 11166
TEST_TIME 34 11248
TEST_TIME 35 11290
TEST_TIME 36 11315
TEST_TIME 37 11410
TEST_TIME 38 11433
TEST_TIME 39 11420
TEST_TIME 40 11391
TEST_TIME 41 11391
TEST_TIME 42 11384
TEST_TIME 43 11388
TEST_TIME 44 11470
TEST_TIME 45 11458
TEST_TIME 46 11422
TEST_TIME 47 11422
TEST_TIME 48 11510
TEST_TIME 49 11631
TEST_TIME 50 11611

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 06-11-2026 14:51:20 to 06-11-2026 14:51:22.

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 860860 860860 0 0.00 0 3794 2 0 0
doc_list_biud 860860 860860 0 0.00 0 2983 5 0 0
sp_add_invoice_to_stock 6067 6067 0 0.00 4 16157 1581 0 0
sp_cancel_adding_invoice 4041 4041 0 0.00 2 5508 196 0 0
sp_cancel_client_order 2271 2271 0 0.00 3 1517 44 0 0
sp_cancel_customer_reserve 200127 200127 0 0.00 1 2985 15 0 0
sp_cancel_pay_from_customer 891 891 0 0.00 2 580 21 0 0
sp_cancel_pay_to_supplier 555 555 0 0.00 2 545 23 0 0
sp_cancel_supplier_invoice 5010 5010 0 0.00 1 2074 133 0 0
sp_cancel_supplier_order 517 517 0 0.00 6 38080 7822 0 0
sp_cancel_write_off 7049 7049 0 0.00 1 2892 21 0 0
sp_client_order 27920 27920 0 0.00 3 3830 52 0 0
sp_customer_reserve 278516 278516 0 0.00 0 4246 29 0 0
sp_fill_shopping_cart 42261 42261 0 0.00 1 2781 21 0 0
sp_fill_shopping_cart_clo_res 278516 278516 0 0.00 0 1613 2 0 0
sp_get_clo_for_invoice 6067 6067 0 0.00 0 2391 32 0 0
sp_kill_cost_storno 12536 12536 0 0.00 0 1388 9 0 0
sp_kill_qstorno_ret_qs2qd 412830 412830 0 0.00 0 2961 7 0 0
sp_kill_qty_storno 238019 238019 0 0.00 0 2983 17 0 0
sp_lock_selected_doc 26426 26426 0 0.00 0 826 1 0 0
sp_make_cost_storno 35877 35877 0 0.00 0 2845 8 0 0
sp_multiply_rows_for_pdistr 35877 35877 0 0.00 0 1105 11 0 0
sp_multiply_rows_for_qdistr 27920 27920 0 0.00 0 1713 18 0 0
sp_pay_from_customer 9421 9421 0 0.00 3 1775 38 0 0
sp_pay_to_supplier 7452 7452 0 0.00 3 1108 33 0 0
sp_payment_common 16873 16873 0 0.00 1 796 7 0 0
sp_qd_handle_on_cancel_clo 2271 2271 0 0.00 0 1509 28 0 0
sp_qd_handle_on_invoice_upd_sts 10108 10108 0 0.00 0 2973 61 0 0
sp_qd_handle_on_reserve_upd_sts 12937 12937 0 0.00 0 1776 12 0 0
sp_reserve_write_off 12937 12937 0 0.00 3 1831 43 0 0
sp_supplier_invoice 7206 7206 0 0.00 6 6657 364 0 0
sp_supplier_order 7135 7135 0 0.00 4 12848 229 0 0
srv_aggregate_perf_data 233 233 0 0.00 18 10516 1346 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1020 309 0 0
srv_find_qd_qs_mism 540280 540280 0 0.00 0 3794 2 0 0
srv_make_invnt_saldo 946 946 0 0.00 14 9112 1754 0 0
srv_make_money_saldo 2230 2230 0 0.00 0 529 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 452 9069 4761 0 0
v_add_invoice_to_stock 12134 12134 0 0.00 0 1475 3 0 0
v_all_customers 42672 42672 0 0.00 0 228 1 0 0
v_all_suppliers 34600 34600 0 0.00 0 53 1 0 0
v_all_wares 55840 55840 0 0.00 0 239 1 0 0
v_cancel_adding_invoice 1050 1050 0 0.00 0 187 2 0 0
v_cancel_client_order 4542 4542 0 0.00 0 1025 2 0 0
v_cancel_customer_prepayment 1782 1782 0 0.00 0 467 2 0 0
v_cancel_customer_reserve 1828 1828 0 0.00 0 575 3 0 0
v_cancel_payment_to_supplier 1110 1110 0 0.00 0 515 2 0 0
v_cancel_supplier_invoice 1002 1002 0 0.00 0 474 4 0 0
v_cancel_supplier_order 1034 1034 0 0.00 0 29 1 0 0
v_cancel_write_off 2496 2496 0 0.00 0 501 2 0 0
v_max_id_clo_ord 7135 7135 0 0.00 0 70 1 0 0
v_max_id_clo_res 1307 1307 0 0.00 0 232 2 0 0
v_max_id_ord_sup 7206 7206 0 0.00 0 740 2 0 0
v_max_non_paid_invoice 4493 4493 0 0.00 0 250 1 0 0
v_max_non_paid_realizn 9020 9020 0 0.00 0 85 1 0 0
v_min_id_clo_ord 7135 7135 0 0.00 0 560 3 0 0
v_min_id_clo_res 1307 1307 0 0.00 0 801 6 0 0
v_min_id_ord_sup 7206 7206 0 0.00 0 1434 7 0 0
v_min_non_paid_invoice 7452 7452 0 0.00 0 296 2 0 0
v_min_non_paid_realizn 9421 9421 0 0.00 0 633 2 0 0
v_our_firm 13970 13970 0 0.00 0 314 1 0 0
v_reserve_write_off 25874 25874 0 0.00 0 416 2 0 0
x_lock_depdocs_on_canc_invoice 8550 8550 0 0.00 0 1638 9 0 0
x_lock_depdocs_on_canc_sup_ord 517 517 0 0.00 0 204 8 0 0
x_make_qstorno_1000_1200 7135 7135 0 0.00 1 12273 173 0 0
x_make_qstorno_1200_2000 7206 7206 0 0.00 1 6515 313 0 0
x_make_qstorno_2100_3300 278516 278516 0 0.00 0 4196 25 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2026 14:51:23 to 06-11-2026 14:51:27.

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
14:01:03 2 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
14:02:03 282 2147483648 2546425264 2626785280 222180400 9.376 20 9 15 1 224428016 1115104 1132512
14:03:04 316 2147483648 2542382640 2619510784 217585728 9.199 20 13 26 1 221031744 1147280 2298736
14:04:05 761 2147483648 2519141440 2592702464 193411856 8.262 19 11 20 0 196877232 1917472 1547904
14:05:09 382 2147483648 2542000448 2620624896 216312336 9.151 20 7 13 0 219606576 1096736 2197504
14:06:10 278 2147483648 2548029840 2628632576 220347440 9.305 20 11 21 0 225041728 3118048 1576240
14:07:11 309 2147483648 2550494288 2632642560 217295808 9.188 20 10 20 0 227798240 8783296 1719136
14:08:12 313 2147483648 2524628416 2601152512 196890608 8.398 19 9 16 0 199333680 1338416 1104656
14:09:12 147 2147483648 2546265920 2627772416 220382432 9.307 20 11 19 0 223787392 1393600 2011360
14:10:13 245 2147483648 2531786160 2611851264 204129984 8.680 19 10 19 0 208949840 3196016 1623840
14:11:13 176 2147483648 2534551952 2617036800 209302000 8.880 20 6 13 0 212296688 1840688 1154000
14:12:14 454 2147483648 2552833264 2635440128 220447664 9.309 20 8 16 0 228338992 6461216 1430112
14:13:15 145 2147483648 2533474624 2611142656 198588656 8.464 19 13 26 0 210864368 9870176 2405536
14:14:15 196 2147483648 2550889392 2631647232 218591536 9.238 20 10 20 0 227691936 7362176 1738224
14:15:16 275 2147483648 2549997056 2635563008 223630912 9.431 20 8 13 1 227428832 2722656 1075264
14:16:17 363 2147483648 2543300304 2623590400 210938224 8.944 20 10 21 0 220766192 7971840 1856128
14:17:18 237 2147483648 2544731520 2627248128 218264048 9.226 20 10 22 0 221927184 1840368 1822768
14:18:19 210 2147483648 2554122624 2636898304 221320752 9.343 20 15 30 0 231164896 7446160 2397984
14:19:20 271 2147483648 2547019456 2628239360 215790096 9.130 20 14 28 0 224465808 6239232 2436480
14:20:21 460 2147483648 2545015904 2626420736 209969920 8.906 20 8 16 0 219272240 7973776 1328544
14:21:21 214 2147483648 2550049568 2634633216 219621936 9.278 20 8 15 0 226488592 5809232 1057424
14:22:22 360 2147483648 2547151232 2632937472 210849248 8.940 19 11 20 0 219355104 7068720 1437136
14:23:22 689 2147483648 2543464368 2622685184 209220352 8.877 20 15 30 0 220064720 8481344 2363024
14:24:24 416 2147483648 2550580528 2635841536 221283440 9.341 20 9 19 0 228788592 6114048 1391104
14:25:24 122 2147483648 2566686960 2648494080 219953872 9.290 20 15 33 0 243149904 20017456 3178576
14:26:25 148 2147483648 2537541712 2616991744 203839264 8.669 20 10 20 0 214763008 8466720 2457024
14:27:25 247 2147483648 2543590368 2624765952 212290928 8.996 20 12 24 0 220229536 6056528 1882080
14:28:26 489 2147483648 2551196464 2632876032 219473616 9.272 20 11 22 1 228042752 6707440 1861696
14:29:27 186 2147483648 2549703568 2631385088 213708192 9.050 20 9 19 0 227619472 12373584 1537696
14:30:28 185 2147483648 2543566352 2622619648 210489952 8.926 20 13 28 0 219438672 6448576 2500144
14:31:29 140 2147483648 2567208592 2648858624 220966672 9.329 20 14 28 0 242764208 19007632 2789904
14:32:29 188 2147483648 2555015008 2637828096 223585584 9.429 20 15 30 0 231493328 4816832 3090912
14:33:30 204 2147483648 2541840688 2625466368 206978864 8.790 20 8 16 0 218945376 10582960 1383552
14:34:31 142 2147483648 2547953904 2628898816 214446752 9.079 20 12 24 0 224079872 7677728 1955392
14:35:31 621 2147483648 2554014416 2635980800 219434832 9.270 20 13 27 0 228708896 7090368 2183696
14:36:34 437 2147483648 2546630432 2626387968 209606400 8.892 20 13 26 1 219234160 7401408 2226352
14:37:35 142 2147483648 2550749456 2631610368 213226704 9.032 20 11 22 0 225823808 11022752 1574352
14:38:36 184 2147483648 2552977776 2638426112 214713904 9.089 20 9 18 0 229406464 13130944 1561616
14:39:37 431 2147483648 2547376096 2630725632 213670736 9.049 20 15 29 0 222520288 6690000 2159552
14:40:38 214 2147483648 2547755456 2630868992 215815648 9.131 20 9 16 0 223692784 6458288 1418848
14:41:41 735 2147483648 2543691600 2626002944 214972960 9.099 20 8 14 0 219172144 2800112 1399072
14:42:43 199 2147483648 2538685424 2618609664 208122848 8.835 20 12 24 1 214539504 4250480 2166176
14:43:43 1020 2147483648 2550368800 2633707520 218846960 9.248 20 9 19 0 225805968 5600480 1358528
14:44:45 150 2147483648 2544616288 2629607424 214160768 9.068 20 7 14 0 219908160 4593008 1154384
14:45:45 151 2147483648 2540821744 2633998336 211848848 8.979 20 4 8 0 217368464 4890944 628672
14:46:46 353 2147483648 2544897200 2631110656 218201360 9.223 20 11 20 0 223021392 3716832 1103200
14:47:46 418 2147483648 2558250048 2638413824 205410480 8.730 19 10 20 0 234656960 27317520 1928960
14:48:47 116 2147483648 2555698064 2638536704 221025904 9.331 20 11 22 0 231485184 8896080 1563200
14:49:47 212 2147483648 2538510896 2620592128 209160096 8.875 20 10 19 0 213893968 3202608 1531264
14:50:48 276 2147483648 2575850720 2659655680 218625312 9.239 20 11 22 0 251237072 30373312 2238448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 06-11-2026 14:51:28 to 06-11-2026 14:51:43.

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 06-11-2026 14:51:43 to 06-11-2026 14:51:44.

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          188481
MON$OLDEST_ACTIVE               189637
MON$OLDEST_SNAPSHOT             189637
MON$NEXT_TRANSACTION            189637
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-06 11:00:12.4280 GMT
MON$PAGES                       126514
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                        {41A5C999-F553-4B1B-A3CC-2C79511571A6}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             517
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3338 Firebird 4.0 6329bc9
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3338 Firebird 4.0 6329bc9/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    Fri Nov  6 14:50:58 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
--- end of diff output ---

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

06.11.26 14:51:45. 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-06 14:51:46 No severe PSQL-related problems occured
06.11.26 14:51:47. End of report.