The0Danktor opened a new issue, #8229: URL: https://github.com/apache/incubator-devlake/issues/8229
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened Will collecting and transforming data the crashes on the subtask extractJobs this happens because for some reason a workflow stopped before it started causing it to have a negative durration and the field is an bigint unsigned time="2024-12-03 09:07:05" level=error msg=" [pipeline service] [pipeline #3] [task #16] subtask extractJobs ended unexpectedly\n\tWraps: (2) error adding result to batch (500)\n\tWraps: (3) Error 1264 (22003): Out of range value for column 'duration_sec' at row 262 (500)\n\tWraps: (4) Error 1264 (22003): Out of range value for column 'duration_sec' at row 262\n\tError types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *mysql.MySQLError" ### What do you expect to happen that it would work even with a negative duration maby by changing them to positive or changing the field type in the database ### How to reproduce import a workflow in circleci that has a negative duration ### Anything else _No response_ ### Version v1.0.1 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
