From: Reindl Harald
Date: February 20 2013 10:41pm
Subject: Re: replication fails after upgrade to 5.6
List-Archive: http://lists.mysql.com/mysql/229024
Message-Id: <51255115.3000609@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="----enig2GGHTDSFMAUKEJLLVLLWK"

------enig2GGHTDSFMAUKEJLLVLLWK
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 20.02.2013 23:27, schrieb Mike Franon:
> So I successfully upgraded a test db server from 5.0.96 all the way up =
to 5.6
>=20
> Replication as the slave, where the master is 5.0.96, started working
> for about 10 minutes and then got the following error:
>=20
> [ERROR] Slave SQL: Error 'Duplicate entry 'data' for key 'PRIMARY'' on
> query. Default database: 'test'. Query: 'UPDATE IGNORE , Error_code:
> 1062
>=20
> All of our other slaves on 5.0.96 are fine, so I know it has to do
> with 5.6 but just not sure what, when ir an mysql_upgrade everything
> was OK

did you surely upgrade and restart the slaves first?

i personally would NOT go to 5.6 now

it is a very young release and looking and the typical changelogs
replication has always the most fixed bugs


------enig2GGHTDSFMAUKEJLLVLLWK
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.13 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlElURUACgkQhmBjz394AnnBdgCgl84DsJufbO/pSVb2hi/SGJtM
xrgAoJEZxXdzkv8IpNArcVRUoUGEopD3
=UzPO
-----END PGP SIGNATURE-----

------enig2GGHTDSFMAUKEJLLVLLWK--