Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 18.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 4d
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 2377296 kB
MemAvailable 7451400 kB
Buffers 80156 kB
Cached 5075008 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-18 13:50:34
DTS_END                         2026-11-18 13:50:34.9080
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/60276
TRN_ID                          229397
ATT_ID                          476
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: 15683.78 1023 784189
customer order: creation 676.24 41 33812
customer order: refuse 54.96 52 2748
order to supplier: creation 176.94 202 8847
order to supplier: removal 12.92 9038 646
invoice (draft): creation 173.78 360 8689
invoice (draft): removal 126.76 145 6338
invoice accept: apply 148.40 1383 7420
invoice accept: cancel 104.66 228 5233
customer reserve: creation 7555.18 23 377759
customer reserve: removal 5618.26 15 280913
realization accept: apply 319.20 31 15960
realization accept: cancel 188.92 17 9446
payment from customer: creation 223.58 30 11179
payment from customer: removal 21.38 18 1069
payment to supplier: creation 186.80 24 9340
payment to supplier: removal 14.18 16 709
service: total inventory turnovers 23.94 1364 1197
service: total monetary turnovers 52.46 15 2623
service: aggregate perf. data 5.18 1609 259
service: refresh index statistics 0.04 5844 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14297
TEST_TIME 2 14192
TEST_TIME 3 14600
TEST_TIME 4 14718
TEST_TIME 5 14543
TEST_TIME 6 14672
TEST_TIME 7 14858
TEST_TIME 8 14891
TEST_TIME 9 14781
TEST_TIME 10 14737
TEST_TIME 11 14871
TEST_TIME 12 14932
TEST_TIME 13 14859
TEST_TIME 14 15005
TEST_TIME 15 14965
TEST_TIME 16 14974
TEST_TIME 17 15039
TEST_TIME 18 15086
TEST_TIME 19 15127
TEST_TIME 20 15146
TEST_TIME 21 15098
TEST_TIME 22 15143
TEST_TIME 23 15141
TEST_TIME 24 15139
TEST_TIME 25 15134
TEST_TIME 26 15038
TEST_TIME 27 15147
TEST_TIME 28 15071
TEST_TIME 29 15050
TEST_TIME 30 15043
TEST_TIME 31 15055
TEST_TIME 32 15110
TEST_TIME 33 15298
TEST_TIME 34 15280
TEST_TIME 35 15379
TEST_TIME 36 15364
TEST_TIME 37 15348
TEST_TIME 38 15438
TEST_TIME 39 15442
TEST_TIME 40 15495
TEST_TIME 41 15517
TEST_TIME 42 15629
TEST_TIME 43 15667
TEST_TIME 44 15656
TEST_TIME 45 15645
TEST_TIME 46 15674
TEST_TIME 47 15755
TEST_TIME 48 15762
TEST_TIME 49 15771
TEST_TIME 50 15684

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 18-11-2026 13:50:46 to 18-11-2026 13:50:48.

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 1155625 1155625 0 0.00 0 3900 2 0 0
doc_list_biud 1155625 1155625 0 0.00 0 2232 5 0 0
sp_add_invoice_to_stock 7420 7420 0 0.00 5 11389 1383 0 0
sp_cancel_adding_invoice 5233 5233 0 0.00 3 6809 228 0 0
sp_cancel_client_order 2748 2748 0 0.00 2 1582 52 0 0
sp_cancel_customer_reserve 280913 280913 0 0.00 1 1536 16 0 0
sp_cancel_pay_from_customer 1069 1069 0 0.00 1 833 19 0 0
sp_cancel_pay_to_supplier 709 709 0 0.00 1 478 17 0 0
sp_cancel_supplier_invoice 6338 6338 0 0.00 2 3929 146 0 0
sp_cancel_supplier_order 646 646 0 0.00 3 72377 9038 0 0
sp_cancel_write_off 9446 9446 0 0.00 1 623 18 0 0
sp_client_order 33812 33812 0 0.00 3 3925 42 0 0
sp_customer_reserve 377759 377759 0 0.00 0 3934 23 0 0
sp_fill_shopping_cart 51348 51348 0 0.00 0 2051 19 0 0
sp_fill_shopping_cart_clo_res 377759 377759 0 0.00 0 1319 2 0 0
sp_get_clo_for_invoice 7420 7420 0 0.00 0 1700 36 0 0
sp_kill_cost_storno 16457 16457 0 0.00 0 808 9 0 0
sp_kill_qstorno_ret_qs2qd 578256 578256 0 0.00 0 2027 8 0 0
sp_kill_qty_storno 328704 328704 0 0.00 0 2232 18 0 0
sp_lock_selected_doc 32372 32372 0 0.00 0 711 1 0 0
sp_make_cost_storno 43899 43899 0 0.00 0 528 6 0 0
sp_multiply_rows_for_pdistr 43899 43899 0 0.00 0 523 8 0 0
sp_multiply_rows_for_qdistr 33812 33812 0 0.00 0 843 18 0 0
sp_pay_from_customer 11179 11179 0 0.00 2 1026 31 0 0
sp_pay_to_supplier 9340 9340 0 0.00 2 649 24 0 0
sp_payment_common 20519 20519 0 0.00 0 917 6 0 0
sp_qd_handle_on_cancel_clo 2748 2748 0 0.00 0 1563 38 0 0
sp_qd_handle_on_invoice_upd_sts 12653 12653 0 0.00 0 2232 75 0 0
sp_qd_handle_on_reserve_upd_sts 15960 15960 0 0.00 0 1969 10 0 0
sp_reserve_write_off 15960 15960 0 0.00 2 1988 31 0 0
sp_supplier_invoice 8689 8689 0 0.00 4 5625 361 0 0
sp_supplier_order 8847 8847 0 0.00 3 4862 202 0 0
srv_aggregate_perf_data 259 259 0 0.00 97 9054 1610 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 479 304 0 0
srv_find_qd_qs_mism 731016 731016 0 0.00 0 3900 1 0 0
srv_make_invnt_saldo 1197 1197 0 0.00 2 5728 1364 0 0
srv_make_money_saldo 2623 2623 0 0.00 0 467 16 0 0
srv_recalc_idx_stat 2 2 0 0.00 325 11364 5845 0 0
v_add_invoice_to_stock 14840 14840 0 0.00 0 562 2 0 0
v_all_customers 51190 51190 0 0.00 0 66 0 0 0
v_all_suppliers 43276 43276 0 0.00 0 43 0 0 0
v_all_wares 67624 67624 0 0.00 0 68 0 0 0
v_cancel_adding_invoice 1372 1372 0 0.00 0 21 2 0 0
v_cancel_client_order 5496 5496 0 0.00 0 570 1 0 0
v_cancel_customer_prepayment 2138 2138 0 0.00 0 455 2 0 0
v_cancel_customer_reserve 2092 2092 0 0.00 0 185 2 0 0
v_cancel_payment_to_supplier 1418 1418 0 0.00 0 136 1 0 0
v_cancel_supplier_invoice 1158 1158 0 0.00 0 565 3 0 0
v_cancel_supplier_order 1292 1292 0 0.00 0 27 1 0 0
v_cancel_write_off 3018 3018 0 0.00 0 98 2 0 0
v_max_id_clo_ord 8847 8847 0 0.00 0 319 1 0 0
v_max_id_clo_res 1555 1555 0 0.00 0 98 1 0 0
v_max_id_ord_sup 8689 8689 0 0.00 0 751 1 0 0
v_max_non_paid_invoice 5238 5238 0 0.00 0 66 1 0 0
v_max_non_paid_realizn 10901 10901 0 0.00 0 345 1 0 0
v_min_id_clo_ord 8847 8847 0 0.00 0 594 2 0 0
v_min_id_clo_res 1555 1555 0 0.00 0 902 3 0 0
v_min_id_ord_sup 8689 8689 0 0.00 0 897 3 0 0
v_min_non_paid_invoice 9340 9340 0 0.00 0 640 2 0 0
v_min_non_paid_realizn 11179 11179 0 0.00 0 291 2 0 0
v_our_firm 16990 16990 0 0.00 0 65 1 0 0
v_reserve_write_off 31920 31920 0 0.00 0 566 1 0 0
x_lock_depdocs_on_canc_invoice 10992 10992 0 0.00 0 964 11 0 0
x_lock_depdocs_on_canc_sup_ord 646 646 0 0.00 0 122 11 0 0
x_make_qstorno_1000_1200 8847 8847 0 0.00 1 4178 147 0 0
x_make_qstorno_1200_2000 8689 8689 0 0.00 1 4988 320 0 0
x_make_qstorno_2100_3300 377759 377759 0 0.00 0 3933 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-11-2026 13:50:48 to 18-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:38 3 2147483648 2253215104 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
13:01:39 206 2147483648 2511577840 2723004416 255392176 10.628 20 13 24 1 258485360 2577104 516080
13:02:40 298 2147483648 2499916992 2711072768 231318128 9.724 19 11 21 0 234140912 2476912 345872
13:03:40 290 2147483648 2529968336 2784989184 273159888 11.284 20 10 20 0 275857472 2223232 474352
13:04:41 287 2147483648 2538002896 2781679616 273382800 11.292 20 14 29 0 283298608 9276624 639184
13:05:41 238 2147483648 2522246800 2755325952 263291264 10.921 20 12 24 1 267333344 3580768 461312
13:06:42 282 2147483648 2521180032 2758266880 259901632 10.796 19 9 19 0 266435088 6124976 408480
13:07:42 295 2147483648 2528917760 2770677760 269745312 11.159 20 11 23 0 273365712 3070624 549776
13:08:43 315 2147483648 2539326992 2783596544 271600880 11.227 20 13 26 0 284289072 12177568 510624
13:09:44 229 2147483648 2523184224 2757468160 263978160 10.946 20 12 25 1 266820688 2335712 506816
13:10:44 226 2147483648 2532875328 2774949888 268909568 11.128 20 14 26 1 276957280 7549712 498000
13:11:46 304 2147483648 2552529920 2795749376 272775952 11.270 20 18 36 0 296942640 23421456 745232
13:12:46 295 2147483648 2543269152 2780925952 267219264 11.066 20 16 32 0 286504992 18482704 803024
13:13:47 377 2147483648 2540139056 2781163520 271258752 11.214 20 9 18 0 284680784 13019136 402896
13:14:47 279 2147483648 2528459648 2759487488 260270272 10.809 20 16 30 1 271777664 10922448 584944
13:15:48 267 2147483648 2529909184 2770276352 270398176 11.183 20 11 21 0 274417728 3604304 415248
13:16:48 203 2147483648 2536467792 2774536192 265947824 11.019 20 16 32 0 281284864 14658896 678144
13:17:49 262 2147483648 2527407056 2765672448 267829312 11.088 20 12 24 1 272698368 4261104 607952
13:18:49 346 2147483648 2549103200 2791124992 270970848 11.204 20 12 24 0 293961552 22364368 626336
13:19:50 360 2147483648 2531706144 2775515136 271375856 11.219 20 8 16 0 276344816 4648144 320816
13:20:51 279 2147483648 2552380080 2802614272 276044912 11.390 20 15 29 0 295319968 18635120 639936
13:21:51 413 2147483648 2554521888 2798010368 275375744 11.365 20 13 27 0 299285712 23197232 712736
13:22:52 381 2147483648 2534386288 2779840512 272644240 11.265 20 14 29 0 278547072 5376112 526720
13:23:53 242 2147483648 2524528848 2755203072 258793248 10.754 19 17 33 1 268652336 8935536 923552
13:24:53 211 2147483648 2523414544 2756935680 264742864 10.975 20 12 24 0 270050976 4775376 532736
13:25:54 302 2147483648 2541092096 2774585344 270275776 11.178 20 15 31 0 285531840 14412144 843920
13:26:54 340 2147483648 2563675904 2803286016 275248592 11.361 20 12 24 0 307566608 31745024 572992
13:27:55 329 2147483648 2526264208 2766127104 265741456 11.011 20 5 10 0 270301280 4290224 269600
13:28:57 390 2147483648 2528925760 2762817536 261789824 10.865 20 10 20 0 273181040 10896720 494496
13:29:58 479 2147483648 2538802448 2770575360 265892992 11.017 20 8 16 0 280848624 14607152 348480
13:30:59 393 2147483648 2561338016 2810187776 279301360 11.509 20 11 22 0 305648080 25816048 530672
13:31:59 303 2147483648 2526825520 2761216000 264862608 10.979 20 11 23 1 271328432 5860368 605456
13:33:00 310 2147483648 2546068096 2796277760 275434464 11.367 20 13 26 0 290034672 14022064 578144
13:34:01 344 2147483648 2533718176 2780917760 269401808 11.146 20 11 22 0 275753936 5935712 416416
13:35:01 361 2147483648 2532498976 2771972096 264700960 10.973 20 9 18 0 275458912 10363312 394640
13:36:02 258 2147483648 2524929072 2761695232 262602272 10.895 20 16 34 1 268588240 5262192 723776
13:37:02 340 2147483648 2524220544 2758881280 263134944 10.915 20 12 24 0 266189680 2607872 446864
13:38:03 328 2147483648 2535084128 2771062784 257831104 10.719 20 11 20 0 279196624 20843344 522176
13:39:04 278 2147483648 2526472608 2771578880 261637072 10.860 20 15 30 0 269768672 7500928 630672
13:40:04 248 2147483648 2526013376 2761895936 262900432 10.906 20 10 20 0 271075856 7747408 428016
13:41:05 378 2147483648 2532488160 2779451392 266990672 11.057 20 9 18 0 276279472 8912480 376320
13:42:05 294 2147483648 2551538896 2809147392 269472736 11.149 20 8 14 1 295764000 25960656 330608
13:43:06 323 2147483648 2548546528 2799800320 267862528 11.090 20 13 25 0 291188320 22708992 616800
13:44:06 248 2147483648 2533898304 2778116096 268694416 11.120 20 8 16 1 278033216 8968688 370112
13:45:07 356 2147483648 2534475088 2768252928 260513680 10.818 20 10 20 0 278544176 17625584 404912
13:46:07 359 2147483648 2551412992 2800308224 269597328 11.153 20 9 18 0 293761200 23647184 516688
13:47:08 258 2147483648 2530031824 2784837632 268470960 11.112 20 10 20 0 273667312 4724736 471616
13:48:08 276 2147483648 2547036160 2796584960 268876000 11.127 20 10 20 0 288531232 19178800 476432
13:49:09 348 2147483648 2537157920 2784387072 269371120 11.145 20 13 26 0 280045120 10053632 620368
13:50:10 287 2147483648 2532877792 2765598720 250510976 10.446 19 14 28 0 274399824 23177824 711024

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 18-11-2026 13:50:52 to 18-11-2026 13:51:02.

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:00, from 18-11-2026 13:51:03 to 18-11-2026 13:51:03.

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          229560
MON$OLDEST_ACTIVE               229561
MON$OLDEST_SNAPSHOT             229561
MON$NEXT_TRANSACTION            229561
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-18 10:00:08.7730 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                        {BF74E6E4-7DA8-40DD-882D-654FF8B40053}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             598
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1979 Firebird 5.0 43308b1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1979 Firebird 5.0 43308b1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1979 Firebird 5.0 43308b1/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1979 Firebird 5.0 43308b1/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    Wed Nov 18 13:50:35 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'

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