Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 04.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 4d
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 1709140 kB
MemAvailable 7275880 kB
Buffers 87380 kB
Cached 5565696 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-04 14:50:57
DTS_END                         2026-11-04 14:50:57.1230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/38306
TRN_ID                          185172
ATT_ID                          395
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: 11090.60 900 554530
customer order: creation 549.36 57 27468
customer order: refuse 44.78 45 2239
order to supplier: creation 138.86 239 6943
order to supplier: removal 10.30 7876 515
invoice (draft): creation 139.66 392 6983
invoice (draft): removal 92.48 142 4624
invoice accept: apply 119.48 1635 5974
invoice accept: cancel 76.90 205 3845
customer reserve: creation 5406.74 30 270337
customer reserve: removal 3694.14 15 184707
realization accept: apply 252.28 48 12614
realization accept: cancel 138.96 22 6948
payment from customer: creation 181.90 46 9095
payment from customer: removal 17.38 24 869
payment to supplier: creation 151.00 38 7550
payment to supplier: removal 10.54 23 527
service: total inventory turnovers 18.26 1811 913
service: total monetary turnovers 43.26 11 2163
service: aggregate perf. data 4.28 1602 214
service: refresh index statistics 0.04 3735 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-11-2026 14:51:19 to 04-11-2026 14:51:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5408
TEST_TIME 2 6625
TEST_TIME 3 7244
TEST_TIME 4 7738
TEST_TIME 5 8062
TEST_TIME 6 8364
TEST_TIME 7 8664
TEST_TIME 8 8840
TEST_TIME 9 8888
TEST_TIME 10 9002
TEST_TIME 11 8989
TEST_TIME 12 9110
TEST_TIME 13 9222
TEST_TIME 14 9420
TEST_TIME 15 9404
TEST_TIME 16 9521
TEST_TIME 17 9627
TEST_TIME 18 9617
TEST_TIME 19 9766
TEST_TIME 20 9870
TEST_TIME 21 9787
TEST_TIME 22 9806
TEST_TIME 23 9944
TEST_TIME 24 10010
TEST_TIME 25 10073
TEST_TIME 26 10165
TEST_TIME 27 10234
TEST_TIME 28 10239
TEST_TIME 29 10152
TEST_TIME 30 10232
TEST_TIME 31 10339
TEST_TIME 32 10416
TEST_TIME 33 10566
TEST_TIME 34 10604
TEST_TIME 35 10718
TEST_TIME 36 10732
TEST_TIME 37 10761
TEST_TIME 38 10861
TEST_TIME 39 10914
TEST_TIME 40 10934
TEST_TIME 41 10871
TEST_TIME 42 10863
TEST_TIME 43 10953
TEST_TIME 44 11000
TEST_TIME 45 11049
TEST_TIME 46 11048
TEST_TIME 47 11089
TEST_TIME 48 11084
TEST_TIME 49 11095
TEST_TIME 50 11091

Performance per minute, chart


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

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 824649 824649 0 0.00 0 1795 3 0 0
doc_list_biud 824649 824649 0 0.00 0 4060 5 0 0
sp_add_invoice_to_stock 5974 5974 0 0.00 8 15087 1636 0 0
sp_cancel_adding_invoice 3845 3845 0 0.00 2 5345 205 0 0
sp_cancel_client_order 2239 2239 0 0.00 3 1214 46 0 0
sp_cancel_customer_reserve 184707 184707 0 0.00 1 1899 16 0 0
sp_cancel_pay_from_customer 869 869 0 0.00 2 724 25 0 0
sp_cancel_pay_to_supplier 527 527 0 0.00 2 939 23 0 0
sp_cancel_supplier_invoice 4624 4624 0 0.00 1 2861 143 0 0
sp_cancel_supplier_order 515 515 0 0.00 5 48150 7876 0 0
sp_cancel_write_off 6948 6948 0 0.00 1 611 23 0 0
sp_client_order 27468 27468 0 0.00 3 2037 57 0 0
sp_customer_reserve 270337 270337 0 0.00 0 3310 30 0 0
sp_fill_shopping_cart 41394 41394 0 0.00 1 2667 23 0 0
sp_fill_shopping_cart_clo_res 270337 270337 0 0.00 0 1588 2 0 0
sp_get_clo_for_invoice 5974 5974 0 0.00 0 1464 33 0 0
sp_kill_cost_storno 12189 12189 0 0.00 0 919 11 0 0
sp_kill_qstorno_ret_qs2qd 381501 381501 0 0.00 0 4059 8 0 0
sp_kill_qty_storno 221466 221466 0 0.00 0 4060 18 0 0
sp_lock_selected_doc 25900 25900 0 0.00 0 420 2 0 0
sp_make_cost_storno 35233 35233 0 0.00 0 921 9 0 0
sp_multiply_rows_for_pdistr 35233 35233 0 0.00 0 1137 13 0 0
sp_multiply_rows_for_qdistr 27468 27468 0 0.00 0 1155 21 0 0
sp_pay_from_customer 9095 9095 0 0.00 2 903 47 0 0
sp_pay_to_supplier 7550 7550 0 0.00 3 1161 39 0 0
sp_payment_common 16645 16645 0 0.00 1 730 11 0 0
sp_qd_handle_on_cancel_clo 2239 2239 0 0.00 0 1209 29 0 0
sp_qd_handle_on_invoice_upd_sts 9819 9819 0 0.00 0 2214 67 0 0
sp_qd_handle_on_reserve_upd_sts 12614 12614 0 0.00 0 1555 14 0 0
sp_reserve_write_off 12614 12614 0 0.00 3 1562 48 0 0
sp_supplier_invoice 6983 6983 0 0.00 6 7165 393 0 0
sp_supplier_order 6943 6943 0 0.00 5 3378 240 0 0
srv_aggregate_perf_data 214 214 0 0.00 31 12095 1603 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1753 332 0 0
srv_find_qd_qs_mism 514037 514037 0 0.00 0 1795 2 0 0
srv_make_invnt_saldo 913 913 0 0.00 1 7737 1812 0 0
srv_make_money_saldo 2163 2163 0 0.00 0 446 12 0 0
srv_recalc_idx_stat 2 2 0 0.00 184 7286 3735 0 0
v_add_invoice_to_stock 11948 11948 0 0.00 0 714 3 0 0
v_all_customers 42070 42070 0 0.00 0 151 1 0 0
v_all_suppliers 33982 33982 0 0.00 0 61 1 0 0
v_all_wares 54936 54936 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 1030 1030 0 0.00 0 345 2 0 0
v_cancel_client_order 4478 4478 0 0.00 0 445 2 0 0
v_cancel_customer_prepayment 1738 1738 0 0.00 0 382 2 0 0
v_cancel_customer_reserve 1832 1832 0 0.00 0 969 3 0 0
v_cancel_payment_to_supplier 1054 1054 0 0.00 0 403 2 0 0
v_cancel_supplier_invoice 906 906 0 0.00 0 354 4 0 0
v_cancel_supplier_order 1030 1030 0 0.00 0 524 3 0 0
v_cancel_write_off 2556 2556 0 0.00 0 250 2 0 0
v_max_id_clo_ord 6943 6943 0 0.00 0 189 1 0 0
v_max_id_clo_res 1210 1210 0 0.00 0 292 2 0 0
v_max_id_ord_sup 6983 6983 0 0.00 0 1327 2 0 0
v_max_non_paid_invoice 4485 4485 0 0.00 0 80 2 0 0
v_max_non_paid_realizn 8691 8691 0 0.00 0 180 2 0 0
v_min_id_clo_ord 6943 6943 0 0.00 0 760 3 0 0
v_min_id_clo_res 1210 1210 0 0.00 0 966 6 0 0
v_min_id_ord_sup 6983 6983 0 0.00 0 2379 11 0 0
v_min_non_paid_invoice 7550 7550 0 0.00 0 613 4 0 0
v_min_non_paid_realizn 9095 9095 0 0.00 0 678 7 0 0
v_our_firm 13674 13674 0 0.00 0 44 1 0 0
v_reserve_write_off 25228 25228 0 0.00 0 946 2 0 0
x_lock_depdocs_on_canc_invoice 8016 8016 0 0.00 0 657 9 0 0
x_lock_depdocs_on_canc_sup_ord 515 515 0 0.00 0 218 10 0 0
x_make_qstorno_1000_1200 6943 6943 0 0.00 1 3302 179 0 0
x_make_qstorno_1200_2000 6983 6983 0 0.00 2 6488 338 0 0
x_make_qstorno_2100_3300 270337 270337 0 0.00 0 3309 26 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2026 14:51:25 to 04-11-2026 14:51:29.

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:02 3 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
14:02:02 376 2147483648 2546098016 2626252800 222204016 9.376 20 7 10 0 224392784 723456 1465312
14:03:03 180 2147483648 2539568816 2618265600 215708240 9.127 20 8 17 0 218156896 1043472 1405184
14:04:04 374 2147483648 2547586480 2628034560 220484448 9.311 20 11 24 0 224747312 2180320 2082544
14:05:05 279 2147483648 2543114400 2621411328 217678960 9.203 20 8 18 0 220600208 1318304 1602944
14:06:05 251 2147483648 2530001376 2608357376 206597184 8.776 19 7 14 0 208930592 1274464 1058944
14:07:06 303 2147483648 2542874272 2622578688 215124144 9.105 20 9 15 0 219107728 3062336 921248
14:08:07 643 2147483648 2536552368 2617614336 208053008 8.832 19 10 20 0 215730112 5937664 1739440
14:09:08 391 2147483648 2544388832 2621984768 211890640 8.980 20 12 25 0 219898432 5734864 2272928
14:10:09 851 2147483648 2547930336 2628497408 219698688 9.281 20 9 20 0 223413728 2180000 1535040
14:11:10 212 2147483648 2526239248 2604699648 198762656 8.471 19 12 27 0 204428064 3476192 2189216
14:12:11 283 2147483648 2533469760 2613997568 208862064 8.863 20 6 12 0 210986160 1012864 1111232
14:13:12 226 2147483648 2562300512 2650271744 222051040 9.371 20 8 17 0 240733744 17263232 1419472
14:14:13 283 2147483648 2542238224 2625007616 213342048 9.036 20 7 12 1 219344208 4902384 1099776
14:15:14 186 2147483648 2532547040 2615513088 207507072 8.811 20 5 8 0 210346896 2035728 804096
14:16:15 258 2147483648 2545855328 2627506176 219792928 9.284 20 15 30 0 222859136 1121440 1944768
14:17:15 182 2147483648 2549310384 2631753728 218035616 9.217 20 9 20 0 226202720 6592704 1574400
14:18:16 213 2147483648 2532637328 2610974720 202294848 8.609 19 11 21 0 210035280 5987296 1753136
14:19:17 155 2147483648 2555439536 2637221888 216990016 9.177 20 12 23 0 232826240 13990224 1846000
14:20:17 232 2147483648 2542676976 2623004672 213265648 9.033 20 10 20 0 219303600 4325088 1712864
14:21:18 553 2147483648 2538496688 2619904000 211547328 8.967 20 5 10 0 216458624 4192896 718400
14:22:19 477 2147483648 2549299408 2629992448 212289632 8.996 20 16 35 0 227122576 11623392 3209552
14:23:20 221 2147483648 2556236832 2639912960 216426512 9.155 20 7 14 0 232441792 14640064 1375216
14:24:20 185 2147483648 2544766192 2628046848 216395744 9.154 20 11 22 0 221522384 3533424 1593216
14:25:21 198 2147483648 2549104240 2632531968 218830336 9.247 20 11 22 0 225949488 5343264 1775888
14:26:21 124 2147483648 2546878784 2632564736 215943696 9.136 20 13 28 0 227336880 9303568 2089616
14:27:22 228 2147483648 2573584000 2655715328 220586592 9.315 20 12 24 0 250089584 27236064 2266928
14:28:25 210 2147483648 2552622032 2635264000 214669248 9.087 20 12 25 0 228985472 11973952 2342272
14:29:25 379 2147483648 2537124416 2617491456 207576192 8.814 20 12 25 0 213135136 3614896 1944048
14:30:26 322 2147483648 2553769888 2638012416 217033120 9.178 20 8 16 0 230159472 11796128 1330224
14:31:27 139 2147483648 2565575424 2648354816 218828528 9.247 20 10 20 0 241877968 21390928 1658512
14:32:27 280 2147483648 2550598832 2640351232 217338960 9.190 20 5 10 0 226528096 8558752 630384
14:33:28 343 2147483648 2550634064 2633175040 218490192 9.234 20 14 27 0 226290224 5721936 2078096
14:34:29 173 2147483648 2546830368 2629607424 216964208 9.176 20 9 19 1 222473104 3642736 1866160
14:35:29 279 2147483648 2550078176 2641543168 218923344 9.251 20 13 26 0 227996496 6642592 2430560
14:36:29 220 2147483648 2560897648 2642259968 217760880 9.206 20 16 32 0 235626240 15058576 2806784
14:37:30 181 2147483648 2556386112 2637811712 213185968 9.030 20 12 24 0 232447936 17424256 1837712
14:38:31 473 2147483648 2543219120 2624114688 213604656 9.046 20 11 21 0 220604304 5360944 1638704
14:39:32 249 2147483648 2554393280 2634588160 215611920 9.124 20 9 18 0 229826592 12731344 1483328
14:40:32 1753 2147483648 2561664592 2644893696 215388656 9.115 20 10 20 0 237196192 20093648 1713888
14:41:35 300 2147483648 2553153904 2637299712 218520096 9.235 20 11 22 0 229050000 8875952 1653952
14:42:35 492 2147483648 2545760256 2628280320 217185120 9.184 20 13 26 0 223386496 3686288 2515088
14:43:36 497 2147483648 2546165936 2643283968 207687232 8.818 20 12 24 0 233336176 23756752 1892192
14:44:40 463 2147483648 2576689008 2658689024 217955008 9.214 20 13 25 0 251556048 31247904 2353136
14:45:41 343 2147483648 2549227152 2631172096 216467520 9.157 20 13 24 1 223523120 5192528 1863072
14:46:41 311 2147483648 2545930608 2630410240 218581904 9.238 20 10 19 0 222964848 2740080 1642864
14:47:42 285 2147483648 2545384640 2631249920 198761840 8.471 19 10 20 0 216372544 15883440 1727264
14:48:43 197 2147483648 2542560400 2622701568 209080000 8.872 20 12 23 0 217806480 6886896 1839584
14:49:43 390 2147483648 2546383744 2631434240 215700608 9.127 20 9 18 0 224474848 7214000 1560240
14:50:44 239 2147483648 2547515904 2631196672 215380704 9.115 20 10 18 0 222714864 6084736 1249424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 04-11-2026 14:51:30 to 04-11-2026 14:51:46.

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 04-11-2026 14:51:47 to 04-11-2026 14:51:48.

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          185623
MON$OLDEST_ACTIVE               185624
MON$OLDEST_SNAPSHOT             185624
MON$NEXT_TRANSACTION            185624
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-04 11:00:12.1490 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                        {E194A62B-D9FC-4681-8CDB-43388DB5BC96}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             511
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 ---
--- end of diff output ---

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

04.11.26 14:51:49. 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-04 14:51:50 No severe PSQL-related problems occured
04.11.26 14:51:51. End of report.