ERROR: Unable to execute query

SELECT * FROM
       `videos` AS `v`,
       `favourite` AS `f` WHERE
        f.favourite_user_id='7671' AND
        f.favourite_video_id=v.video_id
        ORDER BY v.video_add_time DESC
        LIMIT 0, 10

Disk full (/tmp/#sql_a2d_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")