Bug #63377 SHOW CREATE TABLE for P_S tables fail

• Submitted: 22 Nov 2011 9:20
• Modified: 22 Nov 2011 9:44
• Reporter: Peter Laursen (Basic Quality Contributor)
• Status: Not a Bug
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.6.3
• OS: Any
• Assigned to: Marc ALFF
• CPU Architecture: Any

[22 Nov 2011 9:20] Peter Laursen

Description:
SHOW CREATE to two specific tables in P_S returns error that table does not exist.  SHOW [FULL] TABLES tell that they are there and I can even SELECT from them.

How to repeat:
SHOW CREATE TABLE `performance_schema`.`events_waits_summary_by_event_name`;
/*
Error Code: 1146
Table 'performance_schema.events_waits_summary_by_event_name' doesn't exist
*/
SHOW CREATE TABLE `performance_schema`.`processlist`;
/*
Error Code: 1146
Table 'performance_schema.processlist' doesn't exist
*/

SHOW FULL TABLES FROM `performance_schema`;
/*
Tables_in_performance_schema                        Table_type
--------------------------------------------------  ----------
...
events_waits_summary_by_thread_by_event_name        BASE TABLE
..
processlist                                         BASE TABLE
...

Suggested fix:
This will cause problems with GUI clients that will issue statements like SHOW CREATE TABLE, SHOW TABLE STATUS etc. to populate the GUI.

[22 Nov 2011 9:26] Peter Laursen

No .. I was wrong in one respect.  I cannot SELECT either!

SELECT * FROM `performance_schema`.`processlist`;
/*
Error Code: 1146
Table 'performance_schema.processlist' doesn't exist
*/

But SHOW TABLES tell they are there. Are they supposed to be or not?

[22 Nov 2011 9:44] Marc ALFF

Please follow the proper upgrade procedure when installing a new version of mysql.

In particular, just dropping a 5.6 server binary on top of an existing 5.5 (or earlier 5.6) installation does not work, and will lead to the errors reported here.

mysql_upgrade will create the missing tables.

Not a bug.