中台数据抽取,在连接sybase数据库的时候报java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.错误,关键是它时有时无,前几天跑没问题今天就报错,重跑也不管用.
请大家帮着出谋划策.
查了很多资料
2022-03-23 07:24:06.249 [0-0-0-reader] ERROR ReaderRunner - Reader runner Received Exceptions:
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select RQ,COM_CODE,GZ,GYS,PP,DZXL,JYFS,SXJE,KFQJE,CJFQJE,BCJFQJE,SJFQE,SQE,FQBL,FQFH,SQBL,SQFH,YFQJE,HTBH,HDXMH,YL1,YL2,FQJS,FQS,SQJS,SQS from HD_INV_COM_HZ_MX where (convert(varchar(30),RQ,112)='20220322') 具体错误信息为：java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-5.0.0-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[plugin-rdbms-util-1.0.0-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:281) ~[plugin-rdbms-util-1.0.0-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.reader.sybasereader.SybaseReader$Task.startRead(SybaseReader.java:91) ~[sybasereader-1.0.0.jar:na]
at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:62) ~[datax-core-5.0.0-SNAPSHOT.jar:na]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_241]
Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select RQ,COM_CODE,GZ,GYS,PP,DZXL,JYFS,SXJE,KFQJE,CJFQJE,BCJFQJE,SJFQE,SQE,FQBL,FQFH,SQBL,SQFH,YFQJE,HTBH,HDXMH,YL1,YL2,FQJS,FQS,SQJS,SQS from HD_INV_COM_HZ_MX where (convert(varchar(30),RQ,112)='20220322') 具体错误信息为：java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26)
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97)
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:281)
at com.alibaba.datax.plugin.reader.sybasereader.SybaseReader$Task.startRead(SybaseReader.java:91)
at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:62)
at java.lang.Thread.run(Thread.java:748)
2022-03-23 07:24:14.497 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes, time 0 s | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2022-03-23 07:24:14.497 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错.
2022-03-23 07:24:14.499 [job-0] ERROR JobContainer - Exception when job run
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select RQ,COM_CODE,GZ,GYS,PP,DZXL,JYFS,SXJE,KFQJE,CJFQJE,BCJFQJE,SJFQE,SQE,FQBL,FQFH,SQBL,SQFH,YFQJE,HTBH,HDXMH,YL1,YL2,FQJS,FQS,SQJS,SQS from HD_INV_COM_HZ_MX where (convert(varchar(30),RQ,112)='20220322') 具体错误信息为：java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-5.0.0-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[na:na]
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:281) ~[na:na]
at com.alibaba.datax.plugin.reader.sybasereader.SybaseReader$Task.startRead(SybaseReader.java:91) ~[na:na]
at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:62) ~[datax-core-5.0.0-SNAPSHOT.jar:na]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_241]
2022-03-23 07:24:14.499 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes, time 0 s | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2022-03-23 07:24:14.510 [job-0] INFO HookInvoker - Invoke hook [statistic], path: /opt/plugins/datax/hook/statistic
2022-03-23 07:24:14.515 [job-0] ERROR Engine -
经DataX智能分析,该任务最可能的错误原因是:
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select RQ,COM_CODE,GZ,GYS,PP,DZXL,JYFS,SXJE,KFQJE,CJFQJE,BCJFQJE,SJFQE,SQE,FQBL,FQFH,SQBL,SQFH,YFQJE,HTBH,HDXMH,YL1,YL2,FQJS,FQS,SQJS,SQS from HD_INV_COM_HZ_MX where (convert(varchar(30),RQ,112)='20220322') 具体错误信息为：java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26)
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97)
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:281)
at com.alibaba.datax.plugin.reader.sybasereader.SybaseReader$Task.startRead(SybaseReader.java:91)
at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:62)
at java.lang.Thread.run(Thread.java:748)
END-EOF-END-EOF
