Uploaded image for project: 'LAMS Development'
  1. LAMS Development
  2. LDEV-2470

Mindmap foreign key constraint failure

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.4
    • Component/s: Tool Mind Maps
    • Labels:
      None

      Description

      I found the following error in the server.log of a 2.3.2 server. From the access log looks like an automated once-a-minute POST back to server that's causing the exception. Todo: check out what's wrong here.

      2009-11-25 10:14:04,969 WARN [org.apache.struts.action.RequestProcessor] Unhandled Exception thrown: class org.hibernate.exception.GenericJDBCException
      2009-11-25 10:14:04,969 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/lams/tool/lamind10].[action]] Servlet.service() for servlet action threw exception
      org.hibernate.exception.GenericJDBCException: could not execute update query
              at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
              at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
              at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:99)
              at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:297)
              at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:857)
              at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)
              at org.lamsfoundation.lams.tool.mindmap.dao.hibernate.MindmapNodeDAO.deleteNodes(MindmapNodeDAO.java:86)
              at org.lamsfoundation.lams.tool.mindmap.service.MindmapService.deleteNodes(MindmapService.java:927)
              at sun.reflect.GeneratedMethodAccessor2146.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165)
              at $Proxy57.deleteNodes(Unknown Source)
              at org.lamsfoundation.lams.tool.mindmap.web.actions.LearningAction.saveMindmapXML(LearningAction.java:673)
              at org.lamsfoundation.lams.tool.mindmap.web.actions.LearningAction.saveLastMindmapChanges(LearningAction.java:641)
              at sun.reflect.GeneratedMethodAccessor2147.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
              at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
      ...
      Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`lams2/tl_lamind10_node`, CONSTRAINT `MindmapNode_Parent_FK` FOREIGN KEY (`parent_id`) REFERENCES `tl_lamind10_node` (`node_id`))
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
              at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
              at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
              at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:76)
              ... 61 more


      10.14.143.98 - ken.fu [25/Nov/2009:09:55:04 +1000] "GET /lams/tool/lamind10/learning.do?dispatch=setMindmapContent&mindmapId=494&u
      serId=575&sessionId=26255&noCache=125910318259973 HTTP/1.1" 200 4286
      10.14.143.98 - ken.fu [25/Nov/2009:09:56:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:09:57:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:09:58:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:09:59:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:00:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:01:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:02:03 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:03:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:04:01 +1000] "GET /lams/images/css/diagonal_bg.gif HTTP/1.1" 304 -
      10.14.143.98 - ken.fu [25/Nov/2009:10:04:01 +1000] "GET /lams/images/css/btn_off.gif HTTP/1.1" 304 -
      10.14.143.98 - ken.fu [25/Nov/2009:10:04:01 +1000] "GET /lams/images/css/next.png HTTP/1.1" 304 -
      10.14.143.98 - ken.fu [25/Nov/2009:10:04:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621
      10.14.143.98 - ken.fu [25/Nov/2009:10:05:04 +1000] "POST /lams/tool/lamind10/learning.do HTTP/1.1" 500 4621

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            ernieg Ernie Ghiglione
            Reporter:
            jundirl Jun-Dir Liew
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development