All of a sudden, I started seeing random timeouts and occasional total hangups on a Magento deployment I’m running. The MySQL server runs on the same machine as the web host, so there shouldn’t be any connectivity issues. This was… Continue Reading
More Magento fun. SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction popped up all of sudden. The error context indicated something got jammed up during the reindexing process, and Catalog URL Rewrites was failing… Continue Reading
After a recent snapshot restore, I found myself having trouble with the Magento indexer. It appeared to be stuck, giving the error message “Catalog URL Rewrites Index process is working now. Please try run this process later.” In this case,… Continue Reading
I was working on a site using the Magento platform, and had the temporary staging site located at a subdomain of the main site. When the time came to move it to production, I: Took a snapshot of the EC2… Continue Reading