Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 05.11.2026 13: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 5d
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 2245908 kB
MemAvailable 7465032 kB
Buffers 89616 kB
Cached 5215548 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-05 13:50:46
DTS_END                         2026-11-05 13:50:46.4100
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/40664
TRN_ID                          207923
ATT_ID                          442
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: 13200.52 1003 660026
customer order: creation 616.42 45 30821
customer order: refuse 50.36 49 2518
order to supplier: creation 155.88 198 7794
order to supplier: removal 11.48 8140 574
invoice (draft): creation 155.30 344 7765
invoice (draft): removal 111.04 129 5552
invoice accept: apply 131.52 1383 6576
invoice accept: cancel 90.36 191 4518
customer reserve: creation 6302.88 24 315144
customer reserve: removal 4652.22 14 232611
realization accept: apply 285.78 32 14289
realization accept: cancel 158.56 17 7928
payment from customer: creation 204.66 30 10233
payment from customer: removal 19.24 19 962
payment to supplier: creation 167.52 24 8376
payment to supplier: removal 12.10 16 605
service: total inventory turnovers 19.78 1744 989
service: total monetary turnovers 50.80 13 2540
service: aggregate perf. data 4.58 1421 229
service: refresh index statistics 0.04 6231 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7913
TEST_TIME 2 8990
TEST_TIME 3 9895
TEST_TIME 4 10402
TEST_TIME 5 10502
TEST_TIME 6 10822
TEST_TIME 7 11219
TEST_TIME 8 11532
TEST_TIME 9 11766
TEST_TIME 10 11856
TEST_TIME 11 12031
TEST_TIME 12 12233
TEST_TIME 13 12179
TEST_TIME 14 12349
TEST_TIME 15 12389
TEST_TIME 16 12341
TEST_TIME 17 12494
TEST_TIME 18 12477
TEST_TIME 19 12556
TEST_TIME 20 12515
TEST_TIME 21 12600
TEST_TIME 22 12488
TEST_TIME 23 12638
TEST_TIME 24 12669
TEST_TIME 25 12672
TEST_TIME 26 12733
TEST_TIME 27 12644
TEST_TIME 28 12734
TEST_TIME 29 12740
TEST_TIME 30 12732
TEST_TIME 31 12792
TEST_TIME 32 12851
TEST_TIME 33 12892
TEST_TIME 34 12856
TEST_TIME 35 12858
TEST_TIME 36 12853
TEST_TIME 37 12999
TEST_TIME 38 12991
TEST_TIME 39 13030
TEST_TIME 40 13120
TEST_TIME 41 13105
TEST_TIME 42 13091
TEST_TIME 43 13124
TEST_TIME 44 13156
TEST_TIME 45 13166
TEST_TIME 46 13225
TEST_TIME 47 13250
TEST_TIME 48 13268
TEST_TIME 49 13270
TEST_TIME 50 13201

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 05-11-2026 13:51:07 to 05-11-2026 13:51:09.

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 972870 972870 0 0.00 0 3205 2 0 0
doc_list_biud 972870 972870 0 0.00 0 2511 5 0 0
sp_add_invoice_to_stock 6576 6576 0 0.00 4 13892 1384 0 0
sp_cancel_adding_invoice 4518 4518 0 0.00 3 5484 191 0 0
sp_cancel_client_order 2518 2518 0 0.00 2 2520 50 0 0
sp_cancel_customer_reserve 232611 232611 0 0.00 1 1892 15 0 0
sp_cancel_pay_from_customer 962 962 0 0.00 1 920 20 0 0
sp_cancel_pay_to_supplier 605 605 0 0.00 1 618 17 0 0
sp_cancel_supplier_invoice 5552 5552 0 0.00 1 1723 129 0 0
sp_cancel_supplier_order 574 574 0 0.00 7 73734 8141 0 0
sp_cancel_write_off 7928 7928 0 0.00 1 881 17 0 0
sp_client_order 30821 30821 0 0.00 2 4527 45 0 0
sp_customer_reserve 315144 315144 0 0.00 0 5280 25 0 0
sp_fill_shopping_cart 46380 46380 0 0.00 0 2131 17 0 0
sp_fill_shopping_cart_clo_res 315144 315144 0 0.00 0 1963 2 0 0
sp_get_clo_for_invoice 6576 6576 0 0.00 0 1312 31 0 0
sp_kill_cost_storno 14013 14013 0 0.00 0 1931 8 0 0
sp_kill_qstorno_ret_qs2qd 479276 479276 0 0.00 0 1882 7 0 0
sp_kill_qty_storno 274566 274566 0 0.00 0 2511 17 0 0
sp_lock_selected_doc 29079 29079 0 0.00 0 740 1 0 0
sp_make_cost_storno 39474 39474 0 0.00 0 981 6 0 0
sp_multiply_rows_for_pdistr 39474 39474 0 0.00 0 872 9 0 0
sp_multiply_rows_for_qdistr 30821 30821 0 0.00 0 2535 17 0 0
sp_pay_from_customer 10233 10233 0 0.00 2 1655 31 0 0
sp_pay_to_supplier 8376 8376 0 0.00 1 755 25 0 0
sp_payment_common 18609 18609 0 0.00 0 857 6 0 0
sp_qd_handle_on_cancel_clo 2518 2518 0 0.00 0 2511 36 0 0
sp_qd_handle_on_invoice_upd_sts 11094 11094 0 0.00 0 2270 65 0 0
sp_qd_handle_on_reserve_upd_sts 14289 14289 0 0.00 0 1483 10 0 0
sp_reserve_write_off 14289 14289 0 0.00 2 1498 32 0 0
sp_supplier_invoice 7765 7765 0 0.00 5 6258 344 0 0
sp_supplier_order 7794 7794 0 0.00 3 3531 199 0 0
srv_aggregate_perf_data 229 229 0 0.00 67 8145 1421 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 694 313 0 0
srv_find_qd_qs_mism 613630 613630 0 0.00 0 3204 1 0 0
srv_make_invnt_saldo 989 989 0 0.00 2 4922 1744 0 0
srv_make_money_saldo 2540 2540 0 0.00 0 269 13 0 0
srv_recalc_idx_stat 2 2 0 0.00 277 12185 6231 0 0
v_add_invoice_to_stock 13152 13152 0 0.00 0 766 2 0 0
v_all_customers 46856 46856 0 0.00 0 68 0 0 0
v_all_suppliers 38302 38302 0 0.00 0 51 0 0 0
v_all_wares 61642 61642 0 0.00 0 51 0 0 0
v_cancel_adding_invoice 1158 1158 0 0.00 0 292 2 0 0
v_cancel_client_order 5036 5036 0 0.00 0 577 2 0 0
v_cancel_customer_prepayment 1924 1924 0 0.00 0 564 2 0 0
v_cancel_customer_reserve 1910 1910 0 0.00 0 891 3 0 0
v_cancel_payment_to_supplier 1210 1210 0 0.00 0 83 2 0 0
v_cancel_supplier_invoice 1098 1098 0 0.00 0 499 3 0 0
v_cancel_supplier_order 1148 1148 0 0.00 0 188 2 0 0
v_cancel_write_off 2944 2944 0 0.00 0 517 2 0 0
v_max_id_clo_ord 7794 7794 0 0.00 0 577 1 0 0
v_max_id_clo_res 1430 1430 0 0.00 0 403 2 0 0
v_max_id_ord_sup 7765 7765 0 0.00 0 1041 2 0 0
v_max_non_paid_invoice 4784 4784 0 0.00 0 31 1 0 0
v_max_non_paid_realizn 9882 9882 0 0.00 0 185 1 0 0
v_min_id_clo_ord 7794 7794 0 0.00 0 674 2 0 0
v_min_id_clo_res 1430 1430 0 0.00 0 894 5 0 0
v_min_id_ord_sup 7765 7765 0 0.00 0 1341 6 0 0
v_min_non_paid_invoice 8376 8376 0 0.00 0 694 2 0 0
v_min_non_paid_realizn 10233 10233 0 0.00 0 591 2 0 0
v_our_firm 15488 15488 0 0.00 0 40 1 0 0
v_reserve_write_off 28578 28578 0 0.00 0 795 1 0 0
x_lock_depdocs_on_canc_invoice 9521 9521 0 0.00 0 1775 8 0 0
x_lock_depdocs_on_canc_sup_ord 574 574 0 0.00 0 516 10 0 0
x_make_qstorno_1000_1200 7794 7794 0 0.00 1 3463 150 0 0
x_make_qstorno_1200_2000 7765 7765 0 0.00 1 6193 303 0 0
x_make_qstorno_2100_3300 315144 315144 0 0.00 0 5279 21 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2026 13:51:09 to 05-11-2026 13:51:13.

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
13:00:50 4 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
13:01:51 259 2147483648 2524716832 2805501952 270519856 11.187 20 12 25 1 271801584 757504 524224
13:02:52 496 2147483648 2527324688 2775216128 270586256 11.190 20 9 13 3 273560160 2689744 284160
13:03:53 176 2147483648 2533195376 2776387584 272901408 11.275 20 9 18 0 278311648 5019936 390304
13:04:54 204 2147483648 2518141600 2755383296 260776144 10.828 20 9 17 0 263797536 2719616 301776
13:05:54 477 2147483648 2528394208 2773606400 272025248 11.242 20 4 7 0 272458224 380064 52912
13:06:55 245 2147483648 2513286672 2739073024 250954896 10.463 20 11 21 0 255540320 4012256 573168
13:07:56 208 2147483648 2533609664 2782765056 273844752 11.309 20 8 15 0 279495216 5301776 348688
13:08:56 214 2147483648 2508350736 2735407104 249189024 10.397 19 8 16 0 255077296 5482816 405456
13:09:57 226 2147483648 2534444688 2779467776 272766288 11.270 20 15 30 0 279380224 5920736 693200
13:10:58 261 2147483648 2527709776 2763046912 265227072 10.992 20 13 26 0 272818928 7066832 525024
13:11:59 232 2147483648 2531946144 2772615168 269861024 11.163 20 17 34 0 276910368 6299088 750256
13:12:59 276 2147483648 2527865328 2772758528 268355392 11.108 20 8 16 0 274538144 5900240 282512
13:14:00 263 2147483648 2540007120 2775015424 270406688 11.183 20 11 22 0 284577120 13660144 510288
13:15:01 366 2147483648 2531466336 2771886080 267803952 11.087 20 9 18 0 275625664 7505856 315856
13:16:02 381 2147483648 2531219680 2770620416 268001472 11.095 20 11 23 0 274335552 5910752 423328
13:17:02 277 2147483648 2531953472 2759491584 257384080 10.702 20 7 14 0 276746608 18932016 430512
13:18:03 269 2147483648 2542341568 2791608320 275454048 11.368 20 12 24 0 286346304 10418864 473392
13:19:03 363 2147483648 2525810784 2764607488 263799440 10.940 20 8 16 0 268290752 4207120 284192
13:20:05 295 2147483648 2535327712 2780372992 274456272 11.332 20 6 12 0 280049360 5339696 253392
13:21:06 388 2147483648 2536692416 2789470208 276038032 11.389 20 13 26 0 281158080 4660560 459488
13:22:06 412 2147483648 2518508304 2745298944 257541792 10.708 20 10 21 0 262019856 3975440 502624
13:23:07 284 2147483648 2534472752 2788917248 275996736 11.388 20 6 12 0 280556736 4287552 272448
13:24:08 692 2147483648 2540997936 2790723584 273946544 11.313 20 6 12 0 285745376 11541920 256912
13:25:09 210 2147483648 2531495120 2771623936 267761152 11.086 20 11 22 0 274311280 6146448 403680
13:26:10 333 2147483648 2539368672 2784735232 274418544 11.330 20 8 16 0 283982272 9142992 420736
13:27:10 192 2147483648 2536326832 2777894912 272157152 11.247 20 12 22 1 279382896 6753200 472544
13:28:11 224 2147483648 2537784688 2770620416 264834752 10.978 20 11 22 0 281478016 16234928 408336
13:29:12 320 2147483648 2528353520 2764374016 268667184 11.119 20 11 22 0 271965408 2855088 443136
13:30:12 391 2147483648 2524951888 2748493824 251060656 10.467 20 8 16 0 266361600 14891216 409728
13:31:13 388 2147483648 2540440912 2782355456 276640496 11.411 20 9 18 0 283679504 6735488 303520
13:32:14 265 2147483648 2543917280 2796814336 274655424 11.339 20 10 19 1 288851104 13759136 436544
13:33:14 518 2147483648 2535602224 2773491712 264852800 10.979 20 13 26 0 279274480 13854576 567104
13:34:15 219 2147483648 2526447664 2774028288 268510064 11.113 20 12 24 1 270546912 1603856 432992
13:35:16 379 2147483648 2536637664 2777743360 264877792 10.980 20 9 18 0 282373760 17149216 346752
13:36:16 456 2147483648 2529739984 2776420352 266517280 11.040 20 12 25 1 271372784 4334288 521216
13:37:17 267 2147483648 2526824160 2761125888 255492448 10.632 19 9 16 2 270889648 15030560 366640
13:38:18 300 2147483648 2530084752 2779537408 268664720 11.119 20 9 18 0 277786608 8614960 506928
13:39:18 317 2147483648 2536091296 2780688384 268828752 11.125 20 10 20 0 280291472 11032592 430128
13:40:19 413 2147483648 2544885760 2784845824 263764816 10.938 20 14 28 0 288573024 24267968 540240
13:41:20 350 2147483648 2528296000 2772213760 265673344 11.009 20 10 20 0 272995968 6903248 419376
13:42:21 259 2147483648 2536398544 2783424512 268144928 11.100 20 11 20 1 279353744 10799776 409040
13:43:21 285 2147483648 2535157696 2802663424 270177984 11.175 20 7 14 0 281272448 10849040 245424
13:44:22 356 2147483648 2544250880 2787622912 266591168 11.043 20 8 16 0 288818608 21812816 414624
13:45:23 531 2147483648 2529953840 2778947584 268436336 11.111 20 15 28 1 273731504 4704080 591088
13:46:25 207 2147483648 2536522080 2767495168 262917664 10.907 20 11 22 0 280487856 17171584 398608
13:47:25 283 2147483648 2555842192 2803793920 270658688 11.192 20 12 24 0 298067968 26844336 564944
13:48:26 253 2147483648 2548227552 2798714880 271434224 11.221 20 12 24 0 295160096 23157024 568848
13:49:27 207 2147483648 2534086448 2772705280 263660160 10.935 20 12 25 1 277521968 13187856 673952
13:50:27 300 2147483648 2523741968 2762317824 262803120 10.903 20 6 12 0 268151552 5131248 217184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 05-11-2026 13:51:14 to 05-11-2026 13:51:28.

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 05-11-2026 13:51:28 to 05-11-2026 13:51:29.

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          207825
MON$OLDEST_ACTIVE               208099
MON$OLDEST_SNAPSHOT             208099
MON$NEXT_TRANSACTION            208099
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-05 10:00:11.5550 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                        {2F3E6685-4E4B-48A1-A75F-E38F3B722C36}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             565
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    Thu Nov  5 13:50:47 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'

05.11.26 13:51:29. 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-05 13:51:30 No severe PSQL-related problems occured
05.11.26 13:51:30. End of report.