Skip to content

Instantly share code, notes, and snippets.

@jonvargas
jonvargas / gist:3152496
Created July 20, 2012 18:43
Alfresco fails during upload after migration to Ubuntu 12.04
2012-07-19 21:00:06,327 ERROR [node.db.DeletedNodeCleanupWorker] [DefaultScheduler_Worker-5] Failed to purge nodes. If the purgable set is too large for the available DB resources
then the nodes can be purged manually as well.
Set log level to WARN for this class to get exception log:
Max commit time: 1340161200052
Error:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_node" violates foreign key constraint "fk_alf_cass_pnode" on table "alf_child_assoc"
Detail: Key (id)=(8753) is still referenced from table "alf_child_assoc".
### The error may involve alfresco.node.delete_NodesByTxnCommitTime-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_node" violates foreign key constraint "fk_alf_cass_pnode" on table "alf_child_assoc"