Skip to content

Cannot delete database #21106

@ghost

Description

On a fresh installation, I create a new BigQuery database. I can connect to the database just fine.
However, if I try to delete it, I get the following error:
Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute cursor.execute(statement, parameters) psycopg2.errors.UndefinedColumn: column report_schedule.extra_json does not exist

I have run superset db upgrade and superset db init.

The problem seems to be that the columns of report_schedule table are not what the source code is expecting.

How to reproduce the bug

  1. Install the latest version Apache Superset using the Docker image
  2. Login with an admin user.
  3. Create a BigQuery database following superset instructions
  4. Delete the database you created on step 3

Expected results

The database I created to be deleted.

Actual results

Error: There was an issue deleting Google BigQuery: Fatal error
Error on logs: Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute cursor.execute(statement, parameters) psycopg2.errors.UndefinedColumn: column report_schedule.extra_json does not exist

Screenshots

If applicable, add screenshots to help explain your problem.

Environment

(please complete the following information):

  • browser type and version: Chrome latest
  • superset version: 2.0.0
  • python version: 3.8
  • node.js version: -
  • any feature flags active:

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Docker container is running on Cloud Run. The database used is PostgreSQL 14

Metadata

Metadata

Assignees

No one assigned

    Labels

    #bugBug report

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions