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

[Paul Gevers]

Control: severity -1 serious

Dear maintainer(s),

With a recent upload of postgresql-q3c the autopkgtest of gavodachs 
fails in testing during installation of gavodachs-server when that 
autopkgtest is run with the binary packages of postgresql-q3c from 
unstable. It passes when run with only packages from testing. In tabular 
form:

                        pass            fail
postgresql-q3c         from testing    2.0.1-5
gavodachs              from testing    2.11+dfsg-2
all others             from testing    from testing

I copied some of the output at the bottom of this report. Normally I 
would file a new report for issues like this, but the symptoms look very 
much like bug 984555, so I decided to update that. If think this is a 
new bug, let me know and I file another one. gavodachs2-server currently 
fails to install in unstable too.

Currently this regression is blocking the migration of a bunch of 
packages to testing [1] as postgresql-q3c gets pulled in from unstable 
even if not explicitly asked by the migration software; I very much 
assume because the default postgresql got recently updated and the 
version of postgresql-q3c in unstable was rebuild to support the new 
version. Can you please investigate the situation?

More information about this bug and the reason for filing it can be found on
https://wiki.debian.org/ContinuousIntegration/RegressionEmailInformation

Paul

[1] https://qa.debian.org/excuses.php?package=postgresql-q3c

https://ci.debian.net/packages/g/gavodachs/testing/amd64/65287321/

  92s /usr/lib/python3/dist-packages/gavo/user/initdachs.py:316: 
UserWarning: SQL script file for 
/usr/share/postgresql/contrib/pg_sphere.sql not found.  There are many 
reasons why that may be ok, but unless you know what you are doing, you 
probably should install the corresponding postgres extension.
  92s   warnings.warn("SQL script file for %s not found.  There are many"
  92s *** DaCHS init failed: Early import of adql.ufunctions: 
sqlsupport not initialised yet.
  92s Pass --debug for a traceback.
  94s > add an author column to dc.services if necessary...*** Error: 
While executing DB query:
  94s
  94s   SELECT * FROM dc.resources LIMIT 1
  94s
  94s The database engine reported:
  94s
  94s   ERROR:  relation "dc.resources" does not exist
  94s LINE 1: SELECT * FROM dc.resources LIMIT 1
  94s                       ^
  94s
  94s dpkg: error processing package gavodachs2-server (--configure):
  94s  installed gavodachs2-server package post-installation script 
subprocess returned error exit status 1
  94s Errors were encountered while processing:
  94s  gavodachs2-server
  95s E: Sub-process /usr/bin/dpkg returned an error code (1)
  95s E: Failed to process build dependencies

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 585 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/debian-astro-maintainers/attachments/20251019/41d3322b/attachment-0001.sig>