cancel
Showing results for 
Search instead for 
Did you mean: 

Data cache size limit is reached: 10000

Former Member
0 Kudos
855

Hi All,

I am using hsql db to load all products which are coming from datahub and i am struck with this error. Could someone help me how to resolve this error?

Caused by: java.sql.SQLException: Data cache size limit is reached: 10000 at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) at de.hybris.platform.jdbcwrapper.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:313) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:883) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:876) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:639) ... 13 more Caused by: org.hsqldb.HsqlException: Data cache size limit is reached: 10000 at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.persist.Cache.put(Unknown Source) at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source) at org.hsqldb.persist.DataFileCache.get(Unknown Source) at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source) at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source) at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source) at org.hsqldb.index.NodeAVLDisk.child(Unknown Source) at org.hsqldb.index.IndexAVL.insert(Unknown Source) at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source) at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source) at org.hsqldb.TransactionManagerMVCC.addInsertAction(Unknown Source) at org.hsqldb.Session.addInsertAction(Unknown Source) at org.hsqldb.Table.insertSingleRow(Unknown Source) at org.hsqldb.StatementDML.update(Unknown Source) at org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source) at org.hsqldb.StatementDML.getResult(Unknown Source) at org.hsqldb.StatementDMQL.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source)

Thanks, G Gopinath.

former_member620692
Active Contributor
0 Kudos

Please shut down the server, add the following property in hsqldb/mydb.properties, start the server and test it again.

 hsqldb.cache_file_scale=64
former_member620692
Active Contributor
0 Kudos

- did it work for you?

Former Member
0 Kudos

Hi Arvind,

It didn't worked.I tried using your command.

Thanks, G Gopinath.

Accepted Solutions (0)

Answers (0)