Cannot reply private conversations

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?


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: 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
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.

Andy Huang

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