[
http://jira.codehaus.org/browse/CONTINUUM-1743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=211386#action_211386
]
Brett Porter commented on CONTINUUM-1743:
-----------------------------------------
Here is the full trace when it occurs:
{code}
ERROR 23503: DELETE on table 'PROJECTDEPENDENCY' caused a violation of foreign
key constraint 'PROJECT_FK2' for key (3024679). The statement has been rolled
back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown
Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:575)
at
org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:274)
at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611)
at org.jpox.store.StoreManager.delete(StoreManager.java:1025)
at
org.jpox.state.StateManagerImpl.internalDeletePersistent(StateManagerImpl.java:4468)
at
org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4423)
at
org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1489)
at
org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1532)
at
org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1514)
at
org.jpox.store.rdbms.scostore.FKListStore.clear(FKListStore.java:1137)
at
org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:334)
at
org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2651)
at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:1076)
at
org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4405)
at
org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1489)
at
org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1505)
at
org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:121)
at
org.apache.continuum.dao.AbstractDao.removeObject(AbstractDao.java:79)
at
org.apache.continuum.dao.BuildResultDaoImpl.removeBuildResult(BuildResultDaoImpl.java:295)
at
org.apache.maven.continuum.DefaultContinuum.removeBuildResult(DefaultContinuum.java:1086)
at
org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:671)
at
org.apache.maven.continuum.web.action.ProjectsListAction.remove(ProjectsListAction.java:109)
at
org.apache.maven.continuum.web.action.ProjectsListAction.execute(ProjectsListAction.java:74)
{code}
> Provide better error handling if DELETE of project fails
> --------------------------------------------------------
>
> Key: CONTINUUM-1743
> URL: http://jira.codehaus.org/browse/CONTINUUM-1743
> Project: Continuum
> Issue Type: Bug
> Components: Database, Web - UI
> Affects Versions: 1.1
> Environment: Linux RedHat
> Reporter: Andreas Guther
> Fix For: Backlog
>
>
> It appears that it is not possible to delete a project if it is in a certain
> state. The error message though is not very helpful:
> javax.jdo.JDOUserException: One or more instances could not be deleted
> NestedThrowables: javax.jdo.JDODataStoreException: Delete request
> failed: DELETE FROM PROJECTDEPENDENCY WHERE PROJECTDEPENDENCY_ID=?
> NestedThrowables: SQL Exception: DELETE on table 'PROJECTDEPENDENCY'
> caused a violation of foreign key constraint 'PROJECT_FK2' for key (40580).
> The statement has been rolled back.
> We had a process that seemed to be stuck. We tried then to delete the
> project but this only caused the error message above. I believe that
> Continuum could not delete the project because it was in a state that does
> not allow deleting it. If this is the case I would like to suggest to
> provide a better error handling letting the user know why the delete failed.
> We finally could delete the project after we restarted Continnum (not sure if
> this was necessary, but that is what we did) and then building the project
> again. This time it went through and after the build was successful, we
> could delete the project.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
