[Kea-users] DHCP4_CONFIG_LOAD_FAIL - "getNextRow failed" with MySQL

[Robin Daermann]

Hi Jason,

On Thu, Mar 07, 2019 at 10:36:03AM -0500, Jason Guy wrote:
>I have had terrible issues with Mysql replication and anycast reachability.
>The problem may occurring when Kea writes to one server, which will
>propagate the changes to the other servers. If Kea then reads from the
>database, but perhaps the SQL connection lands on another host before the
>SQL replication is completed, it will cause issues.

I got around this specific issue with specifying

  slave-skip-errors = 1062

in the MySQL/MariaDB configuration. 1062 is "Duplicate Key error".

> I am about to change my
>database from mysql replication to a galera cluster. I think I will still
>continue to set the metric on each server advertising the anycast address
>to be selective for the primary/secondary/tertiary.

Since the last occurence of my problem, when I wrote the initial mail to 
the list, the mentioned error never happened again. And we had lots of 
configuration changes in the last two weeks (about 50). So I would 
assume, that my problem got solved by simply deleting the lease 
information from the database completely. It could definitely be, that I 
screwed sometinh up during migration from standalone to replicated 
database/anycast setup.

Thank you for listening to me.

Mit freundlichen Grüßen
Robin Därmann
(Network Operation Center RUB)

-- 
| Robin Därmann                             Network Operation Center |
| RS18625-RIPE                              Ruhr-Universitaet Bochum |
| Press any key to continue or any other key to quit...              |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6323 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190319/0e75ac9b/attachment.bin>