Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 12.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 cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+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 1w 5d
Command: who -b
bootup_info system boot 2026-11-09 10: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 8138016 kB
MemFree 2390416 kB
MemAvailable 7500472 kB
Buffers 80220 kB
Cached 5148652 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
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-12 07:50:34
DTS_END                         2026-11-12 07:50:34.3710
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/43620
TRN_ID                          235883
ATT_ID                          493
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: 15839.26 897 791963
customer order: creation 700.80 37 35040
customer order: refuse 55.92 48 2796
order to supplier: creation 175.24 183 8762
order to supplier: removal 13.20 8370 660
invoice (draft): creation 175.62 318 8781
invoice (draft): removal 127.08 133 6354
invoice accept: apply 150.24 1281 7512
invoice accept: cancel 105.26 198 5263
customer reserve: creation 7616.56 21 380828
customer reserve: removal 5656.10 14 282805
realization accept: apply 327.60 30 16380
realization accept: cancel 195.08 17 9754
payment from customer: creation 227.58 29 11379
payment from customer: removal 22.36 15 1118
payment to supplier: creation 192.72 23 9636
payment to supplier: removal 13.06 15 653
service: total inventory turnovers 23.66 1408 1183
service: total monetary turnovers 55.42 13 2771
service: aggregate perf. data 5.70 1438 285
service: refresh index statistics 0.06 4347 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 12-11-2026 07:50:47 to 12-11-2026 07:50:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14591
TEST_TIME 2 14247
TEST_TIME 3 14631
TEST_TIME 4 14696
TEST_TIME 5 14942
TEST_TIME 6 14948
TEST_TIME 7 14957
TEST_TIME 8 15099
TEST_TIME 9 15359
TEST_TIME 10 15318
TEST_TIME 11 15360
TEST_TIME 12 15344
TEST_TIME 13 15387
TEST_TIME 14 15337
TEST_TIME 15 15231
TEST_TIME 16 15249
TEST_TIME 17 15326
TEST_TIME 18 15326
TEST_TIME 19 15257
TEST_TIME 20 15220
TEST_TIME 21 15296
TEST_TIME 22 15291
TEST_TIME 23 15245
TEST_TIME 24 15219
TEST_TIME 25 15241
TEST_TIME 26 15186
TEST_TIME 27 15183
TEST_TIME 28 15183
TEST_TIME 29 15199
TEST_TIME 30 15152
TEST_TIME 31 15203
TEST_TIME 32 15161
TEST_TIME 33 15217
TEST_TIME 34 15223
TEST_TIME 35 15364
TEST_TIME 36 15391
TEST_TIME 37 15422
TEST_TIME 38 15507
TEST_TIME 39 15554
TEST_TIME 40 15565
TEST_TIME 41 15652
TEST_TIME 42 15697
TEST_TIME 43 15684
TEST_TIME 44 15777
TEST_TIME 45 15777
TEST_TIME 46 15795
TEST_TIME 47 15807
TEST_TIME 48 15895
TEST_TIME 49 15929
TEST_TIME 50 15839

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 12-11-2026 07:50:48 to 12-11-2026 07:50:50.

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 1166566 1166566 0 0.00 0 1266 2 0 0
doc_list_biud 1166566 1166566 0 0.00 0 3063 5 0 0
sp_add_invoice_to_stock 7512 7512 0 0.00 5 11100 1282 0 0
sp_cancel_adding_invoice 5263 5263 0 0.00 1 6397 199 0 0
sp_cancel_client_order 2796 2796 0 0.00 2 1674 48 0 0
sp_cancel_customer_reserve 282805 282805 0 0.00 1 2444 15 0 0
sp_cancel_pay_from_customer 1118 1118 0 0.00 1 464 16 0 0
sp_cancel_pay_to_supplier 653 653 0 0.00 1 671 16 0 0
sp_cancel_supplier_invoice 6354 6354 0 0.00 1 3068 134 0 0
sp_cancel_supplier_order 660 660 0 0.00 5 56056 8370 0 0
sp_cancel_write_off 9754 9754 0 0.00 1 1461 18 0 0
sp_client_order 35040 35040 0 0.00 2 1551 38 0 0
sp_customer_reserve 380828 380828 0 0.00 0 2043 21 0 0
sp_fill_shopping_cart 52583 52583 0 0.00 0 2794 16 0 0
sp_fill_shopping_cart_clo_res 380828 380828 0 0.00 0 1258 2 0 0
sp_get_clo_for_invoice 7512 7512 0 0.00 0 2163 31 0 0
sp_kill_cost_storno 16788 16788 0 0.00 0 1246 8 0 0
sp_kill_qstorno_ret_qs2qd 582378 582378 0 0.00 0 3062 7 0 0
sp_kill_qty_storno 331524 331524 0 0.00 0 3063 17 0 0
sp_lock_selected_doc 33042 33042 0 0.00 0 659 1 0 0
sp_make_cost_storno 44907 44907 0 0.00 0 844 6 0 0
sp_multiply_rows_for_pdistr 44907 44907 0 0.00 0 675 8 0 0
sp_multiply_rows_for_qdistr 35040 35040 0 0.00 0 1313 17 0 0
sp_pay_from_customer 11379 11379 0 0.00 1 1769 30 0 0
sp_pay_to_supplier 9636 9636 0 0.00 2 743 23 0 0
sp_payment_common 21015 21015 0 0.00 0 1254 6 0 0
sp_qd_handle_on_cancel_clo 2796 2796 0 0.00 0 1642 34 0 0
sp_qd_handle_on_invoice_upd_sts 12775 12775 0 0.00 0 1962 63 0 0
sp_qd_handle_on_reserve_upd_sts 16380 16380 0 0.00 0 1571 9 0 0
sp_reserve_write_off 16380 16380 0 0.00 2 1576 30 0 0
sp_supplier_invoice 8781 8781 0 0.00 4 5053 318 0 0
sp_supplier_order 8762 8762 0 0.00 3 2091 183 0 0
srv_aggregate_perf_data 285 285 0 0.00 98 6086 1439 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 521 294 0 0
srv_find_qd_qs_mism 737652 737652 0 0.00 0 929 1 0 0
srv_make_invnt_saldo 1183 1183 0 0.00 1 4540 1409 0 0
srv_make_money_saldo 2771 2771 0 0.00 0 226 13 0 0
srv_recalc_idx_stat 3 3 0 0.00 342 12300 4347 0 0
v_add_invoice_to_stock 15024 15024 0 0.00 0 907 2 0 0
v_all_customers 53552 53552 0 0.00 0 88 0 0 0
v_all_suppliers 43712 43712 0 0.00 0 73 0 0 0
v_all_wares 70080 70080 0 0.00 0 117 0 0 0
v_cancel_adding_invoice 1344 1344 0 0.00 0 498 2 0 0
v_cancel_client_order 5592 5592 0 0.00 0 559 2 0 0
v_cancel_customer_prepayment 2236 2236 0 0.00 0 365 1 0 0
v_cancel_customer_reserve 2084 2084 0 0.00 0 59 1 0 0
v_cancel_payment_to_supplier 1306 1306 0 0.00 0 131 1 0 0
v_cancel_supplier_invoice 1310 1310 0 0.00 0 174 2 0 0
v_cancel_supplier_order 1320 1320 0 0.00 0 186 1 0 0
v_cancel_write_off 3108 3108 0 0.00 0 388 2 0 0
v_max_id_clo_ord 8762 8762 0 0.00 0 664 1 0 0
v_max_id_clo_res 1616 1616 0 0.00 0 914 2 0 0
v_max_id_ord_sup 8781 8781 0 0.00 0 881 1 0 0
v_max_non_paid_invoice 5323 5323 0 0.00 0 89 1 0 0
v_max_non_paid_realizn 11005 11005 0 0.00 0 175 1 0 0
v_min_id_clo_ord 8762 8762 0 0.00 0 680 2 0 0
v_min_id_clo_res 1616 1616 0 0.00 0 715 4 0 0
v_min_id_ord_sup 8781 8781 0 0.00 0 1654 4 0 0
v_min_non_paid_invoice 9636 9636 0 0.00 0 720 2 0 0
v_min_non_paid_realizn 11379 11379 0 0.00 0 453 2 0 0
v_our_firm 17276 17276 0 0.00 0 31 0 0 0
v_reserve_write_off 32760 32760 0 0.00 0 536 1 0 0
x_lock_depdocs_on_canc_invoice 10962 10962 0 0.00 0 1141 9 0 0
x_lock_depdocs_on_canc_sup_ord 660 660 0 0.00 0 578 11 0 0
x_make_qstorno_1000_1200 8762 8762 0 0.00 1 2073 138 0 0
x_make_qstorno_1200_2000 8781 8781 0 0.00 1 4442 281 0 0
x_make_qstorno_2100_3300 380828 380828 0 0.00 0 2042 19 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2026 07:50:50 to 12-11-2026 07:50:54.

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:37 5 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
07:01:38 303 2147483648 2517655648 2739073024 257504464 10.707 20 13 27 0 263738096 5678320 555312
07:02:39 274 2147483648 2494531216 2702274560 238624448 10.000 19 14 28 0 240562000 1322416 615136
07:03:40 227 2147483648 2524026640 2769014784 266120208 11.025 20 15 28 1 269972288 3371664 480416
07:04:40 206 2147483648 2529579520 2775244800 270274000 11.178 20 8 16 0 275348304 4584832 489472
07:05:41 274 2147483648 2538575600 2783068160 273729712 11.305 20 12 24 0 283640656 9372384 538560
07:06:41 219 2147483648 2514118000 2742771712 252803904 10.532 19 13 26 0 257364320 3966224 594192
07:07:42 261 2147483648 2539253984 2789838848 273367520 11.292 20 14 29 0 282581168 8611680 601968
07:08:42 308 2147483648 2526038768 2763038720 263310480 10.922 20 15 30 0 271084672 7175104 599088
07:09:43 216 2147483648 2533443360 2785136640 273522304 11.297 20 9 18 0 279183952 5356848 304800
07:10:44 168 2147483648 2526356560 2757902336 258293456 10.736 20 12 24 0 267944688 9165280 485952
07:11:44 279 2147483648 2520781520 2752364544 256105824 10.655 19 11 23 0 264231376 7613216 512336
07:12:45 247 2147483648 2537767072 2782031872 270900096 11.201 20 18 36 0 281197056 9542128 754832
07:13:45 266 2147483648 2526270240 2769326080 255444256 10.630 19 14 28 1 265264240 9192032 627952
07:14:46 249 2147483648 2535226304 2776014848 271004016 11.205 20 10 20 1 281051328 9610368 436944
07:15:46 225 2147483648 2529690704 2773598208 271640736 11.228 20 9 18 0 274760640 2781872 338032
07:16:47 310 2147483648 2532522112 2775576576 269879808 11.164 20 9 18 0 277368784 7042672 446304
07:17:47 303 2147483648 2528105520 2768056320 267904528 11.091 20 12 24 0 272153840 3719904 529408
07:18:48 211 2147483648 2538987280 2771140608 264297792 10.958 20 11 22 0 283331824 18513008 521024
07:19:48 282 2147483648 2536276240 2781343744 274013824 11.315 20 10 18 1 280895040 6497184 384032
07:20:49 222 2147483648 2549680768 2800308224 274415968 11.330 20 12 25 0 294441216 19452688 572560
07:21:49 299 2147483648 2527766800 2761007104 258604592 10.747 20 14 28 0 268640816 9433616 602608
07:22:50 409 2147483648 2541795920 2795565056 275046096 11.353 20 15 30 0 284406400 8660640 699664
07:23:51 336 2147483648 2541569024 2777387008 263652224 10.934 20 16 32 0 285299440 20859472 787744
07:24:52 352 2147483648 2535715968 2782208000 272679360 11.266 20 12 24 1 278680800 5450256 551184
07:25:53 395 2147483648 2536148944 2781118464 270361664 11.181 20 10 20 0 276289680 5536800 391216
07:26:54 292 2147483648 2536151792 2777382912 271784688 11.234 20 13 26 0 279642000 7291584 565728
07:27:54 358 2147483648 2543011200 2789859328 276034624 11.389 20 10 20 0 287146624 10676896 435104
07:28:55 333 2147483648 2539158416 2781028352 272009984 11.242 20 8 16 0 283457536 11069824 377728
07:29:57 304 2147483648 2553044656 2806902784 277251312 11.434 20 15 30 0 296837280 18872352 713616
07:30:57 353 2147483648 2577681680 2834989056 287621072 11.811 20 16 32 0 320684720 32130352 933296
07:31:58 235 2147483648 2530091584 2764771328 265054880 10.986 20 13 24 1 274629008 9110208 463920
07:32:59 414 2147483648 2551638336 2804858880 272603104 11.264 20 11 22 0 301461968 28358528 500336
07:33:59 383 2147483648 2525356512 2767118336 262626192 10.896 20 10 19 0 270298320 7357136 314992
07:35:00 265 2147483648 2537114912 2771091456 264032048 10.948 20 11 22 0 280702256 16019040 651168
07:36:01 346 2147483648 2532098992 2777735168 268657328 11.119 20 11 22 0 276772864 7682800 432736
07:37:01 431 2147483648 2534019152 2790592512 267722704 11.084 20 11 22 0 285343072 16943856 676512
07:38:02 336 2147483648 2534942400 2773393408 265590576 11.006 20 13 26 0 278149376 12008400 550400
07:39:05 407 2147483648 2527622816 2763186176 263634848 10.934 20 11 22 0 270878816 6815136 428832
07:40:06 519 2147483648 2521967104 2756640768 263107616 10.914 20 10 20 0 267279632 3772976 399040
07:41:07 197 2147483648 2550186880 2796101632 270721824 11.195 20 12 23 0 294120416 22905216 493376
07:42:08 189 2147483648 2525508880 2764632064 262171344 10.880 20 9 16 1 276912720 14264288 477088
07:43:08 266 2147483648 2527835504 2769715200 266652128 11.045 20 9 18 0 270782160 3804448 325584
07:44:09 226 2147483648 2544415104 2796396544 266179504 11.028 20 12 24 0 287019344 20160032 679808
07:45:09 303 2147483648 2547013424 2788884480 268911104 11.128 20 13 26 0 289264784 19835504 518176
07:46:10 335 2147483648 2549218464 2796212224 271255824 11.214 20 14 28 0 292169024 20244080 669120
07:47:11 328 2147483648 2537909584 2781941760 266306448 11.032 20 11 22 0 281680128 14812112 561568
07:48:12 400 2147483648 2521423344 2759921664 260672768 10.824 20 10 20 0 265745824 4722912 350144
07:49:13 223 2147483648 2544178528 2790436864 270545168 11.188 20 11 22 0 286779632 15808528 425936
07:50:13 242 2147483648 2542828112 2804826112 273710592 11.304 20 10 18 2 287894336 13691264 492480

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 12-11-2026 07:51:05 to 12-11-2026 07:51:06.

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          235868
MON$OLDEST_ACTIVE               236019
MON$OLDEST_SNAPSHOT             236019
MON$NEXT_TRANSACTION            236019
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-12 04:00:10.1000 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                        {CF5853F5-D7D1-416F-B05A-6D0EC3896D6A}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             606
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1964 Firebird 5.0 5bb0d97
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1964 Firebird 5.0 5bb0d97"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1964 Firebird 5.0 5bb0d97/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1964 Firebird 5.0 5bb0d97/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    Thu Nov 12 07:50:35 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:9: 
:10: 
:11: test-0    Thu Nov 12 07:50:36 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:13: 
--- end of diff output ---

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

12.11.26 07:51:06. 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-12 07:51:07 No severe PSQL-related problems occured
12.11.26 07:51:07. End of report.