Bug #11463 WITH ROLLUP kills server

• Submitted: 20 Jun 2005 16:17
• Modified: 20 Jun 2005 18:21
• Reporter: Ben Forta
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.4
• OS: Windows (Win XP)
• CPU Architecture: Any

[20 Jun 2005 16:17] Ben Forta

Description:
The following statement kills the server every time:

SELECT vend_id, COUNT(*) AS num_prods
FROM products
GROUP BY vend_id WITH ROLLUP;

Not much useful in logs:

Database was not shut down normally!
InnoDB: Starting crash recovery.

How to repeat:
I can provide sample table if needed, but is pretty self-explanatory.

[20 Jun 2005 16:35] Heikki Tuuri

This is probably a general MySQL bug, not specific to InnoDB. Changing the category to 'MySQL Server'.
Regards,
Heikki

[20 Jun 2005 17:07] Heikki Tuuri

Ben,

please print

SHOW CREATE TABLE ...

for your table.

If possible, please post the contents of your table.

Regards,

Heikki

[20 Jun 2005 17:20] MySQL Verification Team

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

I was able for to crash the 5.0.4 server, however an5.0.8 server from
BK source not crashes anymore,

[20 Jun 2005 17:22] Ben Forta

Heikki, was about to post the CREATE TABLE and contents, but it looks like this has been reproduced already, so won't bother unless you say you still need it.

[20 Jun 2005 17:37] MySQL Verification Team

Please provide the information requested, for to be safe.
I will test your case too.

Thanks.

[20 Jun 2005 18:11] Ben Forta

File with create and populate SQL uploaded.

[20 Jun 2005 18:21] MySQL Verification Team

Thanks for the feedback, with your test case the server not
crashes anymore.