Each time there is a select in the logs prior to the crash, sorry to not include it before as it looked like the timestamp was wrong but that was for another line.
130227 11:30:29 [ERROR] /usr/sbin/mysqld: Sort aborted
len 224; hex 38b473d4be2a000063c0986bb62a00006012d3efab2a0000446174654164646564203d206e6f77280300000009095748030000000000000001000000000000000000000000000000000000
000000000000000000000000002f636f72706f726174652f69332f7368617264696e672f63616c6c6465746169010000000000000083445107000000008ee6b2d9be2a000002000000000000000100000000
000000405d36b3ab2a0000030000000000000060e1117700000000020000000000000048bb4dddbe2a00002d63726f6e31303188e6b2d9be2a00001000000000000000; asc 8 s * c k * ` *
DateAdded = now( WH /corp/i/sharding/calldetai DQ * @]6 * ` w
H M * -cron01 * ;
TRANSACTION 235B5EB68, ACTIVE 16 sec, process no 6462, OS thread id 1385572672 fetching rows, thread declared inside InnoDB 968
mysql tables in use 3, locked 0
MySQL thread id 18862, query id 13801933 10.24.160.250 rv-marketing Sending data
Select C.`CallDir`, Count(Distinct C.ContactID) as Contacts
From
Corp.`Call` C
Where C.`CallDate` = '2013-02-26'
and C.`CallDir`='Inbound'
Group by
C.`CallDir`
LIMIT 0, 1000
Each time there is a select in the logs prior to the crash, sorry to not include it before as it looked like the timestamp was wrong but that was for another line.
130227 11:30:29 [ERROR] /usr/sbin/mysqld: Sort aborted 063c0986bb62a00 006012d3efab2a0 000446174654164 646564203d206e6 f77280300000009 095748030000000 000000001000000 000000000000000 000000000000000 000000000002f63 6f72706f7261746 52f69332f736861 7264696e672f636 16c6c6465746169 010000000000000 083445107000000 008ee6b2d9be2a0 000020000000000 00000100000000 b2a000003000000 0000000060e1117 700000000020000 000000000048bb4 dddbe2a00002d63 726f6e31303188e 6b2d9be2a000010 00000000000000; asc 8 s * c k * ` * sharding/ calldetai DQ * @]6 * ` w
C.`CallDir` ,
Count( Distinct C.ContactID) as Contacts
C.`CallDate` = '2013-02-26' ='Inbound'
len 224; hex 38b473d4be2a000
000000000000000
000000405d36b3a
DateAdded = now( WH /corp/i/
H M * -cron01 * ;
TRANSACTION 235B5EB68, ACTIVE 16 sec, process no 6462, OS thread id 1385572672 fetching rows, thread declared inside InnoDB 968
mysql tables in use 3, locked 0
MySQL thread id 18862, query id 13801933 10.24.160.250 rv-marketing Sending data
Select
From
Corp.`Call` C
Where
and C.`CallDir`
Group by
C.`CallDir`
LIMIT 0, 1000