Database not large enough for boxset releases

Description

I assume the issue is boxset not clear from log

11/06/2017 21.05.08:com.jthink.jaikoz.db.SongCache:addSongToDatabase:WARNING: Failed AddSongToDatabase:A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 65536.
java.sql.SQLDataException: A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 65536.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.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.db.SongCache.addSongToDatabase(SongCache.java:180)
at com.jthink.jaikoz.db.SongCache$SubmitToDatabaseTask.run(SongCache.java:248)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 65536.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 17 more
Caused by: ERROR 22001: A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 65536.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLBinary.checkHostVariable(Unknown Source)
at org.apache.derby.exe.aca094c023x015cx989ax7301x000008f420b80.e0(Unknown Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(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)
... 11 more
11/06/2017 21.05.08:com.jthink.jaikoz.db.SongCache:addSongToDatabase:WARNING: Failed AddSongToDatabase:A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to length 65536.

Activity

Show:
IJabz
July 26, 2017, 1:17 PM

The issue was when saving Song to songcache, this uses blobs for the v1,v2,metadata wrapper.
Doubled from 64kb to 128kb

IJabz
July 26, 2017, 1:18 PM

Fixed.

Fixed

Reporter

Paul Taylor

Labels

None

Forum Username

jimthomson

os

None

Fix versions

Priority

Major
Configure