Bug #74028 Random table gets deleted after multiple TUNCATE table operations.
Submitted: 23 Sep 2014 6:05 Modified: 9 Oct 2014 16:05
Reporter: A I Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:xampp latest version on localhost OS:Windows (7 ultimate 64b)
Assigned to: CPU Architecture:Any

[23 Sep 2014 6:05] A I
Description:
I have a dozen of tables that get emptied with TRUNCATE table every 20 seconds or so.

Every couple hours a random table gets deleted and my script stops.

Whats interesting, is that the table gets deleted in main view, but I still can see it in the sidebar on the left. 

When I try to recreate the deleted table, I get "no such table" mysql error. The way I managed to recreate it is by copying table ".frm" file from identical table, it would allow me to drop the old one via sql and recreate it again.

How to repeat:
Empty dozens of tables with TRUNCATE every 20 seconds for many hours.
[9 Oct 2014 16:05] MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.