You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/12/25 07:21:43 UTC
[GitHub] [incubator-doris] vergilchiu opened a new issue #5150: broker load error:transaction status is unknown
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] vergilchiu commented on issue #5150: broker load error:transaction status is unknown
Posted by GitBox <gi...@apache.org>.
vergilchiu commented on issue #5150:
URL: https://github.com/apache/incubator-doris/issues/5150#issuecomment-751198352
> which doris version do you use？
0.12.0-rc03
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] caiconghui commented on issue #5150: broker load error:transaction status is unknown
Posted by GitBox <gi...@apache.org>.
caiconghui commented on issue #5150:
URL: https://github.com/apache/incubator-doris/issues/5150#issuecomment-751197858
which doris version do you use？
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] caiconghui commented on issue #5150: broker load error:transaction status is unknown
Posted by GitBox <gi...@apache.org>.
caiconghui commented on issue #5150:
URL: https://github.com/apache/incubator-doris/issues/5150#issuecomment-755961848
> > which doris version do you use？
>
> 0.12.0-rc03
@vergilchiu
could you see such log : "Get transaction status by label"
I doubt that txn timeout and has been removed, so that txn status is unknown.
or you can add my wechat caiconghui001 for discussion.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org