You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Michael Johns (JIRA)" <ji...@codehaus.org> on 2008/11/10 22:12:13 UTC
[jira] Commented: (CONTINUUM-1972) Error attempting to delete
project group
[ http://jira.codehaus.org/browse/CONTINUUM-1972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=153727#action_153727 ]
Michael Johns commented on CONTINUUM-1972:
------------------------------------------
I cloned issue CONTINUUM-1630 rather than re-open it because I'm not sure this is the same problem. I get the same symptoms, inability to delete projects or groups, but the log message is slightly different, so I decided to create a new issue. Here's my current log message:
{code:java}
java.sql.SQLException: DELETE on table 'PROJECTDEPENDENCY' caused a violation of foreign key constraint 'PROJECT_FK3' for key (4858). The statement has been rolled back.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
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:77)
at org.apache.continuum.dao.BuildResultDaoImpl.removeBuildResult(BuildResultDaoImpl.java:259)
at org.apache.maven.continuum.DefaultContinuum.removeBuildResult(DefaultContinuum.java:1380)
at org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:899)
at org.apache.maven.continuum.web.action.ProjectsListAction.remove(ProjectsListAction.java:100)
at org.apache.maven.continuum.web.action.ProjectsListAction.execute(ProjectsListAction.java:68)
{code}
> Error attempting to delete project group
> ----------------------------------------
>
> Key: CONTINUUM-1972
> URL: http://jira.codehaus.org/browse/CONTINUUM-1972
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.1
> Reporter: Michael Johns
> Assignee: Emmanuel Venisse
> Fix For: 1.2
>
>
> When trying to delete a project group:
> 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 (5107). The statement has been rolled back.
> A snippet of the stack trace:
> javax.jdo.JDOUserException: One or more instances could not be deleted
> at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1525)
> at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1498)
> 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:1019)
> at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4405)
> at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473)
> at org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1489)
> at org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:121)
> at org.apache.maven.continuum.store.JdoContinuumStore.removeObject(JdoContinuumStore.java:1906)
> at org.apache.maven.continuum.store.JdoContinuumStore.removeBuildResult(JdoContinuumStore.java:600)
> at org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:719)
> at org.apache.maven.continuum.DefaultContinuum.removeProjectGroup(DefaultContinuum.java:278)
> at org.apache.maven.continuum.web.action.ProjectGroupAction.remove(ProjectGroupAction.java:263)
> [...]
--
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