Problems with maria database, fields in store proc wrong
I have just upgraded to Opensuse 15, and since there are problems with boost in previous versions, I upgraded to the 14 beta.
However, with a mysql database, trying to populate the lease4 & lease6 tables fail with...
2018-05-28 11:53:09.332 ERROR [kea-dhcp6.alloc-engine/11431] ALLOC_ENGINE_V6_ALLOC_ERROR duid=[00:01:00:01:1e:da:f1:1b:b8:27:eb:8f:fe:67], tid=0x2cec69: error during attempt to allocate an IPv6 address: unable to bind parameters for <INSERT INTO lease6(address, duid, valid_lifetime, expire, subnet_id, pref_lifetime, lease_type, iaid, prefix_len, fqdn_fwd, fqdn_rev, hostname, hwaddr, hwtype, hwaddr_source, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>, reason: (error code 0)
2018-05-28 11:54:01.657 ERROR [kea-dhcp4.alloc-engine/11424] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 b8:27:eb:da:12:3b], cid=[ff:eb:da:12:3b:00:01:00:01:1e:da:f1:13:b8:27:eb:8f:47:6e], tid=0xde2380dc: error during attempt to allocate an IPv4 address: unable to bind parameters for <INSERT INTO lease4(address, hwaddr, client_id, valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev, hostname, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>, reason: (error code 0)
There seemed to be a similar problem mentioned in the forums, but there does not seem to anything which matches this.
It was mentioned something to do with timers, but I have them now set to: "reclaim-timer-wait-time": 100, "flush-reclaimed-timer-wait-time": 250, "hold-reclaimed-time": 36000, "max-reclaim-leases": 1000, "max-reclaim-time": 2500, "unwarned-reclaim-cycles": 5 ... "valid-lifetime": 36000, "renew-timer": 9000, "rebind-timer": 18000,
What is strange though, when I take a tcpdump of the connection, I see a number of packets setting SOME of the bind fields, most seem to be set to the the IP address which kea attempts to assign.
It's as if all the bind fields are corrupted.