List:General Discussion« Previous MessageNext Message »
From:leo huang Date:March 28 2006 6:17am
Subject:Re: mysql restart error
View as plain text  
hi, Lakshmi

     The mysql process had ended. I get it from both mysql err log and ps
output.

regards,
Leo Huang

2006/3/28, Lakshmi M P <lakshmi_mp@stripped>:
>
> Run   ps -ef | grep mysql and see any mysql process is running and if so
> kill the same and try to start mysql.It may help.
> leo huang wrote:
> > hi,
> >
> > I met the MySQL restart error today.
> >
> > First, I stopped the running mysql server using
> > /usr/local/mysql/bin/mysqladmin -uroot shutdown.
> >
> > After the server shutdowned, I restarted it using
> > /usr/local/mysql/bin/mysqld_safe &.
> >
> > Then, I got this error: [ERROR] Can't start server: Bind on TCP/IP port:
> > Address already in use.
> >
> > There was no other process that was using the port 3306 which mysql
> server
> > use. But there were some mysql connect did not release because the
> shutdown.
> >
> >
> > The error log is followed:
> > 060328  8:20:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
> >
> > 060328  8:20:47  InnoDB: Starting shutdown...
> > 060328  8:20:49  InnoDB: Shutdown completed; log sequence number 120
> > 2134241340
> > 060328  8:20:49 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
> complete
> >
> > 060328 08:20:49  mysqld ended
> >
> > 060328 08:21:15  mysqld started
> > 060328  8:21:15 [ERROR] Can't start server: Bind on TCP/IP port: Address
> > already in use
> > 060328  8:21:15 [ERROR] Do you already have another mysqld server
> running on
> > port: 3306 ?
> > 060328  8:21:15 [ERROR] Aborting
> >
> > 060328  8:21:15 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
> complete
> >
> > 060328 08:21:15  mysqld ended
> >
> > The netstat outputs are followed:
> > $ netstat -al
> > Active Internet connections (including servers)
> > Proto Recv-Q Send-Q  Local Address          Foreign
> Address        (state)
> > tcp4       0      0  bj.3306          s4.9405           FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.5168           FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.25007          FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.9940           FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.3916           FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.15229          FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.6479           FIN_WAIT_2
> > tcp4       0      0  bj.3306          s4.7873           FIN_WAIT_2
> >
> > Our mysql version is 4.1.18. It is running on FreeBSD 4.9-RELEASE.
> >
> > Any comment will be great thankful!
> >
> > Regards,
> > Leo Huang
> >
> >
>
>
> --
> regards,
> Lakshmi.M.P.
> DBA-Support
> Sify Limited.
> Ext:4134
>
> ********** DISCLAIMER **********
> Information contained and transmitted by this E-MAIL is proprietary to
> Sify Limited and is intended for use only by the individual or entity to
> which it is addressed, and may contain information that is privileged,
> confidential or exempt from disclosure under applicable law. If this is a
> forwarded message, the content of this E-MAIL may not have been sent with
> the authority of the Company. If you are not the intended recipient, an
> agent of the intended recipient or a  person responsible for delivering
> the
> information to the named recipient,  you are notified that any use,
> distribution, transmission, printing, copying or dissemination of this
> information in any way or in any manner is strictly prohibited. If you
> have
> received this communication in error, please delete this mail & notify us
> immediately at admin@stripped
>
> www.sify.com - your homepage on the internet for news, sports, finance,
> astrology, movies, entertainment, food, languages etc
>

Thread
mysql restart errorleo huang28 Mar
  • mysql serverprathima rao28 Mar
    • Re: mysql serverEugene Kosov28 Mar
Re: mysql restart errorleo huang28 Mar
Re: mysql restart errorleo huang29 Mar