Bug#1051703: pdns-backend-pgsql: No mention of schema updates in NEWS despite breaking service

[Dan Poltawski]

Package: pdns-backend-pgsql
Version: 4.7.3-2
Severity: important

Dear Maintainer,

Upon upgrading, manual steps are required to update the schema of the SQL tables as mentioned upstream here:

https://doc.powerdns.com/authoritative/upgrading.html#schema-changes

Unfortunately I did not find this mentioned in NEWS or changelog leading to errors on upgrade:

---
Exiting because communicator thread died with error: virtual void GSQLBackend::getUpdatedMasters(std::vector<DomainInfo>&, std::unordered_set<DNSName>&, CatalogHashMap&) unable to retrieve list of master domains: Fatal error during prePQpreparepare: 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=false and domains.type in ('MASTER', 'PRODUCER'): ERROR: column domains.options does not exist
---

I suggest these changes are mentioned in the debian upgrades notes

thanks,
Dan



-- System Information:
Debian Release: 12.1
APT prefers stable-security
APT policy: (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.1.0-12-amd64 (SMP w/2 CPU threads; PREEMPT)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages pdns-backend-pgsql depends on:
ii libc6 2.36-9+deb12u1
ii libgcc-s1 12.2.0-14
ii libpq5 15.3-0+deb12u1
ii libstdc++6 12.2.0-14
ii pdns-server 4.7.3-2

pdns-backend-pgsql recommends no packages.

Versions of packages pdns-backend-pgsql suggests:
pn postgresql <none>

-- no debconf information

[Chris Hofstaedtler]

Hi,

* Dan Poltawski <dan.po...@tnp.net.uk> [230911 15:21]:

> Upon upgrading, manual steps are required to update the schema of the SQL tables as mentioned upstream here:
>
> https://doc.powerdns.com/authoritative/upgrading.html#schema-changes
>
> Unfortunately I did not find this mentioned in NEWS or changelog leading to errors on upgrade:

This is currently documented in:

* README.Debian files in each individual pdns-backend-* package
* NEWS file of pdns-server

Duplicating this info into NEWS for each individual pdns-backend-*
package could be done for trixie, but I think it's a bit much.

Chris