"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@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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users > > Attachments: > * signature.asc _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
