Missing track report cant report back for very large albums

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

Status

Reporter

Paul Taylor

Labels

None

Forum Username

Kinter

os

None

Fix versions

Affects versions

Priority

Major
Configure