Bug 2186505

Description of problem:

An overnight automated update of the package pdns-backend-sqlite-4.6.2-1.el8.x86_64 to pdns-backend-sqlite-4.7.3-1.el8.x86_64 (together with the related pdns base packages) resulted in the pdns server being unable to start, because there is a mandatory schema change described at https://doc.powerdns.com/authoritative/upgrading.html when updating to 4.7. The package did not carry out this schema change, and consequently pdns_server exits on every start attempt with:

Exiting because communicator thread died with error: virtual v
oid GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&, std::unordered_set<DNSName>&, CatalogHashMap&) unable to retrieve list of master domains: Unable to compile SQLite statement : 'select domains.id, domains.name, domains.type, domains.notified_serial, domains.options, domains.catalog, records.content from records join domains on records.domain_id=domains.id and records.name=domains.name where records.type='SOA' and records.disabled=0 and domains.type in ('MASTER', 'PRODUCER')': no such column: domains.options (1)

Version-Release number of selected component (if applicable):

pdns-backend-sqlite-4.7.3-1.el8.x86_64

How reproducible:

Every time

Steps to Reproduce:
1. Set up PDNS to use the SQLite back-end in version 4.6.
2. Update

Actual results:

Crashes with the above error message.

Expected results:

Schema is updated automatically and server is able to start.

Additional info:

I resolved this in my case by researching and running the schema update manually. I report the error for the benefit of others.