Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.10.2020 07:28
Common Performance Final Results
  1. Hardware and OS info
  2. DB and 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, full
  3. Ratio "Versions / Records" for tables
  4. Database Validation Results
  5. New in firebird.log while test was run
  6. 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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 11722900 kB
MemAvailable 31678044 kB
Buffers 0 kB
Cached 19882104 kB
SwapCached 5132 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.0
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                    
DTS_END                         
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           
IP                              
TRN_ID                          
ATT_ID                          
EXC_UNIT                        


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 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: 8655.10 30912 1038612
customer order: creation 164.47 360 19736
customer order: refuse 14.32 349 1718
order to supplier: creation 43.82 1256 5258
order to supplier: removal 3.21 121942 385
invoice (draft): creation 43.52 3362 5222
invoice (draft): removal 48.37 1014 5804
invoice accept: apply 39.95 19704 4794
invoice accept: cancel 43.53 954 5223
customer reserve: creation 3679.03 195 441483
customer reserve: removal 4295.14 72 515417
realization accept: apply 81.12 157 9734
realization accept: cancel 73.52 126 8822
payment from customer: creation 58.12 111 6974
payment from customer: removal 5.99 72 719
payment to supplier: creation 46.93 115 5631
payment to supplier: removal 3.25 61 390
service: total inventory turnovers 3.86 3284 463
service: total monetary turnovers 6.08 588 730
service: aggregate perf. data 0.88 15852 105
service: refresh index statistics 0.03 448672 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-10-2020 07:28:54 to 20-10-2020 07:28:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2377
TEST_TIME 2 2625
TEST_TIME 3 3523
TEST_TIME 4 5489
TEST_TIME 5 5869
TEST_TIME 6 6232
TEST_TIME 7 6272
TEST_TIME 8 6410
TEST_TIME 9 6541
TEST_TIME 10 6766
TEST_TIME 11 7048
TEST_TIME 12 7080
TEST_TIME 13 7308
TEST_TIME 14 7349
TEST_TIME 15 7261
TEST_TIME 16 7542
TEST_TIME 17 7749
TEST_TIME 18 7997
TEST_TIME 19 7826
TEST_TIME 20 8011
TEST_TIME 21 8170
TEST_TIME 22 8309
TEST_TIME 23 8448
TEST_TIME 24 8417
TEST_TIME 25 9116
TEST_TIME 26 9190
TEST_TIME 27 9822
TEST_TIME 28 10705
TEST_TIME 29 11204
TEST_TIME 30 10887
TEST_TIME 31 10568
TEST_TIME 32 10689
TEST_TIME 33 10521
TEST_TIME 34 10311
TEST_TIME 35 10227
TEST_TIME 36 10143
TEST_TIME 37 10029
TEST_TIME 38 9966
TEST_TIME 39 9820
TEST_TIME 40 9619
TEST_TIME 41 9624
TEST_TIME 42 9624
TEST_TIME 43 9664
TEST_TIME 44 9607
TEST_TIME 45 9635
TEST_TIME 46 9591
TEST_TIME 47 9543
TEST_TIME 48 9426
TEST_TIME 49 9538
TEST_TIME 50 9537
TEST_TIME 51 9533
TEST_TIME 52 9469
TEST_TIME 53 9420
TEST_TIME 54 9693
TEST_TIME 55 9636
TEST_TIME 56 9563
TEST_TIME 57 9452
TEST_TIME 58 9359
TEST_TIME 59 9253
TEST_TIME 60 9210
TEST_TIME 61 9178
TEST_TIME 62 9145
TEST_TIME 63 9196
TEST_TIME 64 9145
TEST_TIME 65 9111
TEST_TIME 66 9200
TEST_TIME 67 9286
TEST_TIME 68 9232
TEST_TIME 69 9255
TEST_TIME 70 9280
TEST_TIME 71 9286
TEST_TIME 72 9254
TEST_TIME 73 9258
TEST_TIME 74 9251
TEST_TIME 75 9249
TEST_TIME 76 9192
TEST_TIME 77 9124
TEST_TIME 78 9101
TEST_TIME 79 9031
TEST_TIME 80 8967
TEST_TIME 81 8914
TEST_TIME 82 8928
TEST_TIME 83 8931
TEST_TIME 84 8902
TEST_TIME 85 8876
TEST_TIME 86 8845
TEST_TIME 87 8834
TEST_TIME 88 8851
TEST_TIME 89 8881
TEST_TIME 90 8941
TEST_TIME 91 8969
TEST_TIME 92 8991
TEST_TIME 93 9018
TEST_TIME 94 9072
TEST_TIME 95 8999
TEST_TIME 96 8912
TEST_TIME 97 8913
TEST_TIME 98 8968
TEST_TIME 99 8947
TEST_TIME 100 8927
TEST_TIME 101 8886
TEST_TIME 102 8884
TEST_TIME 103 8852
TEST_TIME 104 8884
TEST_TIME 105 8861
TEST_TIME 106 8835
TEST_TIME 107 8855
TEST_TIME 108 8909
TEST_TIME 109 8962
TEST_TIME 110 8974
TEST_TIME 111 8934
TEST_TIME 112 8860
TEST_TIME 113 8812
TEST_TIME 114 8790
TEST_TIME 115 8733
TEST_TIME 116 8744
TEST_TIME 117 8706
TEST_TIME 118 8694
TEST_TIME 119 8704
TEST_TIME 120 8668

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-10-2020 07:28:57 to 20-10-2020 07:29:01.

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 1446166 1446166 0 0.00 0 18731 7 0 0
doc_list_biud 1446166 1446166 0 0.00 0 61414 33 0 0
sp_add_invoice_to_stock 4890 4794 96 1.96 32 234900 19705 0 96
sp_cancel_adding_invoice 5223 5223 0 0.00 5 86233 954 0 0
sp_cancel_client_order 1718 1718 0 0.00 4 17798 349 0 0
sp_cancel_customer_reserve 515417 515417 0 0.00 1 26326 73 0 0
sp_cancel_pay_from_customer 719 719 0 0.00 3 7056 72 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 1566 61 0 0
sp_cancel_supplier_invoice 5814 5804 10 0.17 1 61418 1015 0 10
sp_cancel_supplier_order 385 385 0 0.00 8 1152592 121942 0 0
sp_cancel_write_off 8822 8822 0 0.00 1 15759 127 0 0
sp_client_order 19736 19736 0 0.00 4 22791 361 0 0
sp_customer_reserve 441483 441483 0 0.00 0 74394 195 0 0
sp_fill_shopping_cart 30206 30206 0 0.00 1 18887 45 0 0
sp_fill_shopping_cart_clo_res 441481 441481 0 0.00 0 15681 17 0 0
sp_get_clo_for_invoice 4792 4792 0 0.00 0 26030 394 0 0
sp_kill_cost_storno 15154 15154 0 0.00 0 5589 56 0 0
sp_kill_qstorno_ret_qs2qd 1045845 1045845 0 0.00 0 61413 39 0 0
sp_kill_qty_storno 551895 551895 0 0.00 0 61414 84 0 0
sp_lock_selected_doc 20215 20215 0 0.00 0 10108 5 0 0
sp_make_cost_storno 27131 27131 0 0.00 0 8751 46 0 0
sp_multiply_rows_for_pdistr 27131 27131 0 0.00 0 7124 28 0 0
sp_multiply_rows_for_qdistr 19736 19736 0 0.00 0 18552 188 0 0
sp_pay_from_customer 6974 6974 0 0.00 3 14882 112 0 0
sp_pay_to_supplier 5631 5631 0 0.00 5 12686 115 0 0
sp_payment_common 12605 12605 0 0.00 1 5959 19 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 17792 321 0 0
sp_qd_handle_on_invoice_upd_sts 10015 10015 0 0.00 0 30436 396 0 0
sp_qd_handle_on_reserve_upd_sts 9734 9734 0 0.00 0 9181 43 0 0
sp_reserve_write_off 9734 9734 0 0.00 6 15088 157 0 0
sp_supplier_invoice 5222 5222 0 0.00 7 91846 3362 0 0
sp_supplier_order 5258 5258 0 0.00 6 49909 1257 0 0
srv_aggregate_perf_data 105 105 0 0.00 2152 294234 15853 0 0
srv_fill_mon_cache_memory 63 63 0 0.00 1963 125818 44788 0 0
srv_find_qd_qs_mism 992178 992178 0 0.00 0 18729 6 0 0
srv_make_invnt_saldo 463 463 0 0.00 30 117676 3285 0 0
srv_make_money_saldo 730 730 0 0.00 1 14793 588 0 0
srv_recalc_idx_stat 4 4 0 0.00 203342 739546 448672 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4794 4794 0 0.00 0 19561 170 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 1 3872 104 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 404 6 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 621 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 719 719 0 0.00 0 2067 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 263 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 1931 15 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 21164 1360 0 0
t$perf-norm:sp_cancel_write_off 982 982 0 0.00 0 1121 5 0 0
t$perf-norm:sp_client_order 19736 19736 0 0.00 0 16473 22 0 0
t$perf-norm:sp_customer_reserve 964 964 0 0.00 0 1537 5 0 0
t$perf-norm:sp_pay_from_customer 6974 6974 0 0.00 0 3107 6 0 0
t$perf-norm:sp_pay_to_supplier 5631 5631 0 0.00 0 3834 7 0 0
t$perf-norm:sp_reserve_write_off 9734 9734 0 0.00 0 10063 10 0 0
t$perf-norm:sp_supplier_invoice 5222 5222 0 0.00 0 17250 20 0 0
t$perf-norm:sp_supplier_order 5258 5258 0 0.00 0 24909 19 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 113 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 63 63 0 0.00 0 20 1 0 0
t$perf-norm:srv_make_invnt_saldo 463 463 0 0.00 0 10656 28 0 0
t$perf-norm:srv_make_money_saldo 730 730 0 0.00 0 2390 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 85 23 0 0
v_add_invoice_to_stock 9776 9584 192 1.96 0 5564 17 0 192
v_all_customers 35436 35436 0 0.00 0 16 1 0 0
v_all_suppliers 29006 29006 0 0.00 0 20 1 0 0
v_all_wares 39472 39472 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 739 6 0 0
v_cancel_client_order 3436 3436 0 0.00 0 1797 4 0 0
v_cancel_customer_prepayment 1438 1438 0 0.00 0 538 4 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 5758 13 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 873 6 0 0
v_cancel_supplier_invoice 864 844 20 2.31 0 3354 16 0 20
v_cancel_supplier_order 770 770 0 0.00 0 3360 8 0 0
v_cancel_write_off 1964 1964 0 0.00 0 4786 15 0 0
v_max_id_clo_ord 5258 5258 0 0.00 0 487 1 0 0
v_max_id_clo_res 964 964 0 0.00 0 10457 16 0 0
v_max_id_ord_sup 5211 5211 0 0.00 0 6915 5 0 0
v_max_non_paid_invoice 1597 1597 0 0.00 0 374 2 0 0
v_max_non_paid_realizn 4109 4109 0 0.00 0 2222 4 0 0
v_min_id_clo_ord 5258 5258 0 0.00 0 863 4 0 0
v_min_id_clo_res 964 964 0 0.00 0 4113 15 0 0
v_min_id_ord_sup 5211 5211 0 0.00 0 3517 7 0 0
v_min_non_paid_invoice 5631 5631 0 0.00 0 4236 11 0 0
v_min_non_paid_realizn 6974 6974 0 0.00 0 5956 14 0 0
v_our_firm 9766 9766 0 0.00 0 17 1 0 0
v_reserve_write_off 19468 19468 0 0.00 0 7584 5 0 0
x_lock_depdocs_on_canc_invoice 10605 10605 0 0.00 0 16069 124 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 17715 374 0 0
x_make_qstorno_1000_1200 5258 5258 0 0.00 2 48149 1182 0 0
x_make_qstorno_1200_2000 5222 5222 0 0.00 3 91840 3176 0 0
x_make_qstorno_2100_3300 441483 441483 0 0.00 0 74389 175 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 20-10-2020 07:29:02 to 20-10-2020 07:29:05.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
04:56:50 7 8192000000 8796624000 8807108608 3156752 0.038 1 1 2 0 3254112 61504 35856
04:57:52 27167 8192000000 9727514256 10025259008 803535728 8.932 100 92 184 0 833891200 8424704 21930768
04:59:27 21788 8192000000 9777060688 10086846464 849299520 9.393 100 89 178 0 882784848 11979248 21506080
05:01:02 13184 8192000000 9818369568 10139398144 884927056 9.749 100 88 176 3 923313632 18333952 20052624
05:02:18 12891 8192000000 9865451616 10199482368 915673792 10.053 100 76 152 0 977025792 44717424 16634576
05:03:32 8959 8192000000 9920267584 10263994368 954591824 10.436 100 78 157 0 1026034240 55112448 16329968
05:04:44 6140 8192000000 9973654432 10328817664 995227312 10.832 100 83 167 8 1090740880 78715424 16798144
05:05:54 2916 8192000000 10004776400 10367463424 1022300880 11.094 100 88 176 1 1116012464 75835536 17876048
05:06:59 1411 8192000000 10003828368 10370461696 1046285760 11.325 100 89 175 3 1114475472 49801808 18387904
05:08:02 1503 8192000000 10030191888 10408026112 1058105216 11.438 100 80 160 2 1140662128 66802208 15754704
05:09:04 5633 8192000000 10001205616 10391224320 1062909728 11.484 100 46 93 2 1121148016 48913392 9324896
05:10:12 6377 8192000000 9991348128 10389090304 1070914016 11.561 100 27 54 0 1109714704 33502832 5297856
05:11:19 51394 8192000000 9999248832 10413486080 1081393216 11.661 100 36 72 2 1104932496 14542208 8997072
05:13:16 5238 8192000000 10019728816 10419548160 1083450400 11.680 100 35 69 2 1118142032 26622352 8069280
05:14:23 7979 8192000000 9987578688 10394976256 1086827376 11.712 100 40 81 3 1117175296 21096864 9251056
05:15:32 9060 8192000000 10003463056 10417332224 1082509392 11.671 99 21 42 0 1110017872 23059456 4449024
05:16:44 49584 8192000000 9989660032 10385924096 1069183008 11.544 98 30 60 2 1096560016 20258816 7118192
05:18:34 3586 8192000000 9984505168 10368839680 1060337520 11.460 100 47 92 3 1097326128 26087456 10901152
05:19:38 3707 8192000000 9914215632 10292301824 982181360 10.705 96 48 99 2 1003565296 8350080 13033856
05:20:44 8012 8192000000 9937527200 10323701760 993644432 10.817 97 31 62 0 1025251600 25162448 6444720
05:21:55 46178 8192000000 9928710304 10326241280 996727072 10.847 96 29 58 1 1017871984 14799152 6345760
05:23:42 5469 8192000000 9954700960 10338828288 1035382160 11.220 99 52 104 1 1063229568 15537312 12310096
05:24:49 8324 8192000000 9988118272 10390118400 1063596112 11.491 100 37 74 4 1089160256 17574704 7989440
05:25:59 7724 8192000000 9986834976 10387611648 1071460752 11.566 100 40 82 2 1095418224 14941824 9015648
05:27:11 31402 8192000000 10018875664 10410381312 1089998912 11.743 100 57 113 1 1122266496 20980960 11286624
05:28:52 19480 8192000000 10081203280 10477596672 1104097840 11.877 100 60 118 2 1190745936 75222576 11425520
05:30:15 1959 8192000000 10098209120 10487009280 1117640256 12.005 100 80 160 0 1206343296 71678224 17024816
05:31:23 6607 8192000000 10112938752 10512089088 1132309392 12.143 100 64 128 1 1215313200 70245072 12758736
05:32:41 9087 8192000000 10137936768 10548473856 1142590960 12.240 100 59 117 0 1249789088 95155872 12042256
05:33:56 5017 8192000000 10153846768 10563125248 1156212944 12.368 100 53 106 4 1263825888 96658272 10954672
05:35:11 6579 8192000000 10198387456 10603810816 1163011856 12.431 100 73 146 0 1308681776 129735360 15934560
05:36:22 3053 8192000000 10219327552 10624188416 1162770160 12.429 100 65 130 1 1319303184 142564784 13968240
05:37:28 2974 8192000000 10239255216 10636058624 1159842368 12.402 100 80 159 2 1339349712 162210688 17296656
05:38:35 6999 8192000000 10255298480 10657484800 1159659792 12.400 100 70 139 0 1360278880 186096000 14523088
05:39:54 2521 8192000000 10302985440 10695593984 1171053984 12.507 100 87 171 0 1396815648 206705600 19056064
05:41:02 5806 8192000000 10328625968 10727690240 1163912800 12.440 100 73 145 2 1420678944 240154944 16611200
05:42:12 2350 8192000000 10368819632 10758971392 1146101872 12.273 99 83 163 0 1468022560 303119888 18800800
05:43:20 2878 8192000000 10365100704 10787012608 1151993808 12.328 99 72 142 0 1461316832 292060448 17262576
05:44:29 10883 8192000000 10365688512 10782904320 1146208000 12.274 100 41 82 1 1470839984 314060672 10571312
05:45:46 3874 8192000000 10407970672 10811277312 1159074032 12.395 100 80 157 0 1508794736 331417792 18302912
05:46:58 2980 8192000000 10459959376 10864824320 1172121136 12.517 100 67 132 1 1557056480 369146112 15789232
05:48:03 9895 8192000000 10437599952 10899070976 1159265728 12.396 100 38 76 2 1555271536 385897520 10108288
05:49:27 15954 8192000000 10460803616 10881241088 1138845696 12.205 100 37 74 1 1568993024 421107520 9039808
05:50:51 23016 8192000000 10533360448 10973143040 1107715360 11.911 98 35 70 2 1602575312 484532960 10326992
05:52:20 22739 8192000000 10421815552 10846248960 1116920656 11.998 100 35 69 2 1523339312 397450144 8968512
05:53:52 37437 8192000000 10295234016 10763112448 1100201376 11.840 99 17 34 1 1425449568 320434320 4813872
05:55:33 51347 8192000000 10076045504 10493689856 1082698960 11.673 97 17 34 4 1134538880 47882608 3957312
05:57:28 41012 8192000000 10080901344 10539446272 1119232128 12.020 100 29 58 1 1186753120 61505488 6015504
06:00:23 67548 8192000000 10053012544 10514092032 1124668640 12.071 99 16 32 0 1158862144 31223216 2970288
06:02:31 45739 8192000000 10054412672 10496364544 1127996624 12.102 99 10 20 0 1156469824 26666224 1806976
06:04:19 38716 8192000000 10061152960 10508984320 1118774048 12.015 99 16 32 2 1156245136 34446656 3024432
06:05:59 67665 8192000000 10131732496 10580307968 1144619856 12.259 100 26 52 2 1207432384 56914736 5897792
06:09:16 59568 8192000000 10059698912 10481930240 1105500528 11.890 97 16 32 0 1135684912 26747504 3436880
06:11:20 93866 8192000000 10124489888 10572742656 1124042320 12.065 98 13 26 0 1185664512 58582144 3040048
06:14:02 54653 8192000000 10133156720 10554839040 1095947456 11.799 96 34 67 1 1195725312 91981664 7796192
06:15:59 74132 8192000000 10050059600 10492514304 1115920704 11.988 98 17 34 2 1142557520 23148976 3487840
06:18:13 33239 8192000000 10108068400 10533838848 1098814272 11.826 96 34 68 3 1172089024 65213984 8060768
06:19:49 59525 8192000000 10101752528 10652622848 1125862544 12.082 99 10 20 1 1252433472 124327248 2243680
06:22:18 72026 8192000000 10063702720 10560090112 1133220640 12.152 100 10 20 0 1186070896 50975296 1874960
06:25:04 68099 8192000000 10099572864 10542665728 1089084800 11.734 96 7 14 0 1164093936 73462368 1546768
06:27:14 62051 8192000000 10094666432 10585378816 1121575408 12.042 100 10 20 1 1202078384 78541840 1961136
06:29:18 75724 8192000000 10076381552 10516025344 1111566336 11.947 98 19 38 1 1143907616 28556816 3784464
06:31:34 50582 8192000000 10135405440 10594889728 1107867984 11.912 97 22 44 1 1207580224 94821312 4890928
06:33:41 62743 8192000000 10057668256 10484350976 1089129712 11.734 97 17 34 1 1120237232 27359088 3748432
06:35:47 66983 8192000000 10096780128 10561564672 1102628832 11.863 98 23 46 0 1168278496 61169648 4480016
06:37:55 25120 8192000000 10044750912 10453557248 1073653344 11.587 97 48 96 0 1103233600 19998704 9581552
06:39:24 18644 8192000000 10084396176 10502094848 1110738304 11.939 100 48 96 1 1168588928 48360144 9490480
06:40:44 48197 8192000000 10096335392 10552180736 1121685328 12.043 100 44 88 3 1206122128 76045936 8390864
06:42:35 118213 8192000000 10057545072 10497716224 1097477232 11.814 98 26 52 0 1159617520 57007120 5133168
06:45:47 45053 8192000000 10045450016 10516725760 1103680736 11.873 99 4 8 0 1154198400 49733104 784560
06:47:33 38931 8192000000 10019883632 10508230656 1071934928 11.571 97 9 18 0 1137488144 63778336 1774880
06:49:17 57045 8192000000 10042083360 10487570432 1093783744 11.779 98 20 40 1 1139436464 41178272 4474448
06:51:16 63036 8192000000 10087095072 10532794368 1130857664 12.129 100 23 46 0 1184193632 48261824 5074144
06:53:23 43356 8192000000 10126030960 10556841984 1130179872 12.123 99 19 38 1 1203602256 69165936 4256448
06:55:14 115099 8192000000 10126595600 10598137856 1144460896 12.257 100 23 46 3 1272638304 123091664 5085744
06:58:15 68994 8192000000 10113407712 10562936832 1097675392 11.816 96 17 34 0 1133195760 32086416 3433952
07:00:25 125818 8192000000 10138794352 10609115136 1113020720 11.961 97 14 28 0 1216106064 100299728 2785616
07:04:05 66016 8192000000 10086037536 10592309248 1138811312 12.204 100 5 10 0 1182094400 42391088 892000
07:06:35 53046 8192000000 10065700096 10510155776 1114676624 11.977 97 12 24 0 1143084752 25814480 2593648
07:08:28 78771 8192000000 10093609328 10532155392 1088949376 11.733 95 25 50 1 1143762064 49798784 5013904
07:10:51 50607 8192000000 10064110496 10509242368 1072944368 11.580 94 19 38 2 1124236128 47223760 4068000
07:12:46 43789 8192000000 10144433168 10568232960 1124300544 12.068 99 42 84 4 1216887792 83978384 8608864
07:14:54 72048 8192000000 10070446256 10508185600 1096361104 11.803 97 7 14 0 1146556592 49075696 1119792
07:17:10 116297 8192000000 10094594592 10571972608 1127286928 12.096 99 16 32 0 1188530832 57856272 3387632
07:20:26 64248 8192000000 10088613664 10566275072 1110561280 11.938 98 10 20 0 1196102896 83277728 2263888
07:23:06 57968 8192000000 10090958400 10526367744 1106107776 11.896 98 19 38 1 1166495136 56758704 3628656
07:25:04 72548 8192000000 10067107536 10539786240 1077602576 11.625 96 11 22 0 1113108000 33455312 2050112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 20-10-2020 07:29:07 to 20-10-2020 07:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 96 v_add_invoice_to_stock 335544517
user_exc 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-10-2020 07:29:23 to 20-10-2020 07:29:25.

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          231168
MON$OLDEST_ACTIVE               233420
MON$OLDEST_SNAPSHOT             233420
MON$NEXT_TRANSACTION            233420
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                       2097152
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                        {8C105897-B735-40F5-7D8B-A1F76E952B78}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             789
MON$NEXT_STATEMENT              53


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

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

20.10.20 07:29:26. There are 33 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, 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
2020-10-20 07:29:28 No severe PSQL-related problems occured
20.10.20 07:29:29. End of report.