Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.12.2022 04: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 | 14963156 kB |
MemAvailable | 30032208 kB |
Buffers | 20 kB |
Cached | 16686152 kB |
SwapCached | 3468 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-18 04:37:22
DTS_END 2022-12-18 04:37:22.6000
FB_GDSCODE -1
FB_MNEMONA
STACK SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP ::1/34482
TRN_ID 224085
ATT_ID 671
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: |
8760.80 |
25371 |
1051296 |
customer order: creation |
171.31 |
444 |
20557 |
customer order: refuse |
14.66 |
380 |
1759 |
order to supplier: creation |
44.69 |
1259 |
5363 |
order to supplier: removal |
3.28 |
161276 |
393 |
invoice (draft): creation |
45.58 |
3077 |
5470 |
invoice (draft): removal |
46.95 |
927 |
5634 |
invoice accept: apply |
41.28 |
29944 |
4953 |
invoice accept: cancel |
42.23 |
1181 |
5068 |
customer reserve: creation |
3869.90 |
287 |
464388 |
customer reserve: removal |
4197.32 |
101 |
503678 |
realization accept: apply |
82.63 |
262 |
9916 |
realization accept: cancel |
71.31 |
174 |
8557 |
payment from customer: creation |
60.06 |
171 |
7207 |
payment from customer: removal |
5.83 |
147 |
700 |
payment to supplier: creation |
47.55 |
188 |
5706 |
payment to supplier: removal |
3.53 |
103 |
424 |
service: total inventory turnovers |
4.16 |
3585 |
499 |
service: total monetary turnovers |
7.68 |
343 |
922 |
service: aggregate perf. data |
0.82 |
17949 |
98 |
service: refresh index statistics |
0.03 |
285626 |
4 |
Completed "Performance in TOTAL". Done for 00:00:03, from 18-12-2022 04:39:06 to 18-12-2022 04:39:09.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
4891 |
TEST_TIME |
2 |
3964 |
TEST_TIME |
3 |
4652 |
TEST_TIME |
4 |
4411 |
TEST_TIME |
5 |
5116 |
TEST_TIME |
6 |
5414 |
TEST_TIME |
7 |
5465 |
TEST_TIME |
8 |
6398 |
TEST_TIME |
9 |
6622 |
TEST_TIME |
10 |
6877 |
TEST_TIME |
11 |
7084 |
TEST_TIME |
12 |
7159 |
TEST_TIME |
13 |
7212 |
TEST_TIME |
14 |
7286 |
TEST_TIME |
15 |
7333 |
TEST_TIME |
16 |
7591 |
TEST_TIME |
17 |
7666 |
TEST_TIME |
18 |
7922 |
TEST_TIME |
19 |
7842 |
TEST_TIME |
20 |
8034 |
TEST_TIME |
21 |
8132 |
TEST_TIME |
22 |
8306 |
TEST_TIME |
23 |
8484 |
TEST_TIME |
24 |
9090 |
TEST_TIME |
25 |
9310 |
TEST_TIME |
26 |
9496 |
TEST_TIME |
27 |
9819 |
TEST_TIME |
28 |
10364 |
TEST_TIME |
29 |
10806 |
TEST_TIME |
30 |
11184 |
TEST_TIME |
31 |
10917 |
TEST_TIME |
32 |
10668 |
TEST_TIME |
33 |
10636 |
TEST_TIME |
34 |
10474 |
TEST_TIME |
35 |
10198 |
TEST_TIME |
36 |
10029 |
TEST_TIME |
37 |
10098 |
TEST_TIME |
38 |
9963 |
TEST_TIME |
39 |
9865 |
TEST_TIME |
40 |
9722 |
TEST_TIME |
41 |
9543 |
TEST_TIME |
42 |
9454 |
TEST_TIME |
43 |
9359 |
TEST_TIME |
44 |
9408 |
TEST_TIME |
45 |
9319 |
TEST_TIME |
46 |
9510 |
TEST_TIME |
47 |
9505 |
TEST_TIME |
48 |
9595 |
TEST_TIME |
49 |
9525 |
TEST_TIME |
50 |
9473 |
TEST_TIME |
51 |
9413 |
TEST_TIME |
52 |
9402 |
TEST_TIME |
53 |
9527 |
TEST_TIME |
54 |
9459 |
TEST_TIME |
55 |
9421 |
TEST_TIME |
56 |
9493 |
TEST_TIME |
57 |
9486 |
TEST_TIME |
58 |
9508 |
TEST_TIME |
59 |
9488 |
TEST_TIME |
60 |
9390 |
TEST_TIME |
61 |
9339 |
TEST_TIME |
62 |
9231 |
TEST_TIME |
63 |
9192 |
TEST_TIME |
64 |
9129 |
TEST_TIME |
65 |
9043 |
TEST_TIME |
66 |
8965 |
TEST_TIME |
67 |
8976 |
TEST_TIME |
68 |
8973 |
TEST_TIME |
69 |
8929 |
TEST_TIME |
70 |
8881 |
TEST_TIME |
71 |
8873 |
TEST_TIME |
72 |
8886 |
TEST_TIME |
73 |
8885 |
TEST_TIME |
74 |
8872 |
TEST_TIME |
75 |
8873 |
TEST_TIME |
76 |
8939 |
TEST_TIME |
77 |
8976 |
TEST_TIME |
78 |
8933 |
TEST_TIME |
79 |
9073 |
TEST_TIME |
80 |
9081 |
TEST_TIME |
81 |
9062 |
TEST_TIME |
82 |
9054 |
TEST_TIME |
83 |
9083 |
TEST_TIME |
84 |
9057 |
TEST_TIME |
85 |
8996 |
TEST_TIME |
86 |
8953 |
TEST_TIME |
87 |
8959 |
TEST_TIME |
88 |
8910 |
TEST_TIME |
89 |
8848 |
TEST_TIME |
90 |
8799 |
TEST_TIME |
91 |
8770 |
TEST_TIME |
92 |
8758 |
TEST_TIME |
93 |
8774 |
TEST_TIME |
94 |
8743 |
TEST_TIME |
95 |
8716 |
TEST_TIME |
96 |
8688 |
TEST_TIME |
97 |
8720 |
TEST_TIME |
98 |
8701 |
TEST_TIME |
99 |
8679 |
TEST_TIME |
100 |
8664 |
TEST_TIME |
101 |
8660 |
TEST_TIME |
102 |
8701 |
TEST_TIME |
103 |
8672 |
TEST_TIME |
104 |
8707 |
TEST_TIME |
105 |
8634 |
TEST_TIME |
106 |
8780 |
TEST_TIME |
107 |
8873 |
TEST_TIME |
108 |
8916 |
TEST_TIME |
109 |
8890 |
TEST_TIME |
110 |
8849 |
TEST_TIME |
111 |
8865 |
TEST_TIME |
112 |
8863 |
TEST_TIME |
113 |
8861 |
TEST_TIME |
114 |
8896 |
TEST_TIME |
115 |
8875 |
TEST_TIME |
116 |
8877 |
TEST_TIME |
117 |
8922 |
TEST_TIME |
118 |
8873 |
TEST_TIME |
119 |
8849 |
TEST_TIME |
120 |
8784 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 18-12-2022 04:39:10 to 18-12-2022 04:39:14.
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 |
1477077 |
1477077 |
0 |
0.00 |
0 |
28994 |
14 |
0 |
0 |
doc_list_biud |
1477072 |
1477072 |
0 |
0.00 |
0 |
49275 |
40 |
0 |
0 |
sp_add_invoice_to_stock |
5079 |
4953 |
126 |
2.48 |
27 |
241861 |
29944 |
0 |
126 |
sp_cancel_adding_invoice |
5068 |
5068 |
0 |
0.00 |
5 |
79399 |
1182 |
0 |
0 |
sp_cancel_client_order |
1759 |
1759 |
0 |
0.00 |
6 |
8326 |
381 |
0 |
0 |
sp_cancel_customer_reserve |
503678 |
503678 |
0 |
0.00 |
1 |
49281 |
101 |
0 |
0 |
sp_cancel_pay_from_customer |
700 |
700 |
0 |
0.00 |
3 |
6917 |
148 |
0 |
0 |
sp_cancel_pay_to_supplier |
424 |
424 |
0 |
0.00 |
4 |
1936 |
103 |
0 |
0 |
sp_cancel_supplier_invoice |
5641 |
5634 |
7 |
0.12 |
2 |
20616 |
928 |
0 |
7 |
sp_cancel_supplier_order |
393 |
393 |
0 |
0.00 |
13 |
1353116 |
161277 |
0 |
0 |
sp_cancel_write_off |
8557 |
8557 |
0 |
0.00 |
2 |
5910 |
175 |
0 |
0 |
sp_client_order |
20557 |
20557 |
0 |
0.00 |
5 |
22751 |
444 |
0 |
0 |
sp_customer_reserve |
464388 |
464388 |
0 |
0.00 |
0 |
111742 |
287 |
0 |
0 |
sp_fill_shopping_cart |
31388 |
31388 |
0 |
0.00 |
1 |
19805 |
76 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
464377 |
464377 |
0 |
0.00 |
0 |
16032 |
19 |
0 |
0 |
sp_get_clo_for_invoice |
4914 |
4914 |
0 |
0.00 |
0 |
47842 |
318 |
0 |
0 |
sp_kill_cost_storno |
14749 |
14749 |
0 |
0.00 |
0 |
14651 |
72 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1021940 |
1021940 |
0 |
0.00 |
0 |
41228 |
44 |
0 |
0 |
sp_kill_qty_storno |
539919 |
539919 |
0 |
0.00 |
0 |
49274 |
100 |
0 |
0 |
sp_lock_selected_doc |
20639 |
20639 |
0 |
0.00 |
0 |
7403 |
7 |
0 |
0 |
sp_make_cost_storno |
27743 |
27743 |
0 |
0.00 |
0 |
19977 |
74 |
0 |
0 |
sp_multiply_rows_for_pdistr |
27743 |
27743 |
0 |
0.00 |
0 |
10210 |
35 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20557 |
20557 |
0 |
0.00 |
0 |
20160 |
169 |
0 |
0 |
sp_pay_from_customer |
7207 |
7207 |
0 |
0.00 |
5 |
12703 |
171 |
0 |
0 |
sp_pay_to_supplier |
5706 |
5706 |
0 |
0.00 |
6 |
14256 |
188 |
0 |
0 |
sp_payment_common |
12913 |
12913 |
0 |
0.00 |
2 |
6919 |
41 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1759 |
1759 |
0 |
0.00 |
1 |
8307 |
295 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
9982 |
9982 |
0 |
0.00 |
0 |
21365 |
482 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
9916 |
9916 |
0 |
0.00 |
0 |
12770 |
53 |
0 |
0 |
sp_reserve_write_off |
9916 |
9916 |
0 |
0.00 |
7 |
19998 |
262 |
0 |
0 |
sp_supplier_invoice |
5470 |
5470 |
0 |
0.00 |
7 |
81560 |
3077 |
0 |
0 |
sp_supplier_order |
5363 |
5363 |
0 |
0.00 |
7 |
21642 |
1260 |
0 |
0 |
srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
2570 |
160518 |
17949 |
0 |
0 |
srv_fill_mon_cache_memory |
68 |
68 |
0 |
0.00 |
729 |
153368 |
37827 |
0 |
0 |
srv_find_qd_qs_mism |
1001484 |
1001484 |
0 |
0.00 |
0 |
28613 |
12 |
0 |
0 |
srv_make_invnt_saldo |
499 |
499 |
0 |
0.00 |
48 |
91435 |
3586 |
0 |
0 |
srv_make_money_saldo |
922 |
922 |
0 |
0.00 |
1 |
11830 |
344 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
161493 |
404030 |
285626 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
126 |
126 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
7 |
7 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
4953 |
4953 |
0 |
0.00 |
1 |
17234 |
893 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
400 |
400 |
0 |
0.00 |
1 |
6604 |
481 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1759 |
1759 |
0 |
0.00 |
0 |
1506 |
25 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
738 |
738 |
0 |
0.00 |
0 |
1266 |
23 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
700 |
700 |
0 |
0.00 |
0 |
5738 |
24 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
424 |
424 |
0 |
0.00 |
0 |
1224 |
14 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
384 |
384 |
0 |
0.00 |
0 |
784 |
29 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
393 |
393 |
0 |
0.00 |
0 |
78990 |
5771 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1011 |
1011 |
0 |
0.00 |
0 |
2561 |
20 |
0 |
0 |
t$perf-norm:sp_client_order |
20557 |
20557 |
0 |
0.00 |
0 |
7572 |
34 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
994 |
994 |
0 |
0.00 |
0 |
2699 |
14 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7207 |
7207 |
0 |
0.00 |
0 |
11231 |
21 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
5706 |
5706 |
0 |
0.00 |
0 |
6200 |
19 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
9916 |
9916 |
0 |
0.00 |
0 |
11257 |
21 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5470 |
5470 |
0 |
0.00 |
0 |
3311 |
25 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5363 |
5363 |
0 |
0.00 |
0 |
3479 |
27 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
98 |
98 |
0 |
0.00 |
0 |
383 |
8 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
68 |
68 |
0 |
0.00 |
0 |
233 |
11 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
499 |
499 |
0 |
0.00 |
0 |
3469 |
17 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
922 |
922 |
0 |
0.00 |
0 |
661 |
5 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
6 |
199 |
84 |
0 |
0 |
v_add_invoice_to_stock |
10078 |
9826 |
252 |
2.50 |
0 |
7172 |
28 |
0 |
252 |
v_all_customers |
37888 |
37888 |
0 |
0.00 |
0 |
82 |
4 |
0 |
0 |
v_all_suppliers |
29938 |
29938 |
0 |
0.00 |
0 |
122 |
4 |
0 |
0 |
v_all_wares |
41114 |
41114 |
0 |
0.00 |
0 |
85 |
4 |
0 |
0 |
v_cancel_adding_invoice |
800 |
800 |
0 |
0.00 |
0 |
97 |
12 |
0 |
0 |
v_cancel_client_order |
3518 |
3518 |
0 |
0.00 |
0 |
6143 |
16 |
0 |
0 |
v_cancel_customer_prepayment |
1400 |
1400 |
0 |
0.00 |
0 |
2540 |
17 |
0 |
0 |
v_cancel_customer_reserve |
1476 |
1476 |
0 |
0.00 |
0 |
3013 |
18 |
0 |
0 |
v_cancel_payment_to_supplier |
848 |
848 |
0 |
0.00 |
0 |
1873 |
15 |
0 |
0 |
v_cancel_supplier_invoice |
782 |
768 |
14 |
1.79 |
0 |
743 |
23 |
0 |
14 |
v_cancel_supplier_order |
786 |
786 |
0 |
0.00 |
0 |
2103 |
15 |
0 |
0 |
v_cancel_write_off |
2022 |
2022 |
0 |
0.00 |
0 |
1977 |
25 |
0 |
0 |
v_max_id_clo_ord |
5363 |
5363 |
0 |
0.00 |
0 |
333 |
5 |
0 |
0 |
v_max_id_clo_res |
994 |
994 |
0 |
0.00 |
0 |
4464 |
15 |
0 |
0 |
v_max_id_ord_sup |
5468 |
5468 |
0 |
0.00 |
0 |
5452 |
7 |
0 |
0 |
v_max_non_paid_invoice |
1568 |
1568 |
0 |
0.00 |
0 |
222 |
7 |
0 |
0 |
v_max_non_paid_realizn |
3681 |
3681 |
0 |
0.00 |
0 |
6054 |
9 |
0 |
0 |
v_min_id_clo_ord |
5363 |
5363 |
0 |
0.00 |
0 |
2440 |
8 |
0 |
0 |
v_min_id_clo_res |
994 |
994 |
0 |
0.00 |
0 |
2995 |
15 |
0 |
0 |
v_min_id_ord_sup |
5468 |
5468 |
0 |
0.00 |
0 |
9972 |
10 |
0 |
0 |
v_min_non_paid_invoice |
5706 |
5706 |
0 |
0.00 |
0 |
3921 |
14 |
0 |
0 |
v_min_non_paid_realizn |
7207 |
7207 |
0 |
0.00 |
0 |
6912 |
15 |
0 |
0 |
v_our_firm |
10278 |
10278 |
0 |
0.00 |
0 |
55 |
4 |
0 |
0 |
v_reserve_write_off |
19832 |
19832 |
0 |
0.00 |
0 |
6384 |
14 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
10318 |
10318 |
0 |
0.00 |
0 |
11050 |
113 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
393 |
393 |
0 |
0.00 |
0 |
2728 |
282 |
0 |
0 |
x_make_qstorno_1000_1200 |
5363 |
5363 |
0 |
0.00 |
2 |
21619 |
1108 |
0 |
0 |
x_make_qstorno_1200_2000 |
5470 |
5470 |
0 |
0.00 |
3 |
81515 |
2868 |
0 |
0 |
x_make_qstorno_2100_3300 |
464387 |
464387 |
0 |
0.00 |
0 |
111732 |
255 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 18-12-2022 04:39:15 to 18-12-2022 04:39:19.
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:26 |
2 |
8192000000 |
8796669344 |
8807108608 |
3189136 |
0.038 |
1 |
1 |
2 |
0 |
3286752 |
61840 |
35776 |
02:08:27 |
26107 |
8192000000 |
9738307856 |
10038112256 |
813194352 |
9.030 |
100 |
93 |
186 |
0 |
843724304 |
8243072 |
22286880 |
02:09:57 |
23454 |
8192000000 |
9777407968 |
10091335680 |
847955168 |
9.380 |
100 |
83 |
166 |
0 |
883585728 |
16312752 |
19317808 |
02:11:28 |
11168 |
8192000000 |
9809888800 |
10130014208 |
877620496 |
9.676 |
100 |
83 |
165 |
1 |
918862704 |
22431632 |
18810576 |
02:12:44 |
7684 |
8192000000 |
9860296912 |
10195410944 |
915563728 |
10.052 |
100 |
80 |
159 |
0 |
971991312 |
39333776 |
17093808 |
02:13:55 |
3124 |
8192000000 |
9912363632 |
10254786560 |
954416528 |
10.434 |
100 |
85 |
163 |
0 |
1025791712 |
53979072 |
17396112 |
02:15:01 |
2046 |
8192000000 |
9946918944 |
10299805696 |
994449504 |
10.825 |
100 |
86 |
161 |
1 |
1070030432 |
58859328 |
16721600 |
02:16:09 |
1556 |
8192000000 |
9986342464 |
10349219840 |
1016700240 |
11.040 |
100 |
96 |
184 |
2 |
1101355312 |
66054320 |
18600752 |
02:17:13 |
892 |
8192000000 |
10020203472 |
10386976768 |
1035536752 |
11.222 |
100 |
99 |
193 |
1 |
1142353536 |
87692560 |
19124224 |
02:18:14 |
887 |
8192000000 |
10013471936 |
10387410944 |
1049910400 |
11.360 |
100 |
88 |
169 |
3 |
1134095520 |
68484896 |
15700224 |
02:19:16 |
1023 |
8192000000 |
10031382704 |
10410901504 |
1061052448 |
11.467 |
100 |
94 |
177 |
1 |
1152469408 |
73161120 |
18255840 |
02:20:18 |
1730 |
8192000000 |
10050304384 |
10430898176 |
1067806240 |
11.531 |
100 |
84 |
156 |
1 |
1166981968 |
84697552 |
14478176 |
02:21:21 |
7740 |
8192000000 |
10033296064 |
10418057216 |
1076975936 |
11.619 |
100 |
68 |
131 |
2 |
1154448400 |
64089008 |
13383456 |
02:22:30 |
1202 |
8192000000 |
10062201328 |
10449666048 |
1082833104 |
11.674 |
100 |
98 |
190 |
0 |
1184326992 |
81603824 |
19890064 |
02:23:32 |
1585 |
8192000000 |
10054949136 |
10438778880 |
1092114512 |
11.763 |
100 |
92 |
181 |
2 |
1174876000 |
64622448 |
18139040 |
02:24:34 |
1084 |
8192000000 |
10060148208 |
10452340736 |
1093881520 |
11.780 |
100 |
89 |
175 |
1 |
1179174784 |
68155552 |
17137712 |
02:25:37 |
1113 |
8192000000 |
10062932224 |
10451406848 |
1097703680 |
11.816 |
100 |
97 |
181 |
2 |
1187746960 |
70601328 |
19441952 |
02:26:39 |
891 |
8192000000 |
10066702384 |
10458284032 |
1097877072 |
11.817 |
100 |
86 |
165 |
0 |
1190967984 |
75667152 |
17423760 |
02:27:42 |
1084 |
8192000000 |
10063666656 |
10453336064 |
1098199136 |
11.821 |
100 |
100 |
185 |
2 |
1185426336 |
68197088 |
19030112 |
02:28:44 |
1012 |
8192000000 |
10019607296 |
10401882112 |
1076221200 |
11.611 |
99 |
94 |
176 |
3 |
1143824688 |
48899504 |
18703984 |
02:29:47 |
1165 |
8192000000 |
10041766256 |
10430410752 |
1079660896 |
11.644 |
100 |
95 |
180 |
1 |
1167855360 |
68772800 |
19421664 |
02:30:48 |
1180 |
8192000000 |
10041875120 |
10429988864 |
1085488032 |
11.700 |
100 |
86 |
163 |
1 |
1160828416 |
60134816 |
15205568 |
02:31:51 |
8855 |
8192000000 |
9989435968 |
10376327168 |
1039068624 |
11.256 |
98 |
52 |
98 |
1 |
1096608784 |
48153408 |
9386752 |
02:33:01 |
1077 |
8192000000 |
10022628352 |
10399227904 |
1051765520 |
11.378 |
100 |
97 |
182 |
0 |
1147481296 |
75780768 |
19935008 |
02:34:03 |
1223 |
8192000000 |
10006556352 |
10383806464 |
1042092544 |
11.285 |
100 |
95 |
182 |
1 |
1129495264 |
67516144 |
19886576 |
02:35:05 |
1134 |
8192000000 |
10001993120 |
10374389760 |
1039009552 |
11.255 |
100 |
98 |
193 |
0 |
1122187536 |
63197680 |
19980304 |
02:36:07 |
1218 |
8192000000 |
10028007280 |
10405249024 |
1056902912 |
11.427 |
100 |
98 |
182 |
1 |
1146981088 |
70777184 |
19300992 |
02:37:10 |
1247 |
8192000000 |
10013500992 |
10390867968 |
1049733584 |
11.358 |
100 |
96 |
185 |
5 |
1134545040 |
65235296 |
19576160 |
02:38:20 |
9832 |
8192000000 |
9986489904 |
10362019840 |
1051731680 |
11.377 |
98 |
67 |
124 |
1 |
1107943264 |
44990224 |
11221360 |
02:39:44 |
7107 |
8192000000 |
10047970160 |
10434469888 |
1070989040 |
11.562 |
99 |
64 |
124 |
0 |
1165706720 |
81815968 |
12901712 |
02:40:57 |
16653 |
8192000000 |
10065265136 |
10452897792 |
1074651984 |
11.596 |
99 |
72 |
132 |
0 |
1169557872 |
81144512 |
13761376 |
02:42:36 |
2511 |
8192000000 |
10124552224 |
10512019456 |
1109877456 |
11.931 |
100 |
82 |
160 |
1 |
1246646192 |
120480592 |
16288144 |
02:43:44 |
894 |
8192000000 |
10122000672 |
10507481088 |
1101873056 |
11.855 |
99 |
92 |
179 |
0 |
1237214464 |
116923344 |
18418064 |
02:44:49 |
3219 |
8192000000 |
10205004688 |
10595667968 |
1130819696 |
12.129 |
100 |
92 |
163 |
1 |
1320835280 |
173358288 |
16657296 |
02:45:54 |
863 |
8192000000 |
10208903456 |
10603536384 |
1137803904 |
12.195 |
100 |
86 |
162 |
1 |
1320995152 |
166635760 |
16555488 |
02:46:59 |
2396 |
8192000000 |
10235385760 |
10628763648 |
1149268720 |
12.303 |
100 |
88 |
165 |
1 |
1347825248 |
180682560 |
17873968 |
02:48:04 |
1707 |
8192000000 |
10234664560 |
10636644352 |
1150159968 |
12.311 |
99 |
89 |
162 |
1 |
1351107968 |
182702192 |
18245808 |
02:49:09 |
1051 |
8192000000 |
10275326912 |
10671816704 |
1171765456 |
12.513 |
100 |
84 |
159 |
0 |
1388031920 |
197934144 |
18332320 |
02:50:13 |
722 |
8192000000 |
10321386816 |
10723516416 |
1176405472 |
12.557 |
100 |
91 |
173 |
2 |
1433703632 |
237237664 |
20060496 |
02:51:16 |
1228 |
8192000000 |
10331701008 |
10734096384 |
1172064720 |
12.516 |
100 |
86 |
162 |
2 |
1439505088 |
248810816 |
18629552 |
02:52:20 |
1129 |
8192000000 |
10369169024 |
10779725824 |
1187239120 |
12.658 |
100 |
93 |
178 |
1 |
1477057744 |
269822928 |
19995696 |
02:53:25 |
1551 |
8192000000 |
10375553472 |
10806571008 |
1188679120 |
12.671 |
100 |
94 |
180 |
2 |
1485106848 |
275533664 |
20894064 |
02:54:31 |
1578 |
8192000000 |
10398379568 |
10836697088 |
1198403136 |
12.761 |
100 |
85 |
169 |
1 |
1508065968 |
291037040 |
18625792 |
02:55:37 |
1142 |
8192000000 |
10426072592 |
10842771456 |
1198720960 |
12.764 |
100 |
95 |
185 |
3 |
1532409744 |
311820816 |
21867968 |
02:56:40 |
851 |
8192000000 |
10463716160 |
10884665344 |
1204455792 |
12.818 |
100 |
96 |
188 |
0 |
1569178560 |
342183984 |
22538784 |
02:57:43 |
1471 |
8192000000 |
10495415488 |
10932457472 |
1202864912 |
12.803 |
100 |
83 |
165 |
0 |
1601782848 |
378751456 |
20166480 |
02:58:47 |
1208 |
8192000000 |
10509905504 |
10930798592 |
1189567600 |
12.679 |
100 |
97 |
192 |
2 |
1613496864 |
400723712 |
23205552 |
02:59:49 |
3112 |
8192000000 |
10500639392 |
10951737344 |
1185226432 |
12.639 |
100 |
80 |
157 |
0 |
1621439536 |
418118352 |
18094752 |
03:00:56 |
7819 |
8192000000 |
10463792576 |
10952142848 |
1178343616 |
12.575 |
99 |
61 |
120 |
1 |
1563733648 |
370246928 |
15143104 |
03:02:06 |
10350 |
8192000000 |
10426299856 |
10888347648 |
1181071040 |
12.600 |
100 |
41 |
80 |
0 |
1537709232 |
345917728 |
10720464 |
03:03:20 |
27255 |
8192000000 |
10389106112 |
10862444544 |
1166407728 |
12.463 |
100 |
29 |
57 |
0 |
1503066096 |
329214112 |
7444256 |
03:05:13 |
51053 |
8192000000 |
10225455744 |
10672500736 |
1140920032 |
12.224 |
99 |
24 |
48 |
1 |
1369945536 |
223393840 |
5631664 |
03:07:04 |
74566 |
8192000000 |
10038308928 |
10475364352 |
1091408240 |
11.756 |
95 |
21 |
38 |
2 |
1128181808 |
32676816 |
4096752 |
03:09:20 |
18299 |
8192000000 |
10100090448 |
10529624064 |
1121018896 |
12.037 |
100 |
61 |
106 |
0 |
1199336368 |
67475824 |
10841648 |
03:10:44 |
123154 |
8192000000 |
10065415872 |
10524749824 |
1086725360 |
11.712 |
97 |
15 |
30 |
0 |
1155067584 |
65512768 |
2829456 |
03:14:09 |
71471 |
8192000000 |
10078578528 |
10531409920 |
1119158704 |
12.019 |
100 |
30 |
60 |
0 |
1186721920 |
61750256 |
5812960 |
03:16:37 |
113443 |
8192000000 |
10141034592 |
10563567616 |
1069517952 |
11.547 |
94 |
33 |
62 |
0 |
1152689376 |
75703264 |
7468160 |
03:19:33 |
14063 |
8192000000 |
10182837088 |
10612113408 |
1132213648 |
12.142 |
100 |
46 |
86 |
1 |
1256652544 |
114970672 |
9468224 |
03:20:48 |
18942 |
8192000000 |
10223289248 |
10642599936 |
1129375712 |
12.115 |
100 |
69 |
129 |
0 |
1309258912 |
164461824 |
15421376 |
03:22:12 |
38345 |
8192000000 |
10189559136 |
10645069824 |
1110875440 |
11.941 |
98 |
22 |
44 |
0 |
1264355552 |
148374880 |
5105232 |
03:24:26 |
72577 |
8192000000 |
10082149504 |
10532507648 |
1111727776 |
11.949 |
99 |
18 |
34 |
1 |
1205720048 |
89748480 |
4243792 |
03:27:04 |
17397 |
8192000000 |
10088051520 |
10524450816 |
1125738480 |
12.081 |
99 |
48 |
92 |
1 |
1164208448 |
28991856 |
9478112 |
03:28:25 |
109277 |
8192000000 |
10094529104 |
10608103424 |
1118504544 |
12.013 |
98 |
28 |
56 |
0 |
1191168256 |
67160240 |
5503472 |
03:31:33 |
47273 |
8192000000 |
10109379152 |
10551734272 |
1101051040 |
11.848 |
97 |
29 |
58 |
0 |
1167463584 |
60493104 |
5919440 |
03:33:23 |
64014 |
8192000000 |
10111723328 |
10582671360 |
1130811424 |
12.129 |
100 |
28 |
56 |
0 |
1195222016 |
59015936 |
5394656 |
03:35:28 |
153368 |
8192000000 |
10090045104 |
10564861952 |
1097188336 |
11.811 |
96 |
19 |
37 |
2 |
1188070208 |
86750896 |
4130976 |
03:39:29 |
31841 |
8192000000 |
10099358912 |
10535333888 |
1136586432 |
12.183 |
100 |
56 |
106 |
1 |
1205357584 |
58135312 |
10635840 |
03:41:02 |
63392 |
8192000000 |
10086496688 |
10551742464 |
1111959616 |
11.951 |
98 |
13 |
26 |
0 |
1178711072 |
63962992 |
2788464 |
03:43:13 |
80890 |
8192000000 |
10075592688 |
10560475136 |
1086375984 |
11.708 |
96 |
14 |
29 |
0 |
1171983792 |
82218656 |
3389152 |
03:45:41 |
74070 |
8192000000 |
10066130496 |
10534621184 |
1110639072 |
11.938 |
99 |
10 |
20 |
0 |
1171721776 |
59038960 |
2043744 |
03:47:57 |
54287 |
8192000000 |
10072571360 |
10539118592 |
1120983408 |
12.036 |
99 |
13 |
26 |
0 |
1164953552 |
40642304 |
3327840 |
03:49:56 |
43394 |
8192000000 |
10072215088 |
10532335616 |
1110676592 |
11.939 |
97 |
24 |
44 |
0 |
1166982928 |
51371472 |
4934864 |
03:51:42 |
39272 |
8192000000 |
10142597968 |
10597011456 |
1135187712 |
12.170 |
99 |
29 |
58 |
1 |
1238588624 |
96754240 |
6646672 |
03:53:28 |
42671 |
8192000000 |
10126014304 |
10562707456 |
1119325280 |
12.021 |
99 |
36 |
69 |
0 |
1228586416 |
101094624 |
8166512 |
03:55:11 |
11409 |
8192000000 |
10123616352 |
10556125184 |
1114053360 |
11.971 |
99 |
47 |
94 |
0 |
1211040240 |
87544304 |
9442576 |
03:56:24 |
57168 |
8192000000 |
10094208976 |
10602123264 |
1101237312 |
11.849 |
98 |
37 |
74 |
1 |
1163737616 |
55277360 |
7222944 |
03:58:22 |
52792 |
8192000000 |
10125053008 |
10579963904 |
1099535744 |
11.833 |
97 |
35 |
68 |
1 |
1168224240 |
61855296 |
6833200 |
04:00:21 |
30888 |
8192000000 |
10105021536 |
10530754560 |
1095377840 |
11.794 |
98 |
43 |
86 |
0 |
1161659824 |
57538704 |
8743280 |
04:01:58 |
87283 |
8192000000 |
10070456640 |
10503852032 |
1116386224 |
11.993 |
100 |
46 |
92 |
0 |
1181314000 |
54640352 |
10287424 |
04:04:26 |
29703 |
8192000000 |
10067167456 |
10536808448 |
1124455616 |
12.069 |
100 |
24 |
48 |
0 |
1191357184 |
62411248 |
4490320 |
04:07:14 |
69982 |
8192000000 |
10063739584 |
10509320192 |
1067792368 |
11.531 |
95 |
11 |
22 |
0 |
1104878080 |
34753824 |
2331888 |
04:09:24 |
72711 |
8192000000 |
10082798288 |
10530410496 |
1097929968 |
11.818 |
98 |
19 |
38 |
0 |
1154872272 |
52515552 |
4426752 |
04:11:45 |
40116 |
8192000000 |
10100878240 |
10545381376 |
1121436736 |
12.041 |
100 |
46 |
90 |
1 |
1189275744 |
58309392 |
9529616 |
04:13:40 |
27456 |
8192000000 |
10171579824 |
10604507136 |
1137213696 |
12.189 |
100 |
40 |
76 |
1 |
1249970544 |
104409904 |
8346944 |
04:15:08 |
45284 |
8192000000 |
10183502880 |
10629996544 |
1129829104 |
12.120 |
99 |
41 |
78 |
0 |
1251247968 |
112427792 |
8991072 |
04:17:02 |
22715 |
8192000000 |
10254903456 |
10687909888 |
1134404880 |
12.163 |
99 |
51 |
96 |
0 |
1326345808 |
181309584 |
10631344 |
04:18:25 |
22011 |
8192000000 |
10286114480 |
10718519296 |
1157988272 |
12.384 |
100 |
47 |
92 |
0 |
1379945296 |
211759968 |
10197056 |
04:19:52 |
35710 |
8192000000 |
10296474160 |
10732965888 |
1149064736 |
12.301 |
99 |
31 |
60 |
0 |
1374054752 |
218109168 |
6880848 |
04:21:29 |
100572 |
8192000000 |
10269389328 |
10759811072 |
1131541136 |
12.136 |
99 |
20 |
40 |
0 |
1374173952 |
237997616 |
4635200 |
04:25:22 |
97116 |
8192000000 |
10082656208 |
10535301120 |
1128080928 |
12.103 |
99 |
19 |
38 |
2 |
1171173664 |
39335456 |
3757280 |
04:28:00 |
19640 |
8192000000 |
10131193136 |
10557263872 |
1121154208 |
12.038 |
98 |
62 |
121 |
1 |
1199811200 |
65911216 |
12745776 |
04:29:22 |
8408 |
8192000000 |
10105776496 |
10544771072 |
1135198352 |
12.170 |
100 |
46 |
92 |
0 |
1191484992 |
47211744 |
9074896 |
04:30:35 |
13039 |
8192000000 |
10117110080 |
10554630144 |
1137233456 |
12.189 |
100 |
47 |
92 |
1 |
1194095536 |
47494480 |
9367600 |
04:31:53 |
53807 |
8192000000 |
10097393040 |
10555351040 |
1098708480 |
11.825 |
97 |
34 |
65 |
0 |
1141112272 |
36075648 |
6328144 |
04:33:51 |
111631 |
8192000000 |
10112563632 |
10589261824 |
1115628864 |
11.986 |
98 |
23 |
44 |
1 |
1193335648 |
73629984 |
4076800 |
04:37:12 |
39873 |
8192000000 |
9099458224 |
9357873152 |
249588224 |
2.956 |
23 |
3 |
6 |
0 |
261792416 |
11781856 |
422336 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 18-12-2022 04:39:21 to 18-12-2022 04:39:37.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
126 |
v_add_invoice_to_stock |
335544517 |
except |
7 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-12-2022 04:39:38 to 18-12-2022 04:39:40.
MON$DATABASE_NAME /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 224362
MON$OLDEST_ACTIVE 224363
MON$OLDEST_SNAPSHOT 224363
MON$NEXT_TRANSACTION 224363
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 2034528
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 778
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 ---
:161:
:162: mscs-test-161.budzdorov.ru Sun Dec 18 04:37:54 2022
:163: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:164:
--- end of diff output ---
18.12.22 04:39:41. 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-18 04:39:43 |
No severe PSQL-related problems occured |
18.12.22 04:39:45. End of report.