Generated by /opt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 35. 08.03.2026 21: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 qa-test
Icon name computer-vm
Chassis vm 🖴
Machine ID daf74ba48b9144e6be6ad3de610736b0
Boot ID 95c749186ea942f6924061c060972afb
Product UUID daf74ba4-8b91-44e6-be6a-d3de610736b0
AF_VSOCK CID 1
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.63+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial daf74ba4-8b91-44e6-be6a-d3de610736b0
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 11y 11month 1w
Command: who -b
bootup_info system boot 2026-01-13 01:14
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) Silver 4214R CPU @ 2.40GHz
CPU family 6
Model 85
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 7
BogoMIPS 4800.00
Virtualization VT-x
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 Unknown: Dependent on hypervisor status
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Not affected
Vulnerability Mds Not affected
Vulnerability Meltdown Not affected
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Mitigation; Enhanced IBRS
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; Enhanced / Automatic IBRS; IBPB conditional; PBRSB-eIBRS SW sequence; BHI SW loop, KVM SW loop
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Mitigation; TSX disabled
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 3232648 kB
MemAvailable 7510048 kB
Buffers 82860 kB
Cached 4334416 kB
SwapCached 632 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Firebird configuration

PREPARING QUERY FAILED: 

set sqlda_display on;
set planonly;
set width param_name 35;
set width param_value 40;
set width param_default 40;
set width param_source 20; -- 'firebird.conf' or 'databases.conf'
set term ^;
execute block returns(param_name varchar(255), param_value varchar(255), param_default varchar(255), "is set ?" varchar(8), param_source varchar(255)) as
begin
  if ( not exists(select * from rdb$relations r where r.rdb$relation_name=upper('rdb$config') ) ) then
    begin
        param_name = 'Too old FB 4.x is used.';
        param_value = 'You have to upgrade it.';
        param_default = 'at least to 4.0.0.2260';
        suspend;
    end
  else
    for
execute statement (
            q'{select 
            rdb$config_name param_name
            ,iif(trim(rdb$config_value)='', '[empty]',rdb$config_value) param_value
            ,iif(trim(rdb$config_default)='', '[empty]', rdb$config_default) param_default
            ,cast(iif(rdb$config_is_set, '[ X ]', '     ') as varchar(5)) as "is set ?"
            ,rdb$config_source param_source
          from rdb$config
          order by param_name }'
        )
        into param_name, param_value, param_default, "is set ?", param_source
    do
        suspend;
end
^
set term ;^
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Failed to establish a connection.
After line 0 in file /var/tmp/logs.oltp-hq50/make_html_table.tmp.sql
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database

Server and database settinfs 

Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Failed to establish a connection.
After line 0 in file /var/tmp/logs.oltp-hq50/oltp50_qa-test-0001.performance_report.tmp

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=qa-test
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=/opt/oltp-emul/data/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=55
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                    
DTS_END                         
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           
IP                              
TRN_ID                          
ATT_ID                          
EXC_UNIT

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 55 minutes: 13470.40 3932 740872
customer order: creation 746.04 64 41032
customer order: refuse 63.04 54 3467
order to supplier: creation 195.25 307 10739
order to supplier: removal 13.85 8566 762
invoice (draft): creation 195.04 491 10727
invoice (draft): removal 125.96 155 6928
invoice accept: apply 169.05 1673 9298
invoice accept: cancel 105.82 270 5820
customer reserve: creation 6372.38 38 350481
customer reserve: removal 4365.75 20 240116
realization accept: apply 357.05 47 19638
realization accept: cancel 187.64 29 10320
payment from customer: creation 254.35 45 13989
payment from customer: removal 24.71 26 1359
payment to supplier: creation 207.33 38 11403
payment to supplier: removal 14.33 25 788
service: total inventory turnovers 14.96 2433 823
service: total monetary turnovers 52.22 34 2872
service: aggregate perf. data 5.60 1461 308
service: refresh index statistics 0.04 62873 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 08-03-2026 21:51:45 to 08-03-2026 21:51:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9091
TEST_TIME 2 9188
TEST_TIME 3 10135
TEST_TIME 4 10528
TEST_TIME 5 10966
TEST_TIME 6 11161
TEST_TIME 7 11497
TEST_TIME 8 11745
TEST_TIME 9 11911
TEST_TIME 10 12254
TEST_TIME 11 12253
TEST_TIME 12 12381
TEST_TIME 13 12449
TEST_TIME 14 12521
TEST_TIME 15 12649
TEST_TIME 16 12714
TEST_TIME 17 12744
TEST_TIME 18 12909
TEST_TIME 19 12974
TEST_TIME 20 13013
TEST_TIME 21 13043
TEST_TIME 22 13187
TEST_TIME 23 13182
TEST_TIME 24 13298
TEST_TIME 25 13344
TEST_TIME 26 13381
TEST_TIME 27 13491
TEST_TIME 28 13524
TEST_TIME 29 13530
TEST_TIME 30 13544
TEST_TIME 31 13619
TEST_TIME 32 13695
TEST_TIME 33 13783
TEST_TIME 34 13819
TEST_TIME 35 13880
TEST_TIME 36 13942
TEST_TIME 37 13920
TEST_TIME 38 14083
TEST_TIME 39 14093
TEST_TIME 40 14157
TEST_TIME 41 14241
TEST_TIME 42 14290
TEST_TIME 43 14246
TEST_TIME 44 14284
TEST_TIME 45 14363
TEST_TIME 46 14393
TEST_TIME 47 14486
TEST_TIME 48 14523
TEST_TIME 49 14617
TEST_TIME 50 14633
TEST_TIME 51 14527

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:01, from 08-03-2026 21:51:47 to 08-03-2026 21:51:48.

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 1105698 1105698 0 0.00 0 2419 3 0 0
doc_list_biud 1105698 1105698 0 0.00 0 3849 7 0 0
sp_add_invoice_to_stock 9298 9298 0 0.00 4 18847 1674 0 0
sp_cancel_adding_invoice 5820 5820 0 0.00 2 8638 271 0 0
sp_cancel_client_order 3467 3467 0 0.00 2 2372 54 0 0
sp_cancel_customer_reserve 240116 240116 0 0.00 0 3850 20 0 0
sp_cancel_pay_from_customer 1359 1359 0 0.00 1 622 26 0 0
sp_cancel_pay_to_supplier 788 788 0 0.00 1 772 25 0 0
sp_cancel_supplier_invoice 6928 6928 0 0.00 1 2651 155 0 0
sp_cancel_supplier_order 762 762 0 0.00 3 45968 8567 0 0
sp_cancel_write_off 10320 10320 0 0.00 1 2805 29 0 0
sp_client_order 41032 41032 0 0.00 2 2774 65 0 0
sp_customer_reserve 350481 350481 0 0.00 0 6589 38 0 0
sp_fill_shopping_cart 62501 62501 0 0.00 0 4091 25 0 0
sp_fill_shopping_cart_clo_res 350478 350478 0 0.00 0 2374 3 0 0
sp_get_clo_for_invoice 9298 9298 0 0.00 0 2968 38 0 0
sp_kill_cost_storno 18287 18287 0 0.00 0 1947 13 0 0
sp_kill_qstorno_ret_qs2qd 498242 498242 0 0.00 0 3659 11 0 0
sp_kill_qty_storno 296349 296349 0 0.00 0 3849 25 0 0
sp_lock_selected_doc 40039 40039 0 0.00 0 842 2 0 0
sp_make_cost_storno 54328 54328 0 0.00 0 2405 9 0 0
sp_multiply_rows_for_pdistr 54328 54328 0 0.00 0 1520 15 0 0
sp_multiply_rows_for_qdistr 41032 41032 0 0.00 0 2730 30 0 0
sp_pay_from_customer 13989 13989 0 0.00 2 1832 46 0 0
sp_pay_to_supplier 11403 11403 0 0.00 1 1598 39 0 0
sp_payment_common 25392 25392 0 0.00 0 1755 7 0 0
sp_qd_handle_on_cancel_clo 3467 3467 0 0.00 0 2359 42 0 0
sp_qd_handle_on_invoice_upd_sts 15118 15118 0 0.00 0 3769 100 0 0
sp_qd_handle_on_reserve_upd_sts 19638 19638 0 0.00 0 1983 18 0 0
sp_reserve_write_off 19638 19638 0 0.00 2 2039 48 0 0
sp_supplier_invoice 10727 10727 0 0.00 3 8187 491 0 0
sp_supplier_order 10739 10739 0 0.00 3 4423 307 0 0
srv_aggregate_perf_data 308 308 0 0.00 41 8319 1462 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 4 1512 575 0 0
srv_find_qd_qs_mism 687254 687254 0 0.00 0 1664 1 0 0
srv_make_invnt_saldo 823 823 0 0.00 0 11115 2434 0 0
srv_make_money_saldo 2872 2872 0 0.00 0 459 35 0 0
srv_recalc_idx_stat 2 2 0 0.00 16460 109286 62873 0 0
v_add_invoice_to_stock 18596 18596 0 0.00 0 735 2 0 0
v_all_customers 63040 63040 0 0.00 0 255 0 0 0
v_all_suppliers 50992 50992 0 0.00 0 361 0 0 0
v_all_wares 82064 82064 0 0.00 0 294 0 0 0
v_cancel_adding_invoice 1668 1668 0 0.00 0 331 2 0 0
v_cancel_client_order 6934 6934 0 0.00 0 878 1 0 0
v_cancel_customer_prepayment 2718 2718 0 0.00 0 458 2 0 0
v_cancel_customer_reserve 2526 2526 0 0.00 0 311 1 0 0
v_cancel_payment_to_supplier 1576 1576 0 0.00 0 432 1 0 0
v_cancel_supplier_invoice 1382 1382 0 0.00 0 305 2 0 0
v_cancel_supplier_order 1524 1524 0 0.00 0 373 1 0 0
v_cancel_write_off 3878 3878 0 0.00 0 732 2 0 0
v_max_id_avl_res 3 3 0 0.00 0 1 0 0 0
v_max_id_clo_ord 10739 10739 0 0.00 0 523 1 0 0
v_max_id_clo_res 1979 1979 0 0.00 0 277 2 0 0
v_max_id_ord_sup 10727 10727 0 0.00 0 1807 3 0 0
v_max_non_paid_invoice 7373 7373 0 0.00 0 79 1 0 0
v_max_non_paid_realizn 13271 13271 0 0.00 0 658 1 0 0
v_min_id_avl_res 3 3 0 0.00 1 8 4 0 0
v_min_id_clo_ord 10739 10739 0 0.00 0 1058 3 0 0
v_min_id_clo_res 1982 1982 0 0.00 0 1272 7 0 0
v_min_id_ord_sup 10727 10727 0 0.00 0 1772 7 0 0
v_min_non_paid_invoice 11403 11403 0 0.00 0 797 2 0 0
v_min_non_paid_realizn 13989 13989 0 0.00 0 808 3 0 0
v_our_firm 20466 20466 0 0.00 0 330 0 0 0
v_reserve_write_off 39276 39276 0 0.00 0 728 1 0 0
x_lock_depdocs_on_canc_invoice 12057 12057 0 0.00 0 1962 16 0 0
x_lock_depdocs_on_canc_sup_ord 762 762 0 0.00 0 369 21 0 0
x_make_qstorno_1000_1200 10739 10739 0 0.00 1 4056 253 0 0
x_make_qstorno_1200_2000 10727 10727 0 0.00 1 6573 428 0 0
x_make_qstorno_2100_3300 350481 350481 0 0.00 0 6587 34 0 0

Completed "Performance in DETAILS". Done for 00:00:02, from 08-03-2026 21:51:49 to 08-03-2026 21:51:51.

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: 393216 for all connections, with total size: 3221225472
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
21:00:44 4 3221225472 3377281024 3379736576 4117696 0.127 1 1 2 0 4186752 60512 8544
21:01:47 472 3221225472 3815415280 4200775680 432048640 11.826 35 26 53 0 435208528 2240784 919104
21:02:48 633 3221225472 3874533216 4311146496 487229072 13.138 35 17 34 0 489926304 2071952 625280
21:03:50 440 3221225472 3874612144 4346945536 493613424 13.287 35 16 32 0 495948672 1633616 701632
21:04:51 453 3221225472 3863289344 4288032768 477233744 12.903 35 28 46 5 481544528 3277872 1032912
21:05:52 295 3221225472 3862777280 4303335424 477764160 12.916 35 24 49 0 482757408 4031232 962016
21:06:52 534 3221225472 3834729968 4232531968 450837760 12.277 34 17 34 0 454303552 2784768 681024
21:07:54 457 3221225472 3872348704 4311339008 486070224 13.111 35 16 32 0 492683104 5972208 640672
21:08:54 479 3221225472 3857446384 4282486784 472323248 12.787 35 18 37 0 475948320 2850512 774560
21:09:55 562 3221225472 3860399136 4268789760 467773264 12.680 35 22 42 1 478213552 9641072 799216
21:10:56 512 3221225472 3869347360 4301115392 477868640 12.918 35 19 36 0 484513184 5895872 748672
21:11:57 545 3221225472 3875401984 4311121920 478635872 12.936 35 24 48 0 491175712 11532912 1006928
21:12:58 593 3221225472 3857174752 4274737152 466678160 12.654 35 12 26 0 473960000 6758672 523168
21:13:59 592 3221225472 3867983680 4308742144 480110192 12.971 35 15 29 0 486034624 5398304 526128
21:15:01 448 3221225472 3867038608 4305174528 476245504 12.880 35 15 28 0 485206544 8424256 536784
21:16:02 474 3221225472 3851022608 4259115008 459911232 12.493 35 20 40 0 467258672 6574320 773120
21:17:02 591 3221225472 3859199328 4289318912 473067440 12.805 35 23 44 2 476890704 2974768 848496
21:18:04 450 3221225472 3876068944 4313022464 477093312 12.900 35 22 44 0 493001712 14923456 984944
21:19:04 638 3221225472 3850541264 4274470912 460628800 12.510 35 15 28 0 466943664 5753104 561760
21:20:06 389 3221225472 3872166544 4303093760 477614432 12.912 35 24 48 0 489883488 11166304 1102752
21:21:06 351 3221225472 3869512464 4296671232 475562096 12.864 35 18 37 0 488805712 12446880 796736
21:22:07 530 3221225472 3887533040 4320440320 480069344 12.970 35 18 36 0 504201392 23352576 779472
21:23:08 574 3221225472 3863607424 4279197696 462008752 12.543 35 19 38 0 480851760 17970976 872032
21:24:09 732 3221225472 3867345232 4299964416 465431920 12.624 34 18 36 1 481209184 14945056 832208
21:25:11 575 3221225472 3864644752 4299538432 474733200 12.844 35 10 19 0 480981136 5894016 353920
21:26:12 1512 3221225472 3864227520 4291612672 468280384 12.692 35 11 22 0 479530832 10681136 569312
21:27:14 790 3221225472 3876752480 4310859776 476141680 12.877 35 13 26 0 491804768 15082608 580480
21:28:15 334 3221225472 3867750304 4296572928 473029184 12.804 35 21 43 0 483843424 9956608 857632
21:29:15 412 3221225472 3858094432 4281667584 468110256 12.688 35 19 38 1 474706992 5807552 789184
21:30:16 559 3221225472 3809540896 4176666624 416507456 11.449 35 18 36 0 426185680 8963984 714240
21:31:18 475 3221225472 3902078848 4336668672 490511408 13.215 35 16 32 0 518816240 27501440 803392
21:32:19 630 3221225472 3885947312 4318326784 479787952 12.963 35 19 37 0 501144752 20488752 868048
21:33:20 623 3221225472 3873939696 4300103680 473657136 12.819 35 22 44 1 487954736 13374928 922672
21:34:22 515 3221225472 3876080496 4309856256 477305712 12.905 35 18 35 0 492117872 14030720 781440
21:35:23 769 3221225472 3881806976 4318404608 479090480 12.947 35 17 34 0 498913120 19031824 790816
21:36:25 998 3221225472 3872563888 4300759040 472936416 12.802 35 9 18 0 488717248 15207424 573408
21:37:26 1014 3221225472 3866224336 4292894720 468149008 12.689 35 10 19 0 481919680 13387360 383312
21:38:28 501 3221225472 3877699920 4321439744 474520128 12.839 35 8 16 0 494009776 19093488 396160
21:39:29 531 3221225472 3855498512 4280057856 459244272 12.477 34 12 24 0 469731664 10062864 424528
21:40:29 424 3221225472 3873222128 4305227776 474868912 12.847 35 20 40 0 488345216 12598976 877328
21:41:30 601 3221225472 3875486640 4312489984 475063744 12.852 35 19 36 2 490349472 14554880 730848
21:42:31 602 3221225472 3881624096 4308852736 475697712 12.867 35 22 45 0 498036352 21313424 1025216
21:43:32 449 3221225472 3863329408 4297011200 474435424 12.837 35 25 47 2 479982128 4563040 983664
21:44:34 507 3221225472 3859338800 4286025728 464144928 12.594 35 10 19 1 469843824 5379936 318960
21:45:35 1505 3221225472 3882958224 4329074688 477209680 12.903 35 12 24 0 509259552 31475824 574048
21:46:37 342 3221225472 3870458704 4291645440 465973248 12.637 35 25 49 0 485891872 18781120 1137504
21:47:38 525 3221225472 3884621232 4318113792 477421936 12.908 35 15 30 0 501056272 22902976 731360
21:48:40 549 3221225472 3873424528 4308381696 473919952 12.825 35 12 24 0 486751616 12303488 528176
21:49:42 517 3221225472 3861694864 4289216512 467493040 12.673 35 21 40 0 478255680 9566816 1195824
21:50:43 503 3221225472 3880304880 4315951104 475369328 12.859 35 18 35 0 495373952 19118512 886112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:09, from 08-03-2026 21:51:52 to 08-03-2026 21:52:01.

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 08-03-2026 21:52:01 to 08-03-2026 21:52:02.

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          287679
MON$OLDEST_ACTIVE               288486
MON$OLDEST_SNAPSHOT             288486
MON$NEXT_TRANSACTION            288486
MON$PAGE_BUFFERS                393216
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-03-08 21:00:17.9810 GMT
MON$PAGES                       218790
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                        {D896546C-36AE-4AD1-A18B-7CE18D5F9B40}
MON$FILE_ID                     0108000000000000f029040000000000
MON$NEXT_ATTACHMENT             676
MON$NEXT_STATEMENT              512
MON$REPLICA_MODE                0


ISQL Version: LI-V5.0.4.1773 Firebird 5.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V5.0.4.1773 Firebird 5.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V5.0.4.1773 Firebird 5.0 HQbird/tcp (qa-test)/P19:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V5.0.4.1773 Firebird 5.0 HQbird/tcp (qa-test)/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: qa-test    Sun Mar  8 21:51:38 2026
:8:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:9:     Uncommitted work may have been lost.
:10:     Error writing data to the connection.
:11: 
:12: 
:13: qa-test    Sun Mar  8 21:51:38 2026
:14:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:15:     Uncommitted work may have been lost.
:16:     Error writing data to the connection.
:17: 
:18: 
:19: qa-test    Sun Mar  8 21:51:38 2026
:20:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:21:     Uncommitted work may have been lost.
:22:     Error writing data to the connection.
:23: 
:24: 
:25: qa-test    Sun Mar  8 21:51:38 2026
:26:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:27:     Uncommitted work may have been lost.
:28:     Error writing data to the connection.
:29: 
:30: 
:31: qa-test    Sun Mar  8 21:51:38 2026
:32:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:33:     Uncommitted work may have been lost.
:34:     Error writing data to the connection.
:35: 
:36: 
:37: qa-test    Sun Mar  8 21:51:38 2026
:38:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:39:     Uncommitted work may have been lost.
:40:     Error writing data to the connection.
:41: 
:42: 
:43: qa-test    Sun Mar  8 21:51:38 2026
:44:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:45:     Uncommitted work may have been lost.
:46:     Error writing data to the connection.
:47: 
:48: 
:49: qa-test    Sun Mar  8 21:51:38 2026
:50:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:51:     Uncommitted work may have been lost.
:52:     Error writing data to the connection.
:53: 
:54: 
:55: qa-test    Sun Mar  8 21:51:38 2026
:56:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:57:     Uncommitted work may have been lost.
:58:     Error writing data to the connection.
:59: 
:60: 
:61: qa-test    Sun Mar  8 21:51:38 2026
:62:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:63:     Uncommitted work may have been lost.
:64:     Error writing data to the connection.
:65: 
:66: 
:67: qa-test    Sun Mar  8 21:51:38 2026
:68:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:69:     Uncommitted work may have been lost.
:70:     Error writing data to the connection.
:71: 
:72: 
:73: qa-test    Sun Mar  8 21:51:38 2026
:74:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:75:     Uncommitted work may have been lost.
:76:     Error writing data to the connection.
:77: 
:78: 
:79: qa-test    Sun Mar  8 21:51:38 2026
:80:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:81:     Uncommitted work may have been lost.
:82:     Error writing data to the connection.
:83: 
:84: 
:85: qa-test    Sun Mar  8 21:51:38 2026
:86:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:87:     Uncommitted work may have been lost.
:88:     Error writing data to the connection.
:89: 
:90: 
:91: qa-test    Sun Mar  8 21:51:38 2026
:92:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:93:     Uncommitted work may have been lost.
:94:     Error writing data to the connection.
:95: 
:96: 
:97: qa-test    Sun Mar  8 21:51:38 2026
:98:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:99:     Uncommitted work may have been lost.
:100:     Error writing data to the connection.
:101: 
:102: 
:103: qa-test    Sun Mar  8 21:51:38 2026
:104:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:105:     Uncommitted work may have been lost.
:106:     Error writing data to the connection.
:107: 
:108: 
:109: qa-test    Sun Mar  8 21:51:38 2026
:110:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:111:     Uncommitted work may have been lost.
:112:     Error writing data to the connection.
:113: 
:114: 
:115: qa-test    Sun Mar  8 21:51:38 2026
:116:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:117:     Uncommitted work may have been lost.
:118:     Error writing data to the connection.
:119: 
:120: 
:121: qa-test    Sun Mar  8 21:51:38 2026
:122:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:123:     Uncommitted work may have been lost.
:124:     Error writing data to the connection.
:125: 
:126: 
:127: qa-test    Sun Mar  8 21:51:38 2026
:128:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:129:     Uncommitted work may have been lost.
:130:     Error writing data to the connection.
:131: 
:132: 
:133: qa-test    Sun Mar  8 21:51:38 2026
:134:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:135:     Uncommitted work may have been lost.
:136:     Error writing data to the connection.
:137: 
:138: 
:139: qa-test    Sun Mar  8 21:51:38 2026
:140:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:141:     Uncommitted work may have been lost.
:142:     Error writing data to the connection.
:143: 
:144: 
:145: qa-test    Sun Mar  8 21:51:38 2026
:146:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:147:     Uncommitted work may have been lost.
:148:     Error writing data to the connection.
:149: 
:150: 
:151: qa-test    Sun Mar  8 21:51:38 2026
:152:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:153:     Uncommitted work may have been lost.
:154:     Error writing data to the connection.
:155: 
:156: 
:157: qa-test    Sun Mar  8 21:51:38 2026
:158:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:159:     Uncommitted work may have been lost.
:160:     Error writing data to the connection.
:161: 
:162: 
:163: qa-test    Sun Mar  8 21:51:38 2026
:164:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:165:     Uncommitted work may have been lost.
:166:     Error writing data to the connection.
:167: 
:168: 
:169: qa-test    Sun Mar  8 21:51:38 2026
:170:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:171:     Uncommitted work may have been lost.
:172:     Error writing data to the connection.
:173: 
:174: 
:175: qa-test    Sun Mar  8 21:51:38 2026
:176:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:177:     Uncommitted work may have been lost.
:178:     Error writing data to the connection.
:179: 
:180: 
:181: qa-test    Sun Mar  8 21:51:38 2026
:182:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:183:     Uncommitted work may have been lost.
:184:     Error writing data to the connection.
:185: 
:186: 
:187: qa-test    Sun Mar  8 21:51:38 2026
:188:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:189:     Uncommitted work may have been lost.
:190:     Error writing data to the connection.
:191: 
:192: 
:193: qa-test    Sun Mar  8 21:51:38 2026
:194:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:195:     Uncommitted work may have been lost.
:196:     Error writing data to the connection.
:197: 
:198: 
:199: qa-test    Sun Mar  8 21:51:38 2026
:200:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:201:     Uncommitted work may have been lost.
:202:     Error writing data to the connection.
:203: 
:204: 
:205: qa-test    Sun Mar  8 21:51:38 2026
:206:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:207:     Uncommitted work may have been lost.
:208:     Error writing data to the connection.
:209: 
:210: 
:211: qa-test    Sun Mar  8 21:51:38 2026
:212:     REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
:213:     Uncommitted work may have been lost.
:214:     Error writing data to the connection.
:215: 
:216: 
:217: qa-test    Sun Mar  8 21:51:40 2026
:218:     /opt/hq50/bin/fbguard: /opt/hq50/bin/firebird terminated abnormally (-1)
:219: 
:220: 
:221: 
:222: qa-test    Sun Mar  8 21:51:40 2026
:223:     /opt/hq50/bin/fbguard: guardian starting /opt/hq50/bin/firebird
:224: 
:225: 
--- end of diff output ---

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

08.03.26 21:52:02. All 3 logs in /var/tmp/logs.oltp-hq50 are preserved, 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-03-08 21:52:03 No severe PSQL-related problems occured
08.03.26 21:52:03. End of report.