8 months ago
Hello,
I'm experiencing some issues with my services on Railway and need detailed help to resolve them. I've identified two critical issues in the logs and would like to request assistance from a technician to guide me, or, if possible, perform the procedures with me.
1. PostgreSQL "Collation Mismatch"
The first problem is a recurring warning in my PostgreSQL service logs: "WARNING: database 'railway' has a collation version mismatch".
I understand that the safest solution is to:
- Create a complete backup of my current database.
- Delete the existing database service on Railway.
- Create a new PostgreSQL service so it is provisioned with the correct collation version.
- Import the data from the backup into the new database.
I would like to know if it's possible for a technician to help me execute these steps. I need precise guidance to ensure I don't lose any data during this migration process.
2. Redis "Memory Overcommit" Warning
The second issue is a critical warning in my Redis service logs: "WARNING Memory overcommit must be enabled!".
I understand that this configuration is crucial for Redis to perform background operations, like data persistence and replication, without failures. However, I don't have direct access to the operating system environment to enable this setting using the sysctl vm.overcommit_memory=1 command.
Could you please advise me on the best way to resolve this within the Railway environment? Or, if necessary, perform the change for me?
I appreciate your attention and kindly ask for assistance from a specialist. I am available to schedule a conversation or follow your instructions.
4 Replies
8 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 Bug postgre
- 🧵 WARNING: database "railway" has a collation version mismatch
- 🧵 Can no longer connect to Postgres after upgrade
- 🧵 i need help to fix my data base postgres
If you find the answer from one of these, please let us know by solving the thread!
8 months ago
helppppp
8 months ago
Apologies but this looks like an issue with the application level code. Due to volume, we can only answer platform level issues.
I've made this thread public so that the community might be able to help with you query.
Status changed to Awaiting User Response Railway • 8 months ago
8 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open jake • 8 months ago
6 months ago
I am not able to delete my old migration in the PostgreSQL Alembic version... why so and cannot see query editor also to upgrade the alembic head manually, hence my deployment is getting failed. so someone help me '