Error Playing audio and navigating to a folder

[lladelfa]

Problem Description:I have 2 issues that both happened at the same time. First when navigating to one of my folders I am getting an error this error is described in the in the bellow error message section. Also I can not play any audio on files I can navigate to, I can queue them up but they will not play. These errors occur both in the browser version on the pc and on the Android subsonic app.
Troubleshooting Steps: Tried to use different browsers, also tried to update my java on my computer to the most recent version. I have uninstalled and reinstalled subsonic 4.7 but kept the same database.
Playback Application and version:Chrome, Subsonic for android, internet explorer and firefox these have all been tested on different pcs/devices all with the same results
Subsonic Version:4.7 (build 3106) – September 12, 2012
Server Version: jetty-6.1.x, java 1.7.0_11, Windows 8 (62.8 MB / 114.8 MB)
Hardware Platform: windows 8
Java Memory Limit: 250
Problem Filename: na
Output from ffmpeg -i: na
Last ten log file lines:

Code: Select all

[1/26/13 12:09:15 PM EST]   INFO   DaoHelper   Checking database schema.
[1/26/13 12:09:16 PM EST]   INFO   DaoHelper   Done checking database schema.
[1/26/13 12:09:17 PM EST]   INFO   VersionService   Resolved local Subsonic version to: 4.7
[1/26/13 12:09:17 PM EST]   INFO   MediaScannerService   Automatic media library scanning scheduled to run every 1 day(s), starting at Sun Jan 27 03:00:00 EST 2013
[1/26/13 12:09:17 PM EST]   INFO   PodcastService   Automatic Podcast update scheduled to run every 24 hour(s), starting at Sat Jan 26 12:14:17 EST 2013
[1/26/13 12:09:20 PM EST]   INFO   NetworkService   Successfully forwarding port 83.
[1/26/13 12:10:12 PM EST]   INFO   PlayerDao   Created player 121.
[1/26/13 12:10:13 PM EST]   INFO   VersionService   Resolved latest Subsonic final version to: 4.7
[1/26/13 12:10:13 PM EST]   INFO   VersionService   Resolved latest Subsonic beta version to: 4.7.beta3
[1/26/13 12:14:17 PM EST]   INFO   PodcastService   Starting scheduled Podcast refresh.
[1/26/13 12:14:17 PM EST]   INFO   PodcastService   Completed scheduled Podcast refresh.

Error Message:

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.dao.TransientDataAccessResourceException
Message   PreparedStatementCallback; SQL [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; java.io.IOException: S1000 Data file size limit is reached in statement [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; nested exception is java.sql.SQLException: java.io.IOException: S1000 Data file size limit is reached in statement [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]
Java version   Oracle Corporation 1.7.0_11
Operating system   Windows 8 6.2
Server   jetty-6.1.x
Memory   Used 64 of 114 MB
Stack trace   org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; java.io.IOException: S1000 Data file size limit is reached in statement [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]; nested exception is java.sql.SQLException: java.io.IOException: S1000 Data file size limit is reached in statement [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]
   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.update(JdbcTemplate.java:792)
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
   at net.sourceforge.subsonic.dao.AbstractDao.update(AbstractDao.java:71)
   at net.sourceforge.subsonic.dao.MediaFileDao.createOrUpdateMediaFile(MediaFileDao.java:134)
   at net.sourceforge.subsonic.service.MediaFileService.checkLastModified(MediaFileService.java:128)
   at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:197)
   at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:173)
   at net.sourceforge.subsonic.controller.MainController.handleRequestInternal(MainController.java:84)
   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: java.io.IOException: S1000 Data file size limit is reached in statement [update media_file set 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=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=? where path=?]
   at org.hsqldb.jdbc.Util.throwError(Unknown Source)
   at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
   at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
   ... 62 more


[BKKKPewsey]

Could you have a look in your in c:\subsonic\db folder and report back the size of your subsonic.data file.

A number of users have reported problems similar to this and it would be nice to get this issue resolved.

p.s. Hakko yes we all are aware that HSQLDB is not ideal

[hakko]

Wait wait let me explain a 100th time how bad it is! It's my favorite story!

Or.. is it maybe clear anyway

[lladelfa]

Hey Thanks for the quick reply!

here is the size of my C:\subsonic\db folder

2.26 GB (2,427,660,612 bytes)

[BKKKPewsey]

Yep that's the problem as I believe HSQLDB has a max default limit of 2GB.

The question is why is your DB so large I have over 125k tracks indexed (1.4TB) and my db is only 260MB.
Something is certainly going wrong here (unless you have a very very large media collection)

I suggest stopping SS - rename the subsonic db folder to say "oldDB" and restarting SS
This will create a new DB.
If you then stop SS again - copy the subsonic.script file from the oldDB folder to the new one and then restart SS again this will (should ) copy back most of your settings/users etc.
Note you will have to rescan your media again.
Unless you are really tight on hd space keep hold of the old db as Sindre may want to examine it to investigate further.

He does pop in regularly - just doesn't post much (probably too busy getting HSQLDB to work)

[lladelfa]

I renamed my current db folder to olddb as suggested and when subsonic rebuilt the db files I was able to login to Subsonic with all the default settings. I then shutdown services and copied the .script file over and restarted the services. When trying to log in it received an error.

I then went in and edited the default .script that subsonic creates and added the lines from the backed up .script file that creates the users, players, ect and so far it seems to be fixed.

I'll reply back with my db sized once it gets fully recreated.