Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0000000059B3FFF8): =SELECT indizes.idx, indizes2.idx as idx_prev, data.* FROM ( SELECT COUNT(*) AS playcount, COUNT(*) / maxc.m * 100 AS barwidth, COUNT(*) / total.t * 100 AS percentage, CONCAT(a.artist, ' - ', t.name) AS label, previousPlayCount(t.id, null, 1, date('2011-06-01 00:00:00.0'), date('2011-06-30 00:00:00.0')) AS playcount_prev, p.* FROM (SELECT COUNT(*) AS m FROM plays WHERE (DATE(played_on) BETWEEN ifnull(date('2011-06-01 00:00:00.0'),null) AND ifnull(date('2011-06-30 00:00:00.0'),null) OR '2011-06-01 00:00:00.0' IS NULL AND '2011-06-30 00:00:00.0' IS NULL) AND user_id = 1 GROUP BY track_id ORDER BY 1 DESC LIMIT 1) as maxc, (SELECT COUNT(*) AS t FROM plays WHERE (DATE(played_on) BETWEEN ifnull(date('2011-06-01 00:00:00.0'),null) AND ifnull(date('2011-06-30 00:00:00.0'),null) OR '2011-06-01 00:00:00.0' IS NULL AND '2011-06-30 00:00:00.0' IS NULL) AND user_id = 1) as total, artists a INNER JOIN tracks t ON t.a
Connection ID (thread ID): 15
Status: NOT_KILLED
Similar (judging by callstack) crash was reported on Winqual:
000000013F6B1B99 mysqld. exe!JOIN: :optimize( )[sql_select. cc:868] exe!mysql_ derived_ optimize( )[sql_derived. cc:755] exe!mysql_ handle_ single_ derived( )[sql_derived. cc:174] exe!TABLE_ LIST::handle_ derived( )[table. cc:5766] exe!st_ select_ lex::handle_ derived( )[sql_lex. cc:3159] exe!JOIN: :optimize( )[sql_select. cc:878] exe!mysql_ derived_ optimize( )[sql_derived. cc:755] exe!mysql_ handle_ single_ derived( )[sql_derived. cc:174] exe!TABLE_ LIST::handle_ derived( )[table. cc:5766] exe!st_ select_ lex::handle_ derived( )[sql_lex. cc:3159] exe!JOIN: :optimize( )[sql_select. cc:878] exe!mysql_ select( )[sql_select. cc:2877] exe!handle_ select( )[sql_select. cc:283] exe!execute_ sqlcom_ select( )[sql_parse. cc:5087] exe!mysql_ execute_ command( )[sql_parse. cc:2231] exe!mysql_ parse() [sql_parse. cc:6092] exe!dispatch_ command( )[sql_parse. cc:1210] exe!do_ command( )[sql_parse. cc:906] exe!handle_ one_connection( )[sql_connect. cc:1178] exe!pthread_ start() [my_winthread. c:87] exe!_callthread start() [thread. c:261] exe!_threadstar t()[thread. c:241] dll!BaseThreadI nitThunk( ) RtlUserThreadSt art()
000000013F739A55 mysqld.
000000013F73925F mysqld.
000000013F68AF79 mysqld.
000000013F6321F8 mysqld.
000000013F6B1C1A mysqld.
000000013F739A55 mysqld.
000000013F73925F mysqld.
000000013F68AF79 mysqld.
000000013F6321F8 mysqld.
000000013F6B1C1A mysqld.
000000013F6B450A mysqld.
000000013F6B48C6 mysqld.
000000013F5DC2B6 mysqld.
000000013F5DF260 mysqld.
000000013F5E3914 mysqld.
000000013F5E444C mysqld.
000000013F5E4F15 mysqld.
000000013F6105AD mysqld.
000000013F985B85 mysqld.
000000013F95860B mysqld.
000000013F958695 mysqld.
0000000076F2652D kernel32.
000000007705C521 ntdll.dll!
Trying to get some variables. nt(t.id, null, 1, date('2011-06-01 00:00:00.0'), date('2011-06-30 00:00:00.0')) AS playcount_prev, p.* FROM (SELECT COUNT(*) AS m FROM plays WHERE (DATE(played_on) BETWEEN ifnull( date('2011- 06-01 00:00:00.0'),null) AND ifnull( date('2011- 06-30 00:00:00.0'),null) OR '2011-06-01 00:00:00.0' IS NULL AND '2011-06-30 00:00:00.0' IS NULL) AND user_id = 1 GROUP BY track_id ORDER BY 1 DESC LIMIT 1) as maxc, (SELECT COUNT(*) AS t FROM plays WHERE (DATE(played_on) BETWEEN ifnull( date('2011- 06-01 00:00:00.0'),null) AND ifnull( date('2011- 06-30 00:00:00.0'),null) OR '2011-06-01 00:00:00.0' IS NULL AND '2011-06-30 00:00:00.0' IS NULL) AND user_id = 1) as total, artists a INNER JOIN tracks t ON t.a
Some pointers may be invalid and cause the dump to abort.
Query (0000000059B3FFF8): =SELECT indizes.idx, indizes2.idx as idx_prev, data.* FROM ( SELECT COUNT(*) AS playcount, COUNT(*) / maxc.m * 100 AS barwidth, COUNT(*) / total.t * 100 AS percentage, CONCAT(a.artist, ' - ', t.name) AS label, previousPlayCou
Connection ID (thread ID): 15
Status: NOT_KILLED