[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