Arch Linux

finarfin

Member

Registered: 2010-03-15

Posts: 24

Mysql doesn't start

Hi,
i'm try to start my local mysql server.
But using

/etc/rc.d/mysql start

doesn't work.
(it happense these days, the server worked until few days ago).

The error in the log file is:

110213 11:55:43  InnoDB: Waiting for the background threads to start
110213 11:55:44 InnoDB: 1.1.5 started; log sequence number 1589349
110213 11:55:44 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking'
110213 11:55:44 [ERROR] Aborting

110213 11:55:44  InnoDB: Starting shutdown...
110213 11:55:44  InnoDB: Shutdown completed; log sequence number 1589349
110213 11:55:44 [Note] /usr/bin/mysqld: Shutdown complete

110213 11:55:44 mysqld_safe mysqld from pid file /var/lib/mysql/azraphel.pid ended

Anyone can help me?
Ivan

toad

Member

From: if only I knew

Registered: 2008-12-22

Posts: 1,775

Website

Re: Mysql doesn't start

Did you do the mysql update a couple of days ago? If so, did you follow the instructions?

---

never trust a toad...
::Grateful ArchDonor::
::Grateful Wikipedia Donor::

wonder

Developer

From: Bucharest, Romania

Registered: 2006-07-05

Posts: 5,941

Website

Re: Mysql doesn't start

take care of pacnew files!

---

Give what you have. To someone, it may be better than you dare to think.

finarfin

Member

Registered: 2010-03-15

Posts: 24

Re: Mysql doesn't start

I did a find / -name *pacnew* and the result is the following:

/etc/cups/printers.conf.pacnew
/etc/locale.gen.pacnew
/etc/group.pacnew
/etc/shadow.pacnew
/etc/php/php.ini.pacnew
/etc/hosts.pacnew
/etc/texmf/web2c/updmap.cfg.pacnew
/etc/ld.so.conf.pacnew
/etc/pacman.conf.pacnew
/etc/fstab.pacnew
/etc/logrotate.d/crond.pacnew
/etc/ntpd.conf.pacnew
/etc/rc.conf.pacnew
/etc/gshadow.pacnew
/etc/httpd/conf/httpd.conf.pacnew
/etc/pacman.d/mirrorlist.pacnew
/etc/cron.daily/man-db.pacnew
/usr/share/texmf-config/web2c/updmap.cfg.pacnew

i did not see anything related to mysql.
I did not do mysql_upgrade.

Spider.007

Member

Registered: 2004-06-20

Posts: 1,175

Re: Mysql doesn't start

Both your problem and a few possible solutions can be found here:

https://bbs.archlinux.org/viewtopic.php?pid=889846

wonder

Developer

From: Bucharest, Romania

Registered: 2006-07-05

Posts: 5,941

Website

Re: Mysql doesn't start

look in /etc/mysql/ it should be a .pacnew because your my.cnf contains '--skip-locking' which is not a valid option anymore. Now is skip-external-locking and is available in a default my.cnf

or you already toke care of that .pacnew but you didn't merge it well enough

Last edited by wonder (2011-02-13 17:57:41)

---

Give what you have. To someone, it may be better than you dare to think.