[Kea-users] kea error code 1292

[Satish Patel]

expiration date always in future right?

On Sat, Mar 7, 2020 at 1:18 PM Jeronimo <jscmenezes at gmail.com> wrote:
>
> The date seems to be in the future.
>
>
>
> Em sáb, 7 de mar de 2020 às 15:13, Satish Patel <satish.txt at gmail.com> escreveu:
>>
>> 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
>> Kea-users at lists.isc.org
>> https://lists.isc.org/mailman/listinfo/kea-users