Database migration to AlloyDB: initialization failed during nonrecoverable step (d)

[bubiche]

I'm trying to migrate a PostgreSQL database to AlloyDB using GCP Database Migration Service. All the setup/test steps on Google Cloud Console works but the job failed with "initialization failed during nonrecoverable step (d), please try the setup again".

The document suggests checking the destination's log (it's for CloudSQL but I think it should be similar for AlloyDB right?) so I did it and here's what I found:
`DETAIL: destination connection reported: ERROR: duplicate key value violates unique constraint "pk_us_lex" DETAIL: Key (id)=(1) already exists. CONTEXT: COPY us_lex, line 1`

The table in the source database doesn't have any duplicated ID so I'm not sure why this happen. One clue I have is that table was created/managed by the extension `postgis`. Is this some specific error with postgis + AlloyDB? Is there any workaround for this?

[jeerahalli]

Can you please create enough disk space upfront and retry migration. Thanks.

[Maël_Durand]

Hello, we ran into the same issue. Can you clarify what disk space you are refering to when asking to "create enough disk space upfront" ? Because it seems we can't choose disk space for Alloy databases (the storage seems to be fully autoscaling).

Thanks in advance

Durand Maël

[jeerahalli]

Hello,

Thank you for contacting the Google Cloud Community.

I have gone through your reported issue, however it seems like this is an issue observed specifically at your end. It would need more specific debugging and analysis. To ensure a faster resolution and dedicated support for your issue, I kindly request you to file a support ticket by clicking here[1]. Our support team will prioritize your request and provide you with the assistance you need.

For individual support issues, it is best to utilize the support ticketing system. We appreciate your cooperation!

[1]: https://cloud.google.com/support/docs/manage-cases#creating_cases