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

Cannot reply private conversations

Andy Huang

Well-known member
#1
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
library/Zend/Db/Statement/Mysqli.php:214


Here's my processes:
http://pastebin.com/PPhDrnfN

Here's INNODB status:
http://pastebin.com/SgEyw1Yq

Any suggestions as to how to resolve this issue?
 

Mike

XenForo developer
Staff member
#2
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?
 

Andy Huang

Well-known member
#3
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.