MySQL Partition full

Events happening in the community are now at Drupal community events on www.drupal.org.
n20's picture

Hello,

im facing a WSOD On all my sites. It seems this happens because of a full mysql partition.

Trying to restart mysql:
service mysql restart

gives:
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!

Any suggestion on how to solve this?

Thanks, N20

Comments

Suggest you put this in the

hyperglide's picture

Suggest you put this in the issue queue -- drupal.org/project/barracuda

Did you check your free disk space?

I found this

zkrebs's picture

https://groups.google.com/forum/?fromgroups#!topic/copress/drszur6Zf98

Move MySQL to another Partition/HDD

geoff's picture

If you have room on another partition, you can

stop MySQL
move the MySQL folder to the new partition
symlink the old location to the new location to change the location in the ini file
restart MySQL

If you can, add a new HDD to the server (Using AWS this is easy, depends on where you are hosting) and use that as your MySQL location.

I created multiple drives - one for MySQL, one for BOA Data, one for root and one for backup files. Just mount them where you want them.

Wow, very quick responses!

n20's picture

Wow, very quick responses! Thanks!

Checked my free disk space, i guess my disk is full because of the one dev sites im running has large videos. That + daily backups filled the disk i guess.

i dont needed the dev site anymore so i deleted it manually from disk. Now i get:

Stopping MariaDB database server: mysqld.
Starting MariaDB database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..

when trying to restart mysql

That is normal after killing

rpsu's picture

That is normal after killing (or any other way not cleanly stopped) MariaDB process. It may take a moment to do Checking, but it should report after a while what it has done.

--
Perttu Ehn

unfortunately Not. The

n20's picture

unfortunately Not. The commandline output stops at this point.

Got every thing working with

n20's picture

Got every thing working with upgrade to Head and forced SQL reinstall.

Thanks everybody

BOA

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: