Bug 793668 (JBEPP-745)

Summary:	Unknown error when trying to save html document
Product:	[JBoss] JBoss Enterprise Portal Platform 5	Reporter:	Viliam Rockai <vrockai>
Component:	Site Publisher	Assignee:	Default User <jbpapp-maint>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.1.0.GA	CC:	theute, tkyjovsk
Target Milestone:	---
Target Release:	5.1.1.CR01
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/JBEPP-745
Whiteboard:	ContentExplorerPortlet eXo-JCR
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-08-03 16:42:29 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Viliam Rockai 2010-12-16 17:11:34 UTC

project_key: JBEPP

How to reproduce:
login as root
click on content manager
click on drive acme/ acme news 1/ default.html
click on edit document
change something
click on save draft


sp is running on default HSQL database


log:

18:10:32,809 ERROR [portal:UIPortalApplication] Error during the processAction phase
javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:227)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:526)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.save(ACLInheritanceSupportedWorkspaceDataManager.java:225)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:244)
	at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:366)
	at org.exoplatform.services.jcr.impl.core.NodeImpl.lock(NodeImpl.java:1564)
	at org.exoplatform.ecm.webui.component.explorer.control.action.EditDocumentActionComponent.editDocument(EditDocumentActionComponent.java:154)
	...
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
	at java.lang.Thread.run(Thread.java:619)
Caused by: javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.storage.jdbc.SQLExceptionHandler.handleAddException(SQLExceptionHandler.java:129)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:667)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:662)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:387)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:165)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.access$101(CacheableWorkspaceDataManager.java:54)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.action(CacheableWorkspaceDataManager.java:262)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.txAction(TxIsolatedOperation.java:92)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.txAction(CacheableWorkspaceDataManager.java:268)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:210)
	... 124 more
Caused by: java.sql.SQLException: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.hsqldb.jdbc.Util.throwError(Unknown Source)
	at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
	at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
	at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.SingleDbJDBCConnection.addPropertyRecord(SingleDbJDBCConnection.java:232)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:629)
	... 132 more
javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.storage.jdbc.SQLExceptionHandler.handleAddException(SQLExceptionHandler.java:129)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:667)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:662)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:387)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:165)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.access$101(CacheableWorkspaceDataManager.java:54)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.action(CacheableWorkspaceDataManager.java:262)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.txAction(TxIsolatedOperation.java:92)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.txAction(CacheableWorkspaceDataManager.java:268)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:210)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:526)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.save(ACLInheritanceSupportedWorkspaceDataManager.java:225)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:244)
	at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:366)
	at org.exoplatform.services.jcr.impl.core.NodeImpl.lock(NodeImpl.java:1564)
...

Comment 1 Tomas Kyjovsky 2010-12-16 23:16:20 UTC

Labels: Added: ContentExplorerPortlet eXo-JCR

Comment 2 Tomas Kyjovsky 2011-03-08 19:52:42 UTC

Related support issue: https://jira.exoplatform.org/browse/SPREDHAT-30

Comment 3 Scott Mumford 2011-07-11 07:05:02 UTC

This issue is resolved in eXo https://jira.exoplatform.org/browse/ECMS-1940.
Marking the Release Notes as "Not Yet Documented" pending the resolution of this JIRA.

Comment 4 Scott Mumford 2011-07-11 07:05:02 UTC

Release Notes Docs Status: Added: Not Yet Documented
Release Notes Text: Added: An 'Unknown error' encountered when attempting to save an HTML page has been resolved in this release.

Comment 5 Scott Mumford 2011-08-05 04:48:28 UTC

Release Notes Docs Status: Removed: Not Yet Documented Added: Documented as Resolved Issue