D&C GLug - Home Page

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

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

 

Grant Sewell wrote:
> 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.
> 

Looks like another process has grabbed that port

netstat -nlp | grep 3360

might give a few clues here

HTH..

Neil

-- 
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