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

Jason Guy jguy at cumulusnetworks.com
Wed Mar 6 19:46:16 UTC 2019


Hi Robin,

Please specify the Kea version, and what type of reconfiguration is being
done.

Jason

On Wed, Mar 6, 2019 at 1:14 PM Robin Daermann <
robin.daermann at ruhr-uni-bochum.de> wrote:

> Dear all,
>
> about 2-3 times a week, I get a strange problem with our Kea setup.
>
> We have two Kea servers, each hosting a MySQL server and database for
> lease storage.  Both MySQL servers are replicated in both directions, so
> each Kea server reads and writes from the MySQL database on localhost and
> they share their lease storage (anycast DHCP solution).
>
> So, the problem is: Sometimes, after a reconfiguration, I get the
> following error (either for kea-dhcp4 or kea-dhcp6):
>
> --------------------
> 2019-03-06 07:13:48.379 ERROR [kea-dhcp4.dhcp4/89345]
> DHCP4_CONFIG_LOAD_FAIL configuration error using file:
> /usr/local/etc/kea/kea-dhcp4.conf, reason: Error while processing command
> 'config-set':getNextRow failed for <SELECT subnet_id, state, leases as
> state_count  FROM lease4_stat ORDER BY subnet_id, state>, reason:  (error
> code 0), params: '{ "Dhcp4": { "control-socket": {
> ...
> --------------------
>
> I cut off the rest of the JSON configuration, which is syntactically
> correct.
>
> I can't explain that behaviour. Can anyone point me in the right direction
> here?
>
> Thank you
>
> 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/20190306/dfb96cd4/attachment.html>


More information about the Kea-users mailing list