Arch Linux

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

[SOLVED] Latest MySQL update, will not start.

Not sure where to look for some error reports. Since all my logs are empty.

I also did a yaourt -Rns mysql with no luck. This did not work either.

Could someone help me? This happend last time to. Not sure what I did to make it work.

Birger

P.S.: Solution will be added to the wiki.

Ed1t: Marked as solved.

Last edited by MindTooth (2009-06-24 14:50:51)

foutrelis

Developer

From: Athens, Greece

Registered: 2008-07-28

Posts: 705

Website

Re: [SOLVED] Latest MySQL update, will not start.

Try running it manually and see why it exits:

# mysqld_safe --datadir=/var/lib/mysql

ralvez

Member

From: Canada

Registered: 2005-12-06

Posts: 1,718

Website

Re: [SOLVED] Latest MySQL update, will not start.

try tail -f /var/log/everything.log

R.

tikis

Member

Registered: 2009-06-16

Posts: 5

Re: [SOLVED] Latest MySQL update, will not start.

Look for /var/lib/mysql/yourhostname.err
Is it there?

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

Re: [SOLVED] Latest MySQL update, will not start.

Try running it manually and see why it exits:

# mysqld_safe --datadir=/var/lib/mysql

I can start in safemode.

Look for /var/lib/mysql/yourhostname.err
Is it there?

It is there, and this is what I get in safemode:

090624 08:37:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090624  8:37:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090624  8:37:07  InnoDB: Started; log sequence number 0 43685
090624  8:37:07 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090624  8:37:07 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50068, now running 50135. Please use mysql_upgrade to fix this error.
090624  8:37:07 [ERROR] mysql.user has no `Event_priv` column at position 29
090624  8:37:07 [ERROR] Cannot open mysql.event
090624  8:37:07 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090624  8:37:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.35'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

I am unable to start in mysqld when not using safemode. This is then outputed:

090624  8:40:58  InnoDB: Starting shutdown...
090624  8:40:59  InnoDB: Shutdown completed; log sequence number 0 43685
090624  8:40:59 [Warning] Forcing shutdown of 2 plugins
090624  8:40:59 [Note] /usr/sbin/mysqld: Shutdown complete

Birger

tikis

Member

Registered: 2009-06-16

Posts: 5

Re: [SOLVED] Latest MySQL update, will not start.

I would say it still looks like a privilege problem, but my guess is, that it was working well before the update. So it must be something else. More and more people gets some problem with this update. Like here:
http://bbs.archlinux.org/viewtopic.php?id=74224
http://bbs.archlinux.org/viewtopic.php?id=74295

If you have important data in the mysql database you should try to downgrade to 5.1.34

If you don't have any, then you can try:

rm -rf /var/lib/mysql/*
mysql_install_db --user mysql
/etc/rc.d/mysqld start

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

Re: [SOLVED] Latest MySQL update, will not start.

Ran the chmod line in the Wiki. But no help.

Have cleared my cache, is there a place where I can get the previous package?

Birger

Ed1t: Yes. I have some importan databases. I could try a backup, and remove them.

Ed2t: For some wicked reason. It worked now.

Last edited by MindTooth (2009-06-24 09:00:43)

ralvez

Member

From: Canada

Registered: 2005-12-06

Posts: 1,718

Website

Re: [SOLVED] Latest MySQL update, will not start.

Run mysql_upgrade as root like this: mysql_upgrade -u root -p
Then try /etc/rc.d/mysqld start

R.

MindTooth

Member

From: Norway

Registered: 2008-11-11

Posts: 331

Re: [SOLVED] Latest MySQL update, will not start.

I did, and added it to the wiki. Not sure however it is what this that fixed. Because I had MySQL running before I ran the command the first time.

Birger

ralvez

Member

From: Canada

Registered: 2005-12-06

Posts: 1,718

Website

Re: [SOLVED] Latest MySQL update, will not start.

I can guarantee it was what fixed the problem... because I had a similar problem and that did it

R