Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 624690

Summary: dev-db/pgtap-0.97.0 fails tests ( command failed: "/usr/lib64/postgresql-9.5/bin/psql" -X -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres" )
Product: Gentoo Linux Reporter: Kent Fredric (IRC: kent\n) (RETIRED) <kentnl>
Component: Current packagesAssignee: Aaron W. Swenson <titanofold>
Status: RESOLVED FIXED    
Severity: normal CC: pgsql-bugs
Priority: Normal Keywords: TESTFAILURE
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Bug Depends on: 643544    
Bug Blocks:    
Attachments: build.log

Description Kent Fredric (IRC: kent\n) (RETIRED) gentoo-dev 2017-07-12 13:42:31 UTC
Created attachment 483352 [details]
build.log

From the look of what this test is doing, it expects a pre-existing postgres instance to not be fatal.

But based on what this test is doing, I feel greatly uncomfortable with the idea that it uses a system postgres install. 


(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
command failed: "/usr/lib64/postgresql-9.5/bin/psql" -X -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
make: *** [/usr/lib64/postgresql-9.5/lib64/pgxs/src/makefiles/pgxs.mk:272: installcheck] Error 2
 * ERROR: dev-db/pgtap-0.97.0::gentoo failed (test phase):
 *   emake failed


After setting up a chroot to run postgres, the tests then fail differently:

============== dropping database "contrib_regression" ==============
psql: FATAL:  role "portage" does not exist
command failed: "/usr/lib64/postgresql-9.5/bin/psql" -X -c "DROP DATABASE IF EXISTS \"contrib_regression\"" "postgres"
make: *** [/usr/lib64/postgresql-9.5/lib64/pgxs/src/makefiles/pgxs.mk:272: installcheck] Error 2


And then I create the role manually:


(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
NOTICE:  database "contrib_regression" does not exist, skipping
DROP DATABASE
============== creating database "contrib_regression" ==============
ERROR:  permission denied to create database
command failed: "/usr/lib64/postgresql-9.5/bin/psql" -X -c "CREATE DATABASE \"contrib_regression\" TEMPLATE=template0" "postgres"
make: *** [/usr/lib64/postgresql-9.5/lib64/pgxs/src/makefiles/pgxs.mk:272: installcheck] Error 2
 * ERROR: dev-db/pgtap-0.97.0::gentoo failed (test phase):


And at this point, my patience to make guesses about what it needs to run tests runs out.