dosubot[bot] commented on issue #8621: URL: https://github.com/apache/incubator-devlake/issues/8621#issuecomment-3433320650
<!-- Answer --> The crash is happening because the new `priority` column added in v1.0.3-beta7 does not set a default value or enforce NOT NULL during migration, so existing pipelines and blueprints from earlier versions have `NULL` for `priority`. The Go code expects a non-null integer, which causes the SQL scan error and panic on startup when it encounters a `NULL` value in this column ([PR #8534](https://github.com/apache/incubator-devlake/pull/8534)). To resolve this, you can manually update your database to set a default value (such as `0`) for all existing rows where `priority` is `NULL`. For example, in PostgreSQL: ```sql UPDATE _devlake_pipelines SET priority = 0 WHERE priority IS NULL; UPDATE _devlake_blueprints SET priority = 0 WHERE priority IS NULL; ``` This will allow DevLake to start up and run pipelines as expected. There is currently no official migration or documentation covering this scenario, so a manual SQL fix is the recommended workaround until a patch is released. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b0e2a633-6d43-4cd1-9127-2dc12fd7bc92?feedback_type=other)</sup> [](https://app.dosu.dev/b4e8e847-d479-4541-83a8-d88d83fea5c9/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/incubator-devlake/issues/8621) -- 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]
