[Bug 593552] Re: mysql-server-5.1 deletes tables on start

[Matthias Meier]

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:
"tcexam at 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 "tcexam at 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  mysql	   tcexam	       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.