Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 12.11.2026 03: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 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 4d
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 2188728 kB
MemAvailable 7183812 kB
Buffers 80152 kB
Cached 5033912 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, gssauth, Legacy_Auth Srp256, Srp, gssauth, Legacy_Auth
AuthServer Srp256 Srp256
BlobTempSpace 0 0
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
DisableLogNetIOErrors true true
DummyPacketInterval 0 0
EnableMonDebug false false
EventMemSize 65536 65536
ExtConnPoolLifeTime 7200 7200
ExtConnPoolSize 0 0
ExternalFileAccess None None
FileSystemCacheSize 0 0
FileSystemCacheThreshold 65536 65536
FillMonCallStack true true
FillMonCompiledStatements true true
FillMonStatements true true
GCPolicy combined combined
GuardianOption 1 1
HQbirdVersionString true true
IPv6V6Only false false
InlineSortThreshold 1000 1000
IpcName oemul_hq50SS FirebirdIPI [ X ] firebird.conf
KeyHolderPlugin [empty] [empty]
LegacyHash true true
LegacyIntForCount false false
LegacyTimeLiterals false false
LockAcquireSpins 0 0
LockHashSlots 30011 8191 [ X ] firebird.conf
LockMemSize 10485760 1048576 [ X ] firebird.conf
MaxCountAttachments 0 0
MaxDbCachePages 2048 2048
MaxIdentifierByteLength 252 252
MaxIdentifierCharLength 63 63
MaxParallelWorkers 1 1
MaxStatementCacheSize 2097152 2097152
MaxTempBlobs 1000 1000
MaxUnflushedWriteTime -1 -1
MaxUnflushedWrites -1 -1
MaxUserTraceLogSize 10 10
MinDbCachePages 30000 30000
MonitoringPlugin [empty] [empty]
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 30500 0 [ X ] firebird.conf
SecurityDatabase /opt/hq50/security5.fdb /opt/hq50/security5.fdb
ServerMode Super Super [ X ] firebird.conf
SnapshotsMemSize 65536 65536
SqlSubstDirectory subst subst
StatementTimeout 0 0
SubQueryConversion false false
TcpNoNagle true true
TcpRemoteBufferSize 8192 8192
TempBlockSize 1048576 1048576
TempCacheLimit 536870912 67108864 [ X ] firebird.conf
TempDirectories
TempSpaceLogThreshold 0 0
TempTableDirectory [empty] [empty]
TipCacheBlockSize 4194304 4194304
TraceAll false false
TraceDSQL 0 0
TracePlugin fbtrace fbtrace
UdfAccess Restrict UDF None [ X ] firebird.conf
UseFileSystemCache true true [ X ] firebird.conf
UserManager Srp Srp
WarnCountAttachments 0 0
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-hq50.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-hq50.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/hq50/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=30500
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-hq50-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-hq50
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-12 03:50:35
DTS_END                         2026-11-12 03:50:35.7040
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/55246
TRN_ID                          236735
ATT_ID                          495
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: 16299.72 984 814986
customer order: creation 711.14 39 35557
customer order: refuse 55.52 49 2776
order to supplier: creation 178.26 185 8913
order to supplier: removal 13.54 8461 677
invoice (draft): creation 175.48 335 8774
invoice (draft): removal 130.24 139 6512
invoice accept: apply 150.36 1368 7518
invoice accept: cancel 107.70 189 5385
customer reserve: creation 7837.18 22 391859
customer reserve: removal 5877.60 14 293880
realization accept: apply 325.42 30 16271
realization accept: cancel 193.86 17 9693
payment from customer: creation 230.72 34 11536
payment from customer: removal 21.84 15 1092
payment to supplier: creation 189.98 25 9499
payment to supplier: removal 13.12 15 656
service: total inventory turnovers 24.72 1300 1236
service: total monetary turnovers 57.42 14 2871
service: aggregate perf. data 5.58 1595 279
service: refresh index statistics 0.04 5833 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 12-11-2026 03:50:54 to 12-11-2026 03:50:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 13725
TEST_TIME 2 13731
TEST_TIME 3 13993
TEST_TIME 4 14391
TEST_TIME 5 14718
TEST_TIME 6 14854
TEST_TIME 7 15057
TEST_TIME 8 15106
TEST_TIME 9 15223
TEST_TIME 10 15190
TEST_TIME 11 15200
TEST_TIME 12 15242
TEST_TIME 13 15141
TEST_TIME 14 15211
TEST_TIME 15 15282
TEST_TIME 16 15299
TEST_TIME 17 15229
TEST_TIME 18 15296
TEST_TIME 19 15257
TEST_TIME 20 15474
TEST_TIME 21 15405
TEST_TIME 22 15395
TEST_TIME 23 15448
TEST_TIME 24 15458
TEST_TIME 25 15500
TEST_TIME 26 15524
TEST_TIME 27 15566
TEST_TIME 28 15620
TEST_TIME 29 15603
TEST_TIME 30 15591
TEST_TIME 31 15545
TEST_TIME 32 15674
TEST_TIME 33 15671
TEST_TIME 34 15778
TEST_TIME 35 15763
TEST_TIME 36 15807
TEST_TIME 37 15891
TEST_TIME 38 15888
TEST_TIME 39 16088
TEST_TIME 40 16039
TEST_TIME 41 16091
TEST_TIME 42 16149
TEST_TIME 43 16228
TEST_TIME 44 16187
TEST_TIME 45 16215
TEST_TIME 46 16285
TEST_TIME 47 16302
TEST_TIME 48 16316
TEST_TIME 49 16422
TEST_TIME 50 16300

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 12-11-2026 03:50:55 to 12-11-2026 03:50:57.

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 1198659 1198659 0 0.00 0 1401 2 0 0
doc_list_biud 1198659 1198659 0 0.00 0 2797 5 0 0
sp_add_invoice_to_stock 7518 7518 0 0.00 4 14462 1368 0 0
sp_cancel_adding_invoice 5385 5385 0 0.00 3 4684 189 0 0
sp_cancel_client_order 2776 2776 0 0.00 2 1331 50 0 0
sp_cancel_customer_reserve 293880 293880 0 0.00 1 1912 14 0 0
sp_cancel_pay_from_customer 1092 1092 0 0.00 1 168 16 0 0
sp_cancel_pay_to_supplier 656 656 0 0.00 1 288 15 0 0
sp_cancel_supplier_invoice 6512 6512 0 0.00 1 1686 140 0 0
sp_cancel_supplier_order 677 677 0 0.00 5 64681 8462 0 0
sp_cancel_write_off 9693 9693 0 0.00 1 1423 17 0 0
sp_client_order 35557 35557 0 0.00 3 1531 39 0 0
sp_customer_reserve 391859 391859 0 0.00 0 2138 22 0 0
sp_fill_shopping_cart 53244 53244 0 0.00 0 2826 16 0 0
sp_fill_shopping_cart_clo_res 391859 391859 0 0.00 0 1356 2 0 0
sp_get_clo_for_invoice 7518 7518 0 0.00 0 1633 36 0 0
sp_kill_cost_storno 16826 16826 0 0.00 0 823 8 0 0
sp_kill_qstorno_ret_qs2qd 604642 604642 0 0.00 0 2595 7 0 0
sp_kill_qty_storno 342712 342712 0 0.00 0 2797 16 0 0
sp_lock_selected_doc 32893 32893 0 0.00 0 1090 1 0 0
sp_make_cost_storno 44824 44824 0 0.00 0 649 6 0 0
sp_multiply_rows_for_pdistr 44824 44824 0 0.00 0 736 9 0 0
sp_multiply_rows_for_qdistr 35557 35557 0 0.00 0 923 16 0 0
sp_pay_from_customer 11536 11536 0 0.00 2 1238 34 0 0
sp_pay_to_supplier 9499 9499 0 0.00 2 1137 26 0 0
sp_payment_common 21035 21035 0 0.00 0 1110 9 0 0
sp_qd_handle_on_cancel_clo 2776 2776 0 0.00 0 1328 37 0 0
sp_qd_handle_on_invoice_upd_sts 12903 12903 0 0.00 0 2797 66 0 0
sp_qd_handle_on_reserve_upd_sts 16271 16271 0 0.00 0 1384 10 0 0
sp_reserve_write_off 16271 16271 0 0.00 2 1695 31 0 0
sp_supplier_invoice 8774 8774 0 0.00 4 6424 335 0 0
sp_supplier_order 8913 8913 0 0.00 3 2564 185 0 0
srv_aggregate_perf_data 279 279 0 0.00 89 7786 1595 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 549 298 0 0
srv_find_qd_qs_mism 759294 759294 0 0.00 0 1401 1 0 0
srv_make_invnt_saldo 1236 1236 0 0.00 0 4957 1300 0 0
srv_make_money_saldo 2871 2871 0 0.00 0 225 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 326 11340 5833 0 0
v_add_invoice_to_stock 15036 15036 0 0.00 0 509 2 0 0
v_all_customers 53766 53766 0 0.00 0 179 0 0 0
v_all_suppliers 44096 44096 0 0.00 0 93 0 0 0
v_all_wares 71114 71114 0 0.00 0 75 0 0 0
v_cancel_adding_invoice 1256 1256 0 0.00 0 277 2 0 0
v_cancel_client_order 5552 5552 0 0.00 0 461 1 0 0
v_cancel_customer_prepayment 2184 2184 0 0.00 0 91 1 0 0
v_cancel_customer_reserve 2118 2118 0 0.00 0 529 2 0 0
v_cancel_payment_to_supplier 1312 1312 0 0.00 0 275 2 0 0
v_cancel_supplier_invoice 1254 1254 0 0.00 0 471 3 0 0
v_cancel_supplier_order 1354 1354 0 0.00 0 14 1 0 0
v_cancel_write_off 3178 3178 0 0.00 0 395 2 0 0
v_max_id_clo_ord 8913 8913 0 0.00 0 210 1 0 0
v_max_id_clo_res 1604 1604 0 0.00 0 116 1 0 0
v_max_id_ord_sup 8774 8774 0 0.00 0 919 2 0 0
v_max_non_paid_invoice 5138 5138 0 0.00 0 250 2 0 0
v_max_non_paid_realizn 11207 11207 0 0.00 0 335 1 0 0
v_min_id_clo_ord 8913 8913 0 0.00 0 621 2 0 0
v_min_id_clo_res 1604 1604 0 0.00 0 561 3 0 0
v_min_id_ord_sup 8774 8774 0 0.00 0 1114 4 0 0
v_min_non_paid_invoice 9499 9499 0 0.00 0 721 3 0 0
v_min_non_paid_realizn 11536 11536 0 0.00 0 568 5 0 0
v_our_firm 18006 18006 0 0.00 0 60 0 0 0
v_reserve_write_off 32542 32542 0 0.00 0 513 1 0 0
x_lock_depdocs_on_canc_invoice 11270 11270 0 0.00 0 1324 9 0 0
x_lock_depdocs_on_canc_sup_ord 677 677 0 0.00 0 777 13 0 0
x_make_qstorno_1000_1200 8913 8913 0 0.00 1 2522 138 0 0
x_make_qstorno_1200_2000 8774 8774 0 0.00 1 6399 296 0 0
x_make_qstorno_2100_3300 391859 391859 0 0.00 0 2134 19 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2026 03:50:57 to 12-11-2026 03:51:01.

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
03:00:38 3 2147483648 2253169168 2255597568 4080464 0.189 1 1 2 0 4149520 60512 8544
03:01:40 325 2147483648 2504097088 2725408768 250506000 10.446 20 6 12 0 251532288 809360 216928
03:02:41 348 2147483648 2505935632 2718171136 249708752 10.416 20 12 25 0 251284912 1065520 510640
03:03:41 331 2147483648 2517301328 2751975424 259974160 10.798 20 12 20 1 262804224 2457120 372944
03:04:42 243 2147483648 2526404192 2774577152 271207088 11.212 20 10 18 0 272809696 1284752 317856
03:05:43 416 2147483648 2528831920 2762080256 264211216 10.955 20 9 18 0 272695040 8099040 384784
03:06:43 183 2147483648 2528007200 2773438464 265461088 11.001 20 13 26 1 271582960 5599344 522528
03:07:44 227 2147483648 2527588512 2770837504 271550080 11.225 20 10 20 0 274401408 2461936 389392
03:08:44 321 2147483648 2527608208 2767085568 265403424 10.999 20 11 22 0 270849664 5061440 384800
03:09:45 282 2147483648 2536741584 2778456064 273238704 11.287 20 11 21 0 282414272 8783520 392048
03:10:45 325 2147483648 2529377216 2770800640 271598208 11.227 20 12 24 0 274869136 2804608 466320
03:11:46 246 2147483648 2528797664 2764816384 269067472 11.134 20 8 16 0 274472272 5012400 392400
03:12:46 215 2147483648 2539885696 2794713088 277986096 11.461 20 14 28 0 285448592 6830672 631824
03:13:47 272 2147483648 2522751920 2758332416 263926656 10.944 20 9 19 0 268591472 4140240 524576
03:14:47 203 2147483648 2533724512 2777554944 270398656 11.183 20 11 22 0 278543616 7687616 457344
03:15:48 285 2147483648 2539142336 2784063488 267211152 11.066 20 9 18 0 282901264 15295648 394464
03:16:49 385 2147483648 2538004864 2779557888 265258384 10.994 20 15 28 1 282128592 16150336 719872
03:17:49 297 2147483648 2537940880 2785177600 274288848 11.325 20 15 30 0 282266192 7317792 659552
03:18:50 252 2147483648 2524948960 2758799360 264106992 10.951 20 10 20 0 268748240 4169168 472080
03:19:50 278 2147483648 2558387888 2796425216 271429456 11.221 20 15 29 0 305723136 33662560 631120
03:20:51 350 2147483648 2549550928 2804277248 277568448 11.445 20 15 29 0 291765360 13621856 575056
03:21:53 185 2147483648 2528817392 2766925824 264497392 10.965 20 12 24 0 273928336 8920032 510912
03:22:53 346 2147483648 2542619824 2797563904 275755776 11.379 20 13 27 0 286916320 10677184 483360
03:23:54 179 2147483648 2529911488 2773655552 266810800 11.051 20 11 22 0 275117728 7848336 458592
03:24:55 227 2147483648 2536244768 2781958144 271041968 11.206 20 9 18 0 279730080 8353360 334752
03:25:55 182 2147483648 2534492640 2785398784 271253680 11.214 20 12 24 0 279456896 7750032 453184
03:26:55 238 2147483648 2535838320 2780053504 267325056 11.070 20 12 24 0 279730352 11833856 571440
03:27:56 236 2147483648 2542176752 2790006784 275225280 11.360 20 13 26 0 287538640 11790816 522544
03:28:57 408 2147483648 2546268144 2799099904 278144208 11.466 20 5 10 0 291781632 13439344 198080
03:29:57 351 2147483648 2522582624 2752655360 255263904 10.623 19 11 22 0 266031248 10272880 494464
03:30:58 198 2147483648 2530891920 2766155776 270402784 11.183 20 10 21 0 275464928 4648336 413808
03:31:58 548 2147483648 2552803744 2789330944 267194272 11.065 20 11 23 0 292780928 25094784 491872
03:33:01 314 2147483648 2536880160 2773237760 263366144 10.924 20 15 30 0 280025008 15982160 676704
03:34:02 176 2147483648 2537034144 2784124928 268820432 11.125 20 9 18 0 281128640 11931808 376400
03:35:02 339 2147483648 2536057440 2780041216 268882400 11.127 20 13 25 0 279236352 9906832 447120
03:36:03 482 2147483648 2527079472 2769543168 265216704 10.992 20 8 16 0 269924064 4276560 430800
03:37:04 417 2147483648 2530386544 2774192128 267084672 11.061 20 9 18 0 275048064 7661536 301856
03:38:05 266 2147483648 2524897600 2763870208 260403200 10.814 20 10 20 0 267609216 6851824 354192
03:39:05 372 2147483648 2558203072 2800324608 270753952 11.196 20 12 24 0 301077072 29767872 555248
03:40:06 392 2147483648 2530909680 2778398720 267026176 11.059 20 13 27 0 272752864 5195088 531600
03:41:08 184 2147483648 2536184384 2783170560 268440400 11.111 20 6 12 0 280125712 11352816 332496
03:42:08 312 2147483648 2548158656 2790821888 268774640 11.123 20 13 26 0 291711488 22186256 750592
03:43:09 304 2147483648 2552110608 2798829568 270361472 11.181 20 14 28 0 295565328 24280464 923392
03:44:09 304 2147483648 2529311424 2778480640 264381296 10.961 20 7 14 0 272662400 7997936 283168
03:45:10 266 2147483648 2538598288 2775953408 266277360 11.031 20 11 22 0 281638640 14916720 444560
03:46:10 318 2147483648 2541978064 2788261888 268585808 11.116 20 15 29 0 285630240 16545760 498672
03:47:11 281 2147483648 2545276048 2793824256 268056480 11.097 20 14 27 0 290152640 21471248 624912
03:48:11 424 2147483648 2548471616 2777411584 257873440 10.720 20 15 30 0 289170000 30734064 562496
03:49:12 305 2147483648 2559189424 2807996416 271004352 11.205 20 12 24 0 304083952 32485408 594192
03:50:13 287 2147483648 2538706016 2786377728 263906992 10.944 20 9 17 0 281975808 17782912 285904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 12-11-2026 03:51:01 to 12-11-2026 03:51:13.

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

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq50.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   1
MON$OLDEST_TRANSACTION          236691
MON$OLDEST_ACTIVE               237267
MON$OLDEST_SNAPSHOT             237267
MON$NEXT_TRANSACTION            237267
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-12 00:00:09.8590 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                        {CEB38CA0-7DA2-43CD-B4DE-796EC38F2D45}
MON$FILE_ID                     0108000000000000c2ed070000000000
MON$NEXT_ATTACHMENT             607
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1917 Firebird 5.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1917 Firebird 5.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1917 Firebird 5.0 HQbird/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1917 Firebird 5.0 HQbird/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 ---
--- end of diff output ---

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

12.11.26 03:51:14. There are 3 logs in /var/tmp/logs.oltp-hq50 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-12 03:51:15 No severe PSQL-related problems occured
12.11.26 03:51:15. End of report.