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

Ruslan Zakirov ruslan.zakirov at gmail.com
Tue Oct 20 17:09:05 EDT 2009

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.

More information about the Rt-devel mailing list