Scan for New Music crashes part way through

Need help? Post your questions here.

Moderator: moderators

Scan for New Music crashes part way through

Postby johnforster21 » Tue Nov 20, 2018 3:08 pm

<-------------------------Subsonic Help Request---------------------->
Problem Description: New Music not appearing - turns out scanning process is crashing part way through

I am prepared to believe that the cause of the problem is a damaged or faulty music file, but I cannot find out how to identify
the problem file. All recently added music files were labelled using Media Monkey without any problems.

Troubleshooting Steps: Manually re-running scan (no change). Viewed subsonic log file - scan crashing - see below
Playback Application and version: Sonos Version 9.2
Subsonic Version: 6.1.4 (build c43f63) – November 11, 2018
Server Version: jetty-6.1.x, java 1.8.0_152, HSQLDB, Windows 10 (71.7 MB / 145.0 MB)
Hardware Platform: Windows 10 Pro
Java Memory Limit: Not sure ... see above
Problem Filename: Don't know
Output from ffmpeg -i: Don't know how to do this - possibly not relevant
Last ten log file lines: I have included rather more than this, I think the extra is relevant
[2018-11-20 11:01:35,576] INFO MediaScannerService - Scanned media library with 98500 entries.
[2018-11-20 11:01:42,801] INFO MediaScannerService - Scanned media library with 98750 entries.
[2018-11-20 11:01:49,991] 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.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:68)
at net.sourceforge.subsonic.dao.MediaFileDao.markPresent(MediaFileDao.java:530)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:234)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:220)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:161)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:31)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:130)
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)
... 13 more

[2018-11-20 11:01:50,260] INFO PlaylistService - Starting playlist import.
[2018-11-20 11:01:50,260] INFO PlaylistService - Completed playlist import.
<-------------------------Subsonic Help Request---------------------->
johnforster21
 
Posts: 1
Joined: Fri May 25, 2018 7:06 am

Return to Help

Who is online

Users browsing this forum: No registered users and 5 guests