From: | Chethan HB <chethanbasavaraj(at)gmail(dot)com> |
---|---|
To: | undisclosed-recipients:; |
Subject: | Fwd: [BUGS] BUG #6240: About - postgreswdinit.sql |
Date: | 2011-10-05 11:12:26 |
Message-ID: | CAGTTrtdAcAywhqkzjgfYD4UK7r_VeU5wiUeFAQLrDztBzggsYg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
Hi,
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
Regards
Chethan HB
"Life is just a moment between a breath and none. Hope I do enough to add
meaning to it."
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Cristian Cruz | 2011-10-05 13:00:36 | Re: BUG #6226: Broken foreign key stored on database (parent deleted with children still readable, BUG#6225 Update) |
Previous Message | Magnus Hagander | 2011-10-05 10:42:22 | Re: BUG #6233: pg_dump hangs with Access Violation C0000005 |
From | Date | Subject | |
---|---|---|---|
Next Message | Adarsh Sharma | 2011-10-05 12:05:26 | Postgresql Data directory Issue |
Previous Message | Raymond O'Donnell | 2011-10-05 11:09:11 | Re: Postgresql-8.2 Replication |