Subsonic Forum

Upgraded from 4.6 to 4.7 Beta 2. Deleted cache and first time attempt at scanning media failed.

Code: Select all

[6/9/12 9:17:07 AM PDT]   INFO   DaoHelper   Checking database schema.
[6/9/12 9:17:07 AM PDT]   INFO   DaoHelper   Done checking database schema.
[6/9/12 9:17:07 AM PDT]   INFO   VersionService   Resolved local Subsonic version to: 4.7.beta2
[6/9/12 9:17:07 AM PDT]   INFO   MediaScannerService   Automatic media scanning disabled.
[6/9/12 9:17:07 AM PDT]   INFO   PodcastService   Automatic Podcast update disabled.
[6/9/12 9:17:11 AM PDT]   INFO   NetworkService   Successfully forwarding port 80.
[6/9/12 9:17:31 AM PDT]   ERROR   SearchService   Failed to search for random albums.
[6/9/12 9:17:41 AM PDT]   INFO   VersionService   Resolved latest Subsonic final version to: 4.6
[6/9/12 9:17:41 AM PDT]   INFO   VersionService   Resolved latest Subsonic beta version to: 4.7.beta2
[6/9/12 9:17:48 AM PDT]   INFO   MediaScannerService   Starting to scan media library.
[6/9/12 9:17:48 AM PDT]   ERROR   MediaScannerService   Failed to scan media library.


Artist browsing pane also failed to load

Code: Select all

Error
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.

Exception   org.springframework.jdbc.BadSqlGrammarException
Message   PreparedStatementCallback; bad SQL grammar [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 path=?]; nested exception is java.sql.SQLException: Column not found: ALBUM_ARTIST 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 path=?]
Java version   Sun Microsystems Inc. 1.6.0_31
Operating system   Windows 7 6.1
Server   jetty-6.1.x
Memory   Used 36 of 58 MB
Stack trace   org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [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 path=?]; nested exception is java.sql.SQLException: Column not found: ALBUM_ARTIST 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 path=?]
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   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.AbstractDao.queryOne(AbstractDao.java:120)
   at net.sourceforge.subsonic.dao.MediaFileDao.getMediaFile(MediaFileDao.java:59)
   at net.sourceforge.subsonic.service.MediaFileService.getMediaFile(MediaFileService.java:100)
   at net.sourceforge.subsonic.service.MusicIndexService.createArtistsByFolderStructure(MusicIndexService.java:142)
   at net.sourceforge.subsonic.service.MusicIndexService.createArtists(MusicIndexService.java:131)
   at net.sourceforge.subsonic.service.MusicIndexService.getIndexedArtists(MusicIndexService.java:66)
   at net.sourceforge.subsonic.controller.LeftController.getMusicFolderContent(LeftController.java:218)
   at net.sourceforge.subsonic.controller.LeftController.handleRequestInternal(LeftController.java:140)
   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.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:47)
   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: Column not found: ALBUM_ARTIST 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 path=?]
   at org.hsqldb.jdbc.Util.throwError(Unknown Source)
   at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
   at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
   at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1322)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:585)
   ... 68 more



If this is a Windows install you may need to re-edit the Subsonic service logon settings.

Looks like a permissions issue.

GJ51 wrote:If this is a Windows install you may need to re-edit the Subsonic service logon settings.

Looks like a permissions issue.

Where do I do that? Do you mean the actual service in Windows Services? It is set to use the local system account, is that not right?

Only if all the files are stored on the same machine, ie a local directory. I f you are accessing a server share or remote files you have to do some setup work.

The files are on the local system that Subsonic is installed on. Local system account should be fine.

You're probably going to have to just redo a clean install. I have 4.7b2 running fine on win 64 bit.

Maybe a Java refresh will do it.

That error message means that your code installation (the subsonic.war) is incompatible with your settings database (subsonic.db). I'd guess some glitch in the beta releases that didn't update the database schema as expected. A clean install (uninstall, remove c:/subsonic, install) would fix it (and remove all your settings and users). It would also be possible to carefully update the database schema manually through db.view. A Java uninstall/install wouldn't make any difference.

I am running Windows 7 X64. I have a similar problem. I was running 4.6 and then installed 4.7 beta 2. I have two folders set up and everything was working fine even from outside lan connections. Then I read an article on how to better organize music files and folders. So I picked one sub folder of the "My Music" folder and started by renaming only that one sub folder in the "My Music" folder. "My Music" is what I have registered in Subsonic. After rescanning to see if Subsonic recognized my file rename, all of the folders in My Music are empty except for the Album art. No music. Only one sub folder shows any music. So I removed the "My Music" entry in Subsonic, rescanned, and the "My Music" entry in Subsonic was gone. Then I stop and restart Subsonic just as a precaution and it was as expected, no "My Music" folder in Subsonic. Now I add the "My Music" folder back into Subsonic and rescan. Same problem. The only way I can see all my music folders is when I select "All Files" in Subsonic and even then the "My Music" sub folders only contain album art. By the way, I only messed with one sub folder in the "My Music" folder on my Windows file manager. What have I done?

Example:
e:\documents and settings\btamxx\my documents\my music\
This is the main My Music folder I have and also the one registered in Subsonic.

The sub folders of the My Folders folder all contain artist names such as:
e:\documents and settings\btamxx\my documents\my music\chet atkins\the best of chet atkins\

"Chet Atkins" is the artists name and "The best of chet atkins" is the album name.

All of this was working fine until I renames the "Chet Atkins" folder to "Chet Atkins and Friends" and then rescanned.

As I first mentioned, I have two music folder entries in Subsonic.
C:\Users\Bill Thames\Music\Amazon MP3\Mike Adkins
This folder still works perfectly. Only the My Music folder is hosed.

What's up? Did I break it or is it something in the Beta???

btamxx wrote:I am running Windows 7 X64. I have a similar problem. I was running 4.6 and then installed 4.7 beta 2. I have two folders set up and everything was working fine even from outside lan connections. Then I read an article on how to better organize music files and folders. So I picked one sub folder of the "My Music" folder and started by renaming only that one sub folder in the "My Music" folder. "My Music" is what I have registered in Subsonic. After rescanning to see if Subsonic recognized my file rename, all of the folders in My Music are empty except for the Album art. No music. Only one sub folder shows any music. So I removed the "My Music" entry in Subsonic, rescanned, and the "My Music" entry in Subsonic was gone. Then I stop and restart Subsonic just as a precaution and it was as expected, no "My Music" folder in Subsonic. Now I add the "My Music" folder back into Subsonic and rescan. Same problem. The only way I can see all my music folders is when I select "All Files" in Subsonic and even then the "My Music" sub folders only contain album art. By the way, I only messed with one sub folder in the "My Music" folder on my Windows file manager. What have I done?

Example:
e:\documents and settings\btamxx\my documents\my music\
This is the main My Music folder I have and also the one registered in Subsonic.

The sub folders of the My Folders folder all contain artist names such as:
e:\documents and settings\btamxx\my documents\my music\chet atkins\the best of chet atkins\

"Chet Atkins" is the artists name and "The best of chet atkins" is the album name.

All of this was working fine until I renames the "Chet Atkins" folder to "Chet Atkins and Friends" and then rescanned.

As I first mentioned, I have two music folder entries in Subsonic.
C:\Users\Bill Thames\Music\Amazon MP3\Mike Adkins
This folder still works perfectly. Only the My Music folder is hosed.

What's up? Did I break it or is it something in the Beta???

Update:

I uninstalled 4.7b2 and re-installed it. Same results. So I un-installed it again, searched and deleted every reference in the registry, then installed 4.7b2 again. No change. So I un-installed it and re-installed 4.6 and it really looked good until I clicked on one of my music folders and then this:

Error

Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.



Exception

java.lang.NullPointerException



Message

null



Java version

Sun Microsystems Inc. 1.6.0_31



Operating system

Windows 7 6.1



Server

jetty-6.1.x



Memory

Used 38 of 59 MB



Stack trace
java.lang.NullPointerException
at net.sourceforge.subsonic.controller.MainController.handleRequestInternal(MainController.java:71)
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)

I guess this is not a well read forum. But for anyone having this problem, I uninstalled everything and deleted the c:\subsonic folder containing the database files. Then re-installed 4.7 b2. After setting everything back up (network,port forwarding, etc.) it all works perfectly. I am well pleased with Subsonic. I think I must have deleted a file on the disk while Subsonic was still running or something. I hope this helps.

I sometimes get criticized for making the suggestion, but a clean reinstall of Java and SS is most often just faster and easier than trying to look under the hood to figure out the problem. On most systems it doesn't take very long and if you already have the forwarding rules set up properly they usually don't need to be redone.

Plus I just like knowing that I'm starting with a clean slate.

Glad you fixed it.