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