[Bug 593552] Re: mysql-server-5.1 deletes tables on start
[Expired for mysql-dfsg-5.1 (Ubuntu) because there has been no activity for 60 days.] ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Incomplete = Expired -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. https://bugs.launchpad.net/bugs/593552 Title: mysql-server-5.1 deletes tables on start -- 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 593552] Re: mysql-server-5.1 deletes tables on start
Thank you for taking the time to report this bug and helping to make Ubuntu better. Unfortunately, we can't fix it because your description didn't include enough information. You may find it helpful to read How to report bugs effectively http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then provide a more complete description of the problem. We have instructions on debugging some types of problems at http://wiki.ubuntu.com/DebuggingProcedures. At a minimum, we need: 1. the specific steps or actions you took that caused you to encounter the problem, 2. the behavior you expected, and 3. the behavior you actually encountered (in as much detail as possible). Thanks! When reporting bugs in the future please use apport, either via the appropriate application's Help - Report a Problem menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs. ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided = Low ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New = Incomplete -- mysql-server-5.1 deletes tables on start https://bugs.launchpad.net/bugs/593552 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
[Bug 593552] Re: mysql-server-5.1 deletes tables on start
Possibly the deleting of all the mysql tables occurs because I have an invalid table 'tcexam9.bak' in the mysql data directory, which i copied long ago manually for testing reasons. I will verify this in the next mainenance window of my server :) Find attached the syslog of the mysql start before and after the mysql- server upgrade. ** Attachment added: syslog-before-upgrade http://launchpadlibrarian.net/50316458/syslog-before-upgrade -- mysql-server-5.1 deletes tables on start https://bugs.launchpad.net/bugs/593552 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
[Bug 593552] Re: mysql-server-5.1 deletes tables on start
** Attachment added: dpkg.log http://launchpadlibrarian.net/50316505/dpkg.log -- mysql-server-5.1 deletes tables on start https://bugs.launchpad.net/bugs/593552 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
[Bug 593552] Re: mysql-server-5.1 deletes tables on start
As following scenario shows, the problem occures really because of a oviously invalid table which I backuped inside the mysql data directory: Test1) Before starting the problematic mysql server security release (5.1.41-3ubuntu12.3) by start mysql the mysql data directory shows following entries: debian-5.0.flag ibdata1 ib_logfile0 ib_logfile1 mysql mysql_upgrade_info tcexam tcexam9 tcexam.bak1 zm Mention the entry tcexam.bak1 which is an exact copy of the tcexam table directory. (identical according a diff -r and also the access rights are same. Possibly I copied the table manually some years ago by a cp -a tcexam tcexam.bak1 - I didn't use these two tables since then because I'm working now on another table tcexam9). After starting the mysql-server (release 5.1.41-3ubuntu12.3) the only directory entry left is: tce...@002ebak1 So a l l t a b l e s d i s a p e a r e d - including table mysql and all other tabels! Test2) After restoring the directory from the backup and deleting tcexam.bak1 manually before starting the mysql-server, all is working fine. Test3) After that I did another test with the now working setup: I stopped the mysyl-server, copied tcexam now manually by a cp -a tcexam tcexam.bak1 and started mysql again - but now the problem doesn't happen again! (But of course I can reproduce it by resoring the original directory content.) As I mentioned, this happens only with mysql-server-5.1 5.1.41-3ubuntu12.3, not with older releases! At last I looked into the subdirectory tce...@002ebak1 and what surprise all the tables are there: db.opt ibdata1 ib_logfile1 mysql_upgrade_info tcexam9 zm debian-5.0.flag ib_logfile0 mysqltcexam tcexam.bak1 Strange isn't it? Regards Matthias -- mysql-server-5.1 deletes tables on start https://bugs.launchpad.net/bugs/593552 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