Bug #26285 Selecting information_schema crahes server
Submitted: 12 Feb 2007 13:37 Modified: 19 Mar 2007 18:03
Reporter: Franz Bernscherer
Status: Closed
Category:Server: I_S Severity:S1 (Critical)
Version:5.1.15 Beta OS:Microsoft Windows (Windows 2003)
Assigned to: Sergey Gluhov Target Version:

[12 Feb 2007 13:37] Franz Bernscherer 
Description:
Selecting information_schema with phpMyAdmin 2.11.0-dev crashes mysqld-nt.

How to repeat:
try to view the databases in information_schema
[13 Feb 2007 8:03] Sveta Smirnova 
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
[13 Feb 2007 8:57] Franz Bernscherer 
You'r right - sorry; Server Version: 5.1.15-beta-community-nt
with root rights.
[13 Feb 2007 14:13] Sveta Smirnova 
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.
[13 Feb 2007 14:18] Sveta Smirnova 
Problem happens only if one tries to access to I_S using C API application. From command
line client all work fine.
[15 Mar 2007 10:30] Alexander Barkov 
The patch can be also found here:

http://lists.mysql.com/commits/21910
[15 Mar 2007 10:31] Alexander Barkov 
The patch http://lists.mysql.com/commits/21910 looks ok to push.
[16 Mar 2007 9:20] Bugs System 
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.
[17 Mar 2007 18:57] Alexey Botchkov 
Pushed in 5.0.40, 5.1.17
[19 Mar 2007 18:03] Paul DuBois 
Noted in 5.0.40, 5.1.17 changelogs.