Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 12:51
Common Performance Final Results
  1. Hardware and OS info
  2. Firebird configuration
  3. Test configuration
  4. Test Finish details
  5. Test workload details
  6. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 1w 3d
Command: who -b
bootup_info system boot 2026-11-09 10:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138016 kB
MemFree 1695324 kB
MemAvailable 7496160 kB
Buffers 80048 kB
Cached 5839208 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
GCPolicy combined combined
GuardianOption 1 1
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_fb60SS 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
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
OnDisconnectTriggerTimeout 180 180
OptimizeForFirstRows false false
OutputRedirectionFile /dev/null /dev/null
ParallelWorkers 1 1
ProcessPriorityLevel 0 0
Providers Remote, Engine14, Loopback Remote, Engine14, Loopback
ReadConsistency true true
RemoteAccess true true
RemoteAuxPort 0 0
RemoteBindAddress
RemoteFileOpenAbility false false
RemoteServiceName gds_db gds_db
RemoteServicePort 3600 0 [ X ] firebird.conf
RemoteServiceUnixSocket
SecurityDatabase /opt/fb60/security6.fdb /opt/fb60/security6.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
StatementTimeout 0 0
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-fb60.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
PAGE_SIZE                       8192


Test configuration settings

param=OLTP_ROOT_DIR, val=/mnt/oltp-emul
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-fb60.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_60.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb60/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=red
param=html_chart_color_memo_att, val=red
param=html_chart_color_memo_stm, val=red
param=html_chart_color_memo_trn, val=red
param=html_chart_color_perf_score, val=red
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=3600
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-fb60-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-fb60
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-10 12:50:58
DTS_END                         2026-11-10 12:50:58.4290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(38:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(98:17)
IP                              ::1/59738
TRN_ID                          175237
ATT_ID                          382
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: 9339.82 1295 466991
customer order: creation 514.90 48 25745
customer order: refuse 44.56 74 2228
order to supplier: creation 132.64 390 6632
order to supplier: removal 8.92 9757 446
invoice (draft): creation 130.60 1898 6530
invoice (draft): removal 84.36 171 4218
invoice accept: apply 111.92 1384 5596
invoice accept: cancel 68.58 230 3429
customer reserve: creation 4468.60 29 223430
customer reserve: removal 3012.44 21 150622
realization accept: apply 235.64 30 11782
realization accept: cancel 118.70 20 5935
payment from customer: creation 172.72 36 8636
payment from customer: removal 16.16 18 808
payment to supplier: creation 140.14 29 7007
payment to supplier: removal 9.50 16 475
service: total inventory turnovers 21.66 1380 1083
service: total monetary turnovers 43.34 7 2167
service: aggregate perf. data 4.38 1502 219
service: refresh index statistics 0.06 8864 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-11-2026 12:51:12 to 10-11-2026 12:51:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5059
TEST_TIME 2 5943
TEST_TIME 3 6522
TEST_TIME 4 6645
TEST_TIME 5 6968
TEST_TIME 6 7265
TEST_TIME 7 7464
TEST_TIME 8 7757
TEST_TIME 9 8040
TEST_TIME 10 8208
TEST_TIME 11 8272
TEST_TIME 12 8323
TEST_TIME 13 8603
TEST_TIME 14 8549
TEST_TIME 15 8615
TEST_TIME 16 8773
TEST_TIME 17 8894
TEST_TIME 18 8840
TEST_TIME 19 8989
TEST_TIME 20 8973
TEST_TIME 21 9129
TEST_TIME 22 9076
TEST_TIME 23 9142
TEST_TIME 24 9177
TEST_TIME 25 9222
TEST_TIME 26 9205
TEST_TIME 27 9225
TEST_TIME 28 9197
TEST_TIME 29 9319
TEST_TIME 30 9309
TEST_TIME 31 9314
TEST_TIME 32 9342
TEST_TIME 33 9314
TEST_TIME 34 9317
TEST_TIME 35 9378
TEST_TIME 36 9307
TEST_TIME 37 9341
TEST_TIME 38 9393
TEST_TIME 39 9376
TEST_TIME 40 9396
TEST_TIME 41 9362
TEST_TIME 42 9343
TEST_TIME 43 9390
TEST_TIME 44 9379
TEST_TIME 45 9384
TEST_TIME 46 9389
TEST_TIME 47 9394
TEST_TIME 48 9396
TEST_TIME 49 9382
TEST_TIME 50 9340

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 10-11-2026 12:51:15 to 10-11-2026 12:51:17.

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 697798 697798 0 0.00 0 1708 3 0 0
doc_list_biud 697798 697798 0 0.00 0 2479 7 0 0
sp_add_invoice_to_stock 5596 5596 0 0.00 5 13299 1384 0 0
sp_cancel_adding_invoice 3429 3429 0 0.00 2 6380 230 0 0
sp_cancel_client_order 2228 2228 0 0.00 2 930 75 0 0
sp_cancel_customer_reserve 150622 150622 0 0.00 1 1723 22 0 0
sp_cancel_pay_from_customer 808 808 0 0.00 1 303 19 0 0
sp_cancel_pay_to_supplier 475 475 0 0.00 2 163 16 0 0
sp_cancel_supplier_invoice 4218 4218 0 0.00 1 1702 172 0 0
sp_cancel_supplier_order 446 446 0 0.00 11 78304 9757 0 0
sp_cancel_write_off 5935 5935 0 0.00 1 1150 21 0 0
sp_client_order 25745 25745 0 0.00 3 2713 49 0 0
sp_customer_reserve 223430 223430 0 0.00 0 2853 29 0 0
sp_fill_shopping_cart 38907 38907 0 0.00 0 9027 307 0 0
sp_fill_shopping_cart_clo_res 223430 223430 0 0.00 0 1195 2 0 0
sp_get_clo_for_invoice 5596 5596 0 0.00 0 2235 31 0 0
sp_kill_cost_storno 10647 10647 0 0.00 0 512 7 0 0
sp_kill_qstorno_ret_qs2qd 311843 311843 0 0.00 0 1694 11 0 0
sp_kill_qty_storno 184256 184256 0 0.00 0 2474 23 0 0
sp_lock_selected_doc 24296 24296 0 0.00 0 650 1 0 0
sp_make_cost_storno 33021 33021 0 0.00 0 672 6 0 0
sp_multiply_rows_for_pdistr 33021 33021 0 0.00 0 407 8 0 0
sp_multiply_rows_for_qdistr 25745 25745 0 0.00 0 956 16 0 0
sp_pay_from_customer 8636 8636 0 0.00 3 1269 37 0 0
sp_pay_to_supplier 7007 7007 0 0.00 2 1274 30 0 0
sp_payment_common 15643 15643 0 0.00 0 786 11 0 0
sp_qd_handle_on_cancel_clo 2228 2228 0 0.00 0 908 51 0 0
sp_qd_handle_on_invoice_upd_sts 9025 9025 0 0.00 0 2275 61 0 0
sp_qd_handle_on_reserve_upd_sts 11782 11782 0 0.00 0 2474 8 0 0
sp_reserve_write_off 11782 11782 0 0.00 3 2483 31 0 0
sp_supplier_invoice 6530 6530 0 0.00 47 10303 1898 0 0
sp_supplier_order 6632 6632 0 0.00 33 8586 390 0 0
srv_aggregate_perf_data 219 219 0 0.00 83 9695 1503 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 7 607 270 0 0
srv_find_qd_qs_mism 432564 432564 0 0.00 0 1708 2 0 0
srv_make_invnt_saldo 1083 1083 0 0.00 0 4956 1380 0 0
srv_make_money_saldo 2167 2167 0 0.00 0 295 7 0 0
srv_recalc_idx_stat 3 3 0 0.00 7075 9843 8865 0 0
v_add_invoice_to_stock 11192 11192 0 0.00 0 577 3 0 0
v_all_customers 39234 39234 0 0.00 0 153 2 0 0
v_all_suppliers 31734 31734 0 0.00 0 80 1 0 0
v_all_wares 51490 51490 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 956 956 0 0.00 0 84 2 0 0
v_cancel_client_order 4456 4456 0 0.00 0 584 2 0 0
v_cancel_customer_prepayment 1616 1616 0 0.00 0 275 2 0 0
v_cancel_customer_reserve 1628 1628 0 0.00 0 153 2 0 0
v_cancel_payment_to_supplier 950 950 0 0.00 0 28 2 0 0
v_cancel_supplier_invoice 906 906 0 0.00 0 181 3 0 0
v_cancel_supplier_order 892 892 0 0.00 0 122 2 0 0
v_cancel_write_off 2432 2432 0 0.00 0 457 2 0 0
v_max_id_clo_ord 6632 6632 0 0.00 1 545 71 0 0
v_max_id_clo_res 1183 1183 0 0.00 0 40 2 0 0
v_max_id_ord_sup 6530 6530 0 0.00 1 4316 746 0 0
v_max_non_paid_invoice 4302 4302 0 0.00 0 67 2 0 0
v_max_non_paid_realizn 8372 8372 0 0.00 0 49 2 0 0
v_min_id_clo_ord 6632 6632 0 0.00 1 5199 98 0 0
v_min_id_clo_res 1183 1183 0 0.00 0 919 5 0 0
v_min_id_ord_sup 6530 6530 0 0.00 1 8514 804 0 0
v_min_non_paid_invoice 7007 7007 0 0.00 0 464 4 0 0
v_min_non_paid_realizn 8636 8636 0 0.00 0 283 5 0 0
v_our_firm 12784 12784 0 0.00 0 47 1 0 0
v_reserve_write_off 23564 23564 0 0.00 0 633 2 0 0
x_lock_depdocs_on_canc_invoice 7194 7194 0 0.00 0 1007 8 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 206 7 0 0
x_make_qstorno_1000_1200 6632 6632 0 0.00 1 3648 165 0 0
x_make_qstorno_1200_2000 6530 6530 0 0.00 1 4326 310 0 0
x_make_qstorno_2100_3300 223430 223430 0 0.00 0 2853 26 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 10-11-2026 12:51:17 to 10-11-2026 12:51:22.

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
12:01:02 6 2147483648 2257003360 2259726336 35552 0.001 1 1 2 0 194256 116736 41968
12:02:03 279 2147483648 2337514144 2431901696 899504 0.041 20 8 17 0 3175792 1232624 1043664
12:03:06 362 2147483648 2338204608 2436681728 616656 0.028 20 6 14 0 3921584 2031984 1272944
12:04:06 349 2147483648 2342447376 2443780096 160272 0.007 20 11 24 1 3304624 1404256 1740096
12:05:07 476 2147483648 2343355280 2446405632 -145072 -0.006 20 12 25 0 3132512 1237456 2040128
12:06:08 433 2147483648 2342533728 2447097856 1296832 0.060 20 5 10 0 3106128 1202944 606352
12:07:09 279 2147483648 2349984512 2453835776 -2841120 -0.132 20 12 29 0 3654576 1770016 4725680
12:08:10 171 2147483648 2348998752 2455191552 -1112032 -0.051 20 14 34 0 3856992 1956208 3012816
12:09:10 478 2147483648 2348062752 2455437312 269120 0.012 20 5 12 0 2674880 798304 1607456
12:10:11 158 2147483648 2352048992 2461847552 271904 0.012 20 10 22 0 4318432 2419872 1626656
12:11:11 199 2147483648 2349080704 2458673152 1262064 0.058 20 4 8 0 4653120 2787264 603792
12:12:12 181 2147483648 2353481344 2461024256 -1663968 -0.077 20 8 18 0 5926512 4045296 3545184
12:13:12 120 2147483648 2381405744 2474434560 -127184 -0.005 20 10 20 0 32898624 30999408 2026400
12:14:13 251 2147483648 2351472464 2469367808 -4242256 -0.197 19 13 35 0 2598320 815824 6024752
12:15:14 268 2147483648 2354082624 2472984576 -1594032 -0.074 20 9 23 0 4116176 2221168 3489040
12:16:14 174 2147483648 2359249632 2472726528 37824 0.001 20 10 22 0 11199488 9296576 1865088
12:17:15 183 2147483648 2366305616 2475245568 -1325344 -0.061 20 13 28 0 13773664 11882304 3216704
12:18:16 415 2147483648 2364592544 2477678592 -2084752 -0.097 20 13 29 1 9222640 7350944 3956448
12:19:17 382 2147483648 2359880480 2473504768 -2766624 -0.128 20 9 22 0 10338800 8461440 4643984
12:20:17 214 2147483648 2355046912 2473357312 -636912 -0.029 20 10 22 1 3708960 1815152 2530720
12:21:18 213 2147483648 2364902368 2476142592 -2678608 -0.124 20 10 23 0 11403072 9510192 4571488
12:22:18 189 2147483648 2362035008 2478850048 -4863424 -0.226 20 10 23 0 6150080 4269744 6743760
12:23:19 155 2147483648 2362406496 2472787968 -618000 -0.028 19 9 19 0 13511120 11716576 2412544
12:24:20 199 2147483648 2357073952 2475212800 -1913520 -0.089 20 12 26 0 4539760 2648112 3805168
12:25:20 278 2147483648 2367069296 2483957760 -5704944 -0.266 20 15 37 0 8614160 6731648 7587456
12:26:21 222 2147483648 2359392080 2473082880 430176 0.020 20 10 21 1 9961168 8073264 1457728
12:27:22 314 2147483648 2369255712 2479243264 -2781888 -0.129 20 12 27 0 14940944 13049152 4673680
12:28:23 328 2147483648 2358043856 2474659840 -2062416 -0.096 19 12 26 0 5435024 3642192 3855248
12:29:23 201 2147483648 2382397024 2486792192 -5793328 -0.270 20 14 32 0 24613904 22719168 7688064
12:30:24 360 2147483648 2370602880 2485460992 -5990176 -0.279 20 10 26 0 11474096 9582480 7881792
12:31:24 282 2147483648 2356904576 2450268160 -1487200 -0.069 20 8 20 0 13034768 11147088 3374880
12:32:26 173 2147483648 2366134160 2468724736 -2404624 -0.112 20 14 28 0 13761872 11871616 4294880
12:33:26 144 2147483648 2358777216 2468999168 -950496 -0.044 20 11 24 0 5840384 3943824 2847056
12:34:27 185 2147483648 2371393088 2475397120 -5946656 -0.277 20 16 36 0 14064848 12189408 7822096
12:35:27 146 2147483648 2367412832 2476638208 -1193680 -0.055 20 14 29 0 10753776 8861552 3085904
12:36:28 313 2147483648 2369468800 2482069504 -9015424 -0.421 20 14 36 0 9096400 7207136 10904688
12:37:29 272 2147483648 2360975648 2471428096 806256 0.037 20 7 14 0 8769280 6880288 1082736
12:38:29 307 2147483648 2383288544 2489331712 -14461552 -0.677 20 17 45 0 16329936 14437600 16353888
12:39:30 136 2147483648 2370813216 2480992256 -3095328 -0.144 20 12 27 0 12961392 11074192 4982528
12:40:30 603 2147483648 2361837712 2477989888 -9796304 -0.458 20 14 34 0 8002320 6122016 11676608
12:41:31 326 2147483648 2359196928 2478231552 -4604816 -0.214 20 10 24 1 5595952 3707792 6492976
12:42:32 202 2147483648 2370194768 2483486720 -6204368 -0.289 20 17 39 1 11150800 9261760 8093408
12:43:32 388 2147483648 2376965056 2490269696 -12697248 -0.594 20 12 30 0 14775328 12893232 14579344
12:44:33 145 2147483648 2373512832 2483953664 -2050768 -0.095 20 11 23 1 17141040 15257840 3933968
12:45:33 266 2147483648 2366160544 2485813248 -5929024 -0.276 20 18 42 0 6929120 5045664 7812480
12:46:34 273 2147483648 2386362560 2496327680 -10499584 -0.491 20 17 46 0 18954672 17057872 12396384
12:47:35 278 2147483648 2374625872 2490548224 -14459424 -0.677 20 16 40 0 9175696 7280480 16354640
12:48:35 182 2147483648 2373428208 2489294848 -5822064 -0.271 20 16 39 0 12179056 10280848 7720272
12:49:36 302 2147483648 2371455824 2492506112 -10995328 -0.514 20 14 38 0 5630176 3741376 12884128
12:50:36 607 2147483648 2374166912 2497511424 -10712272 -0.501 20 14 39 0 5741488 3852576 12601184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-11-2026 12:51:23 to 10-11-2026 12:51:37.

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 10-11-2026 12:51:37 to 10-11-2026 12:51:38.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb60.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   14
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          174409
MON$OLDEST_ACTIVE               175401
MON$OLDEST_SNAPSHOT             175401
MON$NEXT_TRANSACTION            175401
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-10 09:00:11.6700 GMT
MON$PAGES                       136354
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                        {CBFD53F0-3AEF-49E2-A9F9-788ECB77BD62}
MON$FILE_ID                     0108000000000000c3ec070000000000
MON$NEXT_ATTACHMENT             509
MON$NEXT_STATEMENT              900
MON$REPLICA_MODE                0


ISQL Version: LI-T6.0.0.2455 Firebird 6.0 67dbeb4
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T6.0.0.2455 Firebird 6.0 67dbeb4"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T6.0.0.2455 Firebird 6.0 67dbeb4/tcp (test-0)/P20:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T6.0.0.2455 Firebird 6.0 67dbeb4/tcp (test-0)/P20:C"
on disk structure version 14.0

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 10 12:50:59 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:9: 
:10: 
:11: test-0    Tue Nov 10 12:50:59 2026
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:13: 
:14: 
:15: test-0    Tue Nov 10 12:51:00 2026
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3600
:17: 
--- end of diff output ---

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

10.11.26 12:51:38. There are 3 logs in /var/tmp/logs.oltp-fb60 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-10 12:51:39 No severe PSQL-related problems occured
10.11.26 12:51:40. End of report.