Forum .LRN Q&A: Re: Univ. of Valencia is running OACS 5.1 with Postgres 8.1.3 in our production server

Collapse
9: Re: Univ. of Valencia is running OACS 5.1 with Postgres 8.1.3 in our production server (response to 1)
Posted by Malte Sussdorff on 11/18/06 03:37 PM
I managed to get 8.2beta3 to run after trying in vain to get 8.1.5 to work.

What I realized is the following (which was probably the reason why 8.1.5 did not work out either).

DON'T have xotcl-request-monitor installed. I have no insight into what it is exactly doing which could cause this but in 10 out of 10 times (different sites) that I tried moving to 8.1/8.2 ONLY the installation which had not xotcl-request-monitor (XRM) installed worked.

Initially I suspected XRM to write into the database and that the insert was broken, but ney, that was not the reason as the site just works happily.

I could reproduce this behaviour on 5 different systems running xotcl and XRM from HEAD with AOLserver 4.5 and the latest sources.

Collapse
10: Re: Univ. of Valencia is running OACS 5.1 with Postgres 8.1.3 in our production server (response to 9)
Posted by Malte Sussdorff on 11/21/06 08:13 AM
After I reinstalled the database, recompiled the nspostgres driver to match the database version and some more performance tuning I made a fresh checkout of xotcl and the request-monitor and now it works on two of the five sites.

In case you wonder about our settings for the tuning: http://cognovis.de/entwickler/tips/postgresql/tuning/

Collapse
11: Re: Univ. of Valencia is running OACS 5.1 with Postgres 8.1.3 in our production server (response to 10)
Posted by john zhang on 11/21/06 03:04 PM
very helpful information! Thank you for sharing, Malt!