[Kea-users] kea error code 1292

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[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)
_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] kea error code 1292

Jeronimo
The date seems to be in the future.



Em sáb, 7 de mar de 2020 às 15:13, Satish Patel <[hidden email]> 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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users

_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [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 <[hidden email]>
_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] kea error code 1292

Satish Patel
In reply to this post by Jeronimo
expiration date always in future right?

On Sat, Mar 7, 2020 at 1:18 PM Jeronimo <[hidden email]> wrote:

>
> The date seems to be in the future.
>
>
>
> Em sáb, 7 de mar de 2020 às 15:13, Satish Patel <[hidden email]> 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
>> [hidden email]
>> https://lists.isc.org/mailman/listinfo/kea-users
_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] kea error code 1292

Tomek Mrugalski
In reply to this post by Satish Patel
On 07/03/2020 19:12, Satish Patel wrote:
> We are running kea-1.3 with mysql backend
Sorry, I've stopped reading just there. 1.3 is ancient. There has been
4715 commits since 1.3.0 went out. Lots and lots of changes, including
many in MySQL and lease manager. Take a look at the changelog here:
https://gitlab.isc.org/isc-projects/kea/-/blob/master/ChangeLog

I strongly suggest to upgrade to 1.6.2, which is the latest stable release.

Tomek
_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] kea error code 1292

Satish Patel
Just curious if this issue related to Daylight saving. I just found my
Kea running on UTC timezone and MySQL running on EDT timezone. Do you
thing that could be an issue?

~S

On Sun, Mar 8, 2020 at 10:07 AM Tomek Mrugalski <[hidden email]> wrote:

>
> On 07/03/2020 19:12, Satish Patel wrote:
> > We are running kea-1.3 with mysql backend
> Sorry, I've stopped reading just there. 1.3 is ancient. There has been
> 4715 commits since 1.3.0 went out. Lots and lots of changes, including
> many in MySQL and lease manager. Take a look at the changelog here:
> https://gitlab.isc.org/isc-projects/kea/-/blob/master/ChangeLog
>
> I strongly suggest to upgrade to 1.6.2, which is the latest stable release.
>
> Tomek
> _______________________________________________
> Kea-users mailing list
> [hidden email]
> https://lists.isc.org/mailman/listinfo/kea-users
_______________________________________________
Kea-users mailing list
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users