[Kea-users] kea 1.3.0 dying with mysql error

[Satish Patel]

I have configured kea 1.3.0 with mysql and everything works but after
few hours found kea is dead and spotted following error in log, I have
check everything mysql running fine everything looks good in DB.


2018-06-15 11:48:55.798 INFO  [kea-dhcp4.dhcp4/16020] DHCP4_STARTED
Kea DHCPv4 server version 1.3.0 started
2018-06-15 12:01:29.048 ERROR [kea-dhcp4.dhcpsrv/16020]
DHCPSRV_MYSQL_FATAL_ERROR Unrecoverable MySQL error occurred: unable
to execute for <SELECT h.host_id, h.dhcp_identifier,
h.dhcp_identifier_type, h.dhcp4_subnet_id, h.dhcp6_subnet_id,
h.ipv4_address, h.hostname, h.dhcp4_client_classes,
h.dhcp6_client_classes, h.dhcp4_next_server, h.dhcp4_server_hostname,
h.dhcp4_boot_file_name, o.option_id, o.code, o.value,
o.formatted_value, o.space, o.persistent FROM hosts AS h LEFT JOIN
dhcp4_options AS o ON h.host_id = o.host_id WHERE h.dhcp4_subnet_id =
? AND h.dhcp_identifier_type = ?    AND h.dhcp_identifier = ? ORDER BY
h.host_id, o.option_id>, reason: MySQL server has gone away (error
code: 2006). Server exiting now!
2018-06-15 12:01:29.055 INFO  [kea-dhcp4.legal-log/16020]
LEGAL_LOG_FILE_CLOSED  @@Missing placeholder %1 for
'/var/log//kea-forensic4.20180615.txt'@@
2018-06-15 12:01:29.056 INFO  [kea-dhcp4.hooks/16020]
HOOKS_LIBRARY_UNLOADED hooks library
/usr/lib64/hooks/libdhcp_legal_log.so successfully unloaded
2018-06-15 12:01:29.056 INFO  [kea-dhcp4.lease_cmds_hooks/16020]
LEASE_CMDS_DEINIT_OK
2018-06-15 12:01:29.056 INFO  [kea-dhcp4.hooks/16020]
HOOKS_LIBRARY_UNLOADED hooks library
/usr/lib64/hooks/libdhcp_lease_cmds.so successfully unloaded
2018-06-15 12:01:29.056 INFO  [kea-dhcp4.host_cmds_hooks/16020]
HOST_CMDS_DEINIT_OK
2018-06-15 12:01:29.056 INFO  [kea-dhcp4.hooks/16020]
HOOKS_LIBRARY_UNLOADED hooks library
/usr/lib64/hooks/libdhcp_host_cmds.so successfully unloaded