This bug has irritated me big time. Upon further observation, I determined that the error I got was the result of temporary table getting very large.
Please check the disk space (command: df -h) and make sure you have enough space.
This resolves the problem!!
