I've noticed some odd behaviour with JForum's HSQLDB log file. This is with version 2.1.4, running on Tomcat. I realize that the conditions that this bug is happening under are a bit unusual, but I'm hoping that if it is a bug, it is fixable :?
I'm running JForum on a development machine, which has Tomcat being restarted frequently, and over time the HSQLDB log file ballons to an alarming size in a short period of time (> 4 megabytes in one case). When the log file approaches this size, it seems that JForum will not start up anymore because it's taking too long to parse this file.
The problem seems to be, as time progresses, the INSERT INTO JFORUM_SESSIONS and DELETE FROM JFORUM_SESSIONS statements start getting repeated for single log ins. By this I mean, the same exact line will be repeated in the log multiple times (in some cases, this seems to be hundreds of repetitions, if not more).
This behaviour can be repeated easily by doing the following:
On a machine running JForum + HSQLDB log in as any user using Firefox, then log in as the same user under Internet Explorer (this simulates having the user logging in multiple times using different computers, which is what is happening on our test machine). Then, shut down and restart Tomcat, and repeat the above. Do this a few times while watching the contents of the jforum.log file under the hsqldb folder, and you will hopefully notice what I'm talking about.
Thank you for your time,
Colin [originally posted on jforum.net by Colin Walsh]