PDA

View Full Version : Weird mysql error after trying to install MyDNS :/


pne
24th October 2007, 18:21
This is my problem;
I tried to install MyDNS, during the install process something fucked up mysql so not it wont start, stop or work! If you kill it manually (killall -9 mysqld) It just restarts by itself :|
Anyone got a solution?

This is what I get when I try to re-install mysql-server
apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
mysql-server
0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
1 not fully installed or removed.
Need to get 0B/47.5kB of archives.
After unpacking 86.0kB of additional disk space will be used.
(Reading database ... 27768 files and directories currently installed.)
Unpacking mysql-server (from .../mysql-server_5.0.38-0ubuntu1_all.deb) ...
* Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 1
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing /var/cache/apt/archives/mysql-server_5.0.38-0ubuntu1_all.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server_5.0.38-0ubuntu1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

falko
25th October 2007, 17:54
MySQL seems to be running already. What's the output of ps aux|grep -i mysql?

pne
26th October 2007, 14:33
[QUOTE=falko]MySQL seems to be running already. What's the output of

ps aux|grep -i mysql
mysql 20314 0.0 3.4 51660 4340 ? Sl Oct24 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock --skip-grant-tables --skip-networking

root 20315 0.0 0.5 2800 636 ? S Oct24 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld

root 23146 0.0 0.5 3756 632 ? S Aug15 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --datadir=/var/lib/mysql --skip-grant-tables --skip-networking
(If you kill the Mysqld process it just restarts anyway :s, Is there some sort of auto restarter?)

Cheers.

falko
27th October 2007, 17:16
(If you kill the Mysqld process it just restarts anyway :s, Is there some sort of auto restarter?)

Maybe a cron job? Or do you use monit (see http://www.howtoforge.com/server_monitoring_with_munin_monit_debian_etch_p2 )?

pne
28th October 2007, 15:35
Maybe a cron job? Or do you use monit (see http://www.howtoforge.com/server_monitoring_with_munin_monit_debian_etch_p2 )?

I don't have monit, so it have to be a cron problaby =/
But it's not listed in the crontab.

What could it be? :|

falko
29th October 2007, 16:44
Please check the scripts in the /etc/cron.* directories.