Deleting campaign ERROR

Jesse James

Member
Hey,

I tried to delete a campaign (a huge one HTML campaign sent to more then half million emails)
I got this error:

Error 500: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

can you please fix it
Thank you very much
 

twisted1919

Administrator
Staff member
There's nothing to fix, it's your server that can't handle the deletion of so many records at once.
Even if you run the delete from command line, it'll take a long time till 500k records and their related records are deleted.
The obvious suggestion is, either try from command line, or try adding more RAM to that server.

Thanks.
 

twisted1919

Administrator
Staff member
Following up on this, i thought that i can help this case a bit more.
So, now when a campaign or list is deleted, it is marked as deleted only and passed to the daily cron job for actual deletion.
In this way, when you delete a campaign/list from the web interface, it will be instantly then the cron job at midnight will do the actual hard work of deleting the records.
 
Top