Client timeout during DB migration

[Llyth]

Hi,

Just a heads up we are encountering this error when we ran an upgrade from version 9.1.2 to 9.4.2 :

│ [cache-server] ERROR Database migration failed @smithy/node-http-handler - the request socket timed out after 3000 ms of inactivity (configured by client requestHandler).

We fixed it by running the migration manually in sequence but think this is related to the amount of migrations to do and the low timeout of 3s.

It worked in preproduction but not on production although the db (postgres) was on the same node as the server container.

Probable causes of time taken:
Time to drop the different tables, migration being done in a single transaction etc.

Best regards and thanks for the project !