[rt-users] Upgrade problems

[Les Driggers]

Hi all,
I'm upgrading from rt-3.0.5 on RedHat 9 to 3.4.0rc6 on a new server. 
Version info on the new server: Fedora Core 3, Postgres 7.4.6, 
Apache 2.0.52, Perl 5.8.5, mod_perl 1.9916.

I'll describe my problems first and anyone interested in helping
can read on for more details. Everything seems to be OK except
when I click a ticket, its history is blank. Another problem is 
when I do a search, not all owners are listed and Nobody is listed
twice. Are these issues due to the problems shown below with the
database updates?


Upgrade steps:
  1) Dump old database with 'pg_dumpall -U postgres > rt3-25jan05.bak'
  2) Restore database on new server with 'psql -U postgres template1 
   < rt3.bak'.
  3) Run make upgrade.

Make upgrade finishes with:
  Congratulations. RT has been upgraded. You should now check-over 
  /opt/rt3/etc/RT_Config.pm for any necessary site customization.
  Additionally, you should update RT's system database objects by
  running
  ls etc/upgrade

  For each item in that directory whose name is greater than
  your previously installed RT version, run:
           /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-
  password --action schema --datadir etc/upgrade/<version>
           /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-
  password --action acl --datadir etc/upgrade/<version>
           /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-
  password --action insert --datadir etc/upgrade/<version>
 

#ls etc/upgrade/
3.1.0  3.1.15  3.1.17  3.3.0  3.3.11

I get the following errors trying to do the updates:
# /opt/rt3/sbin/rt-setup-database --dba postgres --action schema --
datadir etc/upgrade/3.1.0
Creating database schema.
Problem with statement:

CREATE SEQUENCE attributes_id_seq
ERROR:  relation "attributes_id_seq" already exists at /opt/rt3/sbin/rt-
setup-database line 205.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action acl --datadir
etc/upgrade/3.1.0
Done setting up database ACLs.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action insert --
datadir etc/upgrade/3.1.0
Done setting up database content.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action schema --
datadir etc/upgrade/3.1.15
Creating database schema.
Couldn't find schema file for Pg

# /opt/rt3/sbin/rt-setup-database --dba postgres --action acl --datadir
etc/upgrade/3.1.15
Couldn't find ACLS for Pg

# /opt/rt3/sbin/rt-setup-database --dba postgres --action insert --
datadir etc/upgrade/3.1.15
Creating scrips...74.done.
Done setting up database content.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action schema --
datadir etc/upgrade/3.1.17
Creating database schema.
Couldn't find schema file for Pg

# /opt/rt3/sbin/rt-setup-database --dba postgres --action acl --datadir
etc/upgrade/3.1.17
Couldn't find ACLS for Pg

# /opt/rt3/sbin/rt-setup-database --dba postgres --action insert --
datadir etc/upgrade/3.1.17
Creating ScripActions...20.21.done.
Creating ScripConditions...11.done.
Done setting up database content.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action schema --
datadir etc/upgrade/3.3.0
Creating database schema.
Problem with statement:

drop index ticketcustomfieldvalues1
ERROR:  index "ticketcustomfieldvalues1" does not exist
at /opt/rt3/sbin/rt-setup-database line 205.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action acl --datadir
etc/upgrade/3.3.0
DBD::Pg::st execute failed: ERROR:  relation "objectcustomfieldvalues"
does not exist at /opt/rt3/sbin/rt-setup-database line 341.
Problem with statement:
 GRANT SELECT, INSERT, UPDATE, DELETE ON objectcustomfieldvalues to rt;
ERROR:  relation "objectcustomfieldvalues" does not exist
at /opt/rt3/sbin/rt-setup-database line 342.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action insert --
datadir etc/upgrade/3.3.0
Done setting up database content.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action schema --
datadir etc/upgrade/3.3.11
Creating database schema.
Problem with statement:
 ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER
ERROR:  relation "objectcustomfieldvalues" does not exist
at /opt/rt3/sbin/rt-setup-database line 205.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action acl --datadir
etc/upgrade/3.3.11
Done setting up database ACLs.

# /opt/rt3/sbin/rt-setup-database --dba postgres --action insert --
datadir etc/upgrade/3.3.11
Done setting up database content.



Thanks in advance,
Les