Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.04.2022 10:38
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 | 16062812 kB |
MemAvailable | 31546800 kB |
Buffers | 0 kB |
Cached | 15665064 kB |
SwapCached | 2688 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.2
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-04-15 10:37:14
DTS_END 2022-04-15 10:37:14.9520
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/50704
TRN_ID 212303
ATT_ID 555
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: |
8972.82 |
24718 |
1076738 |
customer order: creation |
168.37 |
493 |
20204 |
customer order: refuse |
13.88 |
510 |
1665 |
order to supplier: creation |
45.26 |
1487 |
5431 |
order to supplier: removal |
3.43 |
192770 |
411 |
invoice (draft): creation |
45.05 |
3583 |
5406 |
invoice (draft): removal |
49.58 |
1162 |
5950 |
invoice accept: apply |
40.53 |
28327 |
4864 |
invoice accept: cancel |
45.31 |
1417 |
5437 |
customer reserve: creation |
3794.96 |
264 |
455395 |
customer reserve: removal |
4482.59 |
114 |
537911 |
realization accept: apply |
80.72 |
327 |
9687 |
realization accept: cancel |
73.57 |
191 |
8828 |
payment from customer: creation |
58.49 |
198 |
7019 |
payment from customer: removal |
5.71 |
169 |
685 |
payment to supplier: creation |
48.88 |
200 |
5866 |
payment to supplier: removal |
3.28 |
126 |
394 |
service: total inventory turnovers |
3.84 |
4693 |
461 |
service: total monetary turnovers |
8.23 |
376 |
987 |
service: aggregate perf. data |
1.11 |
16141 |
133 |
service: refresh index statistics |
0.03 |
241808 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 15-04-2022 10:38:56 to 15-04-2022 10:38:58.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
8824 |
TEST_TIME |
2 |
6942 |
TEST_TIME |
3 |
6312 |
TEST_TIME |
4 |
5902 |
TEST_TIME |
5 |
5990 |
TEST_TIME |
6 |
5947 |
TEST_TIME |
7 |
5917 |
TEST_TIME |
8 |
6163 |
TEST_TIME |
9 |
6190 |
TEST_TIME |
10 |
6312 |
TEST_TIME |
11 |
6378 |
TEST_TIME |
12 |
6705 |
TEST_TIME |
13 |
6768 |
TEST_TIME |
14 |
6945 |
TEST_TIME |
15 |
6918 |
TEST_TIME |
16 |
7053 |
TEST_TIME |
17 |
7295 |
TEST_TIME |
18 |
7476 |
TEST_TIME |
19 |
7627 |
TEST_TIME |
20 |
7700 |
TEST_TIME |
21 |
7709 |
TEST_TIME |
22 |
7772 |
TEST_TIME |
23 |
7870 |
TEST_TIME |
24 |
8080 |
TEST_TIME |
25 |
7996 |
TEST_TIME |
26 |
8017 |
TEST_TIME |
27 |
8106 |
TEST_TIME |
28 |
8025 |
TEST_TIME |
29 |
8117 |
TEST_TIME |
30 |
8388 |
TEST_TIME |
31 |
8500 |
TEST_TIME |
32 |
8643 |
TEST_TIME |
33 |
9140 |
TEST_TIME |
34 |
9529 |
TEST_TIME |
35 |
9411 |
TEST_TIME |
36 |
9431 |
TEST_TIME |
37 |
10025 |
TEST_TIME |
38 |
10151 |
TEST_TIME |
39 |
10262 |
TEST_TIME |
40 |
10734 |
TEST_TIME |
41 |
10763 |
TEST_TIME |
42 |
10561 |
TEST_TIME |
43 |
10660 |
TEST_TIME |
44 |
10671 |
TEST_TIME |
45 |
10713 |
TEST_TIME |
46 |
10569 |
TEST_TIME |
47 |
10418 |
TEST_TIME |
48 |
10245 |
TEST_TIME |
49 |
10121 |
TEST_TIME |
50 |
10156 |
TEST_TIME |
51 |
10268 |
TEST_TIME |
52 |
10134 |
TEST_TIME |
53 |
9962 |
TEST_TIME |
54 |
9863 |
TEST_TIME |
55 |
9824 |
TEST_TIME |
56 |
9729 |
TEST_TIME |
57 |
9661 |
TEST_TIME |
58 |
9809 |
TEST_TIME |
59 |
9913 |
TEST_TIME |
60 |
9828 |
TEST_TIME |
61 |
9808 |
TEST_TIME |
62 |
9769 |
TEST_TIME |
63 |
9674 |
TEST_TIME |
64 |
9621 |
TEST_TIME |
65 |
9661 |
TEST_TIME |
66 |
9592 |
TEST_TIME |
67 |
9641 |
TEST_TIME |
68 |
9609 |
TEST_TIME |
69 |
9615 |
TEST_TIME |
70 |
9612 |
TEST_TIME |
71 |
9638 |
TEST_TIME |
72 |
9580 |
TEST_TIME |
73 |
9569 |
TEST_TIME |
74 |
9662 |
TEST_TIME |
75 |
9667 |
TEST_TIME |
76 |
9646 |
TEST_TIME |
77 |
9597 |
TEST_TIME |
78 |
9644 |
TEST_TIME |
79 |
9555 |
TEST_TIME |
80 |
9576 |
TEST_TIME |
81 |
9491 |
TEST_TIME |
82 |
9436 |
TEST_TIME |
83 |
9433 |
TEST_TIME |
84 |
9379 |
TEST_TIME |
85 |
9316 |
TEST_TIME |
86 |
9258 |
TEST_TIME |
87 |
9219 |
TEST_TIME |
88 |
9191 |
TEST_TIME |
89 |
9166 |
TEST_TIME |
90 |
9249 |
TEST_TIME |
91 |
9234 |
TEST_TIME |
92 |
9200 |
TEST_TIME |
93 |
9214 |
TEST_TIME |
94 |
9242 |
TEST_TIME |
95 |
9245 |
TEST_TIME |
96 |
9281 |
TEST_TIME |
97 |
9402 |
TEST_TIME |
98 |
9405 |
TEST_TIME |
99 |
9371 |
TEST_TIME |
100 |
9401 |
TEST_TIME |
101 |
9396 |
TEST_TIME |
102 |
9468 |
TEST_TIME |
103 |
9404 |
TEST_TIME |
104 |
9367 |
TEST_TIME |
105 |
9299 |
TEST_TIME |
106 |
9285 |
TEST_TIME |
107 |
9299 |
TEST_TIME |
108 |
9255 |
TEST_TIME |
109 |
9261 |
TEST_TIME |
110 |
9219 |
TEST_TIME |
111 |
9161 |
TEST_TIME |
112 |
9125 |
TEST_TIME |
113 |
9086 |
TEST_TIME |
114 |
9070 |
TEST_TIME |
115 |
9096 |
TEST_TIME |
116 |
9070 |
TEST_TIME |
117 |
9053 |
TEST_TIME |
118 |
9052 |
TEST_TIME |
119 |
9026 |
TEST_TIME |
120 |
8992 |
Completed "Performance for every MINUTE". Done for 00:00:03, from 15-04-2022 10:39:00 to 15-04-2022 10:39:03.
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 |
1495935 |
1495935 |
0 |
0.00 |
0 |
22332 |
16 |
0 |
0 |
doc_list_biud |
1495923 |
1495923 |
0 |
0.00 |
0 |
105939 |
47 |
0 |
0 |
sp_add_invoice_to_stock |
4993 |
4864 |
129 |
2.58 |
77 |
213195 |
28327 |
0 |
129 |
sp_cancel_adding_invoice |
5437 |
5437 |
0 |
0.00 |
8 |
79898 |
1418 |
0 |
0 |
sp_cancel_client_order |
1665 |
1665 |
0 |
0.00 |
6 |
10555 |
511 |
0 |
0 |
sp_cancel_customer_reserve |
537911 |
537911 |
0 |
0.00 |
1 |
33853 |
115 |
0 |
0 |
sp_cancel_pay_from_customer |
685 |
685 |
0 |
0.00 |
4 |
5925 |
169 |
0 |
0 |
sp_cancel_pay_to_supplier |
394 |
394 |
0 |
0.00 |
4 |
1379 |
127 |
0 |
0 |
sp_cancel_supplier_invoice |
5961 |
5950 |
11 |
0.18 |
3 |
105963 |
1163 |
0 |
11 |
sp_cancel_supplier_order |
411 |
411 |
0 |
0.00 |
10 |
1478251 |
192771 |
0 |
0 |
sp_cancel_write_off |
8828 |
8828 |
0 |
0.00 |
2 |
12279 |
192 |
0 |
0 |
sp_client_order |
20204 |
20204 |
0 |
0.00 |
6 |
14493 |
493 |
0 |
0 |
sp_customer_reserve |
455395 |
455395 |
0 |
0.00 |
1 |
97523 |
265 |
0 |
0 |
sp_fill_shopping_cart |
31025 |
31025 |
0 |
0.00 |
1 |
22222 |
95 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
455374 |
455374 |
0 |
0.00 |
0 |
15334 |
19 |
0 |
0 |
sp_get_clo_for_invoice |
4838 |
4838 |
0 |
0.00 |
0 |
30606 |
294 |
0 |
0 |
sp_kill_cost_storno |
15344 |
15344 |
0 |
0.00 |
0 |
17778 |
93 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1091011 |
1091011 |
0 |
0.00 |
0 |
105936 |
49 |
0 |
0 |
sp_kill_qty_storno |
574724 |
574724 |
0 |
0.00 |
0 |
105939 |
114 |
0 |
0 |
sp_lock_selected_doc |
20140 |
20140 |
0 |
0.00 |
0 |
11931 |
10 |
0 |
0 |
sp_make_cost_storno |
27410 |
27410 |
0 |
0.00 |
0 |
22295 |
95 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27406 |
27406 |
0 |
0.00 |
0 |
11676 |
44 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20203 |
20203 |
0 |
0.00 |
0 |
8946 |
181 |
0 |
0 |
sp_pay_from_customer |
7019 |
7019 |
0 |
0.00 |
5 |
19368 |
198 |
0 |
0 |
sp_pay_to_supplier |
5866 |
5866 |
0 |
0.00 |
7 |
17564 |
201 |
0 |
0 |
sp_payment_common |
12883 |
12883 |
0 |
0.00 |
2 |
8941 |
51 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1665 |
1665 |
0 |
0.00 |
1 |
10541 |
407 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10274 |
10274 |
0 |
0.00 |
0 |
22826 |
634 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9685 |
9685 |
0 |
0.00 |
0 |
13397 |
67 |
0 |
0 |
sp_reserve_write_off |
9687 |
9687 |
0 |
0.00 |
9 |
20576 |
327 |
0 |
0 |
sp_supplier_invoice |
5406 |
5406 |
0 |
0.00 |
11 |
128168 |
3584 |
0 |
0 |
sp_supplier_order |
5431 |
5431 |
0 |
0.00 |
7 |
39842 |
1488 |
0 |
0 |
srv_aggregate_perf_data |
133 |
133 |
0 |
0.00 |
2182 |
169457 |
16141 |
0 |
0 |
srv_fill_mon_cache_memory |
76 |
76 |
0 |
0.00 |
880 |
157129 |
29044 |
0 |
0 |
srv_find_qd_qs_mism |
1028357 |
1028357 |
0 |
0.00 |
0 |
12256 |
12 |
0 |
0 |
srv_make_invnt_saldo |
461 |
461 |
0 |
0.00 |
53 |
67108 |
4694 |
0 |
0 |
srv_make_money_saldo |
987 |
987 |
0 |
0.00 |
1 |
10189 |
377 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
65406 |
364666 |
241809 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
129 |
129 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
11 |
11 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4869 |
4869 |
0 |
0.00 |
1 |
16972 |
1147 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
401 |
401 |
0 |
0.00 |
2 |
7550 |
508 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1665 |
1665 |
0 |
0.00 |
0 |
2592 |
32 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
651 |
651 |
0 |
0.00 |
0 |
2558 |
39 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
685 |
685 |
0 |
0.00 |
0 |
248 |
12 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
394 |
394 |
0 |
0.00 |
0 |
1184 |
21 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
393 |
393 |
0 |
0.00 |
0 |
5112 |
72 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
411 |
411 |
0 |
0.00 |
0 |
117148 |
8786 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1022 |
1022 |
0 |
0.00 |
0 |
2298 |
22 |
0 |
0 |
t$perf-norm:sp_client_order |
20204 |
20204 |
0 |
0.00 |
0 |
15320 |
41 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
1018 |
1018 |
0 |
0.00 |
0 |
2614 |
20 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7019 |
7019 |
0 |
0.00 |
0 |
14434 |
23 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5866 |
5866 |
0 |
0.00 |
0 |
6205 |
22 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9687 |
9687 |
0 |
0.00 |
0 |
14325 |
27 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5408 |
5408 |
0 |
0.00 |
0 |
4486 |
36 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5432 |
5432 |
0 |
0.00 |
0 |
4570 |
36 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
133 |
133 |
0 |
0.00 |
0 |
1679 |
32 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
76 |
76 |
0 |
0.00 |
0 |
516 |
13 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
461 |
461 |
0 |
0.00 |
0 |
15373 |
63 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
987 |
987 |
0 |
0.00 |
0 |
325 |
5 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
6 |
211 |
71 |
0 |
0 |
v_add_invoice_to_stock |
9924 |
9666 |
258 |
2.59 |
0 |
8516 |
29 |
0 |
258 |
v_all_customers |
37254 |
37254 |
0 |
0.00 |
0 |
153 |
4 |
0 |
0 |
v_all_suppliers |
30714 |
30714 |
0 |
0.00 |
0 |
80 |
5 |
0 |
0 |
v_all_wares |
40396 |
40396 |
0 |
0.00 |
0 |
152 |
4 |
0 |
0 |
v_cancel_adding_invoice |
802 |
802 |
0 |
0.00 |
0 |
8314 |
34 |
0 |
0 |
v_cancel_client_order |
3330 |
3330 |
0 |
0.00 |
0 |
8319 |
19 |
0 |
0 |
v_cancel_customer_prepayment |
1370 |
1370 |
0 |
0.00 |
0 |
5859 |
20 |
0 |
0 |
v_cancel_customer_reserve |
1302 |
1302 |
0 |
0.00 |
0 |
3681 |
14 |
0 |
0 |
v_cancel_payment_to_supplier |
788 |
788 |
0 |
0.00 |
0 |
1102 |
12 |
0 |
0 |
v_cancel_supplier_invoice |
808 |
786 |
22 |
2.72 |
0 |
412 |
27 |
0 |
22 |
v_cancel_supplier_order |
822 |
822 |
0 |
0.00 |
0 |
676 |
12 |
0 |
0 |
v_cancel_write_off |
2044 |
2044 |
0 |
0.00 |
0 |
4954 |
26 |
0 |
0 |
v_max_id_clo_ord |
5427 |
5427 |
0 |
0.00 |
0 |
1551 |
6 |
0 |
0 |
v_max_id_clo_res |
1017 |
1017 |
0 |
0.00 |
0 |
2938 |
24 |
0 |
0 |
v_max_id_ord_sup |
5400 |
5400 |
0 |
0.00 |
0 |
2849 |
7 |
0 |
0 |
v_max_non_paid_invoice |
1334 |
1334 |
0 |
0.00 |
0 |
274 |
9 |
0 |
0 |
v_max_non_paid_realizn |
3636 |
3636 |
0 |
0.00 |
0 |
3324 |
9 |
0 |
0 |
v_min_id_clo_ord |
5426 |
5426 |
0 |
0.00 |
0 |
4297 |
11 |
0 |
0 |
v_min_id_clo_res |
1017 |
1017 |
0 |
0.00 |
0 |
3089 |
18 |
0 |
0 |
v_min_id_ord_sup |
5400 |
5400 |
0 |
0.00 |
0 |
5238 |
9 |
0 |
0 |
v_min_non_paid_invoice |
5865 |
5865 |
0 |
0.00 |
0 |
5874 |
17 |
0 |
0 |
v_min_non_paid_realizn |
7018 |
7018 |
0 |
0.00 |
0 |
5937 |
20 |
0 |
0 |
v_our_firm |
9906 |
9906 |
0 |
0.00 |
0 |
56 |
5 |
0 |
0 |
v_reserve_write_off |
19370 |
19370 |
0 |
0.00 |
0 |
8339 |
12 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
10994 |
10994 |
0 |
0.00 |
0 |
16850 |
149 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
411 |
411 |
0 |
0.00 |
0 |
3666 |
362 |
0 |
0 |
x_make_qstorno_1000_1200 |
5431 |
5431 |
0 |
0.00 |
2 |
39825 |
1274 |
0 |
0 |
x_make_qstorno_1200_2000 |
5406 |
5406 |
0 |
0.00 |
5 |
127430 |
3341 |
0 |
0 |
x_make_qstorno_2100_3300 |
455395 |
455395 |
0 |
0.00 |
0 |
97495 |
232 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 15-04-2022 10:39:04 to 15-04-2022 10:39:08.
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 |
08:07:18 |
3 |
8192000000 |
8796669024 |
8807174144 |
3189120 |
0.038 |
1 |
1 |
2 |
0 |
3286736 |
61840 |
35776 |
08:08:19 |
9030 |
8192000000 |
9712525232 |
10009280512 |
794428992 |
8.840 |
100 |
88 |
176 |
1 |
823659440 |
7415184 |
21815264 |
08:09:35 |
21925 |
8192000000 |
9745144736 |
10049773568 |
823336688 |
9.132 |
100 |
92 |
184 |
0 |
857132832 |
10618864 |
23177280 |
08:11:03 |
17014 |
8192000000 |
9779065408 |
10093572096 |
846863072 |
9.369 |
100 |
86 |
172 |
0 |
883458032 |
16064848 |
20530112 |
08:12:28 |
12592 |
8192000000 |
9839730144 |
10166935552 |
903576992 |
9.934 |
100 |
77 |
154 |
0 |
950592896 |
30602752 |
16413152 |
08:13:45 |
6626 |
8192000000 |
9889245408 |
10230599680 |
945218304 |
10.344 |
100 |
83 |
161 |
2 |
1009388080 |
47077216 |
17092560 |
08:14:54 |
6921 |
8192000000 |
9954920752 |
10302140416 |
983030032 |
10.714 |
100 |
86 |
171 |
2 |
1067264432 |
66582944 |
17651456 |
08:16:04 |
3070 |
8192000000 |
9971824080 |
10325606400 |
1004697504 |
10.924 |
100 |
90 |
176 |
1 |
1089191056 |
66325072 |
18168480 |
08:17:09 |
2323 |
8192000000 |
10000621056 |
10362425344 |
1026290144 |
11.133 |
100 |
90 |
173 |
0 |
1112473280 |
69062544 |
17120592 |
08:18:14 |
1607 |
8192000000 |
10006243360 |
10376941568 |
1045330048 |
11.316 |
100 |
89 |
174 |
0 |
1125553088 |
62649696 |
17573344 |
08:19:17 |
1104 |
8192000000 |
10023084416 |
10395103232 |
1053494448 |
11.394 |
100 |
99 |
192 |
2 |
1142773280 |
68623040 |
20655792 |
08:20:20 |
1026 |
8192000000 |
10012655472 |
10388508672 |
1056942272 |
11.427 |
100 |
90 |
169 |
1 |
1136021232 |
60389584 |
18689376 |
08:21:23 |
1197 |
8192000000 |
10052620160 |
10433122304 |
1063541360 |
11.490 |
100 |
92 |
179 |
0 |
1177508800 |
95614784 |
18352656 |
08:22:27 |
1256 |
8192000000 |
10033023664 |
10411917312 |
1068975328 |
11.542 |
100 |
90 |
162 |
2 |
1152650032 |
67713296 |
15961408 |
08:23:31 |
1284 |
8192000000 |
10065954080 |
10451812352 |
1077109616 |
11.620 |
100 |
93 |
180 |
1 |
1192676560 |
97557504 |
18009440 |
08:24:33 |
1044 |
8192000000 |
10038264048 |
10426757120 |
1082922512 |
11.675 |
100 |
91 |
177 |
2 |
1157317632 |
55671616 |
18723504 |
08:25:38 |
1244 |
8192000000 |
10037776928 |
10424410112 |
1084231232 |
11.688 |
100 |
96 |
187 |
0 |
1160802848 |
57145152 |
19426464 |
08:26:40 |
1342 |
8192000000 |
10053682816 |
10441220096 |
1085548272 |
11.700 |
100 |
98 |
189 |
1 |
1171506464 |
67373232 |
18584960 |
08:27:42 |
1232 |
8192000000 |
10055548960 |
10441543680 |
1089520064 |
11.738 |
100 |
95 |
186 |
1 |
1176113824 |
67403760 |
19190000 |
08:28:45 |
1516 |
8192000000 |
10063050976 |
10452221952 |
1095500048 |
11.795 |
100 |
95 |
179 |
4 |
1188023040 |
73386720 |
19136272 |
08:29:49 |
1161 |
8192000000 |
10054092640 |
10442653696 |
1090202336 |
11.745 |
100 |
99 |
193 |
3 |
1176809728 |
68186800 |
18420592 |
08:30:52 |
1125 |
8192000000 |
10036832256 |
10419859456 |
1073613680 |
11.587 |
99 |
89 |
169 |
0 |
1158687824 |
67159104 |
17915040 |
08:31:56 |
1422 |
8192000000 |
10029446256 |
10408325120 |
1069468192 |
11.547 |
100 |
94 |
183 |
0 |
1150094096 |
61987840 |
18638064 |
08:32:59 |
1178 |
8192000000 |
10025760432 |
10403942400 |
1067057888 |
11.524 |
100 |
95 |
188 |
0 |
1144070256 |
58854400 |
18157968 |
08:34:01 |
1138 |
8192000000 |
10034980976 |
10413129728 |
1047643792 |
11.338 |
99 |
95 |
184 |
0 |
1157629440 |
91322288 |
18663360 |
08:35:03 |
1252 |
8192000000 |
9996981168 |
10365071360 |
1031983984 |
11.188 |
100 |
97 |
188 |
2 |
1118421088 |
68014176 |
18422928 |
08:36:05 |
2725 |
8192000000 |
9976307744 |
10355425280 |
1020269968 |
11.075 |
100 |
78 |
138 |
1 |
1095107792 |
61642944 |
13194880 |
08:37:09 |
4377 |
8192000000 |
9974610832 |
10351128576 |
1021917632 |
11.091 |
100 |
58 |
109 |
0 |
1090576832 |
57189184 |
11470016 |
08:38:18 |
3297 |
8192000000 |
10020716544 |
10391572480 |
1045097040 |
11.314 |
100 |
96 |
188 |
1 |
1137243968 |
72967392 |
19179536 |
08:39:46 |
15682 |
8192000000 |
10045757312 |
10427838464 |
1067904352 |
11.532 |
100 |
73 |
142 |
2 |
1159932640 |
78277712 |
13750576 |
08:41:06 |
11795 |
8192000000 |
10080867824 |
10471714816 |
1088847680 |
11.732 |
100 |
66 |
132 |
0 |
1206819744 |
102993840 |
14978224 |
08:42:29 |
10596 |
8192000000 |
10084684288 |
10485624832 |
1097492272 |
11.814 |
100 |
59 |
117 |
0 |
1206759296 |
96753888 |
12513136 |
08:43:48 |
6123 |
8192000000 |
10135982752 |
10528669696 |
1108216560 |
11.916 |
100 |
72 |
142 |
0 |
1254280272 |
130439360 |
15624352 |
08:45:07 |
1659 |
8192000000 |
10165923280 |
10558599168 |
1119762928 |
12.025 |
100 |
84 |
156 |
2 |
1282625248 |
145296928 |
17565392 |
08:46:14 |
4039 |
8192000000 |
10176983744 |
10571538432 |
1129564464 |
12.117 |
100 |
84 |
158 |
3 |
1291974352 |
145352928 |
17056960 |
08:47:29 |
2722 |
8192000000 |
10198207008 |
10612301824 |
1133379984 |
12.153 |
100 |
70 |
137 |
0 |
1312247120 |
163607024 |
15260112 |
08:48:36 |
1238 |
8192000000 |
10217939344 |
10621034496 |
1147112816 |
12.282 |
100 |
81 |
150 |
2 |
1326205744 |
161939504 |
17153424 |
08:49:44 |
972 |
8192000000 |
10241464272 |
10638360576 |
1163660720 |
12.438 |
100 |
93 |
178 |
4 |
1351678848 |
167896224 |
20121904 |
08:50:47 |
1800 |
8192000000 |
10255381888 |
10663018496 |
1170327616 |
12.500 |
100 |
92 |
180 |
2 |
1371571152 |
180784368 |
20459168 |
08:51:53 |
2709 |
8192000000 |
10272970192 |
10679533568 |
1171249536 |
12.509 |
100 |
92 |
178 |
3 |
1385122096 |
193554224 |
20318336 |
08:53:00 |
1435 |
8192000000 |
10327408320 |
10730418176 |
1182230784 |
12.611 |
100 |
97 |
193 |
0 |
1432619072 |
229013808 |
21374480 |
08:54:05 |
931 |
8192000000 |
10304426240 |
10742403072 |
1185182576 |
12.639 |
100 |
97 |
187 |
2 |
1418002320 |
210882240 |
21937504 |
08:55:08 |
1634 |
8192000000 |
10360039024 |
10779009024 |
1195924432 |
12.738 |
100 |
96 |
186 |
0 |
1464094208 |
247321824 |
20847952 |
08:56:16 |
949 |
8192000000 |
10396268432 |
10804703232 |
1201162016 |
12.787 |
100 |
97 |
192 |
1 |
1501826560 |
279553520 |
21111024 |
08:57:20 |
1269 |
8192000000 |
10412960752 |
10821255168 |
1204500000 |
12.818 |
100 |
96 |
190 |
1 |
1526071632 |
299660480 |
21911152 |
08:58:25 |
1492 |
8192000000 |
10433597696 |
10846416896 |
1193087360 |
12.712 |
99 |
94 |
185 |
0 |
1540418448 |
326539856 |
20791232 |
08:59:30 |
920 |
8192000000 |
10472614848 |
10891952128 |
1192066480 |
12.703 |
100 |
96 |
185 |
2 |
1577115776 |
362343616 |
22705680 |
09:00:34 |
1001 |
8192000000 |
10484825424 |
10925486080 |
1197494432 |
12.753 |
100 |
95 |
189 |
1 |
1592795216 |
372032928 |
23267856 |
09:01:37 |
871 |
8192000000 |
10464649552 |
10868785152 |
1187123696 |
12.657 |
100 |
94 |
185 |
0 |
1569835120 |
360423584 |
22287840 |
09:02:44 |
908 |
8192000000 |
10520407072 |
10937143296 |
1188702464 |
12.671 |
100 |
92 |
184 |
0 |
1621798512 |
410922032 |
22174016 |
09:03:49 |
932 |
8192000000 |
10555212720 |
10984861696 |
1195254944 |
12.732 |
100 |
82 |
160 |
1 |
1660471824 |
444689008 |
20527872 |
09:04:52 |
2042 |
8192000000 |
10557365328 |
10994221056 |
1188070928 |
12.665 |
100 |
87 |
168 |
0 |
1661310416 |
451330608 |
21908880 |
09:05:58 |
1103 |
8192000000 |
10585715472 |
11042557952 |
1184664496 |
12.634 |
100 |
83 |
165 |
1 |
1691272416 |
485028688 |
21579232 |
09:07:03 |
2708 |
8192000000 |
10603917856 |
11056689152 |
1193156368 |
12.713 |
100 |
93 |
178 |
1 |
1703293680 |
487447216 |
22690096 |
09:08:08 |
3030 |
8192000000 |
10599399616 |
11041107968 |
1181560352 |
12.605 |
100 |
80 |
156 |
0 |
1703497472 |
502310880 |
19626240 |
09:09:18 |
1252 |
8192000000 |
10586875680 |
11043282944 |
1186932784 |
12.655 |
100 |
70 |
134 |
0 |
1683906816 |
480256336 |
16717696 |
09:10:24 |
7155 |
8192000000 |
10578394080 |
11072651264 |
1198006448 |
12.758 |
100 |
66 |
132 |
0 |
1682578416 |
468422928 |
16149040 |
09:11:33 |
15163 |
8192000000 |
10470630272 |
10956791808 |
1189987648 |
12.683 |
100 |
39 |
78 |
1 |
1587607984 |
387746192 |
9874144 |
09:12:50 |
6597 |
8192000000 |
10478772624 |
10935840768 |
1172583280 |
12.521 |
100 |
42 |
82 |
0 |
1574320880 |
390237744 |
11499856 |
09:13:59 |
14705 |
8192000000 |
10390856336 |
10915446784 |
1156021984 |
12.366 |
99 |
32 |
64 |
1 |
1511765984 |
346777344 |
8966656 |
09:15:15 |
19368 |
8192000000 |
10357144016 |
10897260544 |
1156865776 |
12.374 |
100 |
22 |
44 |
0 |
1448234608 |
285657376 |
5711456 |
09:16:37 |
44104 |
8192000000 |
10253778208 |
10779357184 |
1144725024 |
12.260 |
100 |
15 |
30 |
0 |
1389203280 |
240670512 |
3807744 |
09:18:21 |
53455 |
8192000000 |
10129090800 |
10569883648 |
1149005408 |
12.300 |
100 |
17 |
34 |
0 |
1224477120 |
71361952 |
4109760 |
09:20:19 |
16060 |
8192000000 |
10190091664 |
10625245184 |
1150144544 |
12.311 |
100 |
53 |
103 |
0 |
1272142704 |
110423328 |
11574832 |
09:21:52 |
62541 |
8192000000 |
10105777408 |
10605240320 |
1146809808 |
12.280 |
100 |
10 |
20 |
0 |
1197645584 |
48739248 |
2096528 |
09:24:05 |
157129 |
8192000000 |
10148263856 |
10607140864 |
1142222416 |
12.236 |
99 |
33 |
62 |
1 |
1203814544 |
54106528 |
7485600 |
09:27:48 |
77571 |
8192000000 |
10100332960 |
10579914752 |
1151880464 |
12.327 |
100 |
25 |
49 |
4 |
1218070592 |
61051472 |
5138656 |
09:30:09 |
51818 |
8192000000 |
10133135520 |
10577436672 |
1158751184 |
12.392 |
99 |
50 |
98 |
1 |
1218179104 |
48794256 |
10633664 |
09:32:03 |
19076 |
8192000000 |
10178986720 |
10612727808 |
1161641904 |
12.419 |
100 |
62 |
113 |
2 |
1270239984 |
97107024 |
11491056 |
09:33:29 |
10297 |
8192000000 |
10173044800 |
10607247360 |
1144747168 |
12.260 |
100 |
68 |
122 |
4 |
1278951824 |
119709808 |
14494848 |
09:34:43 |
12472 |
8192000000 |
10241796144 |
10676678656 |
1133522592 |
12.155 |
99 |
55 |
108 |
1 |
1322214976 |
176483504 |
12208880 |
09:35:59 |
18646 |
8192000000 |
10161709440 |
10651406336 |
1122094896 |
12.047 |
99 |
12 |
24 |
0 |
1268991600 |
143957680 |
2939024 |
09:37:25 |
42715 |
8192000000 |
10083795536 |
10556248064 |
1117418192 |
12.003 |
98 |
11 |
21 |
1 |
1197727952 |
78094832 |
2214928 |
09:39:08 |
69521 |
8192000000 |
10089482688 |
10561519616 |
1145883808 |
12.271 |
100 |
18 |
34 |
0 |
1200782016 |
50635392 |
4262816 |
09:41:19 |
98728 |
8192000000 |
10063772048 |
10568724480 |
1109030640 |
11.923 |
97 |
6 |
12 |
0 |
1139590192 |
29514656 |
1044896 |
09:43:59 |
54614 |
8192000000 |
10075009200 |
10543345664 |
1123695616 |
12.062 |
98 |
29 |
58 |
0 |
1168729232 |
39135296 |
5898320 |
09:45:54 |
20365 |
8192000000 |
10112221040 |
10558058496 |
1144205472 |
12.255 |
100 |
41 |
70 |
1 |
1194912672 |
42156880 |
8550320 |
09:47:19 |
31054 |
8192000000 |
10076178784 |
10538577920 |
1132328208 |
12.143 |
99 |
18 |
36 |
0 |
1197628880 |
61457840 |
3842832 |
09:48:51 |
24677 |
8192000000 |
10087333456 |
10535514112 |
1145694768 |
12.269 |
100 |
25 |
50 |
0 |
1197793344 |
47163536 |
4935040 |
09:50:19 |
31258 |
8192000000 |
10120460688 |
10563608576 |
1107186304 |
11.906 |
96 |
29 |
56 |
2 |
1196635136 |
83629120 |
5819712 |
09:51:53 |
92567 |
8192000000 |
10072966032 |
10519519232 |
1110259488 |
11.935 |
97 |
12 |
24 |
0 |
1135669872 |
22768320 |
2642064 |
09:54:42 |
22616 |
8192000000 |
10161681184 |
10604122112 |
1154763936 |
12.354 |
100 |
29 |
56 |
3 |
1252550240 |
92091424 |
5694880 |
09:56:05 |
105079 |
8192000000 |
10080212416 |
10555777024 |
1127466480 |
12.097 |
98 |
19 |
38 |
1 |
1202349088 |
70864304 |
4018304 |
09:58:53 |
31076 |
8192000000 |
10093463456 |
10574790656 |
1142300224 |
12.237 |
99 |
25 |
48 |
1 |
1188416432 |
41284688 |
4831520 |
10:00:30 |
52499 |
8192000000 |
10050520800 |
10524807168 |
1120901552 |
12.036 |
98 |
6 |
12 |
0 |
1143836096 |
21835728 |
1098816 |
10:02:30 |
77336 |
8192000000 |
10095613200 |
10566217728 |
1117176192 |
12.000 |
97 |
11 |
22 |
0 |
1162112928 |
42559024 |
2377712 |
10:05:23 |
53699 |
8192000000 |
10108853648 |
10578264064 |
1128508848 |
12.107 |
100 |
17 |
34 |
0 |
1225323552 |
92992736 |
3821968 |
10:07:21 |
58053 |
8192000000 |
10089353488 |
10549907456 |
1153505504 |
12.342 |
100 |
26 |
51 |
1 |
1208631088 |
49891616 |
5233968 |
10:09:19 |
10642 |
8192000000 |
10155268848 |
10587140096 |
1141922192 |
12.234 |
100 |
43 |
86 |
0 |
1259115600 |
108433152 |
8760256 |
10:10:33 |
40186 |
8192000000 |
10146634448 |
10579267584 |
1071784224 |
11.569 |
94 |
26 |
52 |
0 |
1187070448 |
109656672 |
5629552 |
10:12:13 |
44054 |
8192000000 |
10177478848 |
10632929280 |
1129295888 |
12.115 |
100 |
29 |
58 |
2 |
1276624752 |
141584992 |
5743872 |
10:14:21 |
40422 |
8192000000 |
10087858112 |
10554109952 |
1091421424 |
11.756 |
97 |
40 |
80 |
2 |
1156010688 |
55787872 |
8801392 |
10:16:03 |
14599 |
8192000000 |
10090998880 |
10509631488 |
1109293040 |
11.926 |
99 |
65 |
130 |
2 |
1166113488 |
43497232 |
13323216 |
10:17:18 |
50849 |
8192000000 |
10118174320 |
10614542336 |
1109945552 |
11.932 |
99 |
29 |
56 |
2 |
1242465568 |
126335824 |
6184192 |
10:19:41 |
50765 |
8192000000 |
10067422464 |
10504863744 |
1100462336 |
11.842 |
98 |
42 |
81 |
3 |
1138053376 |
28638880 |
8952160 |
10:21:38 |
77429 |
8192000000 |
10090924656 |
10534400000 |
1117147936 |
12.000 |
99 |
28 |
56 |
0 |
1193158800 |
70241376 |
5769488 |
10:23:56 |
70731 |
8192000000 |
10070248112 |
10556743680 |
1119850320 |
12.026 |
99 |
15 |
30 |
1 |
1188681520 |
65745104 |
3086096 |
10:26:07 |
65732 |
8192000000 |
10050524768 |
10512031744 |
1119086880 |
12.018 |
99 |
15 |
31 |
0 |
1157058448 |
35114880 |
2856688 |
10:28:15 |
22865 |
8192000000 |
10059479376 |
10507616256 |
1116808720 |
11.997 |
99 |
52 |
99 |
2 |
1159651456 |
32488048 |
10354688 |
10:29:38 |
74815 |
8192000000 |
10078804832 |
10564349952 |
1130206992 |
12.123 |
100 |
12 |
24 |
0 |
1188487312 |
55479456 |
2800864 |
10:31:53 |
48389 |
8192000000 |
10079799216 |
10576506880 |
1139671488 |
12.212 |
100 |
20 |
40 |
1 |
1224648624 |
80629184 |
4347952 |
10:33:47 |
24324 |
8192000000 |
10129058352 |
10572455936 |
1128571584 |
12.108 |
98 |
40 |
79 |
3 |
1223434944 |
85982208 |
8881152 |
10:35:18 |
13193 |
8192000000 |
10180861328 |
10612248576 |
1142725520 |
12.241 |
100 |
46 |
92 |
0 |
1267103280 |
114060368 |
10317392 |
10:36:32 |
20937 |
8192000000 |
10216537760 |
10653872128 |
1151167504 |
12.320 |
100 |
47 |
94 |
1 |
1322085984 |
160368400 |
10550080 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:17, from 15-04-2022 10:39:10 to 15-04-2022 10:39:27.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
129 |
v_add_invoice_to_stock |
335544517 |
except |
11 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-04-2022 10:39:28 to 15-04-2022 10:39:30.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 206299
MON$OLDEST_ACTIVE 214752
MON$OLDEST_SNAPSHOT 214752
MON$NEXT_TRANSACTION 214752
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 2102208
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 765
MON$NEXT_STATEMENT 53
MON$REPLICA_MODE 0
ISQL Version: LI-V4.0.2.2761 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2761 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2761 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2761 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 ---
:111:
:112: mscs-test-161.budzdorov.ru Fri Apr 15 10:37:23 2022
:113: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:114:
:115:
:116: mscs-test-161.budzdorov.ru Fri Apr 15 10:37:28 2022
:117: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:118:
--- end of diff output ---
15.04.22 10:39:31. 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-04-15 10:39:33 |
No severe PSQL-related problems occured |
15.04.22 10:39:35. End of report.