SQL Truncation Errors

I'm on Serviio 0.6 and the log is repeatedly filled with these errors. I understand the problem, but these are files from sound effects CD's that have these very long and descriptive names...

I attach an example file. {{{ 2011-10-22 10:35:32,744 WARN [LibraryAdditionsCheckerThread] Cannot add file d7 - Track96.m4a because of an unexpected error. Message: Cannot create Folder with name 7 - Motorcycle Gangs, Vintage Motorcycles,Office Ambiences, Parachutes, Police Radios , Ratchets, Record Scratches, Rockets, Sand Storms, Ship Signals, Ship SONAR, Space Shuttles org.serviio.db.dao.PersistenceException: Cannot create Folder with name 7 - Motorcycle Gangs, Vintage Motorcycles,Office Ambiences, Parachutes, Police Radios , Ratchets, Record Scratches, Rockets, Sand Storms, Ship Signals, Ship SONAR, Space Shuttles at org.serviio.library.dao.FolderDAOImpl.create(FolderDAOImpl.java:528) at org.serviio.library.dao.FolderDAOImpl.getOrCreateFolder(FolderDAOImpl.java:195) at org.serviio.library.local.service.FolderService.createOrReadFolder(FolderService.java:47) at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:64) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:154) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:128) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:128) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:78) Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '7 - Motorcycle Gangs, Vintage Motorcycles,Office Ambiences, &' to length 128. 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 org.serviio.library.dao.FolderDAOImpl.create(FolderDAOImpl.java:525) ... 7 more Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '7 - Motorcycle Gangs, Vintage Motorcycles,Office Ambiences, &' to length 128. 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 VARCHAR '7 - Motorcycle Gangs, Vintage Motorcycles,Office Ambiences, &' to length 128. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source) at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(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

}}}

Comments (4)