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

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+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 2w 2d
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 1960936 kB
MemAvailable 7276104 kB
Buffers 79092 kB
Cached 5317184 kB
SwapCached 12 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

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

Server and database settinfs


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


Test configuration settings

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

Test finish info


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2026-11-17 02:50:47
DTS_END                         2026-11-17 02:50:47.1560
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(95:17)
IP                              ::1/46446
TRN_ID                          238597
ATT_ID                          489
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: 16429.22 836 821461
customer order: creation 706.24 43 35312
customer order: refuse 56.94 43 2847
order to supplier: creation 178.46 201 8923
order to supplier: removal 13.18 8328 659
invoice (draft): creation 176.30 351 8815
invoice (draft): removal 129.66 131 6483
invoice accept: apply 152.74 1414 7637
invoice accept: cancel 108.66 186 5433
customer reserve: creation 7862.78 23 393139
customer reserve: removal 5965.60 13 298280
realization accept: apply 339.16 33 16958
realization accept: cancel 191.98 18 9599
payment from customer: creation 231.12 31 11556
payment from customer: removal 22.12 18 1106
payment to supplier: creation 192.52 32 9626
payment to supplier: removal 12.42 15 621
service: total inventory turnovers 26.12 1237 1306
service: total monetary turnovers 57.92 13 2896
service: aggregate perf. data 5.26 2168 263
service: refresh index statistics 0.04 2430 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 17-11-2026 02:50:59 to 17-11-2026 02:51:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11480
TEST_TIME 2 12585
TEST_TIME 3 13194
TEST_TIME 4 13662
TEST_TIME 5 13883
TEST_TIME 6 13984
TEST_TIME 7 14171
TEST_TIME 8 14486
TEST_TIME 9 14535
TEST_TIME 10 14653
TEST_TIME 11 14875
TEST_TIME 12 15067
TEST_TIME 13 15072
TEST_TIME 14 15173
TEST_TIME 15 15232
TEST_TIME 16 15197
TEST_TIME 17 15347
TEST_TIME 18 15415
TEST_TIME 19 15393
TEST_TIME 20 15439
TEST_TIME 21 15436
TEST_TIME 22 15356
TEST_TIME 23 15379
TEST_TIME 24 15490
TEST_TIME 25 15498
TEST_TIME 26 15448
TEST_TIME 27 15567
TEST_TIME 28 15381
TEST_TIME 29 15603
TEST_TIME 30 15505
TEST_TIME 31 15569
TEST_TIME 32 15673
TEST_TIME 33 15717
TEST_TIME 34 15794
TEST_TIME 35 15809
TEST_TIME 36 15845
TEST_TIME 37 15933
TEST_TIME 38 16034
TEST_TIME 39 16041
TEST_TIME 40 16120
TEST_TIME 41 16124
TEST_TIME 42 16229
TEST_TIME 43 16221
TEST_TIME 44 16456
TEST_TIME 45 16382
TEST_TIME 46 16402
TEST_TIME 47 16392
TEST_TIME 48 16479
TEST_TIME 49 16479
TEST_TIME 50 16429

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-11-2026 02:51:01 to 17-11-2026 02:51:04.

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 1206559 1206559 0 0.00 0 1538 2 0 0
doc_list_biud 1206559 1206559 0 0.00 0 2748 5 0 0
sp_add_invoice_to_stock 7637 7637 0 0.00 5 11219 1415 0 0
sp_cancel_adding_invoice 5433 5433 0 0.00 3 4366 186 0 0
sp_cancel_client_order 2847 2847 0 0.00 3 1363 44 0 0
sp_cancel_customer_reserve 298280 298280 0 0.00 1 1829 13 0 0
sp_cancel_pay_from_customer 1106 1106 0 0.00 2 645 18 0 0
sp_cancel_pay_to_supplier 621 621 0 0.00 2 182 15 0 0
sp_cancel_supplier_invoice 6483 6483 0 0.00 1 2464 131 0 0
sp_cancel_supplier_order 659 659 0 0.00 4 57666 8329 0 0
sp_cancel_write_off 9599 9599 0 0.00 1 1669 19 0 0
sp_client_order 35312 35312 0 0.00 3 1477 43 0 0
sp_customer_reserve 393139 393139 0 0.00 0 3550 24 0 0
sp_fill_shopping_cart 53050 53050 0 0.00 1 2261 20 0 0
sp_fill_shopping_cart_clo_res 393139 393139 0 0.00 0 1472 2 0 0
sp_get_clo_for_invoice 7637 7637 0 0.00 0 1774 34 0 0
sp_kill_cost_storno 16759 16759 0 0.00 0 1055 9 0 0
sp_kill_qstorno_ret_qs2qd 613301 613301 0 0.00 0 2461 7 0 0
sp_kill_qty_storno 347896 347896 0 0.00 0 2748 15 0 0
sp_lock_selected_doc 33803 33803 0 0.00 0 186 1 0 0
sp_make_cost_storno 45777 45777 0 0.00 0 749 6 0 0
sp_multiply_rows_for_pdistr 45777 45777 0 0.00 0 720 10 0 0
sp_multiply_rows_for_qdistr 35312 35312 0 0.00 0 1343 17 0 0
sp_pay_from_customer 11556 11556 0 0.00 2 1150 31 0 0
sp_pay_to_supplier 9626 9626 0 0.00 3 1040 33 0 0
sp_payment_common 21182 21182 0 0.00 1 568 9 0 0
sp_qd_handle_on_cancel_clo 2847 2847 0 0.00 0 1356 29 0 0
sp_qd_handle_on_invoice_upd_sts 13070 13070 0 0.00 0 2748 64 0 0
sp_qd_handle_on_reserve_upd_sts 16958 16958 0 0.00 0 1456 10 0 0
sp_reserve_write_off 16958 16958 0 0.00 3 1463 34 0 0
sp_supplier_invoice 8815 8815 0 0.00 4 6394 351 0 0
sp_supplier_order 8923 8923 0 0.00 5 1821 202 0 0
srv_aggregate_perf_data 263 263 0 0.00 46 39723 2168 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 710 230 0 0
srv_find_qd_qs_mism 765773 765773 0 0.00 0 1538 1 0 0
srv_make_invnt_saldo 1306 1306 0 0.00 3 4251 1237 0 0
srv_make_money_saldo 2896 2896 0 0.00 0 239 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 151 4710 2431 0 0
v_add_invoice_to_stock 15274 15274 0 0.00 0 699 2 0 0
v_all_customers 53394 53394 0 0.00 0 33 1 0 0
v_all_suppliers 44260 44260 0 0.00 0 36 1 0 0
v_all_wares 70624 70624 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 1282 1282 0 0.00 0 318 2 0 0
v_cancel_client_order 5694 5694 0 0.00 0 467 1 0 0
v_cancel_customer_prepayment 2212 2212 0 0.00 0 343 2 0 0
v_cancel_customer_reserve 2218 2218 0 0.00 0 329 2 0 0
v_cancel_payment_to_supplier 1242 1242 0 0.00 0 114 1 0 0
v_cancel_supplier_invoice 1246 1246 0 0.00 0 195 2 0 0
v_cancel_supplier_order 1318 1318 0 0.00 0 31 1 0 0
v_cancel_write_off 3204 3204 0 0.00 0 291 2 0 0
v_max_id_clo_ord 8923 8923 0 0.00 0 62 1 0 0
v_max_id_clo_res 1658 1658 0 0.00 0 438 1 0 0
v_max_id_ord_sup 8815 8815 0 0.00 0 783 2 0 0
v_max_non_paid_invoice 5234 5234 0 0.00 0 29 1 0 0
v_max_non_paid_realizn 11286 11286 0 0.00 0 66 1 0 0
v_min_id_clo_ord 8923 8923 0 0.00 0 309 2 0 0
v_min_id_clo_res 1658 1658 0 0.00 0 545 3 0 0
v_min_id_ord_sup 8815 8815 0 0.00 0 1160 5 0 0
v_min_non_paid_invoice 9626 9626 0 0.00 0 375 7 0 0
v_min_non_paid_realizn 11556 11556 0 0.00 0 329 3 0 0
v_our_firm 17770 17770 0 0.00 0 24 1 0 0
v_reserve_write_off 33916 33916 0 0.00 0 760 1 0 0
x_lock_depdocs_on_canc_invoice 11293 11293 0 0.00 0 1209 11 0 0
x_lock_depdocs_on_canc_sup_ord 659 659 0 0.00 0 548 13 0 0
x_make_qstorno_1000_1200 8923 8923 0 0.00 1 1793 146 0 0
x_make_qstorno_1200_2000 8815 8815 0 0.00 1 6262 307 0 0
x_make_qstorno_2100_3300 393139 393139 0 0.00 0 3547 20 0 0

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

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
02:00:50 3 2147483648 2309418672 2313068544 3168592 0.147 1 1 2 0 3266032 61664 35776
02:01:51 313 2147483648 2523719184 2596761600 198831120 8.474 20 12 27 1 202670528 707712 3131696
02:02:51 339 2147483648 2525284672 2598539264 195617072 8.348 20 10 20 0 200815040 3714272 1483696
02:03:52 179 2147483648 2542130016 2623057920 216409232 9.154 20 12 24 0 219639344 1264416 1965696
02:04:52 143 2147483648 2552730416 2638401536 218510144 9.235 20 5 10 0 230136480 10858288 768048
02:05:53 185 2147483648 2544380512 2623143936 209972816 8.906 20 13 26 1 220149488 7735360 2441312
02:06:53 158 2147483648 2540200880 2619244544 208490112 8.849 20 10 20 0 216227184 6114752 1622320
02:07:54 158 2147483648 2550675552 2630807552 217973136 9.214 20 16 33 0 227298032 6762464 2562432
02:08:54 213 2147483648 2521580576 2597277696 192179376 8.213 19 12 24 0 199102832 5004240 1919216
02:09:54 226 2147483648 2553215744 2633224192 218401712 9.231 20 13 25 1 229864432 8926768 2535952
02:10:55 177 2147483648 2547589104 2628378624 211907360 8.981 20 13 27 0 224583840 10166624 2509856
02:11:55 199 2147483648 2540673136 2620968960 213136048 9.028 20 12 22 0 217372064 1927808 2308208
02:12:56 364 2147483648 2549324272 2628562944 212401648 9.000 20 12 22 0 225164960 10491440 2271872
02:13:56 226 2147483648 2546256048 2626818048 215967536 9.137 20 12 23 0 223331008 5285664 2077808
02:14:57 322 2147483648 2552129424 2632650752 218551840 9.237 20 15 30 0 227640112 6463760 2624512
02:15:58 314 2147483648 2551908608 2632949760 215960016 9.137 20 19 35 1 228380944 9773424 2647504
02:16:58 231 2147483648 2567252144 2648494080 217503888 9.196 20 14 28 0 243637056 23643984 2489184
02:17:59 228 2147483648 2559459776 2640838656 216501648 9.158 20 13 27 0 235723776 16657024 2565104
02:18:59 163 2147483648 2539647072 2618990592 206096864 8.756 19 12 24 0 214336016 6199376 2039776
02:20:00 208 2147483648 2552975664 2634162176 215274512 9.111 20 14 28 0 229940672 12389088 2277072
02:21:01 260 2147483648 2531417840 2610438144 205525584 8.734 20 12 22 0 208716096 1402384 1788128
02:22:01 322 2147483648 2547841840 2631213056 218975648 9.253 20 11 22 0 223686560 2775232 1935680
02:23:02 191 2147483648 2559028848 2639052800 216696928 9.165 20 16 31 0 234513456 15026960 2789568
02:24:03 225 2147483648 2557741136 2638716928 210490192 8.926 20 14 26 0 231202656 18057216 2655248
02:25:04 197 2147483648 2562246320 2642829312 215473968 9.118 20 14 28 0 237664688 19804352 2386368
02:26:04 117 2147483648 2555040848 2637774848 220082032 9.295 20 10 20 0 231125840 9009728 2034080
02:27:04 266 2147483648 2560627968 2640601088 215667904 9.126 20 17 33 0 235372944 17079728 2625312
02:28:05 117 2147483648 2547875408 2628382720 216431168 9.155 20 11 21 0 223732800 5172864 2128768
02:29:05 211 2147483648 2551411904 2642673664 218706640 9.242 20 10 20 0 227522912 6986688 1829584
02:30:05 188 2147483648 2548675600 2627600384 213181504 9.030 20 16 29 1 223716064 7938704 2595856
02:31:06 139 2147483648 2565376304 2648739840 212543648 9.005 20 11 19 0 241170240 26853632 1772960
02:32:06 149 2147483648 2551768192 2634219520 220821216 9.324 20 12 24 0 227440112 4499408 2119488
02:33:06 354 2147483648 2544371328 2626912256 212319008 8.997 20 5 10 0 222235520 9279520 636992
02:34:07 236 2147483648 2533173408 2613518336 204063792 8.677 19 11 23 0 210643872 4351712 2228368
02:35:08 194 2147483648 2548649856 2630057984 212422512 9.001 20 15 30 0 224391488 9069408 2899568
02:36:09 147 2147483648 2556374480 2639503360 216181232 9.146 20 11 22 0 231762992 13415600 2166160
02:37:09 232 2147483648 2558685072 2640687104 219692848 9.280 20 14 28 0 232952016 10658416 2600752
02:38:10 171 2147483648 2553798736 2644500480 217184240 9.184 20 9 16 0 232470080 13994480 1291360
02:39:11 347 2147483648 2549601760 2636591104 215933072 9.136 20 14 26 1 230678256 11343520 3401664
02:40:11 253 2147483648 2555380784 2636505088 214664608 9.087 20 12 24 0 230314800 13395344 2254848
02:41:12 219 2147483648 2539364416 2621378560 210566448 8.929 20 6 12 0 215251264 3309040 1375776
02:42:12 97 2147483648 2540406512 2616770560 192931744 8.243 19 14 28 0 216302176 21082064 2288368
02:43:13 257 2147483648 2566254400 2649104384 218920048 9.251 20 13 26 0 241431216 20604048 1907120
02:44:13 214 2147483648 2589258384 2693574656 221647168 9.355 20 11 22 0 264407280 40758640 2001472
02:45:14 710 2147483648 2543029312 2626846720 205590112 8.737 19 8 16 1 212310576 5597616 1122848
02:46:15 261 2147483648 2544760608 2628116480 213796304 9.054 20 11 22 0 221137328 5282080 2058944
02:47:15 218 2147483648 2545677472 2629591040 215112480 9.104 20 12 23 0 221177696 4320048 1745168
02:48:15 155 2147483648 2545194144 2633420800 210792976 8.938 20 7 12 0 220329152 8666656 869520
02:49:16 347 2147483648 2547131376 2626756608 209716720 8.896 20 15 29 0 221682592 9796960 2168912
02:50:16 125 2147483648 2552691808 2635005952 216707216 9.166 20 15 29 0 227814992 8638064 2469712

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 17-11-2026 02:51:20 to 17-11-2026 02:51:21.

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          238658
MON$OLDEST_ACTIVE               238824
MON$OLDEST_SNAPSHOT             238824
MON$NEXT_TRANSACTION            238824
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-16 23:00:09.8850 GMT
MON$PAGES                       161432
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {6C93DC48-B54F-4682-8F3A-4CB6FC018F0A}
MON$FILE_ID                     01080000000000009fed070000000000
MON$NEXT_ATTACHMENT             597
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.8.3342 Firebird 4.0 a02a946
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.8.3342 Firebird 4.0 a02a946"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.8.3342 Firebird 4.0 a02a946/tcp (test-0)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.8.3342 Firebird 4.0 a02a946/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    Tue Nov 17 02:50:48 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'

17.11.26 02:51:21. 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-17 02:51:23 No severe PSQL-related problems occured
17.11.26 02:51:23. End of report.