Version 5.0.3560.beta4 (also 3510) Last.fm

Post your Server Bug Report
Commanche
Posts: 7
Joined: 21 May 2013, 23:21
Has thanked: 0
Been thanked: 3 times

Version 5.0.3560.beta4 (also 3510) Last.fm

Unread post by Commanche »

Trying to sync with last.fm after updating Java to the latest version:
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
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Version 5.0.3560.beta4 (also 3510) Last.fm

Unread post by Madsonic »

hi there,

the S1000 General error is a rare Database error.
can you try a new test installation from scratch?

best regards
gurutech
Contributor
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

Unread post by gurutech »

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.
Commanche
Posts: 7
Joined: 21 May 2013, 23:21
Has thanked: 0
Been thanked: 3 times

Re: Version 5.0.3560.beta4 (also 3510) Last.fm

Unread post by Commanche »

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
These users thanked the author Commanche for the post:
Madsonic
Rating: 7.69%
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: Version 5.0.3560.beta4 (also 3510) Last.fm

Unread post by Madsonic »

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.
Hi there,

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
Attachments
2013-07-24 23_25_41-.png
Post Reply