dosubot[bot] commented on issue #33347: URL: https://github.com/apache/superset/issues/33347#issuecomment-2848078607
<!-- Greeting --> Hello @teocherasco! I'm here to help you tackle any bugs, answer your questions, and guide you as you contribute. While we wait for a human maintainer, feel free to share more about your issue! 🚀 <!-- Answer --> I found a similar closed issue regarding the reconnection to PostgreSQL failing with a "Database Creation Error" after changing the DB password on AWS RDS. The issue was related to the SQL Alchemy URI not being updated with the new password, which could cause the connection to fail despite successful connection tests <sup>[[1]](https://github.com/apache/superset/blob/master/superset/commands/database/validate.py)</sup>. Additionally, the error log mentions the 'ab_view_menu_id_seq' sequence, which is used to generate unique IDs for the 'id' column in the 'ab_view_menu' table. If this sequence is missing, it might be due to an incomplete or incorrect database migration <sup>[[2]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-09-24_12-04_3fbbc6e8d654_fix_data_access_permissions_for_virtual_.py)</sup>. To resolve the issue, ensure that the SQL Alchemy URI in Superset's configuration is updated with the new password. Also, verify that the database schema is correctly set up, including the presence of the 'ab_view_menu_id_seq' sequence. <!-- 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/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b50e2d14-c342-433c-9105-05f5d6f78b3e?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]
