Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40277

GBNG stack trace error on isanotheruserediting

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 12.5, 19.0
    • Fix Version/s: 12.6, 19.0
    • Component/s: Gradebook
    • Labels:
    • 12 status:
      Resolved
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      Seeing this Mysql error a lot in the logs on 19 for

      /direct/gbng/isotheruserediting

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
      

      Not 100% sure what's calling it. Looks like the method getGradingEvents changed in 12.1 on SAK-33464 so maybe there? Not 100% sure.

      Request URI: /direct/gbng/isotheruserediting/74a8fdeb-95b1-462b-baa6-8bda193e57a6.json
       Path Info: /gbng/isotheruserediting/74a8fdeb-95b1-462b-baa6-8bda193e57a6.json
       Context path: /direct
       Method: GET
       
      Server: ip-172-31-7-189-1530807994446
       User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36
       Browser ID: Win-Mozilla
       IP address: 137.159.216.47
       User ID: 7f56be92-6d28-43f5-8aaf-38540d1d6dfc
       User EID: instructor01
       User Display ID: instructor01
        :{}
      java.lang.RuntimeException: Fatal error trying to execute custom action method: isotheruserediting:list:isAnotherUserEditing
      	at org.sakaiproject.entitybroker.rest.EntityActionsManager.handleCustomActionExecution(EntityActionsManager.java:231)
      	at org.sakaiproject.entitybroker.rest.EntityActionsManager.handleCustomActionRequest(EntityActionsManager.java:96)
      	at org.sakaiproject.entitybroker.rest.EntityHandlerImpl.handleEntityAccess(EntityHandlerImpl.java:409)
      	at org.sakaiproject.entitybroker.util.servlet.DirectServlet.dispatch(DirectServlet.java:189)
      	at org.sakaiproject.entitybroker.servlet.SakaiDirectServlet.dispatch(SakaiDirectServlet.java:148)
      	at org.sakaiproject.entitybroker.util.servlet.DirectServlet.handleRequest(DirectServlet.java:159)
      	at org.sakaiproject.entitybroker.util.servlet.DirectServlet.service(DirectServlet.java:134)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.sakaiproject.oauth.filter.OAuthPostFilter.doFilter(OAuthPostFilter.java:76)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:475)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.sakaiproject.oauth.filter.OAuthPreFilter.doFilter(OAuthPreFilter.java:74)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
      	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412)
      	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
      	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
      	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.reflect.InvocationTargetException
      	at sun.reflect.GeneratedMethodAccessor1462.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.sakaiproject.entitybroker.rest.EntityActionsManager.handleCustomActionExecution(EntityActionsManager.java:206)
      	... 38 more
      Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:146)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      	at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
      	at org.sakaiproject.component.gradebook.GradebookServiceHibernateImpl.getGradingEvents(GradebookServiceHibernateImpl.java:3784)
      	at sun.reflect.GeneratedMethodAccessor1463.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
      	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
      	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
      	at com.sun.proxy.$Proxy110.getGradingEvents(Unknown Source)
      	at org.sakaiproject.gradebookng.business.GradebookNgBusinessService.getEditingNotifications(GradebookNgBusinessService.java:1834)
      	at org.sakaiproject.gradebookng.rest.GradebookNgEntityProvider.isAnotherUserEditing(GradebookNgEntityProvider.java:132)
      	... 42 more
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
      	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)
      	at org.hibernate.loader.Loader.doList(Loader.java:2540)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
      	at org.hibernate.loader.Loader.list(Loader.java:2365)
      	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
      	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
      	at org.sakaiproject.component.gradebook.GradebookServiceHibernateImpl.lambda$getGradingEvents$19(GradebookServiceHibernateImpl.java:3781)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
      	... 58 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
      	at sun.reflect.GeneratedConstructorAccessor78.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      	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:939)
      	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)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
      	... 74 more
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code