[request-tracker-maintainers] Bug#534346: Bug#534346: request-tracker3.8: Upgrading a postgresql database from 3.8.2 to 3.8.3 via rt-setup-database is broken

[Dominic Hargreaves]

On Tue, Jun 23, 2009 at 02:33:34PM -0500, Matt Zagrabelny wrote:

> I am using RT 3.8.2 (debian package) and am upgrading to 3.8.4.
> I am using apache2, postgresql 8.3, and postfix with it.
> 
> I attempted to upgrade the database using the rt-setup-database program,
> but it failed.
> 
> I attempted two different paths to upgrade:
> 
> % rt-setup-database --action upgrade --dba rtuser
> --prompt-for-dba-password
> In order to create or update your RT database, this script needs to
> connect to your  Pg instance on localhost as rtuser
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> 
> Password: 
> Working with:
> Type:   Pg
> Host:   localhost
> Name:   rt3
> User:   rtuser
> DBA:    rtuser
> Enter RT version you're upgrading from: 3.8.2
> 
> Going to apply following upgrades:
> * 3.8.3
> * 3.8.4
> 
> Enter RT version if you want to stop upgrade at some point,
>   or leave it blank if you want apply above upgrades:
> 
> Going to apply following upgrades:
> * 3.8.3
> * 3.8.4
> 
> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
> 
> Proceed [y/N]:y
> Processing 3.8.3
> Now populating database schema.
> DBD::Pg::st execute failed: ERROR:  relation "attachments_id_seq"
> already exists at /usr/share/request-tracker3.8/lib/RT/Handle.pm line
> 506.
> 
> 
> And also the excerpt from the dbconfig-common script:
> 
> % cat
> /usr/share/dbconfig-common/scripts/request-tracker3.8/upgrade/pgsql/3.8.3
> 
> Where I found the following command, and executed it.
> 
> # /usr/sbin/rt-setup-database-3.8 --action schema --datafile
> /usr/share/request-tracker3.8/etc/upgrade/3.8.3/schema.Pg --skip-creates
> 
> But it blew up with the same error.
> 
> -- Package-specific info:
> Changed files:
>   usr/share/request-tracker3.8/html/Ticket/Elements/EditCustomFields
> 
> There are locally modified files in /usr/local/share/request-tracker3.8/,
>  these may (or may not) be the source of the problem.

Hi,

I'm afraid I can't reproduce this. With a manually configured install
(sadly, the dbconfig_common method was broken in 3.8.2):

[install 3.8.2-1]
[Configure database in RT_SiteConfig.pm]
www-data at callisto:~$ /usr/sbin/rt-setup-database-3.8 --action init --skip-creates
Working with:
Type:   Pg
Host:   localhost
Name:   rt3
User:   rt_user
DBA:    rt_user (No DBA)
Now populating database schema.
Done.
Now inserting database ACLs
Done.
Now inserting RT core system objects
Done.
Now inserting data
Done inserting data
Done.
[upgrade to 3.8.4-1]
www-data at callisto:~$ /usr/sbin/rt-setup-database-3.8 --action schema --datafile /usr/share/request-tracker3.8/etc/upgrade/3.8.3/schema.Pg --skip-creates
Working with:
Type:   Pg
Host:   localhost
Name:   rt3
User:   rt_user
DBA:    rt_user (No DBA)
Now populating database schema.
Done.

I can only assume that you had previously upgraded or customised your
database before trying this upgrade.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)