Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 17.11.2026 07: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 2438480 kB
MemAvailable 7494472 kB
Buffers 79444 kB
Cached 5059936 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 07:50:31
DTS_END                         2026-11-17 07:50:31.1170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(59:5) ==> X_MAKE_QSTORNO_1200_2000(289:25) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/37192
TRN_ID                          238855
ATT_ID                          499
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: 16377.98 1100 818899
customer order: creation 706.26 37 35313
customer order: refuse 60.08 50 3004
order to supplier: creation 181.32 181 9066
order to supplier: removal 13.24 8552 662
invoice (draft): creation 177.76 336 8888
invoice (draft): removal 128.80 135 6440
invoice accept: apply 152.52 1317 7626
invoice accept: cancel 107.10 190 5355
customer reserve: creation 7928.80 21 396440
customer reserve: removal 5852.80 14 292640
realization accept: apply 334.18 31 16709
realization accept: cancel 189.60 17 9480
payment from customer: creation 236.86 31 11843
payment from customer: removal 21.24 15 1062
payment to supplier: creation 189.18 25 9459
payment to supplier: removal 13.76 15 688
service: total inventory turnovers 24.10 1330 1205
service: total monetary turnovers 55.04 14 2752
service: aggregate perf. data 5.30 1620 265
service: refresh index statistics 0.04 8064 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 17-11-2026 07:50:43 to 17-11-2026 07:50:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 16784
TEST_TIME 2 15774
TEST_TIME 3 15676
TEST_TIME 4 15575
TEST_TIME 5 15663
TEST_TIME 6 15652
TEST_TIME 7 15574
TEST_TIME 8 15636
TEST_TIME 9 15636
TEST_TIME 10 15831
TEST_TIME 11 15822
TEST_TIME 12 15864
TEST_TIME 13 15921
TEST_TIME 14 15822
TEST_TIME 15 15930
TEST_TIME 16 15824
TEST_TIME 17 15912
TEST_TIME 18 15912
TEST_TIME 19 15892
TEST_TIME 20 15790
TEST_TIME 21 15822
TEST_TIME 22 15754
TEST_TIME 23 15808
TEST_TIME 24 15899
TEST_TIME 25 15893
TEST_TIME 26 15914
TEST_TIME 27 15904
TEST_TIME 28 15849
TEST_TIME 29 15842
TEST_TIME 30 15911
TEST_TIME 31 15899
TEST_TIME 32 15919
TEST_TIME 33 15938
TEST_TIME 34 15983
TEST_TIME 35 16105
TEST_TIME 36 16113
TEST_TIME 37 16192
TEST_TIME 38 16262
TEST_TIME 39 16240
TEST_TIME 40 16275
TEST_TIME 41 16341
TEST_TIME 42 16345
TEST_TIME 43 16442
TEST_TIME 44 16396
TEST_TIME 45 16446
TEST_TIME 46 16466
TEST_TIME 47 16468
TEST_TIME 48 16523
TEST_TIME 49 16568
TEST_TIME 50 16378

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:01, from 17-11-2026 07:50:45 to 17-11-2026 07:50:46.

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 1206442 1206442 0 0.00 0 1483 2 0 0
doc_list_biud 1206442 1206442 0 0.00 0 1995 5 0 0
sp_add_invoice_to_stock 7626 7626 0 0.00 6 11414 1317 0 0
sp_cancel_adding_invoice 5355 5355 0 0.00 2 5447 191 0 0
sp_cancel_client_order 3004 3004 0 0.00 2 1344 51 0 0
sp_cancel_customer_reserve 292640 292640 0 0.00 1 1976 14 0 0
sp_cancel_pay_from_customer 1062 1062 0 0.00 1 201 16 0 0
sp_cancel_pay_to_supplier 688 688 0 0.00 1 306 16 0 0
sp_cancel_supplier_invoice 6440 6440 0 0.00 1 1789 136 0 0
sp_cancel_supplier_order 662 662 0 0.00 5 62121 8552 0 0
sp_cancel_write_off 9480 9480 0 0.00 1 818 18 0 0
sp_client_order 35313 35313 0 0.00 2 1323 37 0 0
sp_customer_reserve 396440 396440 0 0.00 0 2391 21 0 0
sp_fill_shopping_cart 53267 53267 0 0.00 0 2528 16 0 0
sp_fill_shopping_cart_clo_res 396440 396440 0 0.00 0 1388 2 0 0
sp_get_clo_for_invoice 7626 7626 0 0.00 0 1660 33 0 0
sp_kill_cost_storno 16585 16585 0 0.00 0 873 8 0 0
sp_kill_qstorno_ret_qs2qd 601862 601862 0 0.00 0 1995 7 0 0
sp_kill_qty_storno 341916 341916 0 0.00 0 1995 17 0 0
sp_lock_selected_doc 33704 33704 0 0.00 0 943 1 0 0
sp_make_cost_storno 45637 45637 0 0.00 0 668 6 0 0
sp_multiply_rows_for_pdistr 45637 45637 0 0.00 0 1481 8 0 0
sp_multiply_rows_for_qdistr 35313 35313 0 0.00 0 1309 16 0 0
sp_pay_from_customer 11843 11843 0 0.00 1 1275 32 0 0
sp_pay_to_supplier 9459 9459 0 0.00 2 1487 26 0 0
sp_payment_common 21302 21302 0 0.00 0 554 8 0 0
sp_qd_handle_on_cancel_clo 3004 3004 0 0.00 0 1340 37 0 0
sp_qd_handle_on_invoice_upd_sts 12981 12981 0 0.00 0 1939 66 0 0
sp_qd_handle_on_reserve_upd_sts 16709 16709 0 0.00 0 1385 9 0 0
sp_reserve_write_off 16709 16709 0 0.00 2 1397 31 0 0
sp_supplier_invoice 8888 8888 0 0.00 4 5512 336 0 0
sp_supplier_order 9066 9066 0 0.00 3 3576 182 0 0
srv_aggregate_perf_data 265 265 0 0.00 59 6775 1621 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 503 290 0 0
srv_find_qd_qs_mism 762653 762653 0 0.00 0 1477 1 0 0
srv_make_invnt_saldo 1205 1205 0 0.00 1 4705 1331 0 0
srv_make_money_saldo 2752 2752 0 0.00 0 247 14 0 0
srv_recalc_idx_stat 2 2 0 0.00 180 15949 8065 0 0
v_add_invoice_to_stock 15252 15252 0 0.00 0 659 2 0 0
v_all_customers 53594 53594 0 0.00 0 37 0 0 0
v_all_suppliers 43946 43946 0 0.00 0 86 0 0 0
v_all_wares 70626 70626 0 0.00 0 82 0 0 0
v_cancel_adding_invoice 1334 1334 0 0.00 0 504 2 0 0
v_cancel_client_order 6008 6008 0 0.00 0 463 1 0 0
v_cancel_customer_prepayment 2124 2124 0 0.00 0 115 1 0 0
v_cancel_customer_reserve 2220 2220 0 0.00 0 318 2 0 0
v_cancel_payment_to_supplier 1376 1376 0 0.00 0 136 1 0 0
v_cancel_supplier_invoice 1146 1146 0 0.00 0 72 2 0 0
v_cancel_supplier_order 1324 1324 0 0.00 0 91 1 0 0
v_cancel_write_off 3206 3206 0 0.00 0 398 2 0 0
v_max_id_clo_ord 9066 9066 0 0.00 0 243 1 0 0
v_max_id_clo_res 1672 1672 0 0.00 0 111 1 0 0
v_max_id_ord_sup 8888 8888 0 0.00 0 863 1 0 0
v_max_non_paid_invoice 5440 5440 0 0.00 0 205 2 0 0
v_max_non_paid_realizn 11490 11490 0 0.00 0 489 1 0 0
v_min_id_clo_ord 9066 9066 0 0.00 0 727 2 0 0
v_min_id_clo_res 1672 1672 0 0.00 0 703 3 0 0
v_min_id_ord_sup 8888 8888 0 0.00 0 1152 3 0 0
v_min_non_paid_invoice 9459 9459 0 0.00 0 410 3 0 0
v_min_non_paid_realizn 11843 11843 0 0.00 0 553 5 0 0
v_our_firm 17738 17738 0 0.00 0 26 0 0 0
v_reserve_write_off 33418 33418 0 0.00 0 450 1 0 0
x_lock_depdocs_on_canc_invoice 11222 11222 0 0.00 0 1436 9 0 0
x_lock_depdocs_on_canc_sup_ord 662 662 0 0.00 0 245 10 0 0
x_make_qstorno_1000_1200 9066 9066 0 0.00 1 2853 134 0 0
x_make_qstorno_1200_2000 8888 8888 0 0.00 1 5440 300 0 0
x_make_qstorno_2100_3300 396440 396440 0 0.00 0 2211 19 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 17-11-2026 07:50:47 to 17-11-2026 07:50:50.

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
07:00:34 3 2147483648 2253215104 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
07:01:35 275 2147483648 2523372704 2759163904 268751360 11.122 20 8 19 0 270253584 1154160 348064
07:02:35 233 2147483648 2516390816 2742394880 260415296 10.815 20 11 21 1 262475904 1521744 538864
07:03:36 213 2147483648 2491683600 2701553664 232727456 9.777 18 10 21 0 237143600 3962848 453296
07:04:36 215 2147483648 2531598368 2780827648 271914496 11.238 20 12 27 1 277383104 4878672 589936
07:05:37 328 2147483648 2531108368 2776604672 273018640 11.279 20 12 24 0 276400592 2918704 463248
07:06:38 347 2147483648 2531190176 2773008384 266492688 11.039 20 15 31 3 276662992 9390128 780176
07:07:38 248 2147483648 2532280400 2778644480 271562080 11.226 20 17 32 1 277909072 5651456 695536
07:08:39 232 2147483648 2529077808 2779693056 272854352 11.273 20 10 21 0 275740752 2420400 466000
07:09:39 239 2147483648 2525874736 2767265792 269618960 11.154 20 11 24 0 271450736 1332496 499280
07:10:40 328 2147483648 2542986032 2786545664 270387728 11.182 20 14 26 0 286901600 15915056 598816
07:11:40 316 2147483648 2537240272 2781028352 269544064 11.151 20 17 34 0 281397872 11026384 827424
07:12:41 315 2147483648 2525274400 2769010688 266395424 11.035 20 9 17 0 269589616 2807232 386960
07:13:42 263 2147483648 2545875824 2792206336 271489360 11.223 20 14 28 1 290374800 18161040 724400
07:14:42 259 2147483648 2536604752 2771230720 268265376 11.104 20 16 31 0 280451712 11528144 658192
07:15:43 273 2147483648 2541565744 2800848896 272570672 11.262 20 12 26 0 279529920 6330704 628544
07:16:44 272 2147483648 2528207024 2763722752 265291792 10.995 20 13 27 0 272179200 6245312 642096
07:17:44 219 2147483648 2539837632 2792669184 273513184 11.297 20 8 18 0 285030656 11122560 394912
07:18:45 259 2147483648 2533740944 2788782080 272620640 11.264 20 14 27 0 278908928 5605360 682928
07:19:45 244 2147483648 2539464560 2783055872 271621232 11.228 20 12 24 0 283272144 11096448 554464
07:20:46 364 2147483648 2526909104 2771558400 261293392 10.847 19 9 20 0 269955728 8118976 543360
07:21:47 323 2147483648 2550392752 2802118656 276944464 11.423 20 11 22 0 295537984 18005216 588304
07:22:48 323 2147483648 2534015968 2779664384 271294464 11.216 20 15 31 2 276514640 4486656 733520
07:23:48 311 2147483648 2542054496 2784641024 271162256 11.211 20 10 20 0 286187808 14509472 516080
07:24:49 336 2147483648 2540069504 2781474816 270151728 11.174 20 9 18 1 285027376 14292912 582736
07:25:50 269 2147483648 2549711360 2797215744 276921520 11.422 20 9 19 0 294247792 16783920 542352
07:26:52 302 2147483648 2558831472 2806341632 277669552 11.449 20 10 22 0 301868192 23581376 617264
07:27:53 255 2147483648 2548280864 2793824256 273515664 11.297 20 15 30 0 291113152 16570736 1026752
07:28:54 269 2147483648 2560200752 2804858880 273900000 11.311 20 11 20 1 304119024 29683808 535216
07:29:55 325 2147483648 2562864240 2810535936 278752384 11.489 20 14 28 0 305952352 26379056 820912
07:30:56 281 2147483648 2529675456 2758475776 265852160 11.015 20 5 10 0 274426704 8416288 158256
07:31:56 309 2147483648 2538295248 2779541504 270359632 11.181 20 10 20 0 280581568 9771824 450112
07:32:58 139 2147483648 2521322448 2761736192 263556144 10.931 20 2 4 0 265677264 2098464 22656
07:33:58 310 2147483648 2523861520 2759663616 264200304 10.955 20 14 28 0 269354016 4606960 546752
07:34:59 436 2147483648 2548736144 2796793856 268604688 11.117 20 6 12 0 292749344 23894400 250256
07:35:59 196 2147483648 2529649888 2783703040 268814064 11.125 20 10 20 0 274723440 5497152 412224
07:37:00 318 2147483648 2542329552 2778841088 262355248 10.886 20 14 27 1 279596096 16478448 762400
07:38:00 328 2147483648 2553802672 2798858240 267227632 11.066 20 8 15 1 297345632 29765344 352656
07:39:01 246 2147483648 2531704512 2776567808 268987744 11.131 20 10 20 0 275555984 6095632 472608
07:40:02 258 2147483648 2529963856 2765602816 262546240 10.893 20 10 20 0 272901328 9883792 471296
07:41:03 308 2147483648 2538519744 2778812416 268461984 11.112 20 12 24 0 282370304 13383952 524368
07:42:04 356 2147483648 2538562480 2775912448 264647456 10.971 20 13 26 0 281818080 16545072 625552
07:43:04 502 2147483648 2545335296 2783547392 264653424 10.971 20 9 18 0 288970624 23773344 543856
07:44:07 233 2147483648 2539128784 2783391744 269694608 11.157 20 9 18 0 282127888 12001776 431504
07:45:07 391 2147483648 2546535792 2793086976 268161984 11.101 20 10 19 1 290658272 22068960 427328
07:46:08 319 2147483648 2522530352 2757103616 258321248 10.737 20 10 20 0 265998320 7230640 446432
07:47:08 275 2147483648 2527445232 2767831040 266781216 11.050 20 11 21 2 271977776 4531728 664832
07:48:08 253 2147483648 2538897728 2786508800 268334576 11.107 20 14 27 1 280716752 11917936 464240
07:49:09 320 2147483648 2509808944 2740903936 240772112 10.081 19 11 22 0 249643968 8314560 557296
07:50:10 380 2147483648 2524833632 2755624960 259726416 10.789 20 10 20 0 267439760 7336016 377328

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 07:51:01 to 17-11-2026 07:51:01.

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          238848
MON$OLDEST_ACTIVE               238982
MON$OLDEST_SNAPSHOT             238982
MON$NEXT_TRANSACTION            238982
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 04:00:08.2590 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                        {CB2166AF-BEC2-42E6-9A39-F10BF7E818E5}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             615
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 07:50:33 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'

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