From: Reindl Harald Date: February 21 2013 6:29pm Subject: Re: replication fails after upgrade to 5.6 List-Archive: http://lists.mysql.com/mysql/229030 Message-Id: <5126678E.3060109@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="----enig2NPFRWWQCITTLKCWDDMPG" ------enig2NPFRWWQCITTLKCWDDMPG Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 21.02.2013 19:11, schrieb Mike Franon: > Is the only way to really fix this is to upgrade master? I thought > you can replicate from master -> slave if version is higher on slave, > just not the other way around? normally no but take a look at the changelogs of myslq in the last years 80 out of 100 fixes are replication bugs > On Thu, Feb 21, 2013 at 1:03 PM, Reindl Harald = wrote: >> update the master ASAP in a short timeframe too >> and re-init replication if needed >> >> normally both should have exactly the same version >> >> the slaves must be updated first because otherwise >> a master may write instructions in the binlog the older >> slave does not undersatdn at all, but as said normally >> both should have the same version >> >> Am 21.02.2013 18:03, schrieb Mike Franon: >>> So I created a new test box on AWS, and just did one upgrade from >>> 5.0.96 to 5.1, like I did before and replication will not work from a= >>> master with 5.0.96 to a slave with 5.1.68 >>> >>> I keep getting Error 1062, Duplicate Entry for key >>> >>> I get no errors when I do a mysql_upgrade, all comes back ok. >>> >>> I was curious if anyone had any ideas? >>> >>> Thanks >>> >>> On Wed, Feb 20, 2013 at 5:51 PM, Mike Franon w= rote: >>>> This is on a slave, i only upgraded on one box which is the slave i >>>> have not touched master >>>> >>>> On Wed, Feb 20, 2013 at 5:41 PM, Reindl Harald wrote: >>>>> >>>>> >>>>> Am 20.02.2013 23:27, schrieb Mike Franon: >>>>>> So I successfully upgraded a test db server from 5.0.96 all the wa= y up to 5.6 >>>>>> >>>>>> Replication as the slave, where the master is 5.0.96, started work= ing >>>>>> for about 10 minutes and then got the following error: >>>>>> >>>>>> [ERROR] Slave SQL: Error 'Duplicate entry 'data' for key 'PRIMARY'= ' on >>>>>> query. Default database: 'test'. Query: 'UPDATE IGNORE , Error_cod= e: >>>>>> 1062 >>>>>> >>>>>> 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 everythi= ng >>>>>> 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 ------enig2NPFRWWQCITTLKCWDDMPG 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/ iEYEARECAAYFAlEmZ44ACgkQhmBjz394Ank1DgCgjdBmsBpUuIwdTbioPlpbUA8P LC4An3g/vIx4ySn4vXUhwFJlx23PZoKX =r3Jq -----END PGP SIGNATURE----- ------enig2NPFRWWQCITTLKCWDDMPG--