java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`))

Atlassian JIRA | Mei Yan Chan [Atlassian] | 9 years ago
  1. 0

    The problem of space removal when attachments are stored within the database occurred and generated the following error exception: {noformat} 2008-03-25 13:11:45,359 ERROR [http-8484-Processor3] [atlassian.xwork.interceptors.XWorkTransactionInterceptor] onThrowable Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) -- url: /spaces/doremovespace.action | userName: admin org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) {noformat} The same happened while using the embedded DB. Steps to replicate: # Migrate attachment storage to database # Delete the space (Please try the space export from CSP-16708)

    Atlassian JIRA | 9 years ago | Mei Yan Chan [Atlassian]
    java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`))
  2. 0

    The problem of space removal when attachments are stored within the database occurred and generated the following error exception: {noformat} 2008-03-25 13:11:45,359 ERROR [http-8484-Processor3] [atlassian.xwork.interceptors.XWorkTransactionInterceptor] onThrowable Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) -- url: /spaces/doremovespace.action | userName: admin org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`)) at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) {noformat} The same happened while using the embedded DB. Steps to replicate: # Migrate attachment storage to database # Delete the space (Please try the space export from CSP-16708)

    Atlassian JIRA | 9 years ago | Mei Yan Chan [Atlassian]
    java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`))
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    {checklist:name=Design Status: | parent=3000 Design | checklabels=mypplus_abnahme, mypplus_changerequests, mypplus_release1 | comment-heading=Comments} Cause: org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:99) caused by: java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:89) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:181) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:47) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:114) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:98) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:117) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:137) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:159) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:122) at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) Referer URL: http://wiki.namics.com/display/MYPPLUS/3000+Design Build Information: confluence.home: /home/confluence/data system.uptime: 5 days, 7 hours, 47 minutes, 21 seconds system.version: 2.5.4 build.number: 809 Server Information: Application Server: Apache Tomcat/5.5.15 Servlet Version: 2.4 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Database Driver Version: 3.1 Memory Information: total.memory: 254 MB free.memory: 105 MB used.memory: 149 MB System Information: system.date: Wednesday, 26 Sep 2007 system.time: 15:53:06 system.favourite.colour: Myrtle java.version: 1.4.2_10 java.vendor: Sun Microsystems Inc. jvm.version: 1.0 jvm.vendor: Sun Microsystems Inc. jvm.implementation.version: 1.4.2_10-b03 java.runtime: Java(TM) 2 Runtime Environment, Standard Edition java.vm: Java HotSpot(TM) Client VM user.name.word: root user.timezone: Europe/Zurich operating.system: Linux 2.6.9-5.0.5.ELsmp os.architecture: i386 fs.encoding: UTF-8 Cluster Information: Not clustered. Enabled Plugins: Checklists Macros (com.comalatech.checklists, Version: 1.2) Basic Macros (confluence.macros.basic, Version: 1.3) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.2) Chart Plugin (confluence.extra.chart, Version: 1.8) User Listener (confluence.extra.userlister, Version: 1.2) Global Labels Sections (confluence.sections.labels, Version: 1.0) Information Macros (confluence.extra.information, Version: 0.2) Page Operations (confluence.sections.page.operations, Version: 1.0) Task List Macros V2 (confluence.extra.tasklistv2, Version: 2.0.1) WebDAV Plugin (confluence.extra.webdav, Version: 1.1) Profile Tabs (confluence.sections.profile, Version: 1.0) Confluence Remote API (confluence.extra.confluencerpc, Version: 1.4) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Admin Sections (confluence.sections.admin, Version: 1.0) Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.3.2) TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 1.12) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) News Tabs (confluence.sections.news, Version: 1.0) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1) Attachments Macros (confluence.extra.attachments, Version: 1.4) IM Presence Macros (confluence.extra.impresence, Version: 0.1) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) Task List Macros (confluence.extra.tasklist, Version: 1.3) Redirection Macros (org.randombits.confluence.redirection, Version: 2.2) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Dynamic Task List Macros (confluence.extra.dynamictasklist, Version: 1.5) Core Extractors (confluence.extractors.core, Version: 1.4) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Page Tabs (confluence.sections.page, Version: 1.0) Core Listeners (confluence.listeners.core, Version: 1.3) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) Live Search Macros (confluence.extra.livesearch, Version: 1.6) Page View Links (confluence.sections.page.actions, Version: 1.0) JIRA Macros (confluence.extra.jira, Version: 1.6) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 0.9.1) Layout Macros (confluence.extra.layout, Version: 0.2) Excel Plugin (org.swift.confluence.excel, Version: 3.1) Tabular Metadata (confluence.extra.masterdetail, Version: 1.0) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Mail Page Plugin (com.atlassian.confluence.ext.mailpage, Version: 1.2) Calendar Plugin (confluence.extra.calendar, Version: 2.3) Testplan Plugins (com.pantero.confluence.plugins.testplans, Version: 1.1) Advanced Macros (confluence.macros.advanced, Version: 1.3) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.0-rc2) Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.4) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 1.0) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.1) Space Item Tabs (confluence.sections.space, Version: 1.0) Code Macro (confluence.macros.code, Version: 1.4) Request Information: URL: http://wiki.namics.com/500page.jsp - Scheme: http - Server: wiki.namics.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. Attributes: - javax.servlet.forward.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /plugins/checklists/setWikiInput.action - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - javax.servlet.error.message : - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - __sitemesh__using_stream : false - javax.servlet.error.request_uri : /plugins/checklists/setWikiInput.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@164109d - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /plugins/checklists/setWikiInput.action?entityId=4497&columnKey=Comments&cellId=DesignStatus_8332_537771500&pageId=8332&checklistId=DesignStatus&rows=5&cols=50&storeInRows=true&value=Besprochene%20%C3%84nderungen%20m%EF%BF%BDssen%20noch%20gemacht%20werden. - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: (HibernateTemplate): encountered SQLException [Data truncation: Data truncated for column 'text_val' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1 - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - cols = 50 - value = Besprochene Änderungen müssen noch gemacht werden. - rows = 5 - checklistId = DesignStatus - storeInRows = true - columnKey = Comments - cellId = DesignStatus_8332_537771500 - entityId = 4497 - pageId = 8332 Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Atlassian JIRA | 9 years ago | Thomas Link
    java.sql.BatchUpdateException: Data truncation: Data truncated for column 'text_val' at row 1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      Cannot delete or update a parent row: a foreign key constraint fails (`confdb_257_csp16708/attachmentdata`, CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `attachments` (`ATTACHMENTID`))

      at com.mysql.jdbc.ServerPreparedStatement.executeBatch()
    2. MySQL jdbc
      ServerPreparedStatement.executeBatch
      1. com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:648)
      1 frame