**Client Name:**
Spankys Card Shop
**Client Contact Information:**
Scott Lipp
kscollectables@gmail.com
**Client Database URL:**
https://spankyscardshop-admin.crystalcommerce.com
**Describe reported issue:**
The table in their database is locked when they try to delete a product or category. This results in either an error message (when deleting a category), or the product just not going anywhere.
**Steps to Reproduce:**
1. Go to https://spankyscardshop-admin.crystalcommerce.com/categories/1623/edit
2. Delete the category
3. Check the notifications until the error message shows up:
Category Delete me failed to delete: Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE products SET on_ebay = (SELECT count(*) > 0 FROM ebay_auctions WHERE product_id = 135473 AND auction_status = 'On eBay') WHERE id = 135473
