MySQL problems with 6.7.x

amoxley's Avatar

amoxley

24 Aug, 2010 06:15 PM

Since upgrading to 6.7.1 we've noticed some performance issues that look to be database related.

We're using MySQL with replication so binary logging is turned on. Since the upgrade the amount of db logging has increased something like 10-fold.

Tomcat logs show a possibly related error, "java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction", that appears hundreds of times a day.

Any ideas?

  1. 1 Posted by Joel on 24 Aug, 2010 06:21 PM

    Joel's Avatar

    Hi,

    Could you attach your entire cascade.log file to this ticket? Also, what version did you upgrade from, and has this affected performance on the application or the database server? Please let me know.

    Thanks!

  2. 2 Posted by amoxley on 24 Aug, 2010 07:24 PM

    amoxley's Avatar

    I upgraded from 6.4.4 to 6.7.1. The application performance is noticeably slower. The db server doesn't appear to be affected except for the increased DB logging.

    I have attached the log.

  3. 3 Posted by Joel on 24 Aug, 2010 07:35 PM

    Joel's Avatar

    Hi,

    I believe you are running into a known bug within Cascade Server regarding the Quartz scheduling system. We are releasing a patch within the next few days that will hopefully correct this issue. Please monitor our downloads page, the News section of this site, as well as your email for information regarding our releases.

    Thanks!

  4. Support Staff 4 Posted by Tim on 13 Sep, 2010 03:41 PM

    Tim's Avatar

    Alan,

    I'm going to close out this ticket in light of your new one here. We'll be investigating the issue and commenting on that ticket as soon as we have more info.

    Thanks

  5. Tim closed this discussion on 13 Sep, 2010 03:41 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac