by Jailon » Mon Aug 04, 2014 2:36 pm
all was ok on SS4.9 but upgraded to beta 5.0 beta1 and the full scan is crashing out. Seems to crash out around 22k on each scan (full DB is about 50k). If this relates to a corrupt file then I can delete it, but which one? have rebooted, stopped and started SS, removed media folders and reapplied them, cleaned up database etc.#
Any idea's? Thanks
License Subsonic Premium
Version 5.0.beta1 (build 4046) – 24 May 2014
Server jetty-6.1.x, java 1.7.0_10, Windows 8 (83.2 MB / 144.6 MB)
Java Limit 1000mb
Hardware w8.1 64bit. AMD II X250 3Ghz. 6GB Ram
Logs show:
[2014-08-04 07:46:31,229] INFO DaoHelper - Checking database schema.
[2014-08-04 07:50:16,083] INFO DaoHelper - Done checking database schema.
[2014-08-04 07:50:17,717] INFO VersionService - Resolved local Subsonic version to: 5.0.beta1
[2014-08-04 07:50:18,834] INFO PlayerDao - Deleted 3 player(s) that haven't been used after Thu Jun 05 07:50:18 BST 2014
[2014-08-04 07:50:20,224] INFO MediaScannerService - Automatic media library scanning scheduled to run every 1 day(s), starting at Tue Aug 05 03:00:00 BST 2014
[2014-08-04 07:50:20,635] INFO UPnPService - Starting UPnP service...
[2014-08-04 07:50:21,013] INFO PodcastService - Automatic Podcast update scheduled to run every 24 hour(s), starting at Mon Aug 04 07:55:21 BST 2014
[2014-08-04 07:50:22,238] INFO UPnPService - Enabling UPnP/DLNA media server
[2014-08-04 07:50:22,238] INFO UPnPService - Starting UPnP service - Done!
[2014-08-04 07:50:30,894] INFO NetworkService - Successfully forwarding port 4500.
[2014-08-04 07:51:58,412] INFO VersionService - Resolved latest Subsonic final version to: 4.9
[2014-08-04 07:51:58,412] INFO VersionService - Resolved latest Subsonic beta version to: 5.0.beta1
[2014-08-04 07:52:24,434] INFO MediaScannerService - Starting to scan media library.
[2014-08-04 07:52:32,765] INFO MediaScannerService - Scanned media library with 250 entries.
"""Edited here to save space on post""""
[2014-08-04 07:56:46,962] INFO MediaScannerService - Scanned media library with 22500 entries.
[2014-08-04 07:56:48,993] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; S1000 General error java.lang.NullPointerException in statement [update media_file set present=?, last_scanned=? where path=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [update media_file set present=?, last_scanned=? where path=?]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
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.markPresent(MediaFileDao.java:327)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:241)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:229)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:232)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:232)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:178)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:48)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:147)
Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [update media_file set present=?, last_scanned=? 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)
... 12 more
[2014-08-04 07:56:50,179] INFO PlaylistService - Starting playlist import.
[2014-08-04 07:56:50,179] INFO PlaylistService - Completed playlist import.
[2014-08-04 07:56:50,179] INFO PlaylistService - Starting playlist statistics update.
[2014-08-04 07:56:50,180] INFO PlaylistService - Completed playlist statistics update.