Stops working after a day

Need help? Post your questions here.
SaltyMedic
Posts: 6
Joined: 21 Dec 2016, 05:34
Has thanked: 3 times
Been thanked: 1 time

Stops working after a day

Unread post by SaltyMedic » 22 Jan 2018, 15:46

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
=========================================================================================
Madsonic was working fine for a while. Here over the last few weeks I've been running into trouble. When I try to browse for music, it won't respond sometimes. When it does respond, it won't allow me to search. I can sometimes browse. Usually stopping and restarting the service is what allows me to browse again, but the search ability won't work. Also when you go to home within Madsonic it used to show me a listing of random music. Now it doesn't show any albums when I go to home. Also most of my play lists have stopped listing anything.

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
More from the server log with a number of errors:

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

Post Reply