<div dir="ltr"><div class="gmail_default" style="font-size:small">Follow my configuration:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">kea-dhcp4.conf:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><span style="font-family:monospace">{<br>  "Dhcp4": {<br>    "authoritative": false,<br>    "boot-file-name": "",<br>    "calculate-tee-times": false,<br>    "control-socket": {<br>      "socket-name": "/tmp/kea4-ctrl-socket",<br>      "socket-type": "unix"<br>    },<br>    "ddns-generated-prefix": "myhost",<br>    "ddns-override-client-update": false,<br>    "ddns-override-no-update": false,<br>    "ddns-qualifying-suffix": "",<br>    "ddns-replace-client-name": "never",<br>    "ddns-send-updates": true,<br>    "decline-probation-period": 86400,<br>    "dhcp-ddns": {<br>      "enable-updates": false,<br>      "max-queue-size": 1024,<br>      "ncr-format": "JSON",<br>      "ncr-protocol": "UDP",<br>      "sender-ip": "0.0.0.0",<br>      "sender-port": 0,<br>      "server-ip": "127.0.0.1",<br>      "server-port": 53001<br>    },<br>    "dhcp-queue-control": {<br>      "capacity": 64,<br>      "enable-queue": false,<br>      "queue-type": "kea-ring4"<br>    },<br>    "dhcp4o6-port": 0,<br>    "echo-client-id": true,<br>    "expired-leases-processing": {<br>      "flush-reclaimed-timer-wait-time": 25,<br>      "hold-reclaimed-time": 3600,<br>      "max-reclaim-leases": 100,<br>      "max-reclaim-time": 250,<br>      "reclaim-timer-wait-time": 10,<br>      "unwarned-reclaim-cycles": 5<br>    },<br>    "hooks-libraries": [ ],<br>    "host-reservation-identifiers": [ "hw-address", "duid", "circuit-id", "client-id" ],<br>    "hostname-char-replacement": "",<br>    "hostname-char-set": "[^A-Za-z0-9.-]",<br>    "interfaces-config": {<br>      "interfaces": [ "ens3" ],<br>      "re-detect": true<br>    },<br>    "lease-database": {<br>      "host": "dbhost.localdomin",<br>      "name": "dbname",<br>      "password": "secret",<br>      "port": 5432,<br>      "type": "postgresql",<br>      "user": "dbuser"<br>    },<br>    "loggers": [<br>      {<br>        "debuglevel": 99,<br>        "name": "kea-dhcp4",<br>        "output_options": [<br>          {<br>            "output": "/usr/local/var/log/kea-dhcp4.log"<br>          }<br>        ],<br>        "severity": "INFO"<br>      }<br>    ],<br>    "match-client-id": true,<br>    "multi-threading": {<br>      "enable-multi-threading": false,<br>      "packet-queue-size": 64,<br>      "thread-pool-size": 0<br>    },<br>    "next-server": "0.0.0.0",<br>    "option-data": [ ],<br>    "option-def": [ ],<br>    "rebind-timer": 2000,<br>    "renew-timer": 1000,<br>    "reservation-mode": "all",<br>    "sanity-checks": {<br>      "lease-checks": "warn"<br>    },<br>    "server-hostname": "",<br>    "server-tag": "",<br>    "shared-networks": [ ],<br>    "statistic-default-sample-age": 0,<br>    "statistic-default-sample-count": 20,<br>    "store-extended-info": false,<br>    "subnet4": [<br>      {<br>        "4o6-interface": "",<br>        "4o6-interface-id": "",<br>        "4o6-subnet": "",<br>        "calculate-tee-times": false,<br>        "id": 1,<br>        "option-data": [ ],<br>        "pools": [<br>          {<br>            "option-data": [ ],<br>            "pool": "192.168.0.10-192.168.0.13"<br>          }<br>        ],<br>        "rebind-timer": 2000,<br>        "relay": {<br>          "ip-addresses": [ ]<br>        },<br>        "renew-timer": 1000,<br>        "reservations": [<br>          {<br>            "boot-file-name": "",<br>            "client-classes": [ ],<br>            "hostname": "",<br>            "hw-address": "00:50:01:00:01:00",<br>            "ip-address": "192.168.0.12",<br>            "next-server": "0.0.0.0",<br>            "option-data": [ ],<br>            "server-hostname": ""<br>          }<br>        ],<br>        "store-extended-info": false,<br>        "subnet": "<a href="http://192.168.0.0/24">192.168.0.0/24</a>",<br>        "t1-percent": 0.5,<br>        "t2-percent": 0.875,<br>        "valid-lifetime": 4000<br>      }<br>    ],<br>    "t1-percent": 0.5,<br>    "t2-percent": 0.875,<br>    "valid-lifetime": 4000<br>  }<br>}</span></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Regards,</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Jerônimo<br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em qua., 7 de jul. de 2021 às 03:42, Gordon Ross <<a href="mailto:gr306@cam.ac.uk">gr306@cam.ac.uk</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">My configuration is very simple. There are no hooks, no HA, no multi-threading, no fancy commands.<br>
<br>
Postgres version is 12.7<br>
<br>
Gordon.<br>
<br>
On 06/07/2021, 19:27, "Marcin Siodelski" <<a href="mailto:marcin@isc.org" target="_blank">marcin@isc.org</a>> wrote:<br>
<br>
    Gordon,<br>
<br>
    Thanks for posting your issue to the Kea users list. I will try to<br>
    replicate your issue tomorrow with the Postgres lease database backend.<br>
<br>
    It will be super useful if you send me your Kea configuration file. You<br>
    can sanitize it from any private stuff it may contain. Please send it to<br>
    me privately if it can't be posted to the mail list.<br>
<br>
    If it is not possible, please describe the major parts of the<br>
    configuration, e.g. is multi threading on or off, are you using any<br>
    hooks libraries (e.g. lease cmds?), are you sending any commands to Kea<br>
    that can possibly modify the lease information?<br>
<br>
    Finally, please provide your Postgres database version.<br>
<br>
    Kind Regards,<br>
<br>
    Marcin Siodelski<br>
    DHCP Software Engineer,<br>
    ISC<br>
<br>
<br>
    On 06.07.2021 18:28, Gordon Ross wrote:<br>
    > On the off chance, I tried an upgrade to Kea 1.9.9 and the problem persists.<br>
    > <br>
    > Gordon.<br>
    > <br>
    > On 05/07/2021, 16:16, "Kea-users on behalf of Gordon Ross" <<a href="mailto:kea-users-bounces@lists.isc.org" target="_blank">kea-users-bounces@lists.isc.org</a> on behalf of <a href="mailto:gr306@cam.ac.uk" target="_blank">gr306@cam.ac.uk</a>> wrote:<br>
    ><br>
    >     I'm running Kea 1.8.2 using the Postgres lease database backend on Ubuntu 20.04 LTS<br>
    > <br>
    >     Devices can get a new IPv4 address fine. But when they try to renew their address, it fails and the logs show:<br>
    > <br>
    >     ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:21:55:02:67:14], cid=[01:00:21:55:02:67:14], tid=0x58cd: error during attempt to allocate an IPv4 address: unable to update lease for address 172.18.5.4 as it does not exist<br>
    > <br>
    >     If I delete the entry from the leases table, Kea then happily re-issues the address. (I can perform the DELETE as the Kea DB user so no permissions problems there)<br>
    > <br>
    >     I saw an earlier post about an error in Kea 1.8 & HA, but I'm not running HA at the moment - and I'm on a later version of Kea.<br>
    > <br>
    >     Is this bug still outstanding in 1.8.2?<br>
    > <br>
    >     Thank you,<br>
    > <br>
    >     Gordon<br>
    >     -- <br>
    >     Gordon Ross <br>
    >     University of Cambridge<br>
    > <br>
    >     _______________________________________________<br>
    >     ISC funds the development of this software with paid support subscriptions. Contact us at <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=eq9EslaePYR9Eju%2FOHp5krzAwc5A70FQoLe4KdFY%2BRo%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=eq9EslaePYR9Eju%2FOHp5krzAwc5A70FQoLe4KdFY%2BRo%3D&amp;reserved=0</a> for more information.<br>
    > <br>
    >     To unsubscribe visit <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0</a>.<br>
    > <br>
    >     Kea-users mailing list<br>
    >     <a href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a><br>
    >     <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0</a><br>
    > <br>
    > _______________________________________________<br>
    > ISC funds the development of this software with paid support subscriptions. Contact us at <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=eq9EslaePYR9Eju%2FOHp5krzAwc5A70FQoLe4KdFY%2BRo%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.isc.org%2Fcontact%2F&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=eq9EslaePYR9Eju%2FOHp5krzAwc5A70FQoLe4KdFY%2BRo%3D&amp;reserved=0</a> for more information.<br>
    > <br>
    > To unsubscribe visit <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0</a>.<br>
    > <br>
    > Kea-users mailing list<br>
    > <a href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a><br>
    > <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0" rel="noreferrer" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.isc.org%2Fmailman%2Flistinfo%2Fkea-users&amp;data=04%7C01%7Cgr306%40cam.ac.uk%7Ca279f324acc84a66ab3c08d940abad12%7C49a50445bdfa4b79ade3547b4f3986e9%7C0%7C0%7C637611928779424476%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=YHLKNqq5nZhFHWcrtxTNLHtrtGRjHsXGKIZoPwTTLLM%3D&amp;reserved=0</a><br>
    > <br>
<br>
<br>
_______________________________________________<br>
ISC funds the development of this software with paid support subscriptions. Contact us at <a href="https://www.isc.org/contact/" rel="noreferrer" target="_blank">https://www.isc.org/contact/</a> for more information.<br>
<br>
To unsubscribe visit <a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/kea-users</a>.<br>
<br>
Kea-users mailing list<br>
<a href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/kea-users</a><br>
</blockquote></div>