[Kea-users] kea error code 1292

[Francis Dupont]

Jeronimo writes:
> The date seems to be in the future.

=> not very surprising for an expire date...

> > 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)

=> IMHO it looks like a MySQL bug (i.e. I can't explain how the date
could be incorrect).

Regards

Francis Dupont <fdupont at isc.org>