Uploaded image for project: 'Jaikoz'
  1. JAIKOZ-1119

Missing track report cant report back for very large albums

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 8.4.2
    • Fix Version/s: 9.0.0
    • Labels:
      None
    • Forum Username:
      Kinter

      Description

      Missing track report cant report back for very large albums that wont fit in the database. Large albums are not a problem when matching they just store in memory, but in the missing songs report they cause a failure.

      18/02/2016 20.37.47:com.jthink.jthinksearch.client.JthinkSearchServer:doQuery:SEVERE: http://search.jthinkws.com?type=release&query=reid:(de36c451-000c-4488-9375-b6d40b6636e5 ) AND src:1&limit=1&offset=0
      18/02/2016 20.37.47:com.jthink.jthinksearch.client.JthinkSearchServer:doQuery:SEVERE: URLEncoded:http://search.jthinkws.com?type=release&query=reid%3A%28de36c451-000c-4488-9375-b6d40b6636e5+%29+AND+src%3A1&limit=1&offset=0
      18/02/2016 20.37.59:com.jthink.jaikoz.manipulate.matchinghelper.ReleaseCache:addReleaseToDatabase:WARNING: SQL Failed AddReleaseToDatabase:de36c451-000c-4488-9375-b6d40b6636e5:An unexpected exception was thrown
      java.sql.SQLException: An unexpected exception was thrown
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.seeNextException(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.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at com.jthink.jaikoz.manipulate.matchinghelper.ReleaseCache.addReleaseToDatabase(ReleaseCache.java:283)
      at com.jthink.jaikoz.manipulate.matchinghelper.ReleaseCache.add(ReleaseCache.java:74)
      at com.jthink.jaikoz.manipulate.FindMissingAlbumTracks.updateData(FindMissingAlbumTracks.java:110)
      at com.jthink.jaikoz.manipulate.FindMissingAlbumTracks.run(FindMissingAlbumTracks.java:51)
      at java.lang.Thread.run(Thread.java:744)
      Caused by: java.sql.SQLException: An unexpected exception was thrown
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 16 more
      Caused by: java.sql.SQLException: Java exception: 'A truncation error was encountered trying to shrink CLOB '<stream-value>' to length 524288.: org.apache.derby.iapi.services.io.DerbyIOException'.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      ... 13 more
      Caused by: org.apache.derby.iapi.services.io.DerbyIOException: A truncation error was encountered trying to shrink CLOB '<stream-value>' to length 524288.
      at org.apache.derby.iapi.types.ReaderToUTF8Stream.truncate(Unknown Source)
      at org.apache.derby.iapi.types.ReaderToUTF8Stream.checkSufficientData(Unknown Source)
      at org.apache.derby.iapi.types.ReaderToUTF8Stream.fillBuffer(Unknown Source)
      at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown Source)
      at org.apache.derby.impl.store.raw.data.MemByteHolder.write(Unknown Source)
      at org.apache.derby.impl.store.raw.data.RememberBytesInputStream.fillBuf(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StoredPage.logColumn(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StoredPage.logLongColumn(Unknown Source)
      at org.apache.derby.impl.store.raw.data.InsertOperation.writeOptionalDataToBuffer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.InsertOperation.<init>(Unknown Source)
      at org.apache.derby.impl.store.raw.data.LoggableActions.actionInsert(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BasePage.insertLongColumn(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BasePage.insertAllowOverflow(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BasePage.insert(Unknown Source)
      at org.apache.derby.impl.store.access.heap.HeapController.doInsert(Unknown Source)
      at org.apache.derby.impl.store.access.heap.HeapController.insertAndFetchLocation(Unknown Source)
      at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
      at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      ... 9 more
      18/02/2016 20.37.59:com.jthink.jaikoz.manipulate.FindMissingAlbumTracks:updateData:SEVERE: Unable to find release on JthinkMusicServer:de36c451-000c-4488-9375-b6d40b6636e5

        Attachments

          Activity

            People

            • Reporter:
              paul Paul Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: