Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 03.11.2026 12: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 1580984 kB
MemAvailable 7477828 kB
Buffers 83896 kB
Cached 5936672 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 12:51:03
DTS_END                         2026-11-03 12:51:03.6540
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/40230
TRN_ID                          149044
ATT_ID                          343
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: 8061.58 1154 403079
customer order: creation 440.00 55 22000
customer order: refuse 36.52 72 1826
order to supplier: creation 110.42 398 5521
order to supplier: removal 8.36 9131 418
invoice (draft): creation 110.50 1824 5525
invoice (draft): removal 74.04 171 3702
invoice accept: apply 93.24 1635 4662
invoice accept: cancel 60.04 217 3002
customer reserve: creation 3812.44 34 190622
customer reserve: removal 2656.72 20 132836
realization accept: apply 204.14 36 10207
realization accept: cancel 111.74 21 5587
payment from customer: creation 146.72 35 7336
payment from customer: removal 13.56 20 678
payment to supplier: creation 118.46 30 5923
payment to supplier: removal 8.94 19 447
service: total inventory turnovers 16.46 1880 823
service: total monetary turnovers 36.16 7 1808
service: aggregate perf. data 3.06 1855 153
service: refresh index statistics 0.06 5629 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-11-2026 12:51:22 to 03-11-2026 12:51:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11077
TEST_TIME 2 9522
TEST_TIME 3 8651
TEST_TIME 4 8602
TEST_TIME 5 8410
TEST_TIME 6 8355
TEST_TIME 7 8157
TEST_TIME 8 8204
TEST_TIME 9 8066
TEST_TIME 10 8117
TEST_TIME 11 8335
TEST_TIME 12 8200
TEST_TIME 13 8363
TEST_TIME 14 8334
TEST_TIME 15 8311
TEST_TIME 16 8312
TEST_TIME 17 8311
TEST_TIME 18 8292
TEST_TIME 19 8300
TEST_TIME 20 8299
TEST_TIME 21 8391
TEST_TIME 22 8451
TEST_TIME 23 8478
TEST_TIME 24 8517
TEST_TIME 25 8480
TEST_TIME 26 8495
TEST_TIME 27 8548
TEST_TIME 28 8509
TEST_TIME 29 8537
TEST_TIME 30 8543
TEST_TIME 31 8467
TEST_TIME 32 8501
TEST_TIME 33 8498
TEST_TIME 34 8509
TEST_TIME 35 8467
TEST_TIME 36 8490
TEST_TIME 37 8439
TEST_TIME 38 8395
TEST_TIME 39 8367
TEST_TIME 40 8315
TEST_TIME 41 8256
TEST_TIME 42 8297
TEST_TIME 43 8260
TEST_TIME 44 8243
TEST_TIME 45 8247
TEST_TIME 46 8262
TEST_TIME 47 8287
TEST_TIME 48 8218
TEST_TIME 49 8225
TEST_TIME 50 8062

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 03-11-2026 12:51:25 to 03-11-2026 12:51:27.

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 597902 597902 0 0.00 0 2718 3 0 0
doc_list_biud 597902 597902 0 0.00 0 3294 7 0 0
sp_add_invoice_to_stock 4662 4662 0 0.00 4 16347 1636 0 0
sp_cancel_adding_invoice 3002 3002 0 0.00 3 7985 218 0 0
sp_cancel_client_order 1826 1826 0 0.00 3 3308 72 0 0
sp_cancel_customer_reserve 132836 132836 0 0.00 1 2766 21 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 1 639 20 0 0
sp_cancel_pay_to_supplier 447 447 0 0.00 2 661 20 0 0
sp_cancel_supplier_invoice 3702 3702 0 0.00 1 2544 172 0 0
sp_cancel_supplier_order 418 418 0 0.00 10 53652 9132 0 0
sp_cancel_write_off 5587 5587 0 0.00 1 1325 22 0 0
sp_client_order 22000 22000 0 0.00 3 4938 55 0 0
sp_customer_reserve 190622 190622 0 0.00 0 5596 34 0 0
sp_fill_shopping_cart 33046 33046 0 0.00 0 11527 279 0 0
sp_fill_shopping_cart_clo_res 190622 190622 0 0.00 0 1677 2 0 0
sp_get_clo_for_invoice 4662 4662 0 0.00 0 3037 35 0 0
sp_kill_cost_storno 9714 9714 0 0.00 0 747 8 0 0
sp_kill_qstorno_ret_qs2qd 275379 275379 0 0.00 0 2621 10 0 0
sp_kill_qty_storno 162240 162240 0 0.00 0 3294 23 0 0
sp_lock_selected_doc 20693 20693 0 0.00 0 760 1 0 0
sp_make_cost_storno 28128 28128 0 0.00 0 884 6 0 0
sp_multiply_rows_for_pdistr 28128 28128 0 0.00 0 2716 10 0 0
sp_multiply_rows_for_qdistr 22000 22000 0 0.00 0 1708 19 0 0
sp_pay_from_customer 7336 7336 0 0.00 3 1089 36 0 0
sp_pay_to_supplier 5923 5923 0 0.00 2 2737 30 0 0
sp_payment_common 13259 13259 0 0.00 0 862 9 0 0
sp_qd_handle_on_cancel_clo 1826 1826 0 0.00 0 3294 50 0 0
sp_qd_handle_on_invoice_upd_sts 7664 7664 0 0.00 0 2708 65 0 0
sp_qd_handle_on_reserve_upd_sts 10207 10207 0 0.00 0 1508 10 0 0
sp_reserve_write_off 10207 10207 0 0.00 2 1512 37 0 0
sp_supplier_invoice 5525 5525 0 0.00 39 13773 1824 0 0
sp_supplier_order 5521 5521 0 0.00 38 7679 399 0 0
srv_aggregate_perf_data 153 153 0 0.00 90 9177 1855 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 785 281 0 0
srv_find_qd_qs_mism 372879 372879 0 0.00 0 1857 2 0 0
srv_make_invnt_saldo 823 823 0 0.00 1 7215 1881 0 0
srv_make_money_saldo 1808 1808 0 0.00 0 634 7 0 0
srv_recalc_idx_stat 3 3 0 0.00 244 8470 5630 0 0
v_add_invoice_to_stock 9324 9324 0 0.00 0 289 2 0 0
v_all_customers 33812 33812 0 0.00 0 88 2 0 0
v_all_suppliers 26530 26530 0 0.00 0 52 1 0 0
v_all_wares 44000 44000 0 0.00 0 109 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 447 3 0 0
v_cancel_client_order 3652 3652 0 0.00 0 727 2 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 589 3 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 896 3 0 0
v_cancel_payment_to_supplier 894 894 0 0.00 0 125 2 0 0
v_cancel_supplier_invoice 794 794 0 0.00 0 38 3 0 0
v_cancel_supplier_order 836 836 0 0.00 0 35 2 0 0
v_cancel_write_off 2006 2006 0 0.00 0 104 2 0 0
v_max_id_clo_ord 5521 5521 0 0.00 1 848 64 0 0
v_max_id_clo_res 1099 1099 0 0.00 0 893 4 0 0
v_max_id_ord_sup 5525 5525 0 0.00 1 4185 671 0 0
v_max_non_paid_invoice 3704 3704 0 0.00 0 81 2 0 0
v_max_non_paid_realizn 6937 6937 0 0.00 0 390 2 0 0
v_min_id_clo_ord 5521 5521 0 0.00 1 4387 87 0 0
v_min_id_clo_res 1099 1099 0 0.00 0 554 4 0 0
v_min_id_ord_sup 5525 5525 0 0.00 1 10584 745 0 0
v_min_non_paid_invoice 5923 5923 0 0.00 0 389 2 0 0
v_min_non_paid_realizn 7336 7336 0 0.00 0 639 3 0 0
v_our_firm 10986 10986 0 0.00 0 61 1 0 0
v_reserve_write_off 20414 20414 0 0.00 0 762 2 0 0
x_lock_depdocs_on_canc_invoice 6307 6307 0 0.00 0 1539 8 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 400 10 0 0
x_make_qstorno_1000_1200 5521 5521 0 0.00 1 7605 199 0 0
x_make_qstorno_1200_2000 5525 5525 0 0.00 1 6734 367 0 0
x_make_qstorno_2100_3300 190622 190622 0 0.00 0 5595 30 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 03-11-2026 12:51:28 to 03-11-2026 12:51:33.

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
12:01:09 3 2147483648 2257003360 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
12:02:09 306 2147483648 2334805600 2429136896 196640 0.009 20 10 26 0 3332352 1404160 1731552
12:03:10 246 2147483648 2339826624 2438770688 1412160 0.065 20 3 7 0 3171520 1294608 464752
12:04:11 400 2147483648 2342883440 2445561856 549792 0.025 20 8 21 0 3182256 1276816 1355648
12:05:12 300 2147483648 2344252256 2449465344 990352 0.046 20 7 15 0 3533040 1647584 895104
12:06:13 480 2147483648 2346778768 2450935808 -951104 -0.044 20 11 25 1 3532096 1628976 2854224
12:07:14 182 2147483648 2349008048 2454863872 -850336 -0.039 20 12 25 1 3717888 1846704 2721520
12:08:15 400 2147483648 2345156096 2451824640 122912 0.005 20 6 13 0 2872256 979328 1770016
12:09:16 210 2147483648 2350923248 2460311552 570880 0.026 20 10 20 0 4464704 2558192 1335632
12:10:17 780 2147483648 2344342768 2454724608 1547648 0.072 19 2 4 0 2710336 928000 234688
12:11:19 425 2147483648 2351279600 2462547968 604640 0.028 20 8 18 0 4125312 2239552 1281120
12:12:19 283 2147483648 2351135280 2457354240 392960 0.018 20 10 22 0 6929856 5036416 1500480
12:13:20 158 2147483648 2355426096 2466488320 -930976 -0.043 20 12 28 0 5735568 3844640 2821904
12:14:21 219 2147483648 2359860256 2465771520 -1904320 -0.088 20 11 25 0 12216944 10340160 3781104
12:15:21 221 2147483648 2360270320 2470199296 -2205856 -0.102 20 13 31 0 9163776 7265968 4103664
12:16:23 161 2147483648 2350186688 2465959936 65808 0.003 20 10 23 0 3622192 1733744 1822640
12:17:23 148 2147483648 2355592576 2469478400 -4048784 -0.188 20 12 29 0 3466928 1578064 5937648
12:18:24 379 2147483648 2349400656 2463522816 1157008 0.053 20 6 12 0 3683488 1798240 728240
12:19:25 205 2147483648 2354607168 2469371904 -1908480 -0.088 20 10 22 0 5101776 3201088 3809168
12:20:25 425 2147483648 2352309248 2466668544 -1185120 -0.055 20 5 11 0 7478896 5593168 3070848
12:21:26 237 2147483648 2351131744 2465337344 1041392 0.048 19 6 12 0 4166208 2390752 734064
12:22:27 211 2147483648 2370471696 2477563904 -1540768 -0.071 20 14 31 0 18086544 16193712 3433600
12:23:30 288 2147483648 2357967792 2475483136 -592688 -0.027 20 11 23 0 5800512 3901088 2492112
12:24:32 258 2147483648 2375811600 2482180096 -1539168 -0.071 20 15 32 0 20245504 18351104 3433568
12:25:33 170 2147483648 2358601360 2479591424 -2663712 -0.124 20 17 40 0 5328032 3455808 4535936
12:26:33 144 2147483648 2361358080 2479890432 -6350928 -0.296 20 12 27 0 7304512 5429920 8225520
12:27:34 282 2147483648 2368315552 2485346304 -6953584 -0.324 20 17 39 1 10595488 8696336 8852736
12:28:35 107 2147483648 2365394704 2479788032 1091216 0.050 20 5 10 0 17892688 16003360 798112
12:29:36 273 2147483648 2363939568 2477895680 -2489392 -0.116 20 8 18 0 14690688 12818272 4361808
12:30:38 346 2147483648 2371286928 2485624832 -1316528 -0.061 20 6 14 0 21773104 19895088 3194544
12:31:38 200 2147483648 2366250608 2457989120 -4047136 -0.188 20 11 27 0 12571264 10683136 5935264
12:32:39 157 2147483648 2364835344 2467594240 -3811536 -0.177 20 16 36 0 9742080 7840464 5713152
12:33:39 382 2147483648 2361943664 2472603648 -3874144 -0.180 20 11 25 1 7661808 5758944 5777008
12:34:40 284 2147483648 2368688352 2473963520 -4647760 -0.216 20 15 34 0 12421264 10519248 6549776
12:35:41 578 2147483648 2367999664 2470109184 -1781312 -0.083 20 9 21 0 20135216 18261888 3654640
12:36:42 232 2147483648 2354684256 2468978688 -21216 0.000 20 9 17 0 3336688 1463392 1894512
12:37:43 358 2147483648 2375014432 2477051904 -3547488 -0.165 20 16 35 0 19903904 18009248 5442144
12:38:44 181 2147483648 2359055616 2479714304 -3613088 -0.168 20 12 27 1 3497520 1606016 5504592
12:39:44 238 2147483648 2371980800 2488139776 -19267920 -0.905 20 14 40 0 4502592 2613536 21156976
12:40:45 227 2147483648 2373860528 2488238080 -14952064 -0.701 20 12 33 0 10177936 8291664 16838336
12:41:46 162 2147483648 2360846112 2473115648 177744 0.008 20 10 22 1 11203920 9325888 1700288
12:42:46 157 2147483648 2370297488 2484105216 -1976064 -0.092 20 11 25 0 15042656 13157632 3861088
12:43:47 242 2147483648 2368498704 2478264320 -2614448 -0.121 20 8 18 0 17563552 15673968 4504032
12:44:47 324 2147483648 2361147424 2475941888 -2581088 -0.120 19 9 21 0 6956768 5164848 4373008
12:45:48 248 2147483648 2371600640 2485506048 -9575536 -0.447 20 13 31 0 9735440 7858208 11452768
12:46:49 593 2147483648 2365828928 2482638848 -1060896 -0.049 20 12 26 0 11885248 9991632 2954512
12:47:50 306 2147483648 2364662848 2481303552 -3030960 -0.141 20 9 18 0 13548528 11661232 4918256
12:48:51 169 2147483648 2374644128 2489294848 -8103376 -0.378 20 16 37 1 12552528 10667104 9988800
12:49:51 264 2147483648 2369900352 2488061952 -9803424 -0.458 20 15 38 0 7244720 5356784 11691360
12:50:52 397 2147483648 2365765504 2490785792 -5209232 -0.243 20 12 27 0 4720096 2834624 7094704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 03-11-2026 12:51:34 to 03-11-2026 12:51:50.

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 12:51:50 to 03-11-2026 12:51:51.

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          148817
MON$OLDEST_ACTIVE               149247
MON$OLDEST_SNAPSHOT             149247
MON$NEXT_TRANSACTION            149247
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 09:00:11.9220 GMT
MON$PAGES                       113680
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                        {B057672E-85D7-4405-8433-700D1CFC5A4C}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             465
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 12:51:05 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
:10: 
:11: test-0    Tue Nov  3 12:51:06 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:13: 
:14: 
:15: test-0    Tue Nov  3 12:51:06 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:17: 
:18: 
:19: test-0    Tue Nov  3 12:51:06 2026
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:21: 
--- end of diff output ---

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

03.11.26 12:51:52. 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 12:51:53 No severe PSQL-related problems occured
03.11.26 12:51:53. End of report.