MySQL error in file: /engine/modules/CinemaApi/inc/shortcodes.php at line 405

Error Number: 1021

The Error returned was:
Disk full (/var/lib/mysql/mysqltmp/#sql_7620_12); waiting for someone to free some space...

SQL query:

select id,title,alt_name,xfields,category,season,epsoide,year,date from dle_post where serie_id='21597' group by season ORDER BY season DESC