Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.11.2026 20: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 1651336 kB
MemAvailable 7289136 kB
Buffers 90232 kB
Cached 5630936 kB
SwapCached 16 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

PARAM_NAME PARAM_VALUE PARAM_DEFAULT is set ? PARAM_SOURCE
AllowEncryptedSecurityDatabase false false
AuditTraceConfigFile [empty] [empty]
AuthClient Srp256, Srp, Legacy_Auth Srp256, Srp, Legacy_Auth
AuthServer Srp256 Srp256
BugcheckAbort true false [ X ] firebird.conf
ClearGTTAtRetaining false false
ClientBatchBuffer 131072 131072
ConnectionIdleTimeout 0 0
ConnectionTimeout 180 180
CpuAffinityMask 0 0
DataTypeCompatibility
DatabaseAccess Full Full
DatabaseGrowthIncrement 134217728 134217728
DeadlockTimeout 10 10
DefaultDbCachePages 262144 2048 [ X ] firebird.conf
DefaultTimeZone
DummyPacketInterval 0 0
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb40SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OutputRedirectionFile /dev/null /dev/null
ProcessPriorityLevel 0 0
Providers Remote, Engine13, Loopback Remote, Engine13, Loopback
ReadConsistency true true
Redirection false false
RelaxedAliasChecking false false
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemotePipeName interbas interbas
RemoteServiceName gds_db gds_db
RemoteServicePort 3400 0 [ X ] firebird.conf
SecurityDatabase /opt/fb40/security4.fdb /opt/fb40/security4.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
TcpLoopbackFastPath false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
TempTableDirectory [empty] [empty]
TipCacheBlockSize 4194304 4194304
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
UseLegacyKernelObjectsNames false false
UserManager Srp Srp
WireCompression false false
WireCrypt Required
WireCryptPlugin ChaCha64, ChaCha, Arc4 ChaCha64, ChaCha, Arc4

Server and database settinfs


SERVER_MODE                     SuperServer
DB_NAME                         /var/db/oltp-emul/oltp-fb40.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/var/db/oltp-emul/oltp-fb40.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_40.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=test-0
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=html_chart_color_memo_all, val=green
param=html_chart_color_memo_att, val=green
param=html_chart_color_memo_stm, val=green
param=html_chart_color_memo_trn, val=green
param=html_chart_color_perf_score, val=green
param=init_buff, val=4096
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-fb40-results.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=50
param=tmpdir, val=/var/tmp/logs.oltp-fb40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-06 20:51:05
DTS_END                         2026-11-06 20:51:05.9840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(37:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/56606
TRN_ID                          176979
ATT_ID                          388
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: 10535.68 850 526784
customer order: creation 527.48 60 26374
customer order: refuse 42.46 51 2123
order to supplier: creation 133.92 255 6696
order to supplier: removal 10.38 7665 519
invoice (draft): creation 130.88 398 6544
invoice (draft): removal 89.42 147 4471
invoice accept: apply 112.90 1633 5645
invoice accept: cancel 74.20 223 3710
customer reserve: creation 5079.28 30 253964
customer reserve: removal 3559.44 16 177972
realization accept: apply 243.66 45 12183
realization accept: cancel 127.14 23 6357
payment from customer: creation 174.00 41 8700
payment from customer: removal 15.96 21 798
payment to supplier: creation 144.00 36 7200
payment to supplier: removal 10.22 21 511
service: total inventory turnovers 15.92 2184 796
service: total monetary turnovers 40.56 12 2028
service: aggregate perf. data 3.82 1726 191
service: refresh index statistics 0.04 2415 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 06-11-2026 20:51:34 to 06-11-2026 20:51:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10275
TEST_TIME 2 8929
TEST_TIME 3 8554
TEST_TIME 4 8394
TEST_TIME 5 8458
TEST_TIME 6 8478
TEST_TIME 7 8467
TEST_TIME 8 8491
TEST_TIME 9 8467
TEST_TIME 10 8653
TEST_TIME 11 8803
TEST_TIME 12 8947
TEST_TIME 13 9122
TEST_TIME 14 9165
TEST_TIME 15 9234
TEST_TIME 16 9360
TEST_TIME 17 9382
TEST_TIME 18 9462
TEST_TIME 19 9533
TEST_TIME 20 9611
TEST_TIME 21 9486
TEST_TIME 22 9476
TEST_TIME 23 9479
TEST_TIME 24 9452
TEST_TIME 25 9571
TEST_TIME 26 9549
TEST_TIME 27 9658
TEST_TIME 28 9789
TEST_TIME 29 9862
TEST_TIME 30 9897
TEST_TIME 31 9999
TEST_TIME 32 10035
TEST_TIME 33 10128
TEST_TIME 34 10184
TEST_TIME 35 10256
TEST_TIME 36 10319
TEST_TIME 37 10378
TEST_TIME 38 10357
TEST_TIME 39 10343
TEST_TIME 40 10399
TEST_TIME 41 10444
TEST_TIME 42 10495
TEST_TIME 43 10518
TEST_TIME 44 10529
TEST_TIME 45 10522
TEST_TIME 46 10597
TEST_TIME 47 10596
TEST_TIME 48 10642
TEST_TIME 49 10748
TEST_TIME 50 10536

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-11-2026 20:51:36 to 06-11-2026 20:51:39.

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 781121 781121 0 0.00 0 2875 3 0 0
doc_list_biud 781121 781121 0 0.00 0 2864 5 0 0
sp_add_invoice_to_stock 5645 5645 0 0.00 6 14684 1633 0 0
sp_cancel_adding_invoice 3710 3710 0 0.00 3 5115 224 0 0
sp_cancel_client_order 2123 2123 0 0.00 2 1559 52 0 0
sp_cancel_customer_reserve 177972 177972 0 0.00 1 2864 16 0 0
sp_cancel_pay_from_customer 798 798 0 0.00 2 391 22 0 0
sp_cancel_pay_to_supplier 511 511 0 0.00 2 526 22 0 0
sp_cancel_supplier_invoice 4471 4471 0 0.00 1 2298 147 0 0
sp_cancel_supplier_order 519 519 0 0.00 5 54191 7666 0 0
sp_cancel_write_off 6357 6357 0 0.00 1 1373 24 0 0
sp_client_order 26374 26374 0 0.00 3 3564 61 0 0
sp_customer_reserve 253964 253964 0 0.00 0 5301 31 0 0
sp_fill_shopping_cart 39614 39614 0 0.00 1 3034 23 0 0
sp_fill_shopping_cart_clo_res 253964 253964 0 0.00 0 1820 3 0 0
sp_get_clo_for_invoice 5645 5645 0 0.00 0 1759 34 0 0
sp_kill_cost_storno 11376 11376 0 0.00 0 1198 11 0 0
sp_kill_qstorno_ret_qs2qd 367291 367291 0 0.00 0 2287 8 0 0
sp_kill_qty_storno 212980 212980 0 0.00 0 2864 19 0 0
sp_lock_selected_doc 24736 24736 0 0.00 0 358 2 0 0
sp_make_cost_storno 33728 33728 0 0.00 0 1167 9 0 0
sp_multiply_rows_for_pdistr 33728 33728 0 0.00 0 939 13 0 0
sp_multiply_rows_for_qdistr 26374 26374 0 0.00 0 1792 22 0 0
sp_pay_from_customer 8700 8700 0 0.00 3 1671 42 0 0
sp_pay_to_supplier 7200 7200 0 0.00 3 1420 37 0 0
sp_payment_common 15900 15900 0 0.00 1 910 7 0 0
sp_qd_handle_on_cancel_clo 2123 2123 0 0.00 0 1539 35 0 0
sp_qd_handle_on_invoice_upd_sts 9355 9355 0 0.00 0 2417 71 0 0
sp_qd_handle_on_reserve_upd_sts 12183 12183 0 0.00 0 1823 13 0 0
sp_reserve_write_off 12183 12183 0 0.00 3 1831 45 0 0
sp_supplier_invoice 6544 6544 0 0.00 4 7656 398 0 0
sp_supplier_order 6696 6696 0 0.00 6 4001 256 0 0
srv_aggregate_perf_data 191 191 0 0.00 46 9512 1727 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1212 350 0 0
srv_find_qd_qs_mism 488446 488446 0 0.00 0 2874 2 0 0
srv_make_invnt_saldo 796 796 0 0.00 3 7164 2184 0 0
srv_make_money_saldo 2028 2028 0 0.00 0 216 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 278 4552 2415 0 0
v_add_invoice_to_stock 11290 11290 0 0.00 0 704 3 0 0
v_all_customers 40166 40166 0 0.00 0 121 1 0 0
v_all_suppliers 32298 32298 0 0.00 0 79 1 0 0
v_all_wares 52748 52748 0 0.00 0 93 1 0 0
v_cancel_adding_invoice 1092 1092 0 0.00 0 666 3 0 0
v_cancel_client_order 4246 4246 0 0.00 0 326 2 0 0
v_cancel_customer_prepayment 1596 1596 0 0.00 0 312 2 0 0
v_cancel_customer_reserve 1628 1628 0 0.00 0 948 2 0 0
v_cancel_payment_to_supplier 1022 1022 0 0.00 0 352 2 0 0
v_cancel_supplier_invoice 802 802 0 0.00 0 302 3 0 0
v_cancel_supplier_order 1038 1038 0 0.00 0 89 2 0 0
v_cancel_write_off 2392 2392 0 0.00 0 614 2 0 0
v_max_id_clo_ord 6696 6696 0 0.00 0 79 1 0 0
v_max_id_clo_res 1198 1198 0 0.00 0 1070 2 0 0
v_max_id_ord_sup 6544 6544 0 0.00 0 1098 3 0 0
v_max_non_paid_invoice 4291 4291 0 0.00 0 36 1 0 0
v_max_non_paid_realizn 8398 8398 0 0.00 0 84 1 0 0
v_min_id_clo_ord 6696 6696 0 0.00 0 1051 3 0 0
v_min_id_clo_res 1198 1198 0 0.00 0 1198 9 0 0
v_min_id_ord_sup 6544 6544 0 0.00 0 1637 10 0 0
v_min_non_paid_invoice 7200 7200 0 0.00 0 348 2 0 0
v_min_non_paid_realizn 8700 8700 0 0.00 0 481 2 0 0
v_our_firm 13186 13186 0 0.00 0 72 1 0 0
v_reserve_write_off 24366 24366 0 0.00 0 1626 2 0 0
x_lock_depdocs_on_canc_invoice 7780 7780 0 0.00 0 2266 9 0 0
x_lock_depdocs_on_canc_sup_ord 519 519 0 0.00 0 191 14 0 0
x_make_qstorno_1000_1200 6696 6696 0 0.00 1 3800 199 0 0
x_make_qstorno_1200_2000 6544 6544 0 0.00 1 7636 341 0 0
x_make_qstorno_2100_3300 253964 253964 0 0.00 0 5301 27 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 06-11-2026 20:51:40 to 06-11-2026 20:51:45.

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
20:01:10 2 2147483648 2309418704 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
20:02:11 206 2147483648 2543519152 2624356352 219545408 9.275 20 5 11 0 221414000 1001312 867280
20:03:11 265 2147483648 2538481792 2614804480 212685584 9.011 20 13 24 1 216280000 1708576 1885840
20:04:12 221 2147483648 2550356016 2630926336 224646272 9.470 20 9 18 1 227113104 1216592 1250240
20:05:13 154 2147483648 2533835536 2611302400 208489936 8.849 20 11 23 2 213018080 2251168 2276976
20:06:14 360 2147483648 2547846752 2630729728 221146240 9.336 20 14 25 1 225489168 2105392 2237536
20:07:15 1206 2147483648 2529270400 2606272512 203233808 8.645 20 9 16 0 206522960 1658240 1630912
20:08:16 233 2147483648 2547990848 2633887744 220951360 9.329 20 6 10 0 224761040 2668544 1141136
20:09:17 199 2147483648 2549082864 2631704576 223060560 9.409 20 11 22 2 227158512 2143488 1954464
20:10:18 295 2147483648 2541037424 2620788736 213169200 9.030 20 8 17 0 216727872 2198080 1360592
20:11:18 219 2147483648 2549627600 2632826880 216421168 9.155 20 9 18 0 226324656 8429344 1474144
20:12:19 618 2147483648 2530541936 2612367360 201618192 8.582 20 5 8 1 208263888 5700768 944928
20:13:21 190 2147483648 2546014480 2626281472 212546928 9.006 20 12 23 0 222242896 7666784 2029184
20:14:22 866 2147483648 2544255648 2627698688 217974736 9.214 20 12 20 2 221372752 1480496 1917520
20:15:23 167 2147483648 2538372800 2621542400 213036544 9.024 20 5 10 0 215638304 1797696 804064
20:16:23 203 2147483648 2543476192 2629595136 215259984 9.110 20 8 14 1 220958944 4548368 1150592
20:17:24 235 2147483648 2547825280 2629726208 218062272 9.218 20 13 25 0 224671744 4620976 1988496
20:18:25 104 2147483648 2543766224 2624385024 216896416 9.173 20 9 18 0 220398240 1819792 1682032
20:19:25 138 2147483648 2557842240 2641485824 216226320 9.147 20 13 26 0 234415024 15862560 2326144
20:20:25 340 2147483648 2549592176 2636439552 216684928 9.165 20 11 22 0 225407744 6734128 1988688
20:21:26 468 2147483648 2544133984 2623234048 206785568 8.783 19 10 21 0 222613728 14186448 1641712
20:22:27 179 2147483648 2543575952 2626789376 216884864 9.173 20 10 20 0 220446928 1895664 1666400
20:23:28 1017 2147483648 2545126528 2626338816 215248416 9.110 20 10 20 1 222554560 4643024 2663120
20:24:29 143 2147483648 2544857056 2626228224 213079616 9.026 20 11 22 0 221738016 6883728 1774672
20:25:30 663 2147483648 2555607952 2636566528 212565760 9.006 20 13 25 0 232846496 17868464 2412272
20:26:31 814 2147483648 2564234848 2647195648 208282480 8.841 19 10 19 0 239124624 29362656 1479488
20:27:32 267 2147483648 2535412576 2613694464 199462000 8.498 19 11 22 0 211816256 10481392 1872864
20:28:33 142 2147483648 2544998112 2629017600 216193888 9.146 20 6 12 0 222184688 4660176 1330624
20:29:33 189 2147483648 2557748736 2647101440 218909168 9.250 20 12 22 0 232941280 12211216 1820896
20:30:34 508 2147483648 2550234080 2636271616 214072000 9.064 20 10 20 0 226329280 10696224 1561056
20:31:35 142 2147483648 2539652144 2623565824 209686496 8.895 20 8 15 0 215450688 4753072 1011120
20:32:36 319 2147483648 2563995808 2644443136 216878656 9.172 20 15 30 0 239422896 19830304 2713936
20:33:37 331 2147483648 2542687904 2624663552 213765680 9.053 20 14 27 0 218236352 2013280 2457392
20:34:38 473 2147483648 2552733488 2634027008 215005824 9.100 20 12 22 2 228284656 11108432 2170400
20:35:38 262 2147483648 2548476752 2633166848 215337664 9.113 20 13 26 0 225637648 7908544 2391440
20:36:39 162 2147483648 2557603264 2640969728 217003328 9.177 20 10 20 0 233794080 15328272 1462480
20:37:39 175 2147483648 2546896768 2631004160 215770800 9.130 20 11 22 0 222626176 5297536 1557840
20:38:40 479 2147483648 2533905600 2615058432 202880528 8.631 19 10 18 0 211381456 6971152 1529776
20:39:41 689 2147483648 2544738752 2625220608 212778928 9.015 20 11 23 0 219901344 5314160 1808256
20:40:43 239 2147483648 2543090544 2623979520 213864944 9.056 20 13 24 0 219945440 3603280 2477216
20:41:44 602 2147483648 2555573136 2637729792 218474352 9.234 20 12 24 1 233401776 12824112 2103312
20:42:45 351 2147483648 2540331872 2623549440 211755632 8.975 20 11 22 0 216948176 3362544 1830000
20:43:46 294 2147483648 2541841168 2639659008 208873024 8.864 20 7 14 0 219713200 9755408 1084768
20:44:48 206 2147483648 2543934400 2627411968 212687184 9.011 20 7 12 0 219317136 5584768 1045184
20:45:48 407 2147483648 2541747920 2623717376 213785536 9.053 20 15 30 0 218548640 2086368 2676736
20:46:49 132 2147483648 2546248112 2633289728 217435200 9.194 20 6 10 1 223129424 4732976 961248
20:47:49 280 2147483648 2539468768 2620428288 208187376 8.837 20 10 20 0 215138464 5277168 1673920
20:48:50 251 2147483648 2542967808 2626727936 213625008 9.047 20 5 10 0 218837632 4585216 627408
20:49:52 638 2147483648 2568728400 2662346752 215830320 9.132 20 10 20 1 243420416 25583520 2006576
20:50:53 213 2147483648 2554106784 2636046336 216163008 9.145 20 11 22 0 229847744 11608128 2076608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 06-11-2026 20:51:45 to 06-11-2026 20:52:00.

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 20:52:01 to 06-11-2026 20:52:02.

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          176544
MON$OLDEST_ACTIVE               177098
MON$OLDEST_SNAPSHOT             177098
MON$NEXT_TRANSACTION            177098
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 17:00:13.8520 GMT
MON$PAGES                       126514
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {C24A4BAB-B30D-421C-98EF-242B9B6ADA4C}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             498
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


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

Database statistics


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

Database validation


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

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

--- start of diff output ---
:6: 
:7: test-0    Fri Nov  6 20:51:07 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'

06.11.26 20:52:03. 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-06 20:52:04 No severe PSQL-related problems occured
06.11.26 20:52:05. End of report.