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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 6d
Command: who -b
bootup_info system boot 2026-10-26 18:11
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138024 kB
MemFree 1577544 kB
MemAvailable 7475712 kB
Buffers 90200 kB
Cached 5890216 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-06 18:51:07
DTS_END                         2026-11-06 18:51:07.6690
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/53722
TRN_ID                          152866
ATT_ID                          349
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: 8410.78 1176 420539
customer order: creation 451.76 53 22588
customer order: refuse 37.20 70 1860
order to supplier: creation 113.80 374 5690
order to supplier: removal 8.62 8973 431
invoice (draft): creation 113.76 2018 5688
invoice (draft): removal 75.62 171 3781
invoice accept: apply 96.64 1591 4832
invoice accept: cancel 62.34 225 3117
customer reserve: creation 4023.46 32 201173
customer reserve: removal 2757.34 20 137867
realization accept: apply 205.86 35 10293
realization accept: cancel 109.22 21 5461
payment from customer: creation 151.52 36 7576
payment from customer: removal 14.28 19 714
payment to supplier: creation 123.26 30 6163
payment to supplier: removal 8.26 19 413
service: total inventory turnovers 17.36 1702 868
service: total monetary turnovers 36.92 6 1846
service: aggregate perf. data 3.50 1586 175
service: refresh index statistics 0.06 6540 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11686
TEST_TIME 2 9513
TEST_TIME 3 9171
TEST_TIME 4 8754
TEST_TIME 5 8814
TEST_TIME 6 8838
TEST_TIME 7 9026
TEST_TIME 8 8971
TEST_TIME 9 8947
TEST_TIME 10 8883
TEST_TIME 11 9040
TEST_TIME 12 9048
TEST_TIME 13 9020
TEST_TIME 14 9127
TEST_TIME 15 9093
TEST_TIME 16 9203
TEST_TIME 17 9251
TEST_TIME 18 9233
TEST_TIME 19 9227
TEST_TIME 20 9172
TEST_TIME 21 9176
TEST_TIME 22 9199
TEST_TIME 23 9147
TEST_TIME 24 9117
TEST_TIME 25 9228
TEST_TIME 26 9078
TEST_TIME 27 8952
TEST_TIME 28 8917
TEST_TIME 29 8947
TEST_TIME 30 8969
TEST_TIME 31 8915
TEST_TIME 32 8836
TEST_TIME 33 8851
TEST_TIME 34 8843
TEST_TIME 35 8817
TEST_TIME 36 8755
TEST_TIME 37 8694
TEST_TIME 38 8735
TEST_TIME 39 8710
TEST_TIME 40 8743
TEST_TIME 41 8733
TEST_TIME 42 8710
TEST_TIME 43 8695
TEST_TIME 44 8641
TEST_TIME 45 8684
TEST_TIME 46 8640
TEST_TIME 47 8646
TEST_TIME 48 8584
TEST_TIME 49 8566
TEST_TIME 50 8411

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 06-11-2026 18:51:27 to 06-11-2026 18:51:29.

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 624174 624174 0 0.00 0 2028 3 0 0
doc_list_biud 624174 624174 0 0.00 0 2800 7 0 0
sp_add_invoice_to_stock 4832 4832 0 0.00 5 16510 1592 0 0
sp_cancel_adding_invoice 3117 3117 0 0.00 3 12306 225 0 0
sp_cancel_client_order 1860 1860 0 0.00 3 1232 70 0 0
sp_cancel_customer_reserve 137867 137867 0 0.00 1 2810 21 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 1 430 20 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 1 731 20 0 0
sp_cancel_supplier_invoice 3781 3781 0 0.00 2 2307 171 0 0
sp_cancel_supplier_order 431 431 0 0.00 6 70119 8973 0 0
sp_cancel_write_off 5461 5461 0 0.00 1 2158 22 0 0
sp_client_order 22588 22588 0 0.00 3 3077 53 0 0
sp_customer_reserve 201173 201173 0 0.00 0 3923 33 0 0
sp_fill_shopping_cart 33966 33966 0 0.00 0 10900 310 0 0
sp_fill_shopping_cart_clo_res 201173 201173 0 0.00 0 2258 2 0 0
sp_get_clo_for_invoice 4832 4832 0 0.00 0 1697 33 0 0
sp_kill_cost_storno 9705 9705 0 0.00 0 688 8 0 0
sp_kill_qstorno_ret_qs2qd 285407 285407 0 0.00 0 2799 10 0 0
sp_kill_qty_storno 167642 167642 0 0.00 0 2800 23 0 0
sp_lock_selected_doc 21075 21075 0 0.00 0 679 1 0 0
sp_make_cost_storno 28864 28864 0 0.00 0 1044 6 0 0
sp_multiply_rows_for_pdistr 28864 28864 0 0.00 0 826 10 0 0
sp_multiply_rows_for_qdistr 22588 22588 0 0.00 0 1677 18 0 0
sp_pay_from_customer 7576 7576 0 0.00 2 1687 36 0 0
sp_pay_to_supplier 6163 6163 0 0.00 2 1743 31 0 0
sp_payment_common 13739 13739 0 0.00 0 1146 8 0 0
sp_qd_handle_on_cancel_clo 1860 1860 0 0.00 0 1145 48 0 0
sp_qd_handle_on_invoice_upd_sts 7949 7949 0 0.00 0 1852 63 0 0
sp_qd_handle_on_reserve_upd_sts 10293 10293 0 0.00 0 1647 10 0 0
sp_reserve_write_off 10293 10293 0 0.00 2 2038 35 0 0
sp_supplier_invoice 5688 5688 0 0.00 22 11859 2018 0 0
sp_supplier_order 5690 5690 0 0.00 12 4632 374 0 0
srv_aggregate_perf_data 175 175 0 0.00 101 8463 1587 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 1335 302 0 0
srv_find_qd_qs_mism 388475 388475 0 0.00 0 2023 2 0 0
srv_make_invnt_saldo 868 868 0 0.00 0 6770 1702 0 0
srv_make_money_saldo 1846 1846 0 0.00 0 431 7 0 0
srv_recalc_idx_stat 3 3 0 0.00 975 11538 6540 0 0
v_add_invoice_to_stock 9664 9664 0 0.00 0 1349 3 0 0
v_all_customers 34732 34732 0 0.00 0 101 2 0 0
v_all_suppliers 27666 27666 0 0.00 0 75 1 0 0
v_all_wares 45176 45176 0 0.00 0 62 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 154 3 0 0
v_cancel_client_order 3720 3720 0 0.00 0 454 2 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 105 2 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 655 3 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 717 3 0 0
v_cancel_supplier_invoice 776 776 0 0.00 0 774 5 0 0
v_cancel_supplier_order 862 862 0 0.00 0 382 3 0 0
v_cancel_write_off 2078 2078 0 0.00 0 799 3 0 0
v_max_id_clo_ord 5690 5690 0 0.00 1 699 67 0 0
v_max_id_clo_res 1019 1019 0 0.00 0 787 3 0 0
v_max_id_ord_sup 5688 5688 0 0.00 1 3709 772 0 0
v_max_non_paid_invoice 3708 3708 0 0.00 0 53 2 0 0
v_max_non_paid_realizn 7146 7146 0 0.00 0 109 1 0 0
v_min_id_clo_ord 5690 5690 0 0.00 1 1770 83 0 0
v_min_id_clo_res 1019 1019 0 0.00 0 804 6 0 0
v_min_id_ord_sup 5688 5688 0 0.00 0 8684 830 0 0
v_min_non_paid_invoice 6163 6163 0 0.00 0 252 2 0 0
v_min_non_paid_realizn 7576 7576 0 0.00 0 435 2 0 0
v_our_firm 11304 11304 0 0.00 0 95 1 0 0
v_reserve_write_off 20586 20586 0 0.00 0 356 1 0 0
x_lock_depdocs_on_canc_invoice 6510 6510 0 0.00 0 1553 8 0 0
x_lock_depdocs_on_canc_sup_ord 431 431 0 0.00 0 929 10 0 0
x_make_qstorno_1000_1200 5690 5690 0 0.00 1 3642 174 0 0
x_make_qstorno_1200_2000 5688 5688 0 0.00 1 7132 378 0 0
x_make_qstorno_2100_3300 201173 201173 0 0.00 0 3886 28 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 06-11-2026 18:51:29 to 06-11-2026 18:51:34.

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
18:01:12 3 2147483648 2257003360 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
18:02:12 296 2147483648 2336544592 2431029248 254352 0.011 20 11 25 0 2783808 836480 1692976
18:03:15 276 2147483648 2346614656 2443628544 -1189728 -0.055 20 13 28 0 5398112 3507888 3079952
18:04:15 210 2147483648 2341414864 2440073216 1281840 0.059 20 3 6 0 3304272 1413680 608752
18:05:16 169 2147483648 2347834720 2451656704 396016 0.018 20 10 21 1 4633248 2744144 1493088
18:06:17 271 2147483648 2350478992 2455539712 -1411808 -0.065 20 10 24 0 3099696 1198336 3313168
18:07:18 311 2147483648 2342497168 2447888384 1151104 0.053 20 5 12 0 2691408 826288 714016
18:08:19 199 2147483648 2347124096 2452705280 697408 0.032 20 9 20 0 3580048 1682144 1200496
18:09:19 594 2147483648 2349256480 2455810048 115968 0.005 20 13 27 0 3610496 1717728 1776800
18:10:20 122 2147483648 2352739952 2458447872 -1053232 -0.049 20 13 27 1 6108384 4229456 2932160
18:11:21 205 2147483648 2351428960 2459291648 272640 0.012 20 9 20 0 3974096 2088272 1613184
18:12:21 424 2147483648 2352902224 2457645056 -2790128 -0.130 20 10 24 0 7319888 5444208 4665808
18:13:23 215 2147483648 2352717312 2463240192 -4060160 -0.189 20 12 29 0 7714912 5833488 5941584
18:14:23 233 2147483648 2356768976 2467770368 -5447360 -0.254 20 14 35 3 3696480 1803552 7340288
18:15:24 151 2147483648 2369851744 2472275968 -466688 -0.021 20 8 18 0 17939696 16047648 2358736
18:16:25 209 2147483648 2358452448 2467373056 -3875776 -0.180 20 15 36 0 7484192 5591968 5768000
18:17:25 297 2147483648 2362379936 2470928384 -4588384 -0.214 20 15 37 1 6619360 4720112 6487632
18:18:26 207 2147483648 2364432736 2472194048 -6858832 -0.320 20 16 38 0 10457472 8577504 8738800
18:19:26 91 2147483648 2357239200 2470375424 -1792912 -0.083 20 11 23 0 6926544 5045584 3673872
18:20:27 163 2147483648 2361576512 2472288256 -4289344 -0.200 20 14 34 0 8818496 6930080 6177760
18:21:28 248 2147483648 2358939680 2471333888 -182928 -0.008 20 7 16 0 9294512 7410144 2067296
18:22:31 217 2147483648 2364908320 2477912064 -1975392 -0.092 20 13 29 0 10997216 9113760 3858848
18:23:32 186 2147483648 2362688368 2470608896 -1458992 -0.067 20 8 19 0 12990048 11097728 3351312
18:24:32 200 2147483648 2359241648 2474172416 -6366640 -0.297 20 11 28 0 5603488 3715808 8254320
18:25:33 211 2147483648 2355581488 2469072896 -5015440 -0.234 19 10 25 0 3977872 2178464 6814848
18:26:34 192 2147483648 2375898624 2476679168 -4908336 -0.229 20 15 36 1 22168736 20278240 6798832
18:27:34 275 2147483648 2367945968 2485112832 -8884256 -0.415 20 16 42 1 6383088 4483248 10784096
18:28:35 195 2147483648 2363208544 2477273088 -3501456 -0.163 20 15 34 1 9975408 8076000 5400864
18:29:36 272 2147483648 2360097520 2477195264 574368 0.026 20 10 21 0 7085984 5192288 1319328
18:30:36 199 2147483648 2359742432 2478268416 -4338896 -0.202 20 14 34 1 3425440 1541040 6223296
18:31:37 1335 2147483648 2368414848 2457075712 -541280 -0.025 20 7 15 0 23354560 21458176 2437664
18:32:40 554 2147483648 2367378112 2473959424 -8581872 -0.401 20 13 35 0 3415840 1529264 10468448
18:33:41 334 2147483648 2356311712 2462105600 -881648 -0.041 20 11 25 1 6533136 4635136 2779648
18:34:42 230 2147483648 2373772368 2469773312 -7276112 -0.339 20 17 42 0 17386112 15499024 9163200
18:35:42 166 2147483648 2366323280 2468347904 -462800 -0.021 20 10 21 0 13744144 11861440 2345504
18:36:43 527 2147483648 2372867712 2483568640 -14672592 -0.687 20 19 53 0 4600672 2707504 16565760
18:37:44 220 2147483648 2361596160 2471141376 -2361328 -0.110 20 14 30 0 5920528 4030288 4251568
18:38:44 489 2147483648 2370839632 2476838912 -14531488 -0.681 20 17 45 1 9346176 7466592 16411072
18:39:45 138 2147483648 2359364896 2467807232 -357104 -0.016 20 8 17 0 8779888 6897056 2239936
18:40:46 1012 2147483648 2372484960 2473811968 -9068816 -0.424 20 14 34 0 16256304 14368608 10956512
18:41:47 92 2147483648 2368057808 2476875776 -2741184 -0.127 20 9 21 0 13616288 11735680 4621792
18:42:48 297 2147483648 2374697024 2484027392 -7775376 -0.363 20 14 35 0 12514928 10618160 9672144
18:43:49 283 2147483648 2355096832 2469572608 -3606208 -0.168 20 9 21 0 5435424 3555408 5486224
18:44:49 328 2147483648 2361974896 2476347392 -4941216 -0.230 20 11 28 0 5140368 3257152 6824432
18:45:50 273 2147483648 2367702272 2478645248 -694496 -0.032 20 10 21 0 12493824 10613824 2574496
18:46:50 806 2147483648 2362299120 2483073024 809008 0.037 20 7 14 0 16576560 14697472 1070080
18:47:51 217 2147483648 2387406128 2496589824 -5626272 -0.262 20 15 35 1 26682784 24791424 7517632
18:48:54 337 2147483648 2369302896 2493898752 -13485920 -0.631 20 18 47 0 6131488 4245840 15371568
18:49:55 220 2147483648 2371410544 2489008128 -4348912 -0.202 20 13 31 0 14478592 12583616 6243888
18:50:56 302 2147483648 2377740688 2494734336 -7647824 -0.357 20 15 38 0 15559808 13658192 9549440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 06-11-2026 18:51:35 to 06-11-2026 18:51:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 06-11-2026 18:51:49 to 06-11-2026 18:51:50.

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          152823
MON$OLDEST_ACTIVE               153061
MON$OLDEST_SNAPSHOT             153061
MON$NEXT_TRANSACTION            153061
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-06 15:00:13.0510 GMT
MON$PAGES                       120785
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                        {BC03D779-AB2C-43F5-9E1E-ABD4A5665E4E}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             470
MON$NEXT_STATEMENT              900
MON$REPLICA_MODE                0


ISQL Version: LI-T6.0.0.2452 Firebird 6.0 f78dbc4
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T6.0.0.2452 Firebird 6.0 f78dbc4"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T6.0.0.2452 Firebird 6.0 f78dbc4/tcp (test-0)/P20:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T6.0.0.2452 Firebird 6.0 f78dbc4/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    Fri Nov  6 18:51:10 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
--- end of diff output ---

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

06.11.26 18:51:50. 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-06 18:51:51 No severe PSQL-related problems occured
06.11.26 18:51:52. End of report.