dosubot[bot] commented on issue #8602: URL: https://github.com/apache/incubator-devlake/issues/8602#issuecomment-3361930037
<!-- Answer --> The error happens because the `name` column in the `cicd_deployments` table is defined as `varchar(255)`, but some GitHub deployment names exceed this length, causing MySQL to reject the insert and fail the pipeline. There is currently no trimming or validation for this field before insertion in the code, so any name longer than 255 characters will trigger this error. You have two main options: 1. **Increase the column length** in your database schema and model (for example, to `varchar(500)`), which allows longer names but may impact performance if the column is indexed. 2. **Trim the name field in code** before insertion, ensuring it never exceeds 255 characters, which avoids schema changes but may result in loss of information for very long names. Both approaches are valid and have been used for similar issues in DevLake before ([example](https://github.com/apache/incubator-devlake/issues/8545)). If you want a quick workaround, trimming the string in the extraction or insertion logic is safest for stability. If you prefer to preserve full names, update the schema and run the necessary migrations. Let me know if you want step-by-step guidance for either approach! <!-- 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/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/ceeefbc6-b706-4610-9a6a-75a14c563a50?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/8602) -- 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]
