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-d...@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-d...@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) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
