You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@devlake.apache.org by "Startrekzky (via GitHub)" <gi...@apache.org> on 2023/12/01 08:14:41 UTC
[I] [Bug][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Startrekzky opened a new issue, #6132:
URL: https://github.com/apache/incubator-devlake/issues/6132
### 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
When investigating into the CI/CD schema, I found that
- table cicd_pipelines lacks the field `started_date`
- table cicd_tasks lacks the field `created_date`
These two fields are different in CI/CD workflows. For instance, if a GitLab job is queued after it's created, its `created_date` and `started_date` will be different.
### What do you expect to happen
In v0.20:
- [ ] Add the field `started_date` and `queued_date` to table cicd_pipelines
- [ ] Add the field `created_date`and `queued_date` to table cicd_tasks
- [ ] Add the field `queued_date` to table cicd_deployment_commits
- [ ] Check and fix the value assignment logic of Bamboo's `created_date`, `queued_date` and `started_date`
- [ ] Check and fix the value assignment logic of GitLab's `created_date`, `queued_date` and `started_date`
- [ ] Update the schema doc and diagram: https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema#cicd_pipelines
In v0.21:
- [ ] Check the values of `created_date` and `started_date` in cicd_pipelines
- [ ] GitHub
- [ ] Jenkins
- [ ] BitBucket
- [ ] Azure
- [ ] Check the values of `created_date` and `started_date` in cicd_tasks
- [ ] GitHub
- [ ] Jenkins
- [ ] BitBucket
- [ ] Azure
- [ ] Check the values of `created_date`, `queued_date` and `started_date` in cicd_deployment_commits
- [ ] GitHub
- [ ] Jenkins
- [ ] BitBucket
- [ ] Azure
### How to reproduce
Collect a GitLab job that has been queued.
### Anything else
_No response_
### Version
main
### 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-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6132:
URL: https://github.com/apache/incubator-devlake/issues/6132#issuecomment-1820013901
This issue has been automatically marked as stale because it has been inactive for 60 days. It will be closed in next 7 days if no further activity occurs.
--
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][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "d4x1 (via GitHub)" <gi...@apache.org>.
d4x1 commented on issue #6132:
URL: https://github.com/apache/incubator-devlake/issues/6132#issuecomment-1848956869
<img width="734" alt="image" src="https://github.com/apache/incubator-devlake/assets/5844806/2302d43d-aa3a-4c67-92a8-1ce1e594758a">
AzureDevops plugins has no cicd_deployment_commits data so far. So it's not checked.
--
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][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #6132: [Bug][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date`
URL: https://github.com/apache/incubator-devlake/issues/6132
--
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][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "abeizn (via GitHub)" <gi...@apache.org>.
abeizn closed issue #6132: [Bug][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date`
URL: https://github.com/apache/incubator-devlake/issues/6132
--
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][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6132:
URL: https://github.com/apache/incubator-devlake/issues/6132#issuecomment-1830986208
This issue has been closed because it has been inactive for a long time. You can reopen it if you encounter the similar problem in the future.
--
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][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date` [incubator-devlake]
Posted by "d4x1 (via GitHub)" <gi...@apache.org>.
d4x1 closed issue #6132: [Bug][Schema] cicd_pipelines lacks `started_date`, `queued_date` and cicd_tasks lacks `created_date`, `queued_date`
URL: https://github.com/apache/incubator-devlake/issues/6132
--
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
[GitHub] [incubator-devlake] d4x1 commented on issue #6132: [Bug][Schema] cicd_pipelines lacks `started_date` and cicd_tasks lacks `created_date`
Posted by "d4x1 (via GitHub)" <gi...@apache.org>.
d4x1 commented on issue #6132:
URL: https://github.com/apache/incubator-devlake/issues/6132#issuecomment-1729121804
Got it, it's a tedious change. I'll do it later.
--
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