[rt-users] setup-database error during upgrade at 3.8.81

George Kelbley kelbley at cs.unm.edu
Thu Mar 13 15:31:02 EDT 2014

I'm upgrading from 3.6.1 and although I could swear I got further than 
this on a previous attempt, I am getting :

[Thu Mar 13 19:16:40 2014] [critical]: DBD::mysql::st execute failed: 
Duplicate key name 'CachedGroupMembers3' at 
/usr/share/request-tracker4/lib/RT/Handle.pm line 515. 
DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' 
at /usr/share/request-tracker4/lib/RT/Handle.pm line 515.

during the setup-database --action upgrade

I am migrating from an old server to a new one running debian wheezy, rt 
installed from packages.

I created an rt3 database on my new server with the latin character set, 
dumped from the old to the new using the --default-character-set=binary 
option, then when running the setup to get from 3.6.1 to 3.7.87 as 
described in the documentation, I get the above error.  This is an old 
db, but I don't think we ever set up a customer CachedGroupMembers3 as 
described in some other posts.  So I appear to bailing before getting to 
the mysql db upgrade required.

The weirdest thing is that I got all the way to end of an upgrade on a 
previous trial by doing the mysql upgrade first, fixing some errors via 
mysql as supplied by Kevin, then running the setup-database from 3.6.1 
to 4.0.7.  However I am consistantly getting the Duplicate key error no 
matter which way I try the upgrade.

More information about the rt-users mailing list