or Create a profile

Home → Installation and System Configuration →

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.

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

  • New Issue

  • Conversation Started

  • The discussion is closed

    No more actions from Cascade CMS or the discussion starter are required.

  • Re-open the discussion

Private Permissions

This discussion is private. Only you and Cascade CMS support staff can see and reply to it.

Public Permissions

This discussion is public. Everyone can see and reply to it.

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

Recent Discussions

26 Oct, 2017 08:45 PM Incorrect path in submenus
31 Jan, 2017 08:08 PM example of php (web services) that reads a page and writes a new one
15 Sep, 2016 04:50 PM Best way to convert title tags to h1 tags
30 Aug, 2016 12:28 PM Query using selected option value from select
26 Aug, 2016 02:40 PM Are we suppose to use the new help/support website?

 

26 Aug, 2016 01:19 PM Links in PDF Output
25 Aug, 2016 03:02 PM Site Import Issues
25 Aug, 2016 12:50 PM Velocity syntax for conditional statement with two or more conditions
24 Aug, 2016 08:43 PM Increment integer on loop
24 Aug, 2016 07:20 PM Multi-select
21 Aug, 2016 01:20 PM Include contents from a rendered page