Out of memory

Need help? Post your questions here.

Moderator: moderators

Out of memory

Postby jarome » Thu Dec 25, 2014 9:18 pm

When I try to clean up the database in the settings menu, I get an out of memory error. I told Subsonic to use 2000 MB in /etc/sysconfig/subsonic. It is not able to scan my collection of 71000+ tracks. It seems stuck at 21,000 or so.

Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [select max(id) from album where not present]; out of memory; nested exception is java.sql.SQLException: out of memory
Java version Oracle Corporation 1.7.0_71
Operating system Linux 3.16.7-7-desktop
Server jetty-6.1.x
Memory Used 86 of 147 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select max(id) from album where not present]; out of memory; nested exception is java.sql.SQLException: out of memory
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 org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:768)
at net.sourceforge.subsonic.dao.AbstractDao.queryForInt(AbstractDao.java:97)
at net.sourceforge.subsonic.dao.AlbumDao.expunge(AlbumDao.java:236)
at net.sourceforge.subsonic.controller.MusicFolderSettingsController.expunge(MusicFolderSettingsController.java:74)
at net.sourceforge.subsonic.controller.MusicFolderSettingsController.formBackingObject(MusicFolderSettingsController.java:58)
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(Abstr
jarome
 
Posts: 88
Joined: Sat Apr 16, 2011 2:53 am

Re: Out of memory

Postby jarome » Fri Dec 26, 2014 2:18 pm

The problem is that the server does not shut down, even though it says it does. There are multiple Java processes still running (same PID, but different ports). I have to kill these manually, and also the db lck file.
Why doesn't subsonic close down properly? OpenSUSE 13.2
jarome
 
Posts: 88
Joined: Sat Apr 16, 2011 2:53 am


Return to Help

Who is online

Users browsing this forum: No registered users and 10 guests