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.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
