Search before asking

• I had searched in the issues 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

• I agree to follow this project's Code of Conduct