[OPEN-ILS-DEV] Upgrading PostGres issues

[Garry Dunn]

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