Superset Runbook
Contents
Superset Runbook#
Key Locations#
Env |
Namespace |
GitHub Repo |
---|---|---|
MOC-Smaug Prod |
Common errors#
ValueError: Invalid decryption key#
When rebooting superset, the initcontainer may crash and report ValueError: Invalid decryption key
in the logs.
To fix this you may have to set the secret key to null so it may be refreshed. Follow these steps:
Run the following:
NOTE: that running the following will clear the passwords for the databases in superset, and will need to be re-entered
$ oc rsh ${SUPERSET_DB_POD}
sh-4.2$ psql
postgres=# \connect supersetdb
supersetdb=# UPDATE public.dbs SET password = null;
supersetdb=# UPDATE public.dbs SET encrypted_extra = null;
Explained more here
Duplicate key value violates unique constraint#
When rebooting superset, the init container might report duplicate key value violates unique constraint
.
This happens when oauth mapping has overlapping users. If one user is in multiple groups then it will try to add the user twice, but run in to a conflict. Ensure that this is not the case.
Trino Error in Superset#
If you keep seeing “Trino errors show up” and in super logs you see:
requests.exceptions.ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
INFO:trino.exceptions:failed after 3 attempts
Try going to Data > Databases
at the top, open edit panel for opf-trino
database. Test the connection.
If it reports an error, try adding in the password again where it says XXX..
and see if that works.
Can’t find user when adding them to a Chart#
When adding a user to a chart, you may not be able to see the user.
In this example a user by the name of “Karan” could not be found.
First ensure that the user has logged into Superset at least once (so that the user is created within Superset)
When adding users to charts, you may see a lot of blank lines in the user list dropdown, these empty lines represent users that have not updated their First/Last name within Superset.
Have the user go to settings
(top right) > info
> edit user
. If the user does not have permissions to do this
reach out to an ODH admin, anyone from this list here will have the appropriate permissions. Have them
edit this user’s name accordingly.
The user should now show up in the drop down list when searched for by First/Last name.
This endpoint requires datasource $datasource (Public Dashboards)#
When making dashboards public you may encounter an error:
This endpoint requires the datasources $datasource, database, or
all_datasource_access
permission
Prerequisite:
Superset Admin
Resolution:
Go to Settings -> List users -> Edit Public role -> Permissions -> Select datasource drop down.
The datasource in the drop down should correspond to the one mentioned in the error. The name may not be exact, but
will likely be of the form: datasource access on [DATABASE].[$YOUR_DATASOURCE](id:##)
example:
datasource access on [Trino].[thoth_support_issues](id:83