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