質問編集履歴
1
質問更新
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -4,14 +4,28 @@
|
|
|
4
4
|
原因不明の状況です。
|
|
5
5
|
|
|
6
6
|
```ここに言語を入力
|
|
7
|
+
■実行ユーザの権限 srdcsユーザ
|
|
8
|
+
srdcs04% env
|
|
9
|
+
USER=srdcs
|
|
10
|
+
LOGNAME=srdcs
|
|
11
|
+
HOME=/export/home/srdcs
|
|
12
|
+
PATH=/bin:/usr/bin:/usr/ucb:/etc:.:/usr/sfw/bin/gcc:/export/home/srdcs/embulk_test/bin/embulk
|
|
13
|
+
MAIL=/var/mail//srdcs
|
|
14
|
+
SHELL=/bin/csh
|
|
15
|
+
TZ=Japan
|
|
16
|
+
LANG=ja
|
|
17
|
+
TERM=xterm
|
|
18
|
+
DISPLAY=localhost:14.0
|
|
19
|
+
PWD=/export/home/srdcs
|
|
20
|
+
|
|
7
21
|
■crontab設定
|
|
8
22
|
|
|
9
|
-
|
|
23
|
+
srdcs04% crontab -l
|
|
10
24
|
|
|
11
25
|
0,10,20,30,40,50 * * * * /bin/bash /export/home/xxxxxx/embulk_test/sh/bulkinsert_T_RS_TRAN.sh
|
|
12
26
|
|
|
13
27
|
■シェルスクリプト
|
|
14
|
-
|
|
28
|
+
srdcs04% cat /export/home/xxxxxx/embulk_test/sh/bulkinsert_T_RS_TRAN.sh
|
|
15
29
|
#
|
|
16
30
|
# 環境変数設定
|
|
17
31
|
#
|
|
@@ -53,7 +67,7 @@
|
|
|
53
67
|
echo "DATE : ${TIME}" >> ${CHECK_T_RS_TRAN_LOG}
|
|
54
68
|
echo "Embulk command Error T_RS_TRAN_TABLE" >> ${CHECK_T_RS_TRAN_LOG}
|
|
55
69
|
echo "Embulk command Error T_RS_TRAN_TABLE" >> ${mail_T_RS_TRAN_file}
|
|
56
|
-
${MAIL_CMD} -f
|
|
70
|
+
${MAIL_CMD} -f embulk_srdcs04@jp.xxxxx.com ${ADDR} < ${mail_T_RS_TRAN_file}
|
|
57
71
|
exit 1
|
|
58
72
|
fi
|
|
59
73
|
echo "=====================" >> ${CHECK_T_RS_TRAN_LOG}
|
|
@@ -71,7 +85,7 @@
|
|
|
71
85
|
echo "=====================" >> ${CHECK_T_RS_TRAN_LOG}
|
|
72
86
|
echo "DATE : ${TIME}" >> ${CHECK_T_RS_TRAN_LOG}
|
|
73
87
|
echo "Embulk Log Error T_RS_TRAN_TABLE" >> ${CHECK_T_RS_TRAN_LOG}
|
|
74
|
-
${MAIL_CMD} -f
|
|
88
|
+
${MAIL_CMD} -f embulk_srdcs04@jp.xxxxx.com ${ADDR} < ${mail_T_RS_TRAN_file}
|
|
75
89
|
exit 1
|
|
76
90
|
else
|
|
77
91
|
break
|
|
@@ -91,16 +105,16 @@
|
|
|
91
105
|
|
|
92
106
|
|
|
93
107
|
■実行結果
|
|
94
|
-
|
|
108
|
+
srdcs04% tail -f check_T_RS_TRAN.log
|
|
95
109
|
=====================
|
|
96
110
|
DATE : 19/03/05 15:00:00
|
|
97
111
|
Embulk command Error T_RS_TRAN_TABLE
|
|
98
112
|
|
|
99
113
|
|
|
100
114
|
■cronの権限
|
|
101
|
-
|
|
115
|
+
srdcs04% ls -ltrh /var/spool/cron/crontabs
|
|
102
116
|
|
|
103
|
-
-rw------- 1 root xxxxxx 1.2K 3月 5日 15:20
|
|
117
|
+
-rw------- 1 root xxxxxx 1.2K 3月 5日 15:20 srdcs
|
|
104
118
|
|
|
105
119
|
|
|
106
120
|
```
|