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

[18 Nov 2014 8:50] Lev Bystritskiy
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.
[18 Nov 2014 10:44] Miguel Solorzano
Thank you for the bug report. Please check against latest release 5.5.40. Thanks.
[26 Nov 2014 13:19] Lev Bystritskiy
Tested in 5.5.40 - everything is fine, no bug in 5.5.40.
[26 Nov 2014 13:21] Miguel Solorzano
Thank you for the feedback.