MySQL Error Occurred

Error Message:
3: Error writing file '/var/mysqltmp/MYBNT89M' (Errcode: 28)

SQL:
SELECT name,deg_id,cat_image from cubecart_brands where status=1 order by rand() LIMIT 8