You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/08/29 11:31:05 UTC
[GitHub] [superset] maliklbn opened a new issue, #21235: Bug with SQL Lab : DB engine Error
maliklbn opened a new issue, #21235:
URL: https://github.com/apache/superset/issues/21235
Hello all,
I have a problem since a few days, I have this error as soon as I want to launch a query in SQL Lab or even just view a table :
'Data could not be retrieved from the results backend. You need to re-run the original query.'
Do you have any idea what it might be due to? I feel like I haven't changed anything though.
I should point out that the error occurs absolutely all the time, and with all databases that are on superset.
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1553005807
Hi @maliklamblin ,It is working fine.can you please recheck it and close the issue
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1541470570
Hi,Can you Please confirm is it fixed or not?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1550879394
Since you feel the issue is resolved, can you please close the issue?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1543533103
Hi, Can you provide detail information with the steps required to reproduce the same which you are facing.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1477943000
It is not a bug.I didn’t get DB engine error in Version 2.1.0 .But After launched the query i need to re run the query to see the results.
Loom video:-
https://www.loom.com/share/340f58920eea44bfb1bbb2339361533c
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1536986686
I see this on 2.1.0 now :(
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1541910420
I still see this in the docker image with version 2.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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1549274594
I could have found the issue, here are the findings:
1. I used local file system cache, now i have changed to REDIS cache
```
+# Config RESULTS_BACKEND
+RESULTS_BACKEND = RedisCache(
+ host=REDIS_HOST,
+ key_prefix='superset_results'
+)
```
2. another thing to notice is that i have 3 superset hosts running behind a loadbalancer, each were using local file system cache, so once i changed to use my redis cache results backend, it works fine.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1536086740
has this been fixed? @mishamsk
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] ShaliniIruvuru commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "ShaliniIruvuru (via GitHub)" <gi...@apache.org>.
ShaliniIruvuru commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1550879221
Since you feel the issue is resolved, can you please close the issue?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] mishamsk commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "mishamsk (via GitHub)" <gi...@apache.org>.
mishamsk commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1536511109
@zhujian0805 afaik no, but I haven't upgraded beyond 2.0.1, so not sure about the latest release
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] mishamsk commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by GitBox <gi...@apache.org>.
mishamsk commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1365585832
Have the same issue. Version 2.0.0. I am suspecting that this is happening after I restored a backup. Surprisingly it doesn't affect anything else: charts, dashboard and scheduled reports all work.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1548934335
Actually it's hard to reproduce, i just click the "RUN" button few times and i will get chance to see the error. is it because cache expired?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhujian0805 commented on issue #21235: Bug with SQL Lab : DB engine Error
Posted by "zhujian0805 (via GitHub)" <gi...@apache.org>.
zhujian0805 commented on issue #21235:
URL: https://github.com/apache/superset/issues/21235#issuecomment-1552316218
I'm fine to close. i'm not the guy created the issue. would ask if @maliklamblin is ok with closing. :)
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Bug with SQL Lab : DB engine Error [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #21235: Bug with SQL Lab : DB engine Error
URL: https://github.com/apache/superset/issues/21235
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org