Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.11.2020 19:27
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 11238636 kB
MemAvailable 30986748 kB
Buffers 0 kB
Cached 19752352 kB
SwapCached 3652 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-20 19:27:53
DTS_END                         2020-11-20 19:27:53.8160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34326
TRN_ID                          233695
ATT_ID                          717
EXC_UNIT                        2


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: 9226.91 21605 1107229
customer order: creation 165.75 402 19890
customer order: refuse 14.32 349 1718
order to supplier: creation 42.72 1426 5126
order to supplier: removal 3.51 113556 421
invoice (draft): creation 43.86 3507 5263
invoice (draft): removal 54.90 799 6588
invoice accept: apply 39.29 18434 4715
invoice accept: cancel 49.72 717 5966
customer reserve: creation 3655.64 179 438677
customer reserve: removal 4864.93 64 583792
realization accept: apply 79.68 173 9562
realization accept: cancel 88.06 116 10567
payment from customer: creation 57.32 126 6878
payment from customer: removal 5.58 82 669
payment to supplier: creation 46.63 121 5596
payment to supplier: removal 3.33 63 399
service: total inventory turnovers 4.35 1071 522
service: total monetary turnovers 6.52 39 782
service: aggregate perf. data 0.78 19095 94
service: refresh index statistics 0.03 271790 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-11-2020 19:28:17 to 20-11-2020 19:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1489
TEST_TIME 2 1718
TEST_TIME 3 2621
TEST_TIME 4 3610
TEST_TIME 5 4248
TEST_TIME 6 4523
TEST_TIME 7 4716
TEST_TIME 8 5206
TEST_TIME 9 5100
TEST_TIME 10 5057
TEST_TIME 11 5158
TEST_TIME 12 5216
TEST_TIME 13 5540
TEST_TIME 14 5825
TEST_TIME 15 6393
TEST_TIME 16 6645
TEST_TIME 17 6796
TEST_TIME 18 6804
TEST_TIME 19 6978
TEST_TIME 20 7432
TEST_TIME 21 7768
TEST_TIME 22 8020
TEST_TIME 23 8168
TEST_TIME 24 8336
TEST_TIME 25 8541
TEST_TIME 26 8674
TEST_TIME 27 9008
TEST_TIME 28 9340
TEST_TIME 29 10501
TEST_TIME 30 10965
TEST_TIME 31 10645
TEST_TIME 32 10352
TEST_TIME 33 10151
TEST_TIME 34 10015
TEST_TIME 35 9876
TEST_TIME 36 9895
TEST_TIME 37 9763
TEST_TIME 38 9605
TEST_TIME 39 9718
TEST_TIME 40 9669
TEST_TIME 41 9496
TEST_TIME 42 9344
TEST_TIME 43 9338
TEST_TIME 44 9528
TEST_TIME 45 9435
TEST_TIME 46 9454
TEST_TIME 47 9380
TEST_TIME 48 9432
TEST_TIME 49 9436
TEST_TIME 50 9406
TEST_TIME 51 9496
TEST_TIME 52 9417
TEST_TIME 53 9478
TEST_TIME 54 9468
TEST_TIME 55 9529
TEST_TIME 56 9488
TEST_TIME 57 9454
TEST_TIME 58 9375
TEST_TIME 59 9290
TEST_TIME 60 9369
TEST_TIME 61 9249
TEST_TIME 62 9330
TEST_TIME 63 9264
TEST_TIME 64 9185
TEST_TIME 65 9122
TEST_TIME 66 9106
TEST_TIME 67 9091
TEST_TIME 68 9067
TEST_TIME 69 9055
TEST_TIME 70 9061
TEST_TIME 71 9137
TEST_TIME 72 9185
TEST_TIME 73 9197
TEST_TIME 74 9226
TEST_TIME 75 9229
TEST_TIME 76 9189
TEST_TIME 77 9217
TEST_TIME 78 9279
TEST_TIME 79 9333
TEST_TIME 80 9247
TEST_TIME 81 9176
TEST_TIME 82 9172
TEST_TIME 83 9117
TEST_TIME 84 9163
TEST_TIME 85 9129
TEST_TIME 86 9118
TEST_TIME 87 9114
TEST_TIME 88 9106
TEST_TIME 89 9117
TEST_TIME 90 9145
TEST_TIME 91 9137
TEST_TIME 92 9166
TEST_TIME 93 9191
TEST_TIME 94 9225
TEST_TIME 95 9271
TEST_TIME 96 9289
TEST_TIME 97 9337
TEST_TIME 98 9336
TEST_TIME 99 9425
TEST_TIME 100 9354
TEST_TIME 101 9327
TEST_TIME 102 9300
TEST_TIME 103 9256
TEST_TIME 104 9310
TEST_TIME 105 9272
TEST_TIME 106 9253
TEST_TIME 107 9224
TEST_TIME 108 9220
TEST_TIME 109 9175
TEST_TIME 110 9131
TEST_TIME 111 9100
TEST_TIME 112 9224
TEST_TIME 113 9223
TEST_TIME 114 9201
TEST_TIME 115 9254
TEST_TIME 116 9301
TEST_TIME 117 9311
TEST_TIME 118 9285
TEST_TIME 119 9304
TEST_TIME 120 9264

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-11-2020 19:28:20 to 20-11-2020 19:28:24.

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 1514187 1514187 0 0.00 0 19858 6 0 0
doc_list_biud 1514181 1514181 0 0.00 0 64964 31 0 0
sp_add_invoice_to_stock 4836 4715 121 2.50 17 175803 18435 0 121
sp_cancel_adding_invoice 5966 5966 0 0.00 5 81175 718 0 0
sp_cancel_client_order 1718 1718 0 0.00 5 9814 350 0 0
sp_cancel_customer_reserve 583792 583792 0 0.00 1 64965 65 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 4139 83 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 2081 64 0 0
sp_cancel_supplier_invoice 6597 6588 9 0.13 2 46718 800 0 9
sp_cancel_supplier_order 421 421 0 0.00 5 1048590 113556 0 0
sp_cancel_write_off 10567 10567 0 0.00 1 19043 117 0 0
sp_client_order 19890 19890 0 0.00 3 40411 403 0 0
sp_customer_reserve 438677 438677 0 0.00 0 69174 179 0 0
sp_fill_shopping_cart 30250 30250 0 0.00 1 10158 38 0 0
sp_fill_shopping_cart_clo_res 438671 438671 0 0.00 0 27518 16 0 0
sp_get_clo_for_invoice 4709 4709 0 0.00 0 47405 461 0 0
sp_kill_cost_storno 17601 17601 0 0.00 0 7143 59 0 0
sp_kill_qstorno_ret_qs2qd 1185160 1185160 0 0.00 0 64959 35 0 0
sp_kill_qty_storno 623320 623320 0 0.00 0 64963 74 0 0
sp_lock_selected_doc 19852 19852 0 0.00 0 5847 4 0 0
sp_make_cost_storno 26745 26745 0 0.00 0 19272 57 0 0
sp_multiply_rows_for_pdistr 26744 26744 0 0.00 0 11013 28 0 0
sp_multiply_rows_for_qdistr 19890 19890 0 0.00 0 36314 193 0 0
sp_pay_from_customer 6878 6878 0 0.00 4 14439 126 0 0
sp_pay_to_supplier 5596 5596 0 0.00 5 14579 121 0 0
sp_payment_common 12473 12473 0 0.00 2 14426 29 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 0 9791 326 0 0
sp_qd_handle_on_invoice_upd_sts 10674 10674 0 0.00 0 37932 333 0 0
sp_qd_handle_on_reserve_upd_sts 9560 9560 0 0.00 0 13225 60 0 0
sp_reserve_write_off 9562 9562 0 0.00 6 15510 174 0 0
sp_supplier_invoice 5263 5263 0 0.00 6 85910 3507 0 0
sp_supplier_order 5126 5126 0 0.00 5 44029 1427 0 0
srv_aggregate_perf_data 94 94 0 0.00 2924 218929 19096 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1107 137426 32790 0 0
srv_find_qd_qs_mism 1061996 1061996 0 0.00 0 19857 5 0 0
srv_make_invnt_saldo 522 522 0 0.00 23 45431 1071 0 0
srv_make_money_saldo 782 782 0 0.00 0 12776 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 159422 477756 271791 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4715 4715 0 0.00 0 11958 164 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 3490 76 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 3892 11 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 2036 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 1096 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 1869 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 3416 28 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 21825 1695 0 0
t$perf-norm:sp_cancel_write_off 968 968 0 0.00 0 1300 7 0 0
t$perf-norm:sp_client_order 19890 19890 0 0.00 0 8041 19 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 764 6 0 0
t$perf-norm:sp_pay_from_customer 6878 6878 0 0.00 0 12110 11 0 0
t$perf-norm:sp_pay_to_supplier 5596 5596 0 0.00 0 4998 9 0 0
t$perf-norm:sp_reserve_write_off 9562 9562 0 0.00 0 9391 11 0 0
t$perf-norm:sp_supplier_invoice 5263 5263 0 0.00 0 8824 19 0 0
t$perf-norm:sp_supplier_order 5126 5126 0 0.00 0 3728 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 368 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 2468 38 0 0
t$perf-norm:srv_make_invnt_saldo 522 522 0 0.00 0 1739 24 0 0
t$perf-norm:srv_make_money_saldo 782 782 0 0.00 0 1240 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9654 9412 242 2.50 0 6619 21 0 242
v_all_customers 36300 36300 0 0.00 0 17 1 0 0
v_all_suppliers 28958 28958 0 0.00 0 19 1 0 0
v_all_wares 39772 39772 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 504 6 0 0
v_cancel_client_order 3436 3436 0 0.00 0 2593 4 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 3431 7 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 323 3 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 382 4 0 0
v_cancel_supplier_invoice 756 738 18 2.38 0 2945 20 0 18
v_cancel_supplier_order 842 842 0 0.00 0 2431 7 0 0
v_cancel_write_off 1936 1936 0 0.00 0 1913 13 0 0
v_max_id_clo_ord 5113 5113 0 0.00 0 118 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 3916 20 0 0
v_max_id_ord_sup 5248 5248 0 0.00 0 3515 4 0 0
v_max_non_paid_invoice 1478 1478 0 0.00 0 293 3 0 0
v_max_non_paid_realizn 3587 3587 0 0.00 0 5259 5 0 0
v_min_id_clo_ord 5113 5113 0 0.00 0 6757 7 0 0
v_min_id_clo_res 999 999 0 0.00 0 2244 10 0 0
v_min_id_ord_sup 5248 5248 0 0.00 0 3916 5 0 0
v_min_non_paid_invoice 5596 5596 0 0.00 0 5604 14 0 0
v_min_non_paid_realizn 6877 6877 0 0.00 0 14419 23 0 0
v_our_firm 10052 10052 0 0.00 0 22 1 0 0
v_reserve_write_off 19116 19116 0 0.00 0 2934 5 0 0
x_lock_depdocs_on_canc_invoice 12185 12185 0 0.00 0 26232 133 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 4841 358 0 0
x_make_qstorno_1000_1200 5126 5126 0 0.00 1 44023 1349 0 0
x_make_qstorno_1200_2000 5263 5263 0 0.00 3 85860 3366 0 0
x_make_qstorno_2100_3300 438677 438677 0 0.00 0 69172 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-11-2020 19:28:25 to 20-11-2020 19:28:29.

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
16:57:03 3 8192000000 8804656304 8816791552 10294192 0.125 2 2 3 0 10472624 66144 112288
16:57:09 15057 8192000000 10242777808 10547064832 912169600 10.019 72 60 122 1 933989872 2516592 19303680
16:57:33 30375 8192000000 10349889024 10665418752 1384233600 14.454 100 86 172 2 1417071680 4806976 28031104
16:58:19 19025 8192000000 10394163952 10717212672 1438546768 14.937 100 89 177 0 1474370336 6692064 29131504
16:58:52 29878 8192000000 10426655328 10757709824 1473957904 15.248 100 88 176 0 1510535840 8033280 28544656
16:59:32 24471 8192000000 10446510304 10781474816 1499622240 15.473 100 86 172 0 1536186304 8895728 27668336
17:00:06 7566 8192000000 10458784576 10797228032 1519935600 15.650 100 88 176 1 1557083104 9278080 27869424
17:00:20 25002 8192000000 10488782096 10829676544 1534408784 15.775 100 88 173 1 1571412704 9730736 27273184
17:00:52 19975 8192000000 10494479072 10838757376 1552880928 15.935 100 88 176 1 1591009392 10873408 27255056
17:01:21 16213 8192000000 10518414272 10870161408 1566466128 16.052 100 83 164 1 1602916720 10807488 25643104
17:02:07 11705 8192000000 10564744080 10921926656 1616190096 16.477 100 80 160 1 1651896816 11583632 24123088
17:02:31 11278 8192000000 10583884384 10945978368 1644079488 16.714 100 80 160 0 1680066496 12253152 23733856
17:02:52 10441 8192000000 10596863904 10963283968 1659761072 16.847 100 83 164 1 1697444464 13171648 24511744
17:03:11 13221 8192000000 10619363936 10986188800 1677578336 16.997 100 81 161 3 1714670032 13060992 24030704
17:03:33 2492 8192000000 10624791792 10993156096 1686408112 17.071 100 81 162 1 1722763920 12838784 23517024
17:03:42 9200 8192000000 10644109152 11010666496 1701490080 17.198 100 84 167 1 1739193520 13462240 24241200
17:03:59 7510 8192000000 10639773984 11011358720 1706364880 17.238 100 82 161 0 1743047664 12717264 23965520
17:04:15 8777 8192000000 10658899056 11031879680 1718158704 17.337 100 78 157 2 1753450640 12964560 22327376
17:04:31 6512 8192000000 10681000944 11054182400 1738128656 17.503 100 80 155 1 1772050608 12745712 21176240
17:04:47 6050 8192000000 10685285136 11063595008 1749427008 17.597 100 79 158 0 1785481984 13734656 22320320
17:05:01 4105 8192000000 10698255360 11077603328 1759522224 17.680 100 86 171 3 1796517872 12614592 24381056
17:05:12 3135 8192000000 10711635264 11092074496 1771902144 17.783 100 83 166 1 1808344480 12763200 23679136
17:05:22 4418 8192000000 10722708928 11104055296 1783154272 17.875 100 80 160 1 1817610464 12261184 22195008
17:05:33 3705 8192000000 10724581248 11116335104 1799958400 18.014 100 75 150 0 1834138560 12575712 21604448
17:05:44 3114 8192000000 10740642912 11127234560 1809286752 18.090 100 86 171 1 1845683504 12446800 23949952
17:05:54 4242 8192000000 10755121344 11140415488 1818574688 18.166 100 87 173 0 1854168896 11582720 24011488
17:06:06 7169 8192000000 10758303744 11142684672 1821902352 18.193 100 80 156 0 1856140320 12411872 21826096
17:06:19 4340 8192000000 10758794928 11145261056 1824934752 18.218 100 77 154 0 1858715472 12539600 21241120
17:06:30 2249 8192000000 10777217232 11165474816 1836735632 18.314 100 83 167 0 1872843456 12854976 23252848
17:06:39 2411 8192000000 10790525872 11174146048 1844473360 18.377 100 89 179 2 1884085424 13959312 25652752
17:06:48 2497 8192000000 10795608720 11181703168 1850779424 18.428 100 88 176 2 1889100960 14198432 24123104
17:06:58 2503 8192000000 10793877936 11182133248 1853994416 18.455 100 87 174 1 1893359280 14070080 25294784
17:07:06 2329 8192000000 10796879792 11189948416 1859329680 18.498 100 86 172 0 1895940048 11527952 25082416
17:07:16 2123 8192000000 10807289984 11195228160 1862168880 18.521 100 92 184 1 1902293296 13695376 26429040
17:07:24 1252 8192000000 10810030224 11196727296 1865303280 18.546 100 94 183 3 1905202976 14063152 25836544
17:07:32 2769 8192000000 10808232624 11201241088 1864476400 18.540 100 81 162 1 1901379456 13742608 23160448
17:07:41 1941 8192000000 10808626352 11202707456 1871783536 18.599 100 88 176 3 1910337008 13375392 25178080
17:07:49 2047 8192000000 10808759520 11202281472 1871578864 18.597 100 89 178 1 1910201296 12141760 26480672
17:07:58 18891 8192000000 10800932880 11200192512 1869148112 18.577 100 60 120 1 1900074768 14423728 16502928
17:08:24 5031 8192000000 10814484080 11210387456 1875521744 18.629 100 82 163 1 1910310656 11767952 23020960
17:08:36 2672 8192000000 10820577808 11215347712 1877744784 18.647 100 85 168 0 1913690576 11811712 24134080
17:08:46 10073 8192000000 10817667888 11212742656 1881394048 18.676 100 77 155 0 1913949072 11487040 21067984
17:09:02 23008 8192000000 10790675488 11215810560 1877870384 18.648 100 54 107 1 1903716816 10724112 15122320
17:09:35 5782 8192000000 10799496896 11214675968 1879372192 18.660 100 37 74 1 1897645680 7709344 10564144
17:09:47 4092 8192000000 10794957872 11218763776 1882909840 18.689 100 42 84 1 1903599760 9060896 11629024
17:09:58 6945 8192000000 10794177296 11219234816 1881153344 18.674 100 29 58 2 1896757360 7480048 8123968
17:10:13 5529 8192000000 10796515808 11222646784 1887462640 18.725 100 37 74 2 1905440000 7191440 10785920
17:10:25 7165 8192000000 10801523472 11228172288 1894128048 18.779 100 41 82 0 1913547568 8023664 11395856
17:10:39 3833 8192000000 10803358896 11228418048 1893067600 18.770 100 37 75 1 1912188640 8869840 10251200
17:10:49 12481 8192000000 10803179168 11232268288 1892848864 18.769 100 37 75 1 1910510592 6308848 11352880
17:11:10 13812 8192000000 10801717152 11232534528 1893524640 18.774 100 14 28 1 1903549248 5950144 4074464
17:11:30 13080 8192000000 10801478400 11238662144 1900330432 18.829 100 19 38 0 1911507968 6140352 5037184
17:11:51 9781 8192000000 10812016096 11243048960 1902102880 18.843 100 17 34 1 1912550000 5760240 4686880
17:12:09 9747 8192000000 10805626976 11246182400 1903052976 18.851 100 15 30 0 1912846976 5283760 4510240
17:12:26 7453 8192000000 10815327936 11244957696 1903824816 18.857 100 19 38 1 1914306720 5641168 4840736
17:12:40 7350 8192000000 10830893424 11250495488 1907679664 18.888 100 33 65 2 1922218864 5172576 9366624
17:12:54 69163 8192000000 10850419136 11265597440 1912427024 18.926 100 47 94 0 1931668688 5411920 13829744
17:14:09 5386 8192000000 10830167808 11266285568 1911875120 18.922 100 35 70 0 1930512864 8711584 9926160
17:14:25 6271 8192000000 10835055120 11263127552 1912365200 18.926 100 33 67 1 1928748368 7445840 8937328
17:14:37 4286 8192000000 10842744544 11268157440 1916691136 18.960 100 46 92 3 1937938464 7945488 13301840
17:14:48 5970 8192000000 10839397792 11269656576 1917328400 18.965 100 46 91 3 1938192176 7673184 13190592
17:15:02 7293 8192000000 10804998224 11240194048 1889040896 18.738 99 21 42 1 1901321840 5932448 6348496
17:15:17 4227 8192000000 10838520336 11266965504 1915621040 18.952 100 46 92 0 1937481312 8868352 12991920
17:15:31 4098 8192000000 10835568256 11265093632 1913692912 18.936 100 26 52 2 1927347856 5887584 7767360
17:15:43 7606 8192000000 10814447792 11256201216 1890388608 18.749 99 24 48 2 1908050944 11115664 6546672
17:16:00 11455 8192000000 10811653488 11249336320 1885598032 18.710 99 23 46 0 1898580896 6647136 6335728
17:16:20 4448 8192000000 10808492000 11236532224 1873113424 18.609 99 21 42 1 1889153648 10397680 5642544
17:16:31 9994 8192000000 10795132224 11234324480 1875582384 18.629 99 15 30 1 1885869424 5321040 4966000
17:16:50 51185 8192000000 10817910000 11237281792 1856683712 18.476 98 45 90 4 1876500992 4682448 15134832
17:17:50 22865 8192000000 10762130144 11191816192 1748500832 17.589 93 9 18 0 1756275856 5341232 2433792
17:18:21 6790 8192000000 10787889888 11211939840 1851201056 18.432 99 31 62 1 1867440944 7782896 8456992
17:18:34 4466 8192000000 10750097696 11174539264 1825371936 18.222 99 40 81 1 1844548336 7690448 11485952
17:18:45 7219 8192000000 10741672592 11159556096 1808998576 18.088 99 44 88 2 1829244544 8098128 12147840
17:19:03 4720 8192000000 10757562112 11180679168 1838381056 18.328 100 34 68 3 1854262208 6143744 9737408
17:19:14 7602 8192000000 10719959472 11136532480 1756206080 17.653 96 22 44 0 1767886720 5493264 6187376
17:19:29 5498 8192000000 10705661056 11111956480 1753745680 17.633 98 24 48 2 1766901744 6003248 7152816
17:19:42 8726 8192000000 10720348000 11140210688 1785049984 17.891 99 24 48 2 1797204896 5954784 6200128
17:19:58 7816 8192000000 10668705296 11073798144 1656448112 16.819 92 18 37 2 1666840096 4747264 5644720
17:20:14 11283 8192000000 10688987584 11104411648 1725645872 17.399 97 26 51 4 1739840256 6638720 7555664
17:20:32 7957 8192000000 10701625472 11120414720 1776746112 17.823 99 15 30 1 1786662784 5731984 4184688
17:20:50 16982 8192000000 10694952080 11111559168 1769039952 17.759 98 29 54 4 1782149584 5294864 7814768
17:21:33 40958 8192000000 10705340784 11124109312 1763266080 17.711 97 23 46 1 1775294992 5308032 6720880
17:22:30 13621 8192000000 10731991536 11156238336 1810103168 18.097 99 19 38 1 1820829440 5150352 5575920
17:22:52 8483 8192000000 10752634432 11172012032 1803719280 18.044 98 29 58 2 1821672432 9586352 8366800
17:23:09 7927 8192000000 10756730800 11178295296 1837191168 18.318 100 37 75 1 1853877680 5747504 10939008
17:23:23 6282 8192000000 10751543712 11178258432 1844659488 18.379 100 24 49 0 1857587968 5805904 7122576
17:23:36 5800 8192000000 10761519504 11183915008 1844358544 18.376 100 22 44 0 1855841392 4738448 6744400
17:23:52 10874 8192000000 10768986032 11195170816 1853620304 18.452 100 22 45 0 1865722128 5998352 6103472
17:24:09 13048 8192000000 10763647792 11197689856 1856393920 18.474 100 19 38 2 1867457712 5462480 5601312
17:24:28 4989 8192000000 10765466688 11191308288 1856659584 18.476 100 20 40 2 1867469456 5156800 5653072
17:24:42 6706 8192000000 10766570224 11197480960 1859354304 18.498 100 27 54 0 1873993120 6904336 7734480
17:24:55 9522 8192000000 10786466720 11213877248 1867598816 18.565 100 32 64 2 1882267552 5017632 9651104
17:25:13 9339 8192000000 10784009248 11216125952 1872101600 18.601 100 22 44 0 1883888592 5150000 6636992
17:25:33 14509 8192000000 10789915216 11218755584 1875860048 18.632 100 18 36 0 1886845056 5739376 5245632
17:25:56 50909 8192000000 10801147424 11231408128 1884197232 18.699 100 30 60 4 1898467008 5728592 8541184
17:27:06 60145 8192000000 10839807088 11258720256 1907183040 18.884 100 42 84 2 1925576176 6736864 11656272
17:28:23 42189 8192000000 10872761824 11293810688 1934270112 19.101 100 55 109 1 1960127952 10675328 15182512
17:29:15 29423 8192000000 10870580672 11295633408 1941339968 19.157 100 52 102 1 1966277088 10664016 14273104
17:29:59 28272 8192000000 10882836480 11311382528 1948799728 19.217 100 51 102 0 1975593232 12576064 14217440
17:30:37 29576 8192000000 10894416496 11322605568 1954112032 19.259 100 38 76 3 1979170448 13813344 11245072
17:31:29 18260 8192000000 10891804704 11327717376 1958897072 19.297 100 39 78 2 1989204000 18769712 11537216
17:31:53 12087 8192000000 10905929328 11335618560 1961465104 19.318 100 47 94 1 1995367616 19208080 14694432
17:32:24 13043 8192000000 10925884208 11347374080 1972913088 19.409 100 57 112 2 2012115216 22913072 16289056
17:32:52 4261 8192000000 10928209616 11354800128 1979605312 19.462 100 53 106 1 2014807200 19654384 15547504
17:33:08 3503 8192000000 10937361168 11358474240 1985385184 19.507 100 62 123 0 2024712432 20837824 18489424
17:33:32 25674 8192000000 10938682128 11364929536 1985788848 19.511 100 48 95 0 2020679504 20189504 14701152
17:34:13 3423 8192000000 10938819248 11362762752 1986769616 19.518 100 60 119 2 2027986912 23694096 17523200
17:34:23 19542 8192000000 10932938336 11366690816 1992160080 19.561 100 59 116 1 2032298208 22730208 17407920
17:34:53 12827 8192000000 10936219712 11374919680 1992189456 19.561 100 47 94 2 2027489136 21747728 13551952
17:35:13 19852 8192000000 10939458384 11371487232 1976620000 19.438 99 55 109 0 2018800304 26662496 15517808
17:35:41 5492 8192000000 10946553488 11378020352 1992377232 19.563 100 47 96 2 2029094512 22879440 13837840
17:35:59 27897 8192000000 10938156592 11371102208 1975596768 19.430 99 52 104 1 2013512224 22961216 14954240
17:36:36 5950 8192000000 10943757712 11379941376 1992099328 19.560 100 49 97 2 2031613888 25247200 14267360
17:36:49 3967 8192000000 10963296512 11384705024 2000307472 19.625 100 64 128 1 2047997776 28571600 19118704
17:37:01 2712 8192000000 10964362896 11388416000 2003989424 19.654 100 70 137 4 2053785904 28914208 20882272
17:37:12 2817 8192000000 10980185184 11400134656 2011654416 19.715 100 78 155 1 2064078224 29404928 23018880
17:37:22 2545 8192000000 10975845856 11402489856 2014690672 19.738 100 78 155 1 2068441312 30871216 22879424
17:37:35 13252 8192000000 10974938736 11403464704 2012788016 19.723 100 67 135 0 2064668016 32146944 19733056
17:37:56 5497 8192000000 10957278064 11383906304 1988048528 19.528 99 65 128 1 2041016448 33657824 19310096
17:38:08 1106 8192000000 10949814112 11370827776 1985763936 19.510 99 75 148 2 2041043296 33327328 21952032
17:38:17 7222 8192000000 10965972368 11394215936 2000587888 19.627 100 59 117 1 2055119456 36740560 17791008
17:38:33 8541 8192000000 10973860592 11394019328 1985905632 19.511 99 65 129 1 2044630128 38669888 20054608
17:38:54 10778 8192000000 10971391632 11398778880 2001225328 19.632 100 64 126 0 2060398800 39195712 19977760
17:39:12 3962 8192000000 10975037296 11392450560 1991973504 19.559 100 68 135 2 2054796480 41629232 21193744
17:39:25 6400 8192000000 10967934096 11392544768 1995543488 19.588 100 66 133 1 2057346608 41483920 20319200
17:39:39 12771 8192000000 10956180144 11380035584 1968334752 19.372 99 58 115 0 2027090560 40940064 17815744
17:40:02 3621 8192000000 10980948768 11402129408 1999315104 19.617 100 71 138 4 2063047280 42651280 21080896
17:40:12 1730 8192000000 10965864704 11373027328 1974815264 19.424 99 88 174 2 2046156448 43276720 28064464
17:40:22 4513 8192000000 10952085408 11371642880 1967886848 19.369 99 71 141 1 2032025536 42543280 21595408
17:40:34 1591 8192000000 10985509200 11395833856 1992012752 19.560 100 88 176 3 2064710528 45091696 27606080
17:40:43 2332 8192000000 10960517168 11367223296 1954401424 19.262 98 86 171 1 2025880272 45322544 26156304
17:40:53 1606 8192000000 10976472592 11391074304 1987859936 19.527 100 80 158 1 2058719248 46357312 24502000
17:41:01 2294 8192000000 10968028752 11387260928 1969631904 19.383 99 74 148 1 2040269984 47260320 23377760
17:41:10 5166 8192000000 10960519760 11386126336 1966081984 19.354 99 65 129 0 2030955440 43935184 20938272
17:41:24 6227 8192000000 10955252048 11371143168 1956878480 19.281 99 72 141 1 2021542896 42956336 21708080
17:41:40 2052 8192000000 10948784752 11359842304 1944709744 19.184 99 73 145 0 2012857536 45249536 22898256
17:41:49 3477 8192000000 10939896768 11345870848 1950310544 19.229 99 77 154 2 2018537408 43667216 24559648
17:42:00 2440 8192000000 10956164832 11371151360 1973727056 19.415 100 73 146 1 2040032448 43554560 22750832
17:42:10 2070 8192000000 10951293696 11366862848 1965883264 19.353 100 79 156 3 2034946544 45131216 23932064
17:42:20 3983 8192000000 10956000208 11376414720 1975231152 19.427 100 78 152 1 2045327776 45993584 24103040
17:42:32 3545 8192000000 10958141664 11384414208 1980596912 19.469 100 72 142 2 2049445968 46695040 22154016
17:42:42 3455 8192000000 10962534976 11376820224 1977685760 19.446 100 81 161 0 2044948448 42774544 24488144
17:42:54 3660 8192000000 10955871280 11375124480 1964860336 19.345 99 70 140 0 2029298592 43027296 21410960
17:43:04 3209 8192000000 10960445344 11374665728 1974789264 19.423 100 82 163 1 2044687744 44125968 25772512
17:43:15 1467 8192000000 10985295808 11392356352 1986088432 19.513 100 87 173 0 2060394848 48016912 26289504
17:43:24 3036 8192000000 10955296528 11367288832 1964660400 19.343 100 84 167 0 2038112208 47636912 25814896
17:43:34 8312 8192000000 10937483888 11359698944 1940663456 19.152 99 68 136 1 2009606080 47814528 21128096
17:43:51 5252 8192000000 10942747888 11368390656 1960067584 19.307 100 65 129 1 2029961152 49941264 19952304
17:44:03 5134 8192000000 10964256768 11386515456 1974345696 19.420 100 62 124 0 2045074976 49583088 21146192
17:44:18 4096 8192000000 10974019424 11403165696 1984933568 19.504 100 56 112 1 2053656192 51323792 17398832
17:44:31 2395 8192000000 10968201520 11389923328 1971727648 19.399 99 71 142 2 2048011744 53908640 22375456
17:44:40 2204 8192000000 10986789456 11407249408 1991408080 19.555 100 88 175 1 2074652464 54927712 28316672
17:44:53 8662 8192000000 10990888480 11407319040 1974645376 19.422 99 82 166 1 2057651056 57022144 25983536
17:45:14 4140 8192000000 10966218368 11386130432 1967383968 19.365 100 73 145 1 2049139344 59143232 22612144
17:45:25 1473 8192000000 10977128224 11392618496 1970282160 19.388 100 84 166 1 2058250752 61485712 26482880
17:45:35 3017 8192000000 10966876544 11376390144 1934943696 19.106 98 85 169 1 2022403472 60767872 26691904
17:45:45 1142 8192000000 10964226688 11377524736 1959712480 19.304 100 83 165 6 2045917232 60170496 26034256
17:45:53 2122 8192000000 10981589968 11395137536 1976284032 19.435 100 87 174 0 2065396848 61174976 27937840
17:46:02 2814 8192000000 10968636720 11380875264 1965463840 19.349 100 80 160 1 2050468256 58210560 26793856
17:46:15 1614 8192000000 10980911184 11391795200 1973902608 19.416 100 84 170 1 2057818480 57055776 26860096
17:46:24 2504 8192000000 10983541264 11407200256 1984642512 19.501 100 66 132 0 2068544864 62362624 21539728
17:46:36 9498 8192000000 10981692864 11409100800 1969233760 19.379 99 54 108 1 2048647376 61515984 17897632
17:47:05 12487 8192000000 10979012336 11414908928 1986386976 19.515 100 54 108 1 2067726016 62774608 18564432
17:47:25 5785 8192000000 10987393168 11419299840 1989948144 19.543 100 61 121 0 2073890224 64162176 19779904
17:47:38 5284 8192000000 10991660656 11423064064 1990708192 19.549 100 55 110 0 2073257648 64187760 18361696
17:47:53 8581 8192000000 10977308672 11411582976 1971736528 19.399 99 53 104 1 2049035568 59795760 17503280
17:48:16 9275 8192000000 10971247616 11416055808 1982162208 19.482 100 47 94 2 2060285952 61747872 16375872
17:48:36 9316 8192000000 10957758176 11387527168 1950701888 19.232 99 51 102 1 2025277456 57170896 17404672
17:48:52 3253 8192000000 10971576928 11400339456 1975432784 19.429 100 68 133 2 2055132752 57486160 22213808
17:49:04 13872 8192000000 10962288048 11407515648 1981671824 19.478 100 49 98 1 2056708256 58755088 16281344
17:49:27 7800 8192000000 10960699824 11398729728 1981310928 19.475 100 46 91 0 2048823808 52051952 15460928
17:49:44 7971 8192000000 10971211824 11404804096 1979314816 19.459 100 47 93 0 2053839328 59044096 15480416
17:50:05 6427 8192000000 10961919776 11386781696 1945267456 19.189 98 51 102 1 2016440704 54530864 16642384
17:50:18 8070 8192000000 10961274240 11399254016 1974880192 19.424 100 50 100 1 2049140064 57510992 16748880
17:50:46 17281 8192000000 10962409952 11405955072 1961066032 19.315 99 38 76 2 2034882272 61019904 12796336
17:51:11 14498 8192000000 10944634624 11388764160 1955478368 19.270 99 36 72 1 2022591664 54764288 12349008
17:51:32 11653 8192000000 10955887744 11399544832 1971285040 19.396 100 32 63 0 2037924464 55681616 10957808
17:51:51 10767 8192000000 10949200656 11396284416 1952933552 19.250 99 33 66 0 2020360656 56139584 11287520
17:52:09 17723 8192000000 10959802640 11407515648 1967385184 19.365 100 31 62 0 2037984032 60063808 10535040
17:52:37 19616 8192000000 10963441360 11416498176 1975250592 19.427 100 32 64 1 2050512496 64359584 10902320
17:53:06 26880 8192000000 10953324704 11415523328 1967397104 19.365 100 28 56 2 2031862448 54605040 9860304
17:53:39 25318 8192000000 10938798304 11405144064 1962862464 19.329 100 25 50 1 2034616064 62832384 8921216
17:54:14 27092 8192000000 10933574864 11387752448 1929129456 19.060 99 29 58 0 2000764912 60567696 11067760
17:54:48 33711 8192000000 10898308432 11361034240 1876244976 18.635 97 18 36 1 1951086752 67342496 7499280
17:55:29 25186 8192000000 10871817584 11368935424 1922526176 19.007 100 15 30 2 1985545008 56792512 6226320
17:56:28 88322 8192000000 10871815808 11325530112 1919180800 18.980 99 21 43 0 1934073168 8535888 6356480
17:58:39 17959 8192000000 10910778032 11353866240 1959205600 19.300 100 55 110 1 1989215168 14365808 15643760
18:00:10 113507 8192000000 10889832640 11339304960 1850073328 18.423 94 20 41 1 1868506992 12644512 5789152
18:02:11 92744 8192000000 10854218576 11325136896 1921850864 19.002 99 16 32 0 1940944432 14664288 4429280
18:03:50 54591 8192000000 10860183616 11318480896 1899094240 18.819 98 21 40 1 1919715072 14889696 5731136
18:04:51 90426 8192000000 10862795872 11329798144 1897406832 18.805 98 17 34 0 1920604288 17810928 5386528
18:06:29 127726 8192000000 10870325056 11341250560 1950615952 19.231 100 17 33 1 1967252640 11349104 5287584
18:08:48 54393 8192000000 10893948640 11355938816 1961723600 19.320 100 25 49 0 1982859984 13883408 7252976
18:10:36 78461 8192000000 10907571504 11362082816 1963543264 19.334 100 17 34 0 1983871808 15369120 4959424
18:12:17 48754 8192000000 10882030064 11343794176 1940103424 19.148 99 10 20 0 1954075360 11555520 2416416
18:13:12 74381 8192000000 10918078992 11366862848 1971633248 19.398 100 24 48 1 1990089280 11745200 6710832
18:14:36 52507 8192000000 10901833696 11352334336 1931787456 19.081 98 16 32 1 1947025792 10494752 4743584
18:15:35 42096 8192000000 10903391216 11365081088 1968098032 19.370 100 26 52 0 1986845584 11306256 7441296
18:16:23 48095 8192000000 10897876704 11363147776 1937444272 19.126 98 19 39 1 1953319136 10431856 5443008
18:17:33 72152 8192000000 10901008912 11366764544 1950418320 19.230 99 27 54 2 1972095392 13457120 8219952
18:18:56 47833 8192000000 10897269536 11370676224 1960694784 19.312 99 22 42 3 1976904816 10304576 5905456
18:20:04 106315 8192000000 10903268064 11382284288 1937827088 19.129 98 13 26 0 1952415600 11251120 3337392
18:22:00 30307 8192000000 10900612016 11365974016 1962415472 19.325 99 30 59 2 1978263008 7767632 8079904
18:22:37 44285 8192000000 10907025120 11366068224 1923993776 19.019 97 22 44 1 1938063072 8848976 5220320
18:23:31 58152 8192000000 10905313328 11361517568 1902456608 18.846 96 29 58 2 1921218736 10295184 8466944
18:25:06 102425 8192000000 10895357456 11359526912 1951132656 19.235 99 32 64 1 1971074672 9848368 10093648
18:27:04 40143 8192000000 10920887824 11373285376 1983251280 19.490 100 39 78 0 2002558256 8594848 10712128
18:27:51 29207 8192000000 10931201568 11378982912 1969612400 19.382 99 43 86 0 1992827760 11516000 11699360
18:28:31 54843 8192000000 10856456048 11330072576 1878849920 18.656 95 15 30 1 1890098656 7611344 3637392
18:29:38 50521 8192000000 10874090640 11350495232 1937886048 19.130 99 13 26 2 1948899056 6602256 4410752
18:30:37 80122 8192000000 10873748704 11355328512 1950730416 19.232 99 15 29 2 1962179744 7317552 4131776
18:32:03 39530 8192000000 10894310528 11369910272 1961199632 19.316 100 12 23 0 1975658192 11371872 3086688
18:32:49 37211 8192000000 10902423856 11380191232 1954616528 19.263 99 13 26 0 1966038528 8106288 3315712
18:33:32 47185 8192000000 10874962752 11344486400 1887116752 18.723 96 29 53 1 1901428128 8547696 5763680
18:34:27 58247 8192000000 10880523536 11353108480 1911335600 18.917 98 15 30 2 1935957824 20154992 4467232
18:35:42 40504 8192000000 10863350144 11333545984 1877213184 18.643 96 17 34 0 1895893808 13404368 5276256
18:36:28 68912 8192000000 10866166288 11346673664 1889196416 18.739 97 21 41 0 1913972128 18787648 5988064
18:37:54 56070 8192000000 10887006288 11338764288 1905788032 18.873 98 15 29 0 1920245040 9715280 4741728
18:39:00 52822 8192000000 10870873328 11334160384 1900531536 18.831 98 18 36 0 1914878560 9159968 5187056
18:40:03 127182 8192000000 10810648688 11275526144 1728708896 17.425 89 15 30 0 1744207664 11257616 4241152
18:42:17 29772 8192000000 10838564256 11293642752 1886958464 18.721 99 17 32 1 1901397552 9806496 4632592
18:42:58 58643 8192000000 10891838816 11330732032 1918624272 18.976 99 38 76 0 1944597264 14057776 11915216
18:44:05 41505 8192000000 10878775184 11322822656 1903627952 18.855 98 31 62 0 1922740320 10550928 8561440
18:44:53 137426 8192000000 10843363984 11303825408 1832405584 18.279 95 27 54 2 1854037968 13744352 7888032
18:47:17 77712 8192000000 10844037456 11307855872 1903431120 18.854 99 30 60 1 1922746320 11171760 8143440
18:48:46 58618 8192000000 10847572624 11321241600 1903937920 18.858 99 7 14 0 1918818896 12817632 2063344
18:49:51 34863 8192000000 10858427824 11326836736 1927438496 19.046 100 7 14 0 1941474800 12022016 2014288
18:50:36 51368 8192000000 10840069312 11321630720 1886115632 18.714 98 8 16 0 1899864128 11557008 2191488
18:51:45 89448 8192000000 10836403424 11297116160 1845522912 18.386 96 13 26 1 1858904064 9493984 3887168
18:53:38 47035 8192000000 10837240800 11286937600 1841500320 18.353 96 23 46 0 1858364304 10060640 6803344
18:54:39 82362 8192000000 10846936704 11307606016 1884114640 18.698 98 31 62 1 1904262896 11001584 9146672
18:56:16 56549 8192000000 10866706512 11332620288 1922888976 19.010 100 13 26 1 1935551216 9452272 3209968
18:57:29 54457 8192000000 10877443600 11341836288 1943076816 19.171 100 14 28 1 1960391136 13290992 4023328
18:58:29 54502 8192000000 10923950064 11357597696 1957274112 19.284 100 36 71 2 1977052512 9689936 10088464
18:59:34 44190 8192000000 10889586944 11355111424 1939558864 19.143 99 20 40 0 1957293760 12426816 5308080
19:00:24 39942 8192000000 10900010672 11375861760 1965636832 19.351 100 22 44 1 1981983376 10628048 5718496
19:01:19 131919 8192000000 10909283216 11389370368 1915828736 18.953 97 16 32 0 1939271216 19106320 4336160
19:03:46 84879 8192000000 10915609520 11385540608 1942346192 19.165 99 20 41 0 1975972192 27467456 6158544
19:05:18 108117 8192000000 10882860128 11342888960 1903804560 18.857 97 28 55 1 1924593280 13242736 7545984
19:07:26 127111 8192000000 10888927136 11359166464 1941506368 19.159 99 23 46 1 1959179824 11390384 6283072
19:09:39 34107 8192000000 10885554976 11370315776 1965519664 19.350 100 15 30 0 1983054080 12510144 5024272
19:10:37 59502 8192000000 10887371408 11370921984 1950690544 19.232 99 18 36 0 1965501600 10034848 4776208
19:11:55 38838 8192000000 10893746176 11362586624 1969599712 19.382 100 20 42 1 1984387280 8606960 6180608
19:12:44 46664 8192000000 10906456128 11372609536 1978399968 19.452 100 25 50 0 1992851120 7465248 6985904
19:13:38 50746 8192000000 10901759456 11377176576 1957517968 19.286 99 8 16 0 1966673264 6830832 2324464
19:14:41 74957 8192000000 10928451088 11403673600 1993652016 19.573 100 15 30 0 2015023792 17196192 4175584
19:16:32 102142 8192000000 10913222080 11409559552 1995055872 19.584 100 15 30 1 2020001888 20328768 4617248
19:18:38 73405 8192000000 10897079792 11369971712 1890860096 18.753 95 10 20 2 1911888416 18202752 2825568
19:20:00 58859 8192000000 10897904880 11367833600 1900749088 18.832 96 19 38 1 1918891104 12620960 5521056
19:21:56 39772 8192000000 10879767952 11345338368 1912355472 18.926 97 20 40 3 1931449072 13670912 5422688
19:22:42 28106 8192000000 10864791008 11322810368 1902317376 18.845 98 15 30 2 1916518544 10050368 4150800
19:23:17 34102 8192000000 10897005824 11350761472 1916556512 18.959 98 28 56 3 1936701360 11999264 8145584
19:24:56 19653 8192000000 10889840864 11340058624 1933400688 19.094 99 54 108 0 1959561408 11388976 14771744
19:25:25 17509 8192000000 10897530112 11353010176 1956285808 19.277 100 37 74 1 1979883472 13554048 10043616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 20-11-2020 19:28:31 to 20-11-2020 19:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-11-2020 19:29:02 to 20-11-2020 19:29:04.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          229278
MON$OLDEST_ACTIVE               233806
MON$OLDEST_SNAPSHOT             233806
MON$NEXT_TRANSACTION            233806
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2023232
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33392 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33392 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33392 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33392 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:899: 
:900: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:901:     /opt/fb30/bin/fbguard: /opt/fb30/bin/firebird terminated abnormally (-1)
:902: 
:903: 
:904: 
:905: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:906:     /opt/fb30/bin/fbguard: guardian starting /opt/fb30/bin/firebird
:907: 
:908: 
:909: 
:910: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:911:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:912:     Uncommitted work may have been lost.
:913:     Error writing data to the connection.
:914: 
:915: 
:916: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:917:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:918:     Uncommitted work may have been lost.
:919:     Error writing data to the connection.
:920: 
:921: 
:922: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:923:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:924:     Uncommitted work may have been lost.
:925:     Error writing data to the connection.
:926: 
:927: 
:928: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:929:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:930:     Uncommitted work may have been lost.
:931:     Error writing data to the connection.
:932: 
:933: 
:934: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:935:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:936:     Uncommitted work may have been lost.
:937:     Error writing data to the connection.
:938: 
:939: 
:940: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:941:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:942:     Uncommitted work may have been lost.
:943:     Error writing data to the connection.
:944: 
:945: 
:946: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:947:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:948:     Uncommitted work may have been lost.
:949:     Error writing data to the connection.
:950: 
:951: 
:952: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:953:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:954:     Uncommitted work may have been lost.
:955:     Error writing data to the connection.
:956: 
:957: 
:958: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:959:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:960:     Uncommitted work may have been lost.
:961:     Error writing data to the connection.
:962: 
:963: 
:964: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:965:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:966:     Uncommitted work may have been lost.
:967:     Error writing data to the connection.
:968: 
:969: 
:970: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:971:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:972:     Uncommitted work may have been lost.
:973:     Error writing data to the connection.
:974: 
:975: 
:976: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:977:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:978:     Uncommitted work may have been lost.
:979:     Error writing data to the connection.
:980: 
:981: 
:982: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:983:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:984:     Uncommitted work may have been lost.
:985:     Error writing data to the connection.
:986: 
:987: 
:988: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:989:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:990:     Uncommitted work may have been lost.
:991:     Error writing data to the connection.
:992: 
:993: 
:994: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:995:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:996:     Uncommitted work may have been lost.
:997:     Error writing data to the connection.
:998: 
:999: 
:1000: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1001:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1002:     Uncommitted work may have been lost.
:1003:     Error writing data to the connection.
:1004: 
:1005: 
:1006: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1007:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1008:     Uncommitted work may have been lost.
:1009:     Error writing data to the connection.
:1010: 
:1011: 
:1012: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1013:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1014:     Uncommitted work may have been lost.
:1015:     Error writing data to the connection.
:1016: 
:1017: 
:1018: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1019:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1020:     Uncommitted work may have been lost.
:1021:     Error writing data to the connection.
:1022: 
:1023: 
:1024: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1025:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1026:     Uncommitted work may have been lost.
:1027:     Error writing data to the connection.
:1028: 
:1029: 
:1030: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1031:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1032:     Uncommitted work may have been lost.
:1033:     Error writing data to the connection.
:1034: 
:1035: 
:1036: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1037:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1038:     Uncommitted work may have been lost.
:1039:     Error writing data to the connection.
:1040: 
:1041: 
:1042: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1043:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1044:     Uncommitted work may have been lost.
:1045:     Error writing data to the connection.
:1046: 
:1047: 
:1048: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1049:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1050:     Uncommitted work may have been lost.
:1051:     Error writing data to the connection.
:1052: 
:1053: 
:1054: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1055:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1056:     Uncommitted work may have been lost.
:1057:     Error writing data to the connection.
:1058: 
:1059: 
:1060: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1061:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1062:     Uncommitted work may have been lost.
:1063:     Error writing data to the connection.
:1064: 
:1065: 
:1066: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1067:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1068:     Uncommitted work may have been lost.
:1069:     Error writing data to the connection.
:1070: 
:1071: 
:1072: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1073:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1074:     Uncommitted work may have been lost.
:1075:     Error writing data to the connection.
:1076: 
:1077: 
:1078: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1079:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1080:     Uncommitted work may have been lost.
:1081:     Error writing data to the connection.
:1082: 
:1083: 
:1084: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1089: 
:1090: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1091:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1092:     Uncommitted work may have been lost.
:1093:     Error writing data to the connection.
:1094: 
:1095: 
:1096: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1097:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1098:     Uncommitted work may have been lost.
:1099:     Error writing data to the connection.
:1100: 
:1101: 
:1102: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1103:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1104:     Uncommitted work may have been lost.
:1105:     Error writing data to the connection.
:1106: 
:1107: 
:1108: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1109:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1110:     Uncommitted work may have been lost.
:1111:     Error writing data to the connection.
:1112: 
:1113: 
:1114: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1115:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1116:     Uncommitted work may have been lost.
:1117:     Error writing data to the connection.
:1118: 
:1119: 
:1120: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1121:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1122:     Uncommitted work may have been lost.
:1123:     Error writing data to the connection.
:1124: 
:1125: 
:1126: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1131: 
:1132: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1133:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1134:     Uncommitted work may have been lost.
:1135:     Error writing data to the connection.
:1136: 
:1137: 
:1138: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1139:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1140:     Uncommitted work may have been lost.
:1141:     Error writing data to the connection.
:1142: 
:1143: 
:1144: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1145:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1146:     Uncommitted work may have been lost.
:1147:     Error writing data to the connection.
:1148: 
:1149: 
:1150: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1151:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1152:     Uncommitted work may have been lost.
:1153:     Error writing data to the connection.
:1154: 
:1155: 
:1156: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1157:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1158:     Uncommitted work may have been lost.
:1159:     Error writing data to the connection.
:1160: 
:1161: 
:1162: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1163:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1164:     Uncommitted work may have been lost.
:1165:     Error writing data to the connection.
:1166: 
:1167: 
:1168: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1173: 
:1174: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1175:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1176:     Uncommitted work may have been lost.
:1177:     Error writing data to the connection.
:1178: 
:1179: 
:1180: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1181:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1182:     Uncommitted work may have been lost.
:1183:     Error writing data to the connection.
:1184: 
:1185: 
:1186: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1187:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1188:     Uncommitted work may have been lost.
:1189:     Error writing data to the connection.
:1190: 
:1191: 
:1192: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1193:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1194:     Uncommitted work may have been lost.
:1195:     Error writing data to the connection.
:1196: 
:1197: 
:1198: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1199:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1200:     Uncommitted work may have been lost.
:1201:     Error writing data to the connection.
:1202: 
:1203: 
:1204: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1205:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1206:     Uncommitted work may have been lost.
:1207:     Error writing data to the connection.
:1208: 
:1209: 
:1210: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1215: 
:1216: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1217:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1218:     Uncommitted work may have been lost.
:1219:     Error writing data to the connection.
:1220: 
:1221: 
:1222: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1223:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1224:     Uncommitted work may have been lost.
:1225:     Error writing data to the connection.
:1226: 
:1227: 
:1228: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1229:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1230:     Uncommitted work may have been lost.
:1231:     Error writing data to the connection.
:1232: 
:1233: 
:1234: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1235:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1236:     Uncommitted work may have been lost.
:1237:     Error writing data to the connection.
:1238: 
:1239: 
:1240: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1241:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1242:     Uncommitted work may have been lost.
:1243:     Error writing data to the connection.
:1244: 
:1245: 
:1246: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1247:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1248:     Uncommitted work may have been lost.
:1249:     Error writing data to the connection.
:1250: 
:1251: 
:1252: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1257: 
:1258: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1259:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1260:     Uncommitted work may have been lost.
:1261:     Error writing data to the connection.
:1262: 
:1263: 
:1264: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1265:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1266:     Uncommitted work may have been lost.
:1267:     Error writing data to the connection.
:1268: 
:1269: 
:1270: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1271:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1272:     Uncommitted work may have been lost.
:1273:     Error writing data to the connection.
:1274: 
:1275: 
:1276: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1277:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1278:     Uncommitted work may have been lost.
:1279:     Error writing data to the connection.
:1280: 
:1281: 
:1282: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1283:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1284:     Uncommitted work may have been lost.
:1285:     Error writing data to the connection.
:1286: 
:1287: 
:1288: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1289:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1290:     Uncommitted work may have been lost.
:1291:     Error writing data to the connection.
:1292: 
:1293: 
:1294: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1299: 
:1300: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1301:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1302:     Uncommitted work may have been lost.
:1303:     Error writing data to the connection.
:1304: 
:1305: 
:1306: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1307:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1308:     Uncommitted work may have been lost.
:1309:     Error writing data to the connection.
:1310: 
:1311: 
:1312: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1313:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1314:     Uncommitted work may have been lost.
:1315:     Error writing data to the connection.
:1316: 
:1317: 
:1318: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1319:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1320:     Uncommitted work may have been lost.
:1321:     Error writing data to the connection.
:1322: 
:1323: 
:1324: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1325:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1326:     Uncommitted work may have been lost.
:1327:     Error writing data to the connection.
:1328: 
:1329: 
:1330: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1331:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1332:     Uncommitted work may have been lost.
:1333:     Error writing data to the connection.
:1334: 
:1335: 
:1336: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1341: 
:1342: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1343:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1344:     Uncommitted work may have been lost.
:1345:     Error writing data to the connection.
:1346: 
:1347: 
:1348: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1349:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1350:     Uncommitted work may have been lost.
:1351:     Error writing data to the connection.
:1352: 
:1353: 
:1354: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1355:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1356:     Uncommitted work may have been lost.
:1357:     Error writing data to the connection.
:1358: 
:1359: 
:1360: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1361:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1362:     Uncommitted work may have been lost.
:1363:     Error writing data to the connection.
:1364: 
:1365: 
:1366: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1367:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1368:     Uncommitted work may have been lost.
:1369:     Error writing data to the connection.
:1370: 
:1371: 
:1372: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1373:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1374:     Uncommitted work may have been lost.
:1375:     Error writing data to the connection.
:1376: 
:1377: 
:1378: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1383: 
:1384: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1385:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1386:     Uncommitted work may have been lost.
:1387:     Error writing data to the connection.
:1388: 
:1389: 
:1390: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1391:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1392:     Uncommitted work may have been lost.
:1393:     Error writing data to the connection.
:1394: 
:1395: 
:1396: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1397:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1398:     Uncommitted work may have been lost.
:1399:     Error writing data to the connection.
:1400: 
:1401: 
:1402: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1403:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1404:     Uncommitted work may have been lost.
:1405:     Error writing data to the connection.
:1406: 
:1407: 
:1408: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1409:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1410:     Uncommitted work may have been lost.
:1411:     Error writing data to the connection.
:1412: 
:1413: 
:1414: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1415:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1416:     Uncommitted work may have been lost.
:1417:     Error writing data to the connection.
:1418: 
:1419: 
:1420: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1425: 
:1426: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1427:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1428:     Uncommitted work may have been lost.
:1429:     Error writing data to the connection.
:1430: 
:1431: 
:1432: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1433:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1434:     Uncommitted work may have been lost.
:1435:     Error writing data to the connection.
:1436: 
:1437: 
:1438: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1439:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1440:     Uncommitted work may have been lost.
:1441:     Error writing data to the connection.
:1442: 
:1443: 
:1444: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1445:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1446:     Uncommitted work may have been lost.
:1447:     Error writing data to the connection.
:1448: 
:1449: 
:1450: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1451:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1452:     Uncommitted work may have been lost.
:1453:     Error writing data to the connection.
:1454: 
:1455: 
:1456: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1457:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1458:     Uncommitted work may have been lost.
:1459:     Error writing data to the connection.
:1460: 
:1461: 
:1462: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 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: 
:1467: 
:1468: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1469:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1470:     Uncommitted work may have been lost.
:1471:     Error writing data to the connection.
:1472: 
:1473: 
:1474: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1475:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1476:     Uncommitted work may have been lost.
:1477:     Error writing data to the connection.
:1478: 
:1479: 
:1480: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1481:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1482:     Uncommitted work may have been lost.
:1483:     Error writing data to the connection.
:1484: 
:1485: 
:1486: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1487:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1488:     Uncommitted work may have been lost.
:1489:     Error writing data to the connection.
:1490: 
:1491: 
:1492: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:45 2020
:1493:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1494:     Uncommitted work may have been lost.
:1495:     Error writing data to the connection.
:1496: 
:1497: 
:1498: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1499:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1500: 
:1501: 
:1502: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1503:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1504: 
:1505: 
:1506: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1507:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1508: 
:1509: 
:1510: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1511:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1512: 
:1513: 
:1514: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1515:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1516: 
:1517: 
:1518: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1519:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1520: 
:1521: 
:1522: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1523:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1524: 
:1525: 
:1526: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1527:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1528: 
:1529: 
:1530: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1531:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1532: 
:1533: 
:1534: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1535:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1536: 
:1537: 
:1538: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1539:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1540: 
:1541: 
:1542: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1543:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1544: 
:1545: 
:1546: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1547:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1548: 
:1549: 
:1550: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1551:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1552: 
:1553: 
:1554: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1555:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1556: 
:1557: 
:1558: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1559:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1560: 
:1561: 
:1562: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1563:     /opt/fb30/bin/fbguard: /opt/fb30/bin/firebird terminated abnormally (-1)
:1564: 
:1565: 
:1566: 
:1567: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1568:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1569: 
:1570: 
:1571: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1572:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1573: 
:1574: 
:1575: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1576:     /opt/fb30/bin/fbguard: guardian starting /opt/fb30/bin/firebird
:1577: 
:1578: 
:1579: 
:1580: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1581:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1582: 
:1583: 
:1584: mscs-test-161.budzdorov.ru    Fri Nov 20 19:27:46 2020
:1585:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3333
:1586: 
--- end of diff output ---

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

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