MySQL Fatal Error

MySQL Error!
--------------------------

The Error returned was:
Error writing file '/tmp/MYfd=3502' (OS errno 28 - No space left on device)

Error Number:
3

SELECT
prodig_news.id,
prodig_news.title,
prodig_news.anons,
prodig_news.description,
prodig_news.avtor,
prodig_news.url,
prodig_news.date,
prodig_news.view,
prodig_news.photo,
prodig_news.action

FROM `prodig_news` where `action` = '1' ORDER BY `date` desc limit 4

MySQL.v : 8.0.44-0ubuntu0.24.04.2
PHP.v : 5.6.40
Script : /cities-358.html
Refer :