We're still having some interesting issues with upgrading our live
PostGres 8.1 installation of Evergreen 1.2.3 to PostGres 8.2/Evergreen
1.4. The Evergreen side of things is pretty smooth, but PostGres is
causing some grief. We're hoping someone here can shed some light on
the problem.
First I should say that on our test system I am able to get a fully
functional EG 1.4.0.2 running (with a blank database). That tells me
I've got the basics in place (opensrf/ejabber domains & passwords, etc...).
When I try to bring in our PG 8.1 data things get a bit more
interesting. The fundamental problem appears to be because of the
tsearch component. From what I understand, tsearch had an 'interface
change' from 8.1 to 8.2 and some functions have been renamed/removed.
There are many references to the problem on the Internet. The most
complete discussion I've seen is here:
http://www.penguinlinux.com/blog/lamp/tsearch2-with-postgresql-82-errors/
Using the process outlined on that page, I've done steps 1 through 5 and
7. Our dump file was 700M--too big to manually edit and remove the
references as outlined in step 6 so we took step 7. Everything seems to
come in fine.
After that is done, I run the upgrade scripts to take the EG database
from 1.2.3 to 1.4.0.0 and then 1.4.0.1 and 1.4.0.2. That process seems
to go fine and indeed, I can see the changes get committed and the
database structure changes. I can manually query the database using
PSQL and all seems fine. (The 1.2.3 to 1.4.0.0 step gives a bunch of
notices about implicit keys being created.)
I can run:
osrf_ctl.sh -l -a start_all
and everything starts up. srfsh will let me login to the admin account.
Apache starts up fine too.
Then I run:
autogen.sh -c /openils/conf/opensrf_core.xml -u
and I get this:
-----------------------
Updating fieldmapper
Updating web_fieldmapper
Updating OrgTree
removing OrgTree from the cache...
Updating OrgTree HTML
Exception: OpenSRF::EX::ERROR 2009-03-08T21:58:23 OpenSRF::AppRequest
/usr/local/share/perl/5.8.8/OpenSRF/AppSession.pm:1009 System ERROR:
Exception: OpenSRF::DomainObject::oilsMethodException 2009-03-08T
21:58:23 OpenSRF::AppRequest
/usr/local/share/perl/5.8.8/OpenSRF/AppSession.pm:1009 <500> *** Call
to [open-ils.actor.org_tree.retrieve] failed for session
[1236563903.331642100.89846752828], thread trace [1]:
Can't use an undefined value as an ARRAY reference at
/openils/lib/perl5/OpenILS/Application/AppUtils.pm line 1385.
Updating locales selection HTML
Exception: OpenSRF::EX::ERROR 2009-03-08T21:58:24 OpenSRF::AppRequest
/usr/local/share/perl/5.8.8/OpenSRF/AppSession.pm:1009 System ERROR:
Exception: OpenSRF::DomainObject::oilsMethodException 2009-03-08T
21:58:24 OpenSRF::AppRequest
/usr/local/share/perl/5.8.8/OpenSRF/AppSession.pm:1009 <404> An unknown
server error occurred
Updating Search Groups
Refreshing proximity of org units
Successfully updated the organization proximity
Done
-----------------
The staff client won't connect properly, but I'm not worrying too much
about that until I see the autogen go properly.
Any idea as to what's wrong?
Garry
