CaliforniaCCW wrote:It seems to happen about once a day. The forum just freezes up. It gets 51 DB connections and then it stops working. Usually I can fix that by shutting down Tomcat, and then shutting down Postgres, and then restarting them, but now it isn't coming back up at all. The site is getting about 50,000 hits per day.
Any ideas on this?
It's great software, but it doesn't seem very stable.
CaliforniaCCW wrote:This is the latest JForum, 2.1.6. This is what the process table looks like when it hangs:
Only particular threads "hang" when this happens. It's happening right now in fact. Somehow I can't read a particular thread until this UPDATE waiting thing clears on the thread, but it never does until I restart Tomcat. Any ideas?
CaliforniaCCW wrote:It's seemingly random. Some threads become "locked", such that if you click on them, they never load. I look in the processes and there are these "update waiting" processes. I have to kill Tomcat to get it going again.
This is totally repeatable. It happens once a day.
Rafael Steil wrote:Well,
this is kinda confusing. If someone could help on this, it will be great.
CaliforniaCCW, JForum is very stable, but obviously not bug free. We'll do our best to fix all reported problems quickly, and we count with your help - and everybode else!
Let us know if you find anything new. I'll check the database code and error handling, to make sure nothing is being left behind.
I am evaluating JForum to integrate it on a hight traffic website.
Looking at the code of the DAOs, I have noticed a disturbing thing : the jdbc operations are not wrapped in try/catch/finally blocks
This could leads to very bad things such as database cursor leaks.
Below a page explaining in detail how should be wrapped JDBC operations : http://www.javalobby.org/java/forums/t18930.html
Hope it helps
alexvictoor wrote:Rafael, if I am not wrong CaliforniaCCW is using jforum2.16 . Perhaps the new DAO code from the CVS would solve his problem...
Rafael Steil wrote:CaliforniaCCW, the current cvs code is the one which will go as production. There isn't any planed changes to the database code.
I know that it sounds ridiculous to ask you to put a development package in your very busy website,
so, if you want, I can be online on a specific time of the day and give you any assistance needed, for example.