blob: 08991726796ee8a1f0136fb4b41b8f949728ee87 (
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 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 1119: 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 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 1119: 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 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 1119: 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 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 1119: 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 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 1119: 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;
|
