[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Incomplete = Won't Fix -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in Ubuntu. https://bugs.launchpad.net/bugs/123427 Title: [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found -- 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Invalid = Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. https://bugs.launchpad.net/bugs/123427 Title: [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found -- 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found
We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to New. Thanks again! ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Incomplete = Invalid -- [apport] package mysql-server-5.0 failed to install/upgrade: host.frm (and other tables from mysql database) not found https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
I am having a comparable problem running squeezecenter on Intrepid Ibex development versions. Some builds of squeezecenter work; others do not, but it appears to depend on whether the purge / re-install of mysql- server and mysql-server-5.0 is successful or not. This is my screen output: Setting up mysql-server-5.0 (5.0.67-0ubuntu6) ... * Stopping MySQL database server mysqld [ OK ] Reloading AppArmor profiles 'HOME' is already defined AppArmor parser error in /etc/apparmor.d/usr.sbin.mysqld-akonadi at line 64: variable @{HOME} was previously declared Profile /etc/apparmor.d/usr.sbin.mysqld-akonadi failed to load Skipping profile /etc/apparmor.d/usr.sbin.mysqld-akonadi.dpkg-new : Warning. 'HOME' is already defined AppArmor parser error in /etc/apparmor.d/usr.sbin.mysqld-akonadi at line 64: variable @{HOME} was previously declared * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables. Setting up mysql-server (5.0.67-0ubuntu6) ... Setting up squeezecenter (7.2.1~23416) ... changed ownership of `/var/lib/squeezecenter/Plugins' to squeezecenter:nogroup Reloading AppArmor profiles 'HOME' is already defined AppArmor parser error in /etc/apparmor.d/usr.sbin.mysqld-akonadi at line 64: variable @{HOME} was previously declared Profile /etc/apparmor.d/usr.sbin.mysqld-akonadi failed to load Skipping profile /etc/apparmor.d/usr.sbin.mysqld-akonadi.dpkg-new : Warning. 'HOME' is already defined AppArmor parser error in /etc/apparmor.d/usr.sbin.mysqld-akonadi at line 64: variable @{HOME} was previously declared update-rc.d: warning: /etc/init.d/squeezecenter missing LSB style header Starting SqueezeCenter Audio Server. Setting up akonadi-server (1.0.0-0ubuntu3) ... Reloading AppArmor profiles 'HOME' is already defined AppArmor parser error in /etc/apparmor.d/usr.sbin.mysqld-akonadi at line 64: variable @{HOME} was previously declared Profile /etc/apparmor.d/usr.sbin.mysqld-akonadi failed to load : Failed. invoke-rc.d: initscript apparmor, action force-reload failed. -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
Today, I found out that the very same root cause also prevents database dump for backups from working: mysqldump --opt mysql mysql.sql mysqldump: Couldn't execute '/*!40103 SET TIME_ZONE='+00:00' */': Table 'mysql.time_zone_name' doesn't exist (1146) After re-installing mysql-server, it works again. Thus, not only the internal user table but also the timezone table is gone. Maybe all other internal tables, too. Again: This makes backups via a database dump impossible. Is this really Importance: Medium? By the way, the only maintainer question for making this incomplete bug complete for almost one year was, Do you have any files in /var/lib/mysql/? Of course I have: There is my database after all! Look, I'm really willing to help with this but please do it seriously. Or, declare that until further notice MySQL Server doesn't work on Ubuntu and that you recommend PostgreSQL. -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
Do you have any files in /var/lib/mysql/ ? ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Incomplete -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
Re: [Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
:: Do you have any files in /var/lib/mysql/ ? I just checked two of my systems and, yes, there are files there. However, I wrestled through this on all of the boxes I hit it. It bit me on at least three systems. It is an extremely awkward process to wrestle through the bug ... typically taking several hours of thrash on each box. But I have mysql working on the other side of the bug insanity on all of the systems. Heitzso -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
This is a plea for pushing up this bug and bug #105457 in your priority list. I know how delicate such request are, and I haven't made something like this before. But after having experienced both bugs on two very different machines (desktop and server edition) in almost pristine setups, and taking into account how many people made follow-ups here, I think I can safely claim that MySQL server is broken on Ubuntu currently. The fact that there are workarounds doesn't help really, since you have to apply the workarounds over and over again. Even worse, bug #105457 occurs silently. Unfortunately, I have almost no in-depth knowledge about MySQL and Bash myself. However, I can easily reproduce the bugs. I'm willing to help hunting down them with short response times. -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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
[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Invalid = New -- [apport] package mysql-server-5.0 failed to install/upgrade: https://bugs.launchpad.net/bugs/123427 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 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