MySQL database 'Disk is full' | Railway | Page 1

grizzled mauve Jan 22, 2024, 5:00 PM

#

Started to get the error below, what's wrong?

2024-01-22T16:56:50.873312Z 9 [ERROR] [MY-000035] [Server] Disk is full writing './binlog.000006' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.

lean moatBOT Jan 22, 2024, 5:00 PM

#

Project ID: f38b84de-cc94-4845-a0c3-3dfcb1f9d42f

silent joltBOT Jan 22, 2024, 5:00 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

grizzled mauve Jan 22, 2024, 5:00 PM

#

lean moat

f38b84de-cc94-4845-a0c3-3dfcb1f9d42f

cunning depot Jan 22, 2024, 5:11 PM

#

what does the graph for disk (volume) usage look like?

grizzled mauve Jan 22, 2024, 5:12 PM

#

cunning depot Jan 22, 2024, 5:13 PM

#

that's the service metrics, please click on the volume to view the volume usage

grizzled mauve Jan 22, 2024, 5:13 PM

#

Where is that?

cunning depot Jan 22, 2024, 5:14 PM

#

the volume is attached to the service block on the canvas, looks like a little tab and will say something like "mysql data"

grizzled mauve Jan 22, 2024, 5:14 PM

#

cunning depot Jan 22, 2024, 5:14 PM

#

yep definitely out of storage

grizzled mauve Jan 22, 2024, 5:14 PM

#

So my plan support 5gb of data?

cunning depot Jan 22, 2024, 5:16 PM

#

that's correct, can you tell me the start command your database is using? that would be in the service settings

grizzled mauve Jan 22, 2024, 5:17 PM

#

docker-entrypoint.sh mysqld --innodb-use-native-aio=0

cunning depot Jan 22, 2024, 5:17 PM

#

then we might be able to regain some of that storage

grizzled mauve Jan 22, 2024, 5:18 PM

#

My plan doesn't show any where that there is a limit of 5gb??

cunning depot Jan 22, 2024, 5:18 PM

#

the hobby plan has a 5gb volume limit

grizzled mauve Jan 22, 2024, 5:18 PM

#

The other plans?

cunning depot Jan 22, 2024, 5:18 PM

#

the pro plan has a 50gb volume limit

#

is your database crashed?

grizzled mauve Jan 22, 2024, 5:19 PM

#

Yes

cunning depot Jan 22, 2024, 5:19 PM

#

ah then unfortunately we are to late to be able to free disk space because the database needs to be active

#

you would want to upgrade to pro so you could then grow your volume to 50gb and successfully restart your database

grizzled mauve Jan 22, 2024, 5:20 PM

#

50gb per each database?

cunning depot Jan 22, 2024, 5:20 PM

#

correct!

grizzled mauve Jan 22, 2024, 5:20 PM

#

Thanks

cunning depot Jan 22, 2024, 5:21 PM

#

50gb volume per any service actually

grizzled mauve Jan 22, 2024, 5:21 PM

#

Thanks for quick reply

cunning depot Jan 22, 2024, 5:21 PM

#

no problem, after you upgrade if you need any specific help growing your database's volume I'll be around

#

since it's a manual process

grizzled mauve Jan 22, 2024, 5:22 PM

#

Thanks

#MySQL database 'Disk is full'