Skip to content

Instantly share code, notes, and snippets.

@jonvargas
Created July 20, 2012 18:43
Show Gist options
  • Select an option

  • Save jonvargas/3152496 to your computer and use it in GitHub Desktop.

Select an option

Save jonvargas/3152496 to your computer and use it in GitHub Desktop.
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"
Detail: Key (id)=(8753) is still referenced from table "alf_child_assoc".
; SQL []; 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".; nested exception is 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".
2012-07-20 09:03:34,867 INFO [web.scripts.DictionaryQuery] [http-8080-25] Successfully retrieved dictionary information from Alfresco.
2012-07-20 09:04:00,463 ERROR [extensions.webscripts.AbstractRuntime] [http-8080-21] Exception from executeScript - redirecting to status template error: 06200003 Script url /api/upload;jsessionid=843AD0072B8623A2331A435EDB897879 does not map to a Web Script.
org.springframework.extensions.webscripts.WebScriptException: 06200003 Script url /api/upload;jsessionid=843AD0072B8623A2331A435EDB897879 does not map to a Web Script.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment