Not Scanning Media

[phred]

I'm running Subsonic 6.1.6 on a Windows 10 PC. For the past few days the scan for media has not taken place. It's supposed to run automatically at 18:00. Today I finally had some time to dig into this and when I start the scan manually the usual count showing the number of files scanned (in the upper right corner of the GUI) doesn't even start. When I clicked on Settings > Media Folders > Clean up database, it shows this:


And since I can't capture the entire stack trace in a screenshot, this is what is shows:

Code: Select all

org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select min(id) from media_file where not present]; S1000 General error java.util.NoSuchElementException in statement [select min(id) from media_file where not present]; nested exception is java.sql.SQLException: S1000 General error java.util.NoSuchElementException in statement [select min(id) from media_file where not 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 org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:768)
   at net.sourceforge.subsonic.dao.AbstractDao.queryForInt(AbstractDao.java:119)
   at net.sourceforge.subsonic.dao.MediaFileDao.expunge(MediaFileDao.java:546)
   at net.sourceforge.subsonic.controller.MusicFolderSettingsController.expunge(MusicFolderSettingsController.java:57)
   at net.sourceforge.subsonic.controller.MusicFolderSettingsController.formBackingObject(MusicFolderSettingsController.java:40)
   at org.springframework.web.servlet.mvc.AbstractFormController.getErrorsForNewForm(AbstractFormController.java:358)
   at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:338)
   at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:278)
   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:25)
   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
   at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:36)
   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
   at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:41)
   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 min(id) from media_file where not 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)
   ... 65 more

Can someone lend a hand and let me know what's going on and how to resolve it?

Thanks.

[phred]

Bump

[phred]

80 views and who know how many registered forum users and no one has a clue about this?

[Michael Bech Hansen]

The stacktrace mentions “S1000 general error”...
As far as i know this indicates some sort of database corruption.

Try searching these forums for “S1000”, and see if there is anything useful in previous threads.

/M

[phred]

The stacktrace mentions “S1000 general error”...
As far as i know this indicates some sort of database corruption.

Thanks Michael. I will search the forum in a little while and see what I come up with. A number of years ago SubSonic was giving me some issues (can't remember exactly what it was at this point) and I found and ran this. Which I've done a couple of times during this current issue and it hasn't helped. I will look to see what else the forum offers.

The Subsonic Media Streamer is a fantastic application for streaming and
synchronising your music, movies and TV shows, but from time to time
you’re likely to run into issues with the internal database it uses to
store metadata and configuration. This article contains a couple of
quick tips that should help fix issues with files in your media folders
not being indexed correctly.

Go to your Subsonic instance’s database configuration page —
http://yoursubsonicinstall/db.view. Once here, paste the following into
the text box:

DELETE FROM ALBUM;
DELETE FROM ARTIST;
DELETE FROM BOOKMARK;
DELETE FROM MEDIA_FILE;
DELETE FROM MUSIC_FILE_INFO;
DELETE FROM PLAYER;
DELETE FROM PLAYER_TRANSCODING;
DELETE FROM PLAYER_TRANSCODING2;
DELETE FROM PLAYLIST;
DELETE FROM PLAYLIST_FILE;
DELETE FROM PLAYLIST_USER;
DELETE FROM SHARE;
DELETE FROM SHARE_FILE;
DELETE FROM STARRED_ARTIST;
DELETE FROM STARRED_ALBUM;
DELETE FROM STARRED_MEDIA_FILE;
DELETE FROM TRANSCODING;
DELETE FROM TRANSCODING2;
DELETE FROM USER_RATING;

Click the Submit button and wait patiently. When this operation is
complete, go back to the index page of your Subsonic instance, click
Settings, Media Folders, then Clean-up database. Once complete, re-scan
the library; all of your issues should now be solved without losing your
user settings.

[phred]

I found a number of seemingly relevant threads but couldn't try any of the suggests right now. Another issue has developed. My music files are on a NAS yet SS is claiming there is "no media folder found." The music folder on the NAS has a drive letter mapped, but no matter what I've tried, it won't budge. I've tried Z: which is mapped direct to the music files directory. I've tried \\192.168.1.2\Music_Files, and I've tried \\11-NAS, which is the name of the NAS and has worked before. Even stranger is that from the Win10 PC on which the Subsonic server lives, I can use file explore and drill down to the proper directory. I can also use the mapped shortcut both to the music directory and to the NAS root. The NAS can ping the subsonic PC and all the PCs in the LAN can ping the NAS. Although when I double click on the desktop network icon, only the PC with the Subsonic server shows up. No NAS and no other PCs. It doesn't make any sense.