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/08 07:42:09 UTC
[GitHub] [incubator-doris] francisoliverlee opened a new issue #5041: [Bug] constant value in sql executed result with "failed to build storage scanner, no materialized slot"
francisoliverlee opened a new issue #5041:
URL: https://github.com/apache/incubator-doris/issues/5041
**Describe the bug**
errorcode=2, failed to build storage scanner, no materialized slot. the error could happend occasionally, but do happen.
这个报错产生的频率很低, 但是会发生.
**To Reproduce**
7 select-query conntected with union all, SQL bellowed:
7个子查询被union连接, SQL语句如下,
```SQL
(
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'allday' as type,
allday_opened as opened,
allday_booked as booked,
allday_level_booking_rate / 100 as booking_rate,
allday_available as available,
available_class_24h as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
union
all (
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'pt' as type,
pt_opened as opened,
pt_booked as booked,
pt_level_booking_rate / 100 as booking_rate,
pt_available as available,
pt24h_available_class as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
union
all (
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'ppt' as type,
ppt_opened as opened,
ppt_booked as booked,
ppt_level_booking_rate / 100 as booking_rate,
ppt_available as available,
ppt24h_available_class as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
```
**Expected behavior**
exec successfully and retuen right result
期望sql执行成功, 并返回正确的结果
**Desktop (please complete the following information):**
- version: 0.12.21
**Additional context**
FE's error log
```
2020-12-08 10:36:17,276 WARN 150812 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e86
2020-12-08 10:36:17,277 WARN 169772 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e85
2020-12-08 10:36:17,278 WARN 169783 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e84
2020-12-08 10:36:17,281 WARN 169811 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e82
2020-12-08 10:36:17,283 WARN 169990 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e81
2020-12-08 10:36:17,283 WARN 150812 [Coordinator.updateStatus():635] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: 4b65fa948d884c46-a048d7a98bba9e7f, instance id: 4b65fa948d884c46-a048d7a98bba9e86
2020-12-08 10:36:17,283 WARN 169853 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e80
2020-12-08 10:36:17,284 WARN 169800 [Coordinator.updateFragmentExecStatus():1233] one instance report fail, query_id=4b65fa948d884c46-a048d7a98bba9e7f instance_id=4b65fa948d884c46-a048d7a98bba9e83
2020-12-08 10:36:17,286 WARN 170020 [Coordinator.getNext():653] get next fail, need cancel. query id: 4b65fa948d884c46-a048d7a98bba9e7f
2020-12-08 10:36:17,286 WARN 170020 [Coordinator.getNext():673] query failed: failed to build storage scanner, no materialized slot!
2020-12-08 10:36:17,286 WARN 170020 [StmtExecutor.execute():302] execute Exception. errCode = 2, detailMessage = failed to build storage scanner, no materialized slot!
```
----------------------------------------------------------------
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] francisoliverlee edited a comment on issue #5041: [Bug] constant value in sql executed result with "failed to build storage scanner, no materialized slot"(带常量的SQL执行报错)
Posted by GitBox <gi...@apache.org>.
francisoliverlee edited a comment on issue #5041:
URL: https://github.com/apache/incubator-doris/issues/5041#issuecomment-741464158
checked, like https://github.com/apache/incubator-doris/issues/4716, the sql is as bellowing, happened always
```SQL
SELECT
DISTINCT worksheet_1917_.`type`
FROM
(
SELECT
*
FROM
(
(
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'allday' as type,
allday_opened as opened,
allday_booked as booked,
allday_level_booking_rate / 100 as booking_rate,
allday_available as available,
available_class_24h as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
union all
(
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'pt' as type,
pt_opened as opened,
pt_booked as booked,
pt_level_booking_rate / 100 as booking_rate,
pt_available as available,
pt24h_available_class as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
) as temp
) as worksheet_1917_
limit
100
```
----------------------------------------------------------------
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] francisoliverlee commented on issue #5041: [Bug] constant value in sql executed result with "failed to build storage scanner, no materialized slot"(带常量的SQL执行报错)
Posted by GitBox <gi...@apache.org>.
francisoliverlee commented on issue #5041:
URL: https://github.com/apache/incubator-doris/issues/5041#issuecomment-741464158
checked, like https://github.com/apache/incubator-doris/issues/4716, the sql is as bellowing, happened always
```
SELECT
DISTINCT worksheet_1917_.`type`
FROM
(
SELECT
*
FROM
(
(
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'allday' as type,
allday_opened as opened,
allday_booked as booked,
allday_level_booking_rate / 100 as booking_rate,
allday_available as available,
available_class_24h as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
union all
(
select
to_date(schedule_date) schedule_date,
levelsn1 level,
'pt' as type,
pt_opened as opened,
pt_booked as booked,
pt_level_booking_rate / 100 as booking_rate,
pt_available as available,
pt24h_available_class as 24h_available_class
from
vk_app.vk_app_rpt_teacher_9m_productivity_level_all_new_da
)
) as temp
) as worksheet_1917_
limit
100
```
----------------------------------------------------------------
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] francisoliverlee commented on issue #5041: [Bug] constant value in sql executed result with "failed to build storage scanner, no materialized slot"(带常量的SQL执行报错)
Posted by GitBox <gi...@apache.org>.
francisoliverlee commented on issue #5041:
URL: https://github.com/apache/incubator-doris/issues/5041#issuecomment-740444688
the issue similar with https://github.com/apache/incubator-doris/issues/4716, but not the same.
----------------------------------------------------------------
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] francisoliverlee closed issue #5041: [Bug] constant value in sql executed result with "failed to build storage scanner, no materialized slot"(带常量的SQL执行报错)
Posted by GitBox <gi...@apache.org>.
francisoliverlee closed issue #5041:
URL: https://github.com/apache/incubator-doris/issues/5041
----------------------------------------------------------------
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