Uploaded image for project: 'Bitrepository'
  1. Bitrepository
  2. BITMAG-1128

Reference pillar cannot recalculate checksums

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 1.9, 1.8.0.1
    • 1.8
    • Reference pillar
    • None

    Description

      [code]
      java.lang.IllegalStateException: Cannot extract the checksum entries with the arguments, maxTimestamp = '1483624572036'
      at org.bitrepository.pillar.store.checksumdatabase.ChecksumExtractor.extractFileIDsWithMaxChecksumDate(ChecksumExtractor.java:346)
      at org.bitrepository.pillar.store.checksumdatabase.ChecksumDAO.getFileIDsWithOldChecksums(ChecksumDAO.java:163)
      at org.bitrepository.pillar.store.FileStorageModel.verifyFileToCacheConsistencyOfAllData(FileStorageModel.java:270)
      at org.bitrepository.pillar.schedulablejobs.RecalculateChecksumJob.start(RecalculateChecksumJob.java:63)
      at org.bitrepository.service.workflow.JobTimerTask.runJob(JobTimerTask.java:91)
      at org.bitrepository.service.workflow.JobTimerTask.run(JobTimerTask.java:127)
      at java.util.TimerThread.mainLoop(Timer.java:555)
      at java.util.TimerThread.run(Timer.java:505)
      Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "WHERE" at line 1, column 15.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
      at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:567)
      at org.bitrepository.service.database.DatabaseUtils.createPreparedStatement(DatabaseUtils.java:396)
      at org.bitrepository.pillar.store.checksumdatabase.ChecksumExtractor.extractFileIDsWithMaxChecksumDate(ChecksumExtractor.java:330)
      ... 7 common frames omitted
      Caused by: org.apache.derby.iapi.error.StandardException: Syntax error: Encountered "WHERE" at line 1, column 15.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.compile.ParserImpl.parseStatementOrSearchCondition(Unknown Source)
      at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      ... 15 common frames omitted
      [code]

      Attachments

        Activity

          People

            Unassigned Unassigned
            ktc Kim Christensen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: