Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 12.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 5d
Command: who -b
bootup_info system boot 2026-11-09 10:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138016 kB
MemFree 1988236 kB
MemAvailable 7304368 kB
Buffers 80196 kB
Cached 5356656 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-12 08:50:49
DTS_END                         2026-11-12 08:50:49.1890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(58:5) ==> X_MAKE_QSTORNO_1000_1200(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/58716
TRN_ID                          225269
ATT_ID                          463
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: 14055.28 832 702764
customer order: creation 662.32 47 33116
customer order: refuse 55.10 47 2755
order to supplier: creation 170.10 210 8505
order to supplier: removal 12.16 8155 608
invoice (draft): creation 164.90 351 8245
invoice (draft): removal 114.74 138 5737
invoice accept: apply 142.94 1528 7147
invoice accept: cancel 95.14 212 4757
customer reserve: creation 6737.92 27 336896
customer reserve: removal 4899.60 14 244980
realization accept: apply 312.26 39 15613
realization accept: cancel 165.18 21 8259
payment from customer: creation 223.88 39 11194
payment from customer: removal 19.94 19 997
payment to supplier: creation 181.70 32 9085
payment to supplier: removal 12.56 19 628
service: total inventory turnovers 24.10 1358 1205
service: total monetary turnovers 55.94 14 2797
service: aggregate perf. data 4.76 1803 238
service: refresh index statistics 0.04 2572 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 12-11-2026 08:51:03 to 12-11-2026 08:51:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7247
TEST_TIME 2 9196
TEST_TIME 3 10201
TEST_TIME 4 10734
TEST_TIME 5 10824
TEST_TIME 6 11176
TEST_TIME 7 11457
TEST_TIME 8 11667
TEST_TIME 9 11758
TEST_TIME 10 12138
TEST_TIME 11 12277
TEST_TIME 12 12345
TEST_TIME 13 12458
TEST_TIME 14 12609
TEST_TIME 15 12671
TEST_TIME 16 12782
TEST_TIME 17 12778
TEST_TIME 18 12886
TEST_TIME 19 12893
TEST_TIME 20 13052
TEST_TIME 21 13013
TEST_TIME 22 13132
TEST_TIME 23 13148
TEST_TIME 24 13184
TEST_TIME 25 13232
TEST_TIME 26 13232
TEST_TIME 27 13279
TEST_TIME 28 13287
TEST_TIME 29 13329
TEST_TIME 30 13373
TEST_TIME 31 13483
TEST_TIME 32 13536
TEST_TIME 33 13498
TEST_TIME 34 13421
TEST_TIME 35 13432
TEST_TIME 36 13501
TEST_TIME 37 13534
TEST_TIME 38 13610
TEST_TIME 39 13686
TEST_TIME 40 13729
TEST_TIME 41 13844
TEST_TIME 42 13908
TEST_TIME 43 13880
TEST_TIME 44 13892
TEST_TIME 45 13937
TEST_TIME 46 13993
TEST_TIME 47 14002
TEST_TIME 48 13988
TEST_TIME 49 14108
TEST_TIME 50 14055

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-11-2026 08:51:05 to 12-11-2026 08:51:08.

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 1038472 1038472 0 0.00 0 1308 2 0 0
doc_list_biud 1038472 1038472 0 0.00 0 5055 5 0 0
sp_add_invoice_to_stock 7147 7147 0 0.00 6 15808 1529 0 0
sp_cancel_adding_invoice 4757 4757 0 0.00 3 5399 212 0 0
sp_cancel_client_order 2755 2755 0 0.00 3 1469 48 0 0
sp_cancel_customer_reserve 244980 244980 0 0.00 1 1983 15 0 0
sp_cancel_pay_from_customer 997 997 0 0.00 2 611 20 0 0
sp_cancel_pay_to_supplier 628 628 0 0.00 2 567 19 0 0
sp_cancel_supplier_invoice 5737 5737 0 0.00 1 2176 138 0 0
sp_cancel_supplier_order 608 608 0 0.00 5 51012 8156 0 0
sp_cancel_write_off 8259 8259 0 0.00 1 1588 21 0 0
sp_client_order 33116 33116 0 0.00 4 1495 47 0 0
sp_customer_reserve 336896 336896 0 0.00 0 2559 27 0 0
sp_fill_shopping_cart 49866 49866 0 0.00 1 2553 21 0 0
sp_fill_shopping_cart_clo_res 336896 336896 0 0.00 0 1506 2 0 0
sp_get_clo_for_invoice 7147 7147 0 0.00 0 1610 33 0 0
sp_kill_cost_storno 14641 14641 0 0.00 0 1188 9 0 0
sp_kill_qstorno_ret_qs2qd 504564 504564 0 0.00 0 5055 7 0 0
sp_kill_qty_storno 289856 289856 0 0.00 0 5055 17 0 0
sp_lock_selected_doc 31557 31557 0 0.00 0 463 2 0 0
sp_make_cost_storno 43039 43039 0 0.00 0 816 7 0 0
sp_multiply_rows_for_pdistr 43039 43039 0 0.00 0 756 11 0 0
sp_multiply_rows_for_qdistr 33116 33116 0 0.00 0 946 18 0 0
sp_pay_from_customer 11194 11194 0 0.00 3 862 40 0 0
sp_pay_to_supplier 9085 9085 0 0.00 3 820 33 0 0
sp_payment_common 20279 20279 0 0.00 1 478 10 0 0
sp_qd_handle_on_cancel_clo 2755 2755 0 0.00 0 1449 32 0 0
sp_qd_handle_on_invoice_upd_sts 11904 11904 0 0.00 0 1871 67 0 0
sp_qd_handle_on_reserve_upd_sts 15613 15613 0 0.00 0 1192 11 0 0
sp_reserve_write_off 15613 15613 0 0.00 3 1200 39 0 0
sp_supplier_invoice 8245 8245 0 0.00 5 7010 352 0 0
sp_supplier_order 8505 8505 0 0.00 5 2114 210 0 0
srv_aggregate_perf_data 238 238 0 0.00 125 10607 1804 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1123 280 0 0
srv_find_qd_qs_mism 653212 653212 0 0.00 0 1308 1 0 0
srv_make_invnt_saldo 1205 1205 0 0.00 1 4367 1359 0 0
srv_make_money_saldo 2797 2797 0 0.00 0 314 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 223 4922 2573 0 0
v_add_invoice_to_stock 14294 14294 0 0.00 0 467 2 0 0
v_all_customers 50442 50442 0 0.00 0 38 1 0 0
v_all_suppliers 41168 41168 0 0.00 0 69 1 0 0
v_all_wares 66232 66232 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 1288 1288 0 0.00 0 456 2 0 0
v_cancel_client_order 5510 5510 0 0.00 0 385 2 0 0
v_cancel_customer_prepayment 1994 1994 0 0.00 0 358 2 0 0
v_cancel_customer_reserve 2076 2076 0 0.00 0 451 2 0 0
v_cancel_payment_to_supplier 1256 1256 0 0.00 0 241 2 0 0
v_cancel_supplier_invoice 1164 1164 0 0.00 0 85 2 0 0
v_cancel_supplier_order 1216 1216 0 0.00 0 540 3 0 0
v_cancel_write_off 3090 3090 0 0.00 0 452 2 0 0
v_max_id_clo_ord 8505 8505 0 0.00 0 539 1 0 0
v_max_id_clo_res 1595 1595 0 0.00 0 304 1 0 0
v_max_id_ord_sup 8245 8245 0 0.00 0 1336 2 0 0
v_max_non_paid_invoice 5251 5251 0 0.00 0 53 2 0 0
v_max_non_paid_realizn 10827 10827 0 0.00 0 219 2 0 0
v_min_id_clo_ord 8505 8505 0 0.00 0 346 2 0 0
v_min_id_clo_res 1595 1595 0 0.00 0 553 4 0 0
v_min_id_ord_sup 8245 8245 0 0.00 0 1238 5 0 0
v_min_non_paid_invoice 9085 9085 0 0.00 0 439 4 0 0
v_min_non_paid_realizn 11194 11194 0 0.00 0 405 6 0 0
v_our_firm 16524 16524 0 0.00 0 66 1 0 0
v_reserve_write_off 31226 31226 0 0.00 0 619 2 0 0
x_lock_depdocs_on_canc_invoice 9912 9912 0 0.00 0 1360 10 0 0
x_lock_depdocs_on_canc_sup_ord 608 608 0 0.00 0 331 11 0 0
x_make_qstorno_1000_1200 8505 8505 0 0.00 1 2109 151 0 0
x_make_qstorno_1200_2000 8245 8245 0 0.00 1 6397 305 0 0
x_make_qstorno_2100_3300 336896 336896 0 0.00 0 2396 24 0 0

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

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:53 3 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
08:01:53 284 2147483648 2540664112 2621005824 217095600 9.181 20 6 11 0 218883840 1109248 678992
08:02:54 377 2147483648 2546071920 2624675840 220151856 9.298 20 13 25 0 224102416 1393856 2556704
08:03:55 196 2147483648 2542777600 2621440000 214044688 9.063 20 11 20 0 218086144 1948016 2093440
08:04:55 408 2147483648 2539645520 2617479168 211961760 8.983 20 14 27 1 217663776 2607616 3094400
08:05:56 194 2147483648 2545208720 2625277952 218480752 9.234 20 11 25 0 222101792 1598800 2022240
08:06:56 301 2147483648 2535949824 2613428224 207642640 8.816 20 16 33 1 212463520 2532528 2288352
08:07:57 365 2147483648 2548185888 2630529024 219382896 9.268 20 13 29 0 225844480 4024896 2436688
08:08:57 188 2147483648 2541998880 2622291968 210212304 8.916 20 14 29 0 218787744 6390976 2184464
08:09:58 257 2147483648 2564030960 2646282240 221469648 9.348 20 15 32 0 241693280 17399088 2824544
08:10:58 228 2147483648 2520260592 2599649280 189473664 8.107 19 7 14 0 197403712 6886096 1043952
08:11:59 267 2147483648 2531151600 2611122176 205188352 8.721 19 9 16 2 208987584 2349040 1450192
08:12:59 224 2147483648 2546564128 2627522560 216958896 9.175 20 13 24 0 222712944 3479104 2274944
08:14:00 322 2147483648 2543398560 2623639552 215493136 9.119 20 13 28 1 219001792 993952 2514704
08:15:00 187 2147483648 2544706848 2626539520 217492208 9.196 20 12 26 0 221637024 2442352 1702464
08:16:00 803 2147483648 2543036944 2622988288 213877808 9.057 20 14 27 0 220870256 5066896 1925552
08:17:01 552 2147483648 2544308848 2623524864 213929520 9.059 20 10 20 0 221571792 5762976 1879296
08:18:02 149 2147483648 2561326112 2642374656 217650320 9.202 20 12 24 0 237095424 17503312 1941792
08:19:03 156 2147483648 2544642336 2624061440 209678576 8.895 20 13 26 0 220660080 9038288 1943216
08:20:03 279 2147483648 2551639408 2631499776 199118176 8.485 18 10 20 0 225035648 24347488 1569984
08:21:04 129 2147483648 2543948448 2628698112 212353264 8.998 20 7 14 0 221670560 8112688 1204608
08:22:04 193 2147483648 2552458544 2641154048 214385072 9.076 20 11 22 0 230412464 13932640 2094752
08:23:05 464 2147483648 2559769584 2641641472 218378544 9.230 20 11 22 0 234187088 13974720 1833824
08:24:06 289 2147483648 2546164976 2623815680 197568816 8.424 18 12 24 0 218895056 18824368 2501872
08:25:06 183 2147483648 2552328928 2634752000 212691520 9.011 20 9 18 0 228694480 14274768 1728192
08:26:07 343 2147483648 2548098736 2630787072 219285408 9.265 20 13 29 3 224700544 2749248 2665888
08:27:08 125 2147483648 2548858048 2631798784 217751824 9.206 20 11 20 0 225979376 6410960 1816592
08:28:08 144 2147483648 2545440688 2631626752 212807664 9.016 20 9 18 0 222348800 7219808 2321328
08:29:09 162 2147483648 2550881280 2632531968 216949392 9.175 20 15 31 0 226745280 7271232 2524656
08:30:09 227 2147483648 2557409472 2637062144 219747968 9.282 20 15 30 1 232976592 10671248 2557376
08:31:10 135 2147483648 2562074240 2642272256 214780784 9.092 20 14 29 0 237632112 20287600 2563728
08:32:10 303 2147483648 2549932160 2631274496 215084464 9.103 20 14 26 0 225754080 8727216 1942400
08:33:11 290 2147483648 2555901088 2638741504 220629008 9.316 20 11 22 1 232711280 10287952 1794320
08:34:11 1123 2147483648 2537907168 2621034496 208327056 8.843 20 9 18 1 215006272 4896352 1782864
08:35:13 163 2147483648 2542569472 2626834432 212803248 9.015 20 9 18 0 219763072 4438928 2520896
08:36:14 135 2147483648 2558118912 2639081472 217731952 9.205 20 11 22 0 233285904 13433648 2120304
08:37:14 305 2147483648 2551328544 2632437760 213172816 9.030 20 14 28 0 227160128 11667856 2319456
08:38:15 253 2147483648 2570273328 2651533312 210507344 8.927 20 12 24 0 245501568 32896928 2097296
08:39:15 314 2147483648 2567178752 2651631616 221505328 9.350 20 13 24 0 243396720 19083456 2807936
08:40:16 123 2147483648 2551002528 2633920512 216885312 9.173 20 14 28 0 225903344 6551936 2466096
08:41:16 194 2147483648 2552904672 2652893184 217716896 9.205 20 13 24 1 229864224 10045472 2101856
08:42:16 219 2147483648 2564357584 2648453120 215730304 9.128 20 11 22 0 239538176 21928656 1879216
08:43:17 94 2147483648 2556863840 2641485824 219790896 9.284 20 8 16 0 232913968 12172368 950704
08:44:17 221 2147483648 2543208672 2624757760 213792240 9.054 20 10 19 0 218882096 3218192 1871664
08:45:17 216 2147483648 2560999776 2647908352 217413632 9.193 20 11 24 1 238090672 18371168 2305872
08:46:19 198 2147483648 2553246928 2638385152 218471952 9.233 20 10 20 1 229469792 9342432 1655408
08:47:19 184 2147483648 2551691984 2633662464 215436416 9.117 20 14 28 0 226791776 8928896 2426464
08:48:19 321 2147483648 2549888704 2630295552 212933264 9.021 20 11 22 0 224093536 9093728 2066544
08:49:20 814 2147483648 2587397072 2673741824 218405568 9.231 20 10 20 1 263529920 43372512 1751840
08:50:21 187 2147483648 2554141856 2634100736 216353504 9.152 20 18 36 0 228063312 8982912 2726896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 12-11-2026 08:51:26 to 12-11-2026 08:51:27.

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          225236
MON$OLDEST_ACTIVE               225430
MON$OLDEST_SNAPSHOT             225430
MON$NEXT_TRANSACTION            225430
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-12 05:00:10.5280 GMT
MON$PAGES                       161432
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                        {C8017863-F832-482D-850F-A8266F023ED8}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             576
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


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

Database statistics


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

Database validation


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

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

--- start of diff output ---
:6: 
:7: test-0    Thu Nov 12 08: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'

12.11.26 08:51:27. 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-12 08:51:29 No severe PSQL-related problems occured
12.11.26 08:51:29. End of report.