blob: a7c47d8d64a4089d2df745a4aec90f9b49e23711 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
drop table if exists test.user_table;
drop procedure if exists test.user_proc;
drop function if exists test.user_func;
drop event if exists test.user_event;
"Testing mysql_upgrade with TABLE performance_schema.user_table"
create table test.user_table(a int);
use performance_schema;
show tables like "user_table";
Tables_in_performance_schema (user_table)
user_table
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 1125: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
show tables like "user_table";
Tables_in_performance_schema (user_table)
user_table
use test;
drop table test.user_table;
"Testing mysql_upgrade with VIEW performance_schema.user_view"
create view test.user_view as select "Not supposed to be here";
use performance_schema;
show tables like "user_view";
Tables_in_performance_schema (user_view)
user_view
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 1125: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
show tables like "user_view";
Tables_in_performance_schema (user_view)
user_view
use test;
drop view test.user_view;
"Testing mysql_upgrade with PROCEDURE performance_schema.user_proc"
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 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 1125: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.proc where db='performance_schema';
name
user_proc
update mysql.proc set db='test' where name='user_proc';
drop procedure test.user_proc;
"Testing mysql_upgrade with FUNCTION performance_schema.user_func"
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 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 1125: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.proc where db='performance_schema';
name
user_func
update mysql.proc set db='test' where name='user_func';
drop function test.user_func;
"Testing mysql_upgrade with EVENT performance_schema.user_event"
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 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 1125: Unexpected content found in the performance_schema database.
FATAL ERROR: Upgrade failed
select name from mysql.event where db='performance_schema';
name
user_event
update mysql.event set db='test' where name='user_event';
drop event test.user_event;
|
