Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 02.11.2026 07: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 2d
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 2494268 kB
MemAvailable 7448512 kB
Buffers 80112 kB
Cached 4997156 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-02 07:50:41
DTS_END                         2026-11-02 07:50:41.2630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(211:18) ==> SP_CANCEL_CUSTOMER_RESERVE(55:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/46898
TRN_ID                          227718
ATT_ID                          475
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: 15080.70 1023 754035
customer order: creation 672.10 38 33605
customer order: refuse 53.78 39 2689
order to supplier: creation 172.90 182 8645
order to supplier: removal 13.60 7744 680
invoice (draft): creation 171.14 316 8557
invoice (draft): removal 122.24 129 6112
invoice accept: apply 147.66 1337 7383
invoice accept: cancel 102.36 201 5118
customer reserve: creation 7225.76 23 361288
customer reserve: removal 5395.38 14 269769
realization accept: apply 312.54 32 15627
realization accept: cancel 167.72 18 8386
payment from customer: creation 224.18 29 11209
payment from customer: removal 19.68 19 984
payment to supplier: creation 186.72 23 9336
payment to supplier: removal 12.90 16 645
service: total inventory turnovers 22.08 1502 1104
service: total monetary turnovers 52.48 12 2624
service: aggregate perf. data 5.44 1375 272
service: refresh index statistics 0.04 7406 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 02-11-2026 07:50:54 to 02-11-2026 07:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13477
TEST_TIME 2 13491
TEST_TIME 3 14125
TEST_TIME 4 14340
TEST_TIME 5 14436
TEST_TIME 6 14371
TEST_TIME 7 14349
TEST_TIME 8 14222
TEST_TIME 9 14441
TEST_TIME 10 14325
TEST_TIME 11 14369
TEST_TIME 12 14336
TEST_TIME 13 14644
TEST_TIME 14 14647
TEST_TIME 15 14824
TEST_TIME 16 14776
TEST_TIME 17 14673
TEST_TIME 18 14665
TEST_TIME 19 14672
TEST_TIME 20 14628
TEST_TIME 21 14704
TEST_TIME 22 14671
TEST_TIME 23 14711
TEST_TIME 24 14688
TEST_TIME 25 14617
TEST_TIME 26 14660
TEST_TIME 27 14808
TEST_TIME 28 14749
TEST_TIME 29 14779
TEST_TIME 30 14722
TEST_TIME 31 14736
TEST_TIME 32 14737
TEST_TIME 33 14765
TEST_TIME 34 14771
TEST_TIME 35 14809
TEST_TIME 36 14873
TEST_TIME 37 14895
TEST_TIME 38 14904
TEST_TIME 39 14895
TEST_TIME 40 14844
TEST_TIME 41 14816
TEST_TIME 42 14864
TEST_TIME 43 14872
TEST_TIME 44 14939
TEST_TIME 45 15044
TEST_TIME 46 15063
TEST_TIME 47 15134
TEST_TIME 48 15078
TEST_TIME 49 15172
TEST_TIME 50 15081

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:01, from 02-11-2026 07:50:56 to 02-11-2026 07:50:57.

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 1111618 1111618 0 0.00 0 1646 2 0 0
doc_list_biud 1111618 1111618 0 0.00 0 2401 5 0 0
sp_add_invoice_to_stock 7383 7383 0 0.00 2 14147 1338 0 0
sp_cancel_adding_invoice 5118 5118 0 0.00 3 4858 201 0 0
sp_cancel_client_order 2689 2689 0 0.00 2 1642 39 0 0
sp_cancel_customer_reserve 269769 269769 0 0.00 1 2351 15 0 0
sp_cancel_pay_from_customer 984 984 0 0.00 1 1058 19 0 0
sp_cancel_pay_to_supplier 645 645 0 0.00 1 353 16 0 0
sp_cancel_supplier_invoice 6112 6112 0 0.00 1 1829 129 0 0
sp_cancel_supplier_order 680 680 0 0.00 5 48669 7745 0 0
sp_cancel_write_off 8386 8386 0 0.00 1 1001 18 0 0
sp_client_order 33605 33605 0 0.00 2 2378 39 0 0
sp_customer_reserve 361288 361288 0 0.00 0 3470 23 0 0
sp_fill_shopping_cart 50807 50807 0 0.00 0 2239 16 0 0
sp_fill_shopping_cart_clo_res 361288 361288 0 0.00 0 1517 2 0 0
sp_get_clo_for_invoice 7383 7383 0 0.00 0 2827 31 0 0
sp_kill_cost_storno 15133 15133 0 0.00 0 1050 8 0 0
sp_kill_qstorno_ret_qs2qd 554716 554716 0 0.00 0 2264 7 0 0
sp_kill_qty_storno 315764 315764 0 0.00 0 2401 17 0 0
sp_lock_selected_doc 31833 31833 0 0.00 0 1289 1 0 0
sp_make_cost_storno 43555 43555 0 0.00 0 1408 6 0 0
sp_multiply_rows_for_pdistr 43555 43555 0 0.00 0 1298 9 0 0
sp_multiply_rows_for_qdistr 33605 33605 0 0.00 0 2358 16 0 0
sp_pay_from_customer 11209 11209 0 0.00 1 1416 30 0 0
sp_pay_to_supplier 9336 9336 0 0.00 2 993 23 0 0
sp_payment_common 20545 20545 0 0.00 0 1151 6 0 0
sp_qd_handle_on_cancel_clo 2689 2689 0 0.00 0 1596 29 0 0
sp_qd_handle_on_invoice_upd_sts 12501 12501 0 0.00 0 2401 64 0 0
sp_qd_handle_on_reserve_upd_sts 15627 15627 0 0.00 0 1971 10 0 0
sp_reserve_write_off 15627 15627 0 0.00 2 1981 33 0 0
sp_supplier_invoice 8557 8557 0 0.00 3 5573 316 0 0
sp_supplier_order 8645 8645 0 0.00 3 3128 182 0 0
srv_aggregate_perf_data 272 272 0 0.00 79 6587 1376 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 735 297 0 0
srv_find_qd_qs_mism 702604 702604 0 0.00 0 1646 1 0 0
srv_make_invnt_saldo 1104 1104 0 0.00 0 4721 1503 0 0
srv_make_money_saldo 2624 2624 0 0.00 0 198 12 0 0
srv_recalc_idx_stat 2 2 0 0.00 480 14332 7406 0 0
v_add_invoice_to_stock 14766 14766 0 0.00 0 593 2 0 0
v_all_customers 51620 51620 0 0.00 0 108 0 0 0
v_all_suppliers 42472 42472 0 0.00 0 92 0 0 0
v_all_wares 67210 67210 0 0.00 0 64 0 0 0
v_cancel_adding_invoice 1350 1350 0 0.00 0 88 2 0 0
v_cancel_client_order 5378 5378 0 0.00 0 531 1 0 0
v_cancel_customer_prepayment 1968 1968 0 0.00 0 337 2 0 0
v_cancel_customer_reserve 2020 2020 0 0.00 0 60 1 0 0
v_cancel_payment_to_supplier 1290 1290 0 0.00 0 92 1 0 0
v_cancel_supplier_invoice 1302 1302 0 0.00 0 311 3 0 0
v_cancel_supplier_order 1360 1360 0 0.00 0 132 2 0 0
v_cancel_write_off 2978 2978 0 0.00 0 372 2 0 0
v_max_id_clo_ord 8645 8645 0 0.00 0 286 1 0 0
v_max_id_clo_res 1580 1580 0 0.00 0 675 3 0 0
v_max_id_ord_sup 8557 8557 0 0.00 0 1063 1 0 0
v_max_non_paid_invoice 5302 5302 0 0.00 0 434 1 0 0
v_max_non_paid_realizn 10744 10744 0 0.00 0 154 1 0 0
v_min_id_clo_ord 8645 8645 0 0.00 0 533 2 0 0
v_min_id_clo_res 1580 1580 0 0.00 0 1025 35 0 0
v_min_id_ord_sup 8557 8557 0 0.00 0 1293 3 0 0
v_min_non_paid_invoice 9336 9336 0 0.00 0 196 1 0 0
v_min_non_paid_realizn 11209 11209 0 0.00 0 557 2 0 0
v_our_firm 16520 16520 0 0.00 0 50 1 0 0
v_reserve_write_off 31254 31254 0 0.00 0 1027 1 0 0
x_lock_depdocs_on_canc_invoice 10579 10579 0 0.00 0 1656 8 0 0
x_lock_depdocs_on_canc_sup_ord 680 680 0 0.00 0 138 7 0 0
x_make_qstorno_1000_1200 8645 8645 0 0.00 1 2898 134 0 0
x_make_qstorno_1200_2000 8557 8557 0 0.00 1 5518 278 0 0
x_make_qstorno_2100_3300 361288 361288 0 0.00 0 3469 20 0 0

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

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
07:00:44 4 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
07:01:45 214 2147483648 2499494080 2707574784 246144608 10.283 20 5 10 0 247478528 1015472 318448
07:02:46 216 2147483648 2490889456 2703671296 234669344 9.851 18 12 25 0 236448176 1223872 554960
07:03:46 282 2147483648 2529847616 2783260672 272119488 11.246 20 12 26 0 275222112 2610560 492064
07:04:47 206 2147483648 2530389008 2775068672 273398304 11.293 20 12 24 0 276731552 2828496 504752
07:05:47 330 2147483648 2511347216 2736263168 252072496 10.504 19 12 24 0 255987744 3425984 489264
07:06:48 303 2147483648 2534857696 2786787328 273791536 11.307 20 7 14 0 285529904 11506640 231728
07:07:48 165 2147483648 2520989168 2761478144 264285904 10.958 20 12 23 0 266302080 1576608 439568
07:08:49 283 2147483648 2531285808 2774720512 271854528 11.236 20 14 27 0 275917088 3487888 574672
07:09:50 251 2147483648 2518308224 2752262144 255378832 10.628 19 14 28 1 261349008 5386048 584128
07:10:50 261 2147483648 2537202384 2779734016 273142336 11.283 20 15 29 0 281046608 7237616 666656
07:11:51 150 2147483648 2533186816 2782347264 271675920 11.230 20 12 24 0 277964992 5702768 586304
07:12:51 439 2147483648 2537183904 2777587712 271928112 11.239 20 11 22 0 281809552 9391264 490176
07:13:52 182 2147483648 2534034592 2785906688 271525552 11.224 20 8 16 0 279871760 7934352 411856
07:14:53 239 2147483648 2530503056 2772180992 270724656 11.195 20 11 21 0 276615024 5452576 437792
07:15:53 286 2147483648 2540982256 2796085248 274953440 11.350 20 10 20 0 286958864 11566480 438944
07:16:54 186 2147483648 2533091024 2775838720 268139456 11.100 20 12 24 2 277366256 8659760 567040
07:17:54 263 2147483648 2534985744 2771836928 267127104 11.062 20 13 26 0 279245344 11503872 614368
07:18:54 735 2147483648 2544188112 2798727168 275678720 11.376 20 12 25 0 289062288 12832160 551408
07:19:55 349 2147483648 2547149184 2793549824 274196720 11.322 20 14 28 0 293611568 18712992 701856
07:20:56 224 2147483648 2544133360 2787590144 275744128 11.379 20 11 22 0 288342512 12088000 510384
07:21:57 392 2147483648 2538412736 2785902592 272394288 11.256 20 10 20 0 284129712 11244928 490496
07:22:58 265 2147483648 2532462624 2767118336 264367872 10.961 20 11 22 0 277189248 11966720 854656
07:23:59 239 2147483648 2537754640 2781675520 273071456 11.281 20 11 21 0 283029104 9355872 601776
07:25:00 317 2147483648 2535381424 2776375296 269745184 11.159 20 11 22 0 278835360 8443856 646320
07:26:00 266 2147483648 2548272064 2791391232 271866192 11.237 20 12 23 0 292453632 19912912 674528
07:27:01 393 2147483648 2554174416 2791268352 273107168 11.282 20 15 31 0 297759584 23685840 966576
07:28:02 180 2147483648 2548168400 2800902144 277944992 11.459 20 10 20 0 292037776 13575184 517600
07:29:02 204 2147483648 2537718528 2789097472 269943168 11.166 20 10 19 0 281783824 11371680 468976
07:30:03 270 2147483648 2504106432 2728067072 240793200 10.082 20 12 24 0 249393968 8112448 488320
07:31:03 203 2147483648 2533315648 2776080384 274266032 11.325 20 5 10 0 277907232 3363712 277488
07:32:03 432 2147483648 2547897056 2798411776 275321968 11.363 20 14 28 0 292319584 16447504 550112
07:33:05 336 2147483648 2520832640 2764550144 262305424 10.884 20 4 7 0 265630656 3215648 109584
07:34:06 258 2147483648 2524645136 2759581696 266036272 11.022 20 6 12 0 268972608 2628944 307392
07:35:06 375 2147483648 2548900496 2806235136 269077120 11.134 20 9 18 0 289775776 20283376 415280
07:36:07 332 2147483648 2540165168 2795003904 271721776 11.231 20 9 18 0 282658368 10615360 321232
07:37:08 373 2147483648 2534699792 2781933568 268869696 11.127 20 9 18 0 278578048 9384016 324336
07:38:08 384 2147483648 2536965440 2783576064 271108544 11.209 20 5 10 0 281086688 9773648 204496
07:39:09 343 2147483648 2533066432 2775339008 264565104 10.968 20 11 22 0 275245168 10267120 412944
07:40:10 374 2147483648 2528344976 2764271616 261676048 10.861 20 11 22 0 272715200 10580064 459088
07:41:11 296 2147483648 2523331344 2766049280 268038768 11.096 20 12 22 3 270279296 1717552 522976
07:42:11 417 2147483648 2537416800 2784649216 266265120 11.031 20 13 26 1 281320992 14511216 544656
07:43:12 373 2147483648 2546116416 2791657472 269667840 11.156 20 7 14 0 289081920 19082928 331152
07:44:13 367 2147483648 2536583200 2783047680 269000288 11.131 20 5 10 0 283304144 13984512 319344
07:45:14 235 2147483648 2547630320 2788831232 270047872 11.170 20 10 20 0 289983424 19407776 527776
07:46:15 288 2147483648 2535677552 2770087936 261357600 10.849 20 8 16 0 279333200 17590096 385504
07:47:15 229 2147483648 2543268656 2784759808 267376272 11.072 20 7 14 0 287041616 19368944 296400
07:48:16 316 2147483648 2533455200 2784010240 269940624 11.166 20 13 27 1 275073296 4617968 514704
07:49:16 253 2147483648 2540189360 2788016128 266175872 11.027 20 9 18 0 282643440 16122400 345168
07:50:17 421 2147483648 2546224096 2789089280 268883936 11.127 20 10 20 0 288676288 19352048 440304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 02-11-2026 07:51:13 to 02-11-2026 07:51:14.

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          227243
MON$OLDEST_ACTIVE               227927
MON$OLDEST_SNAPSHOT             227927
MON$NEXT_TRANSACTION            227927
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-02 04:00:11.2130 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                        {CFE3AB22-8F34-48B5-97E8-591A15806A44}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             597
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1950 Firebird 5.0 60495c3
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1950 Firebird 5.0 60495c3"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1950 Firebird 5.0 60495c3/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1950 Firebird 5.0 60495c3/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    Mon Nov  2 07:50:42 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:9: 
:10: 
:11: test-0    Mon Nov  2 07:50:42 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:13: 
:14: 
:15: test-0    Mon Nov  2 07:50:42 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:17: 
--- end of diff output ---

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

02.11.26 07:51:14. 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-02 07:51:15 No severe PSQL-related problems occured
02.11.26 07:51:15. End of report.