I'm using two different installation of subsonic. The first one on a Fedora server, with the 4.8 version. It is alive since 4.5, at least, on port 4040. Recently, I've installed a second one on a Debian Wheezy Server, first the 4.9.beta1 version, on port 82. The two server are by my home. In the both case, the music directory is on a NAS, mounted in NFS. It the same directory for the two installations. And the library count 44'000 entries.
Because searching for item I know I have in my Library failed to find something, I tried to find out why. And I understood that the Subsonic 4.9.beta1 on Debian failed to scan media library. I've tried to install the 4.8 instead : no change. Then I've installed the 4.9.beta2 : no better.
In the subsonic.log I get this :
- Code: Select all
[2013-12-13 22:13:27,443] INFO MediaScannerService - Starting to scan media library.
[2013-12-13 22:13:28,438] INFO MediaScannerService - Scanned media library with 250 entries.
[2013-12-13 22:13:28,764] INFO MediaScannerService - Scanned media library with 500 entries.
[2013-12-13 22:13:29,044] INFO MediaScannerService - Scanned media library with 750 entries.
[2013-12-13 22:13:29,277] INFO MediaScannerService - Scanned media library with 1000 entries.
[2013-12-13 22:13:29,505] INFO MediaScannerService - Scanned media library with 1250 entries.
[2013-12-13 22:13:29,714] INFO MediaScannerService - Scanned media library with 1500 entries.
[2013-12-13 22:13:29,931] INFO MediaScannerService - Scanned media library with 1750 entries.
[2013-12-13 22:13:30,165] INFO MediaScannerService - Scanned media library with 2000 entries.
[2013-12-13 22:13:30,385] INFO MediaScannerService - Scanned media library with 2250 entries.
[2013-12-13 22:13:30,576] INFO MediaScannerService - Scanned media library with 2500 entries.
[2013-12-13 22:13:30,817] INFO MediaScannerService - Scanned media library with 2750 entries.
[2013-12-13 22:13:31,036] INFO MediaScannerService - Scanned media library with 3000 entries.
[2013-12-13 22:13:31,252] INFO MediaScannerService - Scanned media library with 3250 entries.
[2013-12-13 22:13:31,477] INFO MediaScannerService - Scanned media library with 3500 entries.
[2013-12-13 22:13:31,687] INFO MediaScannerService - Scanned media library with 3750 entries.
[2013-12-13 22:13:31,878] INFO MediaScannerService - Scanned media library with 4000 entries.
[2013-12-13 22:13:32,088] INFO MediaScannerService - Scanned media library with 4250 entries.
[2013-12-13 22:13:32,212] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update media_file set folder=?,type=?,format=?,title=?,album=?,artist=?,album_artist=?,disc_number=?,track_number=?,year=?,genre=?,bit_rate=?,variable_bit_rate=?,duration_seconds=?,file_size=?,width=?,height=?,cover_art_path=?,parent_path=?,play_count=?,last_played=?,comment=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; Violation of unique index IDX_MEDIA_FILE_GENRE: duplicate value(s) for column(s) GENRE in statement [update media_file set folder=?,type=?,format=?,title=?,album=?,artist=?,album_artist=?,disc_number=?,track_number=?,year=?,genre=?,bit_rate=?,variable_bit_rate=?,duration_seconds=?,file_size=?,width=?,height=?,cover_art_path=?,parent_path=?,play_count=?,last_played=?,comment=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; nested exception is java.sql.SQLException: Violation of unique index IDX_MEDIA_FILE_GENRE: duplicate value(s) for column(s) GENRE in statement [update media_file set folder=?,type=?,format=?,title=?,album=?,artist=?,album_artist=?,disc_number=?,track_number=?,year=?,genre=?,bit_rate=?,variable_bit_rate=?,duration_seconds=?,file_size=?,width=?,height=?,cover_art_path=?,parent_path=?,play_count=?,last_played=?,comment=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at net.sourceforge.subsonic.dao.AbstractDao.update(AbstractDao.java:71)
at net.sourceforge.subsonic.dao.MediaFileDao.createOrUpdateMediaFile(MediaFileDao.java:134)
at net.sourceforge.subsonic.service.MediaFileService.checkLastModified(MediaFileService.java:127)
at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:196)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:216)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:220)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:220)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:171)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:46)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:145)
Caused by: java.sql.SQLException: Violation of unique index IDX_MEDIA_FILE_GENRE: duplicate value(s) for column(s) GENRE in statement [update media_file set folder=?,type=?,format=?,title=?,album=?,artist=?,album_artist=?,disc_number=?,track_number=?,year=?,genre=?,bit_rate=?,variable_bit_rate=?,duration_seconds=?,file_size=?,width=?,height=?,cover_art_path=?,parent_path=?,play_count=?,last_played=?,comment=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 13 more
I've just check, with the 4.8 on Fedora, I don't have this problem.
On debian I have this : "openjdk-6-jre/wheezy uptodate 6b27-1.12.6-1~deb7u1"
If anyone has a proposition...
