hsqldb properties -
i using hsqldb having following settings in properties file (not set me)
hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=true hsqldb.cache_scale=14 version=1.8.0 hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 modified=yes hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0
the db started giving errors in logs java.sql.sqlexception: s1000 general error java.util. nosuchelementexception
some searching on google pointed me because limit of .data file has been reached. size of .data file around 0.7gb. if increase cache_file_size , above error disappear
hsqldb.default_table_type=memory hsqldb.cache_file_scale=1
if hsqldb.cache_file_scale=3.
mean database in memory , require 3gb. if memory issue how can reduced ?
the current setting allows 2gb in data file.
i suggest perform shutdown script clear problems. if have further problems, contact hsqldb project.
Comments
Post a Comment