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 2021/04/14 13:49:18 UTC
[GitHub] [incubator-doris] htyoung opened a new issue #5655: ERROR 5025 (HY000): errCode = 2, detailMessage = close wait failed coz rpc error. node=10.254.19.3:8060, errmsg=tablet writer write failed, tablet_id=113603, txn_id=177405, err=-215
htyoung opened a new issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655
建表语句如下：
CREATE TABLE IF NOT EXISTS test_table_2
(
dateline BIGINT COMMENT '服务器时间，毫秒时间戳'
,dt date COMMENT '分区字段，天分区，yyyyMMdd'
,ht int COMMENT '分区字段，小时分区，格式HH'
)
DUPLICATE KEY(dateline)
COMMENT ''
PARTITION BY RANGE(dt, ht)
(
partition p20210401 VALUES [("2021-04-01","0"),("2021-04-01","24")),
partition p20210402 VALUES [("2021-04-02","0"),("2021-04-02","24")),
partition p20210403 VALUES [("2021-04-03","0"),("2021-04-03","24")),
partition p20210404 VALUES [("2021-04-04","0"),("2021-04-04","24")),
partition p20210405 VALUES [("2021-04-05","0"),("2021-04-05","24")),
partition p20210406 VALUES [("2021-04-06","0"),("2021-04-06","24")),
partition p20210407 VALUES [("2021-04-07","0"),("2021-04-07","24")),
partition p20210408 VALUES [("2021-04-08","0"),("2021-04-08","24")),
partition p20210409 VALUES [("2021-04-09","0"),("2021-04-09","24")),
partition p20210410 VALUES [("2021-04-10","0"),("2021-04-10","24")),
partition p20210411 VALUES [("2021-04-11","0"),("2021-04-11","24"))
)
DISTRIBUTED BY HASH(dateline) BUCKETS 16
;
插入语句：
insert into dy_dwd.dwd_dy_log_dot_hi_2(dateline,dt,ht) values(1618408080,'2021-04-01',5);
结果报错：
ERROR 5025 (HY000): errCode = 2, detailMessage = already stopped, skip waiting for close. cancelled/!eos: : 1/0
--
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] htyoung commented on issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
htyoung commented on issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655#issuecomment-820305632
> 官网不建议使用insert into valuse用于生产环境，说明性能很不好。
我也注意到了，但是作为一个兼容MySQL的产品，提升insert into的性能可以直接适配之前的MySQL ETL插件，不用重新在开发，可以很小的减少迁移成本
--
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] htyoung closed issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
htyoung closed issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655
--
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] htyoung commented on issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
htyoung commented on issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655#issuecomment-820304520
> 官网不建议使用insert into valuse用于生产环境，说明性能很不好。
--
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] pigdance commented on issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
pigdance commented on issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655#issuecomment-820285470
官网不建议使用insert into valuse用于生产环境，说明性能很不好。
--
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] hf200012 commented on issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655#issuecomment-820307383
nsert into a single piece of data is not recommended to be used in a production environment, you can use stream load or routine load
--
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] htyoung removed a comment on issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
htyoung removed a comment on issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655#issuecomment-820304520
> 官网不建议使用insert into valuse用于生产环境，说明性能很不好。
--
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] htyoung closed issue #5655: insert into语句性能问题
Posted by GitBox <gi...@apache.org>.
htyoung closed issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655
--
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] htyoung closed issue #5655: ERROR 5025 (HY000): errCode = 2, detailMessage = close wait failed coz rpc error. node=10.254.19.3:8060, errmsg=tablet writer write failed, tablet_id=113603, txn_id=177405, err=-215
Posted by GitBox <gi...@apache.org>.
htyoung closed issue #5655:
URL: https://github.com/apache/incubator-doris/issues/5655
--
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