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
Subject
Views
Written By
Posted
1655
July 07, 2014 10:34PM
857
July 08, 2014 05:55PM
Re: Slave "skip" relay-bin command randomly
964
July 15, 2014 10:49AM
836
July 17, 2014 04:54PM
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.