[rt-users] Request for advice or assistance - rt-validator/upgrade

[Kevin Falcone]

On Thu, Nov 29, 2012 at 11:25:00AM -0500, Arnon Clark wrote:
> I'm trying to run an upgrade from 3.8.7 to the latest, but when I'm
> running the rt-validator before the database upgrade, I'm hitting
> multiple errors as follows :
> 
> Record #600812 in Attachments references not existent record in Attachments
>     Parent => '600810' => id
>     Attachment #600812 -> Txn #1567410, Transaction #1567410 ->
> object RT::Ticket #187695
> 
> I tried using shredder to delete the tickets in question, but am
> still seeing the error. Does anyone have any recommendations on how
> to proceed?

It looks like someone manually deleted one part of a multipart
attachment (the parent but not the child).

You appear to be using the validator from 4.0.4, not 4.0.8 which is
the latest.

Assuming you have a backup, run rt-validator with --check --resolve
and tell it to delete those leftover attachments for you and it'll
take care of them.

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