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

ClusterEventTracking gets hung up when an error occurs

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.6, 11.0
    • Fix Version/s: 10.8 [Tentative], 11.2, 12.0
    • Component/s: Kernel
    • Labels:
      None
    • 11 status:
      Resolved
    • 10 status:
      Resolved
    • Previous Issue Keys:
      KNL-1436

      Description

      When the ClusterEventTracking thread dies no events are written to the log. The following stack will appear:

      2016-05-15 04:21:44,054  WARN org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$3f5f66c1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select SAKAI_EVENT.EVENT_ID,SAKAI_EVENT.EVENT_DATE,SAKAI_EVENT.EVENT,SAKAI_EVENT.REF,SAKAI_EVENT.SESSION_ID,SAKAI_EVENT.EVENT_CODE,SAKAI_EVENT.CONTEXT,SAKAI_SESSION.SESSION_SERVER from SAKAI_EVENT left join SAKAI_SESSION ON SAKAI_EVENT.SESSION_ID = SAKAI_SESSION.SESSION_ID where (SAKAI_EVENT.EVENT_ID > ?) 375127593
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure                                                                                                                                                                                                                                                    The last packet successfully received from the server was 5,001 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.                  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)                                                                                            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)                                                                     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)                                                             at java.lang.reflect.Constructor.newInstance(Constructor.java:526)                                                                                                  at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)                                                                                                             at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:983)
              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3457)                                                                                                     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3357)                                                                                                     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3797)                                                                                                       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)                                                                                                            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)                                                                                                         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)                                                                                                  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)                                                                                    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)                                                                                       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)                                                            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)                                                            at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:553)
              at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
              at org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:623)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
              at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2949)
              at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3367)
              ... 13 more
      Exception in thread "org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$3f5f66c1" java.lang.AssertionError: java.sql.SQLException: Already closed.          at org.sakaiproject.db.impl.BasicSqlService.returnConnection(BasicSqlService.java:286)
              at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:619)
              at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
              at org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:623)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: Already closed.
              at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
              at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
              at org.sakaiproject.db.impl.BasicSqlService.returnConnection(BasicSqlService.java:282)
              ... 4 more
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ern Earle R Nietzel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code