Hi All,
I know there was an earlier post regarding "sort aborted" error after
upgrading to 4.1.14 from 4.0.xxx, I am getting this error too, and it never
occured to me before, I found out the query which is doing this,
SELECT * FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid =
thread.threadid AND deletionlog.type = 'thread')
WHERE forumid = 61 AND
visible = 1 AND
open <> 10 AND
deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 1
mysql error: Error writing file '/tmp/MYt96glR' (Errcode: 28)
mysql error number: 3
The permissions on the /tmp have not changed and are set properly, the user
mysql can create large files in the /tmp directory ( checked after su to
mysql ) , I tried to increase the sort_buffer_size to 1M from 0.5M,
surprisingly everything else works fine, did any of you guys have similar
issues.....
Thanks
Kishore Jalleda
