I have got issues with a part of the Music library. I have a hole from F to J artists. If I use another multimedia player such as Kodi TV, I have no issue, I can see all the "missing" directories.
How to fix that?
I noticed this issue a few weeks ago. it was fine before.
Cheers
Problem Description:
Not possible to fully see the complete music DB. Library is not fully visible (missing most of artists with name starting from E to J), more than 130+ directories are missing.
Troubleshooting Steps:
stop and restart of subsonic service, reboot of the server, upgrade to latest version, reboot, deletion of library and asking to create again...
Playback Application and version:
using web app from windows computers and Android app from several smartphones. same issue on all devices/
Subsonic Version:
License Subsonic Premium (expires 12 avril 2020)
Version 6.1.3 (build e408c9) – 31 octobre 2017
Server Version:
Serveur jetty-6.1.x, java 1.8.0_171, HSQLDB, Windows Server 2008 R2 (81,5 MB / 145,0 MB)
Hardware Platform:
Windows Home Server 2011 (equivalent to Windows Server 2008 R2)
Java Memory Limit:
(Windows: 145MB)
Problem Filename:
all artists from F* to J* missing. not visible.
Last ten log file lines:
- Code: Select all
[17/07/18 19:34:39 CEST] INFO HsqlDaoHelper Checking database schema.
[17/07/18 19:34:43 CEST] INFO HsqlDaoHelper Done checking database schema.
[17/07/18 19:34:43 CEST] INFO SettingsService Java: 1.8.0_171, OS: Windows Server 2008 R2
[17/07/18 19:34:43 CEST] INFO VersionService Resolved local Subsonic version to: 6.1.3
[17/07/18 19:34:44 CEST] INFO PlayerDao Deleted 1 player(s) that haven't been used after Fri May 18 19:34:44 CEST 2018
[17/07/18 19:34:44 CEST] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Wed Jul 18 03:00:00 CEST 2018
[17/07/18 19:34:44 CEST] INFO UPnPService Starting UPnP service...
[17/07/18 19:34:44 CEST] INFO PodcastService Automatic Podcast update scheduled to run every 24 hour(s), starting at Tue Jul 17 19:39:44 CEST 2018
[17/07/18 19:34:45 CEST] INFO UPnPService Disabling UPnP/DLNA media server
[17/07/18 19:34:45 CEST] INFO UPnPService Starting UPnP service - Done!
[17/07/18 19:34:49 CEST] INFO BootstrapVerificationFilter Servlet container: jetty-6.1.x
[17/07/18 19:34:49 CEST] WARN SearchService Failed to get media file 3308
[17/07/18 19:34:54 CEST] INFO NetworkService Deleted port mapping for port 4040
[17/07/18 19:34:54 CEST] INFO NetworkService Deleted port mapping for port 4443
[17/07/18 19:35:03 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:35:47 CEST] WARN SearchService Failed to get media file 2451
[17/07/18 19:35:47 CEST] INFO VersionService Resolved latest Subsonic final version to: 6.1.3
[17/07/18 19:35:47 CEST] INFO VersionService Resolved latest Subsonic beta version to: 6.1.beta2
[17/07/18 19:35:48 CEST] INFO PlayerDao Created player 12.
[17/07/18 19:35:59 CEST] WARN SearchService Failed to get media file 2451
[17/07/18 19:36:05 CEST] WARN CoverArtController Failed to process cover art I:\ServerFolders\Musique\Cats on Trees\Neon (2018)\00-cats_on_trees-neon-2018.jpg: java.lang.OutOfMemoryError: Java heap space
[17/07/18 19:36:09 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:38:08 CEST] WARN SearchService Failed to get media file 2451
[17/07/18 19:38:25 CEST] INFO MusicFolderDao Deleted music folder with ID 0
[17/07/18 19:38:25 CEST] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Wed Jul 18 03:00:00 CEST 2018
[17/07/18 19:38:42 CEST] INFO MusicFolderDao Created music folder I:\ServerFolders\Musique
[17/07/18 19:38:42 CEST] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Wed Jul 18 03:00:00 CEST 2018
[17/07/18 19:38:52 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:39:02 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:39:12 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:39:22 CEST] WARN RESTFilter Error in REST API: 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=?]
[17/07/18 19:39:23 CEST] INFO MediaScannerService Starting to scan media library.
[17/07/18 19:39:23 CEST] ERROR MediaScannerService Failed to scan media library.