Comment 2 for bug 1134757

Revision history for this message
Ammon Sutherland (ammon-sutherland) wrote : Re: MySQL crash

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