[OF-268] improve reliability of embedded database Created: 12/Jul/07  Updated: 13/Jun/10  Resolved: 13/Jun/10

Status: Resolved
Project: Openfire
Components: Database
Affects versions: None
Fix versions: 3.7.0 beta

Type: Improvement Priority: Minor
Reporter: LG Assignee: Gaston Dombiak
Resolution: Fixed Votes: 3
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified


 Description   

Set hsqldb.log_size to 20 MB (default is 200 MB) and this is very very big. A checkpoint will take ages to complete - see http://www.hsqldb.org/doc/guide/ch04.html

Set SET WRITE DELAY to 100 ms to get a 99.9999% according to http://www.hsqldb.org/doc/guide/ch09.html#set_write_delay-section

Make sure that server-properties.jsp returns an error if updating of the properties fail, current code is:
82 JiveGlobals.setProperty(propName, propValue);
83 response.sendRedirect("server-properties.jsp?success=true");
84 return;

Verify that "openfired stop" on linux and "stop Openfire" on Windows stop Openfire in a clean way, http://www.igniterealtime.org/forum/thread.jspa?threadID=27303&tstart=0 reports that this is not the case while it works for me on linux.

 Comments   
Comment by LG [ 13/Jun/10 ]

"@Make sure that server-properties.jsp returns an error if updating of the properties fail" - the current code uses some logic to check the values before it tries to insert them, so this should be no issue.
@"Verify that "openfired stop" ... stop Openfire in a clean way" - the thread does no longer exist and there are no new threads with such problems.
==> I'd like to close it for 3.7.0 with the HSQLDB fixes.

Comment by LG [ 13/Jun/10 ]

Feel free to create new issues for "server-properties.jsp" or "stop" if these are still issues.

Generated at Fri Apr 26 04:52:53 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100251-rev:2d0d695520e7095763476433152508933e579798.