[rt-users] rt4 database upgrade

[Kevin Falcone]

On Wed, Jun 15, 2011 at 01:03:05PM -0400, Delarosa, Adalberto wrote:
>    I am in the mist of moving from RT 3.8.8 to 4.0.  I run the update database script and I get
>    the following error:
> 
> 
> 
>    [warning]: DBD::mysql::st execute failed: Duplicate entry '0' for key 'PRIMARY' at
>    /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509, <> line 1.
>    (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)

This points to some sort of corruption with your PRIMARY KEY on the
ACL table.  You may want to run the mysql check/repair tools on it.
> 
> 
>    Couldn't load GM record #0 at ./rt-validator line 433

That really reads like you have other corruption in your database.

You can run rt-validator in --verbose mode to see what it is doing to
find a 0, but it seems it is deeper than the RT level.

-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/20110615/d9e157af/attachment.sig>