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 <[EMAIL PROTECTED]>:
>
> 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 [EMAIL PROTECTED]
>
> www.sify.com - your homepage on the internet for news, sports, finance,
> astrology, movies, entertainment, food, languages etc
>
