Mysqld stopped with the error message "[ERROR] /usr/libexec/mysqld: Sort aborted"
Issue
- Mysql stopped running with the following in
var/log/mysqld.log
130328 7:59:59 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:01 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:01 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:01 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:02 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:02 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:02 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:05 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:06 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:00:06 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:02:26 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 8:02:39 InnoDB: ERROR: the age of the last checkpoint is 9433825,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
130328 8:15:11 [ERROR] /usr/libexec/mysqld: Sort aborted
130328 08:43:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130328 8:43:03 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130328 8:43:03 InnoDB: Started; log sequence number 20 3409599255
130328 8:43:03 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem.
130328 8:43:03 [Note] Event Scheduler: Loaded 0 events
130328 8:43:03 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.52' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130328 8:45:00 [Note] /usr/libexec/mysqld: Normal shutdown
130328 8:45:00 [Note] Event Scheduler: Purging the queue. 0 events
130328 8:45:02 InnoDB: Starting shutdown...
130328 8:45:03 InnoDB: Shutdown completed; log sequence number 20 3409599255
130328 8:45:03 [Note] /usr/libexec/mysqld: Shutdown complete
130328 08:45:03 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- running as a HA service on Red Hat Cluster Suite
Environment
- Red Hat Enterprise Linux 6.1
- mysql-server-5.1.52-1.el6_0.1.x86_64
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.