[rt-users] error upgrading db from 3.6.3 to 4.0.0

Kevin Falcone falcone at bestpractical.com
Mon May 2 18:38:15 EDT 2011


On Mon, May 02, 2011 at 02:03:51PM -0700, Hersker, Steve wrote:
>    So....I want to upgrade to that instead. There was no UPGRADING.mysql, just the README saying
>    to run rt-setup-database.

UPGRADING.mysql is now in docs and is still referenced in README and
UPGRADING-3.6 which you should be reading (along with UPGRADING-3.8
and UPGRADING-4.0)

>    When I try to upgrade from 3.6.3 all the way up to 4.0.0, I'm getting:
> 
>    Processing 3.7.81
> 
>    Now populating database schema.
> 
>    [Mon May  2 20:53:58 2011] [crit]: DBD::mysql::st execute failed: Duplicate key name
>    'CachedGroupMembers3' at /opt/rt4/sbin/../lib/RT/Handle.pm line 503.
>    (/opt/rt4/sbin/../lib/RT.pm:340)
> 
>    DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at
>    /opt/rt4/sbin/../lib/RT/Handle.pm line 503.

Looks like you ran 3.7.81 twice


> 
>    Now populating database schema.
> 
>    [Mon May  2 20:31:51 2011] [crit]: DBD::mysql::st execute failed: Can't DROP 'DelegatedBy';
>    check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 503.
>    (/opt/rt4/sbin/../lib/RT.pm:340)
> 
>    DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at
>    /opt/rt4/sbin/../lib/RT/Handle.pm line 503.

Looks like you ran something else twice too, since that column has
existed since at least 3.4

>    Do I need to upgrade incrementally from 3.6.3 to 3.8.9 to 3.9.x and then to 4.0.0? Is there
>    info on this that I missed? Or, should the rt-setup-database handle the jump from 3.6.3 to
>    4.0.0 (including 3.8.0's schema changes)?

You can use rt-setup-database from 3.6.3 to 3.7.81 follow
UPGRADING.mysql and then continue onward from there to 4.0.0

Also, there is no reason to use a 3.8.9 tarball and a 4.0.0 tarball,
you can do it all from the fresh install in /opt/rt4

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110502/8009f8b6/attachment.sig>


More information about the rt-users mailing list