Race condition while rendering pipeline commit

[xoxys]

Component

web-ui

Describe the bug

Bildschirmaufzeichnung.vom.2024-12-08.20-56-36.mp4

Sometimes pipeline. is rendered instead of the commit hash. I guess that's a race condition during data loading from pinia. What I'm wondering about it, this only happens while a user is logged in. If the pipeline list is loaded as unauthenticated, everything seems to be working as intended.

Steps to reproduce

Reload the pipeline list multiple times.

Expected behavior

No response

System Info

{"source":"https://github.com/woodpecker-ci/woodpecker","version":"next-d0e4a176f1"}

Additional context

No response

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]

[zc-devs]

Authenticated

Unauthenticated

1. Requests for pipelines per repo I have. Wasn't a case on 2.8.
2. Request for current active repo.

[xoxys]

Seems to be related to https://github.com/woodpecker-ci/woodpecker/pull/3806/files#r1921574171

[xoxys]

https://github.com/woodpecker-ci/woodpecker/pull/3806/files#r1921575001

AFAIK SQL this was a syntax error, but not sure.

Please double-check that with all DBs. I'm having a similar issue in my message rework PR, and there it is always working with some DBs, but not with the others.

Original author @qwerty287

[xoxys]

I can reproduce the SQL error in sqlite

Will try to find a workaround while keeping the escaped syntax.