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

Database not large enough for boxset releases

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.2.0
    • Labels:
      None
    • Forum Username:
      jimthomson

      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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: