Yes, that is exactly what I am experiencing. The result comes back, and
the server dies....
So it's probably a known bug....
It s via mysqlcc. With command line it works fine in fact (good catch).
I'm not familiar with the JDBC driver/mysqlcc. Does it (the JDBC) also use
mysqlcc ? Or can I run safely my queries with the JDBC driver ? (or shall
I test too:)
Thanks,
Irwin Boutboul
Advanced Internet Technology
150 Kettletown Road, B2-N06
Southbury, CT 06488
Phone: 203-486-5614
"Little, Tim" <tlittle@stripped>
09/12/2003 01:58 PM
To
Irwin Boutboul/Watson/IBM@IBMUS
cc
Subject
RE: SQL query crashes MySQL
Does that crash the server in command-line mode (via mysql) or just in
MySQLcc?
I've seen similar crashes (actual full server crashes) in similar queries
but only under mysqlcc. It seems that the results come back but the
server
dies just after that point. Is this what you are experiencing?
Tim...
-----Original Message-----
From: Irwin Boutboul [mailto:boutboul@stripped]
Sent: Friday, September 12, 2003 12:03 PM
To: mysql@stripped
Subject: SQL query crashes MySQL
Here it is:
select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select
avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ?
and ( bytesdownloaded > 500000 or timeduration > 3000 ) group by id order
by starttime desc limit 20) as selection;
This complex (?) query makes mySQL crash everytime.
If I replace the inner 'select avg(bandwidth)' by 'select *' it works
fine.
I am pretty sure this is not related to my table. You could create any
table and try a query like that on it... If you can t reproduce the bug,
I can give the details of my table.
Shall I file a bug for this one ?
(MySQL 4.1)
Irwin Boutboul
Advanced Internet Technology
150 Kettletown Road, B2-N06
Southbury, CT 06488
Phone: 203-486-5614
