Investigate and clean up orphaned content

Bug #1655477 reported by Paul Everitt
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
KARL4
Fix Released
Medium
Jim Fulton

Bug Description

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.

Revision history for this message
Paul Everitt (paul-agendaless) wrote :

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

Changed in karl4:
assignee: Carlos de la Guardia (cguardia) → Jim Fulton (jim-zope)
milestone: 028 → 030
Changed in karl4:
milestone: 030 → 031
Revision history for this message
Jim Fulton (jim-zope) wrote :

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. :)

Changed in karl4:
status: New → Invalid
Revision history for this message
Paul Everitt (paul-agendaless) wrote :

Packing is good. Do we have automated packing yet?

Changed in karl4:
status: Invalid → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.