Subsomic Server glitching, need help fixing!

[jayw654]

My server for some reason is glitching. Maybe someone will know how to correct the situation. Here are the issues as follows:
1. When changing theme the log in screen will change but the interface of the main page will not.
2. I'm getting sluggish connections when trying to connect, and no it has nothing to do with my network. Anyway for some reason subsonic refuses or slowly connects 60 percent of the time.
3. mp4 streaming fails to work correctly. Files which streamed fine before will no longer stream in mp4. However, flv files seem to be fine. Mov format files are having the same issue of no longer streaming.
4. Requesting lyrics no longer works as it attempts but give a "No Lyrics Found" error.

So how is everything else working?
1. Audio streaming works fine
2. FLV streaming seems okay
3. Everything else seems to be fine also

I know software sometimes glitches and does weird things. I'm hoping someone has ran into this situation before or at least has some tips for fixing the situation, Thanks!

[jayw654]

Here's some additional information which may be needed:

Version

4.5 (build 2385) – August 11, 2011



Server

jetty-6.1.x, java 1.6.0_27, Windows 7 (55.4 MB / 91.4 MB)

[jayw654]

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, comment, play_count, last_played, enabled from music_file_info where path=?]; S1000 General error java.lang.NullPointerException in statement [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?]
Java version Sun Microsystems Inc. 1.6.0_27
Operating system Windows 7 6.1
Server jetty-6.1.x
Memory Used 39 of 68 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?]; S1000 General error java.lang.NullPointerException in statement [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?] 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.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:58) at net.sourceforge.subsonic.dao.AbstractDao.queryOne(AbstractDao.java:62) at net.sourceforge.subsonic.dao.MusicFileInfoDao.getMusicFileInfoForPath(MusicFileInfoDao.java:51) at net.sourceforge.subsonic.service.MusicInfoService.getMusicFileInfoForPath(MusicInfoService.java:45) at net.sourceforge.subsonic.controller.MainController.handleRequestInternal(MainController.java:105) 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:43) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:54) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54) 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.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:227) at org.mortbay.jetty.security.SslSocketConnector$SslConnection.run(SslSocketConnector.java:626) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442) Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [select id, path, comment, play_count, last_played, enabled from music_file_info where path=?] 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) ... 63 more

[jayw654]

I fixed the problem I killed the c:\subsonic folder and store back the database file. nexted loaded subsonic to create the folders then closed it and put the database file in the set of new folders that were created when subsonic was reopened. Lastly I use the instal file to write any missing files that weren't repopulated by opening the program. All is well now except on thing, Lyrics are not working

[BKKKPewsey]

Its most probably not working because chartlyrics.com is not working
which appears to be a regular occurrence

[jayw654]

Well if its been a regular occurance why doesn't the writer use a different database?

[Schokobecher]

I'm offering a 25$ bounty if someone creates a working mod that utilizes another (or better yet multiple) lyric engine(s).
Or maybe even the option to add lyrics manually.

Payment via Paypal or bank transfer.

[BKKKPewsey]

Chartlyrics website is still down (over 2 weeks now) so the api is now only really suitable for instrumental tracks
I think that SS should use embedded lyrics which would then allow all users their lyric engine of choice.

[Schokobecher]

^
exactly.
Gonna post this in the Feature Request forum, maybe more people are willing to offer a bounty to the coder making this possible

[pemholder]

Chartlyrics website is still down (over 2 weeks now) so the api is now only really suitable for instrumental tracks
I think that SS should use embedded lyrics which would then allow all users their lyric engine of choice.

http://forum.subsonic.org/forum/viewtopic.php?f=2&t=2404&p=7960&hilit=lyrics#p7960