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

Cannot reply private conversations

Discussion in 'Troubleshooting and Problems' started by Andy Huang, May 3, 2011.

  1. Andy Huang

    Andy Huang Well-Known Member

    This seems to be happening only for replying to private conversations for us, so I'm opening a new thread instead of bringing up this one.

    Anyways, I am noticing a lot of logs like this in my error log:

    Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction

    Here's my processes:

    Here's INNODB status:

    Any suggestions as to how to resolve this issue?
  2. Mike

    Mike XenForo Developer Staff Member

    Is the lock wait error from the conversation reply? (Based on the URL that triggered it.)

    Your InnoDB status doesn't indicate that there are any transactions running, so it shouldn't be triggered while you were running the status at least. If you can reproduce it, can you get the InnoDB status/process list then?

    The error that is triggered is related to this config value: http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout If you're using the default (50), that'd mean that some other transaction is lasting over 50 seconds. The only thing I could think of relates to sending emails after a conversation, as I believe they happen within the transaction (I should try to change that). Is it slow to reply to these conversations?
  3. Andy Huang

    Andy Huang Well-Known Member

    Ah, that must be it.
    I had gmail smtp configured to use TLS on SSL port so it was throwing a fit timing out.
    I've fixed that, but haven't tried private conversation yet.
  4. Andy Huang

    Andy Huang Well-Known Member

    Private conversation is confirmed working now... and I'm not getting the errors in my error log anymore. Yay!

Share This Page