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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
