Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 16.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 e92ae1229cb64d19992a66f8d80a9f04
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.117+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 2w 2d
Command: who -b
bootup_info system boot 2026-11-14 21:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 2480512 kB
MemAvailable 7453868 kB
Buffers 77724 kB
Cached 4980280 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-16 13:50:34
DTS_END                         2026-11-16 13:50:34.5240
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/57070
TRN_ID                          242834
ATT_ID                          497
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: 16162.96 884 808148
customer order: creation 720.78 36 36039
customer order: refuse 58.90 35 2945
order to supplier: creation 183.90 179 9195
order to supplier: removal 14.00 7491 700
invoice (draft): creation 184.64 313 9232
invoice (draft): removal 132.64 101 6632
invoice accept: apply 157.20 1228 7860
invoice accept: cancel 108.84 186 5442
customer reserve: creation 7783.92 21 389196
customer reserve: removal 5737.02 14 286851
realization accept: apply 331.82 28 16591
realization accept: cancel 193.00 16 9650
payment from customer: creation 233.80 27 11690
payment from customer: removal 22.40 14 1120
payment to supplier: creation 196.64 21 9832
payment to supplier: removal 13.88 18 694
service: total inventory turnovers 24.22 1360 1211
service: total monetary turnovers 59.38 14 2969
service: aggregate perf. data 5.92 1357 296
service: refresh index statistics 0.06 5228 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 16-11-2026 13:50:45 to 16-11-2026 13:50:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14245
TEST_TIME 2 14338
TEST_TIME 3 14364
TEST_TIME 4 14617
TEST_TIME 5 14634
TEST_TIME 6 14715
TEST_TIME 7 14865
TEST_TIME 8 14516
TEST_TIME 9 14585
TEST_TIME 10 14836
TEST_TIME 11 14941
TEST_TIME 12 14992
TEST_TIME 13 15094
TEST_TIME 14 15141
TEST_TIME 15 15181
TEST_TIME 16 15289
TEST_TIME 17 15411
TEST_TIME 18 15464
TEST_TIME 19 15475
TEST_TIME 20 15551
TEST_TIME 21 15563
TEST_TIME 22 15549
TEST_TIME 23 15547
TEST_TIME 24 15549
TEST_TIME 25 15648
TEST_TIME 26 15654
TEST_TIME 27 15604
TEST_TIME 28 15714
TEST_TIME 29 15732
TEST_TIME 30 15713
TEST_TIME 31 15689
TEST_TIME 32 15693
TEST_TIME 33 15704
TEST_TIME 34 15915
TEST_TIME 35 15903
TEST_TIME 36 15939
TEST_TIME 37 15878
TEST_TIME 38 16109
TEST_TIME 39 16067
TEST_TIME 40 16127
TEST_TIME 41 16109
TEST_TIME 42 16114
TEST_TIME 43 16199
TEST_TIME 44 16165
TEST_TIME 45 16208
TEST_TIME 46 16310
TEST_TIME 47 16313
TEST_TIME 48 16308
TEST_TIME 49 16305
TEST_TIME 50 16163

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 16-11-2026 13:50:47 to 16-11-2026 13:50:49.

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 1192805 1192805 0 0.00 0 1732 2 0 0
doc_list_biud 1192805 1192805 0 0.00 0 2914 5 0 0
sp_add_invoice_to_stock 7860 7860 0 0.00 3 14162 1229 0 0
sp_cancel_adding_invoice 5442 5442 0 0.00 2 4823 186 0 0
sp_cancel_client_order 2945 2945 0 0.00 1 1717 36 0 0
sp_cancel_customer_reserve 286851 286851 0 0.00 1 1941 14 0 0
sp_cancel_pay_from_customer 1120 1120 0 0.00 1 497 15 0 0
sp_cancel_pay_to_supplier 694 694 0 0.00 1 1037 18 0 0
sp_cancel_supplier_invoice 6632 6632 0 0.00 1 2925 102 0 0
sp_cancel_supplier_order 700 700 0 0.00 5 46783 7491 0 0
sp_cancel_write_off 9650 9650 0 0.00 1 673 17 0 0
sp_client_order 36039 36039 0 0.00 2 2046 37 0 0
sp_customer_reserve 389196 389196 0 0.00 0 2443 21 0 0
sp_fill_shopping_cart 54466 54466 0 0.00 0 2596 17 0 0
sp_fill_shopping_cart_clo_res 389196 389196 0 0.00 0 1410 2 0 0
sp_get_clo_for_invoice 7860 7860 0 0.00 0 1482 28 0 0
sp_kill_cost_storno 16906 16906 0 0.00 0 1123 8 0 0
sp_kill_qstorno_ret_qs2qd 590684 590684 0 0.00 0 2912 7 0 0
sp_kill_qty_storno 336671 336671 0 0.00 0 2913 16 0 0
sp_lock_selected_doc 34033 34033 0 0.00 0 837 1 0 0
sp_make_cost_storno 45973 45973 0 0.00 0 592 6 0 0
sp_multiply_rows_for_pdistr 45973 45973 0 0.00 0 889 8 0 0
sp_multiply_rows_for_qdistr 36039 36039 0 0.00 0 933 16 0 0
sp_pay_from_customer 11690 11690 0 0.00 2 864 28 0 0
sp_pay_to_supplier 9832 9832 0 0.00 2 761 22 0 0
sp_payment_common 21522 21522 0 0.00 0 722 5 0 0
sp_qd_handle_on_cancel_clo 2945 2945 0 0.00 0 1707 26 0 0
sp_qd_handle_on_invoice_upd_sts 13302 13302 0 0.00 0 2132 61 0 0
sp_qd_handle_on_reserve_upd_sts 16591 16591 0 0.00 0 1608 9 0 0
sp_reserve_write_off 16591 16591 0 0.00 2 1623 28 0 0
sp_supplier_invoice 9232 9232 0 0.00 3 5480 313 0 0
sp_supplier_order 9195 9195 0 0.00 4 2309 179 0 0
srv_aggregate_perf_data 296 296 0 0.00 42 7734 1357 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 596 282 0 0
srv_find_qd_qs_mism 753070 753070 0 0.00 0 1731 1 0 0
srv_make_invnt_saldo 1211 1211 0 0.00 2 4672 1361 0 0
srv_make_money_saldo 2969 2969 0 0.00 0 279 14 0 0
srv_recalc_idx_stat 3 3 0 0.00 289 15054 5229 0 0
v_add_invoice_to_stock 15720 15720 0 0.00 0 739 2 0 0
v_all_customers 54706 54706 0 0.00 0 63 0 0 0
v_all_suppliers 45168 45168 0 0.00 0 37 0 0 0
v_all_wares 72078 72078 0 0.00 0 95 0 0 0
v_cancel_adding_invoice 1396 1396 0 0.00 0 307 2 0 0
v_cancel_client_order 5890 5890 0 0.00 0 331 1 0 0
v_cancel_customer_prepayment 2240 2240 0 0.00 0 169 1 0 0
v_cancel_customer_reserve 2216 2216 0 0.00 0 143 2 0 0
v_cancel_payment_to_supplier 1388 1388 0 0.00 0 884 2 0 0
v_cancel_supplier_invoice 1254 1254 0 0.00 0 197 2 0 0
v_cancel_supplier_order 1400 1400 0 0.00 0 132 1 0 0
v_cancel_write_off 3380 3380 0 0.00 0 124 2 0 0
v_max_id_clo_ord 9195 9195 0 0.00 0 63 1 0 0
v_max_id_clo_res 1663 1663 0 0.00 0 48 1 0 0
v_max_id_ord_sup 9232 9232 0 0.00 0 886 2 0 0
v_max_non_paid_invoice 5675 5675 0 0.00 0 271 1 0 0
v_max_non_paid_realizn 11355 11355 0 0.00 0 78 1 0 0
v_min_id_clo_ord 9195 9195 0 0.00 0 425 2 0 0
v_min_id_clo_res 1663 1663 0 0.00 0 981 4 0 0
v_min_id_ord_sup 9232 9232 0 0.00 0 1054 4 0 0
v_min_non_paid_invoice 9832 9832 0 0.00 0 719 1 0 0
v_min_non_paid_realizn 11690 11690 0 0.00 0 290 2 0 0
v_our_firm 18042 18042 0 0.00 0 48 0 0 0
v_reserve_write_off 33182 33182 0 0.00 0 891 1 0 0
x_lock_depdocs_on_canc_invoice 11447 11447 0 0.00 0 1221 8 0 0
x_lock_depdocs_on_canc_sup_ord 700 700 0 0.00 0 949 38 0 0
x_make_qstorno_1000_1200 9195 9195 0 0.00 1 2259 130 0 0
x_make_qstorno_1200_2000 9232 9232 0 0.00 1 4965 273 0 0
x_make_qstorno_2100_3300 389196 389196 0 0.00 0 2442 18 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 16-11-2026 13:50:49 to 16-11-2026 13:50:52.

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:37 5 2147483648 2253215104 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
13:01:38 272 2147483648 2505790480 2717487104 252327616 10.514 20 9 16 2 253923824 1106864 489344
13:02:39 264 2147483648 2503944496 2708586496 246634336 10.301 20 9 17 0 250140256 3150080 355840
13:03:39 155 2147483648 2520724656 2757001216 264058896 10.949 20 7 14 0 266829488 2506288 264304
13:04:40 213 2147483648 2530726384 2779607040 273604896 11.300 20 13 27 0 277326480 3155648 565936
13:05:41 235 2147483648 2526005488 2762792960 268130496 11.099 20 14 28 0 271377504 2703120 543888
13:06:41 198 2147483648 2521192432 2757668864 264423008 10.963 20 15 30 0 268928112 3723072 782032
13:07:42 247 2147483648 2526973920 2772799488 271074096 11.208 20 8 16 0 272654256 1224960 355200
13:08:42 331 2147483648 2527443216 2768760832 267180640 11.064 20 7 15 0 271860112 4371552 307920
13:09:43 193 2147483648 2527188560 2768957440 269076144 11.134 20 12 25 0 272535680 2930112 529424
13:10:43 221 2147483648 2533005248 2775105536 267107968 11.062 20 14 28 0 277738032 10028240 601824
13:11:44 247 2147483648 2544495840 2786414592 272907984 11.275 20 15 30 0 285810032 12265936 636112
13:12:45 204 2147483648 2518448672 2754527232 260996416 10.836 20 14 27 0 263018368 1494496 527456
13:13:45 284 2147483648 2526394640 2755600384 262101504 10.877 20 13 25 0 271941552 9276704 563344
13:14:46 319 2147483648 2528315856 2771103744 268363584 11.108 20 11 22 2 273542448 4719584 459280
13:15:46 212 2147483648 2534982096 2783383552 273217600 11.286 20 7 14 1 278252672 4742640 292432
13:16:47 205 2147483648 2536096496 2777026560 268934576 11.129 20 17 32 1 278333504 8704352 694576
13:17:47 381 2147483648 2544649536 2796482560 271225232 11.213 20 10 18 1 289457104 17678448 553424
13:18:48 200 2147483648 2528169712 2766000128 266867152 11.053 20 10 20 0 273074848 5772048 435648
13:19:48 257 2147483648 2543346464 2785157120 272539808 11.261 20 15 30 1 288713680 15456560 717312
13:20:49 250 2147483648 2537830336 2786275328 274557856 11.335 20 14 30 0 282926400 7675968 692576
13:21:49 230 2147483648 2542039824 2779942912 265843312 11.015 20 11 22 0 285942816 19563664 535840
13:22:50 188 2147483648 2533525040 2777526272 270422096 11.184 20 16 32 1 277425040 6322496 680448
13:23:50 214 2147483648 2557356672 2804961280 273702288 11.304 20 10 20 0 296637472 22493168 442016
13:24:51 332 2147483648 2541700224 2778107904 270025776 11.169 20 13 28 1 285718864 15080000 613088
13:25:51 398 2147483648 2543914384 2791858176 275880192 11.384 20 12 24 0 287053888 10596256 577440
13:26:52 268 2147483648 2533809440 2776567808 270080736 11.171 20 15 29 0 277445248 6808880 555632
13:27:52 366 2147483648 2537795936 2769453056 263610656 10.933 20 13 26 0 282764512 18654448 499408
13:28:53 230 2147483648 2542586176 2783641600 270694800 11.194 20 13 26 0 285934816 14621520 618496
13:29:54 329 2147483648 2528807632 2771054592 269598336 11.153 20 10 18 1 274165504 4169568 397600
13:30:54 247 2147483648 2539607376 2784387072 275370816 11.365 20 11 21 0 283493616 7703344 419456
13:31:56 372 2147483648 2541029008 2778451968 272575184 11.263 20 13 26 0 283487936 10380416 532336
13:32:57 594 2147483648 2537394272 2783100928 265839616 11.015 20 7 14 0 281211760 15086768 285376
13:33:58 275 2147483648 2548934080 2790936576 272157584 11.247 20 9 18 0 293729312 21010112 561616
13:35:00 280 2147483648 2522776176 2757255168 259595168 10.784 20 13 25 0 265479552 5324816 559568
13:36:00 274 2147483648 2539709248 2778415104 265035408 10.985 20 16 31 2 283119360 17423168 660784
13:37:01 291 2147483648 2524253344 2757500928 262985952 10.910 20 7 14 0 268623552 5392224 245376
13:38:01 355 2147483648 2562736384 2816704512 272439808 11.258 20 16 29 2 306417552 33356640 621104
13:39:02 278 2147483648 2525736528 2767187968 256596080 10.673 19 8 16 0 268593520 11653536 343904
13:40:02 310 2147483648 2539169728 2781966336 265725712 11.011 20 10 21 0 281868512 15715200 427600
13:41:03 303 2147483648 2533277424 2774081536 264906688 10.981 20 8 16 0 276562064 11350000 305376
13:42:04 321 2147483648 2538004160 2781491200 266928736 11.055 20 13 25 0 281780816 14260320 591760
13:43:04 333 2147483648 2532275728 2768793600 264928592 10.981 20 14 24 2 277402928 11758592 715744
13:44:05 256 2147483648 2539189280 2787192832 269447664 11.148 20 13 26 0 282245184 12283088 514432
13:45:05 366 2147483648 2559610832 2806779904 269625312 11.154 20 11 20 0 302922896 32715520 582064
13:46:08 354 2147483648 2566512576 2805821440 264220592 10.955 20 14 28 0 309078864 44064464 793808
13:47:09 373 2147483648 2538131280 2783023104 268609472 11.117 20 12 24 0 280412496 11310448 492576
13:48:09 162 2147483648 2538052608 2777919488 263658880 10.935 20 11 22 0 280424144 16329728 435536
13:49:10 337 2147483648 2536697344 2771812352 257633088 10.711 20 12 24 0 273540640 15343824 563728
13:50:11 388 2147483648 2529015040 2772672512 268790224 11.124 20 18 37 1 273603136 4014272 798640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 16-11-2026 13:50:53 to 16-11-2026 13:51:03.

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 16-11-2026 13:51:03 to 16-11-2026 13:51:04.

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          242835
MON$OLDEST_ACTIVE               242978
MON$OLDEST_SNAPSHOT             242978
MON$NEXT_TRANSACTION            242978
MON$PAGE_BUFFERS                262144
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2026-11-16 10:00:08.9590 GMT
MON$PAGES                       193732
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                        {B8A42D17-1AC4-4D36-B650-CCD04809B60F}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             621
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1973 Firebird 5.0 3a24e7d
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1973 Firebird 5.0 3a24e7d"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1973 Firebird 5.0 3a24e7d/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1973 Firebird 5.0 3a24e7d/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 16 13:50:38 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'

16.11.26 13:51:04. 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-16 13:51:05 No severe PSQL-related problems occured
16.11.26 13:51:05. End of report.