List:General Discussion« Previous MessageNext Message »
From:Néstor Date:November 30 2012 9:23pm
Subject:MySQL Replication Error
View as plain text  
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
which is a duplicate entry and my 'slave status' shows:
          Slave_IO_Running: Yes
          Slave_SQL_Running: No

And this is the error on my mysql.err file:
121130 12:41:53 [Note] Slave I/O thread killed while reading event
121130 12:41:53 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000266', position 76841310
121130 12:41:57 [Note] Slave SQL thread initialized, starting replication
in log 'mysql-bin.000265' at position 99071761, relay log
'/var/log/mysql/mysql-relay-bin.000006' position: 98589371
121130 12:41:57 [Note] Slave I/O thread: connected to master '
sdcwa_slave@stripped:3306',  replication started in log
'mysql-bin.000266' at position 76841310
121130 12:41:57 [ERROR] Slave: Error 'Duplicate entry
'links:primary-links:tree-data:7b7216a15969aa93e5dfb9aaa24bfc32' for key 1'
on query. Default database: 'parallax'. Query: 'INSERT INTO cache_menu
(cid, data, created, expire, headers, serialized) VALUES
121130 12:41:57 [ERROR] Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'mysql-bin.000265' position 99451408

I done searches on google and I look at several sites and basically they
say to do the following:
mysql> stop slave;
mysql> start slave;
mysql> show slave status\G

But after doing this a couple of minutes later I get the same situation

I have re-installed the database on the slave also to see if this fixes the
but after a few minutes I get the same error.  I have repeated the
replication from the
beginning but I get the same problem after a while.

Does anyone know a way to fix this?



MySQL Replication ErrorNéstor30 Nov
  • RE: MySQL Replication ErrorRick James30 Nov
    • Re: MySQL Replication ErrorReindl Harald30 Nov
      • Re: MySQL Replication Errordivesh kamra5 Dec
        • Re: MySQL Replication ErrorJohan De Meersman5 Dec
          • Re: MySQL Replication ErrorNéstor6 Dec
  • Re: MySQL Replication ErrorManuel Arostegui5 Dec
    • Re: MySQL Replication ErrorNéstor6 Dec
      • Re: MySQL Replication ErrorIgor Shevtsov6 Dec
      • Re: MySQL Replication ErrorIgor Shevtsov6 Dec
      • Re: MySQL Replication ErrorJohan De Meersman10 Dec
Re: MySQL Replication ErrorNéstor7 Dec
  • Re: MySQL Replication ErrorIgor Shevtsov7 Dec