Subsonic Forum

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 [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; java.io.IOException: S1000 Data file size limit is reached in statement [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: java.io.IOException: S1000 Data file size limit is reached in statement [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
Java version Oracle Corporation 1.7.0_21
Operating system Windows 7 6.1
Server jetty-6.1.x
Memory Used 88 of 239 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; java.io.IOException: S1000 Data file size limit is reached in statement [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: java.io.IOException: S1000 Data file size limit is reached in statement [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
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:152)
at net.sourceforge.subsonic.service.MediaFileService.getMediaFile(MediaFileService.java:118)
at net.sourceforge.subsonic.service.MusicIndexService.createSortableArtists(MusicIndexService.java:145)
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.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:227)
at org.mortbay.jetty.security.SslSocketConnector$SslConnection.run(SslSocketConnector.java:626)
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 [insert into media_file (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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
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)
... 64 more


unfortunally i was unable to print more than that.

I would like to access my 30 Tb music by my mobile wherever i am in the world. what to do?
I even written to the owner in norway, but he didn´t answer.. even when i paid...

Just explain to me how:

1, I can get all my 30 tb music to be accessable?
2, How do i expand so that even my other computer can share videos,,? (sometimes nice to watch during travels U know)
3, There were neve any information about program limits... and would be nice to know?

regard

swedepete

What version of Subsonic do you have, what version of Java, and what OS are you running this on?

Pastebin will let you post the whole thing without a wall of text.

Sent from my SCH-I535 using Tapatalk 2

I have gotten this error a couple of times in the past.. To fix it, all I did was clear the cache in my browser (unrelated, but that is what I did) and then restart the server and everything worked fine.

Latest stable release – Subsonic 4.8 <- that version

Not very much help either... here.

Can anyone tell me the limitations for subsonic?
1.. max songs
2.. max harddrives

and if anyone have any knowlwdge about how to add network drives to db.
plz.. no n00b answers thanks.

//swedepete

Max Songs? I dunno.. I have about 110K songs and that is not even as much as some guys here have.
Hard drives? Depends on your setup... I have a PE1800 Tower, running a Raid 1 for the OS (Ubuntu Server) and a Raid 5 for the storage with 4 drives. I also have a raid box that has 4 drive capacity on my workstation that is also mapped to the server. I think the only limitation you have with hard drives would be your server setup, but certainly not with subsonic.
I think currently I have around 5 or 6 TB of data presented to the subsonic server and it runs flawless... Yes.. I did recently upgrade to 4.8. I have been running subsonic for quite a few years now.

Hope that answers some of your questions...

swedepete wrote:Not very much help either... here.

Can anyone tell me the limitations for subsonic?
1.. max songs
2.. max harddrives

and if anyone have any knowlwdge about how to add network drives to db.
plz.. no n00b answers thanks.

//swedepete

I've never seen any reports of anyone hitting a limit, but certainly 30TB of music would be a great test.

The tutorials section for Windows shows how to set up network shares in Subsonic very well.

viewtopic.php?f=6&t=4867

The Monroeworld link shows how to setup service logon rights to the network share for Windows. I would think that the same principles apply to Linux, but I'm a Windows user so I can't help you with the details, but there are plenty of guys here that could help you with that if you're on Linux.

I currently have about 6TB of music and video in my media library and it all runs fine. Obviously the more hardware power you have the better the performance when dealing with large data. I use a RAID 60 array for storage and dual quad core Xeons @2.83GHz to push SS out over 35/35 mbps Fios. Even at that, recorded 1080i TV can run into issues depending on the connection speed of the remote access device.

Thanks Gary.

I were maybe somewhat blurry... I really know how to set up and share drives in a network even with separate profiles and so on. Just that subsonic refus to rcognize them even if i connect them as localdrives.

and about the number of songs.. subsonic stop updating db at aprox 1.500.000 songs.. just freezes..

16 Gb mem in comp.. so should be enough even to handle a dB in subsonic i hope..

would be greatful to get somewhat info about what subsonic really can manage..

unneccesary to invest in more mem for exampla if the program cant handle my requirements.

//regarsds

swedepete

You most likely need to bump up the java memory allocation to accommodate the larger db size. Default is 150, so I'd probably go to 512 or higher with your installation.

I haven't had that issue in so long that I'd have to look it up in the tutorials to see where I'd have to adjust the setting, but the instructions are available here in the forums. It's different for each installation type. The standard windows install allows you to adjust it from the tray icon.

java memory configered to : 32768 Mb , doesn´t work anyway.. stop udating mp3 at apeox 1,500,000 songs still..

You may just have found the limits that have been asked about from time to time. If it's any consolation, it would take over 8.5 years to play 1.5 million tracks back playing 24/7 assuming 3 min./track.

I sent you a PM with another idea that may help, but realistically, your collection may just be beyond the scope of an open source db.

Giving it some more thought, even trying to cope with a collection this size would present some issues just in presentation in the interface.

An alternative might be to break it down into more manageable sub-collections. I run several instances of Subsonic on my 4 servers, some of which are also running virtual machines. All of them access the same storage pool.
If I had to find a solution for your particular issue, I'd be looking at possibly having multiple sites that access subdivisions of the collection. Of course that would depend on how your data is organized. If it needed to be reorganized to employ a strategy like I've suggested, that in itself could prove to be a daunting task.

Managing big data is the new frontier.

I've been thinking about adding some new hardware as ebay has tons of affordable servers in inventory right now.

http://www.ebay.com/sch/Servers-/11211/i.html?Brand=Dell&Processor%2520Type=Xeon%2520Quad%2520Core&Form%2520Factor=Rackmount&_dcat=11211&Product%2520Line=PowerEdge%2520C

If getting remote access via Subsonic is a priority for you, adding some hardware and setting up subcollections could be a practical answer for you.

Way above my paygrade, but I overheard a convo recently where websites were using this to handle large amounts of data:
http://en.wikipedia.org/wiki/Apache_Cassandra

This guy comes in declaring his badass 30 TBs is just too much...request that he gets

"No N00bs"

on his reply...yet:

Memory Used 88 of 239 MB

Beyond all the other obvious fails. This guy carved out 239MB for the software to chew on his "30TBs" of content.

Don't feed the Trolls. I'm only posting years later so people don't think there is some sort of "limit" thanks to this guys' brilliant post

PM Me if you need help setting things up.
-I'm running beyond what OP was trying to do with no lag & no issues.

After reading this SwedePete guy's posts frankly if I was Sindre I wouldn't have replied either.


& I'd love to see this 30 TB collection too. Hell, I'll get the server running just to see it.