[Pdns-users] Need help after the upgrade

[Kevin P. Fleming]

"Lost connection to server during query" means the database server shut down, or crashed, or soemthing.

On Wed, Feb 26, 2025, at 16:48, Peter Zoltan Keresztes (zozo) via Pdns-users wrote:
> Hello 
>
> I had a powerdns server and the server died for some hardware issues 
> during the day. Since I did not remember what version of powerdns it 
> was running at I deployed a new server and deployed the latest stable 
> version on it. Then because of mismatches in the database I have found 
> out that it was something like 4.3 therefore I run the sql migration 
> script to make it compatible with 4.7 schema. Now the powerdns keep 
> failing with the following error:
>
> Feb 26 16:25:44 dns-2 systemd[1]: Starting PowerDNS Authoritative 
> Server...
> Feb 26 16:25:44 dns-2 pdns_server[9754]: Loading 
> '/usr/lib64/pdns/libgmysqlbackend.so'
> Feb 26 16:25:44 dns-2 pdns_server[9754]: This is a standalone pdns
> Feb 26 16:25:44 dns-2 pdns_server[9754]: Listening on controlsocket in 
> '/run/pdns/pdns.controlsocket'
> Feb 26 16:25:44 dns-2 pdns_server[9754]: 'domain-metadata-cache-ttl' is 
> deprecated and will be removed in a future release, use 
> 'zone-metadata-cache-ttl' instead
> Feb 26 16:25:44 dns-2 pdns_server[9754]: UDP server bound to 0.0.0.0:53
> Feb 26 16:25:44 dns-2 pdns_server[9754]: UDP server bound to [::]:53
> Feb 26 16:25:44 dns-2 pdns_server[9754]: TCP server bound to 0.0.0.0:53
> Feb 26 16:25:44 dns-2 pdns_server[9754]: TCP server bound to [::]:53
> Feb 26 16:25:44 dns-2 pdns_server[9754]: PowerDNS Authoritative Server 
> 4.9.4 (C) PowerDNS.COM BV
> Feb 26 16:25:44 dns-2 pdns_server[9754]: Using 64-bits mode. Built 
> using gcc 11.5.0 20240719 (Red Hat 11.5.0-2.0.1) on Feb  6 2025 
> 15:25:48 by root at localhost.
> Feb 26 16:25:44 dns-2 pdns_server[9754]: PowerDNS comes with ABSOLUTELY 
> NO WARRANTY. This is free software, and you are welcome to redistribute 
> it according to the terms of the GPL version 2.
> Feb 26 16:25:44 dns-2 pdns_server[9754]: [webserver] Listening for HTTP 
> requests on 0.0.0.0:8082
> Feb 26 16:25:44 dns-2 pdns_server[9754]: Polled security status of 
> version 4.9.4 at startup, no known issues reported: OK
> Feb 26 16:25:54 dns-2 pdns_server[9754]: PDNSException while filling 
> the zone cache: Database error trying to retrieve all domains:Could not 
> execute mysql statement: select domains.id, domains.name, 
> records.content, domains.type, domains.master, domains.notified_serial, 
> domains.last_check, domains.account, domains.catalog from domains LEFT 
> JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND 
> records.name=domains.name WHERE records.disabled=0 OR ?: Lost 
> connection to server during query
> Feb 26 16:25:54 dns-2 systemd[1]: pdns.service: Main process exited, 
> code=exited, status=1/FAILURE
> Feb 26 16:25:54 dns-2 systemd[1]: pdns.service: Failed with result 
> 'exit-code'.
> Feb 26 16:25:54 dns-2 systemd[1]: Failed to start PowerDNS 
> Authoritative Server.
>
> Any idea how can I fix it at least to a state where I can export the 
> zones to some files so that I could reimport them in a new installation 
> with new database.
>
> Regards,
> Peter
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
> Attachments:
> * signature.asc