Code: Select all
=========================================================================================
VERSION: MADSONIC 6.3.9840 | BUILD: ?
SERVLET: ?
SERVER: CPU: Intel(R) Xeon(R) CPU E3-1246 v3 @ 3.50GHz | ARCH: X64 | MEMORY: 16GB | HDD: 3TB
OS: Linux Ubuntu 16.04.3
SYSTEM: SERVER
INSTALLER: DEB
JAVA: 1.8.0_151
BROWSER: Chrome Version 63.0.3239.132
CLIENT: DSUB and browser for madsonic 6.3
DESCRIPTION: library won't scan, random albums don't show up when clicking on home, and playlists disapear
REPRODUCIBLE: YES
=========================================================================================
I have uninstalled and reinstalled madsonic. The only thing that I kept was madsonic.properties as I didn't want to have to redo my users.
Any help would be appreciated.
Thanks
Jason
Here is an excerpt from my server log after reinstalling it and telling it to scan my media folders:
Code: Select all
[1/19/18 3:58 PM] INFO MediaScannerService Scanned media library with 15500 entries.
[1/19/18 3:58 PM] ERROR MediaScannerService Failed to scan media library.
[1/19/18 3:58 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [update music_folder_tasks set found=?, scan=?, status=?, result=?, comment=?, enabled=? where music_folder_id=?]; integrity constraint violation: unique constraint or index violation; SYS_PK_10821 table: MUSIC_FOLDER_TASKS; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10821 table: MUSIC_FOLDER_TASKS
Code: Select all
[1/19/18 3:58 PM] INFO PlaylistService Starting playlist import.
[1/19/18 3:58 PM] INFO PlaylistService Completed playlist import.
[1/19/18 3:58 PM] INFO PlaylistService Starting playlist statistics update.
[1/19/18 3:58 PM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/19/18 4:00 PM] WARN CoverArtController Failed to process cover art /media/raid1/share/Music/Christian/MercyMe/MercyMe - 2002 - Spoken For/07 - Word Of God Speak.mp3: java.lang.NullPointerException
[1/19/18 4:00 PM] INFO StreamController jason is streaming "2014 Hymns/01-09- Softly and Tenderly.mp3" [RAW]
[1/19/18 4:01 PM] WARN CoverArtController Failed to process cover art /media/raid1/share/Music/Christian/MercyMe/MercyMe - 2002 - Spoken For/07 - Word Of God Speak.mp3: java.lang.NullPointerException
[1/19/18 4:01 PM] WARN CoverArtController Failed to process cover art /media/raid1/share/Music/Christian/MercyMe/MercyMe - 2002 - Spoken For/07 - Word Of God Speak.mp3: java.lang.NullPointerException
[1/19/18 4:02 PM] INFO PodcastService Starting scheduled Podcast refresh.
[1/19/18 4:02 PM] INFO PodcastService Completed scheduled Podcast refresh.
[1/19/18 4:04 PM] WARN PlaylistService Fallback user 'jason' set in Playlist.
[1/19/18 4:04 PM] WARN PlaylistService File in playlist 'bike jams.m3u' not found:
[1/19/18 4:57 PM] INFO StreamController wendy is streaming "Hand on Bible Cirriculum - Preschool age 3 and 4 winter 2010-2011/Preschool age 3 and 4 winter 2010-2011 - 11 - God Cares (1 Peter 57).mp3" [RAW]
[1/19/18 5:00 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Fri Jan 19 17:00:00 MST 2018
[1/19/18 5:00 PM] ERROR MediaScannerService Failed to scan folder.
[1/19/18 5:00 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?]; java.lang.ArrayIndexOutOfBoundsException: 3; nested exception is java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 3
[1/19/18 10:18 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Fri Jan 19 22:18:00 MST 2018
[1/19/18 10:18 PM] ERROR MediaScannerService Failed to scan folder.
[1/19/18 10:18 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?]; java.lang.ArrayIndexOutOfBoundsException; nested exception is java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException
[1/20/18 3:00 AM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/20/18 3:00 AM] ERROR MediaScannerService Failed to scan media library.
[1/20/18 3:00 AM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?]; java.lang.ArrayIndexOutOfBoundsException; nested exception is java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException
[1/20/18 3:00 AM] INFO PlaylistService Starting playlist import.
[1/20/18 3:00 AM] INFO PlaylistService Completed playlist import.
[1/20/18 3:00 AM] INFO PlaylistService Starting playlist statistics update.
[1/20/18 3:00 AM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/20/18 4:02 PM] INFO PodcastService Starting scheduled Podcast refresh.
[1/20/18 4:02 PM] INFO PodcastService Completed scheduled Podcast refresh.
[1/20/18 5:00 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Sat Jan 20 17:00:00 MST 2018
[1/20/18 5:00 PM] ERROR MediaScannerService Failed to scan folder.
[1/20/18 5:00 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/20/18 10:18 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Sat Jan 20 22:18:00 MST 2018
[1/20/18 10:18 PM] ERROR MediaScannerService Failed to scan folder.
[1/20/18 10:18 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:00 AM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/21/18 3:00 AM] ERROR MediaScannerService Failed to scan media library.
[1/21/18 3:00 AM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:00 AM] INFO PlaylistService Starting playlist import.
[1/21/18 3:00 AM] INFO PlaylistService Completed playlist import.
[1/21/18 3:00 AM] INFO PlaylistService Starting playlist statistics update.
[1/21/18 3:00 AM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Hymns' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Bike Jams' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'christmas party' playlist skiped, entry size: 0
[1/21/18 3:30 PM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/21/18 3:30 PM] ERROR MediaScannerService Failed to scan media library.
[1/21/18 3:30 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Completed playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist statistics update.
[1/21/18 3:30 PM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Hymns' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Bike Jams' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'christmas party' playlist skiped, entry size: 0
[1/21/18 3:30 PM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/21/18 3:30 PM] ERROR MediaScannerService Failed to scan media library.
[1/21/18 3:30 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Completed playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist statistics update.
[1/21/18 3:30 PM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Hymns' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'Bike Jams' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'christmas party' playlist skiped, entry size: 0
[1/21/18 3:30 PM] WARN PlaylistService Backup: 'ssparty' playlist skiped, entry size: 0
[1/21/18 3:30 PM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/21/18 3:30 PM] ERROR MediaScannerService Failed to scan media library.
[1/21/18 3:30 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Completed playlist import.
[1/21/18 3:30 PM] INFO PlaylistService Starting playlist statistics update.
[1/21/18 3:30 PM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/21/18 3:34 PM] WARN PlaylistService Backup: 'Hymns' playlist skiped, entry size: 0
[1/21/18 3:34 PM] WARN PlaylistService Backup: 'Bike Jams' playlist skiped, entry size: 0
[1/21/18 3:34 PM] WARN PlaylistService Backup: 'christmas party' playlist skiped, entry size: 0
[1/21/18 3:34 PM] WARN PlaylistService Backup: 'ssparty' playlist skiped, entry size: 0
[1/21/18 3:34 PM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/21/18 3:34 PM] ERROR MediaScannerService Failed to scan media library.
[1/21/18 3:34 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 3:34 PM] INFO PlaylistService Starting playlist import.
[1/21/18 3:34 PM] INFO PlaylistService Completed playlist import.
[1/21/18 3:34 PM] INFO PlaylistService Starting playlist statistics update.
[1/21/18 3:34 PM] WARN PlaylistService Failed to update playlist statistics: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into playlist_file (playlist_id, media_file_id) values (?, ?)]; integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10652 table: PLAYLIST_FILE
[1/21/18 3:37 PM] INFO PlaylistService Starting playlist recovery.
[1/21/18 3:37 PM] INFO PlaylistService Completed playlist recovery.
[1/21/18 3:37 PM] INFO CleanupSettingsController Recover playlists from backup folder.
[1/21/18 4:02 PM] INFO PodcastService Starting scheduled Podcast refresh.
[1/21/18 4:02 PM] INFO PodcastService Completed scheduled Podcast refresh.
[1/21/18 4:19 PM] INFO PlayerDao Created player 21.
[1/21/18 5:00 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Sun Jan 21 17:00:00 MST 2018
[1/21/18 5:00 PM] ERROR MediaScannerService Failed to scan folder.
[1/21/18 5:00 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/21/18 10:18 PM] INFO MediaScannerService WATCHDOG:SCAN: doFolderScanLibrary() started at Sun Jan 21 22:18:00 MST 2018
[1/21/18 10:18 PM] ERROR MediaScannerService Failed to scan folder.
[1/21/18 10:18 PM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/22/18 3:00 AM] INFO MediaScannerService WATCHDOG:SCAN: doFullScanLibrary() started
[1/22/18 3:00 AM] ERROR MediaScannerService Failed to scan media library.
[1/22/18 3:00 AM] ERROR MediaScannerService ERROR PreparedStatementCallback; SQL [insert into music_folder_tasks (id, music_folder_id, found, scan, status, result, comment, enabled) values (?, ?, ?, ?, ?, ?, ?, ?)]; IO error: RowInputBinary - negative length; nested exception is java.sql.SQLException: IO error: RowInputBinary - negative length
[1/22/18 3:00 AM] INFO PlaylistService Starting playlist import.
[1/22/18 3:00 AM] INFO PlaylistService Completed playlist import.
[1/22/18 3:00 AM] INFO PlaylistService Starting playlist statistics update.
[1/22/18 3:00 AM] INFO PlaylistService Completed playlist statistics update.
[1/22/18 7:29 AM] WARN CoverArtController Failed to process cover art /media/raid1/share/Music/Christian/MercyMe/MercyMe - 2002 - Spoken For/07 - Word Of God Speak.mp3: java.lang.NullPointerException