FAQ  •  Register  •  Login

Fail to add video (mkv)

<<

LucianMLI

Serviio newbie

Posts: 1

Joined: Sun Mar 03, 2013 12:48 am

Post Sun Mar 03, 2013 12:59 am

Fail to add video (mkv)

Serviio 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:
  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.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Sun Mar 03, 2013 11:43 am

Re: Fail to add video (mkv)

Can you post ffmpeg -i for the file?

EDIT: never mind, I fixed it for 1.2.1
<<

Hinge

Serviio newbie

Posts: 2

Joined: Wed Mar 06, 2013 4:07 pm

Post Wed Mar 06, 2013 4:12 pm

Re: Fail to add video (mkv)

Is there a way to recode the .mkv to overcome this or is 1.2.1 available soonish?

I have about 20 files that all have this exact error when i imported them in last night.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Mar 06, 2013 5:03 pm

Re: Fail to add video (mkv)

Want to release within a week or so
<<

Hinge

Serviio newbie

Posts: 2

Joined: Wed Mar 06, 2013 4:07 pm

Post Wed Mar 06, 2013 8:24 pm

Re: Fail to add video (mkv)

Ok cool, thanks for the response.
<<

Darkfalz

Serviio lover

Posts: 60

Joined: Fri Feb 22, 2013 10:50 am

Post Thu Mar 07, 2013 1:19 am

Re: Fail to add video (mkv)

Got this too for multiple files.

I'm also bewildered why it fails to find a couple of movies which are exactly named as per themoviedb.org (with no special characters or anything). Like "Cocktail (1988)" for example. Or "Se7en (1995)".
Sony KDL-55HX750 and BDV-N990W (Home Theatre)
Sony KDL-40D3100 and BDP-S390 (Loungeroom)

Return to Serviio Support & Help

Who is online

Users browsing this forum: No registered users and 63 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.