On Thu, Jun 25, 2009 at 06:15:29PM -0000, Shang Wu wrote:
>
> Using the following query triger the crash on the dapper 6.06.2 machine:
> Result from MySQL 5.0.22 (Ubuntu)
> root@localhost:(none)> SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM mysql.user mu ORDER BY mu.user) a;
> ERROR 2013 (HY000): Lost connection to MySQL server during query
> root@localhost:(none)> SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM mysql.user mu) a;
> ERROR 2006 (HY000): MySQL server has gone away
> No connection. Trying to reconnect...
> Jun 23 16:09:57 cmdb mysqld[21409]: thd->query at 0x8b15f40 = SELECT * FROM (SELECT c.cid,sd.hostname,r.name AS rack,l.name AS location,r.rid,sd.height AS top_height,m.height AS height, IF(m.height<sd.height
> ,sd.height-m.height,'0') AS bottom_height,st.name AS status FROM chassis c LEFT JOIN serverdetail sd ON sd.sid=c.sid LEFT JOIN rack r ON c.rid=r.rid LEFT JOIN model m ON m.mid=c.mid LEFT JOIN status st ON c.
> stid=st.stid LEFT JOIN location l ON c.lid=l.lid WHERE NOT st.name IN('Fased Out') UNION SELECT '0' AS cid,re.type AS hostname,r.name AS rack,l.name AS location,r.rid,re.start AS top_height,re.height AS heig
> ht,IF(re.height<re.start,re.start-re.height,'0') AS bottom_height,'N/A' AS status FROM rackextras re LEFT JOIN rack r ON r.rid=re.rid LEFT JOIN location l ON l.lid=r.lid ORDER BY r.rid,re.bottom_height) a WH
> ERE rid=66 ORDER BY bottom_height
These two queries don't look the same - or the log files don't
correspond. Could specify which query causes the bug? If the latter,
please attach a dump of the sql database to be able to reproduce it.
Hi,
On Thu, Jun 25, 2009 at 06:15:29PM -0000, Shang Wu wrote: (none)> SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM mysql.user mu ORDER BY mu.user) a; (none)> SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM mysql.user mu) a;
>
> Using the following query triger the crash on the dapper 6.06.2 machine:
> Result from MySQL 5.0.22 (Ubuntu)
> root@localhost:
> ERROR 2013 (HY000): Lost connection to MySQL server during query
> root@localhost:
> ERROR 2006 (HY000): MySQL server has gone away
> No connection. Trying to reconnect...
> Jun 23 16:09:57 cmdb mysqld[21409]: thd->query at 0x8b15f40 = SELECT * FROM (SELECT c.cid,sd. hostname, r.name AS rack,l.name AS location, r.rid,sd. height AS top_height,m.height AS height, IF(m.height< sd.height m.height, '0') AS bottom_ height, st.name AS status FROM chassis c LEFT JOIN serverdetail sd ON sd.sid=c.sid LEFT JOIN rack r ON c.rid=r.rid LEFT JOIN model m ON m.mid=c.mid LEFT JOIN status st ON c. r.rid,re. start AS top_height, re.height AS heig height< re.start, re.start- re.height, '0') AS bottom_height,'N/A' AS status FROM rackextras re LEFT JOIN rack r ON r.rid=re.rid LEFT JOIN location l ON l.lid=r.lid ORDER BY r.rid,re. bottom_ height) a WH
> ,sd.height-
> stid=st.stid LEFT JOIN location l ON c.lid=l.lid WHERE NOT st.name IN('Fased Out') UNION SELECT '0' AS cid,re.type AS hostname,r.name AS rack,l.name AS location,
> ht,IF(re.
> ERE rid=66 ORDER BY bottom_height
These two queries don't look the same - or the log files don't
correspond. Could specify which query causes the bug? If the latter,
please attach a dump of the sql database to be able to reproduce it.
status incomplete
-- www.ubuntu. com
Mathias Gug
Ubuntu Developer http://