MySQL Forums
Forum List  »  Replication

Re: Slave "skip" relay-bin command randomly
Posted by: KEOU CHAO
Date: July 15, 2014 10:49AM

Thanks, it took a while for the error to show up. It is Radius using Mysql DB,

mysql Ver 14.14 Distrib 5.1.73, for debian-linux-gnu (x86_64) using readline 6.1

The changed was made from mysql query bench 1.1.19 to delete DB entries. It randomly failed. It shows up at slave relay-bin, but did not executed.

Rick James Wrote:
-------------------------------------------------------
> Well, let's get some more details, in order to
> focus on what happened...
>
> * What was the statement?

From the mysql.log at master
140714 11:19:14 4716 Query DELETE FROM `radius`.`radcheck` WHERE `id`=27810

>
> * Are the relevant table(s) identically defined on
> Master and Slave? Compare SHOW CREATE TABLE.
>

Yes, those tables are identical; I ran mysqldbcompare daily to compare the master DB, and slave DB.

> * Is the statement part of a transaction?
I assumed so, but I can not tell.

>
> * What version(s) of mysql are involved?

5.1.17
>
> * ROW or STATEMENT or MIXED replication?

STATEMENT replication

The my.cnf in master has
replicate-do-db=radius

in slave has
replicate-ignore-table=radius.radpostauth
replicate-ignore-table=radius.radacct

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slave "skip" relay-bin command randomly
964
July 15, 2014 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.