Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-1854

RS if save a post in a deleted thread

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.4.8
    • Component/s: Forum tool
    • Labels:
      None

      Description

      2016-01-21 10:26:40,819 [ajp-nio2-8026-exec-16] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N26-E24 ^%^ org.olat.core.logging
      
      https://xyz.olat.com/auth/RepositoryEntry/17858568/CourseNode/85372119390274/Message/134742016 ^%^ Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 Safari/537.36
      
      **RedScreen** org.hibernate.exception.ConstraintViolationException: could not execute statement
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_vertical</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.modules.fo.ui.MessageEditController</controllername>
      		<controllername>org.olat.modules.fo.ui.MessageListController</controllername>
      		<controllername>org.olat.modules.fo.ui.ForumController</controllername>
      		<controllername>org.olat.course.nodes.fo.FOCourseNodeRunController</controllername>
      		<controllername>org.olat.course.run.RunMainController</controllername>
      		<controllername>org.olat.course.run.CourseRuntimeController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      >>> stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:116)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:57)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:46)
         at org.olat.core.gui.components.Window.dispatchRequest(Window.java:536)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:234)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:298)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:216)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:289)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:232)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
      >>> stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
         at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)
         at org.olat.modules.fo.manager.ForumManager.loadMessage(ForumManager.java:660)
         at org.olat.modules.fo.manager.ForumManager.markAsRead(ForumManager.java:956)
         at org.olat.modules.fo.ui.MessageEditController.formOK(MessageEditController.java:422)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:367)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
         at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
      >>> stack of 3.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
         at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
         at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
      >>> stack of 4.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`bfgs`.`o_message`, CONSTRAINT `FKF26C8377B66B0D0` FOREIGN KEY (`parent_id`) REFERENCES `o_message` (`message_id`))
      -> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
         at com.mysql.jdbc.Util.getInstance(Util.java:387)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              srosse Stéphane Rossé
              Tester:
              Kirsten Scherer
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 45 minutes
                45m