D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Troubleshooting MySQL... failure to start

 

On Sun, 02 Dec 2007 23:35:40 +0000
Neil Stone wrote:

> anything in the log files that would suggest why this is failing to fire 
> up ??
> 
> I had a similar thing recently, turned out to be a crashed table, which 
> mysql fixed..
> 

Last few lines of syslog... the only logfile that seems to contain anything... 
immediately after a "/etc/init.d/mysql start":
----
Dec  2 23:47:55 fileserver mysqld_safe[18960]: started
Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55  InnoDB: Started; log 
sequence number 0 2858885
Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Can't start 
server: Bind on TCP/IP port: Cannot assign requested address
Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Do you already 
have another mysqld server running on port : 3306 ?
Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Aborting
Dec  2 23:47:55 fileserver mysqld[18963]:
Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55  InnoDB: Starting 
shutdown...
Dec  2 23:47:58 fileserver mysqld[18963]: 071202 23:47:58  InnoDB: Shutdown 
completed; log sequence number 0 2858885
Dec  2 23:47:58 fileserver mysqld[18963]: 071202 23:47:58 [Note] /usr/sbin/mysqld: 
Shutdown complete
Dec  2 23:47:58 fileserver mysqld[18963]:
Dec  2 23:47:58 fileserver mysqld_safe[18991]: ended
Dec  2 23:48:10 fileserver /etc/init.d/mysql[19110]: 0 processes alive and 
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec  2 23:48:10 fileserver /etc/init.d/mysql[19110]: /usr/bin/mysqladmin: connect to 
server at 'localhost' failed
Dec  2 23:48:10 fileserver /etc/init.d/mysql[19110]: error: 'Can't connect to local 
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Dec  2 23:48:10 fileserver /etc/init.d/mysql[19110]: Check that mysqld is running 
and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Dec  2 23:48:10 fileserver /etc/init.d/mysql[19110]:
----
I can't figure out why it can't bind to the port.

Grant.

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html