when flyway desktop hangs, how can it be debugged (or even stopped)?
nutmix2
Posts: 6 New member
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.
RDS Postgres DB.
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.
Tagged:
Answers
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.