Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 877831 - net-dns/pdns-4.7.0: sql schema migration script missing
Summary: net-dns/pdns-4.7.0: sql schema migration script missing
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal critical (vote)
Assignee: Sven Wegener
URL: https://doc.powerdns.com/authoritativ...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-21 10:29 UTC by Daniel Kenzelmann
Modified: 2022-11-01 19:44 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Kenzelmann 2022-10-21 10:29:14 UTC
When using pdns with postgresql, pdns will fail after upgrade. 

As per https://doc.powerdns.com/authoritative/upgrading.html , the schema needs to be updated:
===
The new Catalog Zones feature comes with a mandatory schema change for the gsql database backends. See files named 4.3.x_to_4.7.0_schema.X.sql for your database backend in our Git repo, tarball, or distro-specific documentation path.
===

However that file is not available (not even in pdns-4.7.0.tar.bz2)
Maybe an upstream failure to provide it? However it might be a good idea to not yet update to 4.7.0 as long as the schema can not be updated.


Reproducible: Always

Steps to Reproduce:
1. Use pdns with postgresql
2. Update to 4.7.0
3. pdns fails
Comment 1 Daniel Kenzelmann 2022-10-21 10:34:06 UTC
Seems to be fixed upstream:

https://github.com/PowerDNS/pdns/issues/12108

Now how to make sure this arrives here? :D
Comment 2 Daniel Kenzelmann 2022-11-01 19:44:44 UTC
Fixed in 4.7.2