Your message dated Wed, 29 Oct 2025 10:22:02 +0100 with message-id <20251029092202.eszskqaho2va6w5w@victor> and subject line gavodachs2-server: fails to install/upgrade. breaks on executing SQL script. has caused the Debian Bug report #984555, regarding gavodachs2-server: fails to install/upgrade. breaks on executing SQL script. to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 984555: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=984555 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Ole's diagnosis was right, and things seem to be back in order.
--- End Message ---
