[BUGS] FW: About - postgreswdinit.sql

[Basavaraj, Chethan (EXT-Other - IN/Bangalore)]

> 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
> 
> -Chethan HB