On 4/17/24 5:49 AM, Peter Davies wrote:
Hi Brendan,
It is not possible to see any details from this logging.
You should check your haproxy configuration, Kea cannot continue
processing
requests if it is unable to connect to the lease database.
I suggest that you temporarily enable Severity DEBUG and debuglevel 99
so you
can see requests and how Kea is processing them.
As all your reservations are global, you should define
"reservations-global": true,"
the default is false.
All pools are guarded by client classes. The client may not be
associated with
any of these classes.
/Peter
digging back into the database issue, i found the following messages in
"journactl -lu kea-dhcp4":
Oct 15 20:34:43 server1 systemd[1]: Started kea-dhcp4.service - Kea
DHCPv4 Server.
Oct 15 20:34:43 server1 kea-dhcp4[1930]: 2024-10-15 20:34:43.848
INFO [kea-dhcp4.dhcp4/1930.140675063382400] DHCP4_STARTING Kea
DHCPv4 server version 2.4.0 (stable) starting
Oct 16 03:24:44 server1 kea-dhcp4[1930]: 2024-10-16 03:24:44.303
ERROR [kea-dhcp4.database/1930.140675063382400]
DATABASE_MYSQL_FATAL_ERROR Unrecoverable MySQL error occurred:
unable to execute for <SELECT a.id, a.object_type, a.object_id,
a.modification_type, r.modification_ts, r.id, r.log_message FROM
dhcp4_audit AS a INNER JOIN dhcp4_audit_revision AS r ON
a.revision_id = r.id INNER JOIN dhcp4_server AS s ON r.server_id =
s.id WHERE (s.tag = ? OR s.id = 1) AND ((r.modification_ts, r.id) >
(?, ?)) ORDER BY r.modification_ts, r.id>, reason: Lost connection
to server during query (error code: 2013).
Oct 16 03:24:44 server1 kea-dhcp4[1930]: 2024-10-16 03:24:44.303
ERROR [kea-dhcp4.dhcp4/1930.140675063382400]
DHCP4_CB_PERIODIC_FETCH_UPDATES_FAIL error on periodic attempt to
fetch configuration updates from the configuration backend(s): fatal
database error or connectivity lost
Oct 16 03:24:44 server1 systemd[1]: kea-dhcp4.service: Main process
exited, code=exited, status=1/FAILURE
Oct 16 03:24:44 server1 systemd[1]: kea-dhcp4.service: Failed with
result 'exit-code'.
Oct 16 03:24:44 server1 systemd[1]: kea-dhcp4.service: Consumed
14.206s CPU time.
there is a select statement in the logs that failed and killed the
instance. i took the select statement in the logs and ran it in a
mariadb client, phpMyAdmin. when i submitted the query, i got the
following error info back:
Error
Static analysis:
3 errors were found during analysis.
Variable name was expected. (near "?" at position 261)
Variable name was expected. (near "?" at position 310)
Variable name was expected. (near "?" at position 313)
SQL query: Copy Documentation
SELECT a.id, a.object_type, a.object_id, a.modification_type,
r.modification_ts, r.id, r.log_message FROM dhcp4_audit AS a INNER
JOIN dhcp4_audit_revision AS r ON a.revision_id = r.id INNER JOIN
dhcp4_server AS s ON r.server_id = s.id WHERE (s.tag = ? OR s.id =
1) AND ((r.modification_ts, r.id) > (?, ?)) ORDER BY
r.modification_ts, r.id LIMIT 0, 25
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to
use near '? OR s.id = 1) AND ((r.modification_ts, r.id) > (?, ?))
ORDER BY r.modificati...' at line 1
the problem is not my database or connectivity to it. the issues is a
malformed query, that uses question marks ( ? ) which seem to be invalid
characters. i logged into the database using the mysql command line
client and issued the same query, to be sure the error was not related
to something in phpMyAdmin, and i got the following error info back:
MariaDB [kea]> SELECT a.id, a.object_type, a.object_id,
a.modification_type, r.modification_ts, r.id, r.log_message FROM
dhcp4_audit AS a INNER JOIN dhcp4_audit_revision AS r ON
a.revision_id = r.id INNER JOIN dhcp4_server AS s ON r.server_id =
s.id WHERE (s.tag = ? OR s.id = 1) AND ((r.modification_ts, r.id) >
(?, ?)) ORDER BY r.modification_ts, r.id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near '? OR s.id = 1) AND ((r.modification_ts, r.id) >
(?, ?)) ORDER BY r.modificati...' at line 1
from the looks of things, there is a malformed query and the error
causes the kea instance to fail. is there a "dialect" issue with the
way the db query is formulated/constructed in kea for mariadb vs
postgresql? i dont have a postgresql instance handy to test against.
given the ERROR, not WARNING, status of the log message, i would assume
that the malformed query causes the resulting failure of the instance
because kea cannot continue. how do i figure a way past these errors?
thanks,
brendan
--
ISC funds the development of this software with paid support subscriptions.
Contact us at https://www.isc.org/contact/ for more information.
To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.
Kea-users mailing list
Kea-users@lists.isc.org
https://lists.isc.org/mailman/listinfo/kea-users
