[Kea-users] problem with Postgres leases after upgrade (I think)

Fri May 17 00:23:34 UTC 2019

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/6eefd088/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sinewave-logo-320x132.png
Type: image/png
Size: 7044 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190516/6eefd088/attachment.png>