Bug #7382 CREATE ... SELECT causing crash

• Submitted: 17 Dec 2004 16:47
• Modified: 11 Jan 2005 10:06
• Reporter: Jorge del Conde
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Linux (Linux)
• Assigned to: Ramil Kalimullin
• CPU Architecture: Any

[17 Dec 2004 16:47] Jorge del Conde

Description:
MySQL is crashing with the following query:

CREATE TABLE xxxxx DELAY_KEY_WRITE=1 AS
select
max(net_id) as net_id,
aid,
lower(
if(position('/' in referer),
substring(referer,1,position('/' in referer)-1),
if(position(':' in referer), /* for file: */
substring(referer,1,position(':' in referer)),
if(referer='',
substring_index(remote_ip,'.',3),
referer -- may be gibberish
)
)
)
) as ref,
event_type,
event_id IN ('imp','cts_counted') as counted,
'?',
count(*) as cnt
from vcl_20040823
where 1=0 and
((event_type='C' or (event_type='I' and find_in_set('Ws',event_flags))) or find_in_set('Wh',event_flags))
and aid > 0
group by 2, 3, 4, 5, 6 ORDER BY NULL

How to repeat:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=5
max_connections=300
threads_connected=3

thd=0x8792458
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfe1f3b8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8089773
0x82bd198
0x82bb64b
0x82a557e
0x82a5bb1
0x808609e
0x80b0c37
0x8097ef2
0x8096cf3
0x8096417
0x82ba94c
0x82ebeea
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x87d64e0 = CREATE TABLE vclog_day_20040823_hsref_temp DELAY_KEY_WRITE=1 AS
select
max(net_id) as net_id,
aid,
lower(
if(position('/' in referer),
substring(referer,1,position('/' in referer)-1),
if(position(':' in referer), /* for file: */
substring(referer,1,position(':' in referer)),
if(referer='',
substring_index(remote_ip,'.',3), -- better than nothing
referer -- may be gibberish
)
)
)
) as ref,
event_type,
event_id IN ('imp','cts_counted') as counted,
'?',
count(*) as cnt
from vcl_20040823
where 1=0 and
((event_type='C' or (event_type='I' and find_in_set('Ws',event_flags))) or find_in_set('Wh',event_flags))
and aid > 0
group by 2, 3, 4, 5, 6 ORDER BY NULL
thd->thread_id=56