Forum .LRN Q&A: Re: Error deleting from homework folder

Posted by Matthew Coupe on
Ahh yes, so there is.

Error: Ns_PgExec: result status: 7 message: ERROR: update or delete on table "lobs" violates foreign key constraint "$1" on table "cr_revisions"
DETAIL: Key (lob_id)=(7779) is still referenced from table "cr_revisions".
CONTEXT: SQL statement "delete from lobs where lob_id = $1 and refcount = 0"
PL/pgSQL function "on_lob_ref" line 19 at SQL statement
SQL statement "delete from cr_revisions where revision_id = 9752914"
PL/pgSQL function "acs_object__delete" line 45 at execute statement
SQL statement "SELECT acs_object__delete( $1 )"
PL/pgSQL function "content_revision__del" line 56 at perform
SQL statement "SELECT content_revision__del( $1 )"
PL/pgSQL function "content_revision__delete" line 4 at perform
SQL statement "SELECT content_revision__delete( $1 )"
PL/pgSQL function "file_storage__delete_version" line 11 at perform

Posted by Matthew Coupe on
I've had a good look at this and I'm not quite sure what this problem is. Can anyone point me in the right direction?

Could it be caused by a slight mismatch between:
acs-content-repository Content Repository 5.3.2
file-storage File Storage 5.3.1

Posted by Dave Bauer on

I went back and read through this.

So what is happening is that the content is stored in the lobs table.

Each revision, if the content (the file) is the same, will refer to the same row in the lobs table.

The function is attempting to delete the row from the lobs table, although there are still revisions referencing that row.