Bug #80940 ibd data files getting removed while truncate & insert on tables.
Submitted: 3 Apr 2016 12:49 Modified: 4 Apr 2016 6:53
Reporter: chandan kumar Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:mysql 5.624 OS:Windows (Server 2008)
Assigned to: CPU Architecture:Any

[3 Apr 2016 12:49] chandan kumar
i am need of help for following scenario:
there is insert(through load data infile) & truncation on tables(25 tables) every 5 seconds, through exe(application build on c++) , the moment when i am going to kill the exe through windows task manager, i can see .ibd files getting removed from data files, i am getting error when i start application (exe) then it tells table doesn't exists.

i checked data files, there i saw particular tables frm file are avail & ibd files got deleted.
as part of debugging i checked error log as well as general log , i am unable to figure out what is going wrong after killing exe through task manager at the time of writing data .

MySQL Version : 5.6.24

OS:Windows Server
Application: C++

How to repeat:
when exe starts it calls stored procedeure which will truncate  & insert data through files.
exe calls happened periodically every 5 sec. 
when i checked processlist..truncate table is in system lock states which never finished.
after some time when we kill exe through task manager & restart exe particular tables does not exit error came.later i come to know ibd files erased only frm files present.
[4 Apr 2016 6:53] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[4 Apr 2016 6:54] MySQL Verification Team
Please refer how truncate operation is handled -http://dev.mysql.com/doc/refman/5.6/en/truncate-table.html