Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 07.11.2026 01: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 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 2429444 kB
MemAvailable 7432680 kB
Buffers 90312 kB
Cached 4998064 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
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb50SS 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
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OuterJoinConversion true true
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
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
RemoteServiceName gds_db gds_db
RemoteServicePort 3500 0 [ X ] firebird.conf
SecurityDatabase /opt/fb50/security5.fdb /opt/fb50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
SubQueryConversion 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
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-fb50.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-fb50.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_50.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb50/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=blue
param=html_chart_color_memo_att, val=blue
param=html_chart_color_memo_stm, val=blue
param=html_chart_color_memo_trn, val=blue
param=html_chart_color_perf_score, val=blue
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=3500
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-fb50-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-fb50
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-07 01:50:47
DTS_END                         2026-11-07 01:50:47.7360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/55632
TRN_ID                          220025
ATT_ID                          470
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: 13889.64 1183 694482
customer order: creation 650.08 43 32504
customer order: refuse 54.46 43 2723
order to supplier: creation 164.56 196 8228
order to supplier: removal 12.30 7581 615
invoice (draft): creation 165.14 327 8257
invoice (draft): removal 118.30 119 5915
invoice accept: apply 141.24 1343 7062
invoice accept: cancel 96.80 176 4840
customer reserve: creation 6611.94 24 330597
customer reserve: removal 4894.36 13 244718
realization accept: apply 304.70 31 15235
realization accept: cancel 174.80 17 8740
payment from customer: creation 215.34 30 10767
payment from customer: removal 20.14 19 1007
payment to supplier: creation 176.18 25 8809
payment to supplier: removal 12.90 16 645
service: total inventory turnovers 20.26 1714 1013
service: total monetary turnovers 51.28 13 2564
service: aggregate perf. data 4.80 1401 240
service: refresh index statistics 0.06 10538 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 07-11-2026 01:51:04 to 07-11-2026 01:51:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5453
TEST_TIME 2 7331
TEST_TIME 3 7860
TEST_TIME 4 8449
TEST_TIME 5 8802
TEST_TIME 6 9098
TEST_TIME 7 9476
TEST_TIME 8 9876
TEST_TIME 9 10062
TEST_TIME 10 10193
TEST_TIME 11 10480
TEST_TIME 12 10812
TEST_TIME 13 11044
TEST_TIME 14 11413
TEST_TIME 15 11578
TEST_TIME 16 11787
TEST_TIME 17 11939
TEST_TIME 18 11985
TEST_TIME 19 11957
TEST_TIME 20 12034
TEST_TIME 21 12149
TEST_TIME 22 12268
TEST_TIME 23 12259
TEST_TIME 24 12369
TEST_TIME 25 12329
TEST_TIME 26 12342
TEST_TIME 27 12512
TEST_TIME 28 12549
TEST_TIME 29 12539
TEST_TIME 30 12695
TEST_TIME 31 12701
TEST_TIME 32 12761
TEST_TIME 33 12831
TEST_TIME 34 12918
TEST_TIME 35 13057
TEST_TIME 36 13085
TEST_TIME 37 13187
TEST_TIME 38 13312
TEST_TIME 39 13305
TEST_TIME 40 13364
TEST_TIME 41 13377
TEST_TIME 42 13517
TEST_TIME 43 13512
TEST_TIME 44 13603
TEST_TIME 45 13666
TEST_TIME 46 13676
TEST_TIME 47 13717
TEST_TIME 48 13836
TEST_TIME 49 13883
TEST_TIME 50 13890

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 07-11-2026 01:51:06 to 07-11-2026 01:51:08.

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 1024860 1024860 0 0.00 0 2475 2 0 0
doc_list_biud 1024860 1024860 0 0.00 0 3596 5 0 0
sp_add_invoice_to_stock 7062 7062 0 0.00 5 14172 1344 0 0
sp_cancel_adding_invoice 4840 4840 0 0.00 3 5161 176 0 0
sp_cancel_client_order 2723 2723 0 0.00 2 1440 43 0 0
sp_cancel_customer_reserve 244718 244718 0 0.00 1 3596 14 0 0
sp_cancel_pay_from_customer 1007 1007 0 0.00 1 1023 19 0 0
sp_cancel_pay_to_supplier 645 645 0 0.00 1 330 17 0 0
sp_cancel_supplier_invoice 5915 5915 0 0.00 1 2249 120 0 0
sp_cancel_supplier_order 615 615 0 0.00 4 50798 7582 0 0
sp_cancel_write_off 8740 8740 0 0.00 1 1183 18 0 0
sp_client_order 32504 32504 0 0.00 2 2623 43 0 0
sp_customer_reserve 330597 330597 0 0.00 0 3930 25 0 0
sp_fill_shopping_cart 48989 48989 0 0.00 0 2210 17 0 0
sp_fill_shopping_cart_clo_res 330597 330597 0 0.00 0 1829 2 0 0
sp_get_clo_for_invoice 7062 7062 0 0.00 0 1869 29 0 0
sp_kill_cost_storno 15232 15232 0 0.00 0 1105 8 0 0
sp_kill_qstorno_ret_qs2qd 504706 504706 0 0.00 0 3593 7 0 0
sp_kill_qty_storno 289848 289848 0 0.00 0 3596 16 0 0
sp_lock_selected_doc 31011 31011 0 0.00 0 567 1 0 0
sp_make_cost_storno 41873 41873 0 0.00 0 2465 6 0 0
sp_multiply_rows_for_pdistr 41873 41873 0 0.00 0 704 9 0 0
sp_multiply_rows_for_qdistr 32504 32504 0 0.00 0 2463 18 0 0
sp_pay_from_customer 10767 10767 0 0.00 2 2478 30 0 0
sp_pay_to_supplier 8809 8809 0 0.00 2 2355 26 0 0
sp_payment_common 19576 19576 0 0.00 0 1032 6 0 0
sp_qd_handle_on_cancel_clo 2723 2723 0 0.00 0 1375 29 0 0
sp_qd_handle_on_invoice_upd_sts 11902 11902 0 0.00 0 1884 64 0 0
sp_qd_handle_on_reserve_upd_sts 15235 15235 0 0.00 0 1895 10 0 0
sp_reserve_write_off 15235 15235 0 0.00 2 1899 31 0 0
sp_supplier_invoice 8257 8257 0 0.00 3 7231 327 0 0
sp_supplier_order 8228 8228 0 0.00 3 4143 197 0 0
srv_aggregate_perf_data 240 240 0 0.00 75 6089 1402 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 565 304 0 0
srv_find_qd_qs_mism 646740 646740 0 0.00 0 1791 1 0 0
srv_make_invnt_saldo 1013 1013 0 0.00 1 4887 1715 0 0
srv_make_money_saldo 2564 2564 0 0.00 0 258 14 0 0
srv_recalc_idx_stat 3 3 0 0.00 1783 17081 10539 0 0
v_add_invoice_to_stock 14124 14124 0 0.00 0 585 2 0 0
v_all_customers 49718 49718 0 0.00 0 171 0 0 0
v_all_suppliers 40128 40128 0 0.00 0 227 0 0 0
v_all_wares 65008 65008 0 0.00 0 107 0 0 0
v_cancel_adding_invoice 1160 1160 0 0.00 0 242 3 0 0
v_cancel_client_order 5446 5446 0 0.00 0 694 2 0 0
v_cancel_customer_prepayment 2014 2014 0 0.00 0 63 1 0 0
v_cancel_customer_reserve 2058 2058 0 0.00 0 291 2 0 0
v_cancel_payment_to_supplier 1290 1290 0 0.00 0 300 2 0 0
v_cancel_supplier_invoice 1208 1208 0 0.00 0 486 3 0 0
v_cancel_supplier_order 1230 1230 0 0.00 0 120 2 0 0
v_cancel_write_off 3022 3022 0 0.00 0 265 2 0 0
v_max_id_clo_ord 8228 8228 0 0.00 0 240 1 0 0
v_max_id_clo_res 1395 1395 0 0.00 0 100 1 0 0
v_max_id_ord_sup 8257 8257 0 0.00 0 900 2 0 0
v_max_non_paid_invoice 5230 5230 0 0.00 0 120 1 0 0
v_max_non_paid_realizn 10366 10366 0 0.00 0 157 1 0 0
v_min_id_clo_ord 8228 8228 0 0.00 0 571 2 0 0
v_min_id_clo_res 1395 1395 0 0.00 0 948 3 0 0
v_min_id_ord_sup 8257 8257 0 0.00 0 1285 5 0 0
v_min_non_paid_invoice 8809 8809 0 0.00 0 477 2 0 0
v_min_non_paid_realizn 10767 10767 0 0.00 0 610 2 0 0
v_our_firm 16092 16092 0 0.00 0 135 1 0 0
v_reserve_write_off 30470 30470 0 0.00 0 523 1 0 0
x_lock_depdocs_on_canc_invoice 10151 10151 0 0.00 0 851 8 0 0
x_lock_depdocs_on_canc_sup_ord 615 615 0 0.00 0 180 10 0 0
x_make_qstorno_1000_1200 8228 8228 0 0.00 1 4137 148 0 0
x_make_qstorno_1200_2000 8257 8257 0 0.00 1 7215 287 0 0
x_make_qstorno_2100_3300 330597 330597 0 0.00 0 3916 21 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 07-11-2026 01:51:08 to 07-11-2026 01:51:11.

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
01:00:51 3 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
01:01:53 362 2147483648 2527517168 2806480896 273525280 11.297 20 8 17 0 274572688 711136 336272
01:02:54 235 2147483648 2521197904 2763206656 268206624 11.102 20 5 10 0 270411824 1938016 267184
01:03:55 319 2147483648 2507427328 2730098688 250577280 10.449 20 9 17 0 252393520 1432544 383696
01:04:55 164 2147483648 2528395152 2776231936 272182912 11.248 20 15 30 0 274594672 1875760 536000
01:05:56 261 2147483648 2507637200 2719760384 249574816 10.411 20 12 23 0 252052016 2068896 408304
01:06:57 212 2147483648 2527375104 2774650880 270370608 11.182 20 8 16 0 273834016 3181168 282240
01:07:57 196 2147483648 2510435632 2733666304 255747360 10.641 20 12 24 1 257764288 1660288 356640
01:08:58 203 2147483648 2526723680 2773303296 268895248 11.128 20 12 23 0 273012464 3603024 514192
01:09:58 488 2147483648 2504062944 2717544448 241993120 10.127 19 8 12 1 248085888 5905872 186896
01:10:59 223 2147483648 2529148784 2778103808 270403840 11.183 20 4 8 0 274345696 3694160 247696
01:12:00 271 2147483648 2527349168 2773991424 269656096 11.155 20 11 22 0 272842624 2816400 370128
01:13:00 314 2147483648 2520395136 2752917504 256162416 10.657 19 14 27 1 262760720 6077952 520352
01:14:01 363 2147483648 2538361664 2783961088 265308016 10.995 20 11 23 0 282647616 16877888 461712
01:15:02 159 2147483648 2524758704 2770853888 266901728 11.054 20 10 21 0 270038352 2815616 321008
01:16:02 229 2147483648 2535394512 2789470208 269381360 11.145 20 16 32 0 280623712 10540976 701376
01:17:03 263 2147483648 2539654944 2791010304 268048912 11.096 20 10 18 1 288030192 19509840 471440
01:18:03 449 2147483648 2531345424 2774360064 269216464 11.139 20 12 24 0 274996256 5289184 490608
01:19:04 384 2147483648 2536022736 2781130752 268033232 11.096 20 12 24 1 275468368 6980016 455120
01:20:06 322 2147483648 2525358464 2775261184 263999744 10.947 20 8 16 0 269340800 4812624 528432
01:21:06 380 2147483648 2534187952 2770673664 262312912 10.885 20 10 20 0 278818928 15895472 610544
01:22:07 474 2147483648 2534580880 2774192128 265093648 10.987 20 7 14 0 278400944 13018784 288512
01:23:10 304 2147483648 2534362384 2780311552 270550048 11.188 20 7 14 1 279076192 8216624 309520
01:24:10 268 2147483648 2540557408 2787840000 270468576 11.185 20 7 14 0 286104816 15341888 294352
01:25:11 281 2147483648 2516542736 2745643008 254639280 10.600 19 13 26 0 260541856 5387760 514816
01:26:12 252 2147483648 2530681360 2770006016 267252752 11.067 20 8 17 0 275175744 7562096 360896
01:27:12 453 2147483648 2558981152 2800128000 270078128 11.171 20 15 30 0 301552048 30738768 735152
01:28:14 353 2147483648 2519111152 2737147904 247677232 10.340 19 9 18 0 262451328 14397888 376208
01:29:18 229 2147483648 2533057888 2771836928 269044960 11.133 20 14 26 1 278590480 8835216 710304
01:30:18 322 2147483648 2558058336 2772328448 263268208 10.920 20 10 20 0 301521152 37703264 549680
01:31:19 168 2147483648 2533158160 2770894848 270412864 11.183 20 11 22 0 277812336 6989664 409808
01:32:19 248 2147483648 2536831984 2780889088 270242656 11.177 20 13 27 1 280981728 10109728 629344
01:33:20 266 2147483648 2537445408 2777092096 264152416 10.953 20 11 22 0 281743792 17087232 504144
01:34:21 170 2147483648 2533924576 2774130688 263954000 10.945 20 8 16 1 277655136 13263936 437200
01:35:21 334 2147483648 2541898272 2779783168 266851248 11.052 20 14 28 0 284121616 16723744 546624
01:36:22 558 2147483648 2541317440 2775740416 259591392 10.784 20 10 20 0 285941104 25792368 557344
01:37:23 282 2147483648 2537161552 2784641024 269792048 11.160 20 13 26 0 280740320 10473600 474672
01:38:23 442 2147483648 2532985664 2774876160 267284480 11.068 20 10 19 0 275034640 7365088 385072
01:39:24 220 2147483648 2535293040 2783027200 268203728 11.102 20 14 29 0 276944832 8105088 636016
01:40:24 240 2147483648 2537893216 2777477120 266648960 11.045 20 16 30 1 282250544 14894080 707504
01:41:25 291 2147483648 2532979344 2774413312 265064720 10.986 20 12 24 0 277276384 11600240 611424
01:42:25 364 2147483648 2549536752 2797559808 269393536 11.146 20 9 18 0 292657104 22918832 344736
01:43:26 421 2147483648 2533307840 2776502272 269423584 11.147 20 9 17 0 275938912 6265136 250192
01:44:28 474 2147483648 2539551216 2783805440 267315360 11.069 20 11 22 0 282470112 14708592 446160
01:45:30 350 2147483648 2533162352 2769289216 263180496 10.917 20 13 26 0 276249312 12400912 667904
01:46:31 212 2147483648 2535606336 2781855744 269865424 11.163 20 7 14 0 280024176 9889472 269280
01:47:32 344 2147483648 2529542464 2775117824 257385744 10.702 20 10 20 0 264611360 6890848 334768
01:48:32 355 2147483648 2541473824 2797965312 267351168 11.071 20 11 22 0 288360592 20476960 532464
01:49:33 339 2147483648 2540764576 2791501824 270435136 11.184 20 10 20 0 284489024 13555088 498800
01:50:34 218 2147483648 2534522496 2787057664 267119248 11.062 20 8 16 0 278043712 10522064 402400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 07-11-2026 01:51:12 to 07-11-2026 01:51:23.

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 07-11-2026 01:51:23 to 07-11-2026 01:51:24.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          220158
MON$OLDEST_ACTIVE               220159
MON$OLDEST_SNAPSHOT             220159
MON$NEXT_TRANSACTION            220159
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 22:00:10.7360 GMT
MON$PAGES                       182308
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                        {CACE5FEA-9B27-4989-B394-12B7919B33CA}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             582
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1952 Firebird 5.0 7a88a7d
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d/tcp (test-0)/P19:C"
on disk structure version 13.1

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    Sat Nov  7 01:50:48 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:9: 
--- end of diff output ---

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

07.11.26 01:51:24. There are 3 logs in /var/tmp/logs.oltp-fb50 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-07 01:51:25 No severe PSQL-related problems occured
07.11.26 01:51:25. End of report.