Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-1994

Bitarchive - spurious java.sql.SQLNonTransientConnectionException / java.lang.ArrayIndexOutOfBoundsException

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 3.18.0
    • None
    • None
    • None
    • SB/KB
    • Hide

      Verified by running releasetest TEST11B

      Show
      Verified by running releasetest TEST11B

    Description

      While running the TEST11B I was browsing the Firestatus and at one point moving back in the browser history I got this exception. I have not been able to reproduce it yet.

      SQL error executing statement org.apache.derby.client.am.PreparedStatement40@9f5742
      SQLException trace:
      SQL State:08006
      Error Code:40000
      java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x0. Plaintext connection attempt to an SSL enabled server?
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Source)
      at dk.netarkivet.common.utils.DBUtils.selectLongValue(DBUtils.java:132)
      at dk.netarkivet.common.utils.DBUtils.selectLongValue(DBUtils.java:174)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheDatabase.getNumberOfFiles(ReplicaCacheDatabase.java:1126)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.getNumberOfFiles(DatabaseBasedActiveBitPreservation.java:579)
      at dk.netarkivet.archive.webinterface.BitpreserveFileState.printMissingFileStateForReplica(BitpreserveFileState.java:425)
      at org.apache.jsp.Bitpreservation_002dfilestatus_jsp._jspService(org.apache.jsp.Bitpreservation_002dfilestatus_jsp:121)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
      at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
      at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      at org.mortbay.jetty.Server.handle(Server.java:322)
      at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
      at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
      at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
      at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
      at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      Caused by: org.apache.derby.client.am.DisconnectException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x0. Plaintext connection attempt to an SSL enabled server?
      at org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
      at org.apache.derby.client.net.NetConnectionReply.parseSYNTAXRM(Unknown Source)
      at org.apache.derby.client.net.NetConnectionReply.parseCommonError(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source)
      at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source)
      at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source)
      at org.apache.derby.client.am.Statement.readOpenQuery(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)
      ... 29 more
      End of SQLException trace

      WARNING: Update of Activebitpreservation information failed
      java.lang.ArrayIndexOutOfBoundsException: -1
      at org.apache.derby.client.net.Request.mark(Unknown Source)
      at org.apache.derby.client.net.Request.markLengthBytes(Unknown Source)
      at org.apache.derby.client.net.NetStatementRequest.buildDSCSQLSTT(Unknown Source)
      at org.apache.derby.client.net.NetStatementRequest.writeDescribeInput(Unknown Source)
      at org.apache.derby.client.net.NetPreparedStatement.writeDescribeInput_(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.writeDescribeInput(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.writePrepareDescribeInputOutput(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
      at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
      at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheHelpers.insertFileIntoDB(ReplicaCacheHelpers.java:149)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheDatabase.addFileListInformation(ReplicaCacheDatabase.java:897)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.findMissingFiles(DatabaseBasedActiveBitPreservation.java:497)
      at dk.netarkivet.archive.webinterface.BitpreservationUpdateThread.run(BitpreservationUpdateThread.java:77)
      Nov 8, 2011 1:25:22 PM org.apache.jsp.error_jsp _jspService
      WARNING: JSP page threw exception: java.lang.ArrayIndexOutOfBoundsException
      java.lang.ArrayIndexOutOfBoundsException

      WARNING: Update of Activebitpreservation information failed
      dk.netarkivet.common.exceptions.IOFailure: Problems updating the replicafileinfo.
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheHelpers.updateReplicaFileInfoMissingFromFilelist(ReplicaCacheHelpers.java:542)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheDatabase.addFileListInformation(ReplicaCacheDatabase.java:926)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.findMissingFiles(DatabaseBasedActiveBitPreservation.java:497)
      at dk.netarkivet.archive.webinterface.BitpreservationUpdateThread.run(BitpreservationUpdateThread.java:77)
      Caused by: java.lang.ArrayIndexOutOfBoundsException

      Attachments

        Issue Links

          Activity

            People

              svc Søren Vejrup Carlsen (Inactive)
              nicl@kb.dk Nicholas Clarke (Inactive)
              Nicholas Clarke Nicholas Clarke (Inactive)
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7h
                  7h