Postgres Issues at Scalix Upgrade

[brwatters]

Ok .. we are stumped .. upgrade from 11.1.04 I think it was .. the last GA of the Network Version failed .. seems it fails over and over again on Postgres

RedHat AS 4.5

Configuring PostgreSQL...
Fatal error occured: Msg: An error occurred configuring Web applications -- check the log for errors.
Scalix Installer - cleaning up...
Scalix Installer - done.
[root@mail scalix-11.2.0-GA]#

LOG: database system was shut down at 2007-09-29 21:00:07 PDT
LOG: checkpoint record is at 0/33A70C
LOG: redo record is at 0/33A70C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 565; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
FATAL: database "scalix" does not exist
ERROR: database "scalix" does not exist
FATAL: database "scalix" does not exist
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: logger shutting down
LOG: database system was shut down at 2007-09-29 21:08:10 PDT
LOG: checkpoint record is at 0/33A750
LOG: redo record is at 0/33A750; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 567; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
FATAL: database "scalix" does not exist
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: logger shutting down

I have uninstalled and rebooted and still the same error?? .. Ideas on how to recover from this .. our email server is now DOWN.

BRW

[chris]

Hi BRW,

you uninstalled everything and reinstalled?

It sounds like the postgres database is missing, try to recreate it with http://www.scalix.com/wiki/index.php?ti ... recreatedb

Chris

[brwatters]

No joy ..

Configuring PostgreSQL...
Fatal error occured: Msg: An error occurred configuring Web applications -- check the log for errors.
Scalix Installer - cleaning up...
Scalix Installer - done.
[root@mail scalix-11.2.0-GA]# cd ..
[root@mail ~]# ./scalixdb.sh
Starting scalix-postgres service (mail): [FAILED]
dropdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/opt/scalix/ml/postgres/data/.s.PGSQL.5733"?
[root@mail ~]# ./scalixdb.sh
Starting scalix-postgres service (mail): [FAILED]
dropdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/opt/scalix/ml/postgres/data/.s.PGSQL.5733"?


Ideas ?? This seems to happen about once every other update and then it forces us to have to start all over again .. I sure hope this is not going to be the case again

BRW

[chris]

It's certainly not an error I've seen - and I think I've seen a lot of 'em ;p

Anyway, can you confirm that postgres is not running and listening on port 5733?

Is the whitelist in /var/opt/scalix/*/postgres/data/pg_hba.conf correctly filled in?

Should look like:

# List of Scalix Platform hosts begins here
host scalix scalix 192.168.188.131/32 md5

Can you post the relevant contents of /var/opt/scalix/*/postgres/pgstartup.log?

Chris

[chris]

I split this thread off from viewtopic.php?t=8893 to make it easier for others to find the discussion around postgres.

Chris

[brwatters]

Ok .. so thats what I thought as well so I did this .. which did not help by the way ..

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

[brwatters]

DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not compatible with this version 7.4.16.
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not compatible with this version 7.4.16.


Ok .. Maybe this is the issue?? .. How do I start over without starting over?? In one of this boxes upgrade cycles it did pull in Postgres v8.1 however I removed and reinstalled v7.4 ..

Ideas??

BRW

[chris]

Are you running multiple databases on the box? If not, is there a reason not just to upgrade to 8.1? I have no idea how to downgrade a postgres database from 8.x format to 7.x format - if it's even possible.

If you don't want to upgrade, you could manuall remove the postgres rpm and the /var/opt/scalix/*/postgres directory, and then reinstall the scalix-postgres package via the installer. However, I think that's much more likely to involve "complications" than just upgrading postgres.

Using postgres 8.1 with Scalix should be no problem.

Chris

[brwatters]

Strange stuff

Uninstalled again ..

Then went in and deleted the Postgres data directory ..

Re-installed and now all appears to be working as it should be .. Thats a first for me.

Chris thanks for the hand holding

BRW

[chris]

Not a problem - glad you got that sorted!

I would assume that things should be correct from now on, seeing as the database will have been initialized by postgres 7.4

Cheers,

Chris

[brwatters]

Hmm .. Ok spoke to soon .. Logged into the web interface without issue ..

I can see that I have msg in my inbox but can not view them .. I get an error code of GUI022 when I attempt to view any of the email .. Can not view the calendar either ??

BRW

[chris]

ok, no problem, i'm still online ;p

1) did postgres start cleanly according to /var/opt/scalix/*/postgres/pgstartup.log?

2) do you see any errors in /var/opt/scalix/*/tomcat/logs/scalix-api.log, scalix-swa.log or similar? what about catalina.out?

Chris

[brwatters]

Ok .. so it appears after folllowing this I was able to solve this issue ..

viewtopic.php?t=8836&highlight=gui022

Thanks agian for sticking with me

BRW

[chris]

Excellent! Hope it stays fixed this time ;p

Chris