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

RS/Db Runtime Exception Find failed in transaction ConstraintViolationException

    XMLWordPrintable

    Details

      Description

      occurred two times in a row (20 seconds apart) on bfgs

      2012-01-05 21:32:10,404 [TP-Processor9] ERROR DBRuntimeException - OLAT::ERROR % N14-E15 % org.olat.core.logging % % 178.199.151.94 % https://*********/auth/1%3A1%3A0%3A0%3A0/ % Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0 % *RedScreen* Find failed in transaction. Query: from v in class org.olat.properties.Property where v.identity is null and v.grp is null and v.resourceTypeName = ? and v.resourceTypeId = ? and v.category = ? and v.name = ? org.hibernate.exception.ConstraintViolationException: could not insert: [org.olat.properties.Property] ::::<dispatchinfo> <componentinfo> <compname>table</compname> <compclass>org.olat.core.gui.components.table.Table</compclass> <extendedinfo>n/a</extendedinfo> <event> <class>org.olat.core.gui.components.table.TableEvent</class> <command>r</command> <tostring>cmd:r, rowId:1, actionId:bgTblLaunch</tostring> </event> </componentinfo> <controllerinfo> <controllername>org.olat.core.gui.components.table.TableController</controllername> <controllername>org.olat.group.ui.main.BGMainController</controllername> <controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername> <controllername>org.olat.core.commons.chiefcontrollers.controller.simple.SimpleBaseController</controllername> <controllername>org.olat.core.commons.chiefcontrollers.BaseChiefController</controllername> </controllerinfo></dispatchinfo> :::: %
      >>> stack of 1.cause::org.olat.core.logging.DBRuntimeException: Find failed in transaction. Query: from v in class org.olat.properties.Property where v.identity is null and v.grp is null and v.resourceTypeName = ? and v.resourceTypeId = ? and v.category = ? and v.name = ? org.hibernate.exception.ConstraintViolationException: could not insert: [org.olat.properties.Property] -> at org.olat.core.commons.persistence.DBManager.find(DBManager.java:214) at org.olat.core.commons.persistence.DBImpl.find(DBImpl.java:492) at org.olat.properties.PropertyManager.findProperties(PropertyManager.java:396) at org.olat.properties.PropertyManager.findProperties(PropertyManager.java:334) at org.olat.properties.PropertyManager.findProperty(PropertyManager.java:487) at org.olat.collaboration.CollaborationTools.getPropertyOf(CollaborationTools.java:678) at org.olat.collaboration.CollaborationTools.isToolEnabled(CollaborationTools.java:576) at org.olat.group.ui.run.BusinessGroupMainRunController.buildTreeModel(BusinessGroupMainRunController.java:1096) at org.olat.group.ui.run.BusinessGroupMainRunController.<init>(BusinessGroupMainRunController.java:259) at org.olat.group.ui.BGControllerFactory.createRunControllerFor(BGControllerFactory.java:140) at org.olat.group.ui.BGControllerFactory.createRunControllerAsTopNavTab(BGControllerFactory.java:178)
      >>> stack of 2.cause::org.hibernate.exception.ConstraintViolationException: could not insert: [org.olat.properties.Property] -> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:997)
      >>> stack of 3.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`****`.`o_property`, CONSTRAINT `FKB60B1BA5190E5` FOREIGN KEY (`grp`) REFERENCES `o_gp_business` (`group_id`)) -> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            strentini Sergio Trentini
            Tester:
            Sergio Trentini
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2 hours Original Estimate - 2 hours
                2h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h