A fatal MySQL error occured.

Query:
SELECT SQL_CALC_FOUND_ROWS l.* FROM pmd_v1_listings l INNER JOIN pmd_v1_listings_categories lc ON l.id=lc.list_id WHERE lc.cat_id IN (272,273,274,275,276) AND l.status='active' GROUP BY l.id ORDER BY priority DESC,title LIMIT 20,20

Error:
(1) Can't create/write to file '/tmp/#sql_5332_0.MYI' (Errcode: 122)