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]



Reply via email to