This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

HA-Logfile error!!

Can anybody help??
I have 2 ASG 320 in HA-Mode running!

On the master node the following errors are displayed:

1-1] CONFIG main: slon version 1.2.14 starting up
2008:11:18-08:46:51 (none) slon[14921]: [2-1] FATAL main: Cannot connect to local database - FATAL: "pg_tblspc/51966/51967" is not a valid data directory
2008:11:18-08:46:51 (none) slon[14921]: [2-2] DETAIL: File "pg_tblspc/51966/51967/PG_VERSION" is missing.
2008:11:18-08:46:51 (none) slon[14921]: [2-3] - sleep 10s
2008:11:18-08:47:01 (none) slon[2076]: [1-1] CONFIG main: slon version 1.2.14 starting up
2008:11:18-08:47:01 (none) slon[14945]: [2-1] FATAL main: Cannot connect to local database - FATAL: "pg_tblspc/51966/51967" is not a valid data directory
2008:11:18-08:47:01 (none) slon[14945]: [2-2] DETAIL: File "pg_tblspc/51966/51967/PG_VERSION" is missing.
2008:11:18-08:47:01 (none) slon[14945]: [2-3] - sleep 10s
2008:11:18-08:47:11 (none) slon[2076]: [1-1] CONFIG main: slon version 1.2.14 starting up
2008:11:18-08:47:11 (none) slon[14983]: [2-1] FATAL main: Cannot connect to local database - FATAL: "pg_tblspc/51966/51967" is not a valid data directory
2008:11:18-08:47:11 (none) slon[14983]: [2-2] DETAIL: File "pg_tblspc/51966/51967/PG_VERSION" is missing.
2008:11:18-08:47:11 (none) slon[14983]: [2-3] - sleep 10s

What can i do??
Seem that HA is not working correct??

This thread was automatically locked due to age.

Parents

0 nhlfan over 16 years ago

Hi,

we have the same behavoiur and we don´t know why. This log entry is repeated many times every 10 seconds.

Did you solved the problem?

Regards,
Clemens
Cancel
Vote Up 0 Vote Down

Cancel
0 da_merlin over 16 years ago in reply to nhlfan

Whats the content of /var/log/reporting/pgsql and its subdirectory?
Is there a PG_VERSION file in both directories ?

If yes, can you verify that the file size of both PG_VERSION files are 4 bytes each?
Cancel
Vote Up 0 Vote Down

Cancel
0 da_merlin over 16 years ago in reply to da_merlin

You can try the following two commands and wait four hours, maybe this will fix the issue:

psql reporting -U ha_sync -c "DROP SCHEMA IF EXISTS _ASG_CLUSTER CASCADE;"
psql pop3 -U ha_sync -c "DROP SCHEMA IF EXISTS _ASG_CLUSTER CASCADE;"
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 da_merlin over 16 years ago in reply to da_merlin

You can try the following two commands and wait four hours, maybe this will fix the issue:

psql reporting -U ha_sync -c "DROP SCHEMA IF EXISTS _ASG_CLUSTER CASCADE;"
psql pop3 -U ha_sync -c "DROP SCHEMA IF EXISTS _ASG_CLUSTER CASCADE;"
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data