Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.12.2022 21:14
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. 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. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. 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 mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 11264492 kB
MemAvailable 30168280 kB
Buffers 0 kB
Cached 20386172 kB
SwapCached 3440 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.11
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
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=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
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=init_buff, val=10000
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_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
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=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.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=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    CRASH DURING TEST RUN, 2022-12-25 21:14
DTS_END                         2022-12-25 21:14:27.4910
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          140728
ATT_ID                          575
EXC_UNIT                        9


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 50

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 120 minutes: 2918.21 26018 350185
customer order: creation 56.36 316 6763
customer order: refuse 5.09 393 611
order to supplier: creation 15.17 1598 1820
order to supplier: removal 1.08 226702 129
invoice (draft): creation 15.43 5459 1852
invoice (draft): removal 17.37 1715 2084
invoice accept: apply 13.21 21068 1585
invoice accept: cancel 15.85 1372 1902
customer reserve: creation 1131.34 218 135761
customer reserve: removal 1550.48 124 186057
realization accept: apply 27.50 206 3300
realization accept: cancel 26.57 174 3188
payment from customer: creation 19.67 128 2360
payment from customer: removal 1.92 112 230
payment to supplier: creation 15.98 139 1918
payment to supplier: removal 1.13 101 136
service: total inventory turnovers 1.38 1354 165
service: total monetary turnovers 2.45 54 294
service: aggregate perf. data 0.23 25505 28
service: refresh index statistics 0.02 233630 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-12-2022 21:14:54 to 25-12-2022 21:14:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1121
TEST_TIME 2 2898
TEST_TIME 3 4081
TEST_TIME 4 3851
TEST_TIME 5 4755
TEST_TIME 6 4557
TEST_TIME 7 5318
TEST_TIME 8 5555
TEST_TIME 9 5648
TEST_TIME 10 5800
TEST_TIME 11 6545
TEST_TIME 12 7057
TEST_TIME 13 7244
TEST_TIME 14 7534
TEST_TIME 15 7528
TEST_TIME 16 7825
TEST_TIME 17 7806
TEST_TIME 18 8178
TEST_TIME 19 8424
TEST_TIME 20 8477
TEST_TIME 21 8683
TEST_TIME 22 8370
TEST_TIME 23 8488
TEST_TIME 24 8374
TEST_TIME 25 8553
TEST_TIME 26 9028
TEST_TIME 27 9453
TEST_TIME 28 9334
TEST_TIME 29 9549
TEST_TIME 30 10470
TEST_TIME 31 10587
TEST_TIME 32 10532
TEST_TIME 33 10483
TEST_TIME 34 10306

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-12-2022 21:14:57 to 25-12-2022 21:15:00.

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 474508 474508 0 0.00 0 11290 8 0 0
doc_list_biud 474508 474508 0 0.00 0 20739 60 0 0
sp_add_invoice_to_stock 1625 1585 40 2.46 40 162325 21068 0 40
sp_cancel_adding_invoice 1902 1902 0 0.00 9 47158 1372 0 0
sp_cancel_client_order 611 611 0 0.00 5 2822 394 0 0
sp_cancel_customer_reserve 186057 186057 0 0.00 0 25071 124 0 0
sp_cancel_pay_from_customer 230 230 0 0.00 3 1203 112 0 0
sp_cancel_pay_to_supplier 136 136 0 0.00 4 1166 102 0 0
sp_cancel_supplier_invoice 2090 2084 6 0.28 3 15172 1716 0 6
sp_cancel_supplier_order 129 129 0 0.00 39 938133 226702 0 0
sp_cancel_write_off 3188 3188 0 0.00 1 4645 174 0 0
sp_client_order 6763 6763 0 0.00 4 21974 317 0 0
sp_customer_reserve 135761 135761 0 0.00 0 23427 218 0 0
sp_fill_shopping_cart 10422 10422 0 0.00 1 27055 47 0 0
sp_fill_shopping_cart_clo_res 135755 135755 0 0.00 0 21916 12 0 0
sp_get_clo_for_invoice 1579 1579 0 0.00 0 30763 298 0 0
sp_kill_cost_storno 5456 5456 0 0.00 0 4629 101 0 0
sp_kill_qstorno_ret_qs2qd 377515 377515 0 0.00 0 19855 68 0 0
sp_kill_qty_storno 198850 198850 0 0.00 0 20739 142 0 0
sp_lock_selected_doc 6779 6779 0 0.00 0 2130 2 0 0
sp_make_cost_storno 9157 9157 0 0.00 0 11289 54 0 0
sp_multiply_rows_for_pdistr 9157 9157 0 0.00 0 6102 41 0 0
sp_multiply_rows_for_qdistr 6763 6763 0 0.00 0 21959 155 0 0
sp_pay_from_customer 2360 2360 0 0.00 4 5336 128 0 0
sp_pay_to_supplier 1918 1918 0 0.00 5 11295 139 0 0
sp_payment_common 4278 4278 0 0.00 2 5825 26 0 0
sp_qd_handle_on_cancel_clo 611 611 0 0.00 1 2808 374 0 0
sp_qd_handle_on_invoice_upd_sts 3481 3481 0 0.00 0 12654 601 0 0
sp_qd_handle_on_reserve_upd_sts 3300 3300 0 0.00 0 6182 67 0 0
sp_reserve_write_off 3300 3300 0 0.00 7 6305 206 0 0
sp_supplier_invoice 1852 1852 0 0.00 9 83808 5459 0 0
sp_supplier_order 1820 1820 0 0.00 7 20287 1599 0 0
srv_aggregate_perf_data 28 28 0 0.00 1937 203214 25506 0 0
srv_fill_mon_cache_memory 25 25 0 0.00 1608 82541 16162 0 0
srv_find_qd_qs_mism 334361 334361 0 0.00 0 8988 6 0 0
srv_make_invnt_saldo 165 165 0 0.00 36 13909 1355 0 0
srv_make_money_saldo 294 294 0 0.00 0 828 54 0 0
srv_recalc_idx_stat 2 2 0 0.00 212173 255088 233631 0 0
t$perf-abend:sp_add_invoice_to_stock 40 40 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 1585 1585 0 0.00 0 3726 282 0 0
t$perf-norm:sp_cancel_adding_invoice 151 151 0 0.00 1 1920 155 0 0
t$perf-norm:sp_cancel_client_order 611 611 0 0.00 0 599 18 0 0
t$perf-norm:sp_cancel_customer_reserve 214 214 0 0.00 0 358 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 230 230 0 0.00 0 763 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 136 136 0 0.00 0 1744 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 131 131 0 0.00 0 717 34 0 0
t$perf-norm:sp_cancel_supplier_order 129 129 0 0.00 0 15594 3174 0 0
t$perf-norm:sp_cancel_write_off 298 298 0 0.00 0 640 7 0 0
t$perf-norm:sp_client_order 6763 6763 0 0.00 0 2179 28 0 0
t$perf-norm:sp_customer_reserve 285 285 0 0.00 0 231 6 0 0
t$perf-norm:sp_pay_from_customer 2360 2360 0 0.00 0 890 8 0 0
t$perf-norm:sp_pay_to_supplier 1918 1918 0 0.00 0 3325 15 0 0
t$perf-norm:sp_reserve_write_off 3300 3300 0 0.00 0 2180 15 0 0
t$perf-norm:sp_supplier_invoice 1852 1852 0 0.00 0 2482 27 0 0
t$perf-norm:sp_supplier_order 1820 1820 0 0.00 0 2165 32 0 0
t$perf-norm:srv_aggregate_perf_data 28 28 0 0.00 0 472 33 0 0
t$perf-norm:srv_fill_mon_cache_memory 25 25 0 0.00 0 8 1 0 0
t$perf-norm:srv_make_invnt_saldo 165 165 0 0.00 0 1200 56 0 0
t$perf-norm:srv_make_money_saldo 294 294 0 0.00 0 1116 32 0 0
t$perf-norm:srv_recalc_idx_stat 2 2 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 3238 3158 80 2.47 0 1590 21 0 80
v_all_customers 12098 12098 0 0.00 0 21 1 0 0
v_all_suppliers 9814 9814 0 0.00 0 25 1 0 0
v_all_wares 13526 13526 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 302 302 0 0.00 0 2378 15 0 0
v_cancel_client_order 1222 1222 0 0.00 0 636 4 0 0
v_cancel_customer_prepayment 460 460 0 0.00 0 181 5 0 0
v_cancel_customer_reserve 428 428 0 0.00 0 252 6 0 0
v_cancel_payment_to_supplier 272 272 0 0.00 0 115 4 0 0
v_cancel_supplier_invoice 274 262 12 4.37 0 536 22 0 12
v_cancel_supplier_order 258 258 0 0.00 0 274 9 0 0
v_cancel_write_off 596 596 0 0.00 0 428 19 0 0
v_max_id_clo_ord 1820 1820 0 0.00 0 619 2 0 0
v_max_id_clo_res 285 285 0 0.00 0 1429 27 0 0
v_max_id_ord_sup 1839 1839 0 0.00 0 691 2 0 0
v_max_non_paid_invoice 670 670 0 0.00 0 455 4 0 0
v_max_non_paid_realizn 1308 1308 0 0.00 0 4998 12 0 0
v_min_id_clo_ord 1820 1820 0 0.00 0 2567 10 0 0
v_min_id_clo_res 285 285 0 0.00 0 28 2 0 0
v_min_id_ord_sup 1839 1839 0 0.00 0 23321 20 0 0
v_min_non_paid_invoice 1918 1918 0 0.00 0 5819 14 0 0
v_min_non_paid_realizn 2360 2360 0 0.00 0 3883 16 0 0
v_our_firm 3532 3532 0 0.00 0 26 1 0 0
v_reserve_write_off 6600 6600 0 0.00 0 1841 6 0 0
x_lock_depdocs_on_canc_invoice 3855 3855 0 0.00 0 5041 196 0 0
x_lock_depdocs_on_canc_sup_ord 129 129 0 0.00 0 8010 611 0 0
x_make_qstorno_1000_1200 1820 1820 0 0.00 2 20262 1477 0 0
x_make_qstorno_1200_2000 1852 1852 0 0.00 4 78466 5263 0 0
x_make_qstorno_2100_3300 135761 135761 0 0.00 0 23426 201 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-12-2022 21:15:01 to 25-12-2022 21:15:05.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, 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        = metadata cache, 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: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

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
20:08:37 1 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
20:09:38 22503 8192000000 9898121104 10207825920 982980000 10.713 100 89 178 0 1011495600 5631152 22884448
20:11:03 11251 8192000000 9940994224 10261073920 1018986368 11.062 100 89 178 0 1050356416 8534496 22835552
20:12:28 12429 8192000000 9962186624 10293821440 1051358480 11.374 100 81 162 1 1080694624 9417472 19918672
20:13:44 10042 8192000000 10011486096 10353692672 1095121808 11.791 100 80 160 1 1125552640 10789312 19641520
20:14:56 9804 8192000000 10053559424 10405249024 1139710320 12.213 100 71 142 0 1168102112 11858816 16532976
20:16:09 6953 8192000000 10096134016 10457497600 1184253056 12.630 100 76 150 0 1212686528 11410032 17023440
20:17:18 2271 8192000000 10138117552 10505895936 1220181072 12.963 100 93 180 3 1255461344 14945904 20334368
20:18:23 1586 8192000000 10174304912 10550611968 1256619440 13.299 100 83 166 1 1289378416 14599680 18159296
20:19:26 761 8192000000 10197316464 10576400384 1284334832 13.553 100 93 188 2 1318231840 13704192 20192816
20:20:29 22354 8192000000 10188296848 10593431552 1297178400 13.670 100 44 86 1 1316530000 8902336 10449264
20:21:56 13296 8192000000 10188427888 10607808512 1311140320 13.796 100 20 40 0 1321765264 6415760 4209184
20:23:12 11279 8192000000 10209159680 10624204800 1323968912 13.913 100 15 30 1 1332953936 5632736 3352288
20:24:24 48082 8192000000 10211185376 10637279232 1328514400 13.954 100 26 50 0 1340268208 5284848 6468960
20:26:14 6429 8192000000 10223568256 10645983232 1334800448 14.011 100 15 30 1 1344083920 6297184 2986288
20:27:24 6292 8192000000 10235028416 10655756288 1338567456 14.044 100 27 52 0 1354716032 10672528 5476048
20:28:33 55422 8192000000 10215938320 10627670016 1308663312 13.774 98 37 70 1 1322261632 5282368 8315952
20:30:30 8989 8192000000 10167066096 10573303808 1265552560 13.381 98 27 53 3 1281427344 9637648 6237136
20:31:39 5652 8192000000 10142575120 10543190016 1217705504 12.940 96 22 44 0 1228279744 5621856 4952384
20:32:50 11675 8192000000 10140588400 10543861760 1252423520 13.260 100 20 40 0 1262443104 4998928 5020656
20:34:02 17276 8192000000 10151332064 10558791680 1254769536 13.282 99 39 78 0 1270907600 7228800 8909264
20:35:20 5244 8192000000 10180162720 10592661504 1285449568 13.563 100 37 75 0 1301056880 7879312 7728000
20:36:26 6802 8192000000 10193722256 10609532928 1305806000 13.748 100 24 48 0 1317428848 6118464 5504384
20:37:35 6582 8192000000 10196700528 10615353344 1310842496 13.794 100 17 34 1 1320448608 6013968 3592144
20:38:47 63327 8192000000 10239006496 10646917120 1332463168 13.989 100 38 74 0 1346461712 5700320 8298224
20:41:00 22182 8192000000 10253613200 10677497856 1358045856 14.220 100 34 68 0 1375044096 9321600 7676640
20:42:32 17565 8192000000 10287706416 10703671296 1374086144 14.364 100 49 96 0 1396400368 11595328 10718896
20:43:54 16217 8192000000 10281834384 10705567744 1382124048 14.436 100 28 56 1 1399493984 10452400 6917536
20:45:13 14142 8192000000 10297374336 10724274176 1390515248 14.510 100 45 90 0 1415782032 14425568 10841216
20:46:36 9843 8192000000 10311290080 10736914432 1398885520 14.585 100 47 94 0 1428546208 18732960 10927728
20:47:51 21158 8192000000 10321740784 10746089472 1397019872 14.568 100 50 97 2 1427573664 18844224 11709568
20:49:17 4188 8192000000 10333768320 10759393280 1411509424 14.697 100 50 96 1 1446826912 22518320 12799168
20:50:23 9192 8192000000 10328267200 10752389120 1403885488 14.630 100 54 108 0 1437289248 19787376 13616384
20:51:36 5707 8192000000 10327346240 10757111808 1408368000 14.669 100 49 98 2 1441604928 21400240 11836688
20:52:46 9838 8192000000 10305119152 10732986368 1369448624 14.322 98 38 75 0 1398172528 19680624 9043280
20:54:04 1606 8192000000 10318517664 10723672064 1372031488 14.345 100 84 168 0 1418998336 26315248 20651600
20:55:09 5752 8192000000 10299497520 10712231936 1365425936 14.286 99 64 128 1 1407546144 25957280 16162928
20:56:20 2696 8192000000 10273441024 10674421760 1320918880 13.885 97 63 126 1 1374497216 37762896 15815440
20:57:27 4630 8192000000 10324990304 10733715456 1365009136 14.282 98 70 135 0 1420851904 38393296 17449472
20:58:38 5020 8192000000 10334849984 10747944960 1385839984 14.469 100 51 100 2 1439079264 40071888 13167392
20:59:49 3081 8192000000 10337339584 10756419584 1391098128 14.516 100 50 100 1 1446658848 41983824 13576896
21:00:54 10188 8192000000 10341755712 10761076736 1388791552 14.495 100 41 81 0 1447163184 46640560 11731072
21:02:10 4321 8192000000 10346938800 10767384576 1393088128 14.533 100 54 104 0 1454266512 47667616 13510768
21:03:17 12667 8192000000 10338706192 10766123008 1377450352 14.394 99 42 84 0 1445138304 55933552 11754400
21:04:48 21476 8192000000 10318310272 10753839104 1372089584 14.346 100 27 54 0 1429626336 49394496 8142256
21:06:13 23613 8192000000 10296734800 10733961216 1347712960 14.127 100 21 41 1 1402470640 48610000 6147680
21:07:56 3522 8192000000 10335126464 10755608576 1367518992 14.305 100 70 140 1 1438421360 52026720 18875648
21:09:05 29541 8192000000 10282324656 10740346880 1360691008 14.244 99 9 16 1 1379803664 17155808 1956848
21:10:34 82540 8192000000 10314478800 10748289024 1360865680 14.245 98 5 10 0 1379428720 17636336 926704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:11, from 25-12-2022 21:15:07 to 25-12-2022 21:15:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 40 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-12-2022 21:15:19 to 25-12-2022 21:15:21.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          139420
MON$OLDEST_ACTIVE               140834
MON$OLDEST_SNAPSHOT             140834
MON$NEXT_TRANSACTION            140834
MON$PAGE_BUFFERS                1000000
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               2020-04-03 16:41:55.3470
MON$PAGES                       2002880
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.11.33650 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33650 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33650 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33650 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.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 ---
:52: 
:53: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:54:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:55:     Uncommitted work may have been lost.
:56:     Error writing data to the connection.
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:60:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:61:     Uncommitted work may have been lost.
:62:     Error writing data to the connection.
:63: 
:64: 
:65: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:66:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:67:     Uncommitted work may have been lost.
:68:     Error writing data to the connection.
:69: 
:70: 
:71: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:72:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:73:     Uncommitted work may have been lost.
:74:     Error writing data to the connection.
:75: 
:76: 
:77: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:78:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:79:     Uncommitted work may have been lost.
:80:     Error writing data to the connection.
:81: 
:82: 
:83: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:84:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:85:     Uncommitted work may have been lost.
:86:     Error writing data to the connection.
:87: 
:88: 
:89: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:90:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:91:     Uncommitted work may have been lost.
:92:     Error writing data to the connection.
:93: 
:94: 
:95: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:96:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:97:     Uncommitted work may have been lost.
:98:     Error writing data to the connection.
:99: 
:100: 
:101: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:102:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:103:     Uncommitted work may have been lost.
:104:     Error writing data to the connection.
:105: 
:106: 
:107: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:108:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:109:     Uncommitted work may have been lost.
:110:     Error writing data to the connection.
:111: 
:112: 
:113: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:114:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:115:     Uncommitted work may have been lost.
:116:     Error writing data to the connection.
:117: 
:118: 
:119: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:120:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:121:     Uncommitted work may have been lost.
:122:     Error writing data to the connection.
:123: 
:124: 
:125: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:126:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:127:     Uncommitted work may have been lost.
:128:     Error writing data to the connection.
:129: 
:130: 
:131: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:132:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:133:     Uncommitted work may have been lost.
:134:     Error writing data to the connection.
:135: 
:136: 
:137: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:138:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:139:     Uncommitted work may have been lost.
:140:     Error writing data to the connection.
:141: 
:142: 
:143: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:144:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:145:     Uncommitted work may have been lost.
:146:     Error writing data to the connection.
:147: 
:148: 
:149: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:150:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:151:     Uncommitted work may have been lost.
:152:     Error writing data to the connection.
:153: 
:154: 
:155: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:156:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:157:     Uncommitted work may have been lost.
:158:     Error writing data to the connection.
:159: 
:160: 
:161: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:162:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:163:     Uncommitted work may have been lost.
:164:     Error writing data to the connection.
:165: 
:166: 
:167: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:168:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:169:     Uncommitted work may have been lost.
:170:     Error writing data to the connection.
:171: 
:172: 
:173: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:174:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:175:     Uncommitted work may have been lost.
:176:     Error writing data to the connection.
:177: 
:178: 
:179: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:180:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:181:     Uncommitted work may have been lost.
:182:     Error writing data to the connection.
:183: 
:184: 
:185: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:186:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:187:     Uncommitted work may have been lost.
:188:     Error writing data to the connection.
:189: 
:190: 
:191: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:192:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:193:     Uncommitted work may have been lost.
:194:     Error writing data to the connection.
:195: 
:196: 
:197: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:198:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:199:     Uncommitted work may have been lost.
:200:     Error writing data to the connection.
:201: 
:202: 
:203: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:204:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:205:     Uncommitted work may have been lost.
:206:     Error writing data to the connection.
:207: 
:208: 
:209: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:210:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:211:     Uncommitted work may have been lost.
:212:     Error writing data to the connection.
:213: 
:214: 
:215: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:216:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:217:     Uncommitted work may have been lost.
:218:     Error writing data to the connection.
:219: 
:220: 
:221: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:222:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:223:     Uncommitted work may have been lost.
:224:     Error writing data to the connection.
:225: 
:226: 
:227: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:228:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:229:     Uncommitted work may have been lost.
:230:     Error writing data to the connection.
:231: 
:232: 
:233: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:234:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:235:     Uncommitted work may have been lost.
:236:     Error writing data to the connection.
:237: 
:238: 
:239: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:240:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:241:     Uncommitted work may have been lost.
:242:     Error writing data to the connection.
:243: 
:244: 
:245: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:246:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:247:     Uncommitted work may have been lost.
:248:     Error writing data to the connection.
:249: 
:250: 
:251: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:252:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:253:     Uncommitted work may have been lost.
:254:     Error writing data to the connection.
:255: 
:256: 
:257: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:258:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:259:     Uncommitted work may have been lost.
:260:     Error writing data to the connection.
:261: 
:262: 
:263: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:264:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:265:     Uncommitted work may have been lost.
:266:     Error writing data to the connection.
:267: 
:268: 
:269: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:270:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:271:     Uncommitted work may have been lost.
:272:     Error writing data to the connection.
:273: 
:274: 
:275: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:276:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:277:     Uncommitted work may have been lost.
:278:     Error writing data to the connection.
:279: 
:280: 
:281: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:282:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:283:     Uncommitted work may have been lost.
:284:     Error writing data to the connection.
:285: 
:286: 
:287: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:288:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:289:     Uncommitted work may have been lost.
:290:     Error writing data to the connection.
:291: 
:292: 
:293: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:294:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:295:     Uncommitted work may have been lost.
:296:     Error writing data to the connection.
:297: 
:298: 
:299: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:300:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:301:     Uncommitted work may have been lost.
:302:     Error writing data to the connection.
:303: 
:304: 
:305: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:306:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:307:     Uncommitted work may have been lost.
:308:     Error writing data to the connection.
:309: 
:310: 
:311: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:312:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:313:     Uncommitted work may have been lost.
:314:     Error writing data to the connection.
:315: 
:316: 
:317: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:318:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:319:     Uncommitted work may have been lost.
:320:     Error writing data to the connection.
:321: 
:322: 
:323: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:324:     /opt/fb30/bin/fbguard: /opt/fb30/bin/firebird terminated abnormally (-1)
:325: 
:326: 
:327: 
:328: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:329:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:330:     Uncommitted work may have been lost.
:331:     Error writing data to the connection.
:332: 
:333: 
:334: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:335:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:336:     Uncommitted work may have been lost.
:337:     Error writing data to the connection.
:338: 
:339: 
:340: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:341:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:342:     Uncommitted work may have been lost.
:343:     Error writing data to the connection.
:344: 
:345: 
:346: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:347:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:348:     Uncommitted work may have been lost.
:349:     Error writing data to the connection.
:350: 
:351: 
:352: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:353:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:354:     Uncommitted work may have been lost.
:355:     Error writing data to the connection.
:356: 
:357: 
:358: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:359:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:360:     Uncommitted work may have been lost.
:361:     Error writing data to the connection.
:362: 
:363: 
:364: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:365:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:366:     Uncommitted work may have been lost.
:367:     Error writing data to the connection.
:368: 
:369: 
:370: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:371:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:372:     Uncommitted work may have been lost.
:373:     Error writing data to the connection.
:374: 
:375: 
:376: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:377:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:378:     Uncommitted work may have been lost.
:379:     Error writing data to the connection.
:380: 
:381: 
:382: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:383:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:384:     Uncommitted work may have been lost.
:385:     Error writing data to the connection.
:386: 
:387: 
:388: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:389:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:390:     Uncommitted work may have been lost.
:391:     Error writing data to the connection.
:392: 
:393: 
:394: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:395:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:396:     Uncommitted work may have been lost.
:397:     Error writing data to the connection.
:398: 
:399: 
:400: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:401:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:402:     Uncommitted work may have been lost.
:403:     Error writing data to the connection.
:404: 
:405: 
:406: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:407:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:408:     Uncommitted work may have been lost.
:409:     Error writing data to the connection.
:410: 
:411: 
:412: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:413:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:414:     Uncommitted work may have been lost.
:415:     Error writing data to the connection.
:416: 
:417: 
:418: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:419:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:420:     Uncommitted work may have been lost.
:421:     Error writing data to the connection.
:422: 
:423: 
:424: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:425:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:426:     Uncommitted work may have been lost.
:427:     Error writing data to the connection.
:428: 
:429: 
:430: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:431:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:432:     Uncommitted work may have been lost.
:433:     Error writing data to the connection.
:434: 
:435: 
:436: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:437:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:438:     Uncommitted work may have been lost.
:439:     Error writing data to the connection.
:440: 
:441: 
:442: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:443:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:444:     Uncommitted work may have been lost.
:445:     Error writing data to the connection.
:446: 
:447: 
:448: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:449:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:450:     Uncommitted work may have been lost.
:451:     Error writing data to the connection.
:452: 
:453: 
:454: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:455:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:456:     Uncommitted work may have been lost.
:457:     Error writing data to the connection.
:458: 
:459: 
:460: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:461:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:462:     Uncommitted work may have been lost.
:463:     Error writing data to the connection.
:464: 
:465: 
:466: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:467:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:468:     Uncommitted work may have been lost.
:469:     Error writing data to the connection.
:470: 
:471: 
:472: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:473:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:474:     Uncommitted work may have been lost.
:475:     Error writing data to the connection.
:476: 
:477: 
:478: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:479:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:480:     Uncommitted work may have been lost.
:481:     Error writing data to the connection.
:482: 
:483: 
:484: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:485:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:486:     Uncommitted work may have been lost.
:487:     Error writing data to the connection.
:488: 
:489: 
:490: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:491:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:492:     Uncommitted work may have been lost.
:493:     Error writing data to the connection.
:494: 
:495: 
:496: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:497:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:498:     Uncommitted work may have been lost.
:499:     Error writing data to the connection.
:500: 
:501: 
:502: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:503:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:504:     Uncommitted work may have been lost.
:505:     Error writing data to the connection.
:506: 
:507: 
:508: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:509:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:510:     Uncommitted work may have been lost.
:511:     Error writing data to the connection.
:512: 
:513: 
:514: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:515:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:516:     Uncommitted work may have been lost.
:517:     Error writing data to the connection.
:518: 
:519: 
:520: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:521:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:522:     Uncommitted work may have been lost.
:523:     Error writing data to the connection.
:524: 
:525: 
:526: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:527:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:528:     Uncommitted work may have been lost.
:529:     Error writing data to the connection.
:530: 
:531: 
:532: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:533:     /opt/fb30/bin/fbguard: guardian starting /opt/fb30/bin/firebird
:534: 
:535: 
:536: 
:537: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:538:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:539:     Uncommitted work may have been lost.
:540:     Error writing data to the connection.
:541: 
:542: 
:543: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:544:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:545:     Uncommitted work may have been lost.
:546:     Error writing data to the connection.
:547: 
:548: 
:549: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:550:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:551:     Uncommitted work may have been lost.
:552:     Error writing data to the connection.
:553: 
:554: 
:555: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:556:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:557:     Uncommitted work may have been lost.
:558:     Error writing data to the connection.
:559: 
:560: 
:561: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:562:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:563:     Uncommitted work may have been lost.
:564:     Error writing data to the connection.
:565: 
:566: 
:567: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:568:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:569:     Uncommitted work may have been lost.
:570:     Error writing data to the connection.
:571: 
:572: 
:573: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:574:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:575:     Uncommitted work may have been lost.
:576:     Error writing data to the connection.
:577: 
:578: 
:579: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:580:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:581:     Uncommitted work may have been lost.
:582:     Error writing data to the connection.
:583: 
:584: 
:585: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:586:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:587:     Uncommitted work may have been lost.
:588:     Error writing data to the connection.
:589: 
:590: 
:591: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:592:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:593:     Uncommitted work may have been lost.
:594:     Error writing data to the connection.
:595: 
:596: 
:597: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:598:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:599:     Uncommitted work may have been lost.
:600:     Error writing data to the connection.
:601: 
:602: 
:603: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:604:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:605:     Uncommitted work may have been lost.
:606:     Error writing data to the connection.
:607: 
:608: 
:609: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:610:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:611:     Uncommitted work may have been lost.
:612:     Error writing data to the connection.
:613: 
:614: 
:615: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:616:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:617:     Uncommitted work may have been lost.
:618:     Error writing data to the connection.
:619: 
:620: 
:621: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:622:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:623:     Uncommitted work may have been lost.
:624:     Error writing data to the connection.
:625: 
:626: 
:627: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:628:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:629:     Uncommitted work may have been lost.
:630:     Error writing data to the connection.
:631: 
:632: 
:633: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:634:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:635:     Uncommitted work may have been lost.
:636:     Error writing data to the connection.
:637: 
:638: 
:639: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:640:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:641:     Uncommitted work may have been lost.
:642:     Error writing data to the connection.
:643: 
:644: 
:645: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:646:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:647:     Uncommitted work may have been lost.
:648:     Error writing data to the connection.
:649: 
:650: 
:651: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:652:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:653:     Uncommitted work may have been lost.
:654:     Error writing data to the connection.
:655: 
:656: 
:657: mscs-test-161.budzdorov.ru    Sun Dec 25 21:14:17 2022
:658:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:659:     Uncommitted work may have been lost.
:660:     Error writing data to the connection.
:661: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

25.12.22 21:15:22. All 3 logs in /var/tmp/logs-oltp30 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
2022-12-25 21:15:25 No severe PSQL-related problems occured
25.12.22 21:15:26. End of report.