Skip to Main Content
CrystalCommerce 2.0 - BUGS (PUBLIC)
Status Shipped
Created by Guest
Created on Jun 24, 2019

[NON-FIREFIGHTING] *** bruteforcemtg *** Error prevents eBay listings from posting

**Client Name:**
Bruteforcemtg

**Client Contact Information:**
Sean Johnson
cs@bruteforcemtg.com

**Client Database URL:**
https://bruteforcemtg-admin.crystalcommerce.com

**Describe reported issue:**
Bruteforcemtg is running into an error in their notifications when they attempt to list a card to eBay. For updating existing listings, the error says:

eBay update failed: Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE products SET on_ebay = (SELECT count(*) > 0 FROM ebay_auctions WHERE product_id = 301350 AND auction_status = 'On eBay') WHERE id = 301350

And for creating new listings:

eBay Auction: '[1x] Sheltered Thicket [x1] Amonkhet Near Mint, English -BFG- MTG Magic ' could not be posted: Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE products SET on_ebay = (SELECT count(*) > 0 FROM ebay_auctions WHERE product_id = 284493 AND auction_status = 'On eBay') WHERE id = 284493

**Steps to Reproduce:**


**Provide a screenshot: **


**Describe desired results:**


** Additional Information:**

Looks like maybe there is a mysql lock in their database that needs to be cleared for these listings to post and update properly?
  • Attach files