Error in MySQL service
fernandofedora
HOBBYOP

2 months ago

Hi, I'm trying to install a node.js application. The project service runs normally on port 8080, but it's not possible to connect to the MySQL database. When I looked at the MySQL service logs, I discovered these errors.

This is likely why I can't use the service correctly to connect to the database.

I've attached an image with the error details.

I would appreciate any help you could give me.

$10 Bounty

22 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!


brody
EMPLOYEE

2 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 brody about 2 months ago


Does your mysql database have data?


realdonalfred
PRO

2 months ago

The most common cause is insufficient memory or resources.
When MySQL doesn’t have enough RAM or disk space during startup, it can’t complete InnoDB initialization or write redo log files. This often happens on small Railway instances or when the container restarts while MySQL is still flushing data to disk.

InnoDB requires enough memory to allocate buffers and redo logs at startup. If memory runs out or the process is killed by the system (OOM — Out Of Memory), MySQL leaves incomplete or corrupted data files, leading to the error you saw.

Try:

Increase memory or disk resources on your Railway service.

If you don’t need the existing data, delete the data volume and restart MySQL


realdonalfred

The most common cause is insufficient memory or resources.When MySQL doesn’t have enough RAM or disk space during startup, it can’t complete InnoDB initialization or write redo log files. This often happens on small Railway instances or when the container restarts while MySQL is still flushing data to disk.InnoDB requires enough memory to allocate buffers and redo logs at startup. If memory runs out or the process is killed by the system (OOM — Out Of Memory), MySQL leaves incomplete or corrupted data files, leading to the error you saw.Try:Increase memory or disk resources on your Railway service.If you don’t need the existing data, delete the data volume and restart MySQL

I... don't think this is true. It says it "failed to initialize data directory".


samgordon

Does your mysql database have data?

realdonalfred
PRO

2 months ago

That's a great question


samgordon

I... don't think this is true. It says it "failed to initialize data directory".

realdonalfred
PRO

2 months ago

Maybe this happened because MySQL ran out of memory or disk space during startup, shutdown or writing proccess...
When the system doesn’t have enough RAM or storage, MySQL can’t finish writing internal files and the process is then killed by the system or crashes, leaving the database in an inconsistent state.


I suppose that could be a cause of corruption, yes.


realdonalfred
PRO

2 months ago

Ojalá no tengas información importante.

Intenta incrementar la RAM o el espacio en disco e intenta reconstruir tu base de datos, si te permite acceso a los archivos intenta modificar el my.cnf agregando.

innodb_force_recovery=1

Hopefully, you don't have any important information.

Try increasing your RAM or disk space and rebuilding your database. If it allows access to the files, try modifying the my.cnf file by adding:

innodb_force_recovery=1


samgordon

Does your mysql database have data?

fernandofedora
HOBBYOP

2 months ago

No, at the moment there is no data, because the error appears since I created the mysql service, it has been impossible to use the mysql service to access the database :(


realdonalfred

The most common cause is insufficient memory or resources.When MySQL doesn’t have enough RAM or disk space during startup, it can’t complete InnoDB initialization or write redo log files. This often happens on small Railway instances or when the container restarts while MySQL is still flushing data to disk.InnoDB requires enough memory to allocate buffers and redo logs at startup. If memory runs out or the process is killed by the system (OOM — Out Of Memory), MySQL leaves incomplete or corrupted data files, leading to the error you saw.Try:Increase memory or disk resources on your Railway service.If you don’t need the existing data, delete the data volume and restart MySQL

fernandofedora
HOBBYOP

2 months ago

According to the calculations, the MySQL service has resources allocated. :(


fernandofedora

According to the calculations, the MySQL service has resources allocated. :(

realdonalfred
PRO

2 months ago

Try reattaching the image after swapping it, but it seems the file is corrupted.


fernandofedora
HOBBYOP

2 months ago

I have deleted the service and recreated it twice and the same error always appears :( I don't know if this is an internal problem :(


fernandofedora

I have deleted the service and recreated it twice and the same error always appears :( I don't know if this is an internal problem :(

realdonalfred
PRO

2 months ago

Try using a lower or newer MySQL version.


realdonalfred

Try using a lower or newer MySQL version.

fernandofedora
HOBBYOP

2 months ago

How can I do that? Normally, I just click the Create button, select MySQL, and the MySQL service is created automatically.

Could you give me some guidance on how I could do that? Thank you very much for responding.


fernandofedora
HOBBYOP

2 months ago

As additional information, I am noticing that all the Mysql services are having errors in Railway. I don't know if this is an internal problem :(. The different services that I have, both the old ones and the new ones, are presenting errors when using the Mysql service :(


realdonalfred
PRO

2 months ago

Go to the settings page and edit the source.


realdonalfred

Go to the settings page and edit the source.

fernandofedora
HOBBYOP

2 months ago

It says I have 9.4

Attachments


fernandofedora

It says I have 9.4

realdonalfred
PRO

2 months ago

Try an older MySQL version and rebuild the node.


fernandofedora
HOBBYOP

2 months ago

Thank you very much, I tried to change to 9.0 but I always get the same error, the mysql service still doesn't work


fernandofedora
HOBBYOP

2 months ago

I have also tried to create a service from scratch, and independently, and there is always an error.

Attachments


fernandofedora
HOBBYOP

2 months ago

Many thanks to everyone who has taken the time to try to help me and give me some ideas.

I think the best thing to do would be to find another platform.

many thanks for everything


realdonalfred
PRO

a month ago

Maybe you can use RDS for DB. Have a nice day.


Loading...