Continuum

Unable to delete build definition with already executed builds

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.1, 1.3.4 (Beta)
  • Fix Version/s: None
  • Component/s: Data Management
  • Environment:
    Oracle 9i, but it probably doesn't matter
  • Complexity:
    Intermediate
  • Number of attachments :
    0

Description

A try to delete a build definition with already executed builds causes an error message:
org.apache.maven.continuum.ContinuumException: Error while executing the action 'remove-build-definition-from-project'.

It's necessary to manually delete all build results for that build definition first.

A stacktrace (an error ORA-02292 is about integrity constraint violation).

org.apache.maven.continuum.ContinuumException: Error while executing the action 'remove-build-definition-from-project'.
at org.apache.maven.continuum.DefaultContinuum.executeAction(DefaultContinuum.java:2824)
at org.apache.maven.continuum.DefaultContinuum.removeBuildDefinitionFromProject(DefaultContinuum.java:2206)
at org.apache.maven.continuum.web.action.BuildDefinitionAction.removeFromProject(BuildDefinitionAction.java:372)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
at org.codehaus.plexus.xwork.interceptor.PlexusReleaseComponentInterceptor.intercept(PlexusReleaseComponentInterceptor.java:69)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:175)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.apache.maven.continuum.web.interceptor.ForceContinuumConfigurationInterceptor.intercept(ForceContinuumConfigurationInterceptor.java:72)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.redback.xwork.interceptor.PolicyEnforcementInterceptor.intercept(PolicyEnforcementInterceptor.java:149)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.redback.xwork.interceptor.SecureActionInterceptor.intercept(SecureActionInterceptor.java:178)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:58)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:175)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:174)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.webwork.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:169)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.redback.xwork.interceptor.AutoLoginInterceptor.intercept(AutoLoginInterceptor.java:156)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.redback.xwork.interceptor.ForceAdminUserInterceptor.intercept(ForceAdminUserInterceptor.java:76)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at org.codehaus.plexus.redback.xwork.interceptor.EnvironmentCheckInterceptor.intercept(EnvironmentCheckInterceptor.java:122)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: javax.jdo.JDODataStoreException: Transaction failed to commit
NestedThrowables:
java.sql.SQLException: ORA-02091: transakcja zosta?a wycofana
ORA-02292: naruszono wi?zy integralno?ci (CONTINUUM.BUILDRESULT_FK1) - znaleziono rekord podrz?dny

at org.jpox.store.rdbms.RDBMSNonmanagedTransaction.commit(RDBMSNonmanagedTransaction.java:467)
at org.codehaus.plexus.jdo.PlexusJdoUtils.updateObject(PlexusJdoUtils.java:163)
at org.apache.maven.continuum.store.JdoContinuumStore.updateObject(JdoContinuumStore.java:1080)
at org.apache.maven.continuum.store.JdoContinuumStore.updateObject(JdoContinuumStore.java:1072)
at org.apache.maven.continuum.store.JdoContinuumStore.updateProject(JdoContinuumStore.java:1456)
at org.apache.maven.continuum.core.action.RemoveBuildDefinitionFromProjectAction.execute(RemoveBuildDefinitionFromProjectAction.java:52)
at org.apache.maven.continuum.DefaultContinuum.executeAction(DefaultContinuum.java:2810)
... 82 more
Caused by: java.sql.SQLException: ORA-02091: transakcja zosta?a wycofana
ORA-02292: naruszono wi?zy integralno?ci (CONTINUUM.BUILDRESULT_FK1) - znaleziono rekord podrz?dny

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:141)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:524)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1147)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)
at org.jpox.store.rdbms.RDBMSNonmanagedTransaction.commit(RDBMSNonmanagedTransaction.java:407)
... 88 more

Issue Links

is duplicated by

Bug - A problem which impairs or prevents the functions of the product. CONTINUUM-1921 foreign key constraint violation when deleting projects

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
relates to

Bug - A problem which impairs or prevents the functions of the product. CONTINUUM-1743 Provide better error handling if DELETE of project fails

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Marcin Zajaczkowski added a comment -

It's a little bit inconvenient, when you some build definition used for long time and suddenly it become invalid (like regular builds with Java 1.4 as an addition to 1.5 builds and a fact that project drops 1.4 support). There are no an easy way to remove that build definition. As a workaround you can only change Schedule to something which is never called.

Show
Marcin Zajaczkowski added a comment - It's a little bit inconvenient, when you some build definition used for long time and suddenly it become invalid (like regular builds with Java 1.4 as an addition to 1.5 builds and a fact that project drops 1.4 support). There are no an easy way to remove that build definition. As a workaround you can only change Schedule to something which is never called.
Hide
Permalink
Paul Benedict added a comment -

Or at least hiding or invaliding further use of it so it no longer appears.

Show
Paul Benedict added a comment - Or at least hiding or invaliding further use of it so it no longer appears.
Hide
Permalink
Wendy Smoak added a comment -

Confirmed in 1.3.4. A group level build definition with related build results cannot be deleted.

No error shows on the page, the build def just doesn't go away. In the logs I see:

2009-09-09 22:38:52,317 [btpool0-9] WARN  JPOX.JDO  - Execution of method "remove" on field "buildDefinitions" caused an error : Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ?
javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ?
	at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:288)
	at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611)
...
NestedThrowablesStackTrace:
ERROR 23503: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK3' for key (25).  The statement has been rolled back.
...
Show
Wendy Smoak added a comment - Confirmed in 1.3.4. A group level build definition with related build results cannot be deleted. No error shows on the page, the build def just doesn't go away. In the logs I see: 2009-09-09 22:38:52,317 [btpool0-9] WARN JPOX.JDO - Execution of method "remove" on field "buildDefinitions" caused an error : Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:288) at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611) ... NestedThrowablesStackTrace: ERROR 23503: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK3' for key (25). The statement has been rolled back. ...

People

  • Assignee:
    Unassigned
    Reporter:
    Marcin Zajaczkowski
Vote (0)
Watch (1)

Dates

  • Created:
    Updated: