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

Robin Daermann robin.daermann at ruhr-uni-bochum.de
Wed Mar 6 17:32:40 UTC 2019

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...              |
-------------- 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/20190306/1fa7b78e/attachment.bin>

More information about the Kea-users mailing list