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/10/21 15:16:49 UTC
[GitHub] [superset] lwandrebeck opened a new issue, #21910: PostgreSQL 15.0 - There was an error loading the schemas and the tables
lwandrebeck opened a new issue, #21910:
URL: https://github.com/apache/superset/issues/21910
Rocky Linux 9, Superset 2.0.0 (virtual env install).
Superset databaseview/list page does not show anymore available databases (without displaying any error), and thus data upload is not possible anymore. Existing dataset is still usable. Used to work fine with PostgreSQL 14 (pg_upgrade was used to get from 14 to 15, so previous rights when it comes to schemas were kept).
#### How to reproduce the bug
1. Go to data (top menu)
2. Click on databases
3. databaseview/list page is displayed
4. database list is empty
### Expected results
Page should list available databases.
### Actual results
Page shows no available database.
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: Firefox 106.0.1
- superset version: Superset 2.0.0
- python version: Python 3.9.10
- node.js version: not installed
- any feature flags active: --certfile=/home/XXX/YYY.crt --keyfile=/home/XXX/YYY.key -b ip:port -w 10 -k gevent --worker-connections 1000 --timeout 120 --limit-request-line 0 --limit-request-field_size 0 --pid /run/superset/superset.pid "superset.app:create_app()
### Checklist
- [X] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [X] I have reproduced the issue with at least the latest released version of superset.
- [X] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
superset init has been run, no change.
No error on postgresql, celery, redis sides either.
I already have upgraded a couple other things from PG14 to PG15 without problem (nextcloud, mediawiki…) so I suspect there’s something fishy on superset side.
Thanks for your support !
--
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] lwandrebeck commented on issue #21910: PostgreSQL 15.0 - There was an error loading the schemas and the tables
Posted by GitBox <gi...@apache.org>.
lwandrebeck commented on issue #21910:
URL: https://github.com/apache/superset/issues/21910#issuecomment-1294658018
Works fine once I have added (back ? can’t remember) user to admin group. I can’t say for sure if it’s a pg_upgrade problem or a small compatibility glitch due to internal changes between 14 and 15. Marking it as closed.
--
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] lwandrebeck closed issue #21910: PostgreSQL 15.0 - There was an error loading the schemas and the tables
Posted by GitBox <gi...@apache.org>.
lwandrebeck closed issue #21910: PostgreSQL 15.0 - There was an error loading the schemas and the tables
URL: https://github.com/apache/superset/issues/21910
--
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