Fail to add video (mkv)
Posted: Sun Mar 03, 2013 12:59 amServiio fails to add a video containing multiple subtitles. I tried truncating the title but no effect. Plays fine in VLC with subs and all.
<video> is not the actual file name
The number of subs is 28.
A sub contains hebrew characters, I don't know the encoding, could this be an issue? The subs are embedded in the video file. Default encoding Windows 1252
Here is the log error:
From the exception the obvious problem is multiple sub handling. Maybe truncation, if necessary, should occur before the query, maybe it is, I dunno the code.
<video> is not the actual file name
The number of subs is 28.
A sub contains hebrew characters, I don't know the encoding, could this be an issue? The subs are embedded in the video file. Default encoding Windows 1252
Here is the log error:
- Code:
2013-03-03 02:43:01,933 WARN [LibraryAdditionsCheckerThread] Cannot add file <video>.mkv because of an unexpected error. Message: Cannot create Video with title <video>
org.serviio.db.dao.PersistenceException: Cannot create Video with title <video>
at org.serviio.library.dao.VideoDAOImpl.create(VideoDAOImpl.java:121)
at org.serviio.library.dao.VideoDAOImpl.create(VideoDAOImpl.java:50)
at org.serviio.library.local.service.VideoService.addVideoToLibrary(VideoService.java:107)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.addNewMediaFile(LibraryAdditionsCheckerThread.java:188)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:145)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:134)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:83)
Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '2/SRT/eng/true,4/SRT/hrv/false,5/SRT/cze/false,6/SRT/dan/fal&' to length 256.
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.VideoDAOImpl.create(VideoDAOImpl.java:118)
... 6 more
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '2/SRT/eng/true,4/SRT/hrv/false,5/SRT/cze/false,6/SRT/dan/fal&' to length 256.
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 '2/SRT/eng/true,4/SRT/hrv/false,5/SRT/cze/false,6/SRT/dan/fal&' to length 256.
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
From the exception the obvious problem is multiple sub handling. Maybe truncation, if necessary, should occur before the query, maybe it is, I dunno the code.