Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 17.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 3d
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 2495624 kB
MemAvailable 7472664 kB
Buffers 79564 kB
Cached 4984372 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-17 13:50:35
DTS_END                         2026-11-17 13:50:35.1040
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/50008
TRN_ID                          232656
ATT_ID                          490
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: 15810.36 1152 790518
customer order: creation 686.64 40 34332
customer order: refuse 55.44 53 2772
order to supplier: creation 175.46 201 8773
order to supplier: removal 13.46 8617 673
invoice (draft): creation 174.32 356 8716
invoice (draft): removal 126.10 149 6305
invoice accept: apply 151.44 1353 7572
invoice accept: cancel 105.62 204 5281
customer reserve: creation 7616.20 22 380810
customer reserve: removal 5677.86 15 283893
realization accept: apply 319.42 31 15971
realization accept: cancel 170.90 18 8545
payment from customer: creation 227.60 30 11380
payment from customer: removal 21.94 16 1097
payment to supplier: creation 191.82 24 9591
payment to supplier: removal 12.64 17 632
service: total inventory turnovers 24.70 1350 1235
service: total monetary turnovers 53.00 14 2650
service: aggregate perf. data 5.76 1477 288
service: refresh index statistics 0.04 9056 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 17-11-2026 13:50:48 to 17-11-2026 13:50:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 14031
TEST_TIME 2 13852
TEST_TIME 3 14062
TEST_TIME 4 14318
TEST_TIME 5 14366
TEST_TIME 6 14537
TEST_TIME 7 14760
TEST_TIME 8 14897
TEST_TIME 9 14889
TEST_TIME 10 15001
TEST_TIME 11 14966
TEST_TIME 12 14893
TEST_TIME 13 14858
TEST_TIME 14 14877
TEST_TIME 15 14898
TEST_TIME 16 14911
TEST_TIME 17 14857
TEST_TIME 18 14893
TEST_TIME 19 15043
TEST_TIME 20 15000
TEST_TIME 21 15088
TEST_TIME 22 15020
TEST_TIME 23 14967
TEST_TIME 24 14960
TEST_TIME 25 14997
TEST_TIME 26 15010
TEST_TIME 27 14957
TEST_TIME 28 14954
TEST_TIME 29 14987
TEST_TIME 30 14945
TEST_TIME 31 14979
TEST_TIME 32 15080
TEST_TIME 33 15109
TEST_TIME 34 15204
TEST_TIME 35 15263
TEST_TIME 36 15298
TEST_TIME 37 15330
TEST_TIME 38 15459
TEST_TIME 39 15406
TEST_TIME 40 15525
TEST_TIME 41 15570
TEST_TIME 42 15630
TEST_TIME 43 15660
TEST_TIME 44 15662
TEST_TIME 45 15724
TEST_TIME 46 15758
TEST_TIME 47 15807
TEST_TIME 48 15899
TEST_TIME 49 15899
TEST_TIME 50 15810

Performance per minute, chart


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

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 1163490 1163490 0 0.00 0 1326 2 0 0
doc_list_biud 1163490 1163490 0 0.00 0 2504 5 0 0
sp_add_invoice_to_stock 7572 7572 0 0.00 5 12986 1353 0 0
sp_cancel_adding_invoice 5281 5281 0 0.00 3 5060 204 0 0
sp_cancel_client_order 2772 2772 0 0.00 2 1085 53 0 0
sp_cancel_customer_reserve 283893 283893 0 0.00 1 2216 15 0 0
sp_cancel_pay_from_customer 1097 1097 0 0.00 1 290 17 0 0
sp_cancel_pay_to_supplier 632 632 0 0.00 2 669 18 0 0
sp_cancel_supplier_invoice 6305 6305 0 0.00 1 2112 149 0 0
sp_cancel_supplier_order 673 673 0 0.00 4 57009 8617 0 0
sp_cancel_write_off 8545 8545 0 0.00 1 814 18 0 0
sp_client_order 34332 34332 0 0.00 3 1567 41 0 0
sp_customer_reserve 380810 380810 0 0.00 0 2886 23 0 0
sp_fill_shopping_cart 51821 51821 0 0.00 0 1588 18 0 0
sp_fill_shopping_cart_clo_res 380810 380810 0 0.00 0 1334 2 0 0
sp_get_clo_for_invoice 7572 7572 0 0.00 0 2323 35 0 0
sp_kill_cost_storno 15555 15555 0 0.00 0 771 8 0 0
sp_kill_qstorno_ret_qs2qd 583309 583309 0 0.00 0 2211 8 0 0
sp_kill_qty_storno 331012 331012 0 0.00 0 2504 18 0 0
sp_lock_selected_doc 32534 32534 0 0.00 0 557 1 0 0
sp_make_cost_storno 44514 44514 0 0.00 0 668 7 0 0
sp_multiply_rows_for_pdistr 44514 44514 0 0.00 0 567 9 0 0
sp_multiply_rows_for_qdistr 34332 34332 0 0.00 0 978 18 0 0
sp_pay_from_customer 11380 11380 0 0.00 2 1352 31 0 0
sp_pay_to_supplier 9591 9591 0 0.00 2 814 24 0 0
sp_payment_common 20971 20971 0 0.00 0 597 6 0 0
sp_qd_handle_on_cancel_clo 2772 2772 0 0.00 0 1079 40 0 0
sp_qd_handle_on_invoice_upd_sts 12853 12853 0 0.00 0 2504 73 0 0
sp_qd_handle_on_reserve_upd_sts 15971 15971 0 0.00 0 1148 10 0 0
sp_reserve_write_off 15971 15971 0 0.00 2 1153 31 0 0
sp_supplier_invoice 8716 8716 0 0.00 5 5680 357 0 0
sp_supplier_order 8773 8773 0 0.00 4 4445 202 0 0
srv_aggregate_perf_data 288 288 0 0.00 17 8062 1478 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 560 312 0 0
srv_find_qd_qs_mism 735901 735901 0 0.00 0 1316 1 0 0
srv_make_invnt_saldo 1235 1235 0 0.00 1 4818 1351 0 0
srv_make_money_saldo 2650 2650 0 0.00 0 261 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 136 17976 9056 0 0
v_add_invoice_to_stock 15144 15144 0 0.00 0 524 2 0 0
v_all_customers 52116 52116 0 0.00 0 36 0 0 0
v_all_suppliers 43336 43336 0 0.00 0 65 0 0 0
v_all_wares 68664 68664 0 0.00 0 105 0 0 0
v_cancel_adding_invoice 1284 1284 0 0.00 0 45 2 0 0
v_cancel_client_order 5544 5544 0 0.00 0 510 1 0 0
v_cancel_customer_prepayment 2194 2194 0 0.00 0 239 1 0 0
v_cancel_customer_reserve 2010 2010 0 0.00 0 113 2 0 0
v_cancel_payment_to_supplier 1264 1264 0 0.00 0 265 2 0 0
v_cancel_supplier_invoice 1204 1204 0 0.00 0 133 2 0 0
v_cancel_supplier_order 1346 1346 0 0.00 0 63 1 0 0
v_cancel_write_off 3136 3136 0 0.00 0 351 2 0 0
v_max_id_clo_ord 8773 8773 0 0.00 0 279 1 0 0
v_max_id_clo_res 1602 1602 0 0.00 0 258 1 0 0
v_max_id_ord_sup 8716 8716 0 0.00 0 953 2 0 0
v_max_non_paid_invoice 5412 5412 0 0.00 0 100 1 0 0
v_max_non_paid_realizn 11065 11065 0 0.00 0 267 1 0 0
v_min_id_clo_ord 8773 8773 0 0.00 0 599 2 0 0
v_min_id_clo_res 1602 1602 0 0.00 0 693 4 0 0
v_min_id_ord_sup 8716 8716 0 0.00 0 1076 4 0 0
v_min_non_paid_invoice 9591 9591 0 0.00 0 273 2 0 0
v_min_non_paid_realizn 11380 11380 0 0.00 0 521 2 0 0
v_our_firm 17178 17178 0 0.00 0 40 1 0 0
v_reserve_write_off 31942 31942 0 0.00 0 457 1 0 0
x_lock_depdocs_on_canc_invoice 10984 10984 0 0.00 0 1210 10 0 0
x_lock_depdocs_on_canc_sup_ord 673 673 0 0.00 0 107 12 0 0
x_make_qstorno_1000_1200 8773 8773 0 0.00 1 4277 150 0 0
x_make_qstorno_1200_2000 8716 8716 0 0.00 1 5656 316 0 0
x_make_qstorno_2100_3300 380810 380810 0 0.00 0 2879 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2026 13:50:51 to 17-11-2026 13:50:55.

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 303 2147483648 2491924368 2684276736 235558640 9.884 20 14 29 1 237253520 1165680 529200
13:02:40 300 2147483648 2513348864 2734661632 258429120 10.741 20 8 17 0 259997168 1114480 453568
13:03:41 200 2147483648 2524129008 2767495168 267635984 11.081 20 10 21 0 270738832 2615472 487376
13:04:41 282 2147483648 2526607712 2775220224 271927008 11.239 20 11 19 1 273725600 1446464 352128
13:05:42 290 2147483648 2521977216 2748841984 263139024 10.915 20 14 27 0 266497600 2853760 504816
13:06:42 350 2147483648 2525983136 2762747904 266200144 11.028 20 10 20 2 270004512 3378272 426096
13:07:43 280 2147483648 2537376176 2779103232 274782448 11.344 20 11 21 0 282497792 7146000 569344
13:08:43 234 2147483648 2539672416 2788081664 275059920 11.354 20 15 29 1 284126528 8248576 818032
13:09:44 261 2147483648 2536116272 2785738752 275248800 11.361 20 8 16 0 280965568 5429584 287184
13:10:44 191 2147483648 2540467536 2791243776 273753872 11.306 20 10 19 0 285648448 11342240 552336
13:11:45 253 2147483648 2524990944 2765299712 268068640 11.097 20 12 25 0 270518144 2050000 399504
13:12:45 302 2147483648 2528664096 2767470592 268947120 11.129 20 12 24 0 273493408 4118240 428048
13:13:46 246 2147483648 2530992400 2774335488 270101744 11.172 20 12 25 0 277781456 7160784 518928
13:14:46 301 2147483648 2551035984 2792595456 274328064 11.327 20 14 28 0 293350160 18401968 620128
13:15:47 295 2147483648 2531934560 2767577088 269009056 11.132 20 15 29 1 275732640 6103216 620368
13:16:47 352 2147483648 2540719952 2778013696 270761312 11.196 20 12 22 0 283456064 12261888 432864
13:17:48 184 2147483648 2549960672 2792022016 269674304 11.156 20 13 26 1 293653744 23271088 708352
13:18:48 335 2147483648 2536072016 2780540928 273096608 11.282 20 9 18 0 281550624 8106304 347712
13:19:49 251 2147483648 2534806208 2782064640 273494768 11.296 20 12 24 0 280089696 6009632 585296
13:20:49 173 2147483648 2533825024 2780045312 271008672 11.205 20 12 24 0 278883248 7354000 520576
13:21:49 301 2147483648 2539328640 2792439808 269160928 11.137 20 11 21 0 283680736 13887088 632720
13:22:50 198 2147483648 2529914160 2771263488 269533840 11.151 20 14 29 0 274756880 4662096 560944
13:23:51 258 2147483648 2533282976 2782523392 275584464 11.373 20 12 24 1 278367248 2201056 581728
13:24:51 299 2147483648 2542176928 2788110336 272426896 11.257 20 12 24 0 286618368 13646320 545152
13:25:52 370 2147483648 2539264784 2789261312 276906000 11.421 20 10 20 0 284716608 7413744 396864
13:26:52 361 2147483648 2542658688 2781310976 270220400 11.176 20 12 24 0 286105680 15416304 468976
13:27:53 292 2147483648 2555969904 2801750016 279120096 11.502 20 14 27 0 298012736 18316864 575776
13:28:54 316 2147483648 2560625872 2804781056 276860384 11.420 20 13 26 0 303307824 25788816 658624
13:29:55 330 2147483648 2541708288 2788392960 275619584 11.374 20 13 26 1 285385392 9183808 582000
13:30:55 279 2147483648 2555868288 2797957120 278209232 11.469 20 13 25 0 297770656 19042032 519392
13:31:56 356 2147483648 2555331408 2805297152 277207216 11.432 20 13 27 0 297624720 19824128 593376
13:32:57 429 2147483648 2540768288 2791813120 271950528 11.240 20 10 20 0 284710928 12202976 557424
13:33:58 342 2147483648 2538308816 2788016128 270833040 11.199 20 8 16 0 282345680 11158224 354416
13:34:58 380 2147483648 2536963760 2785132544 267947264 11.093 20 5 10 0 281958304 13825328 185712
13:35:59 318 2147483648 2532980336 2780418048 269639248 11.155 20 14 27 0 276139856 5977568 523040
13:36:59 307 2147483648 2513378416 2744987648 249731568 10.417 19 10 20 0 257454992 7191024 532400
13:38:01 242 2147483648 2559589696 2804502528 266530896 11.040 20 8 16 0 305992368 39013744 447728
13:39:01 431 2147483648 2510612864 2735861760 250523360 10.447 20 7 14 0 252719264 1966864 229040
13:40:02 257 2147483648 2545470704 2783539200 264673392 10.972 20 12 25 0 287818496 22556384 588720
13:41:03 364 2147483648 2540156944 2780839936 264690864 10.973 20 8 17 0 283304576 18178256 435456
13:42:04 558 2147483648 2558157744 2809507840 269842608 11.162 20 12 25 0 298792032 28349616 599808
13:43:04 409 2147483648 2534684576 2777083904 267064960 11.060 20 11 22 0 279318896 11613296 640640
13:44:06 389 2147483648 2520585264 2757537792 254299168 10.587 19 15 30 0 263156224 8253968 603088
13:45:08 313 2147483648 2520775408 2755919872 259358592 10.775 20 8 16 0 264706064 4998544 348928
13:46:08 436 2147483648 2549607584 2789568512 267856160 11.089 20 9 18 0 297362816 28961248 545408
13:47:11 361 2147483648 2553343728 2800295936 268106592 11.099 20 10 21 0 297865168 29222496 536080
13:48:12 429 2147483648 2541006752 2784665600 266762944 11.049 20 12 23 0 284110368 16810432 536992
13:49:13 331 2147483648 2526005984 2767265792 261948400 10.871 20 6 12 0 268246240 6056016 241824
13:50:14 324 2147483648 2542602528 2788524032 269339936 11.144 20 13 25 0 285546832 15709600 497296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 17-11-2026 13:50:55 to 17-11-2026 13:51:06.

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 17-11-2026 13:51:06 to 17-11-2026 13: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          231873
MON$OLDEST_ACTIVE               232813
MON$OLDEST_SNAPSHOT             232813
MON$NEXT_TRANSACTION            232813
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-17 10:00:09.0800 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                        {319333DF-40B1-48FB-BAF2-0955001ECE88}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             603
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    Tue Nov 17 13:50:36 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3500
:9: 
:10: 
:11: test-0    Tue Nov 17 13: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'

17.11.26 13:51:07. 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-17 13:51:07 No severe PSQL-related problems occured
17.11.26 13:51:08. End of report.