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

[André Isidoro Fernandes Esteves]

Package: gavodachs2-server
Version: 2.3+dfsg-1
Severity: important

Dear Maintainer,


   * What led up to the situation?

broken install

   * What exactly did you do (or not do) that was effective (or
     ineffective)?

tried to update system. apt breaks on gavodachs2-server
package is probably broken

   * What was the outcome of this action?

from the output of apt:

A instalar gavodachs2-server (2.3+dfsg-1) ...
createdb: database creation failed: ERROR:  database "gavo" already exists
Creation of gavo database failed; assuming it's already there
and carrying on.
createuser: creation of new role failed: ERROR:  role "dachsroot" already exists
/usr/lib/python3/dist-packages/gavo/user/initdachs.py:310: 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.
  warnings.warn("SQL script file for %s not found.  There are many"
/usr/lib/python3/dist-packages/gavo/user/initdachs.py:328: UserWarning: SQL script file /usr/share/postgresql/contrib/pg_sphere.sql failed.  Try running manually using psql.  While it hasn't run, the pgSphere extension is not available.
  warnings.warn("SQL script file %s failed.  Try running manually"
/usr/lib/python3/dist-packages/gavo/user/initdachs.py:310: UserWarning: SQL script file for /usr/share/postgresql/contrib/q3c.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.
  warnings.warn("SQL script file for %s not found.  There are many"
/usr/lib/python3/dist-packages/gavo/user/initdachs.py:328: UserWarning: SQL script file /usr/share/postgresql/contrib/q3c.sql failed.  Try running manually using psql.  While it hasn't run, the q3c extension is not available.
  warnings.warn("SQL script file %s failed.  Try running manually"
*** Error: At /usr/lib/python3/dist-
packages/gavo/resources/inputs/__system__/adql.rd, line 166: Execution
of SQL script create_user_functions failed: type spoint does not exist

dpkg: erro ao processar o pacote gavodachs2-server (--configure):
 o subprocesso instalado, do pacote gavodachs2-server, o script post-installation retornou erro do status de saída 1


   * What outcome did you expect instead?

a clean instalation



-- System Information:
Debian Release: bullseye/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-3-amd64 (SMP w/8 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=pt_PT.UTF-8, LC_CTYPE=pt_PT.UTF-8 (charmap=UTF-8), LANGUAGE=pt:en_GB
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages gavodachs2-server depends on:
ii  adduser                                       3.118
ii  members                                       20080128.1+nmu1
ii  postgresql-pgsphere [postgresql-11-pgsphere]  1.1.1+2018.10.13-1
ii  postgresql-q3c [postgresql-11-q3c]            1.6.0-1
ii  python3-gavo                                  2.3+dfsg-1

gavodachs2-server recommends no packages.

gavodachs2-server suggests no packages.

-- no debconf information