[rt-users] RTx::Shredder question

[Ruslan Zakirov]

On 10/4/05, Andy Moran <andy at wildbrain.com> wrote:
>
> This question is probably more for Ruslan, but I thought I'd email the
> list in case it's something obvious.
>
>
> On a test system, we shredded about 25000 tickets in our Spam queue and
> that all went well.. took about 4 days.  (I had to hack the rtx-shredder
> script so it wouldn't write the sqldump restore files to save on disk
> space).
>
> Then I disabled all 22000 spammer user accounts (we only have about 100
> real accounts), and tried shredding all 22000 disabled accounts.  It ran
> for an hour and then died with this error:
This error mean next: Field Creator or LastUpdatedBy of the
RT::Ticket-3612 is link to the user RT::User-37898. This links are
minor dependencies, but you have to resolve them with
'replace_relations' option of the Users plugin, for example sane
values are nobody's id.

Sorry, I must add better coverage for this, but please read below how
to analize if you are in troubles or not.

>
> [Mon Oct  3 17:34:18 2005] [crit]: couldn't find resolver for dependency
> 'RT::User-37898 (depends on,resolvable dependency) RT::Ticket-3612' at
> /usr/local/rt3/lib/RTx/Shredder/Dependency.pm line 87, <STDIN> line 1.
>  (/usr/local/rt3/lib/RT.pm:295)
Ok, could you check ticket #3612? Does RT show it ok? Why it has
dependency on that user?

Do you have sqldumps for last runs when you were deleting users?

>
> I tried running the script again and this time i got a slightly
> different but similar error:
>
> [Mon Oct  3 17:43:22 2005] [crit]: couldn't find resolver for dependency
> 'RT::User-66 (depends on,resolvable dependency) RT::Attachment-1865' at
> /usr/local/rt3/lib/RTx/Shredder/Dependency.pm line 87, <STDIN> line 1.
>  (/usr/local/rt3/lib/RT.pm:295)
>
> Every time after that I tried to run it, it would immediately die with
> the same error.
>
> So my question:   Is this because the some disabled users might still
> own tickets?   Or could it be that in shredding my spam tickets, i
> messed up my database somehow and now can't shred my disabled users?
>
> I'm using the CLI of version 0.02_02.
>
> Cheers!
>
> --Andy

--
Best regards, Ruslan.