Mysqld stopped with the error message "[ERROR] /usr/libexec/mysqld: Sort aborted"

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content