[Kea-users] kea error code 1292

[Satish Patel]

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)