This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new user registration locks up forum

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic