Java error navigating to 'Starred'

[drewsky]

I have starred a few songs in my collection, but when I click on the "Starred" icon at the top, I see this:

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 media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
Java version Sun Microsystems Inc. 1.6.0_27
Operating system Linux 3.5.0-31-generic
Server jetty-6.1.x
Memory Used 165 of 222 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
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:83)
at net.sourceforge.subsonic.dao.MediaFileDao.getStarredFiles(MediaFileDao.java:269)
at net.sourceforge.subsonic.controller.StarredController.handleRequestInternal(StarredController.java:61)
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.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.format,media_file.title,media_file.album,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, starred_media_file where media_file.id = starred_media_file.media_file_id and media_file.present and media_file.type in (?,?,?,?) and starred_media_file.username=? order by starred_media_file.created desc limit ? offset ?]
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)
... 60 more

Running Subsonic 4.8 "Premium" in Ubuntu 12.04.
Any help would be greatly appreciated.

Drew

[rumremix]

I had the same problem. Turned out my database was corrupted. This was caused when I upgraded java without first manually shutting down SS. Here is that thread...

viewtopic.php?f=2&t=12337