Hard disk space full causes MySQL ibd file to be deleted prompt tablespace is missing for table ' db_rsk/xxx '

Early yesterday, the developer feedback said a test environment tablespace is missing for table ' Db_rsk/xxx ', the weekend just upgraded, specifically let the development back to check, said the script is definitely not the operation of drop table. DataDir under Check, found the frm file in the IBD file did not, Bing down, did not find similar anomalies. So first go back to Mysql.err search, half a day after the Friday afternoon found MySQL appeared an abnormal outage, said that the disk space is insufficient, look at the log the file is damaged, as follows:

2016-11-12 11:31:00 28443 [ERROR] Error writing file '/usr/local/percona-server-5.6.30-rel76.3-linux.x86_64.ssl101/ Data/tmp-demo-slow.log ' (Errno:1-No space left on device)
2016-11-12 11:40:00 7fc9c995c700 InnoDB:Error:Write to file./db_rsk/tb_rsk_compliancecalcservice.ibd failed at offset 0 .
innodb:65536 bytes should has been written, only 0 were written.
Innodb:operating system error number 28.
Innodb:check that your OS and file system support files of this size.
Innodb:check also that the disk was not full or a disk quota exceeded.
Innodb:error number means ' No space left on device '.
Innodb:some Operating system error numbers is described at
Innodb:http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-11-12 11:40:00 28443 [ERROR] innodb:truncate TABLE Db_rsk/tb_rsk_compliancecalcservice failed to create a new tables Pace
2016-11-12 11:40:00 7fc9c995c700 innodb:cannot calculate statistics for table "Db_rsk". " Tb_rsk_compliancecalcservice "because. ibd file is missing. For help, refer to HTTP://DEV.MYSQL.COM/DOC/REFMA
N/5.6/en/innodb-troubleshooting.html

Then the background has been reported IBD file is missing.

Find the problem, the solution is convenient, find a backup, the table is re-imported into the can.

That said, MySQL is much more tolerant than Oracle, and Oracle is often resetlogs when it recovers, and sometimes even resetlogs fails.

Hard disk space full causes MySQL ibd file to be deleted prompt tablespace is missing for table ' db_rsk/xxx '