Re: mysql server stopped and i cannot restart
Any luck in resolving this issue? I just rebooted by computer, and guess
what... mysql refuses to start now.
Mar 22 16:54:05 warthog mysqld_safe[2740]: started
Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Warning] option
'net_buffer_length': unsigned value 8388608 adjusted to 1048576
Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File
'/var/log/mysql/mysql-slow.log' not found (Errcode: 13)
Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Could not
use /var/log/mysql/mysql-slow.log for logging (error 13). Turning
logging off for the whole duration of the MySQL server process. To turn
it on again: fix the cause, shutdown the MySQL server and restart it.
Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File
'/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Aborting
Mar 22 16:54:05 warthog mysqld[2744]:
Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Note]
/usr/sbin/mysqld: Shutdown complete
Mar 22 16:54:05 warthog mysqld[2744]:
Mar 22 16:54:05 warthog mysqld_safe[2746]: ended
Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]:
It does complain about logfiles not being there, but they are, and
readible by mysql user.
I am starting to get a bit puzzled. Any helps?
Ronald
harland christofferson wrote:
> I am running 2.6.18-5-amd64
>
> For some reason, the mysql server stopped and I cannot restart it. I
> have not upgraded and the machine was running nominally otherwise for
> 120+ days.
>
> $cat /var/log/messages | grep mysql
>
> Mar 21 12:04:57 localhost mysqld_safe[7775]: started
> Mar 21 12:04:57 localhost mysqld[7778]: ^G/usr/sbin/mysqld: File
> '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
> Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [ERROR] Aborting
> Mar 21 12:04:57 localhost mysqld[7778]:
> Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [Note]
> /usr/sbin/ mysqld: Shutdown complete
> Mar 21 12:04:57 localhost mysqld[7778]:
> Mar 21 12:04:57 localhost mysqld_safe[7780]: ended
> Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: 0 processes alive and
> '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
> Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]:
> ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
> Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: error: 'Can't connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
> Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: Check that mysqld is
> running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
> Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]:
>
>
> I created a /var/log/mysql/mysql-bin.index file and gave ownership
> mysql:mysql. I have no idea if this previously existed or not, or, what
> information should be in this file.
>
> Does anyone have sugg estions? I've been reading all morning but haven't
> found anything helpful yet.
>
> Harland
>
>
>
>
>
>
Reply to: