Page 1 of 1

ERROR 22003

PostPosted: Fri Feb 28, 2014 8:48 pm
by stephendhill
2014-02-28 20:12:16,256 WARN [LibraryAdditionsCheckerThread] Cannot add file 08 Estelle - In the Rain.flac because of an unexpected error. Message: Cannot create MusicTrack with title In the Rain
... 10 more
at org.apache.derby.iapi.types.SQLSmallint.setValue(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
Caused by: ERROR 22003: The resulting value is outside the range for the data type SMALLINT.

Re: ERROR 22003

PostPosted: Sat Mar 01, 2014 8:31 am
by stephendhill
Derby log:
----------------------------------------------------------------
Fri Feb 28 20:11:28 GMT 2014:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.10.1.1 - (1458268): instance a816c00e-0144-7a1f-7dbb-00004ddc491f
on database directory /shared_data/serviio/serviio-1.4/library/db with class loader sun.misc.Launcher$AppClassLoader@1a16869
Loaded from file:/shared_data/serviio/serviio-1.4/lib/derby.jar
java.vendor=Sun Microsystems Inc.
java.runtime.version=1.6.0_24-b07
user.dir=/
os.name=Linux
os.arch=i386
os.version=3.2.0-59-generic-pae
derby.system.home=/shared_data/serviio/serviio-1.4/library
derby.stream.error.file=../log/derby.log
Database Class Loader started - derby.database.classpath=''

Re: ERROR 22003

PostPosted: Sat Mar 01, 2014 8:37 am
by stephendhill
Think I missed important part of log, so here's the rest:
at org.apache.derby.iapi.types.SQLSmallint.setValue(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
Caused by: ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
... 14 more
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
Caused by: java.sql.SQLException: The resulting value is outside the range for the data type SMALLINT.
... 7 more
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:86)
at org.serviio.util.JdbcUtils.setIntValueOnStatement(JdbcUtils.java:186)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
Caused by: java.sql.SQLDataException: The resulting value is outside the range for the data type SMALLINT.
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:83)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:134)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:134)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:145)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.addNewMediaFile(LibraryAdditionsCheckerThread.java:185)
at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:93)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:38)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:91)
org.serviio.db.dao.PersistenceException: Cannot create MusicTrack with title Shine
2014-02-28 20:21:45,807 WARN [LibraryAdditionsCheckerThread] Cannot add file 12 Estelle - Shine.flac because of an unexpected error. Message: Cannot create MusicTrack with title Shine

Re: ERROR 22003

PostPosted: Sat Mar 01, 2014 8:54 am
by stephendhill
Dump of metadata (ffmpeg -f ffmetadata):
;FFMETADATA1
TITLE=Shine
ARTIST=Estelle
ALBUM ARTIST=Estelle
album_artist=Estelle
ALBUM=Shine
DISC=412860
track=12
YEAR=2008
ORGANIZATION=Wea Japan
GENRE=R&B
DATE=2008
ISRC=075678995422
ENCODER=MediaMonkey 4.1.0
ENSEMBLE=Estelle

Re: ERROR 22003

PostPosted: Sat Mar 01, 2014 9:07 am
by stephendhill
Also of interest is the fact that Logitech Media Server, which is running on the same machine as Serviio, has no problem with these tracks (there's more than one track of this album being bounced by Serviio for some reason).

Re: ERROR 22003

PostPosted: Sat Mar 01, 2014 11:25 pm
by stephendhill
This turned out to be the 'part #' (otherwise known as 'Disc #').
Looks like there's a bug in Serviio when a part number is included in the metadata.
I have raised Issue #767 in BitBucket.