Shared on Mage Dispatch · 04 Sep 2024
In a recent Magento upgrade project for one of our merchants, I encountered a problem with the production database during the setup:upgrade process.
This guide details how to reset a message queue that becomes stuck due to issues like crashes or deadlocks. It provides necessary SQL queries and tips for safely backing up your database before performing a potentially destructive operation. Understanding the causes of stuck queues and the proper steps to reset them is essential for maintaining performance.
I got the message on a regular weekday: “We lost almost the entire product catalog, around 10,000 products gone, only 100 left.” The client had no idea what happened. They suspected something went wrong after running a product import, but the CSV file in question looked harmless, it had just a few items. It shouldn’t have caused any damage. Yet, the damage was done.
It’s been far too long since I’ve shared an update on a passion project that I’ve been working on throughout the year, bit by bit. A project that makes my developer heart beat faster
Mage Dispatch is a community-run archive and bi-weekly newsletter for the Magento, Adobe Commerce and Mage-OS ecosystem. Modules, articles, security advisories and tools, hand-picked by developers and shared so good work does not disappear into the void.
Browse the latest links → Explore by topic → Submit a link → About us →
