"hsqldb: Data cache size limit is reached" error

Post your Server Bug Report
garyo
Posts: 49
Joined: 10 Sep 2015, 01:47
Has thanked: 5 times
Been thanked: 15 times

"hsqldb: Data cache size limit is reached" error

Unread post by garyo » 07 Jun 2017, 02:18

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?
These users thanked the author garyo for the post:
Madsonic

garyo
Posts: 49
Joined: 10 Sep 2015, 01:47
Has thanked: 5 times
Been thanked: 15 times

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

Unread post by garyo » 07 Jun 2017, 02:33

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.

Post Reply