Baserow PSQL-DB - Collation mismatch

Technical Help
, ,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

Previously: version 1.26.1
Currently: version 1.33.0

If you are self-hosting, which installation method do you use to run Baserow?

Docker compose

What are the exact steps to reproduce this issue?

Hi, I have a major issue:
I’ve updated my system and baserow from version 1.26.1 to 1.33.0 and now I’m encountering a formula field not working any more…

In the docker logs of the baserow container I see this:
[POSTGRES][2025-05-05 15:40:01] 2025-05-05 15:40:01.294 UTC [58616] baserow@baserow HINT: Rebuild all objects affected by this collation and run ALTER COLLATION pg_catalog.“en-x-icu” REFRESH VERSION, or build PostgreSQL with the right library version.
baserow@baserow DETAIL: The collation in the database was created using version 153.14, but the operating system provides version 153.120.

So I guess I need to rebuild the collations.
I can access the SQL-DB that is created and managed by baserow in the container with the baserow user.
Yet, this user does not have sufficient rights to run an ALTER-Command.

So two questions:

  1. Have you experienced this before and have some solution suggestions?
  2. What are the account details for the PSQL-superuser?

Attach screenshots, videos, or logs that demonstrate the issue.

Bildschirmfoto 2025-05-06 um 11.03.20.png
Bildschirmfoto 2025-05-06 um 11.03.20.png3920×1298 843 KB

2

Hi @kuechleo, welcome to the community! I’ve escalated this issue internally so the team can dig in deeper.

Can you share some details on how you are hosting Baserow? Is it with Docker or something else? Do you use an external postgres server or the all-in-one image with the embedded database?

3

Hi @cwinhall ,
thx for the quick response and your help!

By now with your guidance I was able to fix the problem :partying_face: and will summarize the solution here.

Context:
Yes, I’m hosting Baserow in a Docker container, that is self-contained. So the PSQL-Database is also hosted inside the very same container.

Error:
After upgrading to a newer Baserow-Version (via Docker image pull of newest version) I’ve experienced the weird behavior as described above:
collation “en-x-icu” has a version mismatch

Solution:
Username: baserow
Password: run the command docker exec -it baserow cat /baserow/data/.pgpass

Running the following commands should fix the issue:
docker exec -it baserow bash (with baserow being the name of your container)

su - postgres -c "psql -d baserow"

REINDEX DATABASE baserow;

REINDEX SYSTEM baserow;

ALTER COLLATION pg_catalog."en-x-icu" REFRESH VERSION;

1 Like
4

So glad to hear you resolved it and thanks for sharing the solution for everyone else :heart:

1 Like