MySQL Bugs: #34060: mysql_upgrade needs --local option

Bug #34060	mysql_upgrade needs --local option
Submitted:	25 Jan 2008 15:51	Modified:	4 Oct 2010 8:54
Reporter:	Morgan Tocker	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.0.54	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When the mysql_upgrade script runs, it performs a number of ALTER table statements.  If the mysql_upgrade has already been run on the slave, then it can result in duplicate column errors.

Many people do any upgrades etc to slaves first, so this is kind of annoying.  It's also unknown how many events need to be skipped with SQL_SLAVE_SKIP_COUNTER.

How to repeat:
Use mysql upgrade on slave, then use it on master.

Suggested fix:
Add a --local option to mysql_upgrade to disable binary logging for the session it executes in.

This is a duplicate of bug #46638

Sorry, wrong bug number.

This is a duplcate of bug #43579