Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@continuum.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Date: Wed, 24 Feb 2010 00:59:55 -0600 (CST)
From: "Brett Porter (JIRA)" <jira@codehaus.org>
To: issues@continuum.apache.org
Message-ID: 
 <17349328.92862.1266994795309.JavaMail.haus-jira@codehaus01.managed.contegix.com>
In-Reply-To: 
 <8441560.1209139306484.JavaMail.haus-jira@codehaus01.managed.contegix.com>
Subject: [jira] Commented: (CONTINUUM-1743) Provide better error handling if
 DELETE of project fails
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


    [ 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