[Debian-astro-maintainers] Bug#984555: gavodachs2-server: fails to install/upgrade. breaks on executing SQL script.

[Andreas Beckmann]

Followup-For: Bug #984555

Hi,

I can also reproduce this in a piuparts test.

I think I have an idea what is happening: The upgrade from buster to
bullseye does not install postgresql-13-pgsphere and postgresql-13-q3c
but keeps postgresql-pgsphere and postgresql-q3c from buster installed.
This is a problem of the postgresql-* packages which switched from real
packages postgresql-foo providing virtual postgresql-xx-foo to real
packages postgresql-xx-foo providing virtual postgresql-foo.
IMO it was wrong turning postgresql-foo into virtual packages,
especially if multiple postgresql-xx-foo are expected to be
co-installable, s.t. there are multiple packages providing
postgresql-foo at the same time. postgresql-foo should have stayed a
real package depending on the default version of postgresql-xx-foo.

apt-get does not upgrade installed real packages to other packages
providing the old package name. It just happily keeps the old stuff from
buster installed which does satisfy the dependencies of
gavodachs2-server.

I think you could work around that in gavodachs2-server by stopping to
allow so many alternatives:

  Depends: adduser, members, postgresql-pgsphere | postgresql-11-pgsphere | postgresql-9.6-pgsphere | postgresql-9.4-pgsphere, postgresql-q3c | postgresql-11-q3c | postgresql-9.6-q3c | postgresql-9.4-q3c, python3-gavo (= 2.3+dfsg-2)

and reducing that to

  Depends: adduser, members, postgresql-13-pgsphere, postgresql-13-q3c, python3-gavo (= 2.3+dfsg-2)

and we should see to get this fixed on the postgresql-foo side for
bookworm s.t. you can use

  Depends: adduser, members, postgresql-pgsphere (>= ...), postgresql-q3c (>= ...), python3-gavo (= 2.3+dfsg-2)

afterwards.

Perhaps also a

  Breaks: postgresql-pgsphere (<< 1.1.1+2020), postgresql-q3c (<< 2)

would work for the upgrades to bullseye.


Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: astro-all_3.0.log.gz
Type: application/gzip
Size: 428785 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/debian-astro-maintainers/attachments/20210503/5af4c54e/attachment-0001.gz>