Migrate from strapi 4 to 5

Questions and Answers
1

Hi everyone,
I’d like to ask if anyone has successfully migrated from Strapi v4 to v5 using PostgreSQL.

In my case, the process hangs at ⠙ Loading Strapi and I get the following error:

MigrationError: Migration 5.0.0-02-created-document-id (up) failed: 
update "files" set "document_id" = $1 
where "id" in (select "id" from (select "id" from "files" where "document_id" is null limit $2) as "sub_query") 
- read ETIMEDOUT

I’m using PostgreSQL. My questions are:

  • Has anyone else faced the same issue?
  • Were your tables automatically updated with the documentId column during migration?
  • What exact steps did you follow to migrate successfully?

Any guidance, workarounds, or shared experiences would be really appreciated.

Thanks in advance! :pray:

2

How many records do you have in the files table?