[OPEN-ILS-DEV] ***SPAM*** Re: ***SPAM*** Re: ***SPAM*** Re: 1.4.0.4 -> 1.6.0.3 not a smooth upgrade: not seeing copy summaries

[Dan Scott]

On Mon, 2010-03-22 at 15:35 -0500, Victoria Bush wrote:
> See below for updates.....

<snip>

> > Setting your database to log statements would be good, too; it's often
> > set to log nothing by default.
> 
> I have mine set to log to /home/postgres/logfile, so I found the following which leads me to believe that the problem is actually upgrading the databases from 1.4.0.4 to the 1.6 format. I see this for most statements: 
> 
> > ERROR:  schema "serial" does not exist
> > ERROR:  schema "acq" does not exist

This is a huge problem. Part of the 1.4.0.5-1.6.0.0 upgrade script
creates the serial and acq schemas inside a transaction; if these
schemas don't exist, then the rest of the database schema will be in a
very broken state.

I would suggest going back to one of your 1.4.0.4 backups and rerunning
the 1.4.0.5-1.6.0.0 script again; send us the very first error that
occurs during the upgrade.