[Bug 792607] Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Dan thanks for the feedback! Its good to hear you were able to resurrect the system. I agree that even though there probably is a bug somewhere, isolating it will be terribly difficult. Closing as Invalid. ** Changed in: mysql-5.1 (Ubuntu) Status: Incomplete => Invalid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/792607 Title: Plugin 'InnoDB' registration as a STORAGE ENGINE failed. -- 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 792607] Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
I did do all the upgrades in sequence over the years. This is the first time I've really tried to use the innodb based stuff (mythweb and mythweather), so it could have gotten messed up anywhere along the way. Checking my backups: the timestamp on the files indicates they were last written when I was running 10.10, but I'm also seeing the same error messages during that time. I tried the first couple steps you recommended, but they didn't really work right. # mysqldump --defaults-extra-file=/etc/mysql/debian.cnf --all-databases > ~/all_tables.sql mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES It sounds like it's finding InnoDB stuff, but can't read it properly. # mysql --defaults-extra-file=/etc/mysql/debian.cnf -e "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB'" The select returns nothing because that engine never loaded. It doesn't necessarily mean there isn't anything there. Removing the ib* files (after backing them up) did allow InnoDB to load. I also had to remove /var/lib/mysql/mythconverg/weather* to keep it from complaining about old/bad .frm files. re-installing the mythweb plugin did re-created the tables. mythweb now works for me. I think this means that the bug is probably somewhere in migration (possibly in a previous version), but (hopefully) isn't reproducible. Thank you so much for the hand holding. You can close this bug as not reproducible. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/792607 Title: Plugin 'InnoDB' registration as a STORAGE ENGINE failed. -- 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 792607] Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Hi Dan, thanks for taking the time to file this bug report. It does in fact look like your innodb table space is hosed in some way, though there are ways to fix this. First, backup all your tables: sudo mysqldump --defaults-extra-file=/etc/mysql/debian.cnf --all- databases > all_tables.sql Second, check to see if you have any data in InnoDB tables already: mysql --defaults-extra-file=/etc/mysql/debian.cnf -e "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB'" If you have no tables listed, then you can safely do this: # Remove innodb database files sudo service mysql stop rm /var/lib/mysql/ibdata /var/lib/mysql/ib_logfile* sudo service mysql start That should re-create a new innodb table space. If you do have InnoDB tables already, you may have a lot of data problems, and thats not something we can solve in a bug report unfortunately. It does make me wonder if there's a bug upgrading from 10.10 to 11.04. Did you upgrade directly from 9.04, or did you go through the steps (9.04 -> 9.10 -> 10.04 -> 10.10 -> 11.04) ? We do not generally support upgrades directly from one older stable release to a new one... so this if thats the case, we probably won't be able to fix that. Marking Incomplete pending response from Dan. ** Changed in: mysql-5.1 (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/792607 Title: Plugin 'InnoDB' registration as a STORAGE ENGINE failed. -- 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 792607] Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
-- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/792607 Title: Plugin 'InnoDB' registration as a STORAGE ENGINE failed. -- 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