4.8: Failed to scan media library

[ratedr79]

Since upgrading to 4.8, I can't complete a media scan. I've removed my location, cleaned up the database, even tried scanning a backup location I have, and at random it just dies. Any ideas are appreciated?

[2013-05-14 15:55:10,406] INFO MediaScannerService - Starting to scan media library.
[2013-05-14 15:55:23,125] INFO MediaScannerService - Scanned media library with 250 entries.
[2013-05-14 15:55:25,500] INFO MediaScannerService - Scanned media library with 500 entries.
[2013-05-14 15:55:27,265] INFO MediaScannerService - Scanned media library with 750 entries.
[2013-05-14 15:55:28,390] INFO MediaScannerService - Scanned media library with 1000 entries.
[2013-05-14 15:55:29,640] INFO MediaScannerService - Scanned media library with 1250 entries.
[2013-05-14 15:55:30,781] INFO MediaScannerService - Scanned media library with 1500 entries.
[2013-05-14 15:55:31,890] INFO MediaScannerService - Scanned media library with 1750 entries.
[2013-05-14 15:55:33,125] INFO MediaScannerService - Scanned media library with 2000 entries.
[2013-05-14 15:55:34,187] INFO MediaScannerService - Scanned media library with 2250 entries.
[2013-05-14 15:55:35,187] INFO MediaScannerService - Scanned media library with 2500 entries.
[2013-05-14 15:55:36,234] INFO MediaScannerService - Scanned media library with 2750 entries.
[2013-05-14 15:55:37,390] INFO MediaScannerService - Scanned media library with 3000 entries.
[2013-05-14 15:55:38,359] INFO MediaScannerService - Scanned media library with 3250 entries.
[2013-05-14 15:55:39,265] INFO MediaScannerService - Scanned media library with 3500 entries.
[2013-05-14 15:55:40,296] INFO MediaScannerService - Scanned media library with 3750 entries.
[2013-05-14 15:55:40,906] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.TransientDataAccessResourceException: 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=?]; S1000 General error java.lang.NullPointerException 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: S1000 General error java.lang.NullPointerException 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.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.createOrUpdateMediaFile(MediaFileDao.java:135)
at net.sourceforge.subsonic.service.MediaFileService.checkLastModified(MediaFileService.java:128)
at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:197)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:215)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:170)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:47)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:146)
Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException 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

[2013-05-14 15:55:42,593] INFO PlaylistService - Starting playlist import.
[2013-05-14 15:55:42,593] INFO PlaylistService - Completed playlist import.
[2013-05-14 15:55:42,593] INFO PlaylistService - Starting playlist statistics update.

[alphawave7]

IIRC, this is a corrupt db, and requires a db deletion and rebuild.

[ratedr79]

Well, a db rebuild wasn't exactly what I had planned, but it worked like a charm. Thanks for the help.