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

[flingo]

Exactly the same here: the Kea DHCP server setup worked for weeks and all
over sudden, after a configuration change / restart the servers refused to
start with the mentioned error. 

DELETE FROM lease4_stat where leases < 0 

solved the issue so far. Since I don't want to wait for the next occurence
of quite unfrequent issue, I changed the table description of lease4_stat,
so that field 'leases' is now 'BIGINT(20) UNSIGNED NULL DEFAULT NULL'. This
should prevent any further negative values. Hope this doesn't break the code
elsewhere. Let's wait and see ...

Here is my setup:
- 2 CentOS7 machines 
- each running KEA DHCP 1.5.0 and 
- MYSQL 5.7.x Leases Database 
- MYSQL Master-Master-Replication
- KEA HA / Failover (not load balancing) w/ send-lease-updates and
sync-leases set to false (i.e. leases are replicated via MySQL replication)




--
Sent from: http://kea-users.7364.n8.nabble.com/