1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 What Is Causing Deadlocks

Discussion in 'Troubleshooting and Problems' started by Wesker, Aug 21, 2016.

  1. Wesker

    Wesker Active Member

    Need some help from the xF team here. Basically our site has been having ongoing issues with mySQL being locked up which as a result we have to constantly reset mySQL every 30 minutes. Keeping it short and simple:

    1). There are no errors explaining why this is happening
    2). We have optimized the site twice already
    3). We have implemented caching all around
    4). We have done a variety of other things

    Here is what we're planning to do

    1). Upgrade to 1.5.9
    2). If the upgrade doesn't we will use 3rd party assistance reviewing our databases

    In case the 1.5.9 upgrade doesn't solve the issue, I'm looking for some recommendations on what we should do to try to find what is causing this. I assume one of them will be disable add ons 1 by 1. What other recommendations do you have?
     
  2. Tracy Perry

    Tracy Perry Well-Known Member

  3. Digital Doctor

    Digital Doctor Well-Known Member

    this thread mentions running this query

    Show Engine INNODB status;

    It is certainly a frequent issue that seems fixable.
     
  4. Digital Doctor

    Digital Doctor Well-Known Member

    This comes up alot so there is a Tip sheet on it.
    Of course, as Forum Searching is ineffective, people never find it.

    P: I have seen a "Deadlock found when trying to get a lock" MySQL error in my error logs.
    S: Reload the page to restart whatever process you were attempting. Deadlocks can occur with any transaction or query in an InnoDB MySQL database. They are very difficult to programmatically prevent and shouldn't occur often. If they occur fairly often, it is recommended that you discuss possible solutions with your host. Here is some further reading related to deadlocks:
    http://xenforo.com/community/threads/mysql-deadlock.60778/
    http://xenforo.com/community/threads/deadlock.60097/
    http://xenforo.com/community/thread...to-get-lock-try-restarting-transaction.47820/
    http://xenforo.com/community/threads/vb-3-8-xf-via-cli-importer-discrepancies.27794/#post-327157
     
  5. Tracy Perry

    Tracy Perry Well-Known Member

    Just for edification, there is better choice as outlined in the page I linked to. ;)
    The data is much more easily understood.
    Screen Shot 2016-08-21 at 6.30.22 PM.png
    vs
    Screen Shot 2016-08-21 at 6.30.50 PM.png
     
    Digital Doctor likes this.

Share This Page