Can't load parts of the interface, Subsonic can't find music
Posted: Wed Sep 19, 2018 1:55 pmI'm at work and not at home where the server is located so I don't know if I can do much from here...
SO here's the problem: the login page looks fine, but when I log in as user I get an exception instead of the left menu panel.
If I try to load the "Index" I get the same error, which I've pasted in the code block below.
I don't see this exception at all when login in as admin. However, it appears as though i have no music at all.
Any attempt to rescan any folder immediately fails.
The giant block seemed to indicate memory issues so i tried scanning a smaller folder with only a dozen media files in it instead of the usual one and that didn't change anything.
What on earth is going on?? I've been using this for over a year never encountered something like this.
Here are the latest bunch of log entries:
And here's that huge error message:
SO here's the problem: the login page looks fine, but when I log in as user I get an exception instead of the left menu panel.
If I try to load the "Index" I get the same error, which I've pasted in the code block below.
I don't see this exception at all when login in as admin. However, it appears as though i have no music at all.
Any attempt to rescan any folder immediately fails.
The giant block seemed to indicate memory issues so i tried scanning a smaller folder with only a dozen media files in it instead of the usual one and that didn't change anything.
What on earth is going on?? I've been using this for over a year never encountered something like this.
Here are the latest bunch of log entries:
- Code: Select all
[9/19/18 7:46:53 AM EDT] INFO NetworkService Successfully forwarding port 4040.
[9/19/18 8:00:12 AM EDT] INFO MediaScannerService Starting to scan media library.
[9/19/18 8:00:15 AM EDT] ERROR MediaScannerService Failed to scan media library.
[9/19/18 8:00:15 AM EDT] INFO PlaylistService Starting playlist import.
[9/19/18 8:00:15 AM EDT] INFO PlaylistService Completed playlist import.
[9/19/18 8:19:57 AM EDT] INFO VersionService Resolved latest Subsonic final version to: 6.1.3
[9/19/18 8:19:57 AM EDT] INFO VersionService Resolved latest Subsonic beta version to: 6.1.beta2
[9/19/18 8:22:09 AM EDT] INFO NetworkService Successfully forwarding port 4040.
[9/19/18 9:24:18 AM EDT] INFO NetworkService Successfully forwarding port 4040.
[9/19/18 9:33:15 AM EDT] INFO PlayerDao Created player 32.
[9/19/18 9:33:55 AM EDT] INFO MediaScannerService Starting to scan media library.
[9/19/18 9:33:57 AM EDT] ERROR MediaScannerService Failed to scan media library.
[9/19/18 9:33:57 AM EDT] INFO PlaylistService Starting playlist import.
[9/19/18 9:33:57 AM EDT] INFO PlaylistService Completed playlist import.
[9/19/18 9:36:54 AM EDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Thu Sep 20 08:00:00 EDT 2018
[9/19/18 9:36:57 AM EDT] INFO MediaScannerService Starting to scan media library.
[9/19/18 9:36:59 AM EDT] ERROR MediaScannerService Failed to scan media library.
[9/19/18 9:36:59 AM EDT] INFO PlaylistService Starting playlist import.
[9/19/18 9:36:59 AM EDT] INFO PlaylistService Completed playlist import.
[9/19/18 9:38:46 AM EDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Thu Sep 20 08:00:00 EDT 2018
[9/19/18 9:38:53 AM EDT] INFO MediaScannerService Starting to scan media library.
[9/19/18 9:38:55 AM EDT] ERROR MediaScannerService Failed to scan media library.
[9/19/18 9:38:55 AM EDT] INFO PlaylistService Starting playlist import.
[9/19/18 9:38:55 AM EDT] INFO PlaylistService Completed playlist import.
[9/19/18 9:43:19 AM EDT] INFO MusicFolderDao Deleted music folder with ID 0
[9/19/18 9:43:19 AM EDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Thu Sep 20 08:00:00 EDT 2018
[9/19/18 9:43:23 AM EDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Thu Sep 20 08:00:00 EDT 2018
[9/19/18 9:43:25 AM EDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Thu Sep 20 08:00:00 EDT 2018
[9/19/18 9:43:33 AM EDT] INFO MediaScannerService Starting to scan media library.
[9/19/18 9:43:33 AM EDT] INFO MediaScannerService Scanned media library with 1 entries.
[9/19/18 9:43:33 AM EDT] INFO MediaScannerService Marking non-present files.
[9/19/18 9:43:34 AM EDT] ERROR MediaScannerService Failed to scan media library.
[9/19/18 9:43:34 AM EDT] INFO PlaylistService Starting playlist import.
[9/19/18 9:43:34 AM EDT] INFO PlaylistService Completed playlist import.
And here's that huge error message:
- Code: Select all
Error
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.
Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [select id, path, 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, created, changed, last_scanned, children_last_updated, present, version from media_file where parent_path=? and present]; out of memory; nested exception is java.sql.SQLException: out of memory
Java version Oracle Corporation 1.8.0_31
Operating system Windows 8 6.2
Server jetty-6.1.x
Memory Used 59 of 145 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select id, path, 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, created, changed, last_scanned, children_last_updated, present, version from media_file where parent_path=? and present]; out of memory; nested exception is java.sql.SQLException: out of memory
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
at net.sourceforge.subsonic.dao.AbstractDao.query(AbstractDao.java:84)
at net.sourceforge.subsonic.dao.MediaFileDao.getChildrenOf(MediaFileDao.java:68)
at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:187)
at net.sourceforge.subsonic.service.MusicIndexService.createSortableArtists(MusicIndexService.java:158)
at net.sourceforge.subsonic.service.MusicIndexService.getIndexedArtists(MusicIndexService.java:42)
at net.sourceforge.subsonic.service.MusicIndexService.getMusicFolderContent(MusicIndexService.java:52)
at net.sourceforge.subsonic.controller.LeftController.handleRequestInternal(LeftController.java:45)
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.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 org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
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.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)
Caused by: java.sql.SQLException: out of memory
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 64 more