Re: postgresql test failures

[Ben Pfaff]

I'm pretty sure that this test is trying to create a database server of
its own rather than using the system's server.  It worked for me OK
before without any special configuration, but it is not working with my
new laptop.

I think that John wrote this test, so perhaps he will have some
thoughts.

On Sat, Jan 19, 2019 at 06:28:08PM +0000, Jeremy L wrote:
> Haven't looked at the bootstrapping from pspp, but have some experience with
> postgres connections.
> 
> Postgresql generally requires a database to exist on the cluster on the
> server for the client to connect to. There may be a system-provided
> "postgres" database you can use, then create your "blp" database, and then
> you can reconnect to "blp" instead.
> 
> This makes me think the bootstrap is trying to connect to the database it
> wants to create: can you have it try "postgres" as the connection database
> and then create "blp"?
> 
> 
> On 1/19/19 12:16 PM, 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
> > 
> 
> _______________________________________________
> pspp-dev mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/pspp-dev