The MDVA-13203 Adobe Commerce patch fixes the issue where your site is showing a maintenance page and there are CRITICAL: SQLSTATE[23000]: Integrity constraint violation errors in the system.log
. The patch ID is MDVA-13203. This patch is available when the Quality Patches Tool (QPT) 1.0.13 is installed.
The patch is created for Adobe Commerce version: Adobe Commerce on cloud infrastructure 2.2.4.
Compatible with Adobe Commerce versions: Adobe Commerce (all deployment methods) 2.3.0-2.4.1.
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches
package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.
Steps to reproduce:
bin/magento maintenance:status Status: maintenance mode is not active List of exempt IP-addresses: none
system.log
:grep critical -i var/log/system.log |tail [2018-09-04 17:05:18] report.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4613' for key 'PRIMARY', query was: INSERT INTO `search_tmp_5b8ebb4e994da5_88027289` (`entity_id`,`score`) VALUES (?, ?),... (?, ?), (?, ?) [] [] [2018-09-04 17:05:21] report.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4613' for key 'PRIMARY', query was: INSERT INTO `search_tmp_5b8ebb51579943_52333638` (`entity_id`,`score`) VALUES (?, ?),...,(?, ?) [] [] [2018-09-04 17:05:47] report.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1350' for key 'PRIMARY', query was: INSERT INTO `search_tmp_5b8ebb6b7028f4_68065024` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) [] [] [2018-09-04 17:05:47] report.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1350' for key 'PRIMARY', query was: INSERT INTO `search_tmp_5b8ebb6b7885a9_23360993` (`entity_id`,`score`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) [] [] date Tue Sep 4 17:06:11 UTC 2018
Expected results: You should see the site.
Actual results: The maintenance page shows because of database consistency issues.
To apply individual patches, use the following links depending on your deployment method:
To learn more about Quality Patches Tool, refer to:
For info about other patches available in QPT, refer to Patches available in QPT in our developer documentation.