Error trying to connect kea dhcp server through proxysql

[phoenix]

Hi all

I'm currently using ProxySQL version 1.4.0-0-ge2f0cc4 to access a mariadb galera cluster, all is working well except one minor hiccup with an installation of kea dhcp server. I've built the recent kea 1.2 froum source (no rpm available) and I can connect to an individual member of the cluster and use it for reservations it works well but when I try to go through proxysql I see the below errors:

2017-06-30 18:11:37.394 INFO  [kea-dhcp4.leases/28810] DHCP4_INIT_REBOOT [hwtype=1 00:0c:29:bc:bc:18], cid=[01:00:0c:29:bc:bc:18], tid=0xb3295339: client is in INIT-REBOOT state and requests address 192.168.1.162
2017-06-30 18:11:37.399 ERROR [kea-dhcp4.alloc-engine/28810] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:29:bc:bc:18], cid=[01:00:0c:29:bc:bc:18], tid=0xb3295339: 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: No data supplied for parameters in prepared statement (error code 0)
2017-06-30 18:11:38.407 INFO  [kea-dhcp4.leases/28810] DHCP4_LEASE_ADVERT [hwtype=1 00:0c:29:bc:bc:18], cid=[01:00:0c:29:bc:bc:18], tid=0xe05d9e18: lease 192.168.1.162 will be advertised
2017-06-30 18:11:38.413 ERROR [kea-dhcp4.alloc-engine/28810] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:29:bc:bc:18], cid=[01:00:0c:29:bc:bc:18], tid=0x8f445862: 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: No data supplied for parameters in prepared statement (error code 0)

Does this give any indication of where the problem might be or is there something I need to do in proxysql? I'm still a novice with proxysql so relatively simple answer would help me, if you don't mind. :)

I have the current 10.2.6 version of MariaDB installed and the version of kea that I've built shows this version in it's output:

kea-dhcp4 -V
1.2.0
tarball
linked with:
log4cplus 1.1.3
OpenSSL 1.0.1e-fips 11 Feb 2013
database:
MySQL backend 5.1, library 10.2.5
PostgreSQL backend 3.1, library 90218
Memfile backend 2.0

Regards


Bill;