{"data":{"id":"MDVA-34948","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue with long-running queries, like GET_LOCK.","categories":["Performance"],"components":["magento/framework","magento/module-message-queue"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-1/mdva-34948-slow-site-and-operations","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-1/mdva-34948-slow-site-and-operations.md","blobSha":"bbed685dea773896fbeaf20834581853866af673","description":"The website gets slow, which hampers operations.","stepsToReproduce":"1. Run show processlist in MySQL. 1. Check if there are multiple queries like: SELECT GET_LOCK(SYSTEM_CONFIG', '10');","introducedInQpt":"1.1.1","createdFor":["2.4.0-p1"],"documentedRange":"2.3.6-2.3.6-p1, 2.4.0-2.4.0-p1","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.3.6 <=2.3.6-p1 || >=2.4.0 <=2.4.0-p1","path":"patches/os/MDVA-34948_2.4.0-p1.patch","blobSha":"b49407488bc581864e783926a66aa4590d4e97b0","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-34948_2.4.0-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-message-queue/Console/StartConsumerCommand.php","change":"modified","package":"magento/module-message-queue"},{"path":"vendor/magento/framework/Cache/LockGuardedCacheLoader.php","change":"modified","package":"magento/framework"},{"path":"vendor/magento/framework/Lock/Backend/Cache.php","change":"modified","package":"magento/framework"}],"packages":["magento/module-message-queue","magento/framework"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.0-p1","2.4.0","2.3.6-p1","2.3.6"],"magento-commerce":["2.4.0-p1","2.4.0","2.3.6-p1","2.3.6"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.0-p1","2.4.0","2.3.6-p1","2.3.6"],"magento-commerce":["2.4.0-p1","2.4.0","2.3.6-p1","2.3.6"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-34948 details"}