vergilchiu opened a new issue #5150:
URL: https://github.com/apache/incubator-doris/issues/5150
**Describe the bug**
We have hundreds of "broker load jobs" that loading hive table to doris
everyday.
Sometimes there are several failed jobs , the exception is below. But it
will work file after retry .
Sometimes there are no exceptions , even the same table , same data.
the exception :
```shell
mysql> show load;
+---------+-----------------------------------------------------+-----------+-------------------+--------+---------+-----------------------------------------------------+-----------------------------------------------------+---------------------+--------------+---------------+---------------+---------------------+------+--------------------------------------------------------------+
| JobId | Label | State
| Progress | Type | EtlInfo | TaskInfo
| ErrorMsg | CreateTime
| EtlStartTime | EtlFinishTime | LoadStartTime | LoadFinishTime |
URL | JobDetails |
+---------+-----------------------------------------------------+-----------+-------------------+--------+---------+-----------------------------------------------------+-----------------------------------------------------+---------------------+--------------+---------------+---------------+---------------------+------+--------------------------------------------------------------+
| 3745557 | label20201222_ret2_7e0348bf8fcd4fbbb5d6457ffbeca955 | CANCELLED
| ETL:N/A; LOAD:N/A | BROKER | N/A | cluster:N/A; timeout(s):14400;
max_filter_ratio:0.0 | type:TXN_UNKNOWN; msg:transaction status is unknown |
2020-12-25 03:44:08 | N/A | N/A | N/A | 2020-12-25
03:44:08 | N/A | {"ScannedRows":0,"TaskNumber":0,"FileNumber":0,"FileSize":0} |
+---------+-----------------------------------------------------+-----------+-------------------+--------+---------+-----------------------------------------------------+-----------------------------------------------------+---------------------+--------------+---------------+---------------+---------------------+------+--------------------------------------------------------------+
```
**To Reproduce**
Sometimes It reproduce , somtimes not in the same table.
**Desktop (please complete the following information):**
- OS: centos7.2
- Version 0.12-rc-3
This exception almost happed everyday , so we have to reload the
broker-loading-job everyday .
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
