PowerDNS broken after upgrade to Bookworm
PowerDNS was upgraded from 4.4.1 (Bullseye) to 4.7.3 (Bookworm) and is now broken:
zen@dns ~> sudo pdnsutil edit-zone tails.boum.org
Oct 12 14:21:56 [bindbackend] Done parsing domains, 0 rejected, 0 new, 0 removed
Error: GSQLBackend unable to retrieve information about domain 'tails.boum.org': Could not prepare statement: select id,name,master,last_check,notified_serial,type,options,catalog,account from domains where name=?: Unknown column 'options' in 'field list'
Upgrade notes:
To do
-
Increase system disk size -
Update the SQL schema -
Check whether we use @
in SOA'sRNAME
and replace it in that case (pdnsutil check-all-zones
) -
Check if we use one of CSYNC, IPSECKEY, NID, L32, L64, LP, SVCB and HTTPS and act accordingly in that case -
Rename renamed options in case we use any. -
Make sure we don't rely on changed defaults -
Check if we use any of the removed options -
Make sure we don't rely on changed NSEC3 defaults
Edited by Zen Fu