[Opendnssec-user] mysql migrate duplicate entry

Yuri Schaeffer yuri at nlnetlabs.nl
Wed Mar 1 15:33:22 UTC 2017


Hi Emil

> ERROR 1062 (23000) at line 474: Duplicate entry '81' for key 'PRIMARY'

As Berry said, it has to to with the shared keys option. The fix is
pretty straight forward. I think a DISTINCT keyword in the right place
solves the issue. However with your database in hand I came across
multiple issues with the script.

So I'll work on those and evaluate the fix. I expect to have it finished
tomorrow.

Regards,
Yuri

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170301/ebbc70e5/attachment.bin>


More information about the Opendnssec-user mailing list