FAQ  •  Register  •  Login

DB Exceptions (bugs)

<<

jlcooke

Streaming enthusiast

Posts: 22

Joined: Wed May 30, 2012 7:46 pm

Post Thu May 31, 2012 2:47 pm

DB Exceptions (bugs)

Is there a bugzilla I could submit bugs to? I'm more than happy to fix software I use - point me in the right direction.

I have a several errors in serviio.log for the directory
  Code:
Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in G - Missa Brevis - Salve Regina in E-flat [Roos - Bernius - Heilbronn]


  Code:
2012-05-31 10:38:34,526 WARN  [LibraryAdditionsCheckerThread] Cannot add file 04 Grosse Orgelmesse in E-flat Major Hob.XXII.4 IV. Sanctus.flac because of an unexpected error. Message: Cannot create Folder with name Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in G - Missa Brevis - Salve Regina in E-flat [Roos - Bernius - Heilbronn]
org.serviio.db.dao.PersistenceException: Cannot create Folder with name Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in G - Missa Brevis - Salve Regina in E-flat [Roos - Bernius - Heilbronn]
        at org.serviio.library.dao.FolderDAOImpl.create(FolderDAOImpl.java:531)
        at org.serviio.library.dao.FolderDAOImpl.getOrCreateFolder(FolderDAOImpl.java:198)
        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 'Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in&' 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:528)
        ... 7 more
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR 'Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in&' 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 'Haydn Edition [Disc 044] Grosse Orgelmesse - Salve Regina in&' 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
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17000

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu May 31, 2012 3:51 pm

Re: DB Exceptions (bugs)

<<

jlcooke

Streaming enthusiast

Posts: 22

Joined: Wed May 30, 2012 7:46 pm

Post Thu May 31, 2012 3:56 pm

Re: DB Exceptions (bugs)

Perfect thanks! Found an existing bug: https://bitbucket.org/xnejp03/serviio/i ... ion-errors

I assume the DB schema will be fixed in the next release? :)
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17000

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Thu May 31, 2012 9:32 pm

Re: DB Exceptions (bugs)

fixed for 1.0

Return to Serviio Support & Help

Who is online

Users browsing this forum: Majestic-12 [Bot] and 23 guests

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