rordallas 4 Posted February 2 Report Share Posted February 2 Version 8.0Situation - sending monthly campaign of about 1000 emails.Problem - often, a few (usually less than 10) emails are 'hung' in limbo, the campaign does not finish. The x2_list_items.sent = 0 and x2_list_items.sending = 1 for these records.Typical Error.log entry - 2021/02/02 00:01:59 [error] [exception.CDbException] CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction - UPDATE x2_list_items AS i LEFT JOIN x2_contacts AS c ON c.id=i.contactId SET i.sent=:sent,i.uniqueId=:uniqueId,i.unsubscribed=:unsubscribed,i.suppressed=:suppressed,sending=0,emailAddress=:setEmail WHERE i.id=:id OR (i.listId=:listId AND (i.emailAddress=:emailAddress OR c.email=:email)) in /home/rebeyigi/public_html/X2CRM/x2engine/framework/db/CDbCommand.php:358 Manual remedy - Change the x2_list_items.sending to 0 for the 'hung' records, then in the CRM interface go into the unfinished campaign and click resume. The result is the campaign finishes normally. Obviously this remedy is somewhat painful and beyond capabilities of a typical user.Any help/guidance would be appreciated.Full stack trace attached.stack trace.txt Quote Link to post Share on other sites
jack 7 Posted February 3 Report Share Posted February 3 Hi rordallas,to rectify this for now you can manually compete the campaign. We look more into this.-Jack Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.