A bit unrelated but I seem to have recreated the problem in the nova-multi-cell job in this patch for the cross-cell resize tests:
https://review.opendev.org/#/c/656656/
I'm migrating from a source host with a hostname that is a substring of the target host hostname, and mysql seems to not be handling that and raises the unique constraint error.
I'm not an expert on this, but reading http://www.mysqltutorial.org/mysql-unique/ and looking at https://review.opendev.org/#/c/404293/ it seems that primary key in the neutron table should have been a unique index rather than a primary key.
A bit unrelated but I seem to have recreated the problem in the nova-multi-cell job in this patch for the cross-cell resize tests:
https:/ /review. opendev. org/#/c/ 656656/
I'm migrating from a source host with a hostname that is a substring of the target host hostname, and mysql seems to not be handling that and raises the unique constraint error.
I'm not an expert on this, but reading http:// www.mysqltutori al.org/ mysql-unique/ and looking at https:/ /review. opendev. org/#/c/ 404293/ it seems that primary key in the neutron table should have been a unique index rather than a primary key.