[Rt-devel] piping up about having proper referential integrity in the DB...

[Ruslan Zakirov]

On Tue, Oct 20, 2009 at 11:18 PM, Jesse Vincent <jesse at bestpractical.com> wrote:
> Vick,
>
>> I turned on statement logging in postgres, and tracing the queries RT
>> made, discovered that his ID was still listed as a member of the group
>> in the GroupMembers table.
>
> But not in the CachedGroupMembers table? That seems surprising since all
> changes to those two tables should happen in lockstep inside a
> transaction that gets rolled back on failure.

This is possible if rt-validator from RT 3.8.1 is used with --resolve.
In 3.8.2 this has been fixed and rt-validator can resurrect CGM table
from scratch.

-- 
Best regards, Ruslan.