Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 03.11.2026 06: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 3d
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 1767404 kB
MemAvailable 7437176 kB
Buffers 83308 kB
Cached 5712904 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
AllowUpdateOverwrite true true
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
BugcheckAbort true false [ X ] firebird.conf
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
DefaultProfilerPlugin Default_Profiler Default_Profiler
DefaultTimeZone
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb60SS 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
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
ProcessPriorityLevel 0 0
Providers Remote, Engine14, Loopback Remote, Engine14, Loopback
ReadConsistency true true
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemoteServiceName gds_db gds_db
RemoteServicePort 3600 0 [ X ] firebird.conf
RemoteServiceUnixSocket
SecurityDatabase /opt/fb60/security6.fdb /opt/fb60/security6.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
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
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-fb60.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=OLTP_ROOT_DIR, val=/mnt/oltp-emul
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-fb60.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_60.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb60/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=red
param=html_chart_color_memo_att, val=red
param=html_chart_color_memo_stm, val=red
param=html_chart_color_memo_trn, val=red
param=html_chart_color_perf_score, val=red
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=3600
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-fb60-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-fb60
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-03 06:51:00
DTS_END                         2026-11-03 06:51:00.9340
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(98:17)
IP                              ::1/46576
TRN_ID                          176238
ATT_ID                          396
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: 10439.28 963 521964
customer order: creation 517.36 44 25868
customer order: refuse 41.20 70 2060
order to supplier: creation 132.48 343 6624
order to supplier: removal 10.18 9038 509
invoice (draft): creation 129.84 2324 6492
invoice (draft): removal 92.24 167 4612
invoice accept: apply 108.68 1412 5434
invoice accept: cancel 73.76 234 3688
customer reserve: creation 4980.16 26 249008
customer reserve: removal 3565.24 19 178262
realization accept: apply 243.50 29 12175
realization accept: cancel 132.64 18 6632
payment from customer: creation 170.96 33 8548
payment from customer: removal 16.22 19 811
payment to supplier: creation 142.90 27 7145
payment to supplier: removal 10.64 24 532
service: total inventory turnovers 22.74 1180 1137
service: total monetary turnovers 43.62 8 2181
service: aggregate perf. data 4.88 1482 244
service: refresh index statistics 0.04 2765 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14153
TEST_TIME 2 10939
TEST_TIME 3 9724
TEST_TIME 4 9197
TEST_TIME 5 9349
TEST_TIME 6 9513
TEST_TIME 7 9847
TEST_TIME 8 9909
TEST_TIME 9 9964
TEST_TIME 10 10197
TEST_TIME 11 10225
TEST_TIME 12 10274
TEST_TIME 13 10215
TEST_TIME 14 10213
TEST_TIME 15 10299
TEST_TIME 16 10440
TEST_TIME 17 10414
TEST_TIME 18 10528
TEST_TIME 19 10553
TEST_TIME 20 10508
TEST_TIME 21 10603
TEST_TIME 22 10571
TEST_TIME 23 10656
TEST_TIME 24 10631
TEST_TIME 25 10613
TEST_TIME 26 10643
TEST_TIME 27 10575
TEST_TIME 28 10699
TEST_TIME 29 10754
TEST_TIME 30 10751
TEST_TIME 31 10710
TEST_TIME 32 10709
TEST_TIME 33 10698
TEST_TIME 34 10708
TEST_TIME 35 10790
TEST_TIME 36 10761
TEST_TIME 37 10754
TEST_TIME 38 10719
TEST_TIME 39 10750
TEST_TIME 40 10761
TEST_TIME 41 10777
TEST_TIME 42 10846
TEST_TIME 43 10835
TEST_TIME 44 10851
TEST_TIME 45 10815
TEST_TIME 46 10799
TEST_TIME 47 10744
TEST_TIME 48 10706
TEST_TIME 49 10646
TEST_TIME 50 10439

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 03-11-2026 06:51:20 to 03-11-2026 06: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 771152 771152 0 0.00 0 1834 2 0 0
doc_list_biud 771152 771152 0 0.00 0 1815 6 0 0
sp_add_invoice_to_stock 5434 5434 0 0.00 7 12104 1413 0 0
sp_cancel_adding_invoice 3688 3688 0 0.00 3 6733 234 0 0
sp_cancel_client_order 2060 2060 0 0.00 2 1341 71 0 0
sp_cancel_customer_reserve 178262 178262 0 0.00 1 1816 19 0 0
sp_cancel_pay_from_customer 811 811 0 0.00 1 1032 20 0 0
sp_cancel_pay_to_supplier 532 532 0 0.00 1 2099 25 0 0
sp_cancel_supplier_invoice 4612 4612 0 0.00 1 2592 167 0 0
sp_cancel_supplier_order 509 509 0 0.00 5 68906 9038 0 0
sp_cancel_write_off 6632 6632 0 0.00 1 1107 19 0 0
sp_client_order 25868 25868 0 0.00 2 2344 44 0 0
sp_customer_reserve 249008 249008 0 0.00 0 3079 26 0 0
sp_fill_shopping_cart 38984 38984 0 0.00 0 14148 369 0 0
sp_fill_shopping_cart_clo_res 249008 249008 0 0.00 0 1258 2 0 0
sp_get_clo_for_invoice 5434 5434 0 0.00 0 1545 34 0 0
sp_kill_cost_storno 11663 11663 0 0.00 0 667 7 0 0
sp_kill_qstorno_ret_qs2qd 368277 368277 0 0.00 0 1811 10 0 0
sp_kill_qty_storno 213372 213372 0 0.00 0 1815 21 0 0
sp_lock_selected_doc 24531 24531 0 0.00 0 590 1 0 0
sp_make_cost_storno 33302 33302 0 0.00 0 576 6 0 0
sp_multiply_rows_for_pdistr 33302 33302 0 0.00 0 1029 8 0 0
sp_multiply_rows_for_qdistr 25868 25868 0 0.00 0 1481 15 0 0
sp_pay_from_customer 8548 8548 0 0.00 3 1005 34 0 0
sp_pay_to_supplier 7145 7145 0 0.00 2 1987 28 0 0
sp_payment_common 15693 15693 0 0.00 0 567 10 0 0
sp_qd_handle_on_cancel_clo 2060 2060 0 0.00 0 1331 50 0 0
sp_qd_handle_on_invoice_upd_sts 9122 9122 0 0.00 0 1699 57 0 0
sp_qd_handle_on_reserve_upd_sts 12175 12175 0 0.00 0 1083 8 0 0
sp_reserve_write_off 12175 12175 0 0.00 2 1763 30 0 0
sp_supplier_invoice 6492 6492 0 0.00 35 17999 2325 0 0
sp_supplier_order 6624 6624 0 0.00 33 3633 343 0 0
srv_aggregate_perf_data 244 244 0 0.00 44 7570 1483 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 7 1768 292 0 0
srv_find_qd_qs_mism 483744 483744 0 0.00 0 1833 2 0 0
srv_make_invnt_saldo 1137 1137 0 0.00 2 6171 1181 0 0
srv_make_money_saldo 2181 2181 0 0.00 0 637 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 1656 3875 2766 0 0
v_add_invoice_to_stock 10868 10868 0 0.00 0 1072 2 0 0
v_all_customers 39330 39330 0 0.00 0 66 2 0 0
v_all_suppliers 32566 32566 0 0.00 0 52 1 0 0
v_all_wares 51736 51736 0 0.00 0 135 1 0 0
v_cancel_adding_invoice 1020 1020 0 0.00 0 33 2 0 0
v_cancel_client_order 4120 4120 0 0.00 0 282 2 0 0
v_cancel_customer_prepayment 1622 1622 0 0.00 0 427 2 0 0
v_cancel_customer_reserve 1654 1654 0 0.00 0 352 2 0 0
v_cancel_payment_to_supplier 1064 1064 0 0.00 0 2095 6 0 0
v_cancel_supplier_invoice 1004 1004 0 0.00 0 134 3 0 0
v_cancel_supplier_order 1018 1018 0 0.00 0 276 2 0 0
v_cancel_write_off 2342 2342 0 0.00 0 272 2 0 0
v_max_id_clo_ord 6624 6624 0 0.00 0 382 68 0 0
v_max_id_clo_res 1197 1197 0 0.00 0 238 2 0 0
v_max_id_ord_sup 6492 6492 0 0.00 1 4292 946 0 0
v_max_non_paid_invoice 3978 3978 0 0.00 0 41 2 0 0
v_max_non_paid_realizn 8235 8235 0 0.00 0 33 1 0 0
v_min_id_clo_ord 6624 6624 0 0.00 1 3454 85 0 0
v_min_id_clo_res 1197 1197 0 0.00 0 674 5 0 0
v_min_id_ord_sup 6492 6492 0 0.00 1 11723 1019 0 0
v_min_non_paid_invoice 7145 7145 0 0.00 0 469 4 0 0
v_min_non_paid_realizn 8548 8548 0 0.00 0 506 4 0 0
v_our_firm 13032 13032 0 0.00 0 59 1 0 0
v_reserve_write_off 24350 24350 0 0.00 0 1749 1 0 0
x_lock_depdocs_on_canc_invoice 7798 7798 0 0.00 0 599 7 0 0
x_lock_depdocs_on_canc_sup_ord 509 509 0 0.00 0 110 5 0 0
x_make_qstorno_1000_1200 6624 6624 0 0.00 1 3429 140 0 0
x_make_qstorno_1200_2000 6492 6492 0 0.00 1 5545 329 0 0
x_make_qstorno_2100_3300 249008 249008 0 0.00 0 3055 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-11-2026 06:51:22 to 03-11-2026 06:51:26.

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
06:01:05 6 2147483648 2257003360 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
06:02:05 248 2147483648 2336913904 2431188992 809040 0.037 20 9 18 0 3490960 1554688 1127232
06:03:06 226 2147483648 2338224032 2438844416 319344 0.014 20 8 21 0 2860480 964608 1576528
06:04:07 316 2147483648 2340225808 2440904704 326592 0.015 19 9 20 0 3856928 2046176 1484160
06:05:08 634 2147483648 2339229936 2443493376 1414640 0.065 20 4 10 0 3970480 2081280 474560
06:06:09 309 2147483648 2341779600 2447118336 750720 0.034 20 9 16 1 2882816 978112 1153984
06:07:10 228 2147483648 2350066048 2454945792 -2241824 -0.104 20 11 24 1 9376496 7496256 4122064
06:08:11 167 2147483648 2342813264 2451091456 818240 0.038 20 9 18 0 3009072 1106896 1083936
06:09:11 921 2147483648 2346035216 2453934080 1435552 0.066 20 5 10 0 2894608 1029088 429968
06:10:13 209 2147483648 2345392560 2451828736 561232 0.026 20 8 17 0 5007008 3119936 1325840
06:11:13 373 2147483648 2350579264 2458476544 -4141024 -0.193 20 12 30 0 5798128 3914960 6024192
06:12:15 298 2147483648 2351353264 2460291072 -985600 -0.045 20 10 23 0 6987680 5101552 2871728
06:13:15 150 2147483648 2352476400 2466148352 -2900992 -0.135 20 10 24 0 5921968 4022704 4800256
06:14:16 181 2147483648 2352753008 2466426880 -3656560 -0.170 20 15 40 0 2927024 1027328 5556256
06:15:16 227 2147483648 2350367776 2460614656 761536 0.035 20 8 17 0 5957392 4074784 1121072
06:16:17 247 2147483648 2349610912 2466938880 871040 0.040 20 8 17 0 5413568 3518448 1024080
06:17:17 298 2147483648 2366656336 2476216320 -3378736 -0.157 20 13 30 0 15045904 13155568 5269072
06:18:18 235 2147483648 2359738384 2476220416 -8088384 -0.378 20 19 48 0 4809024 2919264 9978144
06:19:19 220 2147483648 2366677616 2477137920 -5439600 -0.253 20 13 30 1 13619744 11724048 7335296
06:20:19 284 2147483648 2359541920 2471534592 -1193856 -0.055 20 13 29 0 10771168 8883600 3081424
06:21:20 201 2147483648 2364885392 2482991104 -9844432 -0.460 20 15 38 0 6723056 4834336 11733152
06:22:21 211 2147483648 2367902672 2479525888 -6168784 -0.288 20 17 39 0 15241712 13350016 8060480
06:23:22 202 2147483648 2360405584 2481418240 -6757152 -0.315 20 15 36 0 6069120 4182736 8643536
06:24:22 151 2147483648 2362124384 2474795008 -2228208 -0.103 20 16 32 1 11562704 9674224 4116688
06:25:23 1766 2147483648 2359312672 2479554560 -5038624 -0.235 20 12 30 0 6901360 5003312 6936672
06:26:27 230 2147483648 2361155056 2481524736 -10171536 -0.475 20 18 43 1 3993104 2101904 12062736
06:27:27 141 2147483648 2354732320 2476244992 877968 0.040 20 7 14 0 7453392 5569904 1005520
06:28:28 254 2147483648 2365312256 2481414144 -9137104 -0.427 19 17 43 1 9574736 7778656 10933184
06:29:28 188 2147483648 2370980128 2493804544 -7649824 -0.357 20 15 36 0 14424928 12529184 9545568
06:30:29 161 2147483648 2355920368 2484506624 -3599200 -0.167 20 8 20 0 3694048 1800464 5492784
06:31:29 175 2147483648 2368593184 2467024896 -4078896 -0.190 20 10 23 0 19370064 17473904 5975056
06:32:30 226 2147483648 2359328400 2470633472 -9801584 -0.458 19 15 39 0 3456864 1653984 11604464
06:33:30 222 2147483648 2367287696 2475941888 -12417792 -0.581 19 17 42 0 7251392 5458304 14210880
06:34:31 220 2147483648 2372711072 2486501376 -17999680 -0.845 20 19 50 1 6332864 4441184 19891360
06:35:31 280 2147483648 2363083280 2470227968 -2530144 -0.117 20 10 22 0 10788704 8892720 4426128
06:36:32 266 2147483648 2377121808 2480500736 -8806672 -0.411 20 13 34 0 21362112 19474592 10694192
06:37:32 190 2147483648 2360947840 2485858304 -3320304 -0.154 20 14 31 0 6865584 4982208 5203680
06:38:33 310 2147483648 2367296848 2495053824 -13828256 -0.648 20 19 51 0 4924336 3038192 15714400
06:39:33 238 2147483648 2376839056 2498633728 -14669632 -0.687 20 19 47 0 11895136 10001552 16563216
06:40:34 245 2147483648 2371821184 2493411328 -13367504 -0.626 20 15 41 0 8909632 7021216 15255920
06:41:34 273 2147483648 2386264960 2503196672 -17477984 -0.820 20 16 43 0 16564720 14677696 19365008
06:42:35 225 2147483648 2384304352 2492968960 -8782752 -0.410 20 14 33 0 25010000 23123824 10668928
06:43:35 427 2147483648 2386782048 2506797056 -9677824 -0.452 20 13 31 0 26650032 24761520 11566336
06:44:36 301 2147483648 2368330016 2503315456 -8911984 -0.416 20 17 40 0 8187184 6289584 10809584
06:45:36 184 2147483648 2374483712 2509520896 -17114256 -0.803 20 15 38 0 6562896 4665216 19011936
06:46:37 253 2147483648 2381172720 2516398080 -21879920 -1.029 20 17 47 0 10742928 8843184 23779664
06:47:37 286 2147483648 2381490544 2501636096 -4670752 -0.217 20 14 30 0 25542416 23641200 6571968
06:48:38 368 2147483648 2373930624 2506469376 -17952256 -0.843 20 17 45 0 6597088 4710288 19839056
06:49:39 212 2147483648 2365438064 2502250496 -12817072 -0.600 20 15 39 0 3295088 1402432 14709728
06:50:40 246 2147483648 2385215184 2508574720 -13696176 -0.641 20 19 46 0 20330352 18432192 15594336

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 03-11-2026 06:51:27 to 03-11-2026 06:51:39.

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 03-11-2026 06:51:39 to 03-11-2026 06:51:40.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb60.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   14
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          174326
MON$OLDEST_ACTIVE               176409
MON$OLDEST_SNAPSHOT             176409
MON$NEXT_TRANSACTION            176409
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-03 03:00:12.1590 GMT
MON$PAGES                       136354
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                        {51C4C357-7D38-4C5A-BB4C-20938B9958BB}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             509
MON$NEXT_STATEMENT              900
MON$REPLICA_MODE                0


ISQL Version: LI-T6.0.0.2446 Firebird 6.0 0b6d977
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T6.0.0.2446 Firebird 6.0 0b6d977"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T6.0.0.2446 Firebird 6.0 0b6d977/tcp (test-0)/P20:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T6.0.0.2446 Firebird 6.0 0b6d977/tcp (test-0)/P20:C"
on disk structure version 14.0

Database statistics


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

Database validation


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

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

--- start of diff output ---
:6: 
:7: test-0    Tue Nov  3 06:51:02 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
:10: 
:11: test-0    Tue Nov  3 06:51:03 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:13: 
--- end of diff output ---

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

03.11.26 06:51:40. There are 3 logs in /var/tmp/logs.oltp-fb60 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-03 06:51:41 No severe PSQL-related problems occured
03.11.26 06:51:42. End of report.