The database was created using collation version 2.36, but the operating system provides version 2.41.
rrohan419
HOBBYOP

2 months ago

database "railway" has a collation version mismatch

2025-09-26 10:00:10.101 UTC [455] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.

I tried running the query in db client
ALTERDATABASE railway REFRESHCOLLATIONVERSION;

REINDEXDATABASE railway;

but getting error : SQL Error [25001]: ERROR: REINDEX DATABASE cannot be executed within a pipeline

Error position:

Solved

3 Replies

Railway
BOT

2 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

rrohan419
HOBBYOP

2 months ago

solved

in db client connect the railway databse

then run
1. REINDEX DATABASE railway;

  1. ALTER DATABASE railway REFRESH COLLATION VERSION;

    and then redeploy the db service

echohack
EMPLOYEE

2 months ago

This is the solution! Glad you were able to find it independently.

+11

Status changed to Awaiting User Response Railway • 2 months ago

Status changed to Solved echohack • 2 months ago

Loading...