Quartz JOB performs an abnormal retry

the records of Quartz throwing JobExecuteExcetption, database job and trigger disappear during the execution of job. How to make job execute again

Jun.06,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b6e3-2badd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b6e3-2badd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?