Bug #54634 | Alter table query fails and did not written to bin log | ||
---|---|---|---|
Submitted: | 19 Jun 2010 17:07 | Modified: | 21 Jun 2010 6:11 |
Reporter: | Devang Modi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
Version: | mysql Ver 14.12 Distrib 5.0.77 | OS: | Linux (Linux (Linux Server release 5.4 (Tikanga))) |
Assigned to: | CPU Architecture: | Any | |
Tags: | alter, bin, did, fails, log, not, query, table, to, written |
[19 Jun 2010 17:07]
Devang Modi
[20 Jun 2010 7:09]
Valeriy Kravchuk
I do not see any my.cnf. Please, upload it.
[20 Jun 2010 11:27]
Devang Modi
My.cnf without ip, userid and password description
Attachment: master_my.cnf (application/octet-stream, text), 7.15 KiB.
[20 Jun 2010 11:30]
Devang Modi
Dear Friend; Please see it with this. Sorry, for the inconvenience . Devang
[20 Jun 2010 12:21]
Valeriy Kravchuk
You have this: binlog-do-db = cvt in my.cnf. Why do you expect any statements on other databases to be logged? Read http://dev.mysql.com/doc/refman/5.1/en/replication-rules-db-options.html. I think this is NOT a bug.
[21 Jun 2010 1:35]
Devang Modi
Dear sir; We are using this setup since a long back, we found that all other statements like Insert, Update and Delete are applied to other databases perfectly and without any error. That is why I am doubting . For example Insert into cvta0001.t1 .... will be logged and replicated perfectly on all replication server. only "Alter ..." was rejected .... Devang
[21 Jun 2010 4:01]
Devang Modi
Dear Sir; I have tried the same by change binlog-do-db option. I set binlog-do-db=cvt binlog-do-db=cvta0001 than binlog-do-db=cvt;cvta0001 but I am not able solve the case. Please guide me further in this regards. Please also consider my previous comments on this. Devang
[21 Jun 2010 4:39]
Devang Modi
Dear Sir; Thanking you very much for the information regarding binlog-do-db, I able to record "Alter ..." to binlog but still my question is still their "Why master bin log rejected only ALTER statement and not insert,delete and update statement" May be I am wrong somewhere please update me. Devang
[21 Jun 2010 5:07]
Valeriy Kravchuk
Let me ask a question: what is the default database (those set with USE explicitly or those you initially connect to) in case of ALTER and in case of INSERT etc? Maybe they are different? Check your code.
[21 Jun 2010 6:10]
Devang Modi
Dear Sir; Thanks a lot for pointing I am able to understand the set up and you are perfectly right this is not "BUG" Sorry for the reporting. Please accept my Heartiest thanking you for the very well support. Devang
[21 Jun 2010 6:11]
Devang Modi
Dear Sir; Thanks a lot for pointing I am able to understand the set up and you are perfectly right this is not "BUG" Sorry for the reporting but Heartiest thanking you for the very well support. Devang