Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 06.11.2026 01: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 2bf17960cddd47aabfae2d899d34f677
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.113+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 5d
Command: who -b
bootup_info system boot 2026-10-26 18:11
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 8138024 kB
MemFree 2312260 kB
MemAvailable 7445928 kB
Buffers 89564 kB
Cached 5131164 kB
SwapCached 16 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-06 01:50:45
DTS_END                         2026-11-06 01:50:45.2160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/33576
TRN_ID                          208377
ATT_ID                          451
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: 13887.54 1029 694377
customer order: creation 612.54 44 30627
customer order: refuse 51.28 47 2564
order to supplier: creation 156.92 206 7846
order to supplier: removal 11.78 11415 589
invoice (draft): creation 158.22 355 7911
invoice (draft): removal 115.66 432 5783
invoice accept: apply 135.00 1359 6750
invoice accept: cancel 95.52 196 4776
customer reserve: creation 6674.62 23 333731
customer reserve: removal 4945.04 14 247252
realization accept: apply 286.56 32 14328
realization accept: cancel 166.06 19 8303
payment from customer: creation 205.50 31 10275
payment from customer: removal 19.96 16 998
payment to supplier: creation 167.18 25 8359
payment to supplier: removal 11.72 19 586
service: total inventory turnovers 20.08 1667 1004
service: total monetary turnovers 48.76 16 2438
service: aggregate perf. data 5.08 1499 254
service: refresh index statistics 0.06 3158 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 06-11-2026 01:51:00 to 06-11-2026 01:51:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8276
TEST_TIME 2 8970
TEST_TIME 3 9592
TEST_TIME 4 9824
TEST_TIME 5 10054
TEST_TIME 6 10187
TEST_TIME 7 10126
TEST_TIME 8 10363
TEST_TIME 9 10435
TEST_TIME 10 10346
TEST_TIME 11 10654
TEST_TIME 12 10710
TEST_TIME 13 11077
TEST_TIME 14 11161
TEST_TIME 15 11350
TEST_TIME 16 11460
TEST_TIME 17 11619
TEST_TIME 18 11639
TEST_TIME 19 11719
TEST_TIME 20 11778
TEST_TIME 21 11823
TEST_TIME 22 11782
TEST_TIME 23 11886
TEST_TIME 24 11707
TEST_TIME 25 11673
TEST_TIME 26 11768
TEST_TIME 27 11878
TEST_TIME 28 11985
TEST_TIME 29 12012
TEST_TIME 30 12057
TEST_TIME 31 12224
TEST_TIME 32 12333
TEST_TIME 33 12472
TEST_TIME 34 12628
TEST_TIME 35 12720
TEST_TIME 36 12844
TEST_TIME 37 12944
TEST_TIME 38 13079
TEST_TIME 39 13116
TEST_TIME 40 13302
TEST_TIME 41 13356
TEST_TIME 42 13459
TEST_TIME 43 13504
TEST_TIME 44 13612
TEST_TIME 45 13703
TEST_TIME 46 13766
TEST_TIME 47 13751
TEST_TIME 48 13852
TEST_TIME 49 13919
TEST_TIME 50 13888

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:01, from 06-11-2026 01:51:02 to 06-11-2026 01:51:03.

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 1022857 1022857 0 0.00 0 3474 2 0 0
doc_list_biud 1022857 1022857 0 0.00 0 5007 7 0 0
sp_add_invoice_to_stock 6750 6750 0 0.00 4 13784 1360 0 0
sp_cancel_adding_invoice 4776 4776 0 0.00 2 3374 196 0 0
sp_cancel_client_order 2564 2564 0 0.00 2 1271 47 0 0
sp_cancel_customer_reserve 247252 247252 0 0.00 1 5010 15 0 0
sp_cancel_pay_from_customer 998 998 0 0.00 1 441 17 0 0
sp_cancel_pay_to_supplier 586 586 0 0.00 1 1019 20 0 0
sp_cancel_supplier_invoice 5783 5783 0 0.00 1 3621 433 0 0
sp_cancel_supplier_order 589 589 0 0.00 8 78017 11416 0 0
sp_cancel_write_off 8303 8303 0 0.00 1 1057 19 0 0
sp_client_order 30627 30627 0 0.00 2 3527 45 0 0
sp_customer_reserve 333731 333731 0 0.00 0 3530 23 0 0
sp_fill_shopping_cart 46384 46384 0 0.00 0 2576 18 0 0
sp_fill_shopping_cart_clo_res 333731 333731 0 0.00 0 1260 2 0 0
sp_get_clo_for_invoice 6750 6750 0 0.00 0 1391 35 0 0
sp_kill_cost_storno 14663 14663 0 0.00 0 611 10 0 0
sp_kill_qstorno_ret_qs2qd 509179 509179 0 0.00 0 4996 11 0 0
sp_kill_qty_storno 290345 290345 0 0.00 0 5007 23 0 0
sp_lock_selected_doc 29368 29368 0 0.00 0 807 1 0 0
sp_make_cost_storno 39712 39712 0 0.00 0 936 7 0 0
sp_multiply_rows_for_pdistr 39712 39712 0 0.00 0 643 9 0 0
sp_multiply_rows_for_qdistr 30627 30627 0 0.00 0 1200 18 0 0
sp_pay_from_customer 10275 10275 0 0.00 2 999 31 0 0
sp_pay_to_supplier 8359 8359 0 0.00 2 726 26 0 0
sp_payment_common 18634 18634 0 0.00 0 441 6 0 0
sp_qd_handle_on_cancel_clo 2564 2564 0 0.00 0 1267 33 0 0
sp_qd_handle_on_invoice_upd_sts 11526 11526 0 0.00 0 1645 71 0 0
sp_qd_handle_on_reserve_upd_sts 14328 14328 0 0.00 0 3503 10 0 0
sp_reserve_write_off 14328 14328 0 0.00 2 3509 33 0 0
sp_supplier_invoice 7911 7911 0 0.00 4 6332 356 0 0
sp_supplier_order 7846 7846 0 0.00 3 4231 207 0 0
srv_aggregate_perf_data 254 254 0 0.00 25 6620 1500 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 5 1099 351 0 0
srv_find_qd_qs_mism 646492 646492 0 0.00 0 3473 1 0 0
srv_make_invnt_saldo 1004 1004 0 0.00 0 11190 1667 0 0
srv_make_money_saldo 2438 2438 0 0.00 0 326 16 0 0
srv_recalc_idx_stat 3 3 0 0.00 601 7537 3159 0 0
v_add_invoice_to_stock 13500 13500 0 0.00 0 646 2 0 0
v_all_customers 47134 47134 0 0.00 0 70 0 0 0
v_all_suppliers 38838 38838 0 0.00 0 84 0 0 0
v_all_wares 61254 61254 0 0.00 0 110 0 0 0
v_cancel_adding_invoice 1220 1220 0 0.00 0 189 2 0 0
v_cancel_client_order 5128 5128 0 0.00 0 688 2 0 0
v_cancel_customer_prepayment 1996 1996 0 0.00 0 222 1 0 0
v_cancel_customer_reserve 1948 1948 0 0.00 0 30 2 0 0
v_cancel_payment_to_supplier 1172 1172 0 0.00 0 479 2 0 0
v_cancel_supplier_invoice 1048 1048 0 0.00 0 54 2 0 0
v_cancel_supplier_order 1178 1178 0 0.00 0 254 2 0 0
v_cancel_write_off 2890 2890 0 0.00 0 743 2 0 0
v_max_id_clo_ord 7846 7846 0 0.00 0 521 1 0 0
v_max_id_clo_res 1432 1432 0 0.00 0 472 2 0 0
v_max_id_ord_sup 7911 7911 0 0.00 0 1083 2 0 0
v_max_non_paid_invoice 4697 4697 0 0.00 0 174 1 0 0
v_max_non_paid_realizn 9725 9725 0 0.00 0 182 1 0 0
v_min_id_clo_ord 7846 7846 0 0.00 0 649 2 0 0
v_min_id_clo_res 1432 1432 0 0.00 0 253 3 0 0
v_min_id_ord_sup 7911 7911 0 0.00 0 1240 4 0 0
v_min_non_paid_invoice 8359 8359 0 0.00 0 362 2 0 0
v_min_non_paid_realizn 10275 10275 0 0.00 0 351 2 0 0
v_our_firm 15220 15220 0 0.00 0 29 1 0 0
v_reserve_write_off 28656 28656 0 0.00 0 1127 1 0 0
x_lock_depdocs_on_canc_invoice 10035 10035 0 0.00 0 813 9 0 0
x_lock_depdocs_on_canc_sup_ord 589 589 0 0.00 0 1296 42 0 0
x_make_qstorno_1000_1200 7846 7846 0 0.00 1 3907 156 0 0
x_make_qstorno_1200_2000 7911 7911 0 0.00 1 6268 315 0 0
x_make_qstorno_2100_3300 333731 333731 0 0.00 0 3520 20 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2026 01:51:04 to 06-11-2026 01:51:08.

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
01:00:48 5 2147483648 2253215136 2255597568 4112736 0.191 1 1 2 0 4181792 60512 8544
01:01:50 297 2147483648 2525373184 2808172544 271437968 11.221 20 8 16 0 273004960 1206304 360688
01:02:51 207 2147483648 2528248752 2779107328 271841888 11.236 20 8 16 0 274567856 2297568 428400
01:03:52 393 2147483648 2524213488 2753150976 262210336 10.881 20 8 16 0 270633744 8004944 418464
01:04:53 263 2147483648 2526728864 2773848064 269457808 11.148 20 9 18 0 273796832 3927424 411600
01:05:54 215 2147483648 2531783200 2769850368 268305168 11.106 20 7 14 0 277758384 9156224 296992
01:06:54 204 2147483648 2527599824 2775076864 267437056 11.074 20 9 18 0 272010320 4176560 396704
01:07:55 452 2147483648 2517999776 2734055424 246381888 10.292 20 11 21 0 262312544 15467808 462848
01:08:56 376 2147483648 2529263424 2770653184 269326944 11.143 20 9 19 0 275878688 6110080 441664
01:09:57 536 2147483648 2526231664 2764570624 264688608 10.973 20 11 21 0 271352544 6216864 447072
01:10:58 373 2147483648 2547544496 2782588928 267867552 11.090 20 15 30 0 291535264 22933296 734416
01:11:59 288 2147483648 2542458736 2789949440 273174432 11.285 20 12 24 0 287689296 14031728 483136
01:12:59 315 2147483648 2555139168 2801020928 272903568 11.275 20 13 26 0 299478992 25927904 647520
01:14:00 358 2147483648 2527738256 2761256960 265428992 11.000 20 15 30 0 271849488 5781840 638656
01:15:01 324 2147483648 2540015024 2779279360 270342432 11.181 20 11 22 0 284092192 13306624 443136
01:16:02 282 2147483648 2527093312 2752557056 258870608 10.757 20 13 25 0 272128416 12790992 466816
01:17:02 212 2147483648 2536314048 2769682432 268468432 11.112 20 11 21 1 281545072 12620736 455904
01:18:03 433 2147483648 2543817952 2784018432 272262800 11.251 20 13 26 0 289707184 16772128 672256
01:19:05 598 2147483648 2550066304 2784108544 266685392 11.046 20 11 21 1 295463072 28053936 723744
01:20:06 510 2147483648 2544116528 2787500032 271504384 11.223 20 10 19 0 289886832 17938528 443920
01:21:07 354 2147483648 2537068048 2782208000 268278960 11.105 20 8 16 0 281904304 13338128 287216
01:22:08 470 2147483648 2549784640 2790535168 271245040 11.214 20 16 29 2 294664992 22722176 697776
01:23:09 330 2147483648 2536170128 2774700032 258565232 10.746 19 12 24 0 280105616 20974688 565696
01:24:10 1099 2147483648 2530954000 2775572480 269322048 11.143 20 7 14 1 274999888 5374960 302880
01:25:11 191 2147483648 2541540960 2784714752 272593776 11.263 20 12 23 0 285353328 12202576 556976
01:26:13 487 2147483648 2545030640 2812235776 276850384 11.419 20 14 28 0 286581648 9112160 619104
01:27:13 376 2147483648 2547585984 2795376640 273691184 11.304 20 9 18 0 292426528 18284640 450704
01:28:14 431 2147483648 2551740976 2792194048 266891488 11.054 20 11 22 0 299383168 31895968 595712
01:29:15 316 2147483648 2548827616 2793689088 274218800 11.323 20 13 26 0 292832800 18026304 587696
01:30:15 346 2147483648 2535035952 2768240640 271367936 11.218 20 15 28 1 279821856 7847856 606064
01:31:16 377 2147483648 2565696864 2818342912 278885584 11.493 20 13 26 0 308657136 29235872 535680
01:32:17 219 2147483648 2537535504 2785206272 271024512 11.206 20 12 24 0 281578960 10025360 529088
01:33:17 442 2147483648 2538328144 2770513920 260153856 10.805 20 11 22 0 278550400 18005296 391248
01:34:18 200 2147483648 2536677120 2772697088 262682672 10.898 20 8 16 0 280330528 17265040 382816
01:35:18 303 2147483648 2526677984 2761310208 259344672 10.775 20 11 21 0 270386400 10585376 456352
01:36:19 396 2147483648 2527799808 2761428992 256530448 10.670 20 8 16 0 272559824 15589472 439904
01:37:19 342 2147483648 2542779648 2799583232 271814624 11.235 20 8 16 0 284989344 12746752 427968
01:38:20 332 2147483648 2533014768 2779062272 267748976 11.085 20 11 22 0 276682256 8413568 519712
01:39:21 235 2147483648 2526072512 2765398016 264178304 10.954 20 8 16 0 271151328 6680848 292176
01:40:21 280 2147483648 2551693776 2793578496 266112896 11.025 20 10 20 0 295342112 28823824 405392
01:41:22 324 2147483648 2532743168 2785644544 266294800 11.032 20 6 11 0 276722560 10129424 298336
01:42:22 322 2147483648 2529010608 2774093824 268757008 11.122 20 12 24 2 272622816 3322192 543616
01:43:23 301 2147483648 2543339968 2791550976 270318848 11.180 20 12 23 1 286152528 15320032 513648
01:44:24 306 2147483648 2538247024 2778320896 262486896 10.891 20 15 30 0 282175104 18948800 739408
01:45:25 310 2147483648 2535251888 2776752128 267832944 11.088 20 14 28 0 276869856 8481648 555264
01:46:25 435 2147483648 2540020352 2784501760 269371104 11.145 20 12 23 0 284591376 14656880 563392
01:47:26 339 2147483648 2523366864 2763390976 261400576 10.851 20 6 12 0 267281920 5630064 251280
01:48:26 236 2147483648 2551470592 2792054784 264007888 10.947 20 7 14 0 295622336 31258992 355456
01:49:27 372 2147483648 2549610144 2794938368 269189952 11.138 20 11 23 0 293273024 23544496 538576
01:50:28 238 2147483648 2529364544 2771767296 264113808 10.951 20 9 18 1 273588080 9121392 352880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 06-11-2026 01:51:08 to 06-11-2026 01:51:18.

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 06-11-2026 01:51:19 to 06-11-2026 01:51:19.

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          207964
MON$OLDEST_ACTIVE               208512
MON$OLDEST_SNAPSHOT             208512
MON$NEXT_TRANSACTION            208512
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-05 22:00:10.2440 GMT
MON$PAGES                       171564
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                        {51CADFF1-D1CD-4AF8-B6BC-4028821D054C}
MON$FILE_ID                     01080000000000007aed070000000000
MON$NEXT_ATTACHMENT             565
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.5.1952 Firebird 5.0 7a88a7d
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d/tcp (test-0)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.5.1952 Firebird 5.0 7a88a7d/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    Fri Nov  6 01:50:46 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'

06.11.26 01:51:20. 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-06 01:51:20 No severe PSQL-related problems occured
06.11.26 01:51:21. End of report.