Upgrading - 3.6.5 - 3.8.2

RT Users
1

Hi,
In following the upgrade docs we apply updates to schema with
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade

But this gives me error below. Any ideas how I could progress past this
issue?

Output from console;

Processing 3.7.1
Now inserting data
Processing 3.7.3
Now populating database schema.
Processing 3.7.10
Now inserting data
Processing 3.7.15
Now inserting data
Processing 3.7.19
Now inserting data
Processing 3.7.81
Now populating database schema.
[Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate
key name ‘CachedGroupMembers3’ at /opt/rt3/sbin/…/lib/RT/Handle.pm line
506. (/opt/rt3/sbin/…/lib/RT.pm:377)
DBD::mysql::st execute failed: Duplicate key name ‘CachedGroupMembers3’ at
/opt/rt3/sbin/…/lib/RT/Handle.pm line 506.

2

Hi,
In following the upgrade docs we apply updates to schema with
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade

But this gives me error below. Any ideas how I could progress past this
issue?

That suggests you’ve tried to run the update before or manually added an
index. You might try a “DROP INDEX CachedGroupMembers3;” and starting
over from where the upgrade bailed out.