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

[Jason Guy]

Hi Robin,

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 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.

Jason

On Thu, Mar 7, 2019 at 1:27 AM Robin Daermann <
robin.daermann at ruhr-uni-bochum.de> wrote:

> Hi Jason,
>
> On Wed, Mar 06, 2019 at 02:46:16PM -0500, Jason Guy wrote:
> > Please specify the Kea version, and what type of reconfiguration is being
> > done.
>
> Sorry, I missed that. Kea version is 1.5.0 and during reconfigurations,
> additional host reservations are created. Sometimes, they are changed.
>
> I did two main changes at a time, upgrade from Kea 1.3.0 to Kea 1.5.0
> and setup MySQL replication, so unfortunately, I don't know if it's Kea
> or MySQL. But I would assume, it's Kea.
>
> Whenever the Kea configuration gets recreated, the process runs on both
> our Kea machines independently. Config is generated from our
> configuration management automatically and aat roughly the same time,
> then Kea gets restarted and with a bit of bad luck, stops working with
> the mentioned ERROR on one or both the machines.
>
> Yesterday, I had to clean the complete tables lease4 and lease4_stat to
> be able to start the server again, so I guess, there is something with
> the processing of leases and not my configuration.
>
> Thanks
>
> 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...              |
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190307/fe59b591/attachment.htm>