Subsonic 4.7.beta3 released

[phazzard]

Subsonic just stopped working - I cannot get it to do anything - Never had this type of issue before


Error
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 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.7.0_05
Operating system Windows 7 6.1
Server jetty-6.1.x
Memory Used 35 of 49 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.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.getChildrenOf(MediaFileDao.java:78) at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:196) at net.sourceforge.subsonic.service.MusicIndexService.createSortableArtists(MusicIndexService.java:146) at net.sourceforge.subsonic.service.MusicIndexService.getIndexedArtists(MusicIndexService.java:61) at net.sourceforge.subsonic.controller.LeftController.getMusicFolderContent(LeftController.java:220) at net.sourceforge.subsonic.controller.LeftController.handleRequestInternal(LeftController.java:142) 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 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


[8/23/12 10:13:11 AM CDT] INFO DaoHelper Checking database schema.
[8/23/12 10:13:12 AM CDT] INFO Schema47 Database table 'media_file' not found. Creating it.
[8/23/12 10:13:12 AM CDT] ERROR DaoHelper Failed to initialize database.
[8/23/12 10:13:14 AM CDT] INFO VersionService Resolved local Subsonic version to: 4.7.beta3
[8/23/12 10:13:17 AM CDT] INFO MediaScannerService Automatic media library scanning scheduled to run every 3 day(s), starting at Fri Aug 24 03:00:00 CDT 2012
[8/23/12 10:13:18 AM CDT] WARN PlaylistService Failed to auto-import playlist c:\playlists\B's Music.m3u. No songs in the playlist were found.
[8/23/12 10:13:18 AM CDT] INFO PodcastService Automatic Podcast update disabled.
[8/23/12 10:13:22 AM CDT] INFO NetworkService Successfully forwarding port 4040.
[8/23/12 10:14:08 AM CDT] INFO VersionService Resolved latest Subsonic final version to: 4.6
[8/23/12 10:14:08 AM CDT] INFO VersionService Resolved latest Subsonic beta version to: 4.7.beta3
[8/23/12 10:14:09 AM CDT] WARN SearchService Failed to get media file 22152
[8/23/12 10:14:23 AM CDT] INFO MediaScannerService Starting to scan media library.
[8/23/12 10:14:23 AM CDT] ERROR MediaScannerService Failed to scan media library.

[BKKKPewsey]

Thanks to MadEvil we may have found the solution to the playlist problem.
See viewtopic.php?f=2&t=9983&p=44894#p44074
Only just spotted that thread and testing now.

Day 2 of my playlist test and I can still access/display all the playlist tracks so it does look like it may be character case problem

[GJ51]

There are a lot of characters here that cause problems ...

[phazzard]

I completely uninstalled and reinstalled and still same issue as reported above. I am unable to get subsonic to work at all. Long time user, never any issues like this before. Any ideas?

[GJ51]

Did you COMPLETELY remove Java, subsonic, adn delete the C:\Subsonic directory before reinstalling the latest versions of Java and Subsonic?

In Windows, uninstall SS through Control Panel/Programs ans features.

If it don't run after that then your OS is messed up.

[hakko]

There has been at least three different, weird HSQLDB related errors reported for the Subsonic 4.7 beta3 release. It seems pretty likely that there is some obscure bug(s) in Subsonic 4.7 and/or HSQLDB causing this. Wouldn't it be a good idea to upgrade to the latest HSQLDB, at least? The current version, 1.8.0.7, was released in 2006. (!) There's also different opinions on whether HSQLDB is actually production ready or not.

I'm very happy with my change to PostgreSQL as the main database holding metadata of all media files (including a new media scanner that I've written from scratch) but I guess that's asking a bit too much of the average end user to install a stand-alone database engine.

[GJ51]

I'm no expert, but why not MySQL? It's pretty universal isn't it?

[hakko]

MySQL doesn't come as an embedded database for a Java program though, which I guess Sindre wants to make the installation process as as smooth as possible for less experienced users. Besides, changing database is a pretty huge job, so that's why I'm just suggesting an upgrade of the current database to get the benefits of the last six years of work from the devs of HSQLDB.

I don't want to start a database war but PostgreSQL is definitely more appealing than MySQL, if you decide to go for an external database. Since Oracle purchased MySQL, the future is a bit unclear. It was recently reported that the test cases for new releases are no longer open source, for example. PostgreSQL on the other hand is very mature and reliable open source product, with a strong developer base. I feel very confident using it, while I wouldn't use HSQLDB for anything but unit testing in a production environment.

[GJ51]

Thanks,

I'm all for anything that makes SS more stable and perform better. I agree that one area that SS can definitely improve on is stability between version updates. I'm a long time fan of the software and have been testing it long enough to know how to get it to do what i need it to do, but there many long term glitches that need to be fixed.

Making the installation/upgrade process more stable should certainly be near the top of the list and if a better db would contribute in that area, I'm all for it.

[hakko]

DB issues:
viewtopic.php?f=4&t=9998&p=44908&#p44908
viewtopic.php?f=2&t=10105&p=44851#p44851
viewtopic.php?f=2&t=10001&p=44471#p44471

For stability, I can only recommend more and more unit tests and integration tests, that's the way to go, and Subsonic lacks a bit of it.

Sorry about all my complaints, this is still a pretty unique piece of open software! There has been a lot of work put into it and basically, we're just sitting here demanding that Sindre should put more of his spare time into making it more awesome. It's easy to forget to also give proper credits, so I'd like to say thanks again to Sindre for creating this in the first place and for running the forum so that we can discuss and improve it.

[GJ51]

Agreed.

I originally migrated to Subsonic after struggling with Twonky media on my first server, the HP ex485. The whole concept of streaming from your own network was in its infancy then and there weren't many viable options. I stumbled onto SS around version 3.8 and have enjoyed it ever since. It does about everything I need it to do, and most of what I point out and try to explain is for others who have trouble getting it to work right. I guess that's what I'm driving at - it should be easier for new users to get everything working without having to jump through as many whoops as it aometimes takes.

[mbirth]

I also had the 503 error. The log showed something about a FileNotFoundException with a Podcast file. As I moved my music library a few days ago, the podcasts were also moved.

Solution:

• stop SubSonic
• edit /var/subsonic/db/subsonic.script
• replace all appearances of the old path by the new path
• start SubSonic

[GH0]

I am continually getting songs that just randomly stop mid stream:
[8/26/12 6:14:48 PM EDT] INFO PlayQueueInputStream GH0 listening to "Various Artists - Cars Soundtrack/08 Brad Paisley - Find Yourself.mp3"
[8/26/12 6:18:25 PM EDT] INFO PlayQueueInputStream GH0 listening to "DVD/012-monako-shake_da_body.mp3"
[8/26/12 6:19:16 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:19:24 PM EDT] INFO StreamController Got range: Range[6932032,6932032]
[8/26/12 6:19:24 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:19:25 PM EDT] INFO StreamController Got range: Range[6932032,11319295]
[8/26/12 6:19:25 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:19:40 PM EDT] INFO StreamController Got range: Range[11319295,11319295]
[8/26/12 6:19:40 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:19:40 PM EDT] INFO StreamController Got range: Range[11319295,11319295]
[8/26/12 6:19:40 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:20:11 PM EDT] INFO PlayQueueInputStream GH0 listening to "BangarangEP/01 - Right In (Original Mix).mp3"
[8/26/12 6:21:47 PM EDT] INFO StreamController Got range: Range[11319295,11319295]
[8/26/12 6:21:47 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"
[8/26/12 6:21:47 PM EDT] INFO StreamController Got range: Range[11319295,11319295]
[8/26/12 6:21:47 PM EDT] INFO PlayQueueInputStream GH0 listening to "Klaypex - Ready To Go (2012) [320]/07 Sunrise (feat Sara Kay).mp3"

The main culprit of this is the Klaypex song there. The song plays through fine in Foobar2000.

[achmetinternet]

Not sure what's going on here.. all has been well, including beta 1 and 2, until upgrading to beta 3. Now when I try to open subsonic in the browser, i get a 404 error for the index.view

I tried changing ports, but it doesn't seem to help...

I've tried starting/stopping the service multiple times... doesn't help.

It's like it's no longer pointing to the proper local drive location for subsonic's web files. Did something get changed back to use the "default" hard coded install location?

I'm having this same problem too... But I can't get any of the 4.7.beta's to work! I'm currently running Ubuntu 12.04LTS and Subsonic 4.6. This is the first update that I have had trouble installing... All of my permissions seem [linux noob] to be correct... I've checked my ports and made sure the configuration file was correct. Is there something else I'm missing?

I remember a couple of versions back something was changed and Subsonic was very picky about admin rights - is this the case again?

Thanks for any insight!

The 4.7beta3 package works fine... I suggest you do a complete uninstallation of Subsonic and then reinstall it.

I installed 4.7.beta3 and got Error 503... So reading from passed posts, I renamed my db folder and reinstalled the update. I copied in the files from the old db hoping that I would save my users, but no luck. I was able to point to my music and start a scan. It is pretty quick for the amount I have [867GB]. Now I'm building my users - no biggie at least I have my Subsonic back![/quote]

I got this error:
HTTP ERROR: 503

SERVICE_UNAVAILABLE

RequestURI=/login.view

Powered by jetty://

I am running Subsonic on an Amahi Homeserver. Any idea where I can find the db folder and how to save playlists? Or is this going to be fixed with an update on the next beta?

[andvaranaut]

A new nitpick to report. When you click on the name of a song in the playlist, or in any of the 'action' links along the top of the playlist frame (such as prev/next), the frame jumps to the beginning of the playlist, which is rather annoying. Seems to me that there is a "return false;" missing somewhere. Tested with latest Firefox.