[Kea-users] DHCP4_CONFIG_LOAD_FAIL - "getNextRow failed" with MySQL
robin.daermann at ruhr-uni-bochum.de
Tue Mar 19 08:36:50 UTC 2019
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
Thank you for listening to me.
Mit freundlichen Grüßen
(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...
Size: 6323 bytes
Desc: not available
More information about the Kea-users