**Client Name:**
CrossRoadGames
**Client Contact Information:**
Dave Brewer
evildirtydave@yahoo.com
**Client Database URL:**
https://crossroadgames-admin.crystalcommerce.com
**Describe reported issue:**
CrossRoadGames has some old products that they want to delete from their inventory, since they don't carry them anymore. Whenever they try to delete a product, nothing happens. If they try to delete a category to get rid of the product, they get an error message in their notifications.
**Steps to Reproduce:**
Deleting a product:
1. Go to https://crossroadgames-admin.crystalcommerce.com/inventory/update
2. Search for the product named Ch'p (002)
3. Click the "delete" button under the product
Result: Nothing happens
Deleting a Category:
1. Go to https://crossroadgames-admin.crystalcommerce.com/categories/2663/edit
2. The category should be named "Delete me". Click the Delete button, then enter your password to verify that you want to delete it.
3. Wait a few minutes, then go to their notifications page: https://crossroadgames-admin.crystalcommerce.com/system_notifications
Result: The category doesn't delete, and the following error shows up in their notifications:
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 = 251793 AND auction_status = 'On eBay') WHERE id = 251793
**Describe desired results:**
For the product or category to be deleted when the "delete" button is clicked and then verified.
