NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Mysql server start and stop as soon
Hi all
I have a problem to start the mysqlserver !!
I have installed FW 4.1.12 and when I try to start it, it seems to start a few second and then stop. Here is the command I use :
start-stop-daemon -S -q -b -x /usr/sbin/mysqld -- --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/run/mysqld/mysqld.sock
This command worked before the upgrade from FW 4.1.10
Since, I had a problem with my Os partition that was full. So I cleaned it to be able to install the new firmware and since, I can't restart mysql server with 4.1.12 ?
All the paths in the command are valid.
I record many data on my database and since 3 days, it is stopped :-(
Any idea ?
Thanks and regards
PS : to restore the truth, it's mdgm that help me to clean my OS partition and install my new FW ;-)
I have a problem to start the mysqlserver !!
I have installed FW 4.1.12 and when I try to start it, it seems to start a few second and then stop. Here is the command I use :
start-stop-daemon -S -q -b -x /usr/sbin/mysqld -- --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/run/mysqld/mysqld.sock
This command worked before the upgrade from FW 4.1.10
Since, I had a problem with my Os partition that was full. So I cleaned it to be able to install the new firmware and since, I can't restart mysql server with 4.1.12 ?
All the paths in the command are valid.
I record many data on my database and since 3 days, it is stopped :-(
Any idea ?
Thanks and regards
PS : to restore the truth, it's mdgm that help me to clean my OS partition and install my new FW ;-)
5 Replies
Replies have been turned off for this discussion
- After it fails to start, is there any mention of mysql in /var/log/messages ?
- Nothing in /var/log/messages !!
I looked for a mysql.log but it seems it doesn't exist !!!
I'm looking for a log where I can have information regarding mysql !!! - ok I found some interesting information.. I tried running the server with option "--log-error=/c/mysql.log" and here is the result :
/usr/sbin/mysqld, Version: 5.0.24a-Debian_3.infrant1-log. started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
130930 23:11:31 InnoDB: Started; log sequence number 0 126948287
130930 23:11:31 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130930 23:11:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130930 23:11:31 [ERROR] Aborting
130930 23:11:31 InnoDB: Starting shutdown...
130930 23:11:33 InnoDB: Shutdown completed; log sequence number 0 126948287
130930 23:11:33 [Note] /usr/sbin/mysqld: Shutdown complete
So I checked what happen with port 3306 with "netstat -a -t -n" and I found this line :
tcp 0 0 127.0.0.1:3306 127.0.0.1:3306 ESTABLISHED
I tried to kill an eventualy server with "start-stop-daemon --stop -x /usr/sbin/mysqld" and I had this result : "No /usr/sbin/mysqld found running; none killed."
So I wonder who is using this port !!
Thanks for your help
David - Perhaps try rebooting the NAS?
mdgm wrote: Perhaps try rebooting the NAS?
So I restarted the NAS.
I checked what's happen with port 3306 with "netstat -a -t -n" and I found the same line :
tcp 0 0 127.0.0.1:3306 127.0.0.1:3306 ESTABLISHED
but I ran a "start-stop-daemon --stop -x /usr/sbin/mysqld" without any message as if it works :-)
Then I restart again to run the server and it works....
Now with netstat, here is what I have :
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:3306 127.0.0.1:4945 TIME_WAIT
tcp 0 0 127.0.0.1:4947 127.0.0.1:3306 TIME_WAIT
I don't understand what's happened... I will try tomorrow to restart the procedure
Regards
David
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
