Truncation errors persist

Running on Ubuntu Linux, version 0.4.2. The truncation problems previously reported still exist. At first I thought it might be due to special characters ('&' or extra '.') but they didn't fix things. Here is the applicable output from the logs:

2010-12-11 20:11:26,102 WARN [LibraryAdditionsCheckerThread] Cannot read metadata for file 48th Highlanders Of Canada-Scottish National Pipe And Drum Corps - Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Merry Blacksmith Methven Castle Merry Lads Of Dornoch Come By The Hills Lord Dunmore's Jig Willies B.mp3. Message: Cannot create MusicTrack with title Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Merry Blacksmith Methven Castle Merry Lads of Dornoch Come by the Hills Lord Dunmore's Jig Willies B org.serviio.db.dao.PersistenceException: Cannot create MusicTrack with title Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Merry Blacksmith Methven Castle Merry Lads of Dornoch Come by the Hills Lord Dunmore's Jig Willies B at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:85) at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:37) at org.serviio.library.service.AudioService.addMusicTrackToLibrary(AudioService.java:86) at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:157) at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:130) at org.serviio.library.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:130) at org.serviio.library.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:76) Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Mer&' 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.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:82) ... 6 more Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR 'Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Mer&' to length 128. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 16 more Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 'Captin Lumsden Captian Horne Aspen Bank Highland Whiskey Mer&' 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) ... 10 more

Comments (1)