Solvedsuperset Error logging in to superset (sqlalchemy.exc.ProgrammingError)

A clear and concise description of what the bug is.

Expected results

login panel

Actual results

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "ab_permission_view_role" does not exist
LINE 2: FROM ab_permission_view JOIN ab_permission_view_role ON ab_p...

[SQL: SELECT AS ab_permission_view_id, ab_permission_view.permission_id AS ab_permission_view_permission_id, ab_permission_view.view_menu_id AS ab_permission_view_view_menu_id
FROM ab_permission_view JOIN ab_permission_view_role ON = ab_permission_view_role.permission_view_id JOIN ab_role ON = ab_permission_view_role.role_id JOIN ab_permission ON = ab_permission_view.permission_id JOIN ab_view_menu ON = ab_permission_view.view_menu_id
WHERE = %(name_1)s AND IN (%(id_1)s)]
[parameters: {'name_1': 'menu_access', 'id_1': 2}]
(Background on this error at:


If applicable, add screenshots to help explain your problem.

How to reproduce the bug

Following the instructions on,

  1. git clone
  2. cd incubator-superset
  3. docker-compose up
    but unable to get to the l http://localhost:8088

In the docker-compose up output, I see an error related to ab_permission, pasted below
superset_init | sqlalchemy_exception, with_traceback=exc_info[2], from_=e
superset_init | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/", line 182, in raise_
superset_init | raise exception
superset_init | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/", line 1277, in _execute_context
superset_init | cursor, statement, parameters, context
superset_init | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/", line 593, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | sqlalchemy.exc.InternalError: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block
superset_init |
superset_init | [SQL: SELECT AS ab_permission_id, AS ab_permission_name
superset_init | FROM ab_permission
superset_init | WHERE = %(name_1)s]
superset_init | [parameters: {'name_1': 'all_datasource_access'}]
superset_init | (Background on this error at:
superset_app | - - [07/Nov/2020 08:34:58] "GET /health HTTP/1.1" 200 -
superset_app | INFO:werkzeug: - - [07/Nov/2020 08:34:58] "GET /health HTTP/1.1" 200 -
superset_init exited with code 1


(please complete the following information):

  • python version: Python 3.6.3
13 Answers

โœ”๏ธAccepted Answer

I share the following in hopes that my struggle will help someone else. After battling with this issue for over an hour, I was able to get past the error described in this issue by doing the following:

  1. In a terminal window run docker-compose up
  2. Once running, open the browser and observe the error described in this issue.
  3. In a separate terminal window run docker-compose down -v --remove-orphans
  4. Wait for both docker-compose processes to terminate.
  5. In the original terminal window run docker-compose pull and then docker-compose up --force-recreate --build

At this point, I could access the login screen at http://localhost:8088, but I could not login with the admin user. I shut down the instance (I don't recall how, most likely docker-compose down or docker-compose down -v --remove-orphans) and called it a day.

Today, running docker-compose up creates an instance that I can access with admin/admin.

$git status reports

On branch master
Your branch is up to date with 'origin/master'.

nothing to commit, working tree clean

I hope this helps.

Other Answers:

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.89. Please mark this comment with ๐Ÿ‘ or ๐Ÿ‘Ž to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

Related Issues:

superset Was unable to import superset Error: cannot import name '_maybe_box_datetimelike'
tx @Uneasy-listening !!! This worked for me: [only necessary if you have already installed pandas (p...
superset Error logging in to superset (sqlalchemy.exc.ProgrammingError)
I share the following in hopes that my struggle will help someone else After battling with this issu...
superset How to use โ€œemail reportโ€?
@sandy-ha please run superset init again in terminal because FAB(FlaskAppbuilder) will initialize re...
superset Filters as a native dashboard (v2) construct
Due to our changing priorities we have been unable to complete the dashboard level filters feature ...
superset How to have multiple filters on dashboard affecting different charts?
Oh you're right There's currently no way to express that We could add a feature that would introduce...
superset PyArrow broke the build on ARM platform [Regression]
I have the exact same issue on Windows 10 64-bit pip install apache-superset==0.35.1 on Raspbian (Ra...
superset docker-compose failed to build
Setup/Environment: Windows 10 + Docker Desktop + ~ 6 GB of RAM given to Docker (can be configured in...
amplify js Uncaught ReferenceError: global is not defined in latest Angular 6 RC
Just for reference I have passed through this issue with adding these lines on my index.html head: ...
react native firebase ๐Ÿ”ฅ(Android) Program type already present: io.invertase.firebase.BuildConfig
I think I found my ultimate error here In my package.json file I had at some point earlier ...
amplify cli Many-To-Many
You can implement many to many yourself using two 1-M @connections and a joining @model ...
amplify js fetch is not defined
nodejs fix: I'm using amazon-cognito-auth-js with my express app and I'm following the case 1 exampl...
amplify js Error: No credentials, applicationId or region
I had the same issue (running on the latest Amplify v3) and worked around it by changing the followi...
amplify js Is it possible to get cognito user attributes in Lambda/cloud logic ?
I have been looking around for a while I feel the answers here didn't really answer the problem ...
react native firebase ๐Ÿ”ฅ Version mismatch causing app termination
Looks like GoogleAppMeasurement gets imported as a dependency with version 5.3.0 A simple addition t...
react native firebase onNotificationOpened not working on Android (background/foreground)
Solved the issue only on background using @ZardozSpeaks approach Under my ...
grafana HTTP Error Bad Gateway when using prometheus
I still face this error after explicitly writing the URL (in my case it was http://localhost:9090) ...
amplify cli aws-exports.js is not generated
Even after the third read I find it utterly confusing and I have usability issues too ...
amplify js Auth Error: Amplify has not been configured correctly using Nuxt.js
I 'm having the same issue in aws-amplify: ^3.0.11 I found out Auth module didn't load configs of aw...
react native firebase Firebase dependency updates are required to fix gradle v4+ builds
@DeepaSriramRR as a temporal workaround you can disable version check of the Google plugin At the en...
react native firebase AndroidX support
Play Services just shipped AndroidX breaking changes - if you must upgrade your android Firebase SDK...
react native firebase RNFirebase core module was not found natively on ios
I will just leave it here in case someone comes and it's still struggling with this ...
amplify js How to refresh Cognito tokens
It will refresh if you call the SDK for it e.g. with Auth.currentSession() and it finds an expired t...
react native firebase [๐Ÿ“š] AdMob - use @invertase/react-native-google-ads
Just FYI we're getting close here AdMob documentation availability Hi there! I've noticed that AdMob...
react native firebase [SOLVED with v2.1.1] Undefined symbols for architecture x86_6: _OBJC_CLASS_$_RNFirebaseDatabaseReference
Okay.. if anybody comes accross this magic error try this It solved the problem (for now) Close Xcod...
react native firebase [android] No Firebase app '[DEFAULT]' has been created - call firebase.initializeApp(), js engine: hermes
I spent a lot of hours for found who was the problem most setup issues such as default app has not b...
react native firebase iOS: Firebase.h not found
Can you first close xcode then delete the xcworkspace & Podfile.lock files in the ios directory then...
amplify cli @auth public/private IAM roles and other Providers
ok my bad was actually quite easy just do : and add a auth provider in my case was IAM ...
react native firebase Android: JDK 10 not supported for v4.1.0
+1 4.1.0 broke builds for Java10 As a temporary workaround on MacOS Issue Upon upgrading to v4.1.0 a...
amplify js Sign up multiple different accounts with the same email
The pre-signup trigger can be used to prevent the new signup from being created when there's an exis...
ClickHouse DB::Exception: Too many parts (600). Merges are processing significantly slower than inserts
Each insert create a folder in /var/lib/clickhouse/.../table_name/ Inside that folder there are 2 fi...
amplify js Amplify Console 200 (Rewrite) fails on SPA React (Router) Application
This worked for me source: </^((?!.(css|gif|ico|jpg|js|png|txt|svg|woff|ttf)$).)*$/> target address:...
react native firebase Notification not showing up in foreground after triggering displayNotification() (Android)
It seems as if the requirements for displaying a foreground notification are stricter on Android ...
amplify js aws-amplify 0.3.0: "Uncaught ReferenceError: require is not defined" when packaged with webpack
Ok I found something that helped Graphql-js uses .mjs as file extension which caused issues with the...
react native firebase Unable to instantiate service io.invertase.firebase.messaging.MessagingService: java.lang.ClassNotFoundException
My problem was solved by removing these lines from my AndroidManifest.xml Issue I've updated both RN...
react native firebase pod install fails after npm install @react-native-firebase/firestore
I tried the above solutions and didn't work for me I solved the issue by deleting the ./ios/Podfile....
react native firebase cannot find symbol BuildConfig.APPLICATION_ID
@mikehardy seems like it should be enough to rename APPLICATION_ID to LIBRARY_PACKAGE_NAME in /app/a...
amplify js Identity providers authentication against User Pools WITHOUT hosted UI
@martimarkov we find a solution for you to use the customized button to do that ...
react native firebase Error: You attempted to use a firebase module that's not installed on your Android project by calling firebase.notifications()
The solution for this is to add those to app/build.gradle : implementation '
react native firebase IOS unable to receive notification
It appears as if RNFirebase documentation is missing a few required steps Issue: Not able to receive...
amplify cli jest-haste-map: Haste module naming collision: -> namefunction <-
For React Native 0.6x configure the blacklist in metro.config.js instead of rn-cli.config.js as per ...
amplify js Getting "no current user" after successful login to Cognito UserPool
I had the same problem but for me removing the cookie storage configuration in aws-exports.js solved...
amplify js How to add user to Group
๐Ÿ‘† Also we have achieved this using the Post Confirmation Lambda trigger Very simplified from our im...
react native firebase RNFirebaseNotifications.h file not found
I think in the header search paths it should be set to recursive for $(SRCROOT)/../node_modules/reac...
amplify js RFC: Amplify Library Modularization and Bundle Size Improvement
Modularization is available in Preview Hi all With us launching Modularization in the coming weeks ...
react native firebase Multiple dex files define Lcom/google/firebase/iid/zzb;
I got the same conflict with react-native-device-info and solved it with : After adding this package...
react native firebase Document how to mock react-native-firebase for jest
For now I've got this going on and it works for me (you may need to mock more or fewer modules or mo...
nativescript plugin firebase new iOS error on google auth - presenting view controller must be set
Google Auth was previously working on iOS but now I am receiving this error with no changes to codeb...
react native firebase Support Firebase SDK v5.0.0+
There are a number of breaking changed in v5 of the iOS pods: (