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

RS delete a course with references

    XMLWordPrintable

    Details

      Description

      Error#: N63-E473 
      User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/600.6.3 (KHTML, like Gecko) Version/7.1.6 Safari/537.85.15 Log msg: **RedScreen** commit failed, rollback transaction 
      
      org.olat.repository.ui.author.ConfirmDeleteController
      org.olat.repository.ui.RepositoryEntryRuntimeController
      org.olat.core.commons.fullWebApp.BaseFullWebappController
      
      Cause: stack of 1.cause::org.olat.core.logging.DBRuntimeException: commit failed, rollback transaction
      -> at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:782)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:363)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         at org.olat.repository.ui.author.ConfirmDeleteController.deleteEntries(ConfirmDeleteController.java:289)
         at org.olat.repository.ui.author.ConfirmDeleteController.doCompleteDelete(ConfirmDeleteController.java:236)
         at org.olat.repository.ui.author.ConfirmDeleteController.formInnerEvent(ConfirmDeleteController.java:207)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:408)
         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 2.cause::javax.persistence.RollbackException: Error while committing the transaction
      -> at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:94)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:736)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:363)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         at org.olat.repository.ui.author.ConfirmDeleteController.deleteEntries(ConfirmDeleteController.java:289)
         at org.olat.repository.ui.author.ConfirmDeleteController.doCompleteDelete(ConfirmDeleteController.java:236)
         at org.olat.repository.ui.author.ConfirmDeleteController.formInnerEvent(ConfirmDeleteController.java:207)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:408)
         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)
      stack of 3.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.TransactionImpl.commit(TransactionImpl.java:82)
         at org.olat.core.commons.persistence.DBImpl.commit(DBImpl.java:736)
         at org.olat.repository.manager.RepositoryServiceImpl.deleteRepositoryEntryAndBaseGroups(RepositoryServiceImpl.java:363)
         at org.olat.repository.manager.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:335)
         at org.olat.repository.ui.author.ConfirmDeleteController.deleteEntries(ConfirmDeleteController.java:289)
         at org.olat.repository.ui.author.ConfirmDeleteController.doCompleteDelete(ConfirmDeleteController.java:236)
         at org.olat.repository.ui.author.ConfirmDeleteController.formInnerEvent(ConfirmDeleteController.java:207)
         at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:408)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:202)
      stack of 4.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)
         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.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3403)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3630)
         at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:114)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
         at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
      stack of 5.cause::org.postgresql.util.PSQLException: ERROR: update or delete on table "o_olatresource" violates foreign key constraint "fke971b4589ac44fbf" on table "o_references" Detail: Key (resource_id)=(98330) is still referenced from table "o_references".
      -> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3403)
         at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3630)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Tester:
            Florian Gnägi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 40 minutes
                1h 40m