[
http://jira.nuxeo.org/browse/NXP-4029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61529#action_61529
]
Florent Guillaume commented on NXP-4029:
----------------------------------------
Simplified logging between 5.3 RC and 5.3 GA:
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/0d6739528504
> Nuxeo crashes after database transaction error
> ----------------------------------------------
>
> Key: NXP-4029
> URL: http://jira.nuxeo.org/browse/NXP-4029
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.2 RC1
> Reporter: Stéphane Lacoin
> Assignee: Thierry Delprat
> Priority: Blocker
> Fix For: 5.2 RC1 SP1, 5.2 GA SP1, 5.3 RC
>
> Attachments: nuxeo-core-storage-sql-1.5.0-RC1-NXP-4029.jar,
> patch-5.2.RC1-NXP-4029.diff
>
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> We observed at multiple time that nuxeo dm stops to serve requests after the
> occurence of a PostgreSQL error.
> At the same time, Arjuna starts to warn about transactions that are not
> recoverable.
> The temporary workaround that we have found is to manually remove the
> postgreSQL prepared transaction and to restart the server with a cleaned
> tx-object-store.
> Following is an extract of exceptions reported in server log :
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.postgresql.util.PSQLException. message: ERROR: insert or update on table
> "hierarchy" violates foreign key constraint "hierarchy_parentid_hierarchy_fk"
> Detail: Key (parentid)=(30243e0f-f1f8-4113-93b8-14d3de03850a) is not
> present in table "hierarchy".
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
> at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
> at $Proxy374.execute(Unknown Source)
> at
> org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:799)
> ... 48 more
> 2009-09-14 13:42:21,763 WARN [com.arjuna.ats.jta.logging.loggerI18N]
> [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa]
> [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not
> find new XAResource to use f
> or recovering non-serializable XAResource
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
