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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2w 4d
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 1876920 kB
MemAvailable 7316840 kB
Buffers 80364 kB
Cached 5439120 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-18 20:50:49
DTS_END                         2026-11-18 20:50:49.5610
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/40322
TRN_ID                          219808
ATT_ID                          458
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: 14799.80 955 739990
customer order: creation 646.80 49 32340
customer order: refuse 53.50 48 2675
order to supplier: creation 165.30 226 8265
order to supplier: removal 12.08 9488 604
invoice (draft): creation 166.24 400 8312
invoice (draft): removal 120.42 151 6021
invoice accept: apply 142.02 1589 7101
invoice accept: cancel 99.64 212 4982
customer reserve: creation 7146.18 26 357309
customer reserve: removal 5259.10 15 262955
realization accept: apply 304.76 37 15238
realization accept: cancel 176.04 21 8802
payment from customer: creation 217.76 34 10888
payment from customer: removal 21.20 19 1060
payment to supplier: creation 175.58 30 8779
payment to supplier: removal 12.06 16 603
service: total inventory turnovers 23.64 1409 1182
service: total monetary turnovers 52.12 14 2606
service: aggregate perf. data 5.32 1841 266
service: refresh index statistics 0.04 3474 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-11-2026 20:51:05 to 18-11-2026 20:51:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9360
TEST_TIME 2 11110
TEST_TIME 3 11686
TEST_TIME 4 12156
TEST_TIME 5 12570
TEST_TIME 6 12724
TEST_TIME 7 12845
TEST_TIME 8 13057
TEST_TIME 9 13089
TEST_TIME 10 13258
TEST_TIME 11 13273
TEST_TIME 12 13380
TEST_TIME 13 13456
TEST_TIME 14 13596
TEST_TIME 15 13640
TEST_TIME 16 13763
TEST_TIME 17 13645
TEST_TIME 18 13831
TEST_TIME 19 13826
TEST_TIME 20 13859
TEST_TIME 21 13984
TEST_TIME 22 14035
TEST_TIME 23 13991
TEST_TIME 24 14158
TEST_TIME 25 14222
TEST_TIME 26 14224
TEST_TIME 27 14216
TEST_TIME 28 14224
TEST_TIME 29 14269
TEST_TIME 30 14274
TEST_TIME 31 14286
TEST_TIME 32 14270
TEST_TIME 33 14382
TEST_TIME 34 14445
TEST_TIME 35 14474
TEST_TIME 36 14472
TEST_TIME 37 14480
TEST_TIME 38 14584
TEST_TIME 39 14530
TEST_TIME 40 14515
TEST_TIME 41 14582
TEST_TIME 42 14574
TEST_TIME 43 14658
TEST_TIME 44 14709
TEST_TIME 45 14748
TEST_TIME 46 14753
TEST_TIME 47 14776
TEST_TIME 48 14866
TEST_TIME 49 14856
TEST_TIME 50 14800

Performance per minute, chart


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

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 1091424 1091424 0 0.00 0 972 2 0 0
doc_list_biud 1091424 1091424 0 0.00 0 1710 5 0 0
sp_add_invoice_to_stock 7101 7101 0 0.00 8 13937 1590 0 0
sp_cancel_adding_invoice 4982 4982 0 0.00 4 5801 213 0 0
sp_cancel_client_order 2675 2675 0 0.00 3 861 48 0 0
sp_cancel_customer_reserve 262955 262955 0 0.00 1 1711 16 0 0
sp_cancel_pay_from_customer 1060 1060 0 0.00 2 336 19 0 0
sp_cancel_pay_to_supplier 603 603 0 0.00 2 238 17 0 0
sp_cancel_supplier_invoice 6021 6021 0 0.00 2 1367 152 0 0
sp_cancel_supplier_order 604 604 0 0.00 7 53526 9488 0 0
sp_cancel_write_off 8802 8802 0 0.00 1 830 21 0 0
sp_client_order 32340 32340 0 0.00 4 1289 49 0 0
sp_customer_reserve 357309 357309 0 0.00 0 2049 27 0 0
sp_fill_shopping_cart 48917 48917 0 0.00 1 1969 23 0 0
sp_fill_shopping_cart_clo_res 357309 357309 0 0.00 0 1173 2 0 0
sp_get_clo_for_invoice 7101 7101 0 0.00 0 1458 39 0 0
sp_kill_cost_storno 15447 15447 0 0.00 0 574 10 0 0
sp_kill_qstorno_ret_qs2qd 541337 541337 0 0.00 0 1709 8 0 0
sp_kill_qty_storno 308378 308378 0 0.00 0 1710 18 0 0
sp_lock_selected_doc 31034 31034 0 0.00 0 399 2 0 0
sp_make_cost_storno 42006 42006 0 0.00 0 758 8 0 0
sp_multiply_rows_for_pdistr 42006 42006 0 0.00 0 497 10 0 0
sp_multiply_rows_for_qdistr 32340 32340 0 0.00 0 1041 19 0 0
sp_pay_from_customer 10888 10888 0 0.00 3 785 35 0 0
sp_pay_to_supplier 8779 8779 0 0.00 3 726 30 0 0
sp_payment_common 19667 19667 0 0.00 1 592 7 0 0
sp_qd_handle_on_cancel_clo 2675 2675 0 0.00 0 845 32 0 0
sp_qd_handle_on_invoice_upd_sts 12083 12083 0 0.00 0 1701 79 0 0
sp_qd_handle_on_reserve_upd_sts 15238 15238 0 0.00 0 1322 11 0 0
sp_reserve_write_off 15238 15238 0 0.00 3 1334 38 0 0
sp_supplier_invoice 8312 8312 0 0.00 6 4511 400 0 0
sp_supplier_order 8265 8265 0 0.00 5 2125 226 0 0
srv_aggregate_perf_data 266 266 0 0.00 100 10607 1842 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 619 203 0 0
srv_find_qd_qs_mism 689236 689236 0 0.00 0 950 1 0 0
srv_make_invnt_saldo 1182 1182 0 0.00 0 4859 1410 0 0
srv_make_money_saldo 2606 2606 0 0.00 0 275 15 0 0
srv_recalc_idx_stat 2 2 0 0.00 131 6818 3475 0 0
v_add_invoice_to_stock 14202 14202 0 0.00 0 573 2 0 0
v_all_customers 49146 49146 0 0.00 0 30 1 0 0
v_all_suppliers 40490 40490 0 0.00 0 30 1 0 0
v_all_wares 64680 64680 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 1192 1192 0 0.00 0 71 2 0 0
v_cancel_client_order 5350 5350 0 0.00 0 546 2 0 0
v_cancel_customer_prepayment 2120 2120 0 0.00 0 213 1 0 0
v_cancel_customer_reserve 2074 2074 0 0.00 0 399 2 0 0
v_cancel_payment_to_supplier 1206 1206 0 0.00 0 203 1 0 0
v_cancel_supplier_invoice 1264 1264 0 0.00 0 230 3 0 0
v_cancel_supplier_order 1208 1208 0 0.00 0 163 2 0 0
v_cancel_write_off 2976 2976 0 0.00 0 324 2 0 0
v_max_id_clo_ord 8265 8265 0 0.00 0 51 1 0 0
v_max_id_clo_res 1473 1473 0 0.00 0 186 1 0 0
v_max_id_ord_sup 8312 8312 0 0.00 0 788 2 0 0
v_max_non_paid_invoice 5111 5111 0 0.00 0 35 1 0 0
v_max_non_paid_realizn 10516 10516 0 0.00 0 74 1 0 0
v_min_id_clo_ord 8265 8265 0 0.00 0 360 2 0 0
v_min_id_clo_res 1473 1473 0 0.00 0 704 4 0 0
v_min_id_ord_sup 8312 8312 0 0.00 0 1074 4 0 0
v_min_non_paid_invoice 8779 8779 0 0.00 0 586 2 0 0
v_min_non_paid_realizn 10888 10888 0 0.00 0 589 2 0 0
v_our_firm 16278 16278 0 0.00 0 21 1 0 0
v_reserve_write_off 30476 30476 0 0.00 0 444 1 0 0
x_lock_depdocs_on_canc_invoice 10371 10371 0 0.00 0 1554 12 0 0
x_lock_depdocs_on_canc_sup_ord 604 604 0 0.00 0 97 13 0 0
x_make_qstorno_1000_1200 8265 8265 0 0.00 1 2113 164 0 0
x_make_qstorno_1200_2000 8312 8312 0 0.00 1 4412 350 0 0
x_make_qstorno_2100_3300 357309 357309 0 0.00 0 2049 23 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 18-11-2026 20:51:11 to 18-11-2026 20:51:14.

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
20:00:53 2 2147483648 2309418672 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
20:01:53 267 2147483648 2501752112 2568761344 177568752 7.637 18 11 25 0 181356864 1244000 2544112
20:02:54 150 2147483648 2549814816 2628558848 223331088 9.420 20 13 24 0 226680000 1483808 1865104
20:03:54 163 2147483648 2546354656 2626596864 219537328 9.274 20 11 20 0 223465632 2463136 1465168
20:04:55 165 2147483648 2545453360 2625298432 216920432 9.174 20 10 20 0 222725872 3867840 1937600
20:05:55 149 2147483648 2548187920 2628685824 217802080 9.208 20 12 23 0 225776224 6007648 1966496
20:06:56 124 2147483648 2544678352 2625388544 218465568 9.233 20 10 18 0 222341888 2079808 1796512
20:07:56 294 2147483648 2543631536 2621095936 211663536 8.972 20 14 28 0 221483504 7255664 2564304
20:08:57 187 2147483648 2545284080 2626473984 216099488 9.142 20 10 20 0 221748336 3700384 1948464
20:09:57 220 2147483648 2545252560 2626871296 215283632 9.111 20 12 24 0 222040320 4621456 2135232
20:10:58 217 2147483648 2547333808 2628173824 215539104 9.121 20 11 23 0 223727104 5967792 2220208
20:11:58 228 2147483648 2557340112 2641530880 219480176 9.272 20 11 23 0 234074816 12661808 1932832
20:12:59 202 2147483648 2537824816 2619400192 204154768 8.681 20 13 26 0 214831104 8574528 2101808
20:13:59 144 2147483648 2557947984 2638626816 218252784 9.225 20 17 38 1 234972640 13522384 3197472
20:14:59 170 2147483648 2551798448 2633822208 219392096 9.269 20 12 24 0 227384096 5972288 2019712
20:16:00 229 2147483648 2554506192 2636460032 217775712 9.207 20 10 21 0 231216704 11921568 1519424
20:17:00 274 2147483648 2543340656 2626973696 214139152 9.067 20 12 22 0 220866320 5091856 1635312
20:18:01 222 2147483648 2569958240 2655506432 215369744 9.114 20 13 26 0 246311808 27881136 3060928
20:19:01 166 2147483648 2551410144 2632601600 215385696 9.115 20 12 24 0 227285152 9807872 2091584
20:20:02 134 2147483648 2558844944 2639089664 219575968 9.276 20 15 29 0 234518192 12585936 2356288
20:21:03 195 2147483648 2560498752 2640375808 212036544 8.986 20 14 28 0 237171360 22553456 2581360
20:22:03 168 2147483648 2536874352 2617487360 205417200 8.730 19 10 21 0 214048976 6660224 1971552
20:23:04 108 2147483648 2536683936 2619121664 207330880 8.804 20 9 15 2 213688352 4859376 1498096
20:24:04 161 2147483648 2557442208 2637967360 214879376 9.095 20 12 24 0 232981152 15346848 2754928
20:25:04 157 2147483648 2552512208 2638733312 215253296 9.110 20 9 18 0 227423648 10673616 1496736
20:26:05 126 2147483648 2547458000 2629181440 216113808 9.143 20 11 22 0 222892912 4630560 2148544
20:27:05 535 2147483648 2549248944 2629750784 217456544 9.195 20 11 23 0 223855344 4797664 1601136
20:28:06 140 2147483648 2550280592 2631524352 216529120 9.159 20 12 24 1 226550512 8243424 1777968
20:29:07 170 2147483648 2559617712 2643525632 212121392 8.989 20 10 20 0 235976704 22428336 1426976
20:30:07 604 2147483648 2558688896 2646990848 218599696 9.238 20 15 31 1 241876176 20252160 3024320
20:31:08 138 2147483648 2565602768 2647076864 217322688 9.189 20 14 28 0 240874560 20959408 2592464
20:32:08 278 2147483648 2559508976 2642288640 220258272 9.302 20 13 27 0 238852992 15480256 3114464
20:33:09 172 2147483648 2562531728 2644119552 216085360 9.142 20 13 26 0 238479600 19960496 2433744
20:34:09 285 2147483648 2553903552 2637299712 212959504 9.022 20 10 19 0 229229248 15068864 1200880
20:35:10 223 2147483648 2536284064 2616872960 203022384 8.637 19 9 18 0 213045184 8041712 1981088
20:36:11 115 2147483648 2550748240 2635714560 217673216 9.203 20 10 18 0 227470672 8261952 1535504
20:37:11 331 2147483648 2546831952 2625789952 212894592 9.019 20 18 35 0 220249104 4412112 2942400
20:38:11 178 2147483648 2564684256 2653569024 217022704 9.178 20 11 22 0 240308400 21320368 1965328
20:39:12 171 2147483648 2554525216 2641821696 212507664 9.004 20 8 16 0 230392704 16676016 1209024
20:40:12 159 2147483648 2548838592 2630815744 214687184 9.088 20 14 23 1 223954224 7526528 1740512
20:41:13 148 2147483648 2560957728 2640797696 209856016 8.902 20 16 31 0 235951648 23630224 2465408
20:42:13 134 2147483648 2545664512 2627649536 214311232 9.074 20 14 26 0 221492096 5024160 2156704
20:43:13 244 2147483648 2574553552 2656677888 218392400 9.230 20 13 26 0 249363504 28777392 2193712
20:44:14 236 2147483648 2564795792 2647719936 216382496 9.153 20 13 26 0 239022864 20720144 1920224
20:45:15 218 2147483648 2567172160 2652971008 218950976 9.252 20 10 20 1 243072688 22444368 1677344
20:46:15 132 2147483648 2544801328 2625400832 209875024 8.902 20 13 26 0 220206272 8134400 2196848
20:47:15 127 2147483648 2546772848 2639556608 216792224 9.169 20 8 16 0 223674320 5415520 1466576
20:48:16 245 2147483648 2564725632 2646855680 216642432 9.163 20 14 27 0 240662192 21864176 2155584
20:49:16 119 2147483648 2561834704 2642755584 219528048 9.274 20 11 22 0 236837776 14792368 2517360
20:50:16 135 2147483648 2563006528 2646802432 214247456 9.071 20 10 19 0 238462608 22697168 1517984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 18-11-2026 20:51:15 to 18-11-2026 20:51:27.

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 18-11-2026 20:51:28 to 18-11-2026 20: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          219996
MON$OLDEST_ACTIVE               219997
MON$OLDEST_SNAPSHOT             219997
MON$NEXT_TRANSACTION            219997
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-18 17:00:10.7680 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                        {6541EE17-BD2C-4890-860F-AC059D72CE3C}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             566
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3342 Firebird 4.0 a02a946
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3342 Firebird 4.0 a02a946"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3342 Firebird 4.0 a02a946/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3342 Firebird 4.0 a02a946/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    Wed Nov 18 20:50:50 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'

18.11.26 20:51:29. 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-18 20:51:31 No severe PSQL-related problems occured
18.11.26 20:51:31. End of report.