Page 1 of 1

"hsqldb: Data cache size limit is reached" error

Posted: 07 Jun 2017, 02:18
by garyo
After upgrading to 6.3.9500, I'm now getting this error:

Code: Select all

Data cache size limit is reached

Code: Select all

[2017-06-06 21:04:45,386] WARN HsqlDaoHelper - Checking HSQLDB database schema ...
[2017-06-06 21:04:46,607] INFO HSqlSchema01 - Database table 'version' not found.  Creating it.
[2017-06-06 21:04:46,853] ERROR HsqlDaoHelper - Failed to initialize HSQLDB database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLExcep
tion: error in script file line: 195 /var/madsonic/db/madsonic Data cache size limit is reached: 10000 in statement [SET TABLE 
PUBLIC.ARTIST INDEX '308206 309042 309042 308176 308693 307456 0 0 0 0 0 0 318']
...
Caused by: org.hsqldb.HsqlException: error in script file line: 195 /var/madsonic/db/madsonic Data cache size limit is reached: 10000 in statement [SET TABLE PUBLIC.ARTIST INDEX '308206 309042 309042 308176 308693 307456 0 0 0 0 0 0 318']
And madsonic won't start. Help, anyone? How can I set hsqldb properties in madsonic?

Re: "hsqldb: Data cache size limit is reached" error

Posted: 07 Jun 2017, 02:33
by garyo
I restored from last night's db backup, and I'm back up and running. So it looks like it's db corruption, related to a hard shutdown doing a db operation or something.