MySQL Bugs: #48203: mysql > 5.0.76 crashed

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:	None
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

Description:
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.

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?.

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..

I meant you have patched MySQL with external source, we don't have that table in information_schema.

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..

Bug: http://bugs.mysql.com/bug.php?id=53597 marked as duplicate of this one.