I have Openfire working reliably for over 2 years, then without notice, sudden failure. Nothing changed on the server, and the server has not been rebooted for 3 years.
This is my openfire-properties file.
#HSQL Database Engine
#Mon Jan 16 08:10:50 HKT 2012
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=false
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
hsqldb.log_size=200
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0
Using ht eembedded database, which I can see, loads up into memory, my guess is that this loads into memory, and now out of memory, refuses to allow any more, and as a resault stops working, users who are logged in can continue, but no new logins accepted.
During this time, no purges have been done, so I most likly need to clean up the message logs.
Any tips for this? Should I copy the openfire.script file and remove the " INSERT INTO OFMESSAGEARCHIVE VALUES( " lines so I can get it running again?
or is there a memory switch that will allow it to run and then I can use the in admin tools to clean up the archives?
Also, any document on moving from the embeded to mysql?
Regards
Geoff