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

RS creating a new course

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.4
    • Component/s: Course
    • Labels:
      None

      Description

      @Tester: the issue cannot be reproduce. It's a problem with the lock system. My solution is to remove the lock on creation of course. We lock too much things in OpenOLAT

      2015-11-05 09:12:17,951 [ajp-nio2-8021-exec-51] ERROR DBRuntimeException - OLAT::ERROR ^%^ N1-E38 ^%^ org.olat.core.logging 
      Mozilla/5.0 (Windows NT 6.1; rv:38.0) Gecko/20100101 Firefox/38.0 ^%^ **RedScreen** Error in list()
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_null</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.repository.ui.author.CreateRepositoryEntryController</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: Error in list()
      -> at org.olat.core.commons.persistence.DBQueryImpl.list(DBQueryImpl.java:181)
         at org.olat.resource.lock.pessimistic.PessimisticLockManager.findPLock(PessimisticLockManager.java:89)
         at org.olat.resource.lock.pessimistic.PessimisticLockManager.findOrPersistPLock(PessimisticLockManager.java:129)
         at org.olat.commons.coordinate.cluster.ClusterSyncer.doInSync(ClusterSyncer.java:92)
         at org.olat.commons.coordinate.cluster.ClusterSyncer.doInSync(ClusterSyncer.java:129)
         at org.olat.course.CourseFactory.setCourseConfig(CourseFactory.java:912)
         at org.olat.repository.handlers.CourseHandler.createResource(CourseHandler.java:160)
         at org.olat.repository.ui.author.CreateRepositoryEntryController.doCreate(CreateRepositoryEntryController.java:168)
         at org.olat.repository.ui.author.CreateRepositoryEntryController.formOK(CreateRepositoryEntryController.java:144)
         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)
      >>> stack of 2.cause::org.hibernate.exception.LockAcquisitionException: could not extract ResultSet
      -> at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:451)
         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.extract(ResultSetReturnImpl.java:91)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
         at org.hibernate.loader.Loader.doQuery(Loader.java:910)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
         at org.hibernate.loader.Loader.doList(Loader.java:2554)
      >>> stack of 3.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      -> 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:985)
         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)
      

        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 - 1 hour, 10 minutes
                1h 10m