Library partially showing (hole from F to J letters)

Need help? Post your questions here.

Moderator: moderators

Library partially showing (hole from F to J letters)

Postby Griffon13 » Tue Jul 17, 2018 6:13 pm

Hello
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.
Griffon13
 
Posts: 1
Joined: Tue Jul 17, 2018 5:59 pm

Return to Help

Who is online

Users browsing this forum: No registered users and 6 guests