MYSQL QUERY ERROR

Query: SELECT p.*, RAND() as rnd FROM engio_poll p LEFT JOIN engio_poll_country pc ON pc.info_id = p.id WHERE p.view = "1" AND p.date_close > "2026-04-27" ORDER BY rnd
Error: Out of resources when opening file '/tmp/#sql_4bab_0.MAI' (Errcode: 24)