Serviio not adding files to the Library sql exception

Hi I'm running Serviio 0.6.0.1 on FreeBSD 8.2 it was working great until I charged all my music/movies library and the new items didn´t showed in the library
I found the following in the serviio log

WARN [LibraryAdditionsCheckerThread] Cannot add file 03 - Beyond Rangoon - Beyond Rangoon.mp3 because of an unexpected error. Message: Cannot create MusicTrack with title Beyond Rangoon

Caused by: java.sql.SQLDataException: The resulting value is outside the range for the data type SMALLINT.


Does anyone have the same issue??

Thanks for the help here is the complete stack trace.


Let me know if you need something else?


Also is there a way to use mysql instead of Derby?



2012-01-30 19:32:29,664 INFO [MediaServer] ------------------------------------------------------------------------
2012-01-30 19:32:29,697 INFO [MediaServer] Serviio DLNA media streaming server v 0.6.0.1 (rev. 8e4ee98bff12)
2012-01-30 19:32:29,698 INFO [MediaServer] Petr Nejedly 2009-2011
2012-01-30 19:32:29,698 INFO [MediaServer] http://www.serviio.org
2012-01-30 19:32:29,712 INFO [MediaServer]
2012-01-30 19:32:29,712 INFO [MediaServer] Java 1.6.0_07-The FreeBSD Foundation
2012-01-30 19:32:29,713 INFO [MediaServer] OS FreeBSD i386 8.2-RELEASE
2012-01-30 19:32:29,713 INFO [MediaServer] File encoding: ISO-8859-1
2012-01-30 19:32:29,714 INFO [MediaServer] Headless mode enabled: true
2012-01-30 19:32:29,714 INFO [MediaServer] User home dir: /nonexistent
2012-01-30 19:32:29,714 INFO [MediaServer] Temp dir: /var/tmp/
2012-01-30 19:32:29,714 INFO [MediaServer] ------------------------------------------------------------------------
2012-01-30 19:32:30,125 INFO [RestletServer] Starting Restlet server exposed on 192.168.0.200:23423


2012-01-30 19:21:50,888 WARN [LibraryAdditionsCheckerThread] Cannot add file 03 - Beyond Rangoon - Beyond Rangoon.mp3 because of an unexpected error. Message: Cannot create MusicTrack with title Beyond Rangoon
org.serviio.db.dao.PersistenceException: Cannot create MusicTrack with title Beyond Rangoon
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:85)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:37)
at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:86)
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: The resulting value is outside the range for the data type SMALLINT.
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.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at org.serviio.util.JdbcUtils.setIntValueOnStatement(JdbcUtils.java:177)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:66)
... 6 more
Caused by: java.sql.SQLException: The resulting value is outside the range for the data type SMALLINT.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 13 more
Caused by: ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLSmallint.setValue(Unknown Source)
... 9 more

[Cerberus]

update your install of java it is extremely old. your on java 1.6.0_07 and current verstion is 1.6.0_30.

Thanks for reply but do you really think that's the problem?
Could that be a problem with the library table schema?

I will upgrade the jvm tomorrow and I will post the results.

Thanks for your help!!!

Appreciate it.

[Cerberus]

yer that will more than likely solve your issue.

[zip]

that seems like a bug in the schema, i'll have a look. might be something with the track's metadata (eg track number too high)

Hello:
I just upgraded to FreeBSD 9.0 Latest Serviio package and I still have the same issue, is there any thing that I can help with to solve this??

Thanks appreciate your help-

Jesus

Forgot to say
Running serviio-0.6.2
Java:

java -version
openjdk version "1.6.0_30"
OpenJDK Runtime Environment (build 1.6.0_30-b24)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

Thanks!

[zip]

you don't have the latest Serviio. It's probably caused by invalid file metadata, try to remove the offending file.