dosubot[bot] commented on issue #31586: URL: https://github.com/apache/superset/issues/31586#issuecomment-2557442293
<!-- Greeting --> Hey @dkjackyu! I'm here to help you out with any bugs, questions, or contributions you have in mind. Let's squash those bugs and get things sorted! 🤖 <!-- Answer --> I found a similar closed issue that addresses the `relation "report_schedule" does not exist` error. The suggested solution is to run the database migrations before starting the application. This involves executing the command `sudo docker compose run --rm superset superset db upgrade` before `sudo docker compose up --build`. This step ensures that the database schema is up-to-date, which resolves the missing table issue <sup>[[1]](https://github.com/apache/superset/issues/21160)</sup>. The error occurs because the database schema is not aligned with the application's expected schema, which includes the `report_schedule` table. Running `superset db upgrade` applies the necessary database migrations, including the creation of the `report_schedule` table and related tables, thus fixing the issue <sup>[[2]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2020-11-04_11-06_49b5a32daba5_add_report_schedules.py)</sup>. Regarding updates to the codebase or documentation, the current documentation already emphasizes the importance of running `superset db upgrade` before starting the application. It seems that the documentation is correct, but ensuring that users follow these steps is crucial for a smooth setup experience. <!-- 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/fd471838-e897-4a45-bd57-3d94eb3dc106?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/fd471838-e897-4a45-bd57-3d94eb3dc106?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/fd471838-e897-4a45-bd57-3d94eb3dc106?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/fd471838-e897-4a45-bd57-3d94eb3dc106?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/fd471838-e897-4a45-bd57-3d94eb3dc106?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/fd471838-e897-4a45-bd57-3d94eb3dc106?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: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
