Request for advice or assistance - rt-validator/upgrade

Hi folks, I asked (badly) about this a bit ago, and I’m hoping someone
might have a suggestion.

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?

Many thanks for any assistance

Arnon

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