Investigate and clean up orphaned content

[Paul Everitt]

Jim found that we have 4,900+ objects that have no __parent__:

osf-karl=> select count(*) from object_json where state ? 'creator' and not state ? '__parent__';
 count
-------
  4991

The catalog silently filters these out of queries so we weren't failing. We need to look at these, devise a theory as to what happened, and do some kind of remediation (re-attach or remove.)

Aim for February.

[Paul Everitt (paul-agendaless)]

I'll hand this over to Jim for April or May.

[Jim Fulton (jim-zope)]

Haha:

osf-karl=> select count(*) from object_json where state ? 'creator' and not state ? '__parent__';
 count
-------
    86
(1 row)

I think these are results of not packing.

Nothing to see here, move along

and maybe pack once and awhile. :)

[Paul Everitt (paul-agendaless)]

Packing is good. Do we have automated packing yet?