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 2022/10/20 11:28:30 UTC
[GitHub] [doris] zhouaoe opened a new issue, #13525: [Bug] Be stuck in a loop when it execute an export sql
zhouaoe opened a new issue, #13525:
URL: https://github.com/apache/doris/issues/13525
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
官网下载的最新安装包
Git : git://hk-dev01/mnt/disk2/ygl/code/github/apache-doris@b4364b451ef37dbe15db5674551851733645ffbb
Version : 1.1.3-rc02
BuildInfo : ygl@hk-dev01
BuildTime : Tue, 11 Oct 2022 11:11:40 CST
### What's Wrong?
BE执行如下sql时陷入死循环，不断的重复创建SuccessFile，直到持续几分钟后BE 进程core掉。
select * from demo.example_tbl into outfile "s3a://otsosstest/doris/export_from_doris/newbroker/07/"
FORMAT AS CSV
PROPERTIES (
"broker.name" = "broker_za",
"broker.fs.s3a.access.key" = "xxxx",
"broker.fs.s3a.secret.key" = "xxxx",
"broker.fs.s3a.endpoint" = "http://oss-cn-hangzhou.aliyuncs.com",
"column_separator" = ",",
"line_delimiter" = "\n",
"max_file_size" = "10MB",
"success_file_name" = "SUCCESS01"
);
-----------------------------log-----------------------------------
I1020 19:08:40.500828 45943 vfile_result_writer.cpp:142] create file for exporting query result. file name: s3a://otsosstest/doris/export_from_doris/newbroker/07/SUCCESS01. query id: 939ed0297aff49b6-945f02673b30cc91 format:FORMAT_CSV_PLAIN
I1020 19:08:40.594707 45943 vfile_result_writer.cpp:142] create file for exporting query result. file name: s3a://otsosstest/doris/export_from_doris/newbroker/07/SUCCESS01. query id: 939ed0297aff49b6-945f02673b30cc91 format:FORMAT_CSV_PLAIN
I1020 19:08:40.686880 45943 vfile_result_writer.cpp:142] create file for exporting query result. file name: s3a://otsosstest/doris/export_from_doris/newbroker/07/SUCCESS01. query id: 939ed0297aff49b6-945f02673b30cc91 format:FORMAT_CSV_PLAIN
I1020 19:08:40.782086 45943 vfile_result_writer.cpp:142] create file for exporting query result. file name: s3a://otsosstest/doris/export_from_doris/newbroker/07/SUCCESS01. query id: 939ed0297aff49b6-945f02673b30cc91 format:FORMAT_CSV_PLAIN
I1020 19:08:40.876988 45943 vfile_result_writer.cpp:142] create file for exporting query result. file name: s3a://otsosstest/doris/export_from_doris/newbroker/07/SUCCESS01. query id: 939ed0297aff49b6-945f02673b30cc91 format:FORMAT_CSV_PLAIN
。。。 。。。
### What You Expected?
Support function that export data to aliyun OSS by broker。
### How to Reproduce?
1.create an oss bucket；
2.start a broker
3.execute command：
select * from demo.example_tbl into outfile "s3a://otsosstest/doris/export_from_doris/newbroker/07/"
FORMAT AS CSV
PROPERTIES (
"broker.name" = "broker_za",
"broker.fs.s3a.access.key" = "xxxx",
"broker.fs.s3a.secret.key" = "xxxx",
"broker.fs.s3a.endpoint" = "http://oss-cn-hangzhou.aliyuncs.com",
"column_separator" = ",",
"line_delimiter" = "\n",
"max_file_size" = "10MB",
"success_file_name" = "SUCCESS01"
);
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
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] [doris] Gabriel39 closed issue #13525: [Bug] Be stuck in a loop when it execute an export sql
Posted by GitBox <gi...@apache.org>.
Gabriel39 closed issue #13525: [Bug] Be stuck in a loop when it execute an export sql
URL: https://github.com/apache/doris/issues/13525
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
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