summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/pfs_upgrade.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/pfs_upgrade.result')
-rw-r--r--mysql-test/suite/perfschema/r/pfs_upgrade.result180
1 files changed, 90 insertions, 90 deletions
diff --git a/mysql-test/suite/perfschema/r/pfs_upgrade.result b/mysql-test/suite/perfschema/r/pfs_upgrade.result
index c9347809157..b2e415637d9 100644
--- a/mysql-test/suite/perfschema/r/pfs_upgrade.result
+++ b/mysql-test/suite/perfschema/r/pfs_upgrade.result
@@ -8,24 +8,24 @@ use performance_schema;
show tables like "user_table";
Tables_in_performance_schema (user_table)
user_table
-ERROR 1050 (42S01) at line 181: Table 'cond_instances' already exists
-ERROR 1050 (42S01) at line 211: Table 'events_waits_current' already exists
-ERROR 1050 (42S01) at line 225: Table 'events_waits_history' already exists
-ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists
-ERROR 1050 (42S01) at line 260: Table 'events_waits_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 281: Table 'events_waits_summary_by_thread_by_event_name' already exists
-ERROR 1050 (42S01) at line 301: Table 'events_waits_summary_global_by_event_name' already exists
-ERROR 1050 (42S01) at line 318: Table 'file_instances' already exists
-ERROR 1050 (42S01) at line 337: Table 'file_summary_by_event_name' already exists
-ERROR 1050 (42S01) at line 357: Table 'file_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 374: Table 'mutex_instances' already exists
-ERROR 1050 (42S01) at line 392: Table 'performance_timers' already exists
-ERROR 1050 (42S01) at line 410: Table 'rwlock_instances' already exists
-ERROR 1050 (42S01) at line 426: Table 'setup_consumers' already exists
-ERROR 1050 (42S01) at line 443: Table 'setup_instruments' already exists
-ERROR 1050 (42S01) at line 459: Table 'setup_timers' already exists
-ERROR 1050 (42S01) at line 476: Table 'threads' already exists
-ERROR 1644 (HY000) at line 1120: Unexpected content found in the performance_schema database.
+ERROR 1050 (42S01) at line 182: Table 'cond_instances' already exists
+ERROR 1050 (42S01) at line 212: Table 'events_waits_current' already exists
+ERROR 1050 (42S01) at line 226: Table 'events_waits_history' already exists
+ERROR 1050 (42S01) at line 240: Table 'events_waits_history_long' already exists
+ERROR 1050 (42S01) at line 261: Table 'events_waits_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 282: Table 'events_waits_summary_by_thread_by_event_name' already exists
+ERROR 1050 (42S01) at line 302: Table 'events_waits_summary_global_by_event_name' already exists
+ERROR 1050 (42S01) at line 319: Table 'file_instances' already exists
+ERROR 1050 (42S01) at line 338: Table 'file_summary_by_event_name' already exists
+ERROR 1050 (42S01) at line 358: Table 'file_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 375: Table 'mutex_instances' already exists
+ERROR 1050 (42S01) at line 393: Table 'performance_timers' already exists
+ERROR 1050 (42S01) at line 411: Table 'rwlock_instances' already exists
+ERROR 1050 (42S01) at line 427: Table 'setup_consumers' already exists
+ERROR 1050 (42S01) at line 444: Table 'setup_instruments' already exists
+ERROR 1050 (42S01) at line 460: Table 'setup_timers' already exists
+ERROR 1050 (42S01) at line 477: Table 'threads' already exists
+ERROR 1644 (HY000) at line 1122: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
show tables like "user_table";
Tables_in_performance_schema (user_table)
@@ -38,24 +38,24 @@ use performance_schema;
show tables like "user_view";
Tables_in_performance_schema (user_view)
user_view
-ERROR 1050 (42S01) at line 181: Table 'cond_instances' already exists
-ERROR 1050 (42S01) at line 211: Table 'events_waits_current' already exists
-ERROR 1050 (42S01) at line 225: Table 'events_waits_history' already exists
-ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists
-ERROR 1050 (42S01) at line 260: Table 'events_waits_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 281: Table 'events_waits_summary_by_thread_by_event_name' already exists
-ERROR 1050 (42S01) at line 301: Table 'events_waits_summary_global_by_event_name' already exists
-ERROR 1050 (42S01) at line 318: Table 'file_instances' already exists
-ERROR 1050 (42S01) at line 337: Table 'file_summary_by_event_name' already exists
-ERROR 1050 (42S01) at line 357: Table 'file_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 374: Table 'mutex_instances' already exists
-ERROR 1050 (42S01) at line 392: Table 'performance_timers' already exists
-ERROR 1050 (42S01) at line 410: Table 'rwlock_instances' already exists
-ERROR 1050 (42S01) at line 426: Table 'setup_consumers' already exists
-ERROR 1050 (42S01) at line 443: Table 'setup_instruments' already exists
-ERROR 1050 (42S01) at line 459: Table 'setup_timers' already exists
-ERROR 1050 (42S01) at line 476: Table 'threads' already exists
-ERROR 1644 (HY000) at line 1120: Unexpected content found in the performance_schema database.
+ERROR 1050 (42S01) at line 182: Table 'cond_instances' already exists
+ERROR 1050 (42S01) at line 212: Table 'events_waits_current' already exists
+ERROR 1050 (42S01) at line 226: Table 'events_waits_history' already exists
+ERROR 1050 (42S01) at line 240: Table 'events_waits_history_long' already exists
+ERROR 1050 (42S01) at line 261: Table 'events_waits_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 282: Table 'events_waits_summary_by_thread_by_event_name' already exists
+ERROR 1050 (42S01) at line 302: Table 'events_waits_summary_global_by_event_name' already exists
+ERROR 1050 (42S01) at line 319: Table 'file_instances' already exists
+ERROR 1050 (42S01) at line 338: Table 'file_summary_by_event_name' already exists
+ERROR 1050 (42S01) at line 358: Table 'file_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 375: Table 'mutex_instances' already exists
+ERROR 1050 (42S01) at line 393: Table 'performance_timers' already exists
+ERROR 1050 (42S01) at line 411: Table 'rwlock_instances' already exists
+ERROR 1050 (42S01) at line 427: Table 'setup_consumers' already exists
+ERROR 1050 (42S01) at line 444: Table 'setup_instruments' already exists
+ERROR 1050 (42S01) at line 460: Table 'setup_timers' already exists
+ERROR 1050 (42S01) at line 477: Table 'threads' already exists
+ERROR 1644 (HY000) at line 1122: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
show tables like "user_view";
Tables_in_performance_schema (user_view)
@@ -66,24 +66,24 @@ 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 181: Table 'cond_instances' already exists
-ERROR 1050 (42S01) at line 211: Table 'events_waits_current' already exists
-ERROR 1050 (42S01) at line 225: Table 'events_waits_history' already exists
-ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists
-ERROR 1050 (42S01) at line 260: Table 'events_waits_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 281: Table 'events_waits_summary_by_thread_by_event_name' already exists
-ERROR 1050 (42S01) at line 301: Table 'events_waits_summary_global_by_event_name' already exists
-ERROR 1050 (42S01) at line 318: Table 'file_instances' already exists
-ERROR 1050 (42S01) at line 337: Table 'file_summary_by_event_name' already exists
-ERROR 1050 (42S01) at line 357: Table 'file_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 374: Table 'mutex_instances' already exists
-ERROR 1050 (42S01) at line 392: Table 'performance_timers' already exists
-ERROR 1050 (42S01) at line 410: Table 'rwlock_instances' already exists
-ERROR 1050 (42S01) at line 426: Table 'setup_consumers' already exists
-ERROR 1050 (42S01) at line 443: Table 'setup_instruments' already exists
-ERROR 1050 (42S01) at line 459: Table 'setup_timers' already exists
-ERROR 1050 (42S01) at line 476: Table 'threads' already exists
-ERROR 1644 (HY000) at line 1120: Unexpected content found in the performance_schema database.
+ERROR 1050 (42S01) at line 182: Table 'cond_instances' already exists
+ERROR 1050 (42S01) at line 212: Table 'events_waits_current' already exists
+ERROR 1050 (42S01) at line 226: Table 'events_waits_history' already exists
+ERROR 1050 (42S01) at line 240: Table 'events_waits_history_long' already exists
+ERROR 1050 (42S01) at line 261: Table 'events_waits_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 282: Table 'events_waits_summary_by_thread_by_event_name' already exists
+ERROR 1050 (42S01) at line 302: Table 'events_waits_summary_global_by_event_name' already exists
+ERROR 1050 (42S01) at line 319: Table 'file_instances' already exists
+ERROR 1050 (42S01) at line 338: Table 'file_summary_by_event_name' already exists
+ERROR 1050 (42S01) at line 358: Table 'file_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 375: Table 'mutex_instances' already exists
+ERROR 1050 (42S01) at line 393: Table 'performance_timers' already exists
+ERROR 1050 (42S01) at line 411: Table 'rwlock_instances' already exists
+ERROR 1050 (42S01) at line 427: Table 'setup_consumers' already exists
+ERROR 1050 (42S01) at line 444: Table 'setup_instruments' already exists
+ERROR 1050 (42S01) at line 460: Table 'setup_timers' already exists
+ERROR 1050 (42S01) at line 477: Table 'threads' already exists
+ERROR 1644 (HY000) at line 1122: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.proc where db='performance_schema';
name
@@ -94,24 +94,24 @@ 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 181: Table 'cond_instances' already exists
-ERROR 1050 (42S01) at line 211: Table 'events_waits_current' already exists
-ERROR 1050 (42S01) at line 225: Table 'events_waits_history' already exists
-ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists
-ERROR 1050 (42S01) at line 260: Table 'events_waits_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 281: Table 'events_waits_summary_by_thread_by_event_name' already exists
-ERROR 1050 (42S01) at line 301: Table 'events_waits_summary_global_by_event_name' already exists
-ERROR 1050 (42S01) at line 318: Table 'file_instances' already exists
-ERROR 1050 (42S01) at line 337: Table 'file_summary_by_event_name' already exists
-ERROR 1050 (42S01) at line 357: Table 'file_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 374: Table 'mutex_instances' already exists
-ERROR 1050 (42S01) at line 392: Table 'performance_timers' already exists
-ERROR 1050 (42S01) at line 410: Table 'rwlock_instances' already exists
-ERROR 1050 (42S01) at line 426: Table 'setup_consumers' already exists
-ERROR 1050 (42S01) at line 443: Table 'setup_instruments' already exists
-ERROR 1050 (42S01) at line 459: Table 'setup_timers' already exists
-ERROR 1050 (42S01) at line 476: Table 'threads' already exists
-ERROR 1644 (HY000) at line 1120: Unexpected content found in the performance_schema database.
+ERROR 1050 (42S01) at line 182: Table 'cond_instances' already exists
+ERROR 1050 (42S01) at line 212: Table 'events_waits_current' already exists
+ERROR 1050 (42S01) at line 226: Table 'events_waits_history' already exists
+ERROR 1050 (42S01) at line 240: Table 'events_waits_history_long' already exists
+ERROR 1050 (42S01) at line 261: Table 'events_waits_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 282: Table 'events_waits_summary_by_thread_by_event_name' already exists
+ERROR 1050 (42S01) at line 302: Table 'events_waits_summary_global_by_event_name' already exists
+ERROR 1050 (42S01) at line 319: Table 'file_instances' already exists
+ERROR 1050 (42S01) at line 338: Table 'file_summary_by_event_name' already exists
+ERROR 1050 (42S01) at line 358: Table 'file_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 375: Table 'mutex_instances' already exists
+ERROR 1050 (42S01) at line 393: Table 'performance_timers' already exists
+ERROR 1050 (42S01) at line 411: Table 'rwlock_instances' already exists
+ERROR 1050 (42S01) at line 427: Table 'setup_consumers' already exists
+ERROR 1050 (42S01) at line 444: Table 'setup_instruments' already exists
+ERROR 1050 (42S01) at line 460: Table 'setup_timers' already exists
+ERROR 1050 (42S01) at line 477: Table 'threads' already exists
+ERROR 1644 (HY000) at line 1122: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.proc where db='performance_schema';
name
@@ -122,24 +122,24 @@ 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 181: Table 'cond_instances' already exists
-ERROR 1050 (42S01) at line 211: Table 'events_waits_current' already exists
-ERROR 1050 (42S01) at line 225: Table 'events_waits_history' already exists
-ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists
-ERROR 1050 (42S01) at line 260: Table 'events_waits_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 281: Table 'events_waits_summary_by_thread_by_event_name' already exists
-ERROR 1050 (42S01) at line 301: Table 'events_waits_summary_global_by_event_name' already exists
-ERROR 1050 (42S01) at line 318: Table 'file_instances' already exists
-ERROR 1050 (42S01) at line 337: Table 'file_summary_by_event_name' already exists
-ERROR 1050 (42S01) at line 357: Table 'file_summary_by_instance' already exists
-ERROR 1050 (42S01) at line 374: Table 'mutex_instances' already exists
-ERROR 1050 (42S01) at line 392: Table 'performance_timers' already exists
-ERROR 1050 (42S01) at line 410: Table 'rwlock_instances' already exists
-ERROR 1050 (42S01) at line 426: Table 'setup_consumers' already exists
-ERROR 1050 (42S01) at line 443: Table 'setup_instruments' already exists
-ERROR 1050 (42S01) at line 459: Table 'setup_timers' already exists
-ERROR 1050 (42S01) at line 476: Table 'threads' already exists
-ERROR 1644 (HY000) at line 1120: Unexpected content found in the performance_schema database.
+ERROR 1050 (42S01) at line 182: Table 'cond_instances' already exists
+ERROR 1050 (42S01) at line 212: Table 'events_waits_current' already exists
+ERROR 1050 (42S01) at line 226: Table 'events_waits_history' already exists
+ERROR 1050 (42S01) at line 240: Table 'events_waits_history_long' already exists
+ERROR 1050 (42S01) at line 261: Table 'events_waits_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 282: Table 'events_waits_summary_by_thread_by_event_name' already exists
+ERROR 1050 (42S01) at line 302: Table 'events_waits_summary_global_by_event_name' already exists
+ERROR 1050 (42S01) at line 319: Table 'file_instances' already exists
+ERROR 1050 (42S01) at line 338: Table 'file_summary_by_event_name' already exists
+ERROR 1050 (42S01) at line 358: Table 'file_summary_by_instance' already exists
+ERROR 1050 (42S01) at line 375: Table 'mutex_instances' already exists
+ERROR 1050 (42S01) at line 393: Table 'performance_timers' already exists
+ERROR 1050 (42S01) at line 411: Table 'rwlock_instances' already exists
+ERROR 1050 (42S01) at line 427: Table 'setup_consumers' already exists
+ERROR 1050 (42S01) at line 444: Table 'setup_instruments' already exists
+ERROR 1050 (42S01) at line 460: Table 'setup_timers' already exists
+ERROR 1050 (42S01) at line 477: Table 'threads' already exists
+ERROR 1644 (HY000) at line 1122: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.event where db='performance_schema';
name