ACSD-56226: READ queries return outdated data when the synchronous_replication flag is enabled

Categories

Performance, Other

Components

magento/module-catalog-permissions, magento/module-resource-connections

Origin

adobe-commerce-support

Since QPT

1.1.69

Issue

READ queries return outdated data when the synchronous_replication flag is enabled. This causes the slave connection to be disabled, leading to database overload.

Steps to reproduce

1. Set MYSQL_USE_SLAVE_CONNECTION to true in the environment variables on Adobe Commerce on cloud infrastructure. 1. Add the following configuration to .magento.env.yaml to set synchronous_replication to false: DATABASE_CONFIGURATION: _merge: true slave_connection: default: synchronous_replication: false 1. Redeploy and perform frontend actions such as login, add to cart, or place an order.

Adobe's page lists 2.4.6 - 2.4.6-p11 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.7.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-56226. On Cloud, add ACSD-56226 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-56226/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-56226
• JSON API: /api/v1/patches/ACSD-56226