Generated by /opt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 35. 16.04.2026 08:26
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 32cdb01f987d4d7ea5582a2dc3adcc1f
Product UUID daf74ba4-8b91-44e6-be6a-d3de610736b0
AF_VSOCK CID 1
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.74+deb13+1-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 12y 2w 1d
Command: who -b
bootup_info system boot 2026-04-04 08:16
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 2194696 kB
MemAvailable 7461576 kB
Buffers 88356 kB
Cached 5329488 kB
SwapCached 16 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-fb40/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-fb40/oltp40_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-fb40.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_40.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=green
param=html_chart_color_memo_att, val=green
param=html_chart_color_memo_stm, val=green
param=html_chart_color_memo_trn, val=green
param=html_chart_color_perf_score, val=green
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=3400
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-fb40-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-fb40
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 

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-fb40/oltp40_qa-test-0001.performance_report.tmp

Test workload details

PREPARING QUERY FAILED: 

set sqlda_display on;
set planonly;
    set width working_mode 12;
    set width setting 32;
    set width val 30;
    --set list on;
    select 'WORKING_MODE' as setting_name, s.svalue as setting_value
    from settings s
    where s.working_mode = 'INIT' and s.mcode='WORKING_MODE'
    UNION ALL
    select s.mcode as setting, s.svalue as val
    from settings s
    join (
        select s.svalue as working_mode
        from settings s
        where s.working_mode = 'INIT' and s.mcode='WORKING_MODE'
         ) w on s.working_mode = w.working_mode;
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-fb40/make_html_table.tmp.sql
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database

Indexes for heavy-loaded tables

PREPARING QUERY FAILED: 

set sqlda_display on;
set planonly;
    set width tab_name 13;
    set width idx_name 31;
    set width idx_key 45;
    select * from z_qd_indices_ddl;
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-fb40/make_html_table.tmp.sql
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 55 minutes: 5272.44 854 289984
customer order: creation 404.05 86 22223
customer order: refuse 33.24 72 1828
order to supplier: creation 103.44 421 5689
order to supplier: removal 7.27 8018 400
invoice (draft): creation 102.69 567 5648
invoice (draft): removal 55.55 229 3055
invoice accept: apply 87.02 1677 4786
invoice accept: cancel 44.07 338 2424
customer reserve: creation 2437.38 50 134056
customer reserve: removal 1423.00 27 78265
realization accept: apply 186.62 63 10264
realization accept: cancel 84.25 35 4634
payment from customer: creation 133.62 68 7349
payment from customer: removal 12.87 31 708
payment to supplier: creation 112.33 58 6178
payment to supplier: removal 8.55 31 470
service: total inventory turnovers 6.56 3284 361
service: total monetary turnovers 27.00 48 1485
service: aggregate perf. data 2.91 1814 160
service: refresh index statistics 0.02 153 1

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 16-04-2026 08:26:28 to 16-04-2026 08:26:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7840
TEST_TIME 2 8683
TEST_TIME 3 8906
TEST_TIME 4 9450
TEST_TIME 5 9509
TEST_TIME 6 9840
TEST_TIME 7 10029
TEST_TIME 8 10175
TEST_TIME 9 10449
TEST_TIME 10 10600
TEST_TIME 11 10592
TEST_TIME 12 10790
TEST_TIME 13 10866
TEST_TIME 14 10898
TEST_TIME 15 10973
TEST_TIME 16 11072
TEST_TIME 17 11104
TEST_TIME 18 11097
TEST_TIME 19 11132
TEST_TIME 20 11219
TEST_TIME 21 11242
TEST_TIME 22 11258
TEST_TIME 23 11409
TEST_TIME 24 11386
TEST_TIME 25 11337
TEST_TIME 26 11154

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 16-04-2026 08:26:30 to 16-04-2026 08:26:32.

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 439601 439601 0 0.00 0 1146 4 0 0
doc_list_biud 439601 439601 0 0.00 0 3287 9 0 0
sp_add_invoice_to_stock 4786 4786 0 0.00 4 15538 1677 0 0
sp_cancel_adding_invoice 2424 2424 0 0.00 4 5778 338 0 0
sp_cancel_client_order 1828 1828 0 0.00 2 3304 72 0 0
sp_cancel_customer_reserve 78265 78265 0 0.00 1 1752 28 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 2 242 32 0 0
sp_cancel_pay_to_supplier 470 470 0 0.00 2 204 31 0 0
sp_cancel_supplier_invoice 3055 3055 0 0.00 1 1527 229 0 0
sp_cancel_supplier_order 400 400 0 0.00 9 59726 8019 0 0
sp_cancel_write_off 4634 4634 0 0.00 1 837 35 0 0
sp_client_order 22223 22223 0 0.00 3 1358 87 0 0
sp_customer_reserve 134056 134056 0 0.00 0 2990 50 0 0
sp_fill_shopping_cart 33560 33560 0 0.00 1 1874 29 0 0
sp_fill_shopping_cart_clo_res 134056 134056 0 0.00 0 1237 3 0 0
sp_get_clo_for_invoice 4786 4786 0 0.00 0 1268 34 0 0
sp_kill_cost_storno 8236 8236 0 0.00 0 531 16 0 0
sp_kill_qstorno_ret_qs2qd 164619 164619 0 0.00 0 1746 16 0 0
sp_kill_qty_storno 105656 105656 0 0.00 0 3287 37 0 0
sp_lock_selected_doc 20967 20967 0 0.00 0 144 3 0 0
sp_make_cost_storno 28577 28577 0 0.00 0 977 13 0 0
sp_multiply_rows_for_pdistr 28577 28577 0 0.00 0 962 19 0 0
sp_multiply_rows_for_qdistr 22223 22223 0 0.00 0 866 40 0 0
sp_pay_from_customer 7349 7349 0 0.00 2 1172 69 0 0
sp_pay_to_supplier 6178 6178 0 0.00 3 1179 58 0 0
sp_payment_common 13527 13527 0 0.00 1 1056 13 0 0
sp_qd_handle_on_cancel_clo 1828 1828 0 0.00 0 3287 57 0 0
sp_qd_handle_on_invoice_upd_sts 7210 7210 0 0.00 0 1609 125 0 0
sp_qd_handle_on_reserve_upd_sts 10264 10264 0 0.00 0 1071 22 0 0
sp_reserve_write_off 10264 10264 0 0.00 3 1075 64 0 0
sp_supplier_invoice 5648 5648 0 0.00 5 3776 567 0 0
sp_supplier_order 5689 5689 0 0.00 4 2999 422 0 0
srv_aggregate_perf_data 160 160 0 0.00 18 7062 1814 0 0
srv_fill_mon_cache_memory 25 25 0 0.00 3 2367 614 0 0
srv_find_qd_qs_mism 265276 265276 0 0.00 0 1070 2 0 0
srv_make_invnt_saldo 361 361 0 0.00 1 14565 3284 0 0
srv_make_money_saldo 1485 1485 0 0.00 0 617 48 0 0
srv_recalc_idx_stat 1 1 0 0.00 153 153 153 0 0
v_add_invoice_to_stock 9572 9572 0 0.00 0 484 1 0 0
v_all_customers 34458 34458 0 0.00 0 49 0 0 0
v_all_suppliers 26598 26598 0 0.00 0 60 0 0 0
v_all_wares 44446 44446 0 0.00 0 56 0 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 350 2 0 0
v_cancel_client_order 3656 3656 0 0.00 0 494 1 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 116 1 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 183 1 0 0
v_cancel_payment_to_supplier 940 940 0 0.00 0 189 1 0 0
v_cancel_supplier_invoice 758 758 0 0.00 0 35 1 0 0
v_cancel_supplier_order 800 800 0 0.00 0 192 1 0 0
v_cancel_write_off 2064 2064 0 0.00 0 166 1 0 0
v_max_id_clo_ord 5689 5689 0 0.00 0 85 1 0 0
v_max_id_clo_res 1092 1092 0 0.00 0 353 2 0 0
v_max_id_ord_sup 5648 5648 0 0.00 0 535 1 0 0
v_max_non_paid_invoice 4216 4216 0 0.00 0 365 2 0 0
v_max_non_paid_realizn 6938 6938 0 0.00 0 137 2 0 0
v_min_id_clo_ord 5689 5689 0 0.00 0 554 3 0 0
v_min_id_clo_res 1092 1092 0 0.00 0 580 4 0 0
v_min_id_ord_sup 5648 5648 0 0.00 0 1167 6 0 0
v_min_non_paid_invoice 6178 6178 0 0.00 0 1055 7 0 0
v_min_non_paid_realizn 7349 7349 0 0.00 0 922 9 0 0
v_our_firm 10810 10810 0 0.00 0 44 0 0 0
v_reserve_write_off 20528 20528 0 0.00 0 390 1 0 0
x_lock_depdocs_on_canc_invoice 5100 5100 0 0.00 0 1419 16 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 235 25 0 0
x_make_qstorno_1000_1200 5689 5689 0 0.00 1 2981 359 0 0
x_make_qstorno_1200_2000 5648 5648 0 0.00 1 3728 502 0 0
x_make_qstorno_2100_3300 134056 134056 0 0.00 0 2988 45 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 16-04-2026 08:26:33 to 16-04-2026 08:26:36.

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
08:01:02 2 3221225472 3461846256 3466764288 3209328 0.099 1 1 2 0 3306768 61664 35776
08:02:02 709 3221225472 3888833584 4030836736 394931136 10.921 35 20 45 1 403287664 5568576 2787952
08:03:03 606 3221225472 3844279072 3971268608 345933328 9.697 34 16 35 0 350060640 1981344 2145968
08:04:04 429 3221225472 3886646512 4029231104 389835040 10.795 35 12 24 0 398777264 7226080 1716144
08:05:05 602 3221225472 3865703168 4002181120 373336464 10.386 34 21 45 1 380137840 2901648 3899728
08:06:06 320 3221225472 3872660496 4012171264 380770160 10.571 35 16 33 0 387509168 3651872 3087136
08:07:06 951 3221225472 3891342944 4036984832 398039264 10.997 35 21 45 0 407545344 6147872 3358208
08:08:07 587 3221225472 3862528704 4002197504 369392704 10.287 35 24 48 1 376701424 3477184 3831536
08:09:08 2356 3221225472 3885512992 4026023936 381014704 10.577 35 20 43 0 399018592 13964160 4039728
08:10:11 1274 3221225472 3893911216 4040081408 395407840 10.933 35 16 33 1 406771600 8662592 2701168
08:11:13 464 3221225472 3884870912 4027060224 386973552 10.724 35 23 47 0 396598512 6069264 3555696
08:12:14 639 3221225472 3855173136 3995357184 357995328 10.002 34 16 37 0 367876400 6983056 2898016
08:13:15 573 3221225472 3883932320 4027510784 388490416 10.762 35 23 46 0 397198944 4710944 3997584
08:14:16 255 3221225472 3894564336 4038504448 392854448 10.870 35 19 38 0 405723056 9200992 3667616
08:15:17 246 3221225472 3887511408 4031918080 389920528 10.797 35 18 38 0 398139152 5202704 3015920
08:16:17 340 3221225472 3874837136 4020289536 374158384 10.406 35 11 23 0 387275520 11397632 1719504
08:17:18 334 3221225472 3881708464 4023222272 380093328 10.554 35 23 47 0 391641104 7348672 4199104
08:18:18 312 3221225472 3891259280 4037496832 386024624 10.701 35 16 32 0 402510784 13448656 3037504
08:19:20 515 3221225472 3882943216 4034166784 386843616 10.721 35 21 43 2 401855936 10224480 4787840
08:20:21 1619 3221225472 3875247152 4018266112 369023824 10.278 34 15 29 0 385632672 13844256 2764592
08:21:23 342 3221225472 3873476896 4018409472 377389696 10.487 35 16 32 0 386072112 5814080 2868336
08:22:24 568 3221225472 3899417248 4049207296 393813440 10.893 35 23 48 0 411941456 13973776 4154240
08:23:26 390 3221225472 3906738464 4054171648 392201360 10.854 35 12 26 0 417871184 23648464 2021360
08:24:26 438 3221225472 3892900704 4039712768 389786256 10.794 35 18 37 0 404128736 11426208 2916272
08:25:28 309 3221225472 3886589488 4034437120 383249056 10.632 35 11 23 0 399353872 14482880 1621936

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:08, from 16-04-2026 08:26:37 to 16-04-2026 08:26:45.

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 16-04-2026 08:26:45 to 16-04-2026 08:26:46.

Content of mon$database and FB version 


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-fb40.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          151847
MON$OLDEST_ACTIVE               152527
MON$OLDEST_SNAPSHOT             152527
MON$NEXT_TRANSACTION            152527
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-04-16 05:00:17.9930 GMT
MON$PAGES                       112030
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                        {B45BA5FA-F0A8-4ECD-878B-96435167807A}
MON$FILE_ID                     0108000000000000ed2b040000000000
MON$NEXT_ATTACHMENT             425
MON$NEXT_STATEMENT              54
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.7.3270 Firebird 4.0 5130575
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.7.3270 Firebird 4.0 5130575"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.7.3270 Firebird 4.0 5130575/tcp (qa-test)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.7.3270 Firebird 4.0 5130575/tcp (qa-test)/P17:C"
on disk structure version 13.0

Database statistics 


Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

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

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

16.04.26 08:26:47. All 3 logs in /var/tmp/logs.oltp-fb40 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-04-16 08:26:48 No severe PSQL-related problems occured
16.04.26 08:26:49. End of report.