[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: postgresql test failures

From: Jeremy L
Subject: Re: postgresql test failures
Date: Sat, 19 Jan 2019 18:28:08 +0000
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1

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. testing GET DATA /TYPE=PSQL ...
../../tests/ PATH=$PG_PATH:$PATH initdb -A trust
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/ PATH=$PG_PATH:$PATH pg_ctl start -w -o "-k 
$socket_dir -h ''"
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 
server started
../../tests/ PATH=$PG_PATH:$PATH createdb -h "$socket_dir" 
../../tests/ psql -h "$socket_dir" -p $PG_PORT $PG_DBASE < 
--- /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
2019-01-19 09:12:26.102 PST [21859] FATAL:  database "blp" does not exist
../../tests/ exit code was 2, expected 0
server shutting down
250. 250. GET DATA /TYPE=PSQL ( 

pspp-dev mailing list

reply via email to

[Prev in Thread] Current Thread [Next in Thread]