Kea DHCP4 doesnt recover on pgsql server restart
Iam using the postgres as backed for lease-database. When the postgres server becomes unreachable for say 5 minutes, I see the DHCP4 server exiting though I have added configuration for reconnect and max retries. The DHCP4 server remains stalled and doesnt recover even though the POstgres DB is up and running.
loaded 2020-06-21 17:45:07.474 INFO [kea-dhcp4.dhcp4/59] DHCP4_CONFIG_COMPLETE DHCPv4 server has completed configuration: added IPv4 subnets: 1; DDNS: enabled 2020-06-21 17:45:07.474 DEBUG [kea-dhcp4.dhcpsrv/59] DHCPSRV_CLOSE_DB closing currently open postgresql database 2020-06-21 17:45:07.475 ERROR [kea-dhcp4.database/59] DATABASE_PGSQL_DEALLOC_ERROR An error occurred deallocating SQL statements while closing the PostgreSQL lease database: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
2020-06-21 17:45:07.475 INFO [kea-dhcp4.dhcpsrv/59] DHCPSRV_PGSQL_DB opening PostgreSQL lease database: host=172.17.0.1 lfc-interval=3600 max-reconnect-tries=10 name=dhcp password=***** reconnect-wait-time=3000 type=postgresql universe=4 user=dhcp4 2020-06-21 17:45:07.475 ERROR [kea-dhcp4.dhcp4/59] DHCP4_CONFIG_LOAD_FAIL configuration error using file: /etc/kea/kea-dhcp4.conf, reason: Unable to open database: could not connect to server: Connection refused Is the server running on host "172.17.0.1" and accepting TCP/IP connections on port 5432?
2020-06-21 17:45:07.475 ERROR [kea-dhcp4.dhcp4/59] DHCP4_DYNAMIC_RECONFIGURATION_FAIL dynamic server reconfiguration failed with file: /etc/kea/kea-dhcp4.conf { "result": 1, "text": "Config reload failed: configuration error using file '/etc/kea/kea-dhcp4.conf': Unable to open database: could not connect to server: Connection refused\n\tIs the server running on host "172.17.0.1" and accepting\n\tTCP/IP connections on port 5432?\n" }2020-06-21 17:45:07.475 DEBUG [kea-dhcp4.commands/59] COMMAND_SOCKET_WRITE Sent response of 279 bytes (0 bytes left to send) over command socket 27 2020-06-21 17:45:07.476 DEBUG [kea-dhcp4.commands/59] COMMAND_SOCKET_CONNECTION_CLOSED Closed socket 27 for existing command connection ^
Config details: "lease-database": { "type": "postgresql", "name": "dhcp", "password": "test123", "host": "172.17.0.1", "user": "dhcp4", "lfc-interval": 3600, "max-reconnect-tries" : 10 , "reconnect-wait-time" : 3000 },
Is there something Iam missing. Why isn't DHCP server recovering.