Internal error deleting a used schedule ---------------------------------------
Key: CONTINUUM-927 URL: http://jira.codehaus.org/browse/CONTINUUM-927 Project: Continuum Issue Type: Bug Components: Core system Affects Versions: 1.1 Environment: acegi branch Reporter: Carlos Sanchez I think it's caused because some projects use it If you remove a schedule it has to be removed from all projects, probably just set a cascade delete 34792553 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Unactivating schedule 15 MINUTES 34792553 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Stopping active schedule "15 MINUTES". 34792553 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Activating schedule 15 MINUTES 34792554 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Mon Sep 18 13:00:00 PDT 2006 34826137 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Unactivating schedule 15 MINUTES 34826137 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Stopping active schedule "15 MINUTES". 34826137 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Activating schedule 15 MINUTES 34826138 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Mon Sep 18 13:00:00 PDT 2006 34840307 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Unactivating schedule 15 MINUTES 34840307 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Stopping active schedule "15 MINUTES". 34840307 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Activating schedule 15 MINUTES 34840309 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Mon Sep 18 13:00:00 PDT 2006 34852652 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Unactivating schedule 15 MINUTES 34852652 [btpool0-3] INFO org.apache.maven.continuum.build.settings.SchedulesActivator - Stopping active schedule "15 MINUTES". 34852724 [btpool0-3] INFO com.opensymphony.xwork.interceptor.Interceptor:exceptionLogging - Error ocurred during execution javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM SCHEDULE WHERE ID = ? at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:274) at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2471) at org.jpox.store.StoreManager.delete(StoreManager.java:836) at org.jpox.state.StateManagerImpl.internalDeletePersistent(StateManagerImpl.java:4217) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4172) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1393) at org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1404) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:119) at org.apache.maven.continuum.store.JdoContinuumStore.removeObject(JdoContinuumStore.java:1052) at org.apache.maven.continuum.store.JdoContinuumStore.removeSchedule(JdoContinuumStore.java:857) at org.apache.maven.continuum.DefaultContinuum.removeSchedule(DefaultContinuum.java:1574) at org.apache.maven.continuum.security.acegi.ContinuumDelegate.removeSchedule(ContinuumDelegate.java:486) at org.apache.maven.continuum.web.action.ScheduleAction.remove(ScheduleAction.java:146) 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:364) at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:216) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) 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:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at org.codehaus.plexus.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:62) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at org.acegisecurity.webwork.AcegiDispatcherUtils.serviceAction(AcegiDispatcherUtils.java:117) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) 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.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:621) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141) at org.mortbay.jetty.Server.handle(Server.java:269) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:692) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339) at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475) NestedThrowablesStackTrace: ERROR 23503: DELETE on table 'SCHEDULE' caused a violation of foreign key constraint 'BUILDDEFINITKW_FK2' for key (6). 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.execute(Unknown Source) at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88) at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:260) at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2471) at org.jpox.store.StoreManager.delete(StoreManager.java:836) at org.jpox.state.StateManagerImpl.internalDeletePersistent(StateManagerImpl.java:4217) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4172) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1393) at org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1404) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:119) at org.apache.maven.continuum.store.JdoContinuumStore.removeObject(JdoContinuumStore.java:1052) at org.apache.maven.continuum.store.JdoContinuumStore.removeSchedule(JdoContinuumStore.java:857) at org.apache.maven.continuum.DefaultContinuum.removeSchedule(DefaultContinuum.java:1574) at org.apache.maven.continuum.security.acegi.ContinuumDelegate.removeSchedule(ContinuumDelegate.java:486) at org.apache.maven.continuum.web.action.ScheduleAction.remove(ScheduleAction.java:146) 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:364) at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:216) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168) at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) 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:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at org.codehaus.plexus.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:62) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) at org.acegisecurity.webwork.AcegiDispatcherUtils.serviceAction(AcegiDispatcherUtils.java:117) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) 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.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.codehaus.plexus.xwork.filter.FilterToComponentProxy.doFilter(FilterToComponentProxy.java:186) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:621) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141) at org.mortbay.jetty.Server.handle(Server.java:269) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:692) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339) at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475) -- 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