[Debian-astro-maintainers] Bug#1023026: gavodachs: Fails it autopkgtest

[Nilesh Patra]

Source: gavodachs
Version: 2.6+dfsg-1.1
Severity: serious
X-Debbugs-Cc: olebole at debian.org

Hi

gavodachs fails it's autopkgtest with permission errors:

| createuser: error: creation of new role failed: ERROR:  role "dachsroot" already exists
| *** Error: While executing DB query:
|
|  CREATE OR REPLACE FUNCTION q3c_join_symmetric(
|				leftra double precision, leftdec double precision,
|      	rightra double precision, rightdec double precision,
|      	radius double precision) RETURNS boolean AS '
| SELECT (
|    (   
|       ((q3c_ang2ipix($3,$4)>=(q3c_nearby_it($1,$2,$5,0))) AND (q3c_ang2ipix($3,$4)<=(q3c_nearby_it($1,$2,$5,1))))
|    OR ((q3c_ang2ipix($3,$4)>=(q3c_nearby_it($1,$2,$5,2))) AND (q3c_ang2ipix($3,$4)<=(q3c_nearby_it($1,$2,$5,3))))
|    OR ((q3c_ang2ipix($3,$4)>=(q3c_nearby_it($1,$2,$5,4))) AND (q3c_ang2ipix($3,$4)<=(q3c_nearby_it($1,$2,$5,5))))
|    OR ((q3c_ang2ipix($3,$4)>=(q3c_nearby_it($1,$2,$5,6))) AND (q3c_ang2ipix($3,$4)<=(q3c_nearby_it($1,$2,$5,7))))
|    ) AND                           
|    (    
|       ((q3c_ang2ipix($1,$2)>=(q3c_nearby_it($3,$4,$5,0))) AND (q3c_ang2ipix($1,$2)<=(q3c_nearby_it($3,$4,$5,1))))
|    OR ((q3c_ang2ipix($1,$2)>=(q3c_nearby_it($3,$4,$5,2))) AND (q3c_ang2ipix($1,$2)<=(q3c_nearby_it($3,$4,$5,3))))
|    OR ((q3c_ang2ipix($1,$2)>=(q3c_nearby_it($3,$4,$5,4))) AND (q3c_ang2ipix($1,$2)<=(q3c_nearby_it($3,$4,$5,5))))
|    OR ((q3c_ang2ipix($1,$2)>=(q3c_nearby_it($3,$4,$5,6))) AND (q3c_ang2ipix($1,$2)<=(q3c_nearby_it($3,$4,$5,7))))
|    )                               
|    )
|    AND q3c_sindist($1,$2,$3,$4)<POW(SIN(RADIANS($5)/2),2)
| ' LANGUAGE SQL IMMUTABLE;
|
|
| The database engine reported:
|
|  ERROR:  permission denied for schema public
|
| dpkg: error processing package gavodachs2-server (--configure):

Several failures logs can be seen here[1]
This is blocking testing migration for pgsphere and pillow.


[1]: https://ci.debian.net/packages/g/gavodachs/testing/amd64/


-- System Information:
Debian Release: bookworm/sid
  APT prefers testing
  APT policy: (990, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 6.0.0-2-amd64 (SMP w/8 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled