<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font size="4">list members,</font></p>
<p><font size="4">i am trying to migrate to Kea and have 2 HA+MT
instances stood up. when i start relaying dhcp requests to Kea,
i get bunch of failed attempts to obtain leases on the clients,
which i believe is due to the clients not having active leases
from Kea. i am wondering if there is a means to have the
clients get new assigned leases without having to jump through
hoops like reboots.</font></p>
<p><font size="4">as an aside, i also find the below error in my
logs, which seems to indicate a malformed database query.<br>
</font></p>
<p><font size="4">ERROR [kea-dhcp4.database.139901550986944]
DATABASE_MYSQL_FATAL_ERROR Unrecoverable MySQL error occurred:
unable to execute for <SELECT address, hwaddr, client_id,
valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev, hostname,
state, user_context, relay_id, remote_id, pool_id FROM lease4
WHERE client_id = ?>, reason: Lost connection to server
during query (error code: 2013).<br>
</font></p>
<p><font size="4">the select, if pasted into any mariadb client,
fails since the "?" is not proper syntax. i dont know if the
behavior i am seeing with the clients not getting new leases and
the database error above are related or if there are a couple of
issues to be worked through.</font></p>
<p><font size="4">what info should i provide, to understand where i
have issues to address? i am running Kea 2.4.0 on fedora 38.</font></p>
<p><font size="4">thanks in advance,</font></p>
<p><font size="4">brendan<br>
</font></p>
<p>
<style type="text/css"><font size="4">body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }comment { display:none; }</font></style></p>
</body>
</html>