Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Premature end of chunk coded message body: closing chunk expected #2236

Open
2695115374 opened this issue Nov 11, 2024 · 0 comments
Open

Premature end of chunk coded message body: closing chunk expected #2236

2695115374 opened this issue Nov 11, 2024 · 0 comments

Comments

@2695115374
Copy link

2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select goods_id,productid,regcard_id,com_id,regcard_code,regcard_name,regcard_com_name,regcard_address,regcard_spec_model,regcard_context,regcard_apply_range,regcard_other_context,regcard_remark,regcard_production_area,regcard_run_com_name,product_name,product_material,product_unit,product_is_one_off,product_is_sterilized,product_is_in_imp,product_class_code,company_name,company_buslicense,goods_spec,goods_model,udi,goods_code,common_name,first_class,second_class,third_class,feature_parameters,material,version,orgin_code,orgin_code_status,specification_code,modify_type,origin_regcard_code from p47_std_medical_consumables 具体错误信息为：java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected - java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72) ~[clickhousereader-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_311]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] ... 3 common frames omitted
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135) ~[httpclient-4.5.13.jar:4.5.13]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_311]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822) ~[guava-19.0.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698) ~[guava-19.0.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679) ~[guava-19.0.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66) ~[guava-19.0.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133) ~[clickhouse-jdbc-0.2.4.jar:na]
2024-11-11 11:32:43 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 common frames omitted
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 2024-11-11 11:32:52.335 [job-0] INFO StandAloneJobContainerCommunicator - Total 6336960 records, 1910842251 bytes | Speed 549.79KB/s, 1836 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,646.053s | All Task WaitReaderTime 156.917s | Percentage 0.00%
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 2024-11-11 11:32:52.336 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错.
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 2024-11-11 11:32:52.338 [job-0] ERROR JobContainer - Exception when job run
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select goods_id,productid,regcard_id,com_id,regcard_code,regcard_name,regcard_com_name,regcard_address,regcard_spec_model,regcard_context,regcard_apply_range,regcard_other_context,regcard_remark,regcard_production_area,regcard_run_com_name,product_name,product_material,product_unit,product_is_one_off,product_is_sterilized,product_is_in_imp,product_class_code,company_name,company_buslicense,goods_spec,goods_model,udi,goods_code,common_name,first_class,second_class,third_class,feature_parameters,material,version,orgin_code,orgin_code_status,specification_code,modify_type,origin_regcard_code from p47_std_medical_consumables 具体错误信息为：java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected - java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_311]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 3 common frames omitted
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183) ~[httpcore-4.4.13.jar:4.4.13]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135) ~[httpclient-4.5.13.jar:4.5.13]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_311]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133) ~[na:na]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 common frames omitted
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 2024-11-11 11:32:52.339 [job-0] INFO StandAloneJobContainerCommunicator - Total 6336960 records, 1910842251 bytes | Speed 1.78GB/s, 6336960 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,646.053s | All Task WaitReaderTime 156.917s | Percentage 0.00%
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 2024-11-11 11:32:52.339 [job-0] ERROR Engine -
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] 经DataX智能分析,该任务最可能的错误原因是:
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select goods_id,productid,regcard_id,com_id,regcard_code,regcard_name,regcard_com_name,regcard_address,regcard_spec_model,regcard_context,regcard_apply_range,regcard_other_context,regcard_remark,regcard_production_area,regcard_run_com_name,product_name,product_material,product_unit,product_is_one_off,product_is_sterilized,product_is_in_imp,product_class_code,company_name,company_buslicense,goods_spec,goods_model,udi,goods_code,common_name,first_class,second_class,third_class,feature_parameters,material,version,orgin_code,orgin_code_status,specification_code,modify_type,origin_regcard_code from p47_std_medical_consumables 具体错误信息为：java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected - java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 3 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select goods_id,productid,regcard_id,com_id,regcard_code,regcard_name,regcard_com_name,regcard_address,regcard_spec_model,regcard_context,regcard_apply_range,regcard_other_context,regcard_remark,regcard_production_area,regcard_run_com_name,product_name,product_material,product_unit,product_is_one_off,product_is_sterilized,product_is_in_imp,product_class_code,company_name,company_buslicense,goods_spec,goods_model,udi,goods_code,common_name,first_class,second_class,third_class,feature_parameters,material,version,orgin_code,orgin_code_status,specification_code,modify_type,origin_regcard_code from p47_std_medical_consumables 具体错误信息为：java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected - java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53]
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.reader.clickhousereader.ClickhouseReader$Task.startRead(ClickhouseReader.java:72)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLException: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:146)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.next(ClickHouseResultSet.java:182)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 3 more
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: org.apache.http.ConnectionClosedException: Premature end of chunk coded message body: closing chunk expected
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.getChunkSize(ChunkedInputStream.java:263)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.nextChunk(ChunkedInputStream.java:222)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.impl.io.ChunkedInputStream.read(ChunkedInputStream.java:183)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at java.io.FilterInputStream.read(FilterInputStream.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.read(ByteStreams.java:822)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:698)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.ByteStreams.readFully(ByteStreams.java:679)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at com.google.common.io.LittleEndianDataInputStream.readFully(LittleEndianDataInputStream.java:66)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.readNextBlock(ClickHouseLZ4Stream.java:101)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.checkNext(ClickHouseLZ4Stream.java:74)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseLZ4Stream.read(ClickHouseLZ4Stream.java:60)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.readFromStream(StreamSplitter.java:92)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.StreamSplitter.next(StreamSplitter.java:64)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] at ru.yandex.clickhouse.response.ClickHouseResultSet.hasNext(ClickHouseResultSet.java:133)
2024-11-11 11:32:52 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more
2024-11-11 11:32:52 [JobThread.run-165]
----------- datax-web job execute end(finish) -----------
----------- ReturnT:ReturnT [code=500, msg=command exit value(1) is failed, content=null]
2024-11-11 11:32:52 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback finish.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@2695115374