背景
日志报错信息:2024-04-24 02:59:49.307 [job-0] ERROR JobContainer - Exception when job run
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: ALTER TABLE yktls_8month_temp
RENAME TO yktls_8month
具体错误信息为:java.sql.SQLException: Error on rename of ‘./model/yktls_8month_temp’ to ‘./model/yktls_6month’ (errno: 168 - Unknown (generic) error from engine)
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:84) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.writer.util.WriterUtil.executeSqls(WriterUtil.java:103) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter
J
o
b
.
p
o
s
t
(
C
o
m
m
o
n
R
d
b
m
s
W
r
i
t
e
r
.
j
a
v
a
:
152
)
[
p
l
u
g
i
n
−
r
d
b
m
s
−
u
t
i
l
−
0.0.1
−
S
N
A
P
S
H
O
T
.
j
a
r
:
n
a
]
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
a
t
a
x
.
p
l
u
g
i
n
.
w
r
i
t
e
r
.
m
y
s
q
l
w
r
i
t
e
r
.
M
y
s
q
l
W
r
i
t
e
r
Job.post(CommonRdbmsWriter.java:152) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter
Job.post(CommonRdbmsWriter.java:152) [plugin−rdbms−util−0.0.1−SNAPSHOT.jar:na]atcom.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriterJob.post(MysqlWriter.java:64) ~[mysqlwriter-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.postJobWriter(JobContainer.java:837) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.post(JobContainer.java:510) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:117) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.start(Engine.java:87) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.entry(Engine.java:166) [datax-core-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.Engine.main(Engine.java:198) [datax-core-0.0.1-SNAPSHOT.jar:na]
一、步骤
1.查看XXXX表是否存在
检查发现没有此表,只有后缀为temp的表。
2.复制temp的表
复制表,把temp后缀名字去掉,刷新表。
3.进入数据中台查看
查看该表可以正常执行。