MySQL problems with 6.7.x

amoxley's Avatar


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


    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.


  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


    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.


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

    Tim's Avatar


    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.


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

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

Keyboard shortcuts


? 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


26 Aug, 2016 01:19 PM
25 Aug, 2016 03:02 PM
25 Aug, 2016 12:50 PM
24 Aug, 2016 08:43 PM
24 Aug, 2016 07:20 PM
21 Aug, 2016 01:20 PM