You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@devlake.apache.org by "veetmoradiya3628 (via GitHub)" <gi...@apache.org> on 2025/08/14 13:51:35 UTC
[I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
veetmoradiya3628 opened a new issue, #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538
### 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
Receiving the below error while trying collecting the data from few Github Repositories
subtask Extract Jobs ended unexpectedly Wraps: (2) error adding result to batch (500) Wraps: (3) Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 (500) Wraps: (4) Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *mysql.MySQLError
<img width="1325" height="710" alt="Image" src="https://github.com/user-attachments/assets/aa4adf05-cf0c-4137-8a59-401b5994f933" />
### What do you expect to happen
Dev lake data collection pipeline should not fail and expecting the data collection to work fine.
### How to reproduce
It's working for most of the repositories, but we're seeing failures on a few of them.
### Anything else
Issue discussion @ https://devlake-io.slack.com/archives/C03APJ20VM4/p1754475976018429
### Version
devlake:v1.0.2-beta8
### Are you willing to submit PR?
- [x] 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-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh closed issue #8538: [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github
URL: https://github.com/apache/incubator-devlake/issues/8538
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "petkostas (via GitHub)" <gi...@apache.org>.
petkostas commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3319768778
@ssasoglu I have created a new PR directly to Devlake with the tag `v1.0.4-alpha` the images should be ready, can you give it a go?
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3212960482
Hi, @Startrekzky, I just reassigned the issue to @petkostas because he has been working on it for a while.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "ssasoglu (via GitHub)" <gi...@apache.org>.
ssasoglu commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3356003454
We confirmed that `v1.0.4-alpha` fixes this issue. The repository we had problems before, didn't have any problems with the pipeline in this version! Thank you for the effort. 🙌
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "ssasoglu (via GitHub)" <gi...@apache.org>.
ssasoglu commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3223160683
It looks like this was addressed in #8536 but there is no beta release that has this fix included. When can we get one @klesh? Or is this another bug on top of the solution?
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "petkostas (via GitHub)" <gi...@apache.org>.
petkostas commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3284221559
Thanks @klesh! I will most likely push next week as I am currently blocked for personal reasons.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "ssasoglu (via GitHub)" <gi...@apache.org>.
ssasoglu commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3264952866
@petkostas would it be a good idea to create an alpha version out of your branch? Otherwise we need to go through the developer setup right?
If we can get our hands on an alpha release, we can test it against the repo that we are having issues with.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3383861291
@ssasoglu @petkostas Thanks for your contribution.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3331953421
> [@ssasoglu](https://github.com/ssasoglu) I have created a new PR directly to Devlake with the tag `v1.0.4-alpha` the images should be ready, can you give it a go? [@klesh](https://github.com/klesh) there was a lint error in an existing migration file (whitespace), I have included a fix as a separate commit (the file was not modified by my original changes).
Got it, thanks for the information.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "petkostas (via GitHub)" <gi...@apache.org>.
petkostas commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3243110350
I am currently testing this with a few repositories, but I haven't been able to reproduce a zero-time date yet. My next step will be to create some tests that cover this scenario. Alternatively, if anyone affected by this issue can replicate the database and test against my branch, that would be very helpful.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "petkostas (via GitHub)" <gi...@apache.org>.
petkostas commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3188658258
Most likely elated to https://github.com/apache/incubator-devlake/issues/8442
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "ssasoglu (via GitHub)" <gi...@apache.org>.
ssasoglu commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3350368962
The NPM supply chain attack degraded our availability to test the new alpha version.
We are back in full capacity now. We will try `v1.0.4-alpha` version in the following days and I will update here.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "petkostas (via GitHub)" <gi...@apache.org>.
petkostas commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3224132939
@ssasoglu the merged PR addresses the issue in one place, but the remaining fields and tasks also need updating. I've opened a new PR to handle these changes. I'm currently looking for a few repositories that replicate the zero-time behavior, which is a corner case, to ensure the fix works as expected.
I'll provide an update once I've verified the fix with these additional cases.
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Github Data Collection] Receiving Incorrect datetime value: '0000-00-00' for column 'started_at' at row 280 Error types for some data collection in Github [incubator-devlake]
Posted by "klesh (via GitHub)" <gi...@apache.org>.
klesh commented on issue #8538:
URL: https://github.com/apache/incubator-devlake/issues/8538#issuecomment-3273014610
@petkostas You now have write access, so you can push the new branch directly to the main repo.
Pushing a `tag` that starts with `v` (e.g., `v1.0.4-alpha`) will trigger the GitHub Action to build docker images
--
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-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org