wood burning stoves 2.0*
The moose likes JForum and the fly likes new user registration locks up forum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "new user registration locks up forum" Watch "new user registration locks up forum" New topic
Author

new user registration locks up forum

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

This has been bugging me for a while and I can't figure the solution. When a new user registers the whole forum locks up until I restart tomcat. I am sure this must be a MySQL issue. Any body else seen this?

Cheers

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
This is the first time ever. Which JForum and mysql version it is?

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I updated JForum to 2.1.7

MySQL is 3.23.58

It is still doing this... I am lost here I hoped the upgrade would fix it

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
MySQL is 3.23.58


That's a very old version of MySQL and even though there are some 323 version files in the distro, I doubt anyone has tested against that.

Some things to try:

Downgrade your MySQL JDBC driver in the lib directory. There may be issues using the new driver with an old DB.

In the /WEB-INF/config/database/mysql directory, rename the mysql.sql file to something and replace it with the mysql_323.sql file.

In the mysql.properties (same directory) and in your jforum_custom.conf file, make sure that the database.support.subqueries property is false.

I'm almost afraid to ask what what version of Java VM and app server you are running on.... the distro probably has at least some Java 1.4 dependencies, and there may be some Java 1.5 specific calls as well.




[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
jdk1.5.0_04 and tomcat 1.5

I am not a MySQL person and the server isn't mine so I just left things as is when I installed JForum. I wish I was running PostgreSQL...

I will try your ideas and report back. Thanks

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
It seems to run better with those changes but it did lock up again last week. I was on vacation so not sure which day or why.

Tony
[originally posted on jforum.net by kiwi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Only thing more I can think of is to make sure that there is a autoReconnect option on your JDBC url, e.g., autoReconnect=true. I seem to remember that older MySQL DB's needed this.

Then again, it could just be that the network imps sensed a lack of support aura and descended upon your server. Once the support aura was returned, they got chased off to another unprotected site.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Yes I have the autoconnect=true in my mysql.properties

The forum is very slow - partly because I haven't been animating it and partly because of the lockup issue. So it is hard to tell if I have got this sorted or not.

cheers

Tony
[originally posted on jforum.net by kiwi]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: new user registration locks up forum
 
Similar Threads
NX: Help, how to notify all Data objects in unlock()?
WeakHashmap or TimerTask for stale sessions cleanup ?
eclipse install on RedHat 9
Static HashSet problem
locking - why do we have to identify the client?