The database was created using collation version 2.31, but the operating system provides version 2.36. #3687
Replies: 8 comments 4 replies
-
Hi, You can correct this warning with two commands. First you need to make a backup for safety, then connect to your database.
|
Beta Was this translation helpful? Give feedback.
-
Hey, that seem to work for me, without any errors... THANK's so much... regards |
Beta Was this translation helpful? Give feedback.
-
Hey, my dockerized paperless installation has 3 separate containers. 1 is the db container, which u need terminal access to. in my case i logged in via portainer, but u can go aswell via synologys docker system. once logged in a root shell, log into your db, with something like:
One logged into the db That was it for me |
Beta Was this translation helpful? Give feedback.
-
Hm, can only tell u, what worked for me. Sorry. Not a total noob, but DBs not mine. |
Beta Was this translation helpful? Give feedback.
-
@jpoggi You seem to understand databases. Do you think you have what it takes to force my DB into working properly after the last Synology update DSM 7.2-64570 Update 1? Or is this a bug in the whole process? |
Beta Was this translation helpful? Give feedback.
-
Just a quick reminder, it's just a warning not an error or a bug, you can continue like this without any issues. Almost corrected, follow this (after backup your DB by precaution): Connect to your DB as usual:
Then switch to the postgres 'DB':
Correct collation from the postgres DB:
Reindex the postgres DB
Then switch to the template1 'DB':
Correct collation from the template1 DB:
Reindex the template1 DB
Done. |
Beta Was this translation helpful? Give feedback.
-
Thank you all for writing this out. had the exact same issue. Followed the steps, all better now. Thanks you. |
Beta Was this translation helpful? Give feedback.
-
This discussion has been automatically locked since there has not been any recent activity after it was closed. Please open a new discussion for related concerns. |
Beta Was this translation helpful? Give feedback.
-
Hi,
since a few Weeks i receive the following Logs:
26.06.2023 07:28:07 WARNING: database "paperless" has a collation version mismatch 26.06.2023 07:28:07 DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36. 26.06.2023 07:28:07 HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE paperless REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
Im running Paperless-ngx 1.16.3 on a Synology DSM in a Docker environment.
Can someone help me with
Rebuild all objects in this database that use the default collation and run ALTER DATABASE paperless REFRESH COLLATION VERSION, or build PostgreSQL with the right library version
as im not so experienced with DB stuff.regards
Daniel
P.S.: Wondering how this could happen?
Beta Was this translation helpful? Give feedback.
All reactions