apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.65k stars 3.26k forks source link

DataX-dorisdb-writer load data failed #6303

Closed lijinwang-web closed 3 years ago

lijinwang-web commented 3 years ago

I use DataX-dorisdb-writer to load data from mysql to doris,but failed.

2021-07-22 18:02:51.118 [Thread-1] INFO DorisStreamLoadVisitor - Executing stream load to: 'http://10.20.140.160:8030/api/example_db/ods_db_enterprise_t_enterprise_full/_stream_load', size: '94561441' 2021-07-22 18:02:52.234 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2021-07-22 18:02:52.832 [Thread-1] WARN DorisStreamLoadVisitor - Request failed with code:500 2021-07-22 18:02:52.832 [Thread-1] WARN DorisWriterManager - Failed to flush batch data to doris, retry times = 1 java.io.IOException: Unable to flush data to doris: unknown result status. at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisStreamLoadVisitor.doStreamLoad(DorisStreamLoadVisitor.java:58) ~[doriswriter-0.0.1-SNAPSHOT.jar:na] at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.asyncFlush(DorisWriterManager.java:121) [doriswriter-0.0.1-SNAPSHOT.jar:na] at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.access$000(DorisWriterManager.java:15) [doriswriter-0.0.1-SNAPSHOT.jar:na] at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager$1.run(DorisWriterManager.java:94) [doriswriter-0.0.1-SNAPSHOT.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 2021-07-22 18:02:52.835 [0-0-0-writer] ERROR WriterRunner - Writer Runner Received Exceptions: com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - java.lang.RuntimeException: Writing records to Doris failed. at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.checkFlushException(DorisWriterManager.java:141) at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.writeRecord(DorisWriterManager.java:37) at com.dorisdb.connector.datax.plugin.writer.doriswriter.DorisWriter$Task.startWrite(DorisWriter.java:117) at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: java.io.IOException: Unable to flush data to doris: unknown result status. at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.asyncFlush(DorisWriterManager.java:127) at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.access$000(DorisWriterManager.java:15) at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager$1.run(DorisWriterManager.java:94) ... 1 more Caused by: java.io.IOException: Unable to flush data to doris: unknown result status. at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisStreamLoadVisitor.doStreamLoad(DorisStreamLoadVisitor.java:58) at com.dorisdb.connector.datax.plugin.writer.doriswriter.manager.DorisWriterManager.asyncFlush(DorisWriterManager.java:121) ... 3 more

hf200012 commented 3 years ago

The specific software of dorisdb, dorisdb and apache doris are not the same product,