Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Tool should indicate in which db constraints fail #355

Closed
fwolfst opened this issue Aug 29, 2017 · 1 comment
Closed

Tool should indicate in which db constraints fail #355

fwolfst opened this issue Aug 29, 2017 · 1 comment
Labels
acknowledged bug

Comments

@fwolfst
Copy link

fwolfst commented Aug 29, 2017

E.g. I got

[2017-08-29 09:29:39][INFO][mode: data][stage: integrity check][step: Data Integrity Step]: started
^[[0;31m[2017-08-29 09:29:45][ERROR]: Foreign key (FK_CAT_CMP_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID) constraint fails. Orphan records id: 209,224,428,488,592,939 from `catalog_compare_item`.`product_id` has no referenced records in `catalog_product_entity`^[[0m

It took me quite a while to figure out that the issue was in the source (not destination) database. Either the tool should log which db it is checking individually (~ Integrity check on source database), or output the database name within the log (~ ...9 from **mydb**.catalog_compare_item.product_id ).
@victor-v-rad
Copy link
Collaborator

Thank you @fwolfst for posting it. Internal issue MAGETWO-72093 to fix it.

victor-v-rad added a commit to magento-panda/data-migration-tool that referenced this issue Nov 16, 2017
@victor-v-rad
MAGETWO-72093: [GitHub] Integrity check error clarification magento#355
a33d8e9
@victor-v-rad victor-v-rad mentioned this issue Dec 11, 2017
Merged
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
acknowledged bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@victor-v-rad @fwolfst