Bug #98597 alter table get failed sometimes
Submitted: 14 Feb 2020 10:32 Modified: 14 Feb 2020 21:53
Reporter: wu winnie Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any

[14 Feb 2020 10:32] wu winnie
Actually it's not a MySQL bug, but I would like to find a best solution.

we found the alter table operation failed sometimes with error message: Error on rename of '.\\hub_information_schema\\#sql-1fe0_9.frm' to '.\\hub_information_schema\\hub_groups.frm' . 
the root cause is our anti-virus software is doing real-time scan, and lock the temp frm table.
now my question is there some good solution to resolve this issue?  
e.g check the table schema to decide if it needs to do alter operation.
but it looks huge work for us and will make sql looks ugly.
so I am here, could you give me some advice to avoid this issue?

How to repeat:
it happens occasionally
[14 Feb 2020 21:53] MySQL Verification Team
You can exclude all MySQL data + temporary files from AntiVirus scans.