Comment 2 for bug 819716

Revision history for this message
Vladislav Vaintroub (wlad-montyprogram) wrote :

Similar (judging by callstack) crash was reported on Winqual:

000000013F6B1B99 mysqld.exe!JOIN::optimize()[sql_select.cc:868]
000000013F739A55 mysqld.exe!mysql_derived_optimize()[sql_derived.cc:755]
000000013F73925F mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:174]
000000013F68AF79 mysqld.exe!TABLE_LIST::handle_derived()[table.cc:5766]
000000013F6321F8 mysqld.exe!st_select_lex::handle_derived()[sql_lex.cc:3159]
000000013F6B1C1A mysqld.exe!JOIN::optimize()[sql_select.cc:878]
000000013F739A55 mysqld.exe!mysql_derived_optimize()[sql_derived.cc:755]
000000013F73925F mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:174]
000000013F68AF79 mysqld.exe!TABLE_LIST::handle_derived()[table.cc:5766]
000000013F6321F8 mysqld.exe!st_select_lex::handle_derived()[sql_lex.cc:3159]
000000013F6B1C1A mysqld.exe!JOIN::optimize()[sql_select.cc:878]
000000013F6B450A mysqld.exe!mysql_select()[sql_select.cc:2877]
000000013F6B48C6 mysqld.exe!handle_select()[sql_select.cc:283]
000000013F5DC2B6 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5087]
000000013F5DF260 mysqld.exe!mysql_execute_command()[sql_parse.cc:2231]
000000013F5E3914 mysqld.exe!mysql_parse()[sql_parse.cc:6092]
000000013F5E444C mysqld.exe!dispatch_command()[sql_parse.cc:1210]
000000013F5E4F15 mysqld.exe!do_command()[sql_parse.cc:906]
000000013F6105AD mysqld.exe!handle_one_connection()[sql_connect.cc:1178]
000000013F985B85 mysqld.exe!pthread_start()[my_winthread.c:87]
000000013F95860B mysqld.exe!_callthreadstart()[thread.c:261]
000000013F958695 mysqld.exe!_threadstart()[thread.c:241]
0000000076F2652D kernel32.dll!BaseThreadInitThunk()
000000007705C521 ntdll.dll!RtlUserThreadStart()

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