duplicate key value violates unique constraint "deployment_metadata_script"
I've been troubleshooting a problem where it takes a long time to schedule jobs and I'm not sure if this is related or not but I'm seeing a bunch of these error messages in my postgres database:
4 Replies
@Hugo this might be of interest
@mrquip what version of windmill are you on ?
Ok it appears to have stopped. One of the users on the server had a bad git sync job that we disabled and it has stopped. We are on the latest helm chart v1.358.1
Now I'm just seeing this warning:
| 2024-07-08 18:18:56.430 GMT [6243] WARNING: database "postgres" has a collation version mismatch
│ 2024-07-08 18:18:56.430 GMT [6243] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
│ 2024-07-08 18:18:56.430 GMT [6243] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
│ 2024-07-08 18:18:56.430 GMT [6243] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.
│ 2024-07-08 18:18:56.430 GMT [6243] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
that's ok
Ok cool. Thanks!