Re: postgresql test failures

[John Darrington]

I pushed a fix which seems to solve the problem at least on debian ...

J'

On Sun, Jan 20, 2019 at 09:00:59AM +0100, John Darrington wrote:
     I had a look at this, and spoke to some of the postgres people.  
     
     It seems that postgres is not after all the guilty party. Debian is.
     
     Debian's /usr/bin/psql is a wrapper around the real psql which breaks
     things.
     
     I'll see what the best way around this problem is.
     
     J'
     
     On Sat, Jan 19, 2019 at 08:53:15PM +0100, John Darrington wrote:
          I'm getting the same results.  
          
          So I suspect the test needs to be adjusted to suit recent psqlserver
          versions.
          
          J'
          On Sat, Jan 19, 2019 at 09:16:09AM -0800, Ben Pfaff wrote:
               I've recently had to move development to a new laptop because my
               previous one died suddenly.  I'm getting the following test 
failure
               reliably on the new one.  I don't know much about postgresql 
setup, so
               I'd appreciate any advice.
               
               #                             -*- compilation -*-
               250. get-data-psql.at:147: testing GET DATA /TYPE=PSQL ...
               ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH initdb -A 
trust
               stdout:
               The files belonging to this database system will be owned by 
user "blp".
               This user must also own the server process.
               
               The database cluster will be initialized with locale "C".
               The default database encoding has accordingly been set to 
"SQL_ASCII".
               The default text search configuration will be set to "english".
               
               Data page checksums are disabled.
               
               creating directory 
/home/blp/pspp/master/_build/tests/testsuite.dir/0250/cluster ... ok
               creating subdirectories ... ok
               selecting default max_connections ... 100
               selecting default shared_buffers ... 128MB
               selecting dynamic shared memory implementation ... posix
               creating configuration files ... ok
               running bootstrap script ... ok
               performing post-bootstrap initialization ... ok
               syncing data to disk ... ok
               
               Success. You can now start the database server using:
               
                   pg_ctl -D 
/home/blp/pspp/master/_build/tests/testsuite.dir/0250/cluster -l logfile start
               
               ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH pg_ctl 
start -w -o "-k $socket_dir -h ''"
               stdout:
               waiting for server to start....2019-01-19 09:12:25.681 PST 
[21495] LOG:  listening on Unix socket "/tmp/tmp.xPYKH8shgE/.s.PGSQL.6543"
               2019-01-19 09:12:25.719 PST [21557] LOG:  database system was 
shut down at 2019-01-19 09:12:25 PST
               2019-01-19 09:12:25.729 PST [21495] LOG:  database system is 
ready to accept connections
                done
               server started
               ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH createdb 
-h "$socket_dir" -p $PG_PORT $PG_DBASE
               stderr:
               stdout:
               ../../tests/get-data-psql.at:149: psql -h "$socket_dir" -p 
$PG_PORT $PG_DBASE < populate.sql
               --- /dev/null   2019-01-14 21:20:12.627999704 -0800
               +++ 
/home/blp/pspp/master/_build/tests/testsuite.dir/at-groups/250/stderr       
2019-01-19 09:12:26.099989467 -0800
               @@ -0,0 +1 @@
               +psql: FATAL:  database "blp" does not exist
               stdout:
               2019-01-19 09:12:26.102 PST [21859] FATAL:  database "blp" does 
not exist
               ../../tests/get-data-psql.at:149: exit code was 2, expected 0
               server shutting down
               250. get-data-psql.at:147: 250. GET DATA /TYPE=PSQL 
(get-data-psql.at:147): FAILED (get-data-psql.at:149)
               
               _______________________________________________
               pspp-dev mailing list
               address@hidden
               https://lists.gnu.org/mailman/listinfo/pspp-dev
          
          -- 
          Avoid eavesdropping.  Send strong encrypted email.
          PGP Public key ID: 1024D/2DE827B3 
          fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
          See http://sks-keyservers.net or any PGP keyserver for public key.
          
     
     -- 
     Avoid eavesdropping.  Send strong encrypted email.
     PGP Public key ID: 1024D/2DE827B3 
     fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
     See http://sks-keyservers.net or any PGP keyserver for public key.
     

-- 
Avoid eavesdropping.  Send strong encrypted email.
PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See http://sks-keyservers.net or any PGP keyserver for public key.