R
Railway10mo ago
anasxhd

MySQL database 'Disk is full'

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.
Solution:
you would want to upgrade to pro so you could then grow your volume to 50gb and successfully restart your database
Jump to solution
27 Replies
Percy
Percy10mo ago
Project ID: f38b84de-cc94-4845-a0c3-3dfcb1f9d42f
anasxhd
anasxhd10mo ago
f38b84de-cc94-4845-a0c3-3dfcb1f9d42f
Brody
Brody10mo ago
what does the graph for disk (volume) usage look like?
anasxhd
anasxhd10mo ago
No description
Brody
Brody10mo ago
that's the service metrics, please click on the volume to view the volume usage
anasxhd
anasxhd10mo ago
Where is that?
Brody
Brody10mo ago
the volume is attached to the service block on the canvas, looks like a little tab and will say something like "mysql data"
anasxhd
anasxhd10mo ago
No description
Brody
Brody10mo ago
yep definitely out of storage
anasxhd
anasxhd10mo ago
So my plan support 5gb of data?
Brody
Brody10mo ago
that's correct, can you tell me the start command your database is using? that would be in the service settings
anasxhd
anasxhd10mo ago
docker-entrypoint.sh mysqld --innodb-use-native-aio=0
Brody
Brody10mo ago
then we might be able to regain some of that storage
anasxhd
anasxhd10mo ago
My plan doesn't show any where that there is a limit of 5gb??
Brody
Brody10mo ago
the hobby plan has a 5gb volume limit
anasxhd
anasxhd10mo ago
The other plans?
Brody
Brody10mo ago
the pro plan has a 50gb volume limit is your database crashed?
anasxhd
anasxhd10mo ago
Yes
Brody
Brody10mo ago
ah then unfortunately we are to late to be able to free disk space because the database needs to be active
Solution
Brody
Brody10mo ago
you would want to upgrade to pro so you could then grow your volume to 50gb and successfully restart your database
anasxhd
anasxhd10mo ago
50gb per each database?
Brody
Brody10mo ago
correct!
anasxhd
anasxhd10mo ago
Thanks
Brody
Brody10mo ago
50gb volume per any service actually
anasxhd
anasxhd10mo ago
Thanks for quick reply
Brody
Brody10mo ago
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
anasxhd
anasxhd10mo ago
Thanks
Want results from more Discord servers?
Add your server