Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?]; S1000 General error java.lang.NullPointerException in statement [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?]
Java version Oracle Corporation 1.7.0_25
Operating system Windows 7 6.1
Server jetty-6.1.x
Memory Used 218 of 290 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?]; S1000 General error java.lang.NullPointerException in statement [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?]; nested exception is java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?] 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.update(JdbcTemplate.java:792) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858) at net.sourceforge.subsonic.dao.AbstractDao.update(AbstractDao.java:71) at net.sourceforge.subsonic.dao.LastFMArtistSimilarDao.createOrUpdateLastFMArtistSimilar(LastFMArtistSimilarDao.java:70) at net.sourceforge.subsonic.service.LastFMService.getArtistInfo(LastFMService.java:254) at net.sourceforge.subsonic.controller.LastFMSettingsController.handleRequestInternal(LastFMSettingsController.java:73) 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:124) 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:174) 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 [update lastfm_artist_similar set artist_name=?,artist_mbid=?,similar_name=?, similar_mbid=? where artist_name=? and similar_name=?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) ... 61 more
Version 5.0.3560.beta4 (also 3510) Last.fm
Version 5.0.3560.beta4 (also 3510) Last.fm
Trying to sync with last.fm after updating Java to the latest version:
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Version 5.0.3560.beta4 (also 3510) Last.fm
hi there,
the S1000 General error is a rare Database error.
can you try a new test installation from scratch?
best regards
the S1000 General error is a rare Database error.
can you try a new test installation from scratch?
best regards
-
- Contributor
- Posts: 323
- Joined: 02 Jan 2013, 04:56
- Has thanked: 11 times
- Been thanked: 105 times
Re: Version 5.0.3560.beta4 (also 3510) Last.fm
Note sure if what I experienced is similar, but when I tried to do a "full" Last.FM sync, it just took FOREVER! I eventually just clicked on something else (like "Home") to continue Madsonic.
No error messages, the server or browser didn't freeze or anything, just a weird anomaly.
No error messages, the server or browser didn't freeze or anything, just a weird anomaly.
Re: Version 5.0.3560.beta4 (also 3510) Last.fm
A new installation solved the problem
gurutech: Did you watch the logfile? It seems like it's doing nothing, but in the logfile you should see, that he's actually working on it, e.g. [7/24/13 10:25:02 AM CEST] INFO LastFMService ## LastFM ArtistInfo Update: AC/DC
Commanche
gurutech: Did you watch the logfile? It seems like it's doing nothing, but in the logfile you should see, that he's actually working on it, e.g. [7/24/13 10:25:02 AM CEST] INFO LastFMService ## LastFM ArtistInfo Update: AC/DC
Commanche
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Version 5.0.3560.beta4 (also 3510) Last.fm
Hi there,gurutech wrote:Note sure if what I experienced is similar, but when I tried to do a "full" Last.FM sync, it just took FOREVER! I eventually just clicked on something else (like "Home") to continue Madsonic.
No error messages, the server or browser didn't freeze or anything, just a weird anomaly.
yes the Last.FM Full Scan work as designed.
If you have many artist this can take a long time, but once it is triggerd you don't must wait to finish, it runs in the background.
So with last Build, i add a Delta Sync to speed up the missing requests.
best regards