Bug #48203 mysql > 5.0.76 crashed
Submitted: 21 Oct 2009 10:20 Modified: 21 Oct 2009 11:40
Reporter: Andrey Kolbasenko Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Information schema Severity:S2 (Serious)
Version:5.0.82,5.0.84,5.0.86 OS:Linux
Assigned to: CPU Architecture:Any

[21 Oct 2009 10:20] Andrey Kolbasenko
I have a mysql 5.0.86 running in Gentoo Linux.
If I set "skip-innodb" option in my.cnf config file and issue the following query against INFORMATION_SCHEMA, mysql crashed:

mysql> SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_POOL_CONTENT`;
ERROR 2013 (HY000): Lost connection to MySQL server during query              

When innodb enabled in my.cnf all worked whithout crash.

How to repeat:
I reproduced this crash in all 5.0.x version after 5.0.76.
[21 Oct 2009 10:35] MySQL Verification Team
Thank you for the bug report. I couldn't repeat with latest release source:

mysql> SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_POOL_CONTENT`;
ERROR 1109 (42S02): Unknown table 'INNODB_BUFFER_POOL_CONTENT' in information_schema

Looks like you use a server built with different source?.
[21 Oct 2009 10:43] Andrey Kolbasenko
I so sorry.. 5.0.84 is my version: 

*  dev-db/mysql                   
      Latest version available: 5.0.84-r1
      Latest version installed: 5.0.84-r1
      Size of files: 35,972 kB           
      Homepage:      http://www.mysql.com/
      Description:   A fast, multi-threaded, multi-user SQL database server.
      License:       GPL-2                                                  

5.0.86 I'm not tested.. Sorry again..
[21 Oct 2009 10:48] MySQL Verification Team
I meant you have patched MySQL with external source, we don't have that table in information_schema.
[21 Oct 2009 11:40] Andrey Kolbasenko
Thanks! You right, this is a Gentoo specific bug. This table added from "all_innodb_show_bp-persona-x.x.x" patches from mysql-extras package..
[12 May 2010 13:20] MySQL Verification Team
Bug: http://bugs.mysql.com/bug.php?id=53597 marked as duplicate of this one.