MySQL Bugs: #74912: altr table not replicated if _system

Bug #74912	altr table not replicated if _system_ user not root
Submitted:	18 Nov 2014 8:50	Modified:	26 Nov 2014 13:21
Reporter:	Lev Bystritskiy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	5.5.30	OS:	Linux (CentOS)
Assigned to:		CPU Architecture:	Any

Description:
System: Linux 2.6.18-348.2.1.el5 , CentOS
MySql: 5.5.30  , master-master replication

Alter table that was made manually was not replicated, until system user was not root. MySql user was root in both cases.

MySql root user have all privileges, including super_priv

How to repeat:
Original table:

CREATE TABLE `provider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

Then:

ALTER TABLE inet_click.provider add column notify_url varchar(255) after url;

Alter was successful, but not replicated on other master sever. But, if the same operation was made by the same MySql user, but under root system user - all was ok.

Suggested fix:
Can't understand the nature of this bug. Affects only hand made alters, and MySql user was the same. Table/base is not in a skip list.

Thank you for the bug report. Please check against latest release 5.5.40. Thanks.

Tested in 5.5.40 - everything is fine, no bug in 5.5.40.

Thank you for the feedback.