mysqld doesnt work after an upgrade

Arcath · 2009-08-09 16:34:32

after a recent upgrade mysqld has stopped working on my server, its been fine for a year (and as a result has allot of important data in the mysql databases).

when i attempt a restart of the service it just fails, the tail of /var/lib/mysql/whitefall.err is:

090809 17:30:14 InnoDB: Started; log sequence number 0 1621468
090809 17:30:14 [ERROR] /usr/sbin/mysqld: Error writing file '/var/lib/mysql//whitefall.pid' (Errcode: 28)
090809 17:30:14 [ERROR] Can't start server: can't create PID file: No space left on device
090809 17:30:14 mysqld_safe Number of processes running now: 0
090809 17:30:14 mysqld_safe mysqld restarted
090809 17:30:14 [Note] Plugin 'FEDERATED' is disabled.
090809 17:30:14 [Note] Plugin 'ndbcluster' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090809 17:30:14 [ERROR] Can't op090809 17:30:14 mysqld_safe Number of processes running now: 0
090809 17:30:14 mysqld_safe mysqld restarted

i dont know much about the workings of the mysql service, its rather urgent that this gets fixed.

would rolling back to an earlier version work> and if so how do i go about doing that?

djszapi · 2009-08-15 00:54:41

Hello Arcath!

"090809 17:30:14 [ERROR] Can't start server: can't create PID file: No space left on device" <= Is there any free space really ?

Arcath · 2009-08-17 16:34:23

yeah i fixed it now, my 3.5 GB pacman cache wasnt helping :S was able to start in safe mode and run the upgrade

Arch Linux

#1 2009-08-09 16:34:32

mysqld doesnt work after an upgrade

#2 2009-08-15 00:54:41

Re: mysqld doesnt work after an upgrade

#3 2009-08-17 16:34:23

Re: mysqld doesnt work after an upgrade

Board footer