[Bug 267363] dns/powerdns broken after upgrade, mandatory schema changes not included or hinted

From: <bugzilla-noreply_at_freebsd.org>
Date: Wed, 26 Oct 2022 12:42:02 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=267363

            Bug ID: 267363
           Summary: dns/powerdns broken after upgrade, mandatory schema
                    changes not included or hinted
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: freebsd@bengrimm.net
                CC: tremere@cainites.net
             Flags: maintainer-feedback?(tremere@cainites.net)
                CC: tremere@cainites.net

PowerDNS 4.7.0 comes with a mandatory schema change. When upgrading from 4.6.x
there is not a single indication when installing the package that that is
necessary. It should probably also feature prominently in UPGRADING. Note that
the mandatory schema change is also not present in
/usr/local/share/doc/powerdns. The schema upgrades there fall versionS behind
and this should be rectified.

Current problem in PowerDNS (upgraded from 4.6.x to 4.7.0):

Oct 26 14:18:26 authdns1 pdns[5356]: Backend reported permanent error which
prevented lookup (GSQLBackend unable to retrieve information about domain
'xxxxx': 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'), aborting

(times 1 for every zone)

-- 
You are receiving this mail because:
You are the assignee for the bug.