executing the following sql, in a while loop will result in the non-execution indicated in the figure. Sql uses the version field to implement optimistic locks.
@Transactional(rollbackFor = Exception.class)
...
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-1e99601-1752.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-1e99601-1752.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Need Help?