MySQL ODBC Connector - "Sort Aborted" errors after upgrade to 4.1.14

Author

"Sort Aborted" errors after upgrade to 4.1.14

Kishore Jalleda

2005-09-26, 8:24 pm

------ =_Part_17525_2210163
6.1127772750118
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 =3D
thread.threadid AND deletionlog.type =3D 'thread')

WHERE forumid =3D 61 AND

visible =3D 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 use=
r
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

------ =_Part_17525_2210163
6.1127772750118--

Dan Nelson

2005-09-27, 3:23 am

In the last episode (Sep 26), Kishore Jalleda said:

> 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,
>
> mysql error: Error writing file '/tmp/MYt96glR' (Errcode: 28)

$ perror 28
OS error code 28: No space left on device

You need to either grow /tmp, or set tmpdir to some other volume.

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links