"hsqldb: Data cache size limit is reached" error

Post your Server Bug Report

"hsqldb: Data cache size limit is reached" error

Unread postby 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?
garyo
 
Posts: 38
Joined: 10 Sep 2015, 01:47
Has thanked: 3 times
Been thanked: 12 times

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

Unread postby 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.
garyo
 
Posts: 38
Joined: 10 Sep 2015, 01:47
Has thanked: 3 times
Been thanked: 12 times


Return to Bug Reports 6.x

Who is online

Users browsing this forum: No registered users and 2 guests

cron