QuestionQ10

VerifiedTroubleshoot to identify the root cause of issues with Adobe Commerce

An Adobe Commerce Architect is investigating an issue in which some EAV product attributes are no longer being updated.

The catalog contains 20,000 products, each with 100 attributes. Product updates run through recurring Adobe Commerce imports multiple times per day.

The Architect finds an error in the logs indicating an integrity constraint while attempting to insert a row with ID 2147483647.

What is causing this error?

Explanation

2147483647 is the maximum signed 32-bit integer value, so the EAV value table’s auto-increment key has been exhausted. Adobe Commerce product attribute updates use an INSERT ... ON DUPLICATE KEY UPDATE pattern; repeated imports of a large catalog can consume auto-increment values even when rows are updated through duplicate-key handling. Adobe Commerce documents that product imports support Add/Update and can update product fields other than SKU.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!