diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/pfs_upgrade.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/pfs_upgrade.result | 495 |
1 files changed, 245 insertions, 250 deletions
diff --git a/mysql-test/suite/perfschema/r/pfs_upgrade.result b/mysql-test/suite/perfschema/r/pfs_upgrade.result index 17a45d4fe45..9a2b6524c83 100644 --- a/mysql-test/suite/perfschema/r/pfs_upgrade.result +++ b/mysql-test/suite/perfschema/r/pfs_upgrade.result @@ -8,56 +8,55 @@ use performance_schema; show tables like "user_table"; Tables_in_performance_schema (user_table) user_table -ERROR 1050 (42S01) at line 97: Table 'cond_instances' already exists -ERROR 1050 (42S01) at line 122: Table 'events_waits_current' already exists -ERROR 1050 (42S01) at line 147: Table 'events_waits_history' already exists -ERROR 1050 (42S01) at line 172: Table 'events_waits_history_long' already exists -ERROR 1050 (42S01) at line 185: Table 'events_waits_summary_by_instance' already exists -ERROR 1050 (42S01) at line 198: Table 'events_waits_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 211: Table 'events_waits_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 225: Table 'events_waits_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 238: Table 'events_waits_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 250: Table 'events_waits_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 259: Table 'file_instances' already exists -ERROR 1050 (42S01) at line 288: Table 'file_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 319: Table 'file_summary_by_instance' already exists -ERROR 1050 (42S01) at line 332: Table 'socket_instances' already exists -ERROR 1050 (42S01) at line 362: Table 'socket_summary_by_instance' already exists -ERROR 1050 (42S01) at line 391: Table 'socket_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 432: Table 'mutex_instances' already exists -ERROR 1050 (42S01) at line 446: Table 'objects_summary_global_by_type' already exists -ERROR 1050 (42S01) at line 456: Table 'performance_timers' already exists -ERROR 1050 (42S01) at line 466: Table 'rwlock_instances' already exists -ERROR 1050 (42S01) at line 475: Table 'setup_actors' already exists -ERROR 1050 (42S01) at line 483: Table 'setup_consumers' already exists -ERROR 1050 (42S01) at line 492: Table 'setup_instruments' already exists -ERROR 1050 (42S01) at line 503: Table 'setup_objects' already exists -ERROR 1050 (42S01) at line 511: Table 'setup_timers' already exists -ERROR 1050 (42S01) at line 556: Table 'table_io_waits_summary_by_index_usage' already exists -ERROR 1050 (42S01) at line 600: Table 'table_io_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 679: Table 'table_lock_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 699: Table 'threads' already exists -ERROR 1050 (42S01) at line 715: Table 'events_stages_current' already exists -ERROR 1050 (42S01) at line 731: Table 'events_stages_history' already exists -ERROR 1050 (42S01) at line 747: Table 'events_stages_history_long' already exists -ERROR 1050 (42S01) at line 760: Table 'events_stages_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 773: Table 'events_stages_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 786: Table 'events_stages_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 800: Table 'events_stages_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 812: Table 'events_stages_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 858: Table 'events_statements_current' already exists -ERROR 1050 (42S01) at line 904: Table 'events_statements_history' already exists -ERROR 1050 (42S01) at line 950: Table 'events_statements_history_long' already exists -ERROR 1050 (42S01) at line 982: Table 'events_statements_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 1014: Table 'events_statements_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 1046: Table 'events_statements_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 1079: Table 'events_statements_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 1110: Table 'events_statements_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 1119: Table 'hosts' already exists -ERROR 1050 (42S01) at line 1128: Table 'users' already exists -ERROR 1050 (42S01) at line 1138: Table 'accounts' already exists -ERROR 1050 (42S01) at line 1172: Table 'events_statements_summary_by_digest' already exists -ERROR 1644 (HY000) at line 1594: Unexpected content found in the performance_schema database. +ERROR 1050 (42S01) at line ###: Table 'cond_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'mutex_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'objects_summary_global_by_type' already exists +ERROR 1050 (42S01) at line ###: Table 'performance_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'rwlock_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_actors' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_consumers' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_instruments' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_objects' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_index_usage' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'table_lock_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'threads' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'hosts' already exists +ERROR 1050 (42S01) at line ###: Table 'users' already exists +ERROR 1050 (42S01) at line ###: Table 'accounts' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_digest' already exists FATAL ERROR: Upgrade failed show tables like "user_table"; Tables_in_performance_schema (user_table) @@ -70,56 +69,55 @@ use performance_schema; show tables like "user_view"; Tables_in_performance_schema (user_view) user_view -ERROR 1050 (42S01) at line 97: Table 'cond_instances' already exists -ERROR 1050 (42S01) at line 122: Table 'events_waits_current' already exists -ERROR 1050 (42S01) at line 147: Table 'events_waits_history' already exists -ERROR 1050 (42S01) at line 172: Table 'events_waits_history_long' already exists -ERROR 1050 (42S01) at line 185: Table 'events_waits_summary_by_instance' already exists -ERROR 1050 (42S01) at line 198: Table 'events_waits_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 211: Table 'events_waits_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 225: Table 'events_waits_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 238: Table 'events_waits_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 250: Table 'events_waits_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 259: Table 'file_instances' already exists -ERROR 1050 (42S01) at line 288: Table 'file_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 319: Table 'file_summary_by_instance' already exists -ERROR 1050 (42S01) at line 332: Table 'socket_instances' already exists -ERROR 1050 (42S01) at line 362: Table 'socket_summary_by_instance' already exists -ERROR 1050 (42S01) at line 391: Table 'socket_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 432: Table 'mutex_instances' already exists -ERROR 1050 (42S01) at line 446: Table 'objects_summary_global_by_type' already exists -ERROR 1050 (42S01) at line 456: Table 'performance_timers' already exists -ERROR 1050 (42S01) at line 466: Table 'rwlock_instances' already exists -ERROR 1050 (42S01) at line 475: Table 'setup_actors' already exists -ERROR 1050 (42S01) at line 483: Table 'setup_consumers' already exists -ERROR 1050 (42S01) at line 492: Table 'setup_instruments' already exists -ERROR 1050 (42S01) at line 503: Table 'setup_objects' already exists -ERROR 1050 (42S01) at line 511: Table 'setup_timers' already exists -ERROR 1050 (42S01) at line 556: Table 'table_io_waits_summary_by_index_usage' already exists -ERROR 1050 (42S01) at line 600: Table 'table_io_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 679: Table 'table_lock_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 699: Table 'threads' already exists -ERROR 1050 (42S01) at line 715: Table 'events_stages_current' already exists -ERROR 1050 (42S01) at line 731: Table 'events_stages_history' already exists -ERROR 1050 (42S01) at line 747: Table 'events_stages_history_long' already exists -ERROR 1050 (42S01) at line 760: Table 'events_stages_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 773: Table 'events_stages_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 786: Table 'events_stages_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 800: Table 'events_stages_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 812: Table 'events_stages_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 858: Table 'events_statements_current' already exists -ERROR 1050 (42S01) at line 904: Table 'events_statements_history' already exists -ERROR 1050 (42S01) at line 950: Table 'events_statements_history_long' already exists -ERROR 1050 (42S01) at line 982: Table 'events_statements_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 1014: Table 'events_statements_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 1046: Table 'events_statements_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 1079: Table 'events_statements_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 1110: Table 'events_statements_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 1119: Table 'hosts' already exists -ERROR 1050 (42S01) at line 1128: Table 'users' already exists -ERROR 1050 (42S01) at line 1138: Table 'accounts' already exists -ERROR 1050 (42S01) at line 1172: Table 'events_statements_summary_by_digest' already exists -ERROR 1644 (HY000) at line 1594: Unexpected content found in the performance_schema database. +ERROR 1050 (42S01) at line ###: Table 'cond_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'mutex_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'objects_summary_global_by_type' already exists +ERROR 1050 (42S01) at line ###: Table 'performance_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'rwlock_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_actors' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_consumers' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_instruments' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_objects' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_index_usage' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'table_lock_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'threads' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'hosts' already exists +ERROR 1050 (42S01) at line ###: Table 'users' already exists +ERROR 1050 (42S01) at line ###: Table 'accounts' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_digest' already exists FATAL ERROR: Upgrade failed show tables like "user_view"; Tables_in_performance_schema (user_view) @@ -130,56 +128,55 @@ drop view test.user_view; create procedure test.user_proc() select "Not supposed to be here"; update mysql.proc set db='performance_schema' where name='user_proc'; -ERROR 1050 (42S01) at line 97: Table 'cond_instances' already exists -ERROR 1050 (42S01) at line 122: Table 'events_waits_current' already exists -ERROR 1050 (42S01) at line 147: Table 'events_waits_history' already exists -ERROR 1050 (42S01) at line 172: Table 'events_waits_history_long' already exists -ERROR 1050 (42S01) at line 185: Table 'events_waits_summary_by_instance' already exists -ERROR 1050 (42S01) at line 198: Table 'events_waits_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 211: Table 'events_waits_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 225: Table 'events_waits_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 238: Table 'events_waits_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 250: Table 'events_waits_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 259: Table 'file_instances' already exists -ERROR 1050 (42S01) at line 288: Table 'file_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 319: Table 'file_summary_by_instance' already exists -ERROR 1050 (42S01) at line 332: Table 'socket_instances' already exists -ERROR 1050 (42S01) at line 362: Table 'socket_summary_by_instance' already exists -ERROR 1050 (42S01) at line 391: Table 'socket_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 432: Table 'mutex_instances' already exists -ERROR 1050 (42S01) at line 446: Table 'objects_summary_global_by_type' already exists -ERROR 1050 (42S01) at line 456: Table 'performance_timers' already exists -ERROR 1050 (42S01) at line 466: Table 'rwlock_instances' already exists -ERROR 1050 (42S01) at line 475: Table 'setup_actors' already exists -ERROR 1050 (42S01) at line 483: Table 'setup_consumers' already exists -ERROR 1050 (42S01) at line 492: Table 'setup_instruments' already exists -ERROR 1050 (42S01) at line 503: Table 'setup_objects' already exists -ERROR 1050 (42S01) at line 511: Table 'setup_timers' already exists -ERROR 1050 (42S01) at line 556: Table 'table_io_waits_summary_by_index_usage' already exists -ERROR 1050 (42S01) at line 600: Table 'table_io_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 679: Table 'table_lock_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 699: Table 'threads' already exists -ERROR 1050 (42S01) at line 715: Table 'events_stages_current' already exists -ERROR 1050 (42S01) at line 731: Table 'events_stages_history' already exists -ERROR 1050 (42S01) at line 747: Table 'events_stages_history_long' already exists -ERROR 1050 (42S01) at line 760: Table 'events_stages_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 773: Table 'events_stages_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 786: Table 'events_stages_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 800: Table 'events_stages_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 812: Table 'events_stages_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 858: Table 'events_statements_current' already exists -ERROR 1050 (42S01) at line 904: Table 'events_statements_history' already exists -ERROR 1050 (42S01) at line 950: Table 'events_statements_history_long' already exists -ERROR 1050 (42S01) at line 982: Table 'events_statements_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 1014: Table 'events_statements_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 1046: Table 'events_statements_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 1079: Table 'events_statements_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 1110: Table 'events_statements_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 1119: Table 'hosts' already exists -ERROR 1050 (42S01) at line 1128: Table 'users' already exists -ERROR 1050 (42S01) at line 1138: Table 'accounts' already exists -ERROR 1050 (42S01) at line 1172: Table 'events_statements_summary_by_digest' already exists -ERROR 1644 (HY000) at line 1594: Unexpected content found in the performance_schema database. +ERROR 1050 (42S01) at line ###: Table 'cond_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'mutex_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'objects_summary_global_by_type' already exists +ERROR 1050 (42S01) at line ###: Table 'performance_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'rwlock_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_actors' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_consumers' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_instruments' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_objects' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_index_usage' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'table_lock_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'threads' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'hosts' already exists +ERROR 1050 (42S01) at line ###: Table 'users' already exists +ERROR 1050 (42S01) at line ###: Table 'accounts' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_digest' already exists FATAL ERROR: Upgrade failed select name from mysql.proc where db='performance_schema'; name @@ -190,56 +187,55 @@ drop procedure test.user_proc; create function test.user_func() returns integer return 0; update mysql.proc set db='performance_schema' where name='user_func'; -ERROR 1050 (42S01) at line 97: Table 'cond_instances' already exists -ERROR 1050 (42S01) at line 122: Table 'events_waits_current' already exists -ERROR 1050 (42S01) at line 147: Table 'events_waits_history' already exists -ERROR 1050 (42S01) at line 172: Table 'events_waits_history_long' already exists -ERROR 1050 (42S01) at line 185: Table 'events_waits_summary_by_instance' already exists -ERROR 1050 (42S01) at line 198: Table 'events_waits_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 211: Table 'events_waits_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 225: Table 'events_waits_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 238: Table 'events_waits_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 250: Table 'events_waits_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 259: Table 'file_instances' already exists -ERROR 1050 (42S01) at line 288: Table 'file_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 319: Table 'file_summary_by_instance' already exists -ERROR 1050 (42S01) at line 332: Table 'socket_instances' already exists -ERROR 1050 (42S01) at line 362: Table 'socket_summary_by_instance' already exists -ERROR 1050 (42S01) at line 391: Table 'socket_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 432: Table 'mutex_instances' already exists -ERROR 1050 (42S01) at line 446: Table 'objects_summary_global_by_type' already exists -ERROR 1050 (42S01) at line 456: Table 'performance_timers' already exists -ERROR 1050 (42S01) at line 466: Table 'rwlock_instances' already exists -ERROR 1050 (42S01) at line 475: Table 'setup_actors' already exists -ERROR 1050 (42S01) at line 483: Table 'setup_consumers' already exists -ERROR 1050 (42S01) at line 492: Table 'setup_instruments' already exists -ERROR 1050 (42S01) at line 503: Table 'setup_objects' already exists -ERROR 1050 (42S01) at line 511: Table 'setup_timers' already exists -ERROR 1050 (42S01) at line 556: Table 'table_io_waits_summary_by_index_usage' already exists -ERROR 1050 (42S01) at line 600: Table 'table_io_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 679: Table 'table_lock_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 699: Table 'threads' already exists -ERROR 1050 (42S01) at line 715: Table 'events_stages_current' already exists -ERROR 1050 (42S01) at line 731: Table 'events_stages_history' already exists -ERROR 1050 (42S01) at line 747: Table 'events_stages_history_long' already exists -ERROR 1050 (42S01) at line 760: Table 'events_stages_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 773: Table 'events_stages_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 786: Table 'events_stages_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 800: Table 'events_stages_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 812: Table 'events_stages_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 858: Table 'events_statements_current' already exists -ERROR 1050 (42S01) at line 904: Table 'events_statements_history' already exists -ERROR 1050 (42S01) at line 950: Table 'events_statements_history_long' already exists -ERROR 1050 (42S01) at line 982: Table 'events_statements_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 1014: Table 'events_statements_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 1046: Table 'events_statements_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 1079: Table 'events_statements_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 1110: Table 'events_statements_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 1119: Table 'hosts' already exists -ERROR 1050 (42S01) at line 1128: Table 'users' already exists -ERROR 1050 (42S01) at line 1138: Table 'accounts' already exists -ERROR 1050 (42S01) at line 1172: Table 'events_statements_summary_by_digest' already exists -ERROR 1644 (HY000) at line 1594: Unexpected content found in the performance_schema database. +ERROR 1050 (42S01) at line ###: Table 'cond_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'mutex_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'objects_summary_global_by_type' already exists +ERROR 1050 (42S01) at line ###: Table 'performance_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'rwlock_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_actors' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_consumers' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_instruments' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_objects' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_index_usage' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'table_lock_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'threads' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'hosts' already exists +ERROR 1050 (42S01) at line ###: Table 'users' already exists +ERROR 1050 (42S01) at line ###: Table 'accounts' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_digest' already exists FATAL ERROR: Upgrade failed select name from mysql.proc where db='performance_schema'; name @@ -250,56 +246,55 @@ drop function test.user_func; create event test.user_event on schedule every 1 day do select "not supposed to be here"; update mysql.event set db='performance_schema' where name='user_event'; -ERROR 1050 (42S01) at line 97: Table 'cond_instances' already exists -ERROR 1050 (42S01) at line 122: Table 'events_waits_current' already exists -ERROR 1050 (42S01) at line 147: Table 'events_waits_history' already exists -ERROR 1050 (42S01) at line 172: Table 'events_waits_history_long' already exists -ERROR 1050 (42S01) at line 185: Table 'events_waits_summary_by_instance' already exists -ERROR 1050 (42S01) at line 198: Table 'events_waits_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 211: Table 'events_waits_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 225: Table 'events_waits_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 238: Table 'events_waits_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 250: Table 'events_waits_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 259: Table 'file_instances' already exists -ERROR 1050 (42S01) at line 288: Table 'file_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 319: Table 'file_summary_by_instance' already exists -ERROR 1050 (42S01) at line 332: Table 'socket_instances' already exists -ERROR 1050 (42S01) at line 362: Table 'socket_summary_by_instance' already exists -ERROR 1050 (42S01) at line 391: Table 'socket_summary_by_event_name' already exists -ERROR 1050 (42S01) at line 432: Table 'mutex_instances' already exists -ERROR 1050 (42S01) at line 446: Table 'objects_summary_global_by_type' already exists -ERROR 1050 (42S01) at line 456: Table 'performance_timers' already exists -ERROR 1050 (42S01) at line 466: Table 'rwlock_instances' already exists -ERROR 1050 (42S01) at line 475: Table 'setup_actors' already exists -ERROR 1050 (42S01) at line 483: Table 'setup_consumers' already exists -ERROR 1050 (42S01) at line 492: Table 'setup_instruments' already exists -ERROR 1050 (42S01) at line 503: Table 'setup_objects' already exists -ERROR 1050 (42S01) at line 511: Table 'setup_timers' already exists -ERROR 1050 (42S01) at line 556: Table 'table_io_waits_summary_by_index_usage' already exists -ERROR 1050 (42S01) at line 600: Table 'table_io_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 679: Table 'table_lock_waits_summary_by_table' already exists -ERROR 1050 (42S01) at line 699: Table 'threads' already exists -ERROR 1050 (42S01) at line 715: Table 'events_stages_current' already exists -ERROR 1050 (42S01) at line 731: Table 'events_stages_history' already exists -ERROR 1050 (42S01) at line 747: Table 'events_stages_history_long' already exists -ERROR 1050 (42S01) at line 760: Table 'events_stages_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 773: Table 'events_stages_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 786: Table 'events_stages_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 800: Table 'events_stages_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 812: Table 'events_stages_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 858: Table 'events_statements_current' already exists -ERROR 1050 (42S01) at line 904: Table 'events_statements_history' already exists -ERROR 1050 (42S01) at line 950: Table 'events_statements_history_long' already exists -ERROR 1050 (42S01) at line 982: Table 'events_statements_summary_by_thread_by_event_name' already exists -ERROR 1050 (42S01) at line 1014: Table 'events_statements_summary_by_host_by_event_name' already exists -ERROR 1050 (42S01) at line 1046: Table 'events_statements_summary_by_user_by_event_name' already exists -ERROR 1050 (42S01) at line 1079: Table 'events_statements_summary_by_account_by_event_name' already exists -ERROR 1050 (42S01) at line 1110: Table 'events_statements_summary_global_by_event_name' already exists -ERROR 1050 (42S01) at line 1119: Table 'hosts' already exists -ERROR 1050 (42S01) at line 1128: Table 'users' already exists -ERROR 1050 (42S01) at line 1138: Table 'accounts' already exists -ERROR 1050 (42S01) at line 1172: Table 'events_statements_summary_by_digest' already exists -ERROR 1644 (HY000) at line 1594: Unexpected content found in the performance_schema database. +ERROR 1050 (42S01) at line ###: Table 'cond_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_waits_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'file_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_instance' already exists +ERROR 1050 (42S01) at line ###: Table 'socket_summary_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'mutex_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'objects_summary_global_by_type' already exists +ERROR 1050 (42S01) at line ###: Table 'performance_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'rwlock_instances' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_actors' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_consumers' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_instruments' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_objects' already exists +ERROR 1050 (42S01) at line ###: Table 'setup_timers' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_index_usage' already exists +ERROR 1050 (42S01) at line ###: Table 'table_io_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'table_lock_waits_summary_by_table' already exists +ERROR 1050 (42S01) at line ###: Table 'threads' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_stages_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_current' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_history_long' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_thread_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_host_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_user_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_account_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_global_by_event_name' already exists +ERROR 1050 (42S01) at line ###: Table 'hosts' already exists +ERROR 1050 (42S01) at line ###: Table 'users' already exists +ERROR 1050 (42S01) at line ###: Table 'accounts' already exists +ERROR 1050 (42S01) at line ###: Table 'events_statements_summary_by_digest' already exists FATAL ERROR: Upgrade failed select name from mysql.event where db='performance_schema'; name |