magento / magento/data-migration-tool

Integrity constraint violation: 1062 Duplicate entry '11-general' for key

Open
#928 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PHP
Stars
339
Forks
195
PR merge metrics
No merged PRs in 30d

Description

Getting error while migration from Magento 1.9.2.1 to Magento 2.4.7-p5

PHP version: 8.3
Magento 1 version: 1.9.2.1
Magento 2 version: 2.4.7-p5
Mariadb: 10.6

Steps performed:

1) Installed Fresh Magento 2.4.7-p5 and then took db backup.
2) Installed data migration tool, 2.4.7
3) Then made changes in config.xml file like database details, crypt key etc.
4) Started data migration process with settings migrations which is worked fine.
5) When executed command for data migration, getting this error

Image

@victor-v-rad Please help me to fix this issue as soon as possible

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the migration tool's config.xml and the command used for the data migration, then reproduce the reported duplicate-entry error for the `11-general` key using the listed Magento, PHP, and MariaDB versions. Done means determining why the migration reaches this integrity violation and making the migration complete without it.

Written by the indexing model from the issue text.

Assessment

Tech stack
mariadb, php
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.