Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.12.2022 04:37
Command: hostnamectl |
Static hostname | mscs-test-161.budzdorov.ru |
Icon name | computer-server |
Chassis | server |
Machine ID | aeee285d2cca40bf84c40a748f599e77 |
Boot ID | 2a7b53d1c5ed44b9bb2712fffac5d8c6 |
Operating System | CentOS Linux 7 (Core) |
CPE OS Name | cpe:/o:centos:centos:7 |
Kernel | Linux 3.10.0-1127.10.1.el7.x86_64 |
Architecture | x86-64 |
Command: who -b |
bootup_info | system boot 2021-11-11 18:28 |
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor' |
Manufacturer | HP |
Product Name | ProLiant DL380 Gen9 |
Command: dmesg | grep DMI |
[ 0.000000] DMI | HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018 |
Command: lscpu | grep -i -v flags |
Architecture | x86_64 |
CPU op-mode(s) | 32-bit, 64-bit |
Byte Order | Little Endian |
CPU(s) | 24 |
On-line CPU(s) list | 0-23 |
Thread(s) per core | 2 |
Core(s) per socket | 6 |
Socket(s) | 2 |
NUMA node(s) | 2 |
Vendor ID | GenuineIntel |
CPU family | 6 |
Model | 63 |
Model name | Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz |
Stepping | 2 |
CPU MHz | 1200.000 |
CPU max MHz | 2400.0000 |
CPU min MHz | 1200.0000 |
BogoMIPS | 4794.33 |
Virtualization | VT-x |
L1d cache | 32K |
L1i cache | 32K |
L2 cache | 256K |
L3 cache | 15360K |
NUMA node0 CPU(s) | 0-5,12-17 |
NUMA node1 CPU(s) | 6-11,18-23 |
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached' |
MemTotal | 32643792 kB |
MemFree | 14774668 kB |
MemAvailable | 30042872 kB |
Buffers | 20 kB |
Cached | 16835396 kB |
SwapCached | 3368 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_MODE SuperServer 4.0.3
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|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2022-12-27 04:37:23
DTS_END 2022-12-27 04:37:23.4450
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/56968
TRN_ID 222920
ATT_ID 600
EXC_UNIT 2
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 |
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 |
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
*** OVERALL *** for 120 minutes: |
8894.12 |
28728 |
1067294 |
customer order: creation |
164.26 |
485 |
19711 |
customer order: refuse |
15.24 |
386 |
1829 |
order to supplier: creation |
44.48 |
1425 |
5338 |
order to supplier: removal |
3.57 |
154325 |
428 |
invoice (draft): creation |
44.28 |
3094 |
5313 |
invoice (draft): removal |
51.53 |
897 |
6184 |
invoice accept: apply |
39.92 |
28417 |
4791 |
invoice accept: cancel |
46.54 |
1093 |
5585 |
customer reserve: creation |
3658.98 |
279 |
439078 |
customer reserve: removal |
4536.21 |
97 |
544345 |
realization accept: apply |
81.82 |
269 |
9818 |
realization accept: cancel |
80.72 |
169 |
9686 |
payment from customer: creation |
57.49 |
185 |
6899 |
payment from customer: removal |
5.39 |
141 |
647 |
payment to supplier: creation |
48.23 |
206 |
5788 |
payment to supplier: removal |
3.18 |
133 |
382 |
service: total inventory turnovers |
3.70 |
4057 |
444 |
service: total monetary turnovers |
7.61 |
467 |
913 |
service: aggregate perf. data |
0.92 |
13635 |
110 |
service: refresh index statistics |
0.04 |
364804 |
5 |
Completed "Performance in TOTAL". Done for 00:00:03, from 27-12-2022 04:38:19 to 27-12-2022 04:38:22.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
6130 |
TEST_TIME |
2 |
5569 |
TEST_TIME |
3 |
5250 |
TEST_TIME |
4 |
4999 |
TEST_TIME |
5 |
5212 |
TEST_TIME |
6 |
5478 |
TEST_TIME |
7 |
5501 |
TEST_TIME |
8 |
5638 |
TEST_TIME |
9 |
5563 |
TEST_TIME |
10 |
5730 |
TEST_TIME |
11 |
5854 |
TEST_TIME |
12 |
6373 |
TEST_TIME |
13 |
6449 |
TEST_TIME |
14 |
6499 |
TEST_TIME |
15 |
6596 |
TEST_TIME |
16 |
6798 |
TEST_TIME |
17 |
7055 |
TEST_TIME |
18 |
7400 |
TEST_TIME |
19 |
7368 |
TEST_TIME |
20 |
7496 |
TEST_TIME |
21 |
7874 |
TEST_TIME |
22 |
8001 |
TEST_TIME |
23 |
8072 |
TEST_TIME |
24 |
8454 |
TEST_TIME |
25 |
8619 |
TEST_TIME |
26 |
8736 |
TEST_TIME |
27 |
8882 |
TEST_TIME |
28 |
9407 |
TEST_TIME |
29 |
9914 |
TEST_TIME |
30 |
10280 |
TEST_TIME |
31 |
10300 |
TEST_TIME |
32 |
10371 |
TEST_TIME |
33 |
10285 |
TEST_TIME |
34 |
10279 |
TEST_TIME |
35 |
10364 |
TEST_TIME |
36 |
10326 |
TEST_TIME |
37 |
10405 |
TEST_TIME |
38 |
10161 |
TEST_TIME |
39 |
10025 |
TEST_TIME |
40 |
9882 |
TEST_TIME |
41 |
9745 |
TEST_TIME |
42 |
9752 |
TEST_TIME |
43 |
9717 |
TEST_TIME |
44 |
9725 |
TEST_TIME |
45 |
9694 |
TEST_TIME |
46 |
9560 |
TEST_TIME |
47 |
9432 |
TEST_TIME |
48 |
9380 |
TEST_TIME |
49 |
9211 |
TEST_TIME |
50 |
9327 |
TEST_TIME |
51 |
9255 |
TEST_TIME |
52 |
9279 |
TEST_TIME |
53 |
9225 |
TEST_TIME |
54 |
9209 |
TEST_TIME |
55 |
9254 |
TEST_TIME |
56 |
9255 |
TEST_TIME |
57 |
9227 |
TEST_TIME |
58 |
9227 |
TEST_TIME |
59 |
9231 |
TEST_TIME |
60 |
9378 |
TEST_TIME |
61 |
9330 |
TEST_TIME |
62 |
9338 |
TEST_TIME |
63 |
9417 |
TEST_TIME |
64 |
9352 |
TEST_TIME |
65 |
9318 |
TEST_TIME |
66 |
9274 |
TEST_TIME |
67 |
9154 |
TEST_TIME |
68 |
9178 |
TEST_TIME |
69 |
9185 |
TEST_TIME |
70 |
9099 |
TEST_TIME |
71 |
9036 |
TEST_TIME |
72 |
8951 |
TEST_TIME |
73 |
8854 |
TEST_TIME |
74 |
8828 |
TEST_TIME |
75 |
8804 |
TEST_TIME |
76 |
8894 |
TEST_TIME |
77 |
8893 |
TEST_TIME |
78 |
8902 |
TEST_TIME |
79 |
8950 |
TEST_TIME |
80 |
8977 |
TEST_TIME |
81 |
9027 |
TEST_TIME |
82 |
9163 |
TEST_TIME |
83 |
9123 |
TEST_TIME |
84 |
9134 |
TEST_TIME |
85 |
9130 |
TEST_TIME |
86 |
9179 |
TEST_TIME |
87 |
9189 |
TEST_TIME |
88 |
9126 |
TEST_TIME |
89 |
9106 |
TEST_TIME |
90 |
9048 |
TEST_TIME |
91 |
9028 |
TEST_TIME |
92 |
8999 |
TEST_TIME |
93 |
8955 |
TEST_TIME |
94 |
8977 |
TEST_TIME |
95 |
8911 |
TEST_TIME |
96 |
8878 |
TEST_TIME |
97 |
8869 |
TEST_TIME |
98 |
8831 |
TEST_TIME |
99 |
8818 |
TEST_TIME |
100 |
8791 |
TEST_TIME |
101 |
8767 |
TEST_TIME |
102 |
8754 |
TEST_TIME |
103 |
8778 |
TEST_TIME |
104 |
8746 |
TEST_TIME |
105 |
8734 |
TEST_TIME |
106 |
8803 |
TEST_TIME |
107 |
8778 |
TEST_TIME |
108 |
8851 |
TEST_TIME |
109 |
8922 |
TEST_TIME |
110 |
8890 |
TEST_TIME |
111 |
8938 |
TEST_TIME |
112 |
9058 |
TEST_TIME |
113 |
9015 |
TEST_TIME |
114 |
8976 |
TEST_TIME |
115 |
9004 |
TEST_TIME |
116 |
8968 |
TEST_TIME |
117 |
8936 |
TEST_TIME |
118 |
8958 |
TEST_TIME |
119 |
8965 |
TEST_TIME |
120 |
8913 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 27-12-2022 04:38:23 to 27-12-2022 04:38:27.
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 |
1474381 |
1474381 |
0 |
0.00 |
0 |
30947 |
14 |
0 |
0 |
doc_list_biud |
1474369 |
1474369 |
0 |
0.00 |
0 |
73207 |
42 |
0 |
0 |
sp_add_invoice_to_stock |
4978 |
4791 |
187 |
3.75 |
41 |
187306 |
28418 |
0 |
187 |
sp_cancel_adding_invoice |
5585 |
5585 |
0 |
0.00 |
5 |
102361 |
1093 |
0 |
0 |
sp_cancel_client_order |
1829 |
1829 |
0 |
0.00 |
6 |
18487 |
387 |
0 |
0 |
sp_cancel_customer_reserve |
544345 |
544345 |
0 |
0.00 |
1 |
73216 |
97 |
0 |
0 |
sp_cancel_pay_from_customer |
647 |
647 |
0 |
0.00 |
4 |
7366 |
141 |
0 |
0 |
sp_cancel_pay_to_supplier |
382 |
382 |
0 |
0.00 |
4 |
4184 |
134 |
0 |
0 |
sp_cancel_supplier_invoice |
6203 |
6184 |
19 |
0.30 |
3 |
40023 |
897 |
0 |
19 |
sp_cancel_supplier_order |
428 |
428 |
0 |
0.00 |
14 |
1267852 |
154326 |
0 |
0 |
sp_cancel_write_off |
9686 |
9686 |
0 |
0.00 |
2 |
36160 |
169 |
0 |
0 |
sp_client_order |
19711 |
19711 |
0 |
0.00 |
6 |
39493 |
486 |
0 |
0 |
sp_customer_reserve |
439078 |
439078 |
0 |
0.00 |
0 |
77946 |
280 |
0 |
0 |
sp_fill_shopping_cart |
30352 |
30352 |
0 |
0.00 |
2 |
14402 |
75 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
439043 |
439043 |
0 |
0.00 |
0 |
27369 |
19 |
0 |
0 |
sp_get_clo_for_invoice |
4750 |
4750 |
0 |
0.00 |
0 |
22743 |
238 |
0 |
0 |
sp_kill_cost_storno |
16300 |
16300 |
0 |
0.00 |
0 |
15949 |
69 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1104988 |
1104988 |
0 |
0.00 |
0 |
49633 |
43 |
0 |
0 |
sp_kill_qty_storno |
582623 |
582623 |
0 |
0.00 |
0 |
73204 |
98 |
0 |
0 |
sp_lock_selected_doc |
20349 |
20349 |
0 |
0.00 |
0 |
7499 |
6 |
0 |
0 |
sp_make_cost_storno |
27255 |
27255 |
0 |
0.00 |
0 |
30943 |
80 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27254 |
27254 |
0 |
0.00 |
0 |
11617 |
38 |
0 |
0 |
sp_multiply_rows_for_qdistr |
19709 |
19709 |
0 |
0.00 |
0 |
36652 |
179 |
0 |
0 |
sp_pay_from_customer |
6899 |
6899 |
0 |
0.00 |
5 |
30955 |
185 |
0 |
0 |
sp_pay_to_supplier |
5788 |
5788 |
0 |
0.00 |
6 |
13467 |
207 |
0 |
0 |
sp_payment_common |
12686 |
12686 |
0 |
0.00 |
2 |
10820 |
49 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1829 |
1829 |
0 |
0.00 |
0 |
18477 |
322 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10335 |
10335 |
0 |
0.00 |
0 |
48353 |
498 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9816 |
9816 |
0 |
0.00 |
0 |
35966 |
62 |
0 |
0 |
sp_reserve_write_off |
9818 |
9818 |
0 |
0.00 |
9 |
36248 |
269 |
0 |
0 |
sp_supplier_invoice |
5313 |
5313 |
0 |
0.00 |
12 |
140752 |
3094 |
0 |
0 |
sp_supplier_order |
5338 |
5338 |
0 |
0.00 |
7 |
97633 |
1425 |
0 |
0 |
srv_aggregate_perf_data |
110 |
110 |
0 |
0.00 |
2542 |
84419 |
13635 |
0 |
0 |
srv_fill_mon_cache_memory |
71 |
71 |
0 |
0.00 |
833 |
117017 |
33884 |
0 |
0 |
srv_find_qd_qs_mism |
1021656 |
1021656 |
0 |
0.00 |
0 |
17219 |
12 |
0 |
0 |
srv_make_invnt_saldo |
444 |
444 |
0 |
0.00 |
58 |
73483 |
4057 |
0 |
0 |
srv_make_money_saldo |
913 |
913 |
0 |
0.00 |
1 |
34600 |
467 |
0 |
0 |
srv_recalc_idx_stat |
5 |
5 |
0 |
0.00 |
241228 |
493355 |
364805 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
187 |
187 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
19 |
19 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4795 |
4795 |
0 |
0.00 |
1 |
14223 |
856 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
402 |
402 |
0 |
0.00 |
2 |
10495 |
450 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1829 |
1829 |
0 |
0.00 |
0 |
4092 |
31 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
657 |
657 |
0 |
0.00 |
0 |
13816 |
45 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
647 |
647 |
0 |
0.00 |
0 |
4810 |
22 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
382 |
382 |
0 |
0.00 |
0 |
344 |
12 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
413 |
413 |
0 |
0.00 |
0 |
1203 |
27 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
428 |
428 |
0 |
0.00 |
0 |
74865 |
6168 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1029 |
1029 |
0 |
0.00 |
0 |
878 |
15 |
0 |
0 |
t$perf-norm:sp_client_order |
19712 |
19712 |
0 |
0.00 |
0 |
11513 |
35 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
952 |
952 |
0 |
0.00 |
0 |
779 |
14 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
6899 |
6899 |
0 |
0.00 |
0 |
11045 |
22 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5788 |
5788 |
0 |
0.00 |
0 |
22821 |
21 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9818 |
9818 |
0 |
0.00 |
0 |
8086 |
20 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5314 |
5314 |
0 |
0.00 |
0 |
7560 |
31 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5339 |
5339 |
0 |
0.00 |
0 |
11034 |
33 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
110 |
110 |
0 |
0.00 |
0 |
569 |
18 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
71 |
71 |
0 |
0.00 |
0 |
476 |
18 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
444 |
444 |
0 |
0.00 |
0 |
865 |
12 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
913 |
913 |
0 |
0.00 |
0 |
410 |
4 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
5 |
5 |
0 |
0.00 |
14 |
213 |
115 |
0 |
0 |
v_add_invoice_to_stock |
9867 |
9493 |
374 |
3.79 |
0 |
5162 |
31 |
0 |
374 |
v_all_customers |
36586 |
36586 |
0 |
0.00 |
0 |
167 |
3 |
0 |
0 |
v_all_suppliers |
29864 |
29864 |
0 |
0.00 |
0 |
76 |
4 |
0 |
0 |
v_all_wares |
39416 |
39416 |
0 |
0.00 |
0 |
172 |
4 |
0 |
0 |
v_cancel_adding_invoice |
804 |
804 |
0 |
0.00 |
0 |
2217 |
20 |
0 |
0 |
v_cancel_client_order |
3658 |
3658 |
0 |
0.00 |
0 |
3149 |
10 |
0 |
0 |
v_cancel_customer_prepayment |
1294 |
1294 |
0 |
0.00 |
0 |
2656 |
14 |
0 |
0 |
v_cancel_customer_reserve |
1314 |
1314 |
0 |
0.00 |
1 |
4307 |
13 |
0 |
0 |
v_cancel_payment_to_supplier |
764 |
764 |
0 |
0.00 |
0 |
1826 |
15 |
0 |
0 |
v_cancel_supplier_invoice |
864 |
826 |
38 |
4.39 |
0 |
1880 |
23 |
0 |
38 |
v_cancel_supplier_order |
856 |
856 |
0 |
0.00 |
0 |
3251 |
18 |
0 |
0 |
v_cancel_write_off |
2058 |
2058 |
0 |
0.00 |
0 |
5594 |
25 |
0 |
0 |
v_max_id_clo_ord |
5335 |
5335 |
0 |
0.00 |
0 |
174 |
5 |
0 |
0 |
v_max_id_clo_res |
952 |
952 |
0 |
0.00 |
0 |
2601 |
18 |
0 |
0 |
v_max_id_ord_sup |
5308 |
5308 |
0 |
0.00 |
0 |
7318 |
8 |
0 |
0 |
v_max_non_paid_invoice |
1496 |
1496 |
0 |
0.00 |
0 |
189 |
8 |
0 |
0 |
v_max_non_paid_realizn |
3609 |
3609 |
0 |
0.00 |
0 |
1284 |
7 |
0 |
0 |
v_min_id_clo_ord |
5335 |
5335 |
0 |
0.00 |
0 |
2335 |
9 |
0 |
0 |
v_min_id_clo_res |
952 |
952 |
0 |
0.00 |
0 |
4583 |
18 |
0 |
0 |
v_min_id_ord_sup |
5308 |
5308 |
0 |
0.00 |
0 |
3083 |
9 |
0 |
0 |
v_min_non_paid_invoice |
5787 |
5787 |
0 |
0.00 |
0 |
7327 |
19 |
0 |
0 |
v_min_non_paid_realizn |
6899 |
6899 |
0 |
0.00 |
0 |
10804 |
27 |
0 |
0 |
v_our_firm |
9408 |
9408 |
0 |
0.00 |
0 |
69 |
4 |
0 |
0 |
v_reserve_write_off |
19630 |
19630 |
0 |
0.00 |
0 |
5018 |
13 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
11356 |
11356 |
0 |
0.00 |
0 |
10397 |
110 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
428 |
428 |
0 |
0.00 |
0 |
4278 |
340 |
0 |
0 |
x_make_qstorno_1000_1200 |
5338 |
5338 |
0 |
0.00 |
2 |
97606 |
1270 |
0 |
0 |
x_make_qstorno_1200_2000 |
5313 |
5313 |
0 |
0.00 |
4 |
138844 |
2888 |
0 |
0 |
x_make_qstorno_2100_3300 |
439078 |
439078 |
0 |
0.00 |
0 |
77944 |
249 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 27-12-2022 04:38:28 to 27-12-2022 04:38:32.
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 |
02:07:27 |
1 |
8192000000 |
8796669344 |
8807108608 |
3189136 |
0.038 |
1 |
1 |
2 |
0 |
3286752 |
61840 |
35776 |
02:08:29 |
35785 |
8192000000 |
9737912304 |
10039406592 |
813678384 |
9.035 |
100 |
87 |
174 |
0 |
842890944 |
7709424 |
21503136 |
02:10:13 |
13593 |
8192000000 |
9771939552 |
10079289344 |
846783200 |
9.368 |
100 |
94 |
188 |
0 |
882468544 |
13551344 |
22134000 |
02:11:31 |
12496 |
8192000000 |
9796419552 |
10117230592 |
867637888 |
9.576 |
100 |
84 |
168 |
0 |
912591728 |
25890688 |
19063152 |
02:12:50 |
8816 |
8192000000 |
9868525680 |
10203111424 |
912824576 |
10.025 |
100 |
78 |
156 |
0 |
974237872 |
44111936 |
17301360 |
02:14:02 |
3989 |
8192000000 |
9911108592 |
10257711104 |
947511056 |
10.367 |
100 |
81 |
162 |
0 |
1029583584 |
64816240 |
17256288 |
02:15:12 |
1609 |
8192000000 |
9961881360 |
10310123520 |
985923376 |
10.742 |
100 |
96 |
184 |
0 |
1079697856 |
75313392 |
18461088 |
02:16:15 |
1809 |
8192000000 |
9990456832 |
10349469696 |
1013410032 |
11.008 |
100 |
85 |
166 |
0 |
1113549872 |
83265552 |
16874288 |
02:17:20 |
942 |
8192000000 |
9985441024 |
10356707328 |
1036939072 |
11.235 |
100 |
94 |
184 |
0 |
1109611248 |
54644080 |
18028096 |
02:18:22 |
947 |
8192000000 |
10033324144 |
10408849408 |
1050993152 |
11.370 |
100 |
99 |
192 |
0 |
1157357088 |
87577104 |
18786832 |
02:19:24 |
1218 |
8192000000 |
10053379376 |
10430382080 |
1057127968 |
11.429 |
100 |
92 |
180 |
0 |
1173802944 |
98254848 |
18420128 |
02:20:27 |
915 |
8192000000 |
10012446448 |
10389651456 |
1067581360 |
11.529 |
100 |
82 |
158 |
0 |
1135728544 |
53127888 |
15019296 |
02:21:33 |
1435 |
8192000000 |
10037191536 |
10420031488 |
1068967584 |
11.542 |
100 |
88 |
172 |
1 |
1161301904 |
76004784 |
16329536 |
02:22:35 |
1093 |
8192000000 |
10043086432 |
10424463360 |
1081892592 |
11.666 |
100 |
97 |
185 |
2 |
1167164208 |
65699392 |
19572224 |
02:23:38 |
769 |
8192000000 |
10040384784 |
10425425920 |
1085708304 |
11.702 |
100 |
91 |
179 |
0 |
1162729952 |
59522016 |
17499632 |
02:24:40 |
1351 |
8192000000 |
10057235168 |
10446700544 |
1088667808 |
11.730 |
100 |
84 |
159 |
0 |
1180076768 |
75171808 |
16237152 |
02:25:42 |
1179 |
8192000000 |
10060798576 |
10450911232 |
1088556032 |
11.729 |
100 |
88 |
162 |
3 |
1184123056 |
78643696 |
16923328 |
02:26:45 |
1088 |
8192000000 |
10052147472 |
10438619136 |
1092253040 |
11.764 |
100 |
93 |
178 |
2 |
1169607792 |
60664112 |
16690640 |
02:27:48 |
1027 |
8192000000 |
10058151264 |
10450276352 |
1095429360 |
11.794 |
100 |
89 |
174 |
1 |
1183455904 |
70050288 |
17976256 |
02:28:50 |
1543 |
8192000000 |
10014221872 |
10411069440 |
1085160624 |
11.697 |
99 |
71 |
134 |
2 |
1143427424 |
44826160 |
13440640 |
02:29:52 |
1197 |
8192000000 |
10027412336 |
10412138496 |
1071473504 |
11.566 |
100 |
92 |
170 |
0 |
1153096240 |
62149040 |
19473696 |
02:30:55 |
1024 |
8192000000 |
10004970144 |
10388103168 |
1057727424 |
11.435 |
100 |
79 |
144 |
5 |
1125076832 |
51479360 |
15870048 |
02:31:56 |
925 |
8192000000 |
10042217360 |
10424807424 |
1072693936 |
11.578 |
100 |
96 |
180 |
0 |
1163257520 |
72145872 |
18417712 |
02:32:58 |
1275 |
8192000000 |
10021085312 |
10402668544 |
1053468400 |
11.394 |
100 |
82 |
160 |
1 |
1146225952 |
75898736 |
16858816 |
02:34:00 |
1020 |
8192000000 |
9977031552 |
10354376704 |
1019214800 |
11.064 |
100 |
83 |
160 |
1 |
1106982064 |
70403024 |
17364240 |
02:35:02 |
1973 |
8192000000 |
9996448704 |
10375331840 |
1036353008 |
11.230 |
100 |
77 |
151 |
1 |
1115458336 |
63985360 |
15119968 |
02:36:07 |
1505 |
8192000000 |
9985350512 |
10360233984 |
1038973184 |
11.255 |
100 |
88 |
166 |
1 |
1110016592 |
52088640 |
18954768 |
02:37:10 |
6602 |
8192000000 |
9962859376 |
10338627584 |
1021692112 |
11.088 |
98 |
63 |
119 |
1 |
1080423264 |
45984384 |
12746768 |
02:38:23 |
1131 |
8192000000 |
10013337184 |
10389778432 |
1057878064 |
11.436 |
100 |
92 |
173 |
1 |
1132987504 |
56588544 |
18520896 |
02:39:59 |
6684 |
8192000000 |
10046960960 |
10429599744 |
1082264304 |
11.669 |
100 |
73 |
139 |
2 |
1171754560 |
74965200 |
14525056 |
02:41:11 |
3056 |
8192000000 |
10055188512 |
10444955648 |
1094198832 |
11.783 |
100 |
76 |
145 |
0 |
1176334016 |
66756864 |
15378320 |
02:42:20 |
7895 |
8192000000 |
10086497248 |
10475769856 |
1105939072 |
11.894 |
100 |
69 |
129 |
0 |
1216617952 |
97617440 |
13061440 |
02:43:33 |
12783 |
8192000000 |
10151277008 |
10559938560 |
1120672816 |
12.033 |
100 |
67 |
130 |
1 |
1266874464 |
132205104 |
13996544 |
02:44:51 |
3893 |
8192000000 |
10152915184 |
10557267968 |
1130272848 |
12.124 |
100 |
72 |
141 |
0 |
1271301264 |
125397424 |
15630992 |
02:45:58 |
9399 |
8192000000 |
10217928368 |
10621931520 |
1147568128 |
12.287 |
100 |
75 |
148 |
1 |
1336472224 |
172137840 |
16766256 |
02:47:13 |
4522 |
8192000000 |
10228875264 |
10632876032 |
1157163824 |
12.377 |
100 |
75 |
147 |
0 |
1346992000 |
173618288 |
16209888 |
02:48:23 |
6213 |
8192000000 |
10290458688 |
10702983168 |
1170235296 |
12.499 |
100 |
91 |
181 |
0 |
1400055920 |
209605920 |
20214704 |
02:49:39 |
1312 |
8192000000 |
10282675696 |
10697715712 |
1177849968 |
12.570 |
100 |
92 |
178 |
0 |
1395517728 |
197086064 |
20581696 |
02:50:44 |
2139 |
8192000000 |
10318727584 |
10719780864 |
1180523536 |
12.595 |
100 |
85 |
164 |
1 |
1433621584 |
234741664 |
18356384 |
02:51:49 |
2583 |
8192000000 |
10351174672 |
10753232896 |
1176059712 |
12.553 |
100 |
91 |
172 |
0 |
1462868032 |
267231792 |
19576528 |
02:52:54 |
2525 |
8192000000 |
10374650080 |
10796220416 |
1187622064 |
12.661 |
100 |
90 |
178 |
2 |
1486192960 |
278363680 |
20207216 |
02:53:59 |
1123 |
8192000000 |
10403282080 |
10828341248 |
1187735296 |
12.662 |
100 |
97 |
188 |
1 |
1514333760 |
303732688 |
22865776 |
02:55:02 |
979 |
8192000000 |
10376148944 |
10811564032 |
1190079392 |
12.684 |
100 |
94 |
183 |
1 |
1485058560 |
273084736 |
21894432 |
02:56:05 |
826 |
8192000000 |
10403942640 |
10821337088 |
1194848528 |
12.728 |
100 |
96 |
183 |
0 |
1509407264 |
293676256 |
20882480 |
02:57:09 |
1814 |
8192000000 |
10439200576 |
10863575040 |
1195015136 |
12.730 |
100 |
93 |
171 |
1 |
1542808064 |
326730176 |
21062752 |
02:58:15 |
921 |
8192000000 |
10420081440 |
10871115776 |
1189774800 |
12.681 |
100 |
96 |
182 |
1 |
1523598608 |
312351632 |
21472176 |
02:59:19 |
1369 |
8192000000 |
10423591200 |
10841513984 |
1171330400 |
12.509 |
99 |
93 |
179 |
0 |
1531423440 |
338967232 |
21125808 |
03:00:22 |
3244 |
8192000000 |
10428416320 |
10872504320 |
1166009232 |
12.460 |
99 |
83 |
164 |
1 |
1527748096 |
342144640 |
19594224 |
03:01:30 |
5759 |
8192000000 |
10455348976 |
10906161152 |
1181952096 |
12.608 |
100 |
62 |
122 |
0 |
1563543568 |
366187936 |
15403536 |
03:02:55 |
16837 |
8192000000 |
10401195072 |
10865725440 |
1178902256 |
12.580 |
99 |
43 |
85 |
0 |
1504389968 |
315312448 |
10175264 |
03:04:25 |
21774 |
8192000000 |
10413514688 |
10886049792 |
1174768624 |
12.541 |
100 |
26 |
52 |
0 |
1511539568 |
329584976 |
7185968 |
03:05:53 |
21314 |
8192000000 |
10240007808 |
10794713088 |
1164014208 |
12.441 |
100 |
28 |
54 |
2 |
1410358960 |
239295824 |
7048928 |
03:07:28 |
33649 |
8192000000 |
10121713616 |
10592448512 |
1135421680 |
12.172 |
98 |
21 |
42 |
0 |
1249494832 |
108875488 |
5197664 |
03:09:03 |
49467 |
8192000000 |
10101649200 |
10540371968 |
1108603104 |
11.919 |
97 |
21 |
40 |
1 |
1173532384 |
60263056 |
4666224 |
03:10:55 |
58763 |
8192000000 |
10147789408 |
10598866944 |
1114859360 |
11.978 |
98 |
15 |
30 |
1 |
1201803536 |
83102032 |
3842144 |
03:13:17 |
73080 |
8192000000 |
10105624848 |
10565701632 |
1120243904 |
12.029 |
98 |
10 |
20 |
0 |
1192134272 |
69911584 |
1978784 |
03:15:32 |
117016 |
8192000000 |
10096305616 |
10534690816 |
1140369504 |
12.219 |
100 |
48 |
90 |
2 |
1197445248 |
46882608 |
10193136 |
03:18:31 |
25541 |
8192000000 |
10128091136 |
10562629632 |
1138373424 |
12.200 |
100 |
60 |
104 |
1 |
1212807664 |
62164112 |
12270128 |
03:19:57 |
52802 |
8192000000 |
10114048000 |
10584059904 |
1119023072 |
12.018 |
99 |
23 |
46 |
1 |
1236612272 |
112668448 |
4920752 |
03:21:51 |
48748 |
8192000000 |
10043125136 |
10510340096 |
1104488416 |
11.880 |
99 |
14 |
26 |
1 |
1141316608 |
34043744 |
2784448 |
03:23:43 |
55867 |
8192000000 |
10082799504 |
10524049408 |
1113631408 |
11.967 |
99 |
18 |
35 |
0 |
1165729456 |
48387696 |
3710352 |
03:25:39 |
25086 |
8192000000 |
10085940800 |
10540617728 |
1107481168 |
11.909 |
98 |
9 |
18 |
0 |
1177508736 |
68184336 |
1843232 |
03:27:04 |
62451 |
8192000000 |
10048061648 |
10559307776 |
1118748928 |
12.015 |
100 |
12 |
22 |
0 |
1175162688 |
54203392 |
2210368 |
03:29:07 |
22034 |
8192000000 |
10088345072 |
10522877952 |
1118773872 |
12.015 |
99 |
40 |
71 |
3 |
1159007824 |
34279808 |
5954144 |
03:30:33 |
24976 |
8192000000 |
10090716464 |
10524454912 |
1133568176 |
12.155 |
100 |
53 |
99 |
1 |
1191656272 |
46483168 |
11604928 |
03:31:58 |
9242 |
8192000000 |
10110581328 |
10552958976 |
1132748656 |
12.147 |
100 |
47 |
93 |
0 |
1196092880 |
54280400 |
9063824 |
03:33:10 |
28046 |
8192000000 |
10108937344 |
10548039680 |
1135401776 |
12.172 |
100 |
36 |
72 |
0 |
1192991392 |
50845264 |
6744352 |
03:34:39 |
20316 |
8192000000 |
10155439680 |
10589184000 |
1141682752 |
12.231 |
100 |
43 |
81 |
0 |
1230690432 |
80506112 |
8501568 |
03:36:01 |
20387 |
8192000000 |
10193176480 |
10639630336 |
1146889184 |
12.280 |
100 |
51 |
100 |
0 |
1264354032 |
106735472 |
10729376 |
03:37:22 |
28973 |
8192000000 |
10083498960 |
10555944960 |
1120115424 |
12.028 |
98 |
17 |
35 |
1 |
1165248704 |
41810160 |
3323120 |
03:39:07 |
12840 |
8192000000 |
10117259984 |
10542927872 |
1122324640 |
12.049 |
99 |
69 |
136 |
2 |
1204480976 |
68225888 |
13930448 |
03:40:23 |
40955 |
8192000000 |
10113511472 |
10578870272 |
1097697904 |
11.816 |
97 |
29 |
58 |
0 |
1175856960 |
71449408 |
6709648 |
03:42:10 |
100386 |
8192000000 |
10052584768 |
10496901120 |
1088585424 |
11.729 |
97 |
30 |
60 |
1 |
1134797280 |
40350592 |
5861264 |
03:46:02 |
82958 |
8192000000 |
10045892384 |
10510249984 |
1108343024 |
11.917 |
99 |
14 |
28 |
0 |
1157540160 |
46119680 |
3077456 |
03:48:30 |
66717 |
8192000000 |
10118936592 |
10567909376 |
1138343808 |
12.200 |
100 |
18 |
36 |
0 |
1201405920 |
59098432 |
3963680 |
03:50:38 |
99024 |
8192000000 |
10165030176 |
10649292800 |
1092133520 |
11.763 |
96 |
14 |
28 |
0 |
1236491568 |
140992592 |
3365456 |
03:53:33 |
47586 |
8192000000 |
10155422752 |
10655133696 |
1121231808 |
12.039 |
99 |
25 |
51 |
0 |
1254608944 |
127196496 |
6180640 |
03:55:21 |
49267 |
8192000000 |
10154844272 |
10626924544 |
1135931424 |
12.177 |
99 |
25 |
50 |
0 |
1286759712 |
145111744 |
5716544 |
03:57:16 |
57325 |
8192000000 |
10160671904 |
10617909248 |
1106618176 |
11.900 |
97 |
22 |
44 |
0 |
1229919280 |
118708624 |
4592480 |
03:59:14 |
56472 |
8192000000 |
10065151648 |
10531524608 |
1102550992 |
11.862 |
98 |
22 |
44 |
0 |
1180413744 |
73256704 |
4606048 |
04:01:10 |
9963 |
8192000000 |
10117565408 |
10561826816 |
1135035264 |
12.169 |
100 |
66 |
131 |
1 |
1198784432 |
50498944 |
13250224 |
04:02:22 |
54045 |
8192000000 |
10125700032 |
10609152000 |
1102832864 |
11.865 |
97 |
39 |
78 |
0 |
1195343168 |
84704704 |
7805600 |
04:04:22 |
114919 |
8192000000 |
10094255168 |
10551693312 |
1112027792 |
11.952 |
98 |
33 |
66 |
0 |
1185390384 |
66233680 |
7128912 |
04:07:38 |
69601 |
8192000000 |
10073613600 |
10550931456 |
1125740160 |
12.081 |
99 |
20 |
40 |
0 |
1172324768 |
41954656 |
4629952 |
04:11:02 |
63888 |
8192000000 |
10050283520 |
10550673408 |
1104434624 |
11.880 |
98 |
16 |
33 |
0 |
1141514960 |
33709024 |
3371312 |
04:13:19 |
61679 |
8192000000 |
10066503472 |
10542530560 |
1113203584 |
11.963 |
99 |
14 |
28 |
0 |
1162201184 |
46386656 |
2610944 |
04:15:24 |
18380 |
8192000000 |
10062670288 |
10509361152 |
1125866800 |
12.082 |
100 |
25 |
50 |
1 |
1159789568 |
28908976 |
5013792 |
04:16:43 |
41140 |
8192000000 |
10122905280 |
10567311360 |
1131664880 |
12.137 |
99 |
39 |
79 |
1 |
1204444512 |
64646320 |
8133312 |
04:18:25 |
33584 |
8192000000 |
10138415744 |
10575368192 |
1109730288 |
11.930 |
98 |
38 |
76 |
0 |
1199129248 |
81114896 |
8284064 |
04:20:11 |
31221 |
8192000000 |
10166348592 |
10617487360 |
1110613504 |
11.938 |
98 |
35 |
69 |
0 |
1242910800 |
124981152 |
7316144 |
04:21:49 |
32846 |
8192000000 |
10209637968 |
10658914304 |
1125823392 |
12.082 |
98 |
42 |
84 |
0 |
1300161648 |
165219136 |
9119120 |
04:23:22 |
27393 |
8192000000 |
10194710800 |
10626871296 |
1112976912 |
11.961 |
97 |
46 |
91 |
1 |
1257249456 |
134091920 |
10180624 |
04:24:52 |
29179 |
8192000000 |
10251856752 |
10718138368 |
1155140688 |
12.358 |
100 |
40 |
78 |
1 |
1336515376 |
172599648 |
8775040 |
04:26:36 |
52468 |
8192000000 |
10223755392 |
10722607104 |
1150066752 |
12.310 |
100 |
16 |
30 |
1 |
1349124304 |
195255536 |
3802016 |
04:28:47 |
60648 |
8192000000 |
10118688272 |
10771668992 |
1137196736 |
12.189 |
100 |
9 |
18 |
0 |
1278618352 |
139557200 |
1864416 |
04:30:54 |
45990 |
8192000000 |
10076179888 |
10506514432 |
1124895232 |
12.073 |
99 |
40 |
77 |
1 |
1146104400 |
13727440 |
7481728 |
04:32:45 |
84191 |
8192000000 |
10105589776 |
10543882240 |
1085104368 |
11.696 |
95 |
36 |
62 |
4 |
1160951216 |
68008896 |
7837952 |
04:35:10 |
21595 |
8192000000 |
10121907888 |
10551574528 |
1116394144 |
11.993 |
99 |
49 |
98 |
0 |
1208517552 |
82287872 |
9835536 |
04:36:32 |
42699 |
8192000000 |
10109318816 |
10570543104 |
1113594448 |
11.966 |
98 |
29 |
58 |
1 |
1170134032 |
50522448 |
6017136 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 27-12-2022 04:38:34 to 27-12-2022 04:38:50.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
187 |
v_add_invoice_to_stock |
335544517 |
except |
19 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-12-2022 04:38:51 to 27-12-2022 04:38:53.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 220385
MON$OLDEST_ACTIVE 223044
MON$OLDEST_SNAPSHOT 223044
MON$NEXT_TRANSACTION 223044
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 2052320
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 {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID 02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT 781
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.3.2885 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.3.2885 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.3.2885 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.3.2885 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0
Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
:553:
:554: mscs-test-161.budzdorov.ru Tue Dec 27 04:37:30 2022
:555: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:556:
:557:
:558: mscs-test-161.budzdorov.ru Tue Dec 27 04:37:36 2022
:559: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:560:
:561:
:562: mscs-test-161.budzdorov.ru Tue Dec 27 04:37:36 2022
:563: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:564:
:565:
:566: mscs-test-161.budzdorov.ru Tue Dec 27 04:37:37 2022
:567: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:568:
:569:
:570: mscs-test-161.budzdorov.ru Tue Dec 27 04:37:37 2022
:571: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:572:
--- end of diff output ---
27.12.22 04:38:54. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
335544321 'string truncation'. Attempt to assign too long text into string variable.
335544347 'not_valid'. Validation error for column.
335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT |
ERRORS_RESULT |
2022-12-27 04:38:57 |
No severe PSQL-related problems occured |
27.12.22 04:38:58. End of report.