Pipeline stuck in pending status

[rubenelshof]

Component

server

Describe the bug

While the error in #3424 was fixed I am now receiving a different issue.

Starting a pipeline works and shows me steps but I am getting an error and the pipeline is stuck in pending status.

Last working version is next-bf0a9455ce

System Info

next-6eafb37aba

Additional context

:42PM ERR woodpecker/src/github.com/woodpecker-ci/woodpecker/server/pipeline/start.go:36 > error persisting steps for docker-images/misc#46 error="Error 1062 (23000): Duplicate entry '5927' for key 'PRIMARY'" repo=docker-images/misc
5:42PM ERR woodpecker/src/github.com/woodpecker-ci/woodpecker/server/pipeline/create.go:139 > failed to start pipeline for docker-images/misc error="Error 1062 (23000): Duplicate entry '5927' for key 'PRIMARY'"
5:42PM ERR woodpecker/src/github.com/woodpecker-ci/woodpecker/server/router/middleware/logger.go:57 > error="Error #01: failed to start pipeline for docker-images/misc\n" ip= latency=238.678019 method=POST path=/api/repos/13/cron/10 status=500 user-agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36"

Validations

• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Checked that the bug isn't fixed in the next version already [https://woodpecker-ci.org/faq#which-version-of-woodpecker-should-i-use]