Out of resources when opening file '/tmp/#sql_10a4_100.MYD' (Errcode: 24)

SELECT articles.*, authors.ALIAS_ID FROM ecom.articles LEFT JOIN ecom.authors ON articles.authorid = authors.unid WHERE type = 'Llewellyn Journal' AND date <= '2016-08-27' ORDER by date DESC limit 10