Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.04.2022 18:07
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 11949076 kB
MemAvailable 31574176 kB
Buffers 0 kB
Cached 19681396 kB
SwapCached 2324 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.10
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-04-20 18:07
DTS_END                         2022-04-20 18:07:14.6550
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          135548
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: 2079.88 24771 249586
customer order: creation 52.63 320 6316
customer order: refuse 4.65 440 558
order to supplier: creation 13.43 1817 1612
order to supplier: removal 0.88 181638 106
invoice (draft): creation 13.68 5952 1641
invoice (draft): removal 10.22 2112 1226
invoice accept: apply 11.91 28053 1429
invoice accept: cancel 8.99 2386 1079
customer reserve: creation 1028.47 290 123417
customer reserve: removal 849.90 149 101988
realization accept: apply 25.88 261 3106
realization accept: cancel 20.10 225 2412
payment from customer: creation 18.08 177 2169
payment from customer: removal 1.58 175 189
payment to supplier: creation 14.48 206 1737
payment to supplier: removal 0.94 163 113
service: total inventory turnovers 1.37 1095 164
service: total monetary turnovers 2.51 50 301
service: aggregate perf. data 0.18 35270 22
service: refresh index statistics 0.01 234650 1

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-04-2022 18:07:44 to 20-04-2022 18:07:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2532
TEST_TIME 2 1954
TEST_TIME 3 3192
TEST_TIME 4 3424
TEST_TIME 5 4523
TEST_TIME 6 4879
TEST_TIME 7 5762
TEST_TIME 8 5619
TEST_TIME 9 5910
TEST_TIME 10 6337
TEST_TIME 11 6423
TEST_TIME 12 6483
TEST_TIME 13 6785
TEST_TIME 14 7486
TEST_TIME 15 7750
TEST_TIME 16 8043
TEST_TIME 17 7983
TEST_TIME 18 8202
TEST_TIME 19 8387
TEST_TIME 20 8617
TEST_TIME 21 8661
TEST_TIME 22 8966
TEST_TIME 23 8903
TEST_TIME 24 9345
TEST_TIME 25 9363
TEST_TIME 26 9337
TEST_TIME 27 9253

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-04-2022 18:07:47 to 20-04-2022 18:07:50.

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 361977 361977 0 0.00 0 44079 13 0 0
doc_list_biud 361969 361969 0 0.00 0 41356 55 0 0
sp_add_invoice_to_stock 1457 1429 28 1.92 63 156145 28053 0 28
sp_cancel_adding_invoice 1079 1079 0 0.00 9 57755 2386 0 0
sp_cancel_client_order 558 558 0 0.00 6 2003 440 0 0
sp_cancel_customer_reserve 101988 101988 0 0.00 1 13356 150 0 0
sp_cancel_pay_from_customer 189 189 0 0.00 4 5000 175 0 0
sp_cancel_pay_to_supplier 113 113 0 0.00 3 3121 164 0 0
sp_cancel_supplier_invoice 1228 1226 2 0.16 3 17021 2112 0 2
sp_cancel_supplier_order 106 106 0 0.00 48 805015 181639 0 0
sp_cancel_write_off 2412 2412 0 0.00 1 9876 225 0 0
sp_client_order 6316 6316 0 0.00 4 14699 321 0 0
sp_customer_reserve 123417 123417 0 0.00 0 28205 290 0 0
sp_fill_shopping_cart 9556 9556 0 0.00 1 14605 47 0 0
sp_fill_shopping_cart_clo_res 123416 123416 0 0.00 0 18327 14 0 0
sp_get_clo_for_invoice 1428 1428 0 0.00 0 8835 227 0 0
sp_kill_cost_storno 3793 3793 0 0.00 0 9268 152 0 0
sp_kill_qstorno_ret_qs2qd 207720 207720 0 0.00 0 17003 83 0 0
sp_kill_qty_storno 111895 111895 0 0.00 0 41355 176 0 0
sp_lock_selected_doc 6257 6257 0 0.00 0 5443 5 0 0
sp_make_cost_storno 8440 8440 0 0.00 0 43962 95 0 0
sp_multiply_rows_for_pdistr 8439 8439 0 0.00 0 9702 67 0 0
sp_multiply_rows_for_qdistr 6316 6316 0 0.00 0 14683 168 0 0
sp_pay_from_customer 2169 2169 0 0.00 5 10102 177 0 0
sp_pay_to_supplier 1737 1737 0 0.00 6 10515 207 0 0
sp_payment_common 3906 3906 0 0.00 1 9225 46 0 0
sp_qd_handle_on_cancel_clo 558 558 0 0.00 1 1854 414 0 0
sp_qd_handle_on_invoice_upd_sts 2505 2505 0 0.00 1 41355 753 0 0
sp_qd_handle_on_reserve_upd_sts 3100 3100 0 0.00 0 2040 59 0 0
sp_reserve_write_off 3106 3106 0 0.00 8 26663 261 0 0
sp_supplier_invoice 1641 1641 0 0.00 8 85890 5953 0 0
sp_supplier_order 1612 1612 0 0.00 6 13735 1818 0 0
srv_aggregate_perf_data 22 22 0 0.00 3253 329299 35271 0 0
srv_fill_mon_cache_memory 21 21 0 0.00 924 45966 11988 0 0
srv_find_qd_qs_mism 234835 234835 0 0.00 0 8616 11 0 0
srv_make_invnt_saldo 164 164 0 0.00 113 3467 1095 0 0
srv_make_money_saldo 301 301 0 0.00 1 697 50 0 0
srv_recalc_idx_stat 1 1 0 0.00 234650 234650 234650 0 0
t$perf-abend:sp_add_invoice_to_stock 28 28 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 1429 1429 0 0.00 0 14237 391 0 0
t$perf-norm:sp_cancel_adding_invoice 128 128 0 0.00 2 2058 228 0 0
t$perf-norm:sp_cancel_client_order 558 558 0 0.00 0 896 25 0 0
t$perf-norm:sp_cancel_customer_reserve 224 224 0 0.00 0 837 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 189 189 0 0.00 0 1241 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 113 113 0 0.00 0 655 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 106 106 0 0.00 0 1019 56 0 0
t$perf-norm:sp_cancel_supplier_order 106 106 0 0.00 0 20285 3665 0 0
t$perf-norm:sp_cancel_write_off 307 307 0 0.00 0 595 9 0 0
t$perf-norm:sp_client_order 6316 6316 0 0.00 0 1894 33 0 0
t$perf-norm:sp_customer_reserve 310 310 0 0.00 0 1421 10 0 0
t$perf-norm:sp_pay_from_customer 2169 2169 0 0.00 0 3031 14 0 0
t$perf-norm:sp_pay_to_supplier 1737 1737 0 0.00 0 1701 11 0 0
t$perf-norm:sp_reserve_write_off 3106 3106 0 0.00 0 3029 16 0 0
t$perf-norm:sp_supplier_invoice 1641 1641 0 0.00 0 1561 38 0 0
t$perf-norm:sp_supplier_order 1612 1612 0 0.00 0 1291 36 0 0
t$perf-norm:srv_aggregate_perf_data 22 22 0 0.00 0 468 39 0 0
t$perf-norm:srv_fill_mon_cache_memory 21 21 0 0.00 0 35 4 0 0
t$perf-norm:srv_make_invnt_saldo 164 164 0 0.00 0 1003 72 0 0
t$perf-norm:srv_make_money_saldo 301 301 0 0.00 0 1510 36 0 0
t$perf-norm:srv_recalc_idx_stat 1 1 0 0.00 37 37 37 0 0
v_add_invoice_to_stock 2908 2852 56 1.92 0 6965 26 0 56
v_all_customers 11328 11328 0 0.00 0 21 1 0 0
v_all_suppliers 8720 8720 0 0.00 0 18 1 0 0
v_all_wares 12632 12632 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 256 256 0 0.00 0 226 9 0 0
v_cancel_client_order 1116 1116 0 0.00 0 415 4 0 0
v_cancel_customer_prepayment 378 378 0 0.00 0 427 7 0 0
v_cancel_customer_reserve 448 448 0 0.00 0 162 5 0 0
v_cancel_payment_to_supplier 226 226 0 0.00 0 454 7 0 0
v_cancel_supplier_invoice 216 212 4 1.85 0 187 18 0 4
v_cancel_supplier_order 212 212 0 0.00 0 425 7 0 0
v_cancel_write_off 614 614 0 0.00 0 553 18 0 0
v_max_id_clo_ord 1606 1606 0 0.00 0 310 2 0 0
v_max_id_clo_res 310 310 0 0.00 0 981 15 0 0
v_max_id_ord_sup 1634 1634 0 0.00 0 1337 4 0 0
v_max_non_paid_invoice 616 616 0 0.00 0 153 4 0 0
v_max_non_paid_realizn 1234 1234 0 0.00 0 856 6 0 0
v_min_id_clo_ord 1606 1606 0 0.00 0 11122 16 0 0
v_min_id_clo_res 310 310 0 0.00 0 1329 8 0 0
v_min_id_ord_sup 1634 1634 0 0.00 0 5435 9 0 0
v_min_non_paid_invoice 1737 1737 0 0.00 0 6210 37 0 0
v_min_non_paid_realizn 2169 2169 0 0.00 0 8964 37 0 0
v_our_firm 3170 3170 0 0.00 0 13 1 0 0
v_reserve_write_off 6200 6200 0 0.00 0 595 4 0 0
x_lock_depdocs_on_canc_invoice 2199 2199 0 0.00 0 9370 269 0 0
x_lock_depdocs_on_canc_sup_ord 106 106 0 0.00 0 2839 435 0 0
x_make_qstorno_1000_1200 1612 1612 0 0.00 2 13675 1676 0 0
x_make_qstorno_1200_2000 1641 1641 0 0.00 4 85769 5790 0 0
x_make_qstorno_2100_3300 123417 123417 0 0.00 0 25091 270 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-04-2022 18:07:51 to 20-04-2022 18:07:55.

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
17:08:20 2 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
17:09:20 21489 8192000000 9892448096 10200170496 978006128 10.665 100 91 182 1 1008745504 6479344 24260032
17:10:57 19027 8192000000 9957588368 10281725952 1037053360 11.236 100 86 172 0 1067946096 8564544 22328192
17:12:25 16546 8192000000 9999590816 10334216192 1085649440 11.701 100 87 173 2 1116126672 9266256 21210976
17:13:45 13102 8192000000 10030631296 10379980800 1118988992 12.017 100 75 150 0 1147395440 10362576 18043872
17:15:01 11110 8192000000 10081325824 10441056256 1164942848 12.450 100 76 152 4 1193849696 11280416 17626432
17:16:18 7720 8192000000 10117754912 10487726080 1208063056 12.851 100 83 166 1 1239260896 13033408 18164432
17:17:27 3563 8192000000 10156754768 10531577856 1246603056 13.207 100 87 171 1 1278635360 12924032 19108272
17:18:32 2945 8192000000 10192390160 10571485184 1280873360 13.521 100 90 180 3 1313272176 12390928 20007888
17:19:37 1214 8192000000 10218976672 10602364928 1300623984 13.701 100 95 191 1 1335785968 14150464 21011520
17:20:38 3337 8192000000 10208833680 10610405376 1308757152 13.775 100 53 106 0 1329673072 8051200 12864720
17:21:42 5773 8192000000 10200831376 10617483264 1315406864 13.835 100 24 48 1 1331507616 10408176 5692576
17:22:49 10510 8192000000 10201921168 10624438272 1320582480 13.882 100 21 42 2 1331353232 6079472 4691280
17:24:04 63423 8192000000 10218466640 10643210240 1327948048 13.949 100 24 47 0 1338520512 4834832 5737632
17:26:08 6473 8192000000 10227707568 10651574272 1337214560 14.032 100 21 42 0 1348282992 6079952 4988480
17:27:15 5980 8192000000 10230830784 10653425664 1338050016 14.040 100 20 40 1 1348687216 5995216 4641984
17:28:24 67887 8192000000 10193205760 10597462016 1262390128 13.352 95 26 50 2 1273136208 4384032 6362048
17:30:34 5234 8192000000 10140808896 10537193472 1225917136 13.016 97 31 60 0 1239472784 6716112 6839536
17:31:41 8576 8192000000 10133657344 10537472000 1215640400 12.921 97 25 50 0 1226512864 4994320 5878144
17:32:53 8734 8192000000 10144232912 10549223424 1237149408 13.120 98 18 36 0 1247659088 6406016 4103664
17:34:02 32197 8192000000 10144211424 10556489728 1248398480 13.224 99 19 38 1 1258712464 6135648 4178336
17:35:37 7722 8192000000 10175935600 10591916032 1288992960 13.595 100 28 56 3 1301117008 5590560 6533488
17:36:48 12915 8192000000 10193992048 10605928448 1300222912 13.697 100 23 46 0 1311038000 4911024 5904064
17:38:01 45966 8192000000 10216573408 10625204224 1303394480 13.726 99 12 24 0 1311462208 4536880 3530848
17:39:51 23845 8192000000 10251025008 10663182336 1343342048 14.088 100 45 88 1 1364744480 10853808 10548624
17:41:20 41949 8192000000 10261723776 10678644736 1351849728 14.164 100 41 80 1 1372961248 12270032 8841488
17:43:05 20314 8192000000 10281996816 10702544896 1371782800 14.343 100 38 76 0 1396054656 15308832 8963024
17:44:28 5719 8192000000 10295954448 10711363584 1369469232 14.322 99 58 116 3 1400552784 16491488 14592064
17:45:40 9293 8192000000 10308789648 10728390656 1389033952 14.497 100 55 108 1 1419412624 17770848 12607824
17:46:54 4968 8192000000 10322704912 10743586816 1398829040 14.585 100 55 109 1 1428041344 16314336 12897968
17:48:02 2024 8192000000 10333396704 10750390272 1406261440 14.651 100 84 169 1 1446733024 20031520 20440064
17:49:08 5584 8192000000 10331705152 10751488000 1400367168 14.598 100 69 137 5 1441392064 24473088 16551808
17:50:29 4642 8192000000 10341471248 10760863744 1401719808 14.610 100 71 142 1 1446891472 27007056 18164608
17:51:42 9836 8192000000 10344719072 10769502208 1402496144 14.617 100 64 128 0 1450190480 30976864 16717472
17:52:57 923 8192000000 10355041712 10769506304 1408638000 14.672 100 86 172 0 1457520112 27064352 21817760
17:54:03 2217 8192000000 10337190544 10752970752 1391644928 14.521 100 70 136 3 1439322320 30346976 17330416
17:55:10 10043 8192000000 10309408928 10720354304 1359209184 14.230 99 66 132 3 1405431744 29892976 16329584
17:56:25 5427 8192000000 10328413248 10745663488 1373411232 14.358 99 64 128 3 1424593040 35753408 15428400
17:57:36 4676 8192000000 10332419584 10748575744 1376570400 14.386 100 66 128 2 1428793488 36441728 15781360
17:58:56 12259 8192000000 10294300464 10718466048 1359241264 14.231 100 33 66 0 1406376592 38159488 8975840
18:00:15 10056 8192000000 10309710976 10730315776 1365337664 14.285 100 32 64 0 1411815264 37691136 8786464
18:01:39 10281 8192000000 10311600208 10738106368 1370022128 14.327 100 29 58 0 1418639440 40371552 8245760
18:02:55 9618 8192000000 10295772048 10722967552 1353835856 14.182 100 29 57 1 1402451312 40758176 7857280
18:04:08 12080 8192000000 10319184480 10744438784 1373237744 14.356 100 29 58 0 1423283648 42319200 7726704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 20-04-2022 18:07:57 to 20-04-2022 18:08:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 28 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-04-2022 18:08:08 to 20-04-2022 18:08:10.

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          114034
MON$OLDEST_ACTIVE               135653
MON$OLDEST_SNAPSHOT             135653
MON$NEXT_TRANSACTION            135653
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                       1987584
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.10.33577 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.10.33577 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.10.33577 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.10.33577 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 ---
:743: 
:744: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:745:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:746: 
:747: 
:748: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:749:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:750: 
:751: 
:752: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:753:     /opt/fb30/bin/fbguard: /opt/fb30/bin/firebird terminated abnormally (-1)
:754: 
:755: 
:756: 
:757: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:758:     /opt/fb30/bin/fbguard: guardian starting /opt/fb30/bin/firebird
:759: 
:760: 
:761: 
:762: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:763:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:764:     Uncommitted work may have been lost.
:765:     Error writing data to the connection.
:766: 
:767: 
:768: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:769:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:770:     Uncommitted work may have been lost.
:771:     Error writing data to the connection.
:772: 
:773: 
:774: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:775:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:776:     Uncommitted work may have been lost.
:777:     Error writing data to the connection.
:778: 
:779: 
:780: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:781:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:782:     Uncommitted work may have been lost.
:783:     Error writing data to the connection.
:784: 
:785: 
:786: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:787:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:788:     Uncommitted work may have been lost.
:789:     Error writing data to the connection.
:790: 
:791: 
:792: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:793:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:794:     Uncommitted work may have been lost.
:795:     Error writing data to the connection.
:796: 
:797: 
:798: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:799:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:800:     Uncommitted work may have been lost.
:801:     Error writing data to the connection.
:802: 
:803: 
:804: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:805:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:806:     Uncommitted work may have been lost.
:807:     Error writing data to the connection.
:808: 
:809: 
:810: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:811:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:812:     Uncommitted work may have been lost.
:813:     Error writing data to the connection.
:814: 
:815: 
:816: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:817:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:818:     Uncommitted work may have been lost.
:819:     Error writing data to the connection.
:820: 
:821: 
:822: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:823:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:824:     Uncommitted work may have been lost.
:825:     Error writing data to the connection.
:826: 
:827: 
:828: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:829:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:830:     Uncommitted work may have been lost.
:831:     Error writing data to the connection.
:832: 
:833: 
:834: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:835:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:836:     Uncommitted work may have been lost.
:837:     Error writing data to the connection.
:838: 
:839: 
:840: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:841:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:842:     Uncommitted work may have been lost.
:843:     Error writing data to the connection.
:844: 
:845: 
:846: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:847:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:848:     Uncommitted work may have been lost.
:849:     Error writing data to the connection.
:850: 
:851: 
:852: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:853:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:854:     Uncommitted work may have been lost.
:855:     Error writing data to the connection.
:856: 
:857: 
:858: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:859:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:860:     Uncommitted work may have been lost.
:861:     Error writing data to the connection.
:862: 
:863: 
:864: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:865:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:866:     Uncommitted work may have been lost.
:867:     Error writing data to the connection.
:868: 
:869: 
:870: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:871:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:872:     Uncommitted work may have been lost.
:873:     Error writing data to the connection.
:874: 
:875: 
:876: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:877:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:878:     Uncommitted work may have been lost.
:879:     Error writing data to the connection.
:880: 
:881: 
:882: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:883:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:884:     Uncommitted work may have been lost.
:885:     Error writing data to the connection.
:886: 
:887: 
:888: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:889:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:890:     Uncommitted work may have been lost.
:891:     Error writing data to the connection.
:892: 
:893: 
:894: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:895:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:896:     Uncommitted work may have been lost.
:897:     Error writing data to the connection.
:898: 
:899: 
:900: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:901:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:902:     Uncommitted work may have been lost.
:903:     Error writing data to the connection.
:904: 
:905: 
:906: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:907:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:908:     Uncommitted work may have been lost.
:909:     Error writing data to the connection.
:910: 
:911: 
:912: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:913:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:914:     Uncommitted work may have been lost.
:915:     Error writing data to the connection.
:916: 
:917: 
:918: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:919:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:920:     Uncommitted work may have been lost.
:921:     Error writing data to the connection.
:922: 
:923: 
:924: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:925:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:926:     Uncommitted work may have been lost.
:927:     Error writing data to the connection.
:928: 
:929: 
:930: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:931:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:932:     Uncommitted work may have been lost.
:933:     Error writing data to the connection.
:934: 
:935: 
:936: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:937:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:938:     Uncommitted work may have been lost.
:939:     Error writing data to the connection.
:940: 
:941: 
:942: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:943:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:944:     Uncommitted work may have been lost.
:945:     Error writing data to the connection.
:946: 
:947: 
:948: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:949:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:950:     Uncommitted work may have been lost.
:951:     Error writing data to the connection.
:952: 
:953: 
:954: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:955:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:956:     Uncommitted work may have been lost.
:957:     Error writing data to the connection.
:958: 
:959: 
:960: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:961:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:962:     Uncommitted work may have been lost.
:963:     Error writing data to the connection.
:964: 
:965: 
:966: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:967:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:968:     Uncommitted work may have been lost.
:969:     Error writing data to the connection.
:970: 
:971: 
:972: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:973:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:974:     Uncommitted work may have been lost.
:975:     Error writing data to the connection.
:976: 
:977: 
:978: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:979:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:980:     Uncommitted work may have been lost.
:981:     Error writing data to the connection.
:982: 
:983: 
:984: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:985:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:986:     Uncommitted work may have been lost.
:987:     Error writing data to the connection.
:988: 
:989: 
:990: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:991:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:992:     Uncommitted work may have been lost.
:993:     Error writing data to the connection.
:994: 
:995: 
:996: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:997:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:998:     Uncommitted work may have been lost.
:999:     Error writing data to the connection.
:1000: 
:1001: 
:1002: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1003:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1004:     Uncommitted work may have been lost.
:1005:     Error writing data to the connection.
:1006: 
:1007: 
:1008: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1009:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1010:     Uncommitted work may have been lost.
:1011:     Error writing data to the connection.
:1012: 
:1013: 
:1014: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1015:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1016:     Uncommitted work may have been lost.
:1017:     Error writing data to the connection.
:1018: 
:1019: 
:1020: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1021:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1022:     Uncommitted work may have been lost.
:1023:     Error writing data to the connection.
:1024: 
:1025: 
:1026: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1027:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1028:     Uncommitted work may have been lost.
:1029:     Error writing data to the connection.
:1030: 
:1031: 
:1032: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1033:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1034:     Uncommitted work may have been lost.
:1035:     Error writing data to the connection.
:1036: 
:1037: 
:1038: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1039:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1040:     Uncommitted work may have been lost.
:1041:     Error writing data to the connection.
:1042: 
:1043: 
:1044: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1045:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1046:     Uncommitted work may have been lost.
:1047:     Error writing data to the connection.
:1048: 
:1049: 
:1050: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1051:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1052:     Uncommitted work may have been lost.
:1053:     Error writing data to the connection.
:1054: 
:1055: 
:1056: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1057:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1058:     Uncommitted work may have been lost.
:1059:     Error writing data to the connection.
:1060: 
:1061: 
:1062: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1063:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1064:     Uncommitted work may have been lost.
:1065:     Error writing data to the connection.
:1066: 
:1067: 
:1068: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1069:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1070:     Uncommitted work may have been lost.
:1071:     Error writing data to the connection.
:1072: 
:1073: 
:1074: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1075:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1076:     Uncommitted work may have been lost.
:1077:     Error writing data to the connection.
:1078: 
:1079: 
:1080: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1081:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1082:     Uncommitted work may have been lost.
:1083:     Error writing data to the connection.
:1084: 
:1085: 
:1086: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1087:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1088:     Uncommitted work may have been lost.
:1089:     Error writing data to the connection.
:1090: 
:1091: 
:1092: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1093:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1094:     Uncommitted work may have been lost.
:1095:     Error writing data to the connection.
:1096: 
:1097: 
:1098: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1099:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1100:     Uncommitted work may have been lost.
:1101:     Error writing data to the connection.
:1102: 
:1103: 
:1104: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1105:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1106:     Uncommitted work may have been lost.
:1107:     Error writing data to the connection.
:1108: 
:1109: 
:1110: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1111:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1112:     Uncommitted work may have been lost.
:1113:     Error writing data to the connection.
:1114: 
:1115: 
:1116: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1117:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1118:     Uncommitted work may have been lost.
:1119:     Error writing data to the connection.
:1120: 
:1121: 
:1122: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1123:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1124:     Uncommitted work may have been lost.
:1125:     Error writing data to the connection.
:1126: 
:1127: 
:1128: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1129:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1130:     Uncommitted work may have been lost.
:1131:     Error writing data to the connection.
:1132: 
:1133: 
:1134: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1135:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1136:     Uncommitted work may have been lost.
:1137:     Error writing data to the connection.
:1138: 
:1139: 
:1140: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1141:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1142:     Uncommitted work may have been lost.
:1143:     Error writing data to the connection.
:1144: 
:1145: 
:1146: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1147:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1148:     Uncommitted work may have been lost.
:1149:     Error writing data to the connection.
:1150: 
:1151: 
:1152: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1153:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1154:     Uncommitted work may have been lost.
:1155:     Error writing data to the connection.
:1156: 
:1157: 
:1158: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1159:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1160:     Uncommitted work may have been lost.
:1161:     Error writing data to the connection.
:1162: 
:1163: 
:1164: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1165:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1166:     Uncommitted work may have been lost.
:1167:     Error writing data to the connection.
:1168: 
:1169: 
:1170: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1171:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1172:     Uncommitted work may have been lost.
:1173:     Error writing data to the connection.
:1174: 
:1175: 
:1176: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1177:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1178:     Uncommitted work may have been lost.
:1179:     Error writing data to the connection.
:1180: 
:1181: 
:1182: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1183:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1184:     Uncommitted work may have been lost.
:1185:     Error writing data to the connection.
:1186: 
:1187: 
:1188: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1189:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1190:     Uncommitted work may have been lost.
:1191:     Error writing data to the connection.
:1192: 
:1193: 
:1194: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1195:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1196:     Uncommitted work may have been lost.
:1197:     Error writing data to the connection.
:1198: 
:1199: 
:1200: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1201:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1202:     Uncommitted work may have been lost.
:1203:     Error writing data to the connection.
:1204: 
:1205: 
:1206: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1207:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1208:     Uncommitted work may have been lost.
:1209:     Error writing data to the connection.
:1210: 
:1211: 
:1212: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1213:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1214:     Uncommitted work may have been lost.
:1215:     Error writing data to the connection.
:1216: 
:1217: 
:1218: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1219:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1220:     Uncommitted work may have been lost.
:1221:     Error writing data to the connection.
:1222: 
:1223: 
:1224: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1225:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1226:     Uncommitted work may have been lost.
:1227:     Error writing data to the connection.
:1228: 
:1229: 
:1230: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1231:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1232:     Uncommitted work may have been lost.
:1233:     Error writing data to the connection.
:1234: 
:1235: 
:1236: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1237:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1238:     Uncommitted work may have been lost.
:1239:     Error writing data to the connection.
:1240: 
:1241: 
:1242: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1243:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1244:     Uncommitted work may have been lost.
:1245:     Error writing data to the connection.
:1246: 
:1247: 
:1248: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1249:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1250:     Uncommitted work may have been lost.
:1251:     Error writing data to the connection.
:1252: 
:1253: 
:1254: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1255:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1256:     Uncommitted work may have been lost.
:1257:     Error writing data to the connection.
:1258: 
:1259: 
:1260: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1261:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1262:     Uncommitted work may have been lost.
:1263:     Error writing data to the connection.
:1264: 
:1265: 
:1266: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1267:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1268:     Uncommitted work may have been lost.
:1269:     Error writing data to the connection.
:1270: 
:1271: 
:1272: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1273:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1274:     Uncommitted work may have been lost.
:1275:     Error writing data to the connection.
:1276: 
:1277: 
:1278: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1279:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1280:     Uncommitted work may have been lost.
:1281:     Error writing data to the connection.
:1282: 
:1283: 
:1284: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1285:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1286:     Uncommitted work may have been lost.
:1287:     Error writing data to the connection.
:1288: 
:1289: 
:1290: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1291:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1292:     Uncommitted work may have been lost.
:1293:     Error writing data to the connection.
:1294: 
:1295: 
:1296: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1297:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1298:     Uncommitted work may have been lost.
:1299:     Error writing data to the connection.
:1300: 
:1301: 
:1302: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1303:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1304:     Uncommitted work may have been lost.
:1305:     Error writing data to the connection.
:1306: 
:1307: 
:1308: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1309:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1310:     Uncommitted work may have been lost.
:1311:     Error writing data to the connection.
:1312: 
:1313: 
:1314: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1315:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1316:     Uncommitted work may have been lost.
:1317:     Error writing data to the connection.
:1318: 
:1319: 
:1320: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1321:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1322:     Uncommitted work may have been lost.
:1323:     Error writing data to the connection.
:1324: 
:1325: 
:1326: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1327:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1328:     Uncommitted work may have been lost.
:1329:     Error writing data to the connection.
:1330: 
:1331: 
:1332: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1333:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1334:     Uncommitted work may have been lost.
:1335:     Error writing data to the connection.
:1336: 
:1337: 
:1338: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1339:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1340:     Uncommitted work may have been lost.
:1341:     Error writing data to the connection.
:1342: 
:1343: 
:1344: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1345:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1346:     Uncommitted work may have been lost.
:1347:     Error writing data to the connection.
:1348: 
:1349: 
:1350: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1351:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1352:     Uncommitted work may have been lost.
:1353:     Error writing data to the connection.
:1354: 
:1355: 
:1356: mscs-test-161.budzdorov.ru    Wed Apr 20 18:07:03 2022
:1357:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1358:     Uncommitted work may have been lost.
:1359:     Error writing data to the connection.
:1360: 
--- end of diff output ---

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

20.04.22 18:08:11. All 6 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-04-20 18:08:14 No severe PSQL-related problems occured
20.04.22 18:08:15. End of report.