How to repair flyway migration when flyway_schema_history shows migration successful

I am new to postgresql and flyway migration. I don't quite understand what I am supposed to do when a migration script fails using Flyway flyway_schema_history table shows the migration was successful. In this instance, I get the following

>org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException:   Migration V__xxx.sql failed  -------------------------------------------------------------------  >SQL State  : 42809  >Error Code : 0  >Message    : ERROR: "zzzzzz" is not a materialized view  >  

Hint: Use DROP TABLE to remove a table.

Can a table and a materialized view have a common a common name (in Postgres)?

Secondly, the flyway_schema_history table shows the migration was successful under first schema schema_a, but failed under schema_b. Any hints to resolve this?

https://stackoverflow.com/questions/66080443/how-to-repair-flyway-migration-when-flyway-schema-history-shows-migration-succes February 07, 2021 at 02:29AM