MySQL Bugs: #26285: Selecting information

Bug #26285	Selecting information_schema crahes server
Submitted:	12 Feb 2007 12:37	Modified:	19 Mar 2007 17:03
Reporter:	Thomas Brunnthaler	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S1 (Critical)
Version:	5.1.15 Beta	OS:	Windows (Windows 2003)
Assigned to:	Sergei Glukhov	CPU Architecture:	Any

Description:
Selecting information_schema with phpMyAdmin 2.11.0-dev crashes mysqld-nt.

How to repeat:
try to view the databases in information_schema

Thank you for the report.

But there wasn't 5.2.1 version. Please indicate accurate version of MySQL server you use. Also provide output of SHOW GRANTS FOR user you connect to phpMyAdmin

You'r right - sorry; Server Version: 5.1.15-beta-community-nt
with root rights.

Thank you for the report.

Verified as described using last development sources and phpMyAdmin - 2.10.0-rc1.

Mac version and Windows 5.1.11 version are not affected.

Problem happens only if one tries to access to I_S using C API application. From command line client all work fine.

The patch can be also found here:

http://lists.mysql.com/commits/21910

The patch http://lists.mysql.com/commits/21910 looks ok to push.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22097

ChangeSet@1.2482, 2007-03-16 12:15:51+04:00, gluh@mysql.com +3 -0
  Bug#26285 selecting information_schema crahes server
  The crash happens when 'skip-grant-tables' is enabled.
  We skip the filling of I_S privilege tables 
  if acl_cache is not initialized.

Pushed in 5.0.40, 5.1.17

Noted in 5.0.40, 5.1.17 changelogs.