[Kea-users] problem with Postgres leases after upgrade (I think)
Brant Ian Stevens
branto at sinewaveinc.io
Fri May 17 00:51:51 UTC 2019
Forgive the top-post...
I noticed that this was happening on devices that had reservations. New
leases seem to go out without an issue.
Brant Ian Stevens wrote on 5/16/19 8:23 PM:
> Seeing the same...
>
> Did you ever find a resolution? Need any more data collected?
>
> 2019-05-16 20:02:00.091 INFO [kea-dhcp6.dhcp6/747] DHCP6_STARTED Kea
> DHCPv6 server version 1.5.0 started
> 2019-05-16 20:07:31.706 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
> 2019-05-16 20:07:32.660 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
> 2019-05-16 20:07:34.839 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
> 2019-05-16 20:07:39.404 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
> 2019-05-16 20:07:48.442 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
> 2019-05-16 20:08:05.809 ERROR [kea-dhcp6.alloc-engine/747]
> ALLOC_ENGINE_V6_ALLOC_ERROR duid=[REMOVED, tid=0x5aecf0: error during
> attempt to allocate an IPv6 address: Could not convert data to Lease6,
> reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast:
> source type value could not be interpreted as target
>
>
> --
> --
> Regards,
> --
> Brant I. Stevens, founder.
> branto at sinewaveinc.io
> o:212.882.1185. m:917.673.6536. f:917.525.4759.
> https://www.sinewave.network
> <https://www.sinewave.network>
>
>
> Tim Howe wrote on 4/30/19 8:50 PM:
>> On Tue, 30 Apr 2019 17:35:29 -0700
>> Tim Howe<tim.h at bendtel.com> wrote:
>>
>>> I had a working kea 1.3 server. After upgrading to 1.5 and upgrading
>>> my PostgreSQL schema, it appears as if Kea isn't able to correctly use
>>> the new Pg schema(?)
>>>
>>> The below errors seem to suggest that it doesn't like the data that is
>>> in the hwtype column of the lease6 table. In the database all that
>>> data is blank (null?).
>>>
>>> Is there some default value I can fill in that will allow it to get past this problem?
>>>
>>>
>>>
>>> 2019-04-30 17:12:11.800 DEBUG [kea-dhcp6.leases/10281] DHCP6_PROCESS_IA_NA_REQUEST duid=[00:03:00:01:c8:54:4b:54:e5:28], tid=0xcf349e: server is processing IA_NA option with iaid=1 and hint=(no hint)
>>> 2019-04-30 17:12:11.800 DEBUG [kea-dhcp6.dhcpsrv/10281] DHCPSRV_PGSQL_GET_IAID_DUID obtaining IPv4 leases for IAID 1 and DUID 00:03:00:01:c8:54:4b:54:e5:28, lease type 0
>>> 2019-04-30 17:12:11.801 ERROR [kea-dhcp6.alloc-engine/10281] ALLOC_ENGINE_V6_ALLOC_ERROR duid=[00:03:00:01:c8:54:4b:54:e5:28], tid=0xcf349e: error during attempt to allocate an IPv6 address: Could not convert data to Lease6, reason: Invalid data:[] for row: 0 col: 13,hwtype : bad lexical cast: source type value could not be interpreted as target
>>> 2019-04-30 17:12:11.801 DEBUG [kea-dhcp6.leases/10281] DHCP6_LEASE_ADVERT_FAIL duid=[00:03:00:01:c8:54:4b:54:e5:28], tid=0xcf349e: failed to advertise an address lease for iaid=1
>>> 2019-04-30 17:12:11.801 DEBUG [kea-dhcp6.options/10281] DHCP6_ADD_STATUS_CODE_FOR_IA duid=[00:03:00:01:c8:54:4b:54:e5:28], tid=0xcf349e: adding Status Code to IA with iaid=1: NoAddrsAvail(2) "Sorry, no address could be allocated."
>>>
>>> --TimH
>>> _______________________________________________
>>> Kea-users mailing list
>>> Kea-users at lists.isc.org
>>> https://lists.isc.org/mailman/listinfo/kea-users
>> I think the problem is in src/lib/dhcpsrv/pgsql_lease_mgr.cc
>>
>> I notice the state column is ignored here (around line 805).
>> Is my data different after schema upgrade than would be expected if I
>> started with 1.5? Seems this is a data sanity check problem, but I
>> haven't looked at this code before.
>>
>> --TimH
>> _______________________________________________
>> Kea-users mailing list
>> Kea-users at lists.isc.org
>> https://lists.isc.org/mailman/listinfo/kea-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190516/f33cb0b4/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 6906 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190516/f33cb0b4/attachment.png>
More information about the Kea-users
mailing list