[DRILL-1791] CTAS fails due to issue with stale file handles

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Storage - Writer
• Labels: hard_to_verify
• Assignee: Steven Phillips
• Reporter: Abhishek Girish
• Created: 01/Dec/14 06:52
• Updated: 22/Aug/16 03:22
• Resolved: 25/Feb/15 02:30

Description

CTAS statement failed with RuntimeException and logs indicate it is due to invalid / stale file handle.

Previous CTAS statement was incomplete due to a different issue and had to be redone. The existing files that were created from the previous CTAS statement were deleted via the hadoop fs command.

On restarting CTAS, after about a few minutes of delay, this issue was seen.

A snippet of the drillbit.log file has been attached (truncated due to it's large size)