-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.3.7
-
Component/s: Course
-
Labels:None
-
Funded by:
How to reproduce:
- create a course template with a group task element, configure it.
- copy the course template
- delete the copied course without publishing it
2015-10-06 16:06:57,883 [ajp-nio2-8059-exec-9] ERROR DBRuntimeException - OLAT::ERROR ^%^ N59-E37 ^%^ org.olat.core.logging Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:40.0) Gecko/20100101 Firefox/40.0 ^%^ **RedScreen** commit failed, rollback transaction <dispatchinfo> <componentinfo> <compname>ffo_main_confirm_delete</compname> <compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass> <extendedinfo>n/a</extendedinfo> <event> <class>org.olat.core.gui.components.form.flexible.impl.FormEvent</class> <command>done</command> <tostring>com:done,org.olat.core.gui.components.form.flexible.impl.FormEvent@2f23a1</tostring> </event> </componentinfo> <controllerinfo> <controllername>org.olat.repository.ui.author.ConfirmDeleteController</controllername> <controllername>org.olat.repository.ui.author.AuthorListController</controllername> <controllername>org.olat.repository.ui.author.OverviewAuthoringController</controllername> <controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername> </controllerinfo> </dispatchinfo> >>> 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:357) 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:357) 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:357) 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.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.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::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`avaloq`.`o_gta_task_list`, CONSTRAINT `gta_list_to_repo_entry_idx` FOREIGN KEY (`fk_entry`) REFERENCES `o_repositoryentry` (`repositoryentry_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:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)