[Pdns-users] Need help after the upgrade

[Peter Zoltan Keresztes (zozo)]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: Message signed with OpenPGP
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250226/cb279f64/attachment.sig>