dosubot[bot] commented on issue #32846: URL: https://github.com/apache/superset/issues/32846#issuecomment-2751947492
<!-- Greeting --> Hey @devikaaaa33! I'm here to help you with the issue you're facing. Let's work together to get this sorted out. <!-- Answer --> To resolve the "psycopg2.errors.UndefinedColumn: column tables.catalog_perm does not exist" error during the Superset DB migration from version 4.0.2 to 4.1.1, ensure that the migration script `58d051681a3b_add_catalog_perm_to_tables.py` has been executed successfully. This script adds the `catalog_perm` column to the `tables` and `slices` tables. You can manually apply this migration by running the following command: ```bash superset db upgrade ``` This command will apply all pending migrations, including the one that adds the `catalog_perm` column. If the migration has already been applied and the error persists, verify that the database schema is in sync with the expected state by checking the `alembic_version` table for the presence of the `58d051681a3b` revision. If necessary, you may need to manually inspect and modify the database schema to ensure the `catalog_perm` column exists <sup>[[1]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2024-05-01_10-52_58d051681a3b_add_catalog_perm_to_tables.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/8d6bcd5c-a571-48a1-acb2-2f9c5fbfd4c8?feedback_type=other)</sup> -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
