Hey,

I am currently having a big issue with rerunning a migration with 1000000 nodes.
I did the import once, then after a while I realized that I have missed one field and now I want to rerun it. The issue I am now having is that before the migration is actually starting, it does a SELECT on the mapping table.
This SELECT takes ages and the migration is just not starting again. Any idea how to do that in a better way?

Greetings

SG

Comments

sgurlt created an issue. See original summary.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan as a volunteer and at Virtuoso Performance commented
Status: Active » Postponed (maintainer needs more info)

#2843595: Add indexes to migrate_map_* tables, just committed to 8.3.x and 8.4.x last week, should make this better - can you try applying that patch to your 8.2.x and see if it helps?

sgurlt’s picture

sgurlt CreditAttribution: sgurlt as a volunteer and at Bright Solutions GmbH commented

I will give try to apply the patch, thanks for the feedback :-)

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan as a volunteer and at Virtuoso Performance commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

No further information, but best guess is that #2843595: Add indexes to migrate_map_* tables has addressed this.