Folks, We are running kea-1.3 with mysql backend and today suddenly we encounter following errors and it stopped renewing IPs, i have seen flood of following error and suddenly after 30 min error disappeared and it start renewing IP but it cause major production impact, we have plan to upgrade to 1.6 but just trying to understand suddenly after 2 years what happened, any idea?
Basic googling saying it could be a bug of mysql but just want to understand what went wrong so we can avoid this in future. We are running MariaDB 10.2 (galera cluster) 2020-03-07 02:04:29.625 ERROR [kea-dhcp4.alloc-engine/29796] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:19:85:f0:1c:89], cid=[no info], tid=0xd7790768: error during attempt to allocate an IPv4 address: unable to execute for <UPDATE lease4 SET address = ?, hwaddr = ?, client_id = ?, valid_lifetime = ?, expire = ?, subnet_id = ?, fqdn_fwd = ?, fqdn_rev = ?, hostname = ?, state = ? WHERE address = ?>, reason: Incorrect datetime value: '2020-03-08 02:04:29' for column 'expire' at row 1 (error code 1292) _______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
