A fatal MySQL error occured.

Query:
SELECT id, description_short, short_description_size, title, friendly_url, date, listing_address1, listing_address2, listing_zip, location_id, location_text_1, location_text_2, location_text_3, phone FROM pmd_v1_listings WHERE status = 'active' AND featured = 1 GROUP BY pmd_v1_listings.id ORDER by RAND(), pmd_v1_listings.priority LIMIT 0, 5

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