Haitao,
are you using MyISAM or InnoDB tables?
There were only two weeks between the 4.1.6 and 4.1.7 releases, and filesort.cc was not modified at all in that time. The error 'Sort aborted' comes if the sort function fails for some reason.
Can you find out what query is causing these errors?
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
filesort.cc:
err:
if (param.tmp_buffer)
x_free(param.tmp_buffer);
x_free((gptr) sort_keys);
x_free((gptr) buffpek);
close_cached_file(&tempfile);
close_cached_file(&buffpek_pointers);
if (my_b_inited(outfile))
{
if (flush_io_cache(outfile))
error=1;
{
my_off_t save_pos=outfile->pos_in_file;
/* For following reads */
if (reinit_io_cache(outfile,READ_CACHE,0L,0,0))
error=1;
outfile->end_of_file=save_pos;
}
}
if (error)
my_error(ER_FILSORT_ABORT,MYF(ME_ERROR+ME_WAITTANG));
else
statistic_add(filesort_rows, (ulong) records, &LOCK_status);
*examined_rows= param.examined_rows;
#ifdef SKIP_DBUG_IN_FILESORT
DBUG_POP(); /* Ok to DBUG */
#endif
DBUG_PRINT("exit",("records: %ld",records));
DBUG_RETURN(error ? HA_POS_ERROR : records);
} /* filesort */----- Original Message ----- From: "Haitao Jiang" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 03, 2004 11:06 PM
Subject: Upgrade to 4.1.7 caused "Sort Aborted" errors
Hi,
We were using MySQL 4.1.6g without this kind of error, but after we upgrade to 4.1.7, we are having following errors:
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted
What do these mean? How to fix it? Is it a bug? I just wondering if anyone has upgraded to 4.1.7 and has seen these errors.
Thanks so much!
Haitao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
