You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "larshelge (via GitHub)" <gi...@apache.org> on 2023/10/04 11:13:23 UTC
[I] Database connection cache and table cache timeout set to 0 crashes when creating dataset [superset]
larshelge opened a new issue, #25513:
URL: https://github.com/apache/superset/issues/25513
Database connection cache and table cache timeout set to 0 crashes when attempting to create a dataset.
#### How to reproduce the bug
* Create a new Database connection. In my case of type Amazon Redshift.
* Go to step 3 and select Performance.
* Set Schema cache timeout to 0 seconds.
* Set Table cache timeout to 0 seconds.
* Save the Database connection.
* Go to Datasets in the top menu.
* Click + Dataset.
* Select the mentioned database.
* Select a schema.
This will throw an exception with the following text:
> There was an error loading the tables: Unexpected error occurred, please check your logs for details
If I set the cache timeouts to a positive integer, the tables loads well.
Unfortunately the Docker Compose logs show nothing relevant.
### Expected results
I expect the tables for the schema to load, despite the cache timeout being set to 0.
The larger question is: How do you disable the schema and table cache entirely? The UI does not indicate how to do that. Setting the value to 0 is my best guess.
### Actual results
Loading tables will throw an exception with the following text:
> There was an error loading the tables: Unexpected error occurred, please check your logs for details
Unfortunately the Docker Compose logs show nothing relevant.
#### Screenshots
### Environment
(please complete the following information):
- Chrome. Version 117.0.5938.92 (Official Build) (64-bit).
- Superset 3.
- Docker Compose latest build, as of Oct 4, 2023.
--
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
Re: [I] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "cbuffevant (via GitHub)" <gi...@apache.org>.
cbuffevant commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-1998166417
I was able to replicate it with a Redshift Serverless cluster, using Superset 3.0.2. I can take a deeper look...
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-2540212191
CCing @betodealmeida or @sadpandajoe in case they might be interested in this one.
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-1997846917
I don't have a redshift instance to test, but maybe @cbuffevant (from the [rolodex](https://docs.google.com/spreadsheets/d/1U1qxiLvOX0kBTUGME1AHHi6Ywel6ECF8xk_Qy-V9R8c/edit#gid=0), thanks for signing up!) might have some insight here.
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "cbuffevant (via GitHub)" <gi...@apache.org>.
cbuffevant commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-1998846108
Yes, I can confirm that setting timeout value to 1, works fine. The problem seems to be related with values <= 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
Re: [I] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-2842832397
This has been silent for a long while now. Is it still an issue in 4.1.2/5.0.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
Re: [I] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-1998516746
Oh, interesting. Thanks for validating. I wonder if putting in a reasonable default clears the error? In other words are just 0/-1 problematic, but 60 or 600 are fine? Thanks for looking into this!
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-3152841321
Closing this out as inactive/not planned, but MORE than happy to reopen/revisit if this is still an issue in 5.0.0/`master`
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "cbuffevant (via GitHub)" <gi...@apache.org>.
cbuffevant commented on issue #25513:
URL: https://github.com/apache/superset/issues/25513#issuecomment-1998178929
After removing the cache time out values, the error persists...
--
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] Database cache and table cache timeout set to 0 or -1 crashes when creating dataset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #25513: Database cache and table cache timeout set to 0 or -1 crashes when creating dataset
URL: https://github.com/apache/superset/issues/25513
--
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