Stops working after a day

Need help? Post your questions here.

Stops working after a day

Unread postby 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
SaltyMedic
 
Posts: 6
Joined: 21 Dec 2016, 05:34
Has thanked: 3 times
Been thanked: 1 time

Return to Support 6.x

Who is online

Users browsing this forum: No registered users and 2 guests