Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.11.2020 12:41
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 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 10398660 kB
MemAvailable 30951428 kB
Buffers 0 kB
Cached 20539276 kB
SwapCached 4052 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-18 12:41
DTS_END                         2020-11-18 12:41:45.7410
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          173976
ATT_ID                          604
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: 5205.07 26150 624608
customer order: creation 102.88 369 12345
customer order: refuse 8.65 402 1038
order to supplier: creation 27.61 1582 3313
order to supplier: removal 1.84 177324 221
invoice (draft): creation 27.53 4800 3303
invoice (draft): removal 29.49 1309 3539
invoice accept: apply 24.44 23259 2933
invoice accept: cancel 26.73 1278 3207
customer reserve: creation 2180.04 234 261605
customer reserve: removal 2606.68 97 312801
realization accept: apply 48.56 205 5827
realization accept: cancel 45.20 173 5424
payment from customer: creation 34.40 120 4128
payment from customer: removal 3.68 117 441
payment to supplier: creation 29.26 161 3511
payment to supplier: removal 2.00 106 240
service: total inventory turnovers 1.91 6644 229
service: total monetary turnovers 3.67 1224 440
service: aggregate perf. data 0.50 21910 60
service: refresh index statistics 0.03 281685 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:00, from 18-11-2020 12:42:01 to 18-11-2020 12:42:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2562
TEST_TIME 2 3537
TEST_TIME 3 4455
TEST_TIME 4 5650
TEST_TIME 5 5913
TEST_TIME 6 5783
TEST_TIME 7 5993
TEST_TIME 8 6131
TEST_TIME 9 6733
TEST_TIME 10 6611
TEST_TIME 11 6853
TEST_TIME 12 6764
TEST_TIME 13 7027
TEST_TIME 14 6883
TEST_TIME 15 6952
TEST_TIME 16 7065
TEST_TIME 17 7353
TEST_TIME 18 7346
TEST_TIME 19 7376
TEST_TIME 20 7485
TEST_TIME 21 7947
TEST_TIME 22 7792
TEST_TIME 23 8171
TEST_TIME 24 8347
TEST_TIME 25 8920
TEST_TIME 26 9005
TEST_TIME 27 8995
TEST_TIME 28 9479
TEST_TIME 29 10769
TEST_TIME 30 10608
TEST_TIME 31 10407
TEST_TIME 32 10324
TEST_TIME 33 10137
TEST_TIME 34 9920
TEST_TIME 35 9804
TEST_TIME 36 9932
TEST_TIME 37 9733
TEST_TIME 38 9613
TEST_TIME 39 9455
TEST_TIME 40 9332
TEST_TIME 41 9283
TEST_TIME 42 9449
TEST_TIME 43 9497
TEST_TIME 44 9366
TEST_TIME 45 9282
TEST_TIME 46 9184
TEST_TIME 47 9162
TEST_TIME 48 9184
TEST_TIME 49 9060
TEST_TIME 50 8942
TEST_TIME 51 8885
TEST_TIME 52 8847
TEST_TIME 53 8899
TEST_TIME 54 8865
TEST_TIME 55 8791
TEST_TIME 56 8826
TEST_TIME 57 8925
TEST_TIME 58 8863
TEST_TIME 59 8873
TEST_TIME 60 8907
TEST_TIME 61 8901
TEST_TIME 62 8878
TEST_TIME 63 8959
TEST_TIME 64 8918
TEST_TIME 65 8898
TEST_TIME 66 8956
TEST_TIME 67 8962
TEST_TIME 68 8999
TEST_TIME 69 8871
TEST_TIME 70 8790
TEST_TIME 71 8732
TEST_TIME 72 8657
TEST_TIME 73 8615
TEST_TIME 74 8508
TEST_TIME 75 8406
TEST_TIME 76 8300

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-11-2020 12:42:02 to 18-11-2020 12:42:06.

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 865994 865994 0 0.00 0 28638 9 0 0
doc_list_biud 865992 865992 0 0.00 0 62910 44 0 0
sp_add_invoice_to_stock 3055 2933 122 3.99 50 197391 23260 0 122
sp_cancel_adding_invoice 3207 3207 0 0.00 4 62948 1278 0 0
sp_cancel_client_order 1038 1038 0 0.00 5 7566 403 0 0
sp_cancel_customer_reserve 312801 312801 0 0.00 1 59891 98 0 0
sp_cancel_pay_from_customer 441 441 0 0.00 3 3926 118 0 0
sp_cancel_pay_to_supplier 240 240 0 0.00 4 1871 106 0 0
sp_cancel_supplier_invoice 3551 3539 12 0.33 2 21229 1310 0 12
sp_cancel_supplier_order 221 221 0 0.00 6 1307927 177325 0 0
sp_cancel_write_off 5424 5424 0 0.00 2 21111 174 0 0
sp_client_order 12345 12345 0 0.00 4 34174 370 0 0
sp_customer_reserve 261605 261605 0 0.00 0 75393 234 0 0
sp_fill_shopping_cart 18958 18958 0 0.00 1 47765 60 0 0
sp_fill_shopping_cart_clo_res 261596 261596 0 0.00 0 12865 16 0 0
sp_get_clo_for_invoice 2922 2922 0 0.00 0 54676 398 0 0
sp_kill_cost_storno 9312 9312 0 0.00 0 8998 104 0 0
sp_kill_qstorno_ret_qs2qd 634786 634786 0 0.00 0 59884 52 0 0
sp_kill_qty_storno 334977 334977 0 0.00 0 62910 113 0 0
sp_lock_selected_doc 12199 12199 0 0.00 0 8679 3 0 0
sp_make_cost_storno 16386 16386 0 0.00 0 10972 66 0 0
sp_multiply_rows_for_pdistr 16386 16386 0 0.00 0 7588 42 0 0
sp_multiply_rows_for_qdistr 12345 12345 0 0.00 0 10651 164 0 0
sp_pay_from_customer 4128 4128 0 0.00 4 11236 120 0 0
sp_pay_to_supplier 3511 3511 0 0.00 5 11045 162 0 0
sp_payment_common 7639 7639 0 0.00 1 10899 26 0 0
sp_qd_handle_on_cancel_clo 1038 1038 0 0.00 0 7555 370 0 0
sp_qd_handle_on_invoice_upd_sts 6127 6127 0 0.00 0 62910 558 0 0
sp_qd_handle_on_reserve_upd_sts 5827 5827 0 0.00 0 8447 65 0 0
sp_reserve_write_off 5827 5827 0 0.00 7 10747 206 0 0
sp_supplier_invoice 3303 3303 0 0.00 7 93329 4801 0 0
sp_supplier_order 3313 3313 0 0.00 7 28146 1582 0 0
srv_aggregate_perf_data 60 60 0 0.00 2652 242267 21910 0 0
srv_fill_mon_cache_memory 41 41 0 0.00 1769 115161 35948 0 0
srv_find_qd_qs_mism 596331 596331 0 0.00 0 28638 8 0 0
srv_make_invnt_saldo 229 229 0 0.00 54 118391 6645 0 0
srv_make_money_saldo 440 440 0 0.00 1 28937 1224 0 0
srv_recalc_idx_stat 3 3 0 0.00 156490 475999 281685 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 2933 2933 0 0.00 0 12019 225 0 0
t$perf-norm:sp_cancel_adding_invoice 248 248 0 0.00 1 16140 181 0 0
t$perf-norm:sp_cancel_client_order 1038 1038 0 0.00 0 1091 15 0 0
t$perf-norm:sp_cancel_customer_reserve 437 437 0 0.00 0 1638 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 441 441 0 0.00 0 1786 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 240 240 0 0.00 0 158 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 263 263 0 0.00 0 511 16 0 0
t$perf-norm:sp_cancel_supplier_order 221 221 0 0.00 0 20261 2025 0 0
t$perf-norm:sp_cancel_write_off 564 564 0 0.00 0 3982 14 0 0
t$perf-norm:sp_client_order 12345 12345 0 0.00 0 2997 22 0 0
t$perf-norm:sp_customer_reserve 608 608 0 0.00 0 662 8 0 0
t$perf-norm:sp_pay_from_customer 4128 4128 0 0.00 0 1724 7 0 0
t$perf-norm:sp_pay_to_supplier 3511 3511 0 0.00 0 2415 8 0 0
t$perf-norm:sp_reserve_write_off 5827 5827 0 0.00 0 1738 9 0 0
t$perf-norm:sp_supplier_invoice 3303 3303 0 0.00 0 1808 22 0 0
t$perf-norm:sp_supplier_order 3313 3313 0 0.00 0 1627 21 0 0
t$perf-norm:srv_aggregate_perf_data 60 60 0 0.00 0 872 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 41 41 0 0.00 0 352 16 0 0
t$perf-norm:srv_make_invnt_saldo 229 229 0 0.00 0 1061 19 0 0
t$perf-norm:srv_make_money_saldo 440 440 0 0.00 0 5087 25 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 13 8 0 0
v_add_invoice_to_stock 6084 5840 244 4.01 0 4023 22 0 244
v_all_customers 22074 22074 0 0.00 0 28 1 0 0
v_all_suppliers 17932 17932 0 0.00 0 21 1 0 0
v_all_wares 24690 24690 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 496 496 0 0.00 0 1083 10 0 0
v_cancel_client_order 2076 2076 0 0.00 0 2279 8 0 0
v_cancel_customer_prepayment 882 882 0 0.00 0 563 6 0 0
v_cancel_customer_reserve 874 874 0 0.00 0 2278 8 0 0
v_cancel_payment_to_supplier 480 480 0 0.00 0 737 8 0 0
v_cancel_supplier_invoice 550 526 24 4.36 0 687 16 0 24
v_cancel_supplier_order 442 442 0 0.00 0 2274 11 0 0
v_cancel_write_off 1128 1128 0 0.00 0 4980 22 0 0
v_max_id_clo_ord 3313 3313 0 0.00 0 463 2 0 0
v_max_id_clo_res 608 608 0 0.00 0 1422 11 0 0
v_max_id_ord_sup 3300 3300 0 0.00 0 5792 7 0 0
v_max_non_paid_invoice 1158 1158 0 0.00 0 3999 6 0 0
v_max_non_paid_realizn 2387 2387 0 0.00 0 707 3 0 0
v_min_id_clo_ord 3313 3313 0 0.00 0 1871 8 0 0
v_min_id_clo_res 608 608 0 0.00 0 2709 8 0 0
v_min_id_ord_sup 3300 3300 0 0.00 0 3282 4 0 0
v_min_non_paid_invoice 3511 3511 0 0.00 0 5800 19 0 0
v_min_non_paid_realizn 4128 4128 0 0.00 0 10893 14 0 0
v_our_firm 6098 6098 0 0.00 0 120 1 0 0
v_reserve_write_off 11654 11654 0 0.00 0 3301 7 0 0
x_lock_depdocs_on_canc_invoice 6483 6483 0 0.00 0 21156 172 0 0
x_lock_depdocs_on_canc_sup_ord 221 221 0 0.00 0 9363 584 0 0
x_make_qstorno_1000_1200 3313 3313 0 0.00 2 28085 1459 0 0
x_make_qstorno_1200_2000 3303 3303 0 0.00 4 83117 4572 0 0
x_make_qstorno_2100_3300 261605 261605 0 0.00 0 75392 214 0 0

Completed "Performance in DETAILS". Done for 00:00:02, from 18-11-2020 12:42:06 to 18-11-2020 12:42:08.

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
10:56:54 2 8192000000 8796641312 8807108608 3168704 0.038 1 1 2 0 3266400 61840 35856
10:57:55 31776 8192000000 9718990736 10016645120 798294848 8.879 100 86 171 0 827062528 7341632 21426048
10:59:30 324 8192000000 9752267360 10054643712 830026432 9.200 100 88 176 0 863411504 11860928 21524144
11:00:41 13746 8192000000 9791432624 10107342848 863355696 9.534 100 88 176 1 901759024 17927008 20476320
11:02:02 11036 8192000000 9863876960 10194759680 909813136 9.995 100 77 154 0 971280288 44588512 16878640
11:03:17 8959 8192000000 9912518768 10254950400 948629520 10.378 100 76 152 0 1024441936 59758976 16053440
11:04:27 5762 8192000000 9954190800 10303184896 987622896 10.758 100 89 178 0 1068108496 62209664 18275936
11:05:37 3711 8192000000 9988490336 10348294144 1017739792 11.050 100 84 165 1 1098712320 63932048 17040480
11:06:43 3086 8192000000 10034002496 10399629312 1039619184 11.261 100 93 187 2 1150779680 93217232 17943264
11:07:48 1601 8192000000 10033772976 10403184640 1057770544 11.435 100 92 185 4 1146110672 69945840 18394288
11:08:52 5682 8192000000 10008842320 10385256448 1063253344 11.488 100 73 146 2 1128404320 49082256 16068720
11:09:59 4849 8192000000 9984926032 10372055040 1068923152 11.542 100 45 88 1 1102428400 24149488 9355760
11:11:04 11111 8192000000 9981814416 10385334272 1077384528 11.623 100 29 57 2 1102681680 19507616 5789536
11:12:16 8630 8192000000 10008848128 10394718208 1084013104 11.686 100 61 123 1 1106392816 8823088 13556624
11:13:26 5027 8192000000 10018111536 10416398336 1086694128 11.711 100 38 76 1 1120944416 26358304 7891984
11:14:35 5945 8192000000 9998460256 10398560256 1090669984 11.749 100 37 73 1 1108858352 10019888 8168480
11:15:43 75761 8192000000 10002491616 10413101056 1085151296 11.697 99 22 44 1 1104787744 15409584 4226864
11:18:02 5193 8192000000 9986688528 10381377536 1064381456 11.498 98 32 63 0 1086650816 15276576 6992784
11:19:09 5501 8192000000 9987429696 10378395648 1050278720 11.363 98 36 73 2 1087641824 28784224 8578880
11:20:18 16595 8192000000 9934226976 10311184384 960584576 10.495 93 26 52 2 989029488 23242896 5202016
11:21:35 19286 8192000000 9939545760 10333868032 987623984 10.758 96 11 22 0 1020947088 31375408 1947696
11:22:55 5900 8192000000 9926282560 10304774144 1000206176 10.881 98 43 86 2 1026092000 16687840 9197984
11:24:03 3626 8192000000 9954530432 10348388352 1048255392 11.344 100 37 75 4 1082953696 25887984 8810320
11:25:08 19846 8192000000 9968274384 10368704512 1060891904 11.465 100 41 82 1 1079609280 9378144 9339232
11:26:29 13766 8192000000 9990846224 10399838208 1073972752 11.590 100 26 51 3 1108714000 29652112 5089136
11:27:54 6228 8192000000 10024813248 10419417088 1091489232 11.757 100 53 104 2 1137528432 35213600 10825600
11:29:02 18377 8192000000 10073930688 10471673856 1104117120 11.877 100 59 118 2 1177428000 61727840 11583040
11:30:38 19978 8192000000 10118573232 10528915456 1130855536 12.129 100 53 105 2 1215104976 73599968 10649472
11:32:00 26584 8192000000 10136449696 10545938432 1140646144 12.222 100 43 86 2 1234869520 84408800 9814576
11:33:37 5145 8192000000 10173719776 10582609920 1153913792 12.346 100 65 130 1 1281372528 112389552 15069184
11:34:45 4004 8192000000 10223718704 10636333056 1162196304 12.424 100 69 138 0 1328964384 151541056 15227024
11:35:52 3488 8192000000 10257285760 10661883904 1169500144 12.492 100 73 141 2 1350285408 165841968 14943296
11:37:02 7794 8192000000 10263084640 10678513664 1174617360 12.540 100 59 117 0 1366616192 179340064 12658768
11:38:15 3573 8192000000 10258427088 10669191168 1178289504 12.574 100 66 127 0 1358329760 166420864 13619392
11:39:24 6957 8192000000 10316162688 10731847680 1174958832 12.543 100 63 126 2 1418929856 229914160 14056864
11:40:34 10729 8192000000 10302639776 10722443264 1185110864 12.638 100 57 114 0 1402523184 204121280 13291040
11:41:50 2365 8192000000 10343530752 10756546560 1185087200 12.638 100 71 135 1 1451659248 251216496 15355552
11:43:00 1768 8192000000 10364802560 10774970368 1177454560 12.566 100 68 136 1 1467532992 273983968 16094464
11:44:07 4455 8192000000 10400570912 10805071872 1175589696 12.549 100 85 170 1 1493193088 297885824 19717568
11:45:19 3419 8192000000 10453417296 10854969344 1164789584 12.448 100 89 177 0 1542443744 357820400 19833760
11:46:30 2597 8192000000 10488972384 10896171008 1165731312 12.457 100 87 171 1 1587662592 401623456 20307824
11:47:38 3844 8192000000 10504243296 10913636352 1155162496 12.358 100 65 128 0 1600582288 430833264 14586528
11:48:49 2057 8192000000 10509806496 10915745792 1144918656 12.262 100 88 174 0 1605393040 438969760 21504624
11:49:57 9745 8192000000 10488584320 10923024384 1150234624 12.312 100 47 94 0 1582448112 419921808 12291680
11:51:09 13254 8192000000 10406974832 10830569472 1155258448 12.359 100 36 71 1 1526420272 361920304 9241520
11:52:27 17495 8192000000 10395076144 10862108672 1152810960 12.336 100 29 58 0 1507224112 347442080 6971072
11:53:48 27929 8192000000 10395738400 10858110976 1102022448 11.857 99 20 39 3 1496513200 388855824 5634928
11:55:20 16625 8192000000 10151382352 10638540800 1093062256 11.772 98 21 42 0 1255299680 157223680 5013744
11:56:42 97154 8192000000 10084033760 10526949376 1083400352 11.680 97 19 39 2 1166726464 79196624 4129488
11:59:23 115161 8192000000 10108094544 10559389696 1090892736 11.751 97 22 44 0 1170063792 74285040 4886016
12:02:21 57107 8192000000 10055245488 10528120832 1097467360 11.814 98 17 35 0 1201433904 100482112 3484432
12:04:18 90085 8192000000 10132825824 10568650752 1141289136 12.228 100 33 63 2 1212855280 64414832 7151312
12:06:54 108909 8192000000 10144698272 10712215552 1125550560 12.079 98 27 55 2 1283655760 151486048 6619152
12:09:53 68031 8192000000 10063354016 10488844288 1117658608 12.005 98 31 61 1 1152120928 28087392 6374928
12:12:02 45585 8192000000 10105817120 10541023232 1116684864 11.996 98 32 63 1 1183497856 59786176 7026816
12:13:52 46035 8192000000 10087310448 10557870080 1119672160 12.024 99 12 25 1 1173231600 50854592 2704848
12:16:04 70774 8192000000 10125096816 10587193344 1145102384 12.264 100 15 31 0 1234083088 85475888 3504816
12:19:48 78009 8192000000 10065564272 10507264000 1108796784 11.921 97 8 15 1 1153623264 42881856 1944624
12:22:18 89495 8192000000 10073429744 10561765376 1134686800 12.166 99 17 33 1 1218634800 80840880 3107120
12:24:48 17489 8192000000 10101567040 10537000960 1136929152 12.187 99 33 66 2 1175554512 31936608 6688752
12:26:21 31501 8192000000 10092145072 10522144768 1125904656 12.083 98 44 88 0 1169544848 34356288 9283904
12:27:52 50966 8192000000 10123649168 10563387392 1120019072 12.027 97 29 58 1 1182171520 56561824 5590624
12:29:49 54397 8192000000 10063151328 10495283200 1083861008 11.684 95 19 38 0 1107606528 20046336 3699184
12:31:45 90811 8192000000 10071832304 10529140736 1058900432 11.446 94 42 84 0 1148063104 81171696 7990976
12:34:18 103595 8192000000 10064354560 10573713408 1109431984 11.927 99 7 14 0 1155143696 44367568 1344144
12:37:02 40320 8192000000 10048100752 10497781760 1118109584 12.009 100 12 24 1 1136486144 16244272 2132288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:08, from 18-11-2020 12:42:09 to 18-11-2020 12:42:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:00, from 18-11-2020 12:42:17 to 18-11-2020 12:42:17.

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          171617
MON$OLDEST_ACTIVE               174442
MON$OLDEST_SNAPSHOT             174410
MON$NEXT_TRANSACTION            174598
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                       2058976
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             638
MON$NEXT_STATEMENT              6990


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 ---
:1066: 
:1067: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1068:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:1069: 
:1070: 
:1071: 
:1072: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1073:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:1074: 
:1075: 
:1076: 
:1077: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1078:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1079:     Uncommitted work may have been lost.
:1080:     Error writing data to the connection.
:1081:     send_packet/send
:1082: 
:1083: 
:1084: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1085:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1086:     Uncommitted work may have been lost.
:1087:     Error writing data to the connection.
:1088:     send_packet/send
:1089: 
:1090: 
:1091: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1092:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1093:     Uncommitted work may have been lost.
:1094:     Error writing data to the connection.
:1095:     send_packet/send
:1096: 
:1097: 
:1098: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1099:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1100:     Uncommitted work may have been lost.
:1101:     Error writing data to the connection.
:1102:     send_packet/send
:1103: 
:1104: 
:1105: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1106:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1107:     Uncommitted work may have been lost.
:1108:     Error writing data to the connection.
:1109:     send_packet/send
:1110: 
:1111: 
:1112: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1113:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1114:     Uncommitted work may have been lost.
:1115:     Error writing data to the connection.
:1116:     send_packet/send
:1117: 
:1118: 
:1119: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1120:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1121:     Uncommitted work may have been lost.
:1122:     Error writing data to the connection.
:1123:     send_packet/send
:1124: 
:1125: 
:1126: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1127:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1128:     Uncommitted work may have been lost.
:1129:     Error writing data to the connection.
:1130:     send_packet/send
:1131: 
:1132: 
:1133: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1134:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1135:     Uncommitted work may have been lost.
:1136:     Error writing data to the connection.
:1137:     send_packet/send
:1138: 
:1139: 
:1140: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1141:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1142:     Uncommitted work may have been lost.
:1143:     Error writing data to the connection.
:1144:     send_packet/send
:1145: 
:1146: 
:1147: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1148:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1149:     Uncommitted work may have been lost.
:1150:     Error writing data to the connection.
:1151:     send_packet/send
:1152: 
:1153: 
:1154: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1155:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1156:     Uncommitted work may have been lost.
:1157:     Error writing data to the connection.
:1158:     send_packet/send
:1159: 
:1160: 
:1161: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1162:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1163:     Uncommitted work may have been lost.
:1164:     Error writing data to the connection.
:1165:     send_packet/send
:1166: 
:1167: 
:1168: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1169:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1170:     Uncommitted work may have been lost.
:1171:     Error writing data to the connection.
:1172:     send_packet/send
:1173: 
:1174: 
:1175: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1176:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1177:     Uncommitted work may have been lost.
:1178:     Error writing data to the connection.
:1179:     send_packet/send
:1180: 
:1181: 
:1182: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1183:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1184:     Uncommitted work may have been lost.
:1185:     Error writing data to the connection.
:1186:     send_packet/send
:1187: 
:1188: 
:1189: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1190:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1191:     Uncommitted work may have been lost.
:1192:     Error writing data to the connection.
:1193:     send_packet/send
:1194: 
:1195: 
:1196: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1197:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1198:     Uncommitted work may have been lost.
:1199:     Error writing data to the connection.
:1200:     send_packet/send
:1201: 
:1202: 
:1203: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1204:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1205:     Uncommitted work may have been lost.
:1206:     Error writing data to the connection.
:1207:     send_packet/send
:1208: 
:1209: 
:1210: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1211:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1212:     Uncommitted work may have been lost.
:1213:     Error writing data to the connection.
:1214:     send_packet/send
:1215: 
:1216: 
:1217: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1218:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1219:     Uncommitted work may have been lost.
:1220:     Error writing data to the connection.
:1221:     send_packet/send
:1222: 
:1223: 
:1224: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1225:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1226:     Uncommitted work may have been lost.
:1227:     Error writing data to the connection.
:1228:     send_packet/send
:1229: 
:1230: 
:1231: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1232:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1233:     Uncommitted work may have been lost.
:1234:     Error writing data to the connection.
:1235:     send_packet/send
:1236: 
:1237: 
:1238: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1239:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1240:     Uncommitted work may have been lost.
:1241:     Error writing data to the connection.
:1242:     send_packet/send
:1243: 
:1244: 
:1245: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1246:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1247:     Uncommitted work may have been lost.
:1248:     Error writing data to the connection.
:1249:     send_packet/send
:1250: 
:1251: 
:1252: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1253:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1254:     Uncommitted work may have been lost.
:1255:     Error writing data to the connection.
:1256:     send_packet/send
:1257: 
:1258: 
:1259: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1260:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1261:     Uncommitted work may have been lost.
:1262:     Error writing data to the connection.
:1263:     send_packet/send
:1264: 
:1265: 
:1266: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1267:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1268:     Uncommitted work may have been lost.
:1269:     Error writing data to the connection.
:1270:     send_packet/send
:1271: 
:1272: 
:1273: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1274:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1275:     Uncommitted work may have been lost.
:1276:     Error writing data to the connection.
:1277:     send_packet/send
:1278: 
:1279: 
:1280: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1281:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1282:     Uncommitted work may have been lost.
:1283:     Error writing data to the connection.
:1284:     send_packet/send
:1285: 
:1286: 
:1287: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1288:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1289:     Uncommitted work may have been lost.
:1290:     Error writing data to the connection.
:1291:     send_packet/send
:1292: 
:1293: 
:1294: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1295:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1296:     Uncommitted work may have been lost.
:1297:     Error writing data to the connection.
:1298:     send_packet/send
:1299: 
:1300: 
:1301: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1302:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1303:     Uncommitted work may have been lost.
:1304:     Error writing data to the connection.
:1305:     send_packet/send
:1306: 
:1307: 
:1308: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1309:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1310:     Uncommitted work may have been lost.
:1311:     Error writing data to the connection.
:1312:     send_packet/send
:1313: 
:1314: 
:1315: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1316:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1317:     Uncommitted work may have been lost.
:1318:     Error writing data to the connection.
:1319:     send_packet/send
:1320: 
:1321: 
:1322: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1323:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1324:     Uncommitted work may have been lost.
:1325:     Error writing data to the connection.
:1326:     send_packet/send
:1327: 
:1328: 
:1329: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1330:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1331:     Uncommitted work may have been lost.
:1332:     Error writing data to the connection.
:1333:     send_packet/send
:1334: 
:1335: 
:1336: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1337:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1338:     Uncommitted work may have been lost.
:1339:     Error writing data to the connection.
:1340:     send_packet/send
:1341: 
:1342: 
:1343: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1344:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1345:     Uncommitted work may have been lost.
:1346:     Error writing data to the connection.
:1347:     send_packet/send
:1348: 
:1349: 
:1350: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1351:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1352:     Uncommitted work may have been lost.
:1353:     Error writing data to the connection.
:1354:     send_packet/send
:1355: 
:1356: 
:1357: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1358:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1359:     Uncommitted work may have been lost.
:1360:     Error writing data to the connection.
:1361:     send_packet/send
:1362: 
:1363: 
:1364: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1365:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1366:     Uncommitted work may have been lost.
:1367:     Error writing data to the connection.
:1368:     send_packet/send
:1369: 
:1370: 
:1371: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1372:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1373:     Uncommitted work may have been lost.
:1374:     Error writing data to the connection.
:1375:     send_packet/send
:1376: 
:1377: 
:1378: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1379:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1380:     Uncommitted work may have been lost.
:1381:     Error writing data to the connection.
:1382:     send_packet/send
:1383: 
:1384: 
:1385: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1386:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1387:     Uncommitted work may have been lost.
:1388:     Error writing data to the connection.
:1389:     send_packet/send
:1390: 
:1391: 
:1392: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1393:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1394:     Uncommitted work may have been lost.
:1395:     Error writing data to the connection.
:1396:     send_packet/send
:1397: 
:1398: 
:1399: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1400:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1401:     Uncommitted work may have been lost.
:1402:     Error writing data to the connection.
:1403:     send_packet/send
:1404: 
:1405: 
:1406: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1407:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1408:     Uncommitted work may have been lost.
:1409:     Error writing data to the connection.
:1410:     send_packet/send
:1411: 
:1412: 
:1413: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1414:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1415:     Uncommitted work may have been lost.
:1416:     Error writing data to the connection.
:1417:     send_packet/send
:1418: 
:1419: 
:1420: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1421:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1422:     Uncommitted work may have been lost.
:1423:     Error writing data to the connection.
:1424:     send_packet/send
:1425: 
:1426: 
:1427: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1428:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1429:     Uncommitted work may have been lost.
:1430:     Error writing data to the connection.
:1431:     send_packet/send
:1432: 
:1433: 
:1434: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1435:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1436:     Uncommitted work may have been lost.
:1437:     Error writing data to the connection.
:1438:     send_packet/send
:1439: 
:1440: 
:1441: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1442:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1443:     Uncommitted work may have been lost.
:1444:     Error writing data to the connection.
:1445:     send_packet/send
:1446: 
:1447: 
:1448: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1449:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1450:     Uncommitted work may have been lost.
:1451:     Error writing data to the connection.
:1452:     send_packet/send
:1453: 
:1454: 
:1455: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1456:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1457:     Uncommitted work may have been lost.
:1458:     Error writing data to the connection.
:1459:     send_packet/send
:1460: 
:1461: 
:1462: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1463:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1464:     Uncommitted work may have been lost.
:1465:     Error writing data to the connection.
:1466:     send_packet/send
:1467: 
:1468: 
:1469: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1470:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1471:     Uncommitted work may have been lost.
:1472:     Error writing data to the connection.
:1473:     send_packet/send
:1474: 
:1475: 
:1476: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1477:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1478:     Uncommitted work may have been lost.
:1479:     Error writing data to the connection.
:1480:     send_packet/send
:1481: 
:1482: 
:1483: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1484:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1485:     Uncommitted work may have been lost.
:1486:     Error writing data to the connection.
:1487:     send_packet/send
:1488: 
:1489: 
:1490: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1491:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1492:     Uncommitted work may have been lost.
:1493:     Error writing data to the connection.
:1494:     send_packet/send
:1495: 
:1496: 
:1497: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1498:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1499:     Uncommitted work may have been lost.
:1500:     Error writing data to the connection.
:1501:     send_packet/send
:1502: 
:1503: 
:1504: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1505:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1506:     Uncommitted work may have been lost.
:1507:     Error writing data to the connection.
:1508:     send_packet/send
:1509: 
:1510: 
:1511: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1512:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1513:     Uncommitted work may have been lost.
:1514:     Error writing data to the connection.
:1515:     send_packet/send
:1516: 
:1517: 
:1518: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1519:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1520:     Uncommitted work may have been lost.
:1521:     Error writing data to the connection.
:1522:     send_packet/send
:1523: 
:1524: 
:1525: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1526:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1527:     Uncommitted work may have been lost.
:1528:     Error writing data to the connection.
:1529:     send_packet/send
:1530: 
:1531: 
:1532: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1533:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1534:     Uncommitted work may have been lost.
:1535:     Error writing data to the connection.
:1536:     send_packet/send
:1537: 
:1538: 
:1539: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1540:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1541:     Uncommitted work may have been lost.
:1542:     Error writing data to the connection.
:1543:     send_packet/send
:1544: 
:1545: 
:1546: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1547:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1548:     Uncommitted work may have been lost.
:1549:     Error writing data to the connection.
:1550:     send_packet/send
:1551: 
:1552: 
:1553: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1554:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1555:     Uncommitted work may have been lost.
:1556:     Error writing data to the connection.
:1557:     send_packet/send
:1558: 
:1559: 
:1560: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1561:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1562:     Uncommitted work may have been lost.
:1563:     Error writing data to the connection.
:1564:     send_packet/send
:1565: 
:1566: 
:1567: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1568:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1569:     Uncommitted work may have been lost.
:1570:     Error writing data to the connection.
:1571:     send_packet/send
:1572: 
:1573: 
:1574: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1575:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1576:     Uncommitted work may have been lost.
:1577:     Error writing data to the connection.
:1578:     send_packet/send
:1579: 
:1580: 
:1581: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1582:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1583:     Uncommitted work may have been lost.
:1584:     Error writing data to the connection.
:1585:     send_packet/send
:1586: 
:1587: 
:1588: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1589:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1590:     Uncommitted work may have been lost.
:1591:     Error writing data to the connection.
:1592:     send_packet/send
:1593: 
:1594: 
:1595: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1596:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1597:     Uncommitted work may have been lost.
:1598:     Error writing data to the connection.
:1599:     send_packet/send
:1600: 
:1601: 
:1602: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1603:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1604:     Uncommitted work may have been lost.
:1605:     Error writing data to the connection.
:1606:     send_packet/send
:1607: 
:1608: 
:1609: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1610:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1611:     Uncommitted work may have been lost.
:1612:     Error writing data to the connection.
:1613:     send_packet/send
:1614: 
:1615: 
:1616: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1617:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1618:     Uncommitted work may have been lost.
:1619:     Error writing data to the connection.
:1620:     send_packet/send
:1621: 
:1622: 
:1623: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1624:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1625:     Uncommitted work may have been lost.
:1626:     Error writing data to the connection.
:1627:     send_packet/send
:1628: 
:1629: 
:1630: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1631:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1632:     Uncommitted work may have been lost.
:1633:     Error writing data to the connection.
:1634:     send_packet/send
:1635: 
:1636: 
:1637: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1638:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1639:     Uncommitted work may have been lost.
:1640:     Error writing data to the connection.
:1641:     send_packet/send
:1642: 
:1643: 
:1644: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1645:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1646:     Uncommitted work may have been lost.
:1647:     Error writing data to the connection.
:1648:     send_packet/send
:1649: 
:1650: 
:1651: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1652:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1653:     Uncommitted work may have been lost.
:1654:     Error writing data to the connection.
:1655:     send_packet/send
:1656: 
:1657: 
:1658: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1659:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1660:     Uncommitted work may have been lost.
:1661:     Error writing data to the connection.
:1662:     send_packet/send
:1663: 
:1664: 
:1665: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1666:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1667:     Uncommitted work may have been lost.
:1668:     Error writing data to the connection.
:1669:     send_packet/send
:1670: 
:1671: 
:1672: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1673:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1674:     Uncommitted work may have been lost.
:1675:     Error writing data to the connection.
:1676:     send_packet/send
:1677: 
:1678: 
:1679: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1680:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1681:     Uncommitted work may have been lost.
:1682:     Error writing data to the connection.
:1683:     send_packet/send
:1684: 
:1685: 
:1686: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1687:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1688:     Uncommitted work may have been lost.
:1689:     Error writing data to the connection.
:1690:     send_packet/send
:1691: 
:1692: 
:1693: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1694:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1695:     Uncommitted work may have been lost.
:1696:     Error writing data to the connection.
:1697:     send_packet/send
:1698: 
:1699: 
:1700: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1701:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1702:     Uncommitted work may have been lost.
:1703:     Error writing data to the connection.
:1704:     send_packet/send
:1705: 
:1706: 
:1707: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1708:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1709:     Uncommitted work may have been lost.
:1710:     Error writing data to the connection.
:1711:     send_packet/send
:1712: 
:1713: 
:1714: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1715:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1716:     Uncommitted work may have been lost.
:1717:     Error writing data to the connection.
:1718:     send_packet/send
:1719: 
:1720: 
:1721: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1722:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1723:     Uncommitted work may have been lost.
:1724:     Error writing data to the connection.
:1725:     send_packet/send
:1726: 
:1727: 
:1728: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1729:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1730:     Uncommitted work may have been lost.
:1731:     Error writing data to the connection.
:1732:     send_packet/send
:1733: 
:1734: 
:1735: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1736:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1737:     Uncommitted work may have been lost.
:1738:     Error writing data to the connection.
:1739:     send_packet/send
:1740: 
:1741: 
:1742: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1743:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1744:     Uncommitted work may have been lost.
:1745:     Error writing data to the connection.
:1746:     send_packet/send
:1747: 
:1748: 
:1749: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1750:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1751:     Uncommitted work may have been lost.
:1752:     Error writing data to the connection.
:1753:     send_packet/send
:1754: 
:1755: 
:1756: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:38 2020
:1757:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1758:     Uncommitted work may have been lost.
:1759:     Error writing data to the connection.
:1760:     send_packet/send
:1761: 
:1762: 
:1763: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1764:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:1765: 
:1766: 
:1767: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1768:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:1769: 
:1770: 
:1771: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1772:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:1773: 
:1774: 
:1775: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1776:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:1777: 
:1778: 
:1779: 
:1780: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1781:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:1782: 
:1783: 
:1784: 
:1785: mscs-test-161.budzdorov.ru    Wed Nov 18 12:41:39 2020
:1786:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:1787: 
--- end of diff output ---

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

18.11.20 12:42:17. All 48 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-18 12:42:18 No severe PSQL-related problems occured
18.11.20 12:42:18. End of report.