[rt-users] Recovery Assistance

[Jesse Vincent]

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.