Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.11.2020 10:14
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 1920.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 10282720 kB
MemAvailable 30864788 kB
Buffers 0 kB
Cached 20572924 kB
SwapCached 4780 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                    CRASH DURING TEST RUN, 2020-11-19 10:14
DTS_END                         2020-11-19 10:14:15.2160
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          221287
ATT_ID                          731
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: 8162.17 21509 979460
customer order: creation 149.41 396 17929
customer order: refuse 13.46 353 1615
order to supplier: creation 41.38 1377 4965
order to supplier: removal 3.15 103724 378
invoice (draft): creation 40.86 3404 4903
invoice (draft): removal 47.02 864 5642
invoice accept: apply 36.45 16829 4374
invoice accept: cancel 42.67 909 5120
customer reserve: creation 3362.50 165 403500
customer reserve: removal 4155.81 62 498697
realization accept: apply 74.53 175 8943
realization accept: cancel 80.48 122 9658
payment from customer: creation 52.78 108 6333
payment from customer: removal 5.04 78 605
payment to supplier: creation 43.73 114 5247
payment to supplier: removal 3.02 69 362
service: total inventory turnovers 3.38 3220 405
service: total monetary turnovers 5.69 419 683
service: aggregate perf. data 0.81 15364 97
service: refresh index statistics 0.03 282431 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 19-11-2020 10:14:36 to 19-11-2020 10:14:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2822
TEST_TIME 2 3587
TEST_TIME 3 4056
TEST_TIME 4 3579
TEST_TIME 5 3584
TEST_TIME 6 3977
TEST_TIME 7 4374
TEST_TIME 8 4507
TEST_TIME 9 4615
TEST_TIME 10 4981
TEST_TIME 11 5296
TEST_TIME 12 5650
TEST_TIME 13 5856
TEST_TIME 14 6223
TEST_TIME 15 6601
TEST_TIME 16 7137
TEST_TIME 17 7852
TEST_TIME 18 8195
TEST_TIME 19 8220
TEST_TIME 20 8129
TEST_TIME 21 8988
TEST_TIME 22 9313
TEST_TIME 23 9500
TEST_TIME 24 10757
TEST_TIME 25 11179
TEST_TIME 26 11242
TEST_TIME 27 11267
TEST_TIME 28 11362
TEST_TIME 29 11172
TEST_TIME 30 11200
TEST_TIME 31 11080
TEST_TIME 32 10794
TEST_TIME 33 10490
TEST_TIME 34 10518
TEST_TIME 35 10614
TEST_TIME 36 10511
TEST_TIME 37 10439
TEST_TIME 38 10444
TEST_TIME 39 10363
TEST_TIME 40 10228
TEST_TIME 41 10223
TEST_TIME 42 10219
TEST_TIME 43 10070
TEST_TIME 44 10365
TEST_TIME 45 10303
TEST_TIME 46 10251
TEST_TIME 47 10213
TEST_TIME 48 10333
TEST_TIME 49 10372
TEST_TIME 50 10380
TEST_TIME 51 10378
TEST_TIME 52 10389
TEST_TIME 53 10466
TEST_TIME 54 10441
TEST_TIME 55 10496
TEST_TIME 56 10348
TEST_TIME 57 10202
TEST_TIME 58 10071
TEST_TIME 59 9989
TEST_TIME 60 9910
TEST_TIME 61 9876
TEST_TIME 62 9781
TEST_TIME 63 9842
TEST_TIME 64 9827
TEST_TIME 65 9840
TEST_TIME 66 9819
TEST_TIME 67 9793
TEST_TIME 68 9734
TEST_TIME 69 9782
TEST_TIME 70 9837
TEST_TIME 71 9926
TEST_TIME 72 9928
TEST_TIME 73 9917
TEST_TIME 74 9882
TEST_TIME 75 9963
TEST_TIME 76 9931
TEST_TIME 77 9968
TEST_TIME 78 9862
TEST_TIME 79 9775
TEST_TIME 80 9710
TEST_TIME 81 9641
TEST_TIME 82 9587
TEST_TIME 83 9567
TEST_TIME 84 9518
TEST_TIME 85 9472
TEST_TIME 86 9469
TEST_TIME 87 9440
TEST_TIME 88 9476
TEST_TIME 89 9460
TEST_TIME 90 9435
TEST_TIME 91 9466
TEST_TIME 92 9418
TEST_TIME 93 9421
TEST_TIME 94 9445
TEST_TIME 95 9504
TEST_TIME 96 9491
TEST_TIME 97 9405
TEST_TIME 98 9387
TEST_TIME 99 9347
TEST_TIME 100 9286
TEST_TIME 101 9294
TEST_TIME 102 9275
TEST_TIME 103 9273
TEST_TIME 104 9259
TEST_TIME 105 9256
TEST_TIME 106 9244
TEST_TIME 108 9087

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 19-11-2020 10:14:38 to 19-11-2020 10:14:40.

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 1353472 1353472 0 0.00 0 16707 6 0 0
doc_list_biud 1353471 1353471 0 0.00 0 40345 29 0 0
sp_add_invoice_to_stock 4441 4374 67 1.50 28 194637 16830 0 67
sp_cancel_adding_invoice 5120 5120 0 0.00 5 94864 910 0 0
sp_cancel_client_order 1615 1615 0 0.00 5 19630 354 0 0
sp_cancel_customer_reserve 498697 498697 0 0.00 1 23524 63 0 0
sp_cancel_pay_from_customer 605 605 0 0.00 3 4756 78 0 0
sp_cancel_pay_to_supplier 362 362 0 0.00 3 3546 69 0 0
sp_cancel_supplier_invoice 5645 5642 3 0.05 2 18833 865 0 3
sp_cancel_supplier_order 378 378 0 0.00 9 1152243 103724 0 0
sp_cancel_write_off 9658 9658 0 0.00 1 8918 123 0 0
sp_client_order 17929 17929 0 0.00 4 52155 396 0 0
sp_customer_reserve 403500 403500 0 0.00 0 117873 165 0 0
sp_fill_shopping_cart 27788 27788 0 0.00 1 18812 44 0 0
sp_fill_shopping_cart_clo_res 403497 403497 0 0.00 0 26850 18 0 0
sp_get_clo_for_invoice 4370 4370 0 0.00 0 35462 379 0 0
sp_kill_cost_storno 15745 15745 0 0.00 0 14534 53 0 0
sp_kill_qstorno_ret_qs2qd 1013072 1013072 0 0.00 0 24318 34 0 0
sp_kill_qty_storno 534423 534423 0 0.00 0 40344 74 0 0
sp_lock_selected_doc 18513 18513 0 0.00 0 8366 6 0 0
sp_make_cost_storno 24893 24893 0 0.00 0 16517 51 0 0
sp_multiply_rows_for_pdistr 24893 24893 0 0.00 0 7965 29 0 0
sp_multiply_rows_for_qdistr 17929 17929 0 0.00 0 52141 215 0 0
sp_pay_from_customer 6333 6333 0 0.00 4 16710 109 0 0
sp_pay_to_supplier 5247 5247 0 0.00 5 10167 114 0 0
sp_payment_common 11580 11580 0 0.00 1 8313 19 0 0
sp_qd_handle_on_cancel_clo 1615 1615 0 0.00 0 19602 328 0 0
sp_qd_handle_on_invoice_upd_sts 9490 9490 0 0.00 0 40343 361 0 0
sp_qd_handle_on_reserve_upd_sts 8943 8943 0 0.00 0 16807 56 0 0
sp_reserve_write_off 8943 8943 0 0.00 7 16823 176 0 0
sp_supplier_invoice 4903 4903 0 0.00 7 94786 3404 0 0
sp_supplier_order 4965 4965 0 0.00 6 73312 1378 0 0
srv_aggregate_perf_data 97 97 0 0.00 2474 180798 15365 0 0
srv_fill_mon_cache_memory 52 52 0 0.00 1490 134293 50723 0 0
srv_find_qd_qs_mism 937679 937679 0 0.00 0 12731 5 0 0
srv_make_invnt_saldo 405 405 0 0.00 40 107185 3221 0 0
srv_make_money_saldo 683 683 0 0.00 1 9524 419 0 0
srv_recalc_idx_stat 4 4 0 0.00 186383 433801 282432 0 0
t$perf-abend:sp_add_invoice_to_stock 67 67 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4374 4374 0 0.00 0 16837 172 0 0
t$perf-norm:sp_cancel_adding_invoice 380 380 0 0.00 1 2034 97 0 0
t$perf-norm:sp_cancel_client_order 1615 1615 0 0.00 0 2778 12 0 0
t$perf-norm:sp_cancel_customer_reserve 603 603 0 0.00 0 2208 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 605 605 0 0.00 0 640 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 362 362 0 0.00 0 1161 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 351 351 0 0.00 0 2734 19 0 0
t$perf-norm:sp_cancel_supplier_order 378 378 0 0.00 0 16496 1296 0 0
t$perf-norm:sp_cancel_write_off 906 906 0 0.00 0 1936 7 0 0
t$perf-norm:sp_client_order 17929 17929 0 0.00 0 8533 14 0 0
t$perf-norm:sp_customer_reserve 942 942 0 0.00 0 953 4 0 0
t$perf-norm:sp_pay_from_customer 6333 6333 0 0.00 0 14443 10 0 0
t$perf-norm:sp_pay_to_supplier 5247 5247 0 0.00 0 3847 8 0 0
t$perf-norm:sp_reserve_write_off 8943 8943 0 0.00 0 6681 10 0 0
t$perf-norm:sp_supplier_invoice 4903 4903 0 0.00 0 2836 14 0 0
t$perf-norm:sp_supplier_order 4965 4965 0 0.00 0 3505 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 582 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 52 52 0 0.00 0 100 7 0 0
t$perf-norm:srv_make_invnt_saldo 405 405 0 0.00 0 775 9 0 0
t$perf-norm:srv_make_money_saldo 683 683 0 0.00 0 1202 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 89 25 0 0
v_add_invoice_to_stock 8874 8740 134 1.51 0 6794 15 0 134
v_all_customers 32830 32830 0 0.00 0 333 1 0 0
v_all_suppliers 27344 27344 0 0.00 0 347 1 0 0
v_all_wares 35852 35852 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 760 760 0 0.00 0 4625 13 0 0
v_cancel_client_order 3230 3230 0 0.00 0 706 3 0 0
v_cancel_customer_prepayment 1210 1210 0 0.00 0 776 6 0 0
v_cancel_customer_reserve 1206 1206 0 0.00 0 3168 11 0 0
v_cancel_payment_to_supplier 724 724 0 0.00 0 623 4 0 0
v_cancel_supplier_invoice 708 702 6 0.84 0 2064 15 0 6
v_cancel_supplier_order 756 756 0 0.00 0 1198 5 0 0
v_cancel_write_off 1812 1812 0 0.00 0 4621 14 0 0
v_max_id_clo_ord 4963 4963 0 0.00 0 910 1 0 0
v_max_id_clo_res 942 942 0 0.00 0 5118 33 0 0
v_max_id_ord_sup 4898 4898 0 0.00 0 10306 7 0 0
v_max_non_paid_invoice 1436 1436 0 0.00 0 835 2 0 0
v_max_non_paid_realizn 3332 3332 0 0.00 0 4268 4 0 0
v_min_id_clo_ord 4963 4963 0 0.00 0 8652 8 0 0
v_min_id_clo_res 942 942 0 0.00 0 4975 22 0 0
v_min_id_ord_sup 4898 4898 0 0.00 0 10952 10 0 0
v_min_non_paid_invoice 5247 5247 0 0.00 0 5620 10 0 0
v_min_non_paid_realizn 6333 6333 0 0.00 0 7937 14 0 0
v_our_firm 9024 9024 0 0.00 0 650 1 0 0
v_reserve_write_off 17886 17886 0 0.00 0 5363 7 0 0
x_lock_depdocs_on_canc_invoice 10411 10411 0 0.00 0 17570 104 0 0
x_lock_depdocs_on_canc_sup_ord 378 378 0 0.00 0 18269 359 0 0
x_make_qstorno_1000_1200 4965 4965 0 0.00 2 73284 1305 0 0
x_make_qstorno_1200_2000 4903 4903 0 0.00 3 94654 3231 0 0
x_make_qstorno_2100_3300 403500 403500 0 0.00 0 117872 145 0 0

Completed "Performance in DETAILS". Done for 00:00:02, from 19-11-2020 10:14:40 to 19-11-2020 10:14:42.

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
07:56:55 2 8192000000 8796641312 8807108608 3168704 0.038 1 1 2 0 3266400 61840 35856
07:57:56 25305 8192000000 9729603936 10023809024 802651632 8.923 100 89 178 1 832737488 8126976 21958880
07:59:24 29164 8192000000 9767251696 10075144192 839165424 9.291 100 85 170 1 871966624 12497200 20304000
08:00:58 15321 8192000000 9804645888 10125168640 872423664 9.624 100 84 168 0 913322544 21883920 19014960
08:02:21 12392 8192000000 9884666704 10217447424 928937600 10.184 100 87 174 0 995273312 47832416 18503296
08:03:37 9242 8192000000 9938319184 10286485504 972128672 10.607 100 79 156 0 1053829264 65463632 16236960
08:04:47 5987 8192000000 9971983744 10333270016 1007156912 10.948 100 77 155 1 1089021824 65902032 15962880
08:05:56 4301 8192000000 9994886048 10361765888 1035415616 11.221 100 90 181 3 1113403680 60059152 17928912
08:07:02 2039 8192000000 10034021152 10404814848 1052503472 11.385 100 91 182 1 1147432912 75631120 19298320
08:08:06 1280 8192000000 10059026512 10433048576 1071840784 11.570 100 94 188 2 1172318768 81234784 19243200
08:09:08 3612 8192000000 10035827280 10420785152 1076873552 11.618 100 72 143 5 1152431920 60810928 14747440
08:10:11 8160 8192000000 9984299744 10388639744 1082772352 11.674 100 30 62 1 1114065328 24943776 6349200
08:11:21 5247 8192000000 9995451120 10396901376 1089743488 11.740 100 35 70 1 1120910800 24054800 7112512
08:12:31 6012 8192000000 10009957008 10405773312 1090034896 11.743 100 40 82 1 1117713168 18242912 9435360
08:13:39 6688 8192000000 10011864576 10402516992 1091493344 11.757 100 55 112 3 1117103104 13208496 12401264
08:14:46 7007 8192000000 10024635824 10422673408 1095105520 11.791 100 43 86 2 1142201392 37804848 9291024
08:15:58 4274 8192000000 9994096704 10398998528 1086810528 11.712 100 55 110 3 1116418736 16714976 12893232
08:17:05 5479 8192000000 9999808880 10397249536 1073036480 11.581 99 30 62 1 1098481568 19189696 6255392
08:18:11 59954 8192000000 9946808224 10348118016 969078656 10.578 90 35 70 2 1006570240 30138496 7353088
08:20:11 10113 8192000000 9932637888 10320945152 961669504 10.505 94 30 61 0 992342288 23090864 7581920
08:21:23 8588 8192000000 9947898192 10338410496 1003889472 10.916 98 33 65 2 1029722912 18565536 7267904
08:22:32 10443 8192000000 9954304432 10351083520 1029192096 11.161 100 34 69 3 1059150144 22483120 7474928
08:23:43 36941 8192000000 9942677344 10344972288 1038122256 11.247 100 26 52 0 1066130688 21908224 6100208
08:25:25 10837 8192000000 9977699696 10378608640 1056230352 11.420 100 44 86 2 1090959520 24817584 9911584
08:26:37 9449 8192000000 9976962880 10384031744 1064136064 11.496 100 33 65 0 1097082128 25776944 7169120
08:27:50 26052 8192000000 10022209232 10420133888 1082223184 11.669 100 52 102 1 1129031184 35772272 11035728
08:29:21 82798 8192000000 10060509040 10469449728 1100445376 11.842 100 43 86 0 1184721600 75147056 9129168
08:31:49 12021 8192000000 10121871600 10533724160 1111802368 11.949 100 45 87 1 1236147696 114467008 9878320
08:33:06 8887 8192000000 10144587568 10551615488 1120657392 12.033 100 51 100 2 1247692016 116547552 10487072
08:34:24 15348 8192000000 10240719088 10646851584 1137834928 12.195 100 65 129 1 1331614240 179942032 13837280
08:35:45 5728 8192000000 10252653168 10665148416 1143136384 12.245 100 61 122 3 1355693296 197998928 14557984
08:36:56 7283 8192000000 10282964688 10697809920 1165233632 12.452 100 62 121 2 1383423808 204763392 13426784
08:38:07 3412 8192000000 10332035216 10736836608 1174571056 12.540 100 77 148 3 1430346048 239413440 16361552
08:39:14 4016 8192000000 10360298208 10769190912 1174356464 12.538 100 75 148 0 1462830672 271464896 17009312
08:40:21 1487 8192000000 10404407200 10824024064 1176124016 12.554 100 82 163 0 1503389024 309436144 17828864
08:41:26 1569 8192000000 10391540496 10798608384 1167340592 12.472 100 81 162 1 1491492592 305149760 19002240
08:42:31 1965 8192000000 10405264896 10808205312 1136624368 12.184 100 73 145 0 1506802848 353775760 16402720
08:43:35 3230 8192000000 10324692176 10757038080 1151482736 12.323 100 41 82 0 1424195856 263030512 9682608
08:44:42 11848 8192000000 10327595648 10768781312 1119351632 12.021 98 26 52 2 1409532304 283525792 6654880
08:45:57 12907 8192000000 10377499728 10797432832 1125043104 12.075 98 40 80 1 1460922864 325687312 10192448
08:47:24 16233 8192000000 10296407248 10722009088 1125872000 12.082 99 31 62 1 1407736304 273965280 7899024
08:48:47 23969 8192000000 10324477824 10758803456 1121907584 12.045 100 26 50 3 1411731248 282718176 7105488
08:50:14 57726 8192000000 10150971648 10685698048 1100959872 11.847 98 20 40 2 1347068224 240804944 5303408
08:52:19 86838 8192000000 10093772576 10569629696 1036177280 11.228 93 10 20 0 1072087536 33873440 2036816
08:55:45 80654 8192000000 10046599872 10472517632 1107076064 11.905 99 30 60 0 1154095440 40929616 6089760
08:58:08 112696 8192000000 10130052576 10565545984 1126152800 12.085 100 35 70 4 1247318832 112749408 8416624
09:01:20 39127 8192000000 10090000272 10573520896 1114286336 11.973 99 24 48 2 1195757408 75925216 5545856
09:03:05 82207 8192000000 10110084384 10559373312 1104543568 11.881 98 23 46 1 1190188448 80533792 5111088
09:05:39 28740 8192000000 10083085552 10533187584 1127887360 12.101 100 16 32 0 1191508800 60428240 3193200
09:07:10 103282 8192000000 10125634496 10597502976 1123497472 12.060 99 9 18 0 1196269104 70955296 1816336
09:09:54 40351 8192000000 10079005152 10567086080 1125156960 12.076 99 15 30 1 1244334864 115730848 3447056
09:11:37 61438 8192000000 10078477488 10510299136 1132618704 12.146 99 33 67 1 1172560704 32398736 7543264
09:13:43 65172 8192000000 10093040224 10571771904 1127702976 12.100 98 23 46 1 1217748416 85183904 4861536
09:17:09 49150 8192000000 10100484608 10556878848 1136608752 12.184 99 19 38 0 1210246496 69434112 4203632
09:19:03 134292 8192000000 10098788800 10579402752 1113937040 11.970 97 12 24 1 1159506912 43066816 2503056
09:22:29 127587 8192000000 10062966592 10497703936 1131332592 12.134 99 37 76 0 1153736976 14731616 7672768
09:25:37 65237 8192000000 10124622704 10596888576 1136264592 12.180 100 21 41 1 1261540432 120826256 4449584
09:27:43 88821 8192000000 10137092736 10610888704 1097848784 11.817 96 13 26 0 1211327520 110562976 2915760
09:30:12 70301 8192000000 10087507616 10581413888 1115512080 11.985 98 11 22 1 1154536256 36990576 2033600
09:32:25 26018 8192000000 10034810656 10458636288 1094286928 11.783 97 45 90 3 1118469856 14421648 9761280
09:33:51 56350 8192000000 10085647680 10515546112 1068624384 11.539 95 22 44 0 1126374080 52891840 4857856
09:35:48 71806 8192000000 10085871184 10550960128 1083149984 11.677 97 17 34 2 1185555760 98059696 4346080
09:38:00 51521 8192000000 10050901840 10508722176 1110040864 11.933 99 8 16 0 1160078352 48749024 1288464
09:39:56 55545 8192000000 10085862080 10530603008 1098938608 11.828 98 19 38 0 1170575584 67482064 4154912
09:42:56 74315 8192000000 10049289904 10551771136 1088323168 11.727 99 18 36 1 1165091456 72945856 3822432
09:45:39 65779 8192000000 10040809680 10487046144 1102660928 11.863 99 9 19 0 1125484304 21046400 1776976
09:47:56 66044 8192000000 10047125456 10515611648 1106368512 11.898 99 7 14 0 1152055456 44151920 1535024
09:51:19 23272 8192000000 10055250320 10493890560 1122982288 12.055 100 25 50 1 1163795664 35170432 5642944
09:52:43 75542 8192000000 10090035952 10523684864 1121325616 12.040 99 24 46 2 1178807632 52487280 4994736
09:55:36 41512 8192000000 10077791248 10519891968 1085665856 11.701 96 34 68 1 1127378464 34776944 6935664
09:57:31 34592 8192000000 10058858000 10494914560 1121854064 12.045 100 16 32 0 1167587760 42400432 3333264
09:59:09 45199 8192000000 10118230048 10555207680 1134062960 12.160 100 25 50 0 1205813456 66549216 5201280
10:00:57 67473 8192000000 10061754768 10534453248 1101423024 11.851 97 13 26 2 1162560592 58461600 2675968
10:03:11 99454 8192000000 10083263968 10554232832 1110702976 11.939 99 34 68 0 1192887264 75098416 7085872
10:06:07 69197 8192000000 10079956240 10558033920 1121646192 12.043 99 5 10 0 1178226240 55673136 906912
10:08:17 89127 8192000000 10095167568 10539393024 1106174624 11.896 97 16 32 0 1142733392 33231776 3326992
10:10:57 92413 8192000000 10079938384 10552971264 1123158752 12.057 98 21 43 0 1171449872 43838128 4452992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:09, from 19-11-2020 10:14:42 to 19-11-2020 10:14:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 67 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:00, from 19-11-2020 10:14:51 to 19-11-2020 10:14:51.

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          220350
MON$OLDEST_ACTIVE               221815
MON$OLDEST_SNAPSHOT             221797
MON$NEXT_TRANSACTION            221957
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                       2082720
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             766
MON$NEXT_STATEMENT              7238


ISQL Version: LI-V4.0.0.2269 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2269 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2269 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.2269 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 ---
:2642: 
:2643: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2644:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:2645: 
:2646: 
:2647: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2648:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:2649: 
:2650: 
:2651: 
:2652: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2653:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:2654: 
:2655: 
:2656: 
:2657: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2658:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2659:     Uncommitted work may have been lost.
:2660:     Error writing data to the connection.
:2661:     send_packet/send
:2662: 
:2663: 
:2664: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2665:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2666:     Uncommitted work may have been lost.
:2667:     Error writing data to the connection.
:2668:     send_packet/send
:2669: 
:2670: 
:2671: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2672:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2673:     Uncommitted work may have been lost.
:2674:     Error writing data to the connection.
:2675:     send_packet/send
:2676: 
:2677: 
:2678: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2679:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2680:     Uncommitted work may have been lost.
:2681:     Error writing data to the connection.
:2682:     send_packet/send
:2683: 
:2684: 
:2685: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2686:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2687:     Uncommitted work may have been lost.
:2688:     Error writing data to the connection.
:2689:     send_packet/send
:2690: 
:2691: 
:2692: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2693:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2694:     Uncommitted work may have been lost.
:2695:     Error writing data to the connection.
:2696:     send_packet/send
:2697: 
:2698: 
:2699: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2700:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2701:     Uncommitted work may have been lost.
:2702:     Error writing data to the connection.
:2703:     send_packet/send
:2704: 
:2705: 
:2706: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2707:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2708:     Uncommitted work may have been lost.
:2709:     Error writing data to the connection.
:2710:     send_packet/send
:2711: 
:2712: 
:2713: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2714:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2715:     Uncommitted work may have been lost.
:2716:     Error writing data to the connection.
:2717:     send_packet/send
:2718: 
:2719: 
:2720: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2721:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2722:     Uncommitted work may have been lost.
:2723:     Error writing data to the connection.
:2724:     send_packet/send
:2725: 
:2726: 
:2727: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2728:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2729:     Uncommitted work may have been lost.
:2730:     Error writing data to the connection.
:2731:     send_packet/send
:2732: 
:2733: 
:2734: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2735:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2736:     Uncommitted work may have been lost.
:2737:     Error writing data to the connection.
:2738:     send_packet/send
:2739: 
:2740: 
:2741: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2742:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2743:     Uncommitted work may have been lost.
:2744:     Error writing data to the connection.
:2745:     send_packet/send
:2746: 
:2747: 
:2748: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2749:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2750:     Uncommitted work may have been lost.
:2751:     Error writing data to the connection.
:2752:     send_packet/send
:2753: 
:2754: 
:2755: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2756:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2757:     Uncommitted work may have been lost.
:2758:     Error writing data to the connection.
:2759:     send_packet/send
:2760: 
:2761: 
:2762: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2763:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2764:     Uncommitted work may have been lost.
:2765:     Error writing data to the connection.
:2766:     send_packet/send
:2767: 
:2768: 
:2769: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2770:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2771:     Uncommitted work may have been lost.
:2772:     Error writing data to the connection.
:2773:     send_packet/send
:2774: 
:2775: 
:2776: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2777:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2778:     Uncommitted work may have been lost.
:2779:     Error writing data to the connection.
:2780:     send_packet/send
:2781: 
:2782: 
:2783: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2784:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2785:     Uncommitted work may have been lost.
:2786:     Error writing data to the connection.
:2787:     send_packet/send
:2788: 
:2789: 
:2790: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2791:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2792:     Uncommitted work may have been lost.
:2793:     Error writing data to the connection.
:2794:     send_packet/send
:2795: 
:2796: 
:2797: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2798:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2799:     Uncommitted work may have been lost.
:2800:     Error writing data to the connection.
:2801:     send_packet/send
:2802: 
:2803: 
:2804: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2805:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2806:     Uncommitted work may have been lost.
:2807:     Error writing data to the connection.
:2808:     send_packet/send
:2809: 
:2810: 
:2811: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2812:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2813:     Uncommitted work may have been lost.
:2814:     Error writing data to the connection.
:2815:     send_packet/send
:2816: 
:2817: 
:2818: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2819:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2820:     Uncommitted work may have been lost.
:2821:     Error writing data to the connection.
:2822:     send_packet/send
:2823: 
:2824: 
:2825: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2826:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2827:     Uncommitted work may have been lost.
:2828:     Error writing data to the connection.
:2829:     send_packet/send
:2830: 
:2831: 
:2832: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2833:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2834:     Uncommitted work may have been lost.
:2835:     Error writing data to the connection.
:2836:     send_packet/send
:2837: 
:2838: 
:2839: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2840:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2841:     Uncommitted work may have been lost.
:2842:     Error writing data to the connection.
:2843:     send_packet/send
:2844: 
:2845: 
:2846: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2847:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2848:     Uncommitted work may have been lost.
:2849:     Error writing data to the connection.
:2850:     send_packet/send
:2851: 
:2852: 
:2853: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2854:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2855:     Uncommitted work may have been lost.
:2856:     Error writing data to the connection.
:2857:     send_packet/send
:2858: 
:2859: 
:2860: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2861:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2862:     Uncommitted work may have been lost.
:2863:     Error writing data to the connection.
:2864:     send_packet/send
:2865: 
:2866: 
:2867: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2868:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2869:     Uncommitted work may have been lost.
:2870:     Error writing data to the connection.
:2871:     send_packet/send
:2872: 
:2873: 
:2874: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2875:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2876:     Uncommitted work may have been lost.
:2877:     Error writing data to the connection.
:2878:     send_packet/send
:2879: 
:2880: 
:2881: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2882:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2883:     Uncommitted work may have been lost.
:2884:     Error writing data to the connection.
:2885:     send_packet/send
:2886: 
:2887: 
:2888: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2889:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2890:     Uncommitted work may have been lost.
:2891:     Error writing data to the connection.
:2892:     send_packet/send
:2893: 
:2894: 
:2895: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2896:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2897:     Uncommitted work may have been lost.
:2898:     Error writing data to the connection.
:2899:     send_packet/send
:2900: 
:2901: 
:2902: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2903:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2904:     Uncommitted work may have been lost.
:2905:     Error writing data to the connection.
:2906:     send_packet/send
:2907: 
:2908: 
:2909: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2910:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2911:     Uncommitted work may have been lost.
:2912:     Error writing data to the connection.
:2913:     send_packet/send
:2914: 
:2915: 
:2916: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2917:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2918:     Uncommitted work may have been lost.
:2919:     Error writing data to the connection.
:2920:     send_packet/send
:2921: 
:2922: 
:2923: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2924:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2925:     Uncommitted work may have been lost.
:2926:     Error writing data to the connection.
:2927:     send_packet/send
:2928: 
:2929: 
:2930: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2931:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2932:     Uncommitted work may have been lost.
:2933:     Error writing data to the connection.
:2934:     send_packet/send
:2935: 
:2936: 
:2937: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2938:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2939:     Uncommitted work may have been lost.
:2940:     Error writing data to the connection.
:2941:     send_packet/send
:2942: 
:2943: 
:2944: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2945:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2946:     Uncommitted work may have been lost.
:2947:     Error writing data to the connection.
:2948:     send_packet/send
:2949: 
:2950: 
:2951: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2952:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2953:     Uncommitted work may have been lost.
:2954:     Error writing data to the connection.
:2955:     send_packet/send
:2956: 
:2957: 
:2958: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2959:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2960:     Uncommitted work may have been lost.
:2961:     Error writing data to the connection.
:2962:     send_packet/send
:2963: 
:2964: 
:2965: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2966:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2967:     Uncommitted work may have been lost.
:2968:     Error writing data to the connection.
:2969:     send_packet/send
:2970: 
:2971: 
:2972: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2973:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2974:     Uncommitted work may have been lost.
:2975:     Error writing data to the connection.
:2976:     send_packet/send
:2977: 
:2978: 
:2979: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2980:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2981:     Uncommitted work may have been lost.
:2982:     Error writing data to the connection.
:2983:     send_packet/send
:2984: 
:2985: 
:2986: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2987:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2988:     Uncommitted work may have been lost.
:2989:     Error writing data to the connection.
:2990:     send_packet/send
:2991: 
:2992: 
:2993: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:2994:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:2995:     Uncommitted work may have been lost.
:2996:     Error writing data to the connection.
:2997:     send_packet/send
:2998: 
:2999: 
:3000: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3001:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3002:     Uncommitted work may have been lost.
:3003:     Error writing data to the connection.
:3004:     send_packet/send
:3005: 
:3006: 
:3007: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3008:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3009:     Uncommitted work may have been lost.
:3010:     Error writing data to the connection.
:3011:     send_packet/send
:3012: 
:3013: 
:3014: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3015:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3016:     Uncommitted work may have been lost.
:3017:     Error writing data to the connection.
:3018:     send_packet/send
:3019: 
:3020: 
:3021: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3022:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3023:     Uncommitted work may have been lost.
:3024:     Error writing data to the connection.
:3025:     send_packet/send
:3026: 
:3027: 
:3028: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3029:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3030:     Uncommitted work may have been lost.
:3031:     Error writing data to the connection.
:3032:     send_packet/send
:3033: 
:3034: 
:3035: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3036:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3037:     Uncommitted work may have been lost.
:3038:     Error writing data to the connection.
:3039:     send_packet/send
:3040: 
:3041: 
:3042: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3043:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3044:     Uncommitted work may have been lost.
:3045:     Error writing data to the connection.
:3046:     send_packet/send
:3047: 
:3048: 
:3049: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3050:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3051:     Uncommitted work may have been lost.
:3052:     Error writing data to the connection.
:3053:     send_packet/send
:3054: 
:3055: 
:3056: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3057:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3058:     Uncommitted work may have been lost.
:3059:     Error writing data to the connection.
:3060:     send_packet/send
:3061: 
:3062: 
:3063: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3064:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3065:     Uncommitted work may have been lost.
:3066:     Error writing data to the connection.
:3067:     send_packet/send
:3068: 
:3069: 
:3070: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3071:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3072:     Uncommitted work may have been lost.
:3073:     Error writing data to the connection.
:3074:     send_packet/send
:3075: 
:3076: 
:3077: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3078:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3079:     Uncommitted work may have been lost.
:3080:     Error writing data to the connection.
:3081:     send_packet/send
:3082: 
:3083: 
:3084: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3085:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3086:     Uncommitted work may have been lost.
:3087:     Error writing data to the connection.
:3088:     send_packet/send
:3089: 
:3090: 
:3091: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3092:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3093:     Uncommitted work may have been lost.
:3094:     Error writing data to the connection.
:3095:     send_packet/send
:3096: 
:3097: 
:3098: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3099:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3100:     Uncommitted work may have been lost.
:3101:     Error writing data to the connection.
:3102:     send_packet/send
:3103: 
:3104: 
:3105: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3106:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3107:     Uncommitted work may have been lost.
:3108:     Error writing data to the connection.
:3109:     send_packet/send
:3110: 
:3111: 
:3112: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3113:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3114:     Uncommitted work may have been lost.
:3115:     Error writing data to the connection.
:3116:     send_packet/send
:3117: 
:3118: 
:3119: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3120:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3121:     Uncommitted work may have been lost.
:3122:     Error writing data to the connection.
:3123:     send_packet/send
:3124: 
:3125: 
:3126: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3127:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3128:     Uncommitted work may have been lost.
:3129:     Error writing data to the connection.
:3130:     send_packet/send
:3131: 
:3132: 
:3133: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3134:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3135:     Uncommitted work may have been lost.
:3136:     Error writing data to the connection.
:3137:     send_packet/send
:3138: 
:3139: 
:3140: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3141:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3142:     Uncommitted work may have been lost.
:3143:     Error writing data to the connection.
:3144:     send_packet/send
:3145: 
:3146: 
:3147: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3148:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3149:     Uncommitted work may have been lost.
:3150:     Error writing data to the connection.
:3151:     send_packet/send
:3152: 
:3153: 
:3154: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3155:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3156:     Uncommitted work may have been lost.
:3157:     Error writing data to the connection.
:3158:     send_packet/send
:3159: 
:3160: 
:3161: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3162:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3163:     Uncommitted work may have been lost.
:3164:     Error writing data to the connection.
:3165:     send_packet/send
:3166: 
:3167: 
:3168: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3169:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3170:     Uncommitted work may have been lost.
:3171:     Error writing data to the connection.
:3172:     send_packet/send
:3173: 
:3174: 
:3175: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3176:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3177:     Uncommitted work may have been lost.
:3178:     Error writing data to the connection.
:3179:     send_packet/send
:3180: 
:3181: 
:3182: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3183:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3184:     Uncommitted work may have been lost.
:3185:     Error writing data to the connection.
:3186:     send_packet/send
:3187: 
:3188: 
:3189: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3190:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3191:     Uncommitted work may have been lost.
:3192:     Error writing data to the connection.
:3193:     send_packet/send
:3194: 
:3195: 
:3196: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3197:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3198:     Uncommitted work may have been lost.
:3199:     Error writing data to the connection.
:3200:     send_packet/send
:3201: 
:3202: 
:3203: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3204:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3205:     Uncommitted work may have been lost.
:3206:     Error writing data to the connection.
:3207:     send_packet/send
:3208: 
:3209: 
:3210: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3211:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3212:     Uncommitted work may have been lost.
:3213:     Error writing data to the connection.
:3214:     send_packet/send
:3215: 
:3216: 
:3217: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3218:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3219:     Uncommitted work may have been lost.
:3220:     Error writing data to the connection.
:3221:     send_packet/send
:3222: 
:3223: 
:3224: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3225:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3226:     Uncommitted work may have been lost.
:3227:     Error writing data to the connection.
:3228:     send_packet/send
:3229: 
:3230: 
:3231: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3232:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3233:     Uncommitted work may have been lost.
:3234:     Error writing data to the connection.
:3235:     send_packet/send
:3236: 
:3237: 
:3238: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3239:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3240:     Uncommitted work may have been lost.
:3241:     Error writing data to the connection.
:3242:     send_packet/send
:3243: 
:3244: 
:3245: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3246:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3247:     Uncommitted work may have been lost.
:3248:     Error writing data to the connection.
:3249:     send_packet/send
:3250: 
:3251: 
:3252: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3253:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3254:     Uncommitted work may have been lost.
:3255:     Error writing data to the connection.
:3256:     send_packet/send
:3257: 
:3258: 
:3259: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3260:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3261:     Uncommitted work may have been lost.
:3262:     Error writing data to the connection.
:3263:     send_packet/send
:3264: 
:3265: 
:3266: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3267:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3268:     Uncommitted work may have been lost.
:3269:     Error writing data to the connection.
:3270:     send_packet/send
:3271: 
:3272: 
:3273: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3274:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3275:     Uncommitted work may have been lost.
:3276:     Error writing data to the connection.
:3277:     send_packet/send
:3278: 
:3279: 
:3280: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3281:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3282:     Uncommitted work may have been lost.
:3283:     Error writing data to the connection.
:3284:     send_packet/send
:3285: 
:3286: 
:3287: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3288:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3289:     Uncommitted work may have been lost.
:3290:     Error writing data to the connection.
:3291:     send_packet/send
:3292: 
:3293: 
:3294: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3295:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3296:     Uncommitted work may have been lost.
:3297:     Error writing data to the connection.
:3298:     send_packet/send
:3299: 
:3300: 
:3301: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3302:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3303:     Uncommitted work may have been lost.
:3304:     Error writing data to the connection.
:3305:     send_packet/send
:3306: 
:3307: 
:3308: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3309:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3310:     Uncommitted work may have been lost.
:3311:     Error writing data to the connection.
:3312:     send_packet/send
:3313: 
:3314: 
:3315: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3316:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3317:     Uncommitted work may have been lost.
:3318:     Error writing data to the connection.
:3319:     send_packet/send
:3320: 
:3321: 
:3322: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3323:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3324:     Uncommitted work may have been lost.
:3325:     Error writing data to the connection.
:3326:     send_packet/send
:3327: 
:3328: 
:3329: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3330:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3331:     Uncommitted work may have been lost.
:3332:     Error writing data to the connection.
:3333:     send_packet/send
:3334: 
:3335: 
:3336: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:08 2020
:3337:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:3338:     Uncommitted work may have been lost.
:3339:     Error writing data to the connection.
:3340:     send_packet/send
:3341: 
:3342: 
:3343: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:09 2020
:3344:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:3345: 
:3346: 
:3347: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:09 2020
:3348:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:3349: 
:3350: 
:3351: mscs-test-161.budzdorov.ru    Thu Nov 19 10:14:09 2020
:3352:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:3353: 
--- end of diff output ---

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

19.11.20 10:14:51. All 165 logs in /var/tmp/logs-oltp40 are preserved, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-11-19 10:14:51 No severe PSQL-related problems occured
19.11.20 10:14:52. End of report.