Error on playlist - NullPointerException

[eddik]

Hei,

I am making a playlist with this SQL query:
DELETE FROM playlist_file WHERE PLAYLIST_ID = 119;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID) Select ID, '119' From media_file Where DateDiff('day', "CHANGED", CURRENT_DATE) <= 31 And Type = 'MUSIC' And Play_Count = '0' ORDER BY RAND() Limit 35;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID) Select ID, '119' From media_file Where Type = 'MUSIC' And Play_Count > '15' ORDER BY RAND() Limit 2;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID) Select media_file_id, '119' from starred_media_file INNER JOIN media_file on starred_media_file.media_file_id = media_file.id Where DateDiff('day', "CREATED", CURRENT_DATE) <= 30 Order by RAnd() LIMIT 3;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID) SELECT media_file.id, '119' FROM ALBUM JOIN media_file on album.path = media_file.parent_path WHERE PLAY_COUNT = '0' ORDER BY RAND() Limit 5;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID) Select media_file_id, '119' from starred_media_file INNER JOIN media_file on starred_media_file.media_file_id = media_file.id Where media_file.Play_Count < '15' And media_file.Type = 'MUSIC' Order by Rand() LIMIT 5;


Whenever I try to load it in the Subsonic webpage it works, but when loading from Dsub og Subsonic-client for Android or from Jamstash I get this error:

[2017-11-20 14:49:16,304] WARN RESTFilter - Error in REST API: NullPointerException
java.lang.NullPointerException
at net.sourceforge.subsonic.service.MediaFileService.isRoot(MediaFileService.java:216)
at net.sourceforge.subsonic.controller.RESTController.createJaxbChild(RESTController.java:1387)
at net.sourceforge.subsonic.controller.RESTController.createJaxbChild(RESTController.java:1380)
at net.sourceforge.subsonic.controller.RESTController.getPlaylist(RESTController.java:922)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:166)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at net.sourceforge.subsonic.security.RESTRequestParameterProcessingFilter.doFilter(RESTRequestParameterProcessingFilter.java:95)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:25)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.RESTFilter.doFilter(RESTFilter.java:42)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:36)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:41)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)


Can anybody see what makes the problem? In the webinterface it seems fine.

License Subsonic Premium
Version 6.1.3 (build e408c9) – October 31, 2017
Server jetty-6.1.x, java 1.8.0_141, HSQLDB, Linux (117.5 MB / 500.0 MB)

Centos 7. Seems other playlists created similarly work fine. Also tried to remove some of the insert-lines, but that didn't seem to help?

Thanks!

[eddik]

Ok, think I solved it. A few days ago i deleted a bunch of mp3s that I didn't want, and rescanned. Then I ran Clean-up database.

Now I found many of these files were still in the db and got chosen to be in the playlist. I tried scanning and cleaning up multiple times but they didn't disappear.

After running: Delete FROM media_file WHERE Last_Scanned LIKE '%2017-11-14%' it works again. 11/14 was when I deleted the files.

Now I am wondering why the files didnt disappear from the db, I thought this was what the Clean-up was for?

Thanks!

[guss77]

I have this problem as well, and its bothering me to close to a year now and this is the first I heard what is the possible cause.

I think the server should be fixed to show a more reasonable error than NullPointerException, at least in the logs.

After deleting all rows from the media_file table that didn't have the latest last_scanned value, Subsonic stopped throwing this error.

My SQL query was:

select max(last_scanned) from media_file as m2 into @lastscan;
delete from media_file where last_scanned <> @lastscan;

Make sure Subsonic isn't scanning for media when you run the query, otherwise it will clear your entire table.