[Bug 582970] [NEW] mysql-server won't start after update

[Robert]

Public bug reported:

I installed the update (5.1.41-3ubuntu12.1) today. dpkg crashed. I reran
dpkg-reconfigure mysql-server to fix the broken package, but the daemon
will not start.

status mysql reports "mysql start/post-start, (post-start) process 1194"
but there is nothing in /var/run/mysqld.

I assume Bug #551130 is related. But the important issue is that the
server is just not starting.

When I "su mysql" and run mysqld I get the following:

100519 18:35:25 [Warning] Can't create test file /srv/var/lib/mysql/dwaible.lower-test
100519 18:35:25 [Warning] Can't create test file /srv/var/lib/mysql/dwaible.lower-test
100519 18:35:25 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100519 18:35:25 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100519 18:35:25  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

Permissions in that directory are file. I can create test files as user
"mysql" there.

If I run mysql_upgrade, I get errors:

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' 
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: mysql-server 5.1.41-3ubuntu12.1
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic x86_64
Architecture: amd64
Date: Wed May 19 18:19:37 2010
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['pandaw', 'debian-5.1.flag', 'ibdata1', 'ib_logfile1', 'mysql_upgrade_info', 'dwaible.err', 'ib_logfile0', 'mysql']
PackageArchitecture: all
ProcEnviron:
 LANG=en_GB.utf8
 SHELL=/bin/bash
SourcePackage: mysql-dfsg-5.1

** Affects: mysql-dfsg-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug lucid

-- 
mysql-server won't start after update
https://bugs.launchpad.net/bugs/582970
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.