Can flyway run a script for more than 20 hours?

jamal1

I was using flyway to run a script in mariadb, flyway was timing out after 4 hours, this script has to run for 25 hours to complete the changes, is there something i need to fix so that flyway does not time out

Peter_Laws

Hi jamal1,

Thanks for asking the question!
Flyway doesn't govern the connection behaviour, but can be used as an interface to pass the behaviour you're looking for.

Please could you try amending your connection string like so and let us know the outcome?

jdbc:mysql://localhost:1433/my-db?socketTimeout=2000

The timeout value is expressed in milliseconds.