Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.01.2023 09:13
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 11197140 kB
MemAvailable 30478144 kB
Buffers 0 kB
Cached 20439752 kB
SwapCached 1804 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 4.0.3
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=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=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-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-oltp40
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, 2023-01-15 09:13
DTS_END                         2023-01-15 09:13:00.7730
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          128426
ATT_ID                          527
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: 2905.03 25468 348604
customer order: creation 61.52 557 7382
customer order: refuse 4.81 537 577
order to supplier: creation 15.92 1649 1910
order to supplier: removal 1.01 345634 121
invoice (draft): creation 16.47 3812 1976
invoice (draft): removal 14.91 1968 1789
invoice accept: apply 15.27 31992 1832
invoice accept: cancel 13.09 2468 1571
customer reserve: creation 1343.58 300 161229
customer reserve: removal 1323.98 204 158877
realization accept: apply 29.41 433 3529
realization accept: cancel 20.23 296 2427
payment from customer: creation 19.59 263 2351
payment from customer: removal 2.00 232 240
payment to supplier: creation 17.23 284 2067
payment to supplier: removal 1.12 210 134
service: total inventory turnovers 0.99 10139 119
service: total monetary turnovers 3.56 548 427
service: aggregate perf. data 0.38 13721 45
service: refresh index statistics 0.01 94115 1

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-01-2023 09:13:39 to 15-01-2023 09:13:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5886
TEST_TIME 2 5801
TEST_TIME 3 5010
TEST_TIME 4 4513
TEST_TIME 5 4604
TEST_TIME 6 5228
TEST_TIME 7 5481
TEST_TIME 8 6002
TEST_TIME 9 6115
TEST_TIME 10 6287
TEST_TIME 11 6352
TEST_TIME 12 6249
TEST_TIME 13 6390
TEST_TIME 14 6747
TEST_TIME 15 6865
TEST_TIME 16 7082
TEST_TIME 17 7370
TEST_TIME 18 7543
TEST_TIME 19 7617
TEST_TIME 20 7608
TEST_TIME 21 7665
TEST_TIME 22 8134
TEST_TIME 23 8440
TEST_TIME 24 8323
TEST_TIME 25 8532
TEST_TIME 26 8882
TEST_TIME 27 9003
TEST_TIME 28 9335
TEST_TIME 29 9844
TEST_TIME 30 10349
TEST_TIME 31 10329
TEST_TIME 32 10479
TEST_TIME 33 10748
TEST_TIME 34 10674

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 15-01-2023 09:13:43 to 15-01-2023 09:13:45.

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 493835 493835 0 0.00 0 9466 22 0 0
doc_list_biud 493831 493831 0 0.00 0 11082 75 0 0
sp_add_invoice_to_stock 1871 1832 39 2.08 176 183834 31993 0 39
sp_cancel_adding_invoice 1571 1571 0 0.00 28 90731 2468 0 0
sp_cancel_client_order 577 577 0 0.00 14 1978 537 0 0
sp_cancel_customer_reserve 158877 158877 0 0.00 1 6155 205 0 0
sp_cancel_pay_from_customer 240 240 0 0.00 16 1351 233 0 0
sp_cancel_pay_to_supplier 134 134 0 0.00 17 861 211 0 0
sp_cancel_supplier_invoice 1789 1789 0 0.00 27 11087 1969 0 0
sp_cancel_supplier_order 121 121 0 0.00 49 1359937 345634 0 0
sp_cancel_write_off 2427 2427 0 0.00 2 6754 296 0 0
sp_client_order 7382 7382 0 0.00 7 11576 558 0 0
sp_customer_reserve 161229 161229 0 0.00 1 16137 301 0 0
sp_fill_shopping_cart 11255 11255 0 0.00 1 2505 133 0 0
sp_fill_shopping_cart_clo_res 161209 161209 0 0.00 0 10262 18 0 0
sp_get_clo_for_invoice 1792 1792 0 0.00 1 2563 165 0 0
sp_kill_cost_storno 4372 4372 0 0.00 0 6619 153 0 0
sp_kill_qstorno_ret_qs2qd 322091 322091 0 0.00 0 11080 84 0 0
sp_kill_qty_storno 170683 170683 0 0.00 0 11081 197 0 0
sp_lock_selected_doc 7220 7220 0 0.00 0 521 9 0 0
sp_make_cost_storno 9739 9739 0 0.00 0 6808 115 0 0
sp_multiply_rows_for_pdistr 9739 9739 0 0.00 0 9332 60 0 0
sp_multiply_rows_for_qdistr 7382 7382 0 0.00 0 5291 174 0 0
sp_pay_from_customer 2351 2351 0 0.00 6 6744 263 0 0
sp_pay_to_supplier 2067 2067 0 0.00 6 9448 284 0 0
sp_payment_common 4418 4418 0 0.00 2 9238 81 0 0
sp_qd_handle_on_cancel_clo 577 577 0 0.00 3 1872 414 0 0
sp_qd_handle_on_invoice_upd_sts 3363 3363 0 0.00 1 7781 1054 0 0
sp_qd_handle_on_reserve_upd_sts 3529 3529 0 0.00 0 1109 74 0 0
sp_reserve_write_off 3529 3529 0 0.00 7 9628 433 0 0
sp_supplier_invoice 1976 1976 0 0.00 21 26794 3813 0 0
sp_supplier_order 1910 1910 0 0.00 18 20114 1649 0 0
srv_aggregate_perf_data 45 45 0 0.00 3508 34085 13722 0 0
srv_fill_mon_cache_memory 27 27 0 0.00 1003 41713 6310 0 0
srv_find_qd_qs_mism 329874 329874 0 0.00 0 7773 14 0 0
srv_make_invnt_saldo 119 119 0 0.00 119 68947 10140 0 0
srv_make_money_saldo 427 427 0 0.00 9 11024 548 0 0
srv_recalc_idx_stat 1 1 0 0.00 94115 94115 94115 0 0
t$perf-abend:sp_add_invoice_to_stock 39 39 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 1832 1832 0 0.00 3 10034 2095 0 0
t$perf-norm:sp_cancel_adding_invoice 123 123 0 0.00 1 6929 1165 0 0
t$perf-norm:sp_cancel_client_order 577 577 0 0.00 0 1008 53 0 0
t$perf-norm:sp_cancel_customer_reserve 224 224 0 0.00 0 2443 65 0 0
t$perf-norm:sp_cancel_pay_from_customer 240 240 0 0.00 0 944 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 134 134 0 0.00 0 1137 37 0 0
t$perf-norm:sp_cancel_supplier_invoice 149 149 0 0.00 0 780 66 0 0
t$perf-norm:sp_cancel_supplier_order 121 121 0 0.00 1 124654 20506 0 0
t$perf-norm:sp_cancel_write_off 332 332 0 0.00 0 555 34 0 0
t$perf-norm:sp_client_order 7382 7382 0 0.00 0 3278 72 0 0
t$perf-norm:sp_customer_reserve 322 322 0 0.00 0 704 30 0 0
t$perf-norm:sp_pay_from_customer 2351 2351 0 0.00 0 1106 33 0 0
t$perf-norm:sp_pay_to_supplier 2067 2067 0 0.00 0 1112 36 0 0
t$perf-norm:sp_reserve_write_off 3529 3529 0 0.00 0 1736 43 0 0
t$perf-norm:sp_supplier_invoice 1976 1976 0 0.00 0 1576 63 0 0
t$perf-norm:sp_supplier_order 1910 1910 0 0.00 0 1707 66 0 0
t$perf-norm:srv_aggregate_perf_data 45 45 0 0.00 0 195 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 27 27 0 0.00 0 90 9 0 0
t$perf-norm:srv_make_invnt_saldo 119 119 0 0.00 0 684 45 0 0
t$perf-norm:srv_make_money_saldo 427 427 0 0.00 0 356 8 0 0
t$perf-norm:srv_recalc_idx_stat 1 1 0 0.00 202 202 202 0 0
v_add_invoice_to_stock 3660 3582 78 2.13 0 2667 41 0 78
v_all_customers 13082 13082 0 0.00 0 65 8 0 0
v_all_suppliers 10562 10562 0 0.00 0 134 10 0 0
v_all_wares 14764 14764 0 0.00 0 133 9 0 0
v_cancel_adding_invoice 246 246 0 0.00 1 198 24 0 0
v_cancel_client_order 1154 1154 0 0.00 0 731 16 0 0
v_cancel_customer_prepayment 480 480 0 0.00 0 609 21 0 0
v_cancel_customer_reserve 448 448 0 0.00 1 154 21 0 0
v_cancel_payment_to_supplier 268 268 0 0.00 1 423 20 0 0
v_cancel_supplier_invoice 298 298 0 0.00 0 669 44 0 0
v_cancel_supplier_order 242 242 0 0.00 0 189 20 0 0
v_cancel_write_off 664 664 0 0.00 0 465 41 0 0
v_max_id_clo_ord 1909 1909 0 0.00 0 320 10 0 0
v_max_id_clo_res 322 322 0 0.00 0 236 14 0 0
v_max_id_ord_sup 1963 1963 0 0.00 0 531 11 0 0
v_max_non_paid_invoice 658 658 0 0.00 0 591 14 0 0
v_max_non_paid_realizn 1287 1287 0 0.00 0 772 14 0 0
v_min_id_clo_ord 1909 1909 0 0.00 0 941 14 0 0
v_min_id_clo_res 322 322 0 0.00 0 56 14 0 0
v_min_id_ord_sup 1963 1963 0 0.00 0 543 12 0 0
v_min_non_paid_invoice 2067 2067 0 0.00 1 8645 24 0 0
v_min_non_paid_realizn 2351 2351 0 0.00 1 6528 21 0 0
v_our_firm 3810 3810 0 0.00 0 130 10 0 0
v_reserve_write_off 7058 7058 0 0.00 0 596 16 0 0
x_lock_depdocs_on_canc_invoice 3211 3211 0 0.00 0 7819 239 0 0
x_lock_depdocs_on_canc_sup_ord 121 121 0 0.00 1 2916 558 0 0
x_make_qstorno_1000_1200 1910 1910 0 0.00 6 20031 1333 0 0
x_make_qstorno_1200_2000 1976 1976 0 0.00 11 26729 3518 0 0
x_make_qstorno_2100_3300 161228 161228 0 0.00 0 16126 256 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 15-01-2023 09:13:46 to 15-01-2023 09:13:51.

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
08:07:28 903 8192000000 8933232480 8990375936 33188272 0.403 7 5 8 0 33789200 253792 347136
08:08:30 16603 8192000000 9712465776 10010968064 796412224 8.860 100 80 160 0 822935536 7293584 19229728
08:09:49 22061 8192000000 9776531024 10083233792 848325296 9.383 100 93 184 0 882730384 12701888 21703200
08:11:15 16279 8192000000 9808245680 10124632064 872525760 9.625 100 90 180 0 914375840 21094656 20755424
08:12:39 9899 8192000000 9864562320 10195869696 915889328 10.055 100 80 161 0 973934448 40685856 17359264
08:13:51 3481 8192000000 9912146640 10251235328 949908912 10.390 100 94 183 1 1027225680 57928464 19388304
08:14:58 2283 8192000000 9965044848 10316636160 985607088 10.739 100 89 168 2 1082347504 79923552 16816864
08:16:03 1106 8192000000 9999520928 10355953664 1011031600 10.985 100 95 181 1 1113724336 84065488 18627248
08:17:06 1053 8192000000 10020928032 10389180416 1036812512 11.234 100 96 190 0 1136798336 81389072 18596752
08:18:08 888 8192000000 10023099376 10397671424 1058744448 11.444 100 92 176 1 1145682192 68729200 18208544
08:19:09 10887 8192000000 10018047056 10398453760 1065443456 11.509 100 81 154 0 1148554176 66942800 16167920
08:20:22 1115 8192000000 10045406416 10429231104 1077465840 11.623 100 97 183 2 1170869840 74250960 19153040
08:21:24 1193 8192000000 10070577328 10461114368 1085871968 11.703 100 97 185 1 1196636432 91566000 19198464
08:22:26 1406 8192000000 10023648000 10416283648 1088325648 11.727 100 80 148 0 1145838592 42549232 14963712
08:23:29 1216 8192000000 10076947888 10462904320 1095272496 11.793 100 95 181 2 1198121968 84680992 18168480
08:24:32 1104 8192000000 10065303392 10450898944 1092201616 11.764 100 93 173 0 1182817344 74657824 15957904
08:25:34 1124 8192000000 10069284304 10460430336 1095399840 11.794 100 97 190 0 1191355440 76434272 19521328
08:26:35 1192 8192000000 10068936432 10460459008 1100344736 11.841 100 96 179 3 1191872128 72634656 18892736
08:27:38 1222 8192000000 10089441040 10479058944 1101990464 11.857 100 93 177 2 1211737072 90560128 19186480
08:28:41 1099 8192000000 10057592512 10449039360 1105936656 11.894 100 90 168 1 1182013104 57857840 18218608
08:29:42 927 8192000000 10042711264 10428035072 1075522768 11.605 99 86 159 2 1164919024 72845632 16550624
08:30:44 1212 8192000000 10030577008 10410405888 1063459360 11.490 100 97 184 2 1152535584 70291888 18784336
08:31:46 1270 8192000000 10022248016 10399404032 1069923392 11.551 100 94 180 1 1142836864 53818192 19095280
08:32:48 1113 8192000000 10031277920 10407743488 1052539072 11.385 100 98 190 1 1149102816 78798848 17764896
08:33:50 1417 8192000000 9990694608 10365411328 1035387488 11.220 100 96 183 6 1114975360 59585536 20002336
08:34:52 3519 8192000000 9986895872 10367262720 1031810448 11.186 100 69 125 1 1104949328 60996400 12142480
08:35:58 1105 8192000000 9996572176 10370293760 1024821168 11.119 100 93 168 3 1120277664 76961408 18495088
08:36:59 1163 8192000000 10007831568 10385911808 1048407488 11.345 100 93 174 5 1133458832 65623088 19428256
08:38:07 20929 8192000000 10019713872 10404773888 1071551568 11.567 100 70 126 0 1139165040 55540720 12072752
08:39:33 2169 8192000000 10042869504 10423390208 1083345888 11.679 99 75 141 2 1164626464 67880112 13400464
08:40:47 2344 8192000000 10083952432 10471026688 1095475936 11.795 100 78 151 0 1200838768 90232480 15130352
08:41:53 11810 8192000000 10124575856 10519117824 1101814544 11.855 100 64 126 1 1249643616 133990240 13838832
08:43:10 3426 8192000000 10136718544 10528358400 1110024608 11.933 99 73 140 0 1261588096 136695888 14867600
08:44:18 2700 8192000000 10165789328 10575368192 1130078768 12.122 100 73 143 1 1280613872 134139152 16395952
08:45:25 2573 8192000000 10186336784 10596737024 1140563296 12.221 100 75 149 0 1300951184 143690624 16697264
08:46:33 1273 8192000000 10216680576 10612346880 1152984144 12.338 100 97 187 2 1327765712 153748720 21032848
08:47:40 1877 8192000000 10221355584 10627178496 1159036320 12.394 100 86 165 0 1340199088 162884432 18278336
08:48:45 1284 8192000000 10255171488 10660880384 1162576416 12.427 100 72 139 1 1366152720 187627056 15949248
08:49:51 2660 8192000000 10298356544 10701197312 1157050976 12.376 99 92 178 0 1401310368 223770432 20488960
08:50:57 1124 8192000000 10341670448 10747084800 1184654352 12.634 100 95 186 0 1457837296 250939200 22243744
08:52:01 992 8192000000 10367807808 10785112064 1194666864 12.727 100 98 196 0 1480585360 262972176 22946320
08:53:06 1481 8192000000 10399141744 10825949184 1202131904 12.796 100 95 182 1 1500723536 276884800 21706832
08:54:10 5895 8192000000 10394651136 10832474112 1191426144 12.697 99 64 121 1 1495466224 289336192 14703888
08:55:18 11035 8192000000 10410872208 10841083904 1202433584 12.799 100 53 102 2 1522300176 306600320 13266272
08:56:35 2798 8192000000 10465150048 10890702848 1186145360 12.647 100 77 154 0 1571242832 366797040 18300432
08:57:42 1149 8192000000 10450646432 10878439424 1181002512 12.600 100 93 178 0 1557832208 355922016 20907680
08:58:45 2649 8192000000 10434072320 10891988992 1161924352 12.421 99 80 158 1 1539934592 359375136 18635104
08:59:53 7114 8192000000 10430833616 10882166784 1177053232 12.563 100 60 116 0 1535043264 344056560 13933472
09:01:35 3085 8192000000 10490935776 10922352640 1172579872 12.521 100 65 125 1 1590620864 402465072 15575920
09:02:50 9299 8192000000 10415281072 10885431296 1133457488 12.154 99 47 94 0 1516415776 370714240 12244048
09:04:09 1029 8192000000 10405522112 10854326272 1147278688 12.284 100 66 124 1 1508687168 347082400 14326080
09:05:13 1264 8192000000 10356872000 10880942080 1147557184 12.287 100 89 174 1 1462885920 293811520 21517216
09:06:16 1109 8192000000 10343500848 10836332544 1149430096 12.304 100 97 192 1 1445998768 274189744 22378928
09:07:19 41712 8192000000 10268866208 10751995904 1151820896 12.327 100 32 64 0 1397863152 238017152 8025104
09:09:01 25428 8192000000 10230310704 10702688256 1152424368 12.332 100 21 38 1 1355480352 198273072 4782912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 15-01-2023 09:13:53 to 15-01-2023 09:14:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 39 v_add_invoice_to_stock 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-01-2023 09:14:06 to 15-01-2023 09:14:08.

Content of mon$database and FB version 

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          117163
MON$OLDEST_ACTIVE               128533
MON$OLDEST_SNAPSHOT             128533
MON$NEXT_TRANSACTION            128533
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-30 07:30:08.6030 GMT
MON$PAGES                       2054304
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                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             622
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.3.2890 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.3.2890 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.3.2890 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.3.2890 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/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 ---
:75: 
:76: mscs-test-161.budzdorov.ru    Sun Jan 15 09:06:26 2023
:77:     DEBUG_LCK_LIST: found not detached lock 0x0x7f9066a4b450 in deleting pool 0x0x7f907ed42a50
:78: 
:79: 
:80: mscs-test-161.budzdorov.ru    Sun Jan 15 09:06:26 2023
:81:     DEBUG_LCK_LIST: found not detached lock 0x0x7f9066a4e130 in deleting pool 0x0x7f907ed42a50
:82: 
:83: 
:84: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:85:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:86: 
:87: 
:88: 
:89: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:90:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:91: 
:92: 
:93: 
:94: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:95:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:96:     Uncommitted work may have been lost.
:97:     Error writing data to the connection.
:98: 
:99: 
:100: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:101:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:102:     Uncommitted work may have been lost.
:103:     Error writing data to the connection.
:104: 
:105: 
:106: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:107:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:108:     Uncommitted work may have been lost.
:109:     Error writing data to the connection.
:110: 
:111: 
:112: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:113:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:114:     Uncommitted work may have been lost.
:115:     Error writing data to the connection.
:116: 
:117: 
:118: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:119:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:120:     Uncommitted work may have been lost.
:121:     Error writing data to the connection.
:122: 
:123: 
:124: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:125:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:126:     Uncommitted work may have been lost.
:127:     Error writing data to the connection.
:128: 
:129: 
:130: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:131:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:132:     Uncommitted work may have been lost.
:133:     Error writing data to the connection.
:134: 
:135: 
:136: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:137:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:138:     Uncommitted work may have been lost.
:139:     Error writing data to the connection.
:140: 
:141: 
:142: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:143:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:144:     Uncommitted work may have been lost.
:145:     Error writing data to the connection.
:146: 
:147: 
:148: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:149:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:150:     Uncommitted work may have been lost.
:151:     Error writing data to the connection.
:152: 
:153: 
:154: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:155:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:156:     Uncommitted work may have been lost.
:157:     Error writing data to the connection.
:158: 
:159: 
:160: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:161:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:162:     Uncommitted work may have been lost.
:163:     Error writing data to the connection.
:164: 
:165: 
:166: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:167:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:168:     Uncommitted work may have been lost.
:169:     Error writing data to the connection.
:170: 
:171: 
:172: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:173:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:174:     Uncommitted work may have been lost.
:175:     Error writing data to the connection.
:176: 
:177: 
:178: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:179:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:180:     Uncommitted work may have been lost.
:181:     Error writing data to the connection.
:182: 
:183: 
:184: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:185:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:186:     Uncommitted work may have been lost.
:187:     Error writing data to the connection.
:188: 
:189: 
:190: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:191:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:192:     Uncommitted work may have been lost.
:193:     Error writing data to the connection.
:194: 
:195: 
:196: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:197:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:198:     Uncommitted work may have been lost.
:199:     Error writing data to the connection.
:200: 
:201: 
:202: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:203:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:204:     Uncommitted work may have been lost.
:205:     Error writing data to the connection.
:206: 
:207: 
:208: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:209:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:210:     Uncommitted work may have been lost.
:211:     Error writing data to the connection.
:212: 
:213: 
:214: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:215:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:216:     Uncommitted work may have been lost.
:217:     Error writing data to the connection.
:218: 
:219: 
:220: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:221:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:222:     Uncommitted work may have been lost.
:223:     Error writing data to the connection.
:224: 
:225: 
:226: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:227:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:228:     Uncommitted work may have been lost.
:229:     Error writing data to the connection.
:230: 
:231: 
:232: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:233:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:234:     Uncommitted work may have been lost.
:235:     Error writing data to the connection.
:236: 
:237: 
:238: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:239:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:240:     Uncommitted work may have been lost.
:241:     Error writing data to the connection.
:242: 
:243: 
:244: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:245:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:246:     Uncommitted work may have been lost.
:247:     Error writing data to the connection.
:248: 
:249: 
:250: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:251:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:252:     Uncommitted work may have been lost.
:253:     Error writing data to the connection.
:254: 
:255: 
:256: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:257:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:258:     Uncommitted work may have been lost.
:259:     Error writing data to the connection.
:260: 
:261: 
:262: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:263:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:264:     Uncommitted work may have been lost.
:265:     Error writing data to the connection.
:266: 
:267: 
:268: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:269:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:270:     Uncommitted work may have been lost.
:271:     Error writing data to the connection.
:272: 
:273: 
:274: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:275:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:276:     Uncommitted work may have been lost.
:277:     Error writing data to the connection.
:278: 
:279: 
:280: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:281:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:282:     Uncommitted work may have been lost.
:283:     Error writing data to the connection.
:284: 
:285: 
:286: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:287:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:288:     Uncommitted work may have been lost.
:289:     Error writing data to the connection.
:290: 
:291: 
:292: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:293:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:294:     Uncommitted work may have been lost.
:295:     Error writing data to the connection.
:296: 
:297: 
:298: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:299:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:300:     Uncommitted work may have been lost.
:301:     Error writing data to the connection.
:302: 
:303: 
:304: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:305:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:306:     Uncommitted work may have been lost.
:307:     Error writing data to the connection.
:308: 
:309: 
:310: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:311:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:312:     Uncommitted work may have been lost.
:313:     Error writing data to the connection.
:314: 
:315: 
:316: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:317:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:318:     Uncommitted work may have been lost.
:319:     Error writing data to the connection.
:320: 
:321: 
:322: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:323:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:324:     Uncommitted work may have been lost.
:325:     Error writing data to the connection.
:326: 
:327: 
:328: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
: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 Jan 15 09:12:55 2023
:533:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:534:     Uncommitted work may have been lost.
:535:     Error writing data to the connection.
:536: 
:537: 
:538: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:539:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:540:     Uncommitted work may have been lost.
:541:     Error writing data to the connection.
:542: 
:543: 
:544: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:545:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:546:     Uncommitted work may have been lost.
:547:     Error writing data to the connection.
:548: 
:549: 
:550: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:551:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:552:     Uncommitted work may have been lost.
:553:     Error writing data to the connection.
:554: 
:555: 
:556: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:557:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:558:     Uncommitted work may have been lost.
:559:     Error writing data to the connection.
:560: 
:561: 
:562: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:563:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:564:     Uncommitted work may have been lost.
:565:     Error writing data to the connection.
:566: 
:567: 
:568: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:569:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:570:     Uncommitted work may have been lost.
:571:     Error writing data to the connection.
:572: 
:573: 
:574: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:575:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:576:     Uncommitted work may have been lost.
:577:     Error writing data to the connection.
:578: 
:579: 
:580: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:581:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:582:     Uncommitted work may have been lost.
:583:     Error writing data to the connection.
:584: 
:585: 
:586: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:587:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:588:     Uncommitted work may have been lost.
:589:     Error writing data to the connection.
:590: 
:591: 
:592: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:593:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:594:     Uncommitted work may have been lost.
:595:     Error writing data to the connection.
:596: 
:597: 
:598: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:599:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:600:     Uncommitted work may have been lost.
:601:     Error writing data to the connection.
:602: 
:603: 
:604: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:605:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:606:     Uncommitted work may have been lost.
:607:     Error writing data to the connection.
:608: 
:609: 
:610: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:611:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:612:     Uncommitted work may have been lost.
:613:     Error writing data to the connection.
:614: 
:615: 
:616: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:617:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:618:     Uncommitted work may have been lost.
:619:     Error writing data to the connection.
:620: 
:621: 
:622: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:623:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:624:     Uncommitted work may have been lost.
:625:     Error writing data to the connection.
:626: 
:627: 
:628: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:629:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:630:     Uncommitted work may have been lost.
:631:     Error writing data to the connection.
:632: 
:633: 
:634: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:635:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:636:     Uncommitted work may have been lost.
:637:     Error writing data to the connection.
:638: 
:639: 
:640: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:641:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:642:     Uncommitted work may have been lost.
:643:     Error writing data to the connection.
:644: 
:645: 
:646: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:647:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:648:     Uncommitted work may have been lost.
:649:     Error writing data to the connection.
:650: 
:651: 
:652: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:653:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:654:     Uncommitted work may have been lost.
:655:     Error writing data to the connection.
:656: 
:657: 
:658: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:659:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:660:     Uncommitted work may have been lost.
:661:     Error writing data to the connection.
:662: 
:663: 
:664: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:665:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:666:     Uncommitted work may have been lost.
:667:     Error writing data to the connection.
:668: 
:669: 
:670: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:671:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:672:     Uncommitted work may have been lost.
:673:     Error writing data to the connection.
:674: 
:675: 
:676: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:677:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:678:     Uncommitted work may have been lost.
:679:     Error writing data to the connection.
:680: 
:681: 
:682: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:683:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:684:     Uncommitted work may have been lost.
:685:     Error writing data to the connection.
:686: 
:687: 
:688: mscs-test-161.budzdorov.ru    Sun Jan 15 09:12:55 2023
:689:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:690:     Uncommitted work may have been lost.
:691:     Error writing data to the connection.
:692: 
--- end of diff output ---

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

15.01.23 09:14:09. All 3 logs in /var/tmp/logs-oltp40 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
2023-01-15 09:14:12 No severe PSQL-related problems occured
15.01.23 09:14:13. End of report.