dosubot[bot] commented on issue #33252: URL: https://github.com/apache/superset/issues/33252#issuecomment-2832439102
<!-- Greeting --> Hello @farovictor! I'm here to help you with any bugs, questions, or contributions while you wait for a human maintainer. Let's tackle this issue together! <!-- Answer --> I found a similar solved discussion that might be relevant to your issue: [Manual Docker Image Build - Containers exiting with error](https://github.com/apache/superset/discussions/27061#discussioncomment-8444309). In that case, the solution involved stopping the app, killing all sessions in the database, running migrations cleanly, and then restarting the app <sup>[[1]](https://github.com/apache/superset/discussions/27061)</sup>. Additionally, there's an unsolved discussion that might be related: [docker-compose build error "sqlalchemy.exc.OperationalError: (psycopg2.errors.DeadlockDetected) deadlock detected"](https://github.com/apache/superset/discussions/28191), which was last updated on April 24, 2024 <sup>[[2]](https://github.com/apache/superset/discussions/28191)</sup>. The deadlock error you're encountering during the `superset-init-db` job in the Helm chart deployment process seems to be related to the `dashboard_roles` table. This table is used to establish a many-to-many relationship between dashboards and roles, allowing for role-based access control <sup>[[3]](https://github.com/apache/superset/blob/master/superset/models/dashboard.py)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2021-01-14_19-12_e11ccdd12658_add_roles_relationship_to_dashboard.py)</sup>. To resolve the deadlock issue, you might consider scaling down all deployments to 0 replicas, as you mentioned, to ensure no other processes are accessing the database during the migration. This approach aligns with the solution from the solved discussion. <!-- 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/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a78eb311-04a6-4f37-b371-f896aa660762?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]
