Track/Artist Index and Search not available

[djregular]

I'm currently running Subsonic off of a Raspberry Pi w/Raspbian as the OS, and a few days ago the following error appeared in the A-Z index:

Code: Select all

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]; S1000 General error java.util.NoSuchElementException in statement [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]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [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]
Java version   Oracle Corporation 1.8.0_121
Operating system   Linux 4.9.28+
Server   jetty-6.1.x
Memory   Used 60 of 132 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]; S1000 General error java.util.NoSuchElementException in statement [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]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [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]
   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:97)
   at net.sourceforge.subsonic.dao.MediaFileDao.getChildrenOf(MediaFileDao.java:86)
   at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:205)
   at net.sourceforge.subsonic.service.MusicIndexService.createSortableArtists(MusicIndexService.java:176)
   at net.sourceforge.subsonic.service.MusicIndexService.getIndexedArtists(MusicIndexService.java:60)
   at net.sourceforge.subsonic.service.MusicIndexService.getMusicFolderContent(MusicIndexService.java:70)
   at net.sourceforge.subsonic.controller.ArtistsController.handleRequestInternal(ArtistsController.java:130)
   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:59)
   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 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]
   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

Also searching for anything turned up no results. I'm able to access songs in the 'Recently Played' or 'Recently Added' queue, but anything else produced the above error. I'm currently running 6.1 and haven't tried upgrading yet. If upgrading could solve the problem, any pointers on the best way to upgrade via Raspbian would be appreciated.

[djregular]

Update: Upgraded to 6.1.1 and it didn't help. Didn't make things any worse, thankfully.

[alphawave7]

S1000 error generally indicates a corrupt db, often after a java update, for whatever reason (improper service shutdown is suspected). You can try renaming to old.db, and rebuild your db, but you will lose existing users/settings/etc. Once fixed, back this db up..and keep current backups handy for this issue in the future.

[djregular]

So I tried to clear the database to try and save my settings, users, etc by stopping subsonic, and doing the following:

Code: Select all

1. Backed up /var/subsonic/db/subsonic.script file
"cp /var/subsonic/db/subsonic.script /root/"
2. Deleted the contents of my /var/subsonic/db/ directory
"rm /var/subsonic/db/*"
3. Restored subsonic.script file
"cp /root/subsonic.script /var/subsonic/db/"


And it appeared to work, no errors returned and I was able to log in successfully. But I've been trying to scan my library and it's getting stuck at 1. Even after a reboot and making sure to run from admin. If I need to delete the old db entirely, let me know how to actually rebuild the db if I'm mistaken on the process. Otherwise, is there a reason that the scanning process would hang like this? When I was getting the error, I could still manage to play music, I just wasn't able to access it via the index.

Thanks in advance!

[djregular]

Update: So, I've done the following to try and get the scan to progress past 1 file:
1. Unmounted and remounted the drive where the files are located.
2. Various restarts of the Pi and Subsonic.
3. Created a new location to mount the drive to, and pointed Subsonic to it.

That last step did result in some progress. The scanning now updated to 2, and less than half of my files do show up in the 'recently added' section. I've also checked, and all of my files are still present, there's just something keeping Subsonic from progressing the scan. It doesn't ever stop, but it doesn't move any further.

[djregular]

Bumping this thread. Eventually, the scan seemed to progress (albeit slowly) as normal, and eventually all my files showed back up. Unfortunately, shortly afterward, I was back to square one after clearing my database. Scanning files stuck at 1, no files visible in Subsonic, but all my files on disk are still there.

I'm wagering that I'll have to start over from the beginning, but if there's any assistance anyone can offer, I'd appreciate it.

[djregular]

Bumping this thread, one more time. My Subsonic routine has basically devolved into this:

So I tried to clear the database to try and save my settings, users, etc by stopping subsonic, and doing the following:

Code: Select all

1. Backed up /var/subsonic/db/subsonic.script file
"cp /var/subsonic/db/subsonic.script /root/"
2. Deleted the contents of my /var/subsonic/db/ directory
"rm /var/subsonic/db/*"
3. Restored subsonic.script file
"cp /root/subsonic.script /var/subsonic/db/"


And it appeared to work, no errors returned and I was able to log in successfully. But I've been trying to scan my library and it's getting stuck at 1.

From there, after a LONG time (somewhere in-between 24 to 48 hours), then scan eventually finishes, at a certain jumping up to a much larger file number. Then I'm able to use Subsonic normally for anywhere from a few days to about a week before I get some sort of input/output database error.

Do I have any other recourse aside from completely scrapping the DB entirely? I'll say it again, if I need to delete the old db entirely, please let me know how to actually rebuild the db if I'm mistaken on the process. Otherwise, is there a reason that the scanning process would hang like this? Is it possibly a java issue?