How can we help you today? How can we help you today?

when flyway desktop hangs, how can it be debugged (or even stopped)?

Frequently, flyway just hangs when you ask it to migrate some simiple scripts against a DB noone is connected to.
The UI just shows "migrating database" and the spinning wheel of death.
There is no progress update, there is no button to "abort/cancel", and there is nothing in the flyway log files other than listing the existing migration history and a few lines of startup info.  Nothing about execution or errors.

How do we figure out the issue when this happens?  If we hand run the sql scripts against a copy of the database the sql works fine.

Flyway Desktop 7.2.4.0

windows os.
RDS Postgres DB.
nutmix2
0

Comments

2 comments

Sort by
  • Peter_Laws
    Hi nutmix2,

    That's unexpected, I'd typically expect an exception from the db to be passed over by the JDBC driver and surfaced in Flyway Desktop. Regarding the logs, do you have verbose logging on please?

    We can happily create a support issue for you to share more detailed log if they are available rather than publicly, just let us know.

    Are you defining any additional configuration on your connection string such as timeouts?


    Since we're talking about AWS there's also the possibility of if your deployment is being run for an approached address in your security group, but assuming you can perform a test connection against the db it's unlikely to be that, and I would expect a connection failure to fail fast, not hang.
    Peter_Laws
    0
  • Peter_Laws
    In addition to this, the latest release of flyway has more feedback on which migration it's presently deploying so you can track progress more ably.
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.