Thread: BUG #6240: About - postgreswdinit.sql

The following bug has been logged online:

Bug reference:      6240
Logged by:          Chethan HB
Email address:      chethanbasavaraj@gmail.com
PostgreSQL version: 9.0.4
Operating system:   Linux
Description:        About - postgreswdinit.sql
Details:

In a freshly commissioned h/w, when watchdog is created for the first time,
I faced some problem.

I never faced this problem earlier.

Currenlty we are using the following version:
export PGODBC_VERSION=psqlodbc-09.00.0300
Postgres version=9.0.4

Logs are attached here:

Jan  1 02:05:09.492736 info CLA-0 FSPostgresWD: COMMUTIL INFO connection to
db server succeeded, Postgres is up
Jan  1 02:05:09.520838 info CLA-0 FSPostgresWD: COMMUTIL INFO create WD DB
postgreswd
Jan  1 02:05:09.521774 info CLA-0 FSPostgresWD: COMMUTIL INFO port = 5432
Jan  1 02:05:09.526093 info CLA-0 FSPostgresWD: COMMUTIL INFO => executing:
/opt/nokiasiemens/SS_Postgres/bin/psql -d template1 -v ON_ERROR_STOP=on -f
/opt/nokiasiemens/SS_DBHAforPostgres/etc/postgreswdinit.sql -q -h 127.0.0.4
-p 5432  as user: _qnrnwdbman
Jan  1 02:05:10.531239 warn CLA-0 postgres[9919]: [2-1] ERROR:  could not
create file "base/16384/11500": File exists        [This error is from postgres
server]
Jan  1 02:05:10.531317 warn CLA-0 postgres[9919]: [2-2] STATEMENT:  create
database postgreswd;
Jan  1 02:05:10.536788 err CLA-0 FSPostgresWD: COMMUTIL ERROR psql:
/opt/nokiasiemens/SS_DBHAforPostgres/etc/postgreswdinit.sql returned with
error: 3
Jan  1 02:05:10.536851 err CLA-0 FSPostgresWD: COMMUTIL ERROR failed to
execute /opt/nokiasiemens/SS_DBHAforPostgres/etc/postgreswdinit.sql got
error 3
Jan  1 02:05:10.536895 err CLA-0 FSPostgresWD: COMMUTIL ERROR failed to
initialize PersDBProxy object
Jan  1 02:05:10.536943 info CLA-0 FSPostgresWD: COMMUTIL INFO DB postgreswd
does not exist
Jan  1 02:05:10.546575 err CLA-0 postgres[9922]: [2-1] FATAL:  database
"postgreswd" does not exist
Jan  1 02:05:10.547846 warn CLA-0 FSPostgresWD: COMMUTIL WARNING ===> Sql
response :  connection to SQL server  rc code :  -1
Jan  1 02:05:10.547903 info CLA-0 FSPostgresWD: COMMUTIL INFO
[unixODBC]FATAL: database "postgreswd" does not exist (210)
Jan  1 02:05:10.547947 warn CLA-0 FSPostgresWD: COMMUTIL WARNING #######>
failed to connect to the DB
Jan  1 02:05:10.547994 info CLA-0 FSPostgresWD: COMMUTIL INFO initializing
DB
Jan  1 02:05:10.548920 info CLA-0 FSPostgresWD: COMMUTIL INFO postgreswd
starting with redundancy model 1 current role 0
Jan  1 02:05:10.572467 info CLA-0 FSPostgresWD: COMMUTIL INFO connection to
db server succeeded, Postgres is up
Jan  1 02:05:10.598632 info CLA-0 FSPostgresWD: COMMUTIL INFO create WD DB
postgreswd
………..
……….

Kindly let me know as early as possible. Thanks in advance

"Chethan HB" <chethanbasavaraj@gmail.com> writes:
> Jan  1 02:05:10.531239 warn CLA-0 postgres[9919]: [2-1] ERROR:  could not
> create file "base/16384/11500": File exists        [This error is from postgres
> server]
> Jan  1 02:05:10.531317 warn CLA-0 postgres[9919]: [2-2] STATEMENT:  create
> database postgreswd;

This is extremely strange on several levels.  Are you sure you are using
an unmodified Postgres 9.0.4 server?  In my copy of 9.0, there would
never be a file with a relfilenode number as small as 11500, not to
mention that CREATE DATABASE should certainly not be targeting a
nonempty subdirectory of $PGDATA/base to create a new database in.

            regards, tom lane