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."
