[rt-users] Recovery Assistance

[Ruslan Zakirov]

Hi,

As CGM table have more records to account recursive members then you should
filter out some records. Use Via = id and GroupId <> MemberId condition on
CGM table.

Regards, Ruslan. From phone.
2010 11 16 02:51 пользователь "Jesse Vincent" <jesse at bestpractical.com>
написал:
>
>
>
> On Mon, Nov 15, 2010 at 04:52:58PM -0500, Josh Narins wrote:
>> Sorry, wasn't obvious I sent anything last time because of spurious
signature insertion.
>>
>> > From: Jesse Vincent [mailto:jesse at bestpractical.com]
>> > Sent: Monday, November 15, 2010 4:27 PM
>> > On Mon, Nov 15, 2010 at 04:24:22PM -0500, Josh Narins wrote:
>> > > Through admin error, during a practice migration of Postgres to
>> > > Oracle[1], about 5% of the GroupMembers table was deleted[2].
>> >
>> > Is the cached-group-members table intact? You can likely recover all
>> > the data from that, though I'm late for a plane. Someone else may be
>> > able to recommend exact steps to do so.
>>
>> The cached-group-members table is intact!
>
> Basically, the cachedgroupmembers table has a superset of the columns in
the groupmembers table.
>
> If you grab only the columns in cachedgroupmembers that match
groupmembers, remove the id column and unique the set, then you should be
able to insert those rows into the groumembers table. then run rt-validator
and test the heck out of things.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101116/d16f7973/attachment.htm>