SQL Truncation errors

Issue #110 resolved
Former user created an issue

I see a lot of these in my log when parsing music. It seems that column is not big enough to take some of the ID3 tags. {{{ 12:00:24,972 WARN [LibraryUpdaterThread] Cannot read metadata for file 08 - Symphonic Studies Op. 13 - Schumann.mp3. Message: Cannot create MusicAlbum with title Masters of the Roll, Vol. 16: Piano Music of Schubert/Liszt, Chopin, Rubenstein, Mendelssohn, Czerny, J. Strauss, Jr. and Schumann org.serviio.db.dao.PersistenceException: Cannot create MusicAlbum with title Masters of the Roll, Vol. 16: Piano Music of Schubert/Liszt, Chopin, Rubenstein, Mendelssohn, Czerny, J. Strauss, Jr. and Schumann at org.serviio.library.dao.MusicAlbumDAOImpl.create(MusicAlbumDAOImpl.java:62) at org.serviio.library.dao.MusicAlbumDAOImpl.create(MusicAlbumDAOImpl.java:33) at org.serviio.library.service.AudioService.findOrCreateAlbum(AudioService.java:432) at org.serviio.library.service.AudioService.addMusicTrackToLibrary(AudioService.java:62) at org.serviio.library.metadata.LibraryUpdaterThread.searchForNewFiles(LibraryUpdaterThread.java:243) at org.serviio.library.metadata.LibraryUpdaterThread.searchForNewFiles(LibraryUpdaterThread.java:222) at org.serviio.library.metadata.LibraryUpdaterThread.searchForNewFiles(LibraryUpdaterThread.java:222) at org.serviio.library.metadata.LibraryUpdaterThread.run(LibraryUpdaterThread.java:130) Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'Masters of the Roll, Vol. 16: Piano Music of Schubert/Liszt,&' 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.MusicAlbumDAOImpl.create(MusicAlbumDAOImpl.java:59) ... 7 more Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR 'Masters of the Roll, Vol. 16: Piano Music of Schubert/Liszt,&' 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 'Masters of the Roll, Vol. 16: Piano Music of Schubert/Liszt,&' 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 (2)

  1. Log in to comment