Mysql server start and stop as soon

[Quikdav]

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 😉

[chirpa]

After it fails to start, is there any mention of mysql in /var/log/messages ?

[Quikdav]

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

[Quikdav]

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

[mdgm-ntgr]

Perhaps try rebooting the NAS?

[Quikdav]

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