Bug #79202 Unable to import sys_56.sql

• Submitted: 10 Nov 2015 11:14
• Modified: 14 Dec 2015 12:08
• Reporter: Wendell Sulad
• Status: Can't repeat
• Category: MySQL Server: SYS Schema
• Severity: S3 (Non-critical)
• OS: Red Hat
• CPU Architecture: Any

[10 Nov 2015 11:14] Wendell Sulad

Description:
I have an issue while importing sys_56.sql with the latest version in github
My current mysql version I have used is mysql 5.6.20 with redhat 6.5 linux os

Below is my my.cnf configuration for performance schema
performance_schema
performance_schema_instrument = '%=on'
performance_schema_consumer_events_stages_current = ON
performance_schema_consumer_events_stages_history = ON
performance_schema_consumer_events_stages_history_long = ON
performance_schema_consumer_events_statements_current = ON
performance_schema_consumer_events_statements_history = ON
performance_schema_consumer_events_statements_history_long = ON
performance_schema_consumer_events_waits_current = ON
performance_schema_consumer_events_waits_history = ON
performance_schema_consumer_events_waits_history_long = ON
performance_schema_consumer_global_instrumentation = ON
performance_schema_consumer_thread_instrumentation = ON
performance_schema_consumer_statements_digest = ON

Upon importing sys_56.sql below is the sql error that I've encoutered.

[user1@server-local mysql-sys-master]# mysql -u root -p < ./sys_56.sql
Enter password:
ERROR 1146 (42S02) at line 47 in file: './views/p_s/processlist.sql': Table 'performance_schema.threads' doesn't exist

How to repeat:
Run mysql -u root -p < ./sys_56.sql

[14 Dec 2015 12:08] MySQL Verification Team

Hello Wendell Sulad,

Thank you for the report.
I cannot repeat this issue at my end(freshly installed 5.6 latest GA build), Was it a upgrade from previous version? if you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh