Ticket #136 (closed defect: fixed)

Opened 5 months ago

Last modified 8 weeks ago

Deleting a user causes a java error

Reported by: lkh Owned by: dbs
Priority: major Milestone: CONGO 2.1.0
Component: Coconut Version: 2.0
Keywords: Cc:

Description

Deleting a user from Coconut results in:

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (arisiav2/invoice_detail, CONSTRAINT fk_detail_rid FOREIGN KEY (detail_rid) REFERENCES reg_master (master_rid))

sun.reflect.NativeConstructorAccessorImpl?.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl?.newInstance(NativeConstructorAccessorImpl?.java:57)
sun.reflect.DelegatingConstructorAccessorImpl?.newInstance(DelegatingConstructorAccessorImpl?.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:532)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
com.mysql.jdbc.ConnectionImpl?.execSQL(ConnectionImpl?.java:2542)
com.mysql.jdbc.PreparedStatement?.executeInternal(PreparedStatement?.java:1734)
com.mysql.jdbc.PreparedStatement?.executeUpdate(PreparedStatement?.java:2019)
com.mysql.jdbc.PreparedStatement?.executeUpdate(PreparedStatement?.java:1937)
com.mysql.jdbc.PreparedStatement?.executeUpdate(PreparedStatement?.java:1922)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement?.executeUpdate(NewProxyPreparedStatement?.java:105)
com.stonekeep.congo.dao.RegistrantDAO.delete(RegistrantDAO.java:145)
com.stonekeep.congo.coconut.DeleteRegistrant?.execute(DeleteRegistrant?.java:27)
sun.reflect.NativeMethodAccessorImpl?.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl?.invoke(NativeMethodAccessorImpl?.java:57)
sun.reflect.DelegatingMethodAccessorImpl?.invoke(DelegatingMethodAccessorImpl?.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
com.opensymphony.xwork2.DefaultActionInvocation?.invokeAction(DefaultActionInvocation?.java:434)
com.opensymphony.xwork2.DefaultActionInvocation?.invokeActionOnly(DefaultActionInvocation?.java:273)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:235)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor?.doIntercept(DefaultWorkflowInterceptor?.java:141)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor?.intercept(MethodFilterInterceptor?.java:86)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.validator.ValidationInterceptor?.doIntercept(ValidationInterceptor?.java:248)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor?.doIntercept(AnnotationValidationInterceptor?.java:49)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor?.intercept(MethodFilterInterceptor?.java:86)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor?.intercept(ConversionErrorInterceptor?.java:124)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ParametersInterceptor?.doIntercept(ParametersInterceptor?.java:170)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor?.intercept(MethodFilterInterceptor?.java:86)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ParametersInterceptor?.doIntercept(ParametersInterceptor?.java:170)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor?.intercept(MethodFilterInterceptor?.java:86)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor?.intercept(StaticParametersInterceptor?.java:104)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.interceptor.CheckboxInterceptor?.intercept(CheckboxInterceptor?.java:84)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.interceptor.FileUploadInterceptor?.intercept(FileUploadInterceptor?.java:208)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor?.intercept(ModelDrivenInterceptor?.java:88)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor?.intercept(ScopedModelDrivenInterceptor?.java:127)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.interceptor.ProfilingActivationInterceptor?.intercept(ProfilingActivationInterceptor?.java:104)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor?.intercept(DebuggingInterceptor?.java:267)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ChainingInterceptor?.intercept(ChainingInterceptor?.java:130)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:143)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.PrepareInterceptor?.doIntercept(PrepareInterceptor?.java:137)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor?.intercept(MethodFilterInterceptor?.java:86)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.interceptor.ServletConfigInterceptor?.intercept(ServletConfigInterceptor?.java:164)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.AliasInterceptor?.intercept(AliasInterceptor?.java:130)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor?.intercept(ExceptionMappingInterceptor?.java:176)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.stonekeep.congo.interceptors.SessionChecker?.intercept(SessionChecker?.java:68)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
com.stonekeep.congo.interceptors.ToggleInterceptor?.intercept(ToggleInterceptor?.java:29)
sun.reflect.GeneratedMethodAccessor?81.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl?.invoke(DelegatingMethodAccessorImpl?.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.springframework.aop.support.AopUtils?.invokeJoinpointUsingReflection(AopUtils?.java:310)
org.springframework.aop.framework.ReflectiveMethodInvocation?.invokeJoinpoint(ReflectiveMethodInvocation?.java:182)
org.springframework.aop.framework.ReflectiveMethodInvocation?.proceed(ReflectiveMethodInvocation?.java:149)
org.springframework.aop.support.DelegatingIntroductionInterceptor?.doProceed(DelegatingIntroductionInterceptor?.java:131)
org.springframework.aop.support.DelegatingIntroductionInterceptor?.invoke(DelegatingIntroductionInterceptor?.java:119)
org.springframework.aop.framework.ReflectiveMethodInvocation?.proceed(ReflectiveMethodInvocation?.java:171)
org.springframework.aop.framework.JdkDynamicAopProxy?.invoke(JdkDynamicAopProxy?.java:204)
$Proxy11.intercept(Unknown Source)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:230)
com.opensymphony.xwork2.DefaultActionInvocation?$1.doProfiling(DefaultActionInvocation?.java:229)
com.opensymphony.xwork2.util.profiling.UtilTimerStack?.profile(UtilTimerStack?.java:456)
com.opensymphony.xwork2.DefaultActionInvocation?.invoke(DefaultActionInvocation?.java:227)
org.apache.struts2.impl.StrutsActionProxy?.execute(StrutsActionProxy?.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:477)
org.apache.struts2.dispatcher.FilterDispatcher?.doFilter(FilterDispatcher?.java:467)

Change History

Changed 2 months ago by nchanter

Is this a problem still? has this been fixed? I deleted someone and saw no error on 6/1

Changed 8 weeks ago by dbs

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.