Found non-empty schema without metadata table error while migrating

On 02/05/2018 10:52 PM, Abhra Kar wrote:

Hi,

Getting below error—

exec] Flyway (Command-line Tool) v.1.1

[exec]

[exec] Metadata table created: schema_version

[exec] Schema initialized with version: 0

[exec] Flyway (Command-line Tool) v.1.1

[exec]

[exec] ValidationException: Found non-empty schema without metadata
table! Use init() first to initialise the metadata table.

Did you do the above?

The below seems to be a question for the Flyway folks. They don't seem
to have a mailing list, they do point at a SO page:

https://stackoverflow.com/questions/tagged/flyway

It stuck when going to execute below configuration in ant build.xml for
migrate db(populate tables into schema abc)—

<exec executable="./${flyway_sh}" dir="flyway-commandline-1.1">

<arg value="-driver=${flyway_driver}" />

<arg value="-url=${jdbc_db_url}" />

<arg value="-user=${xxxx.username}" />

<arg value="-password=${xxxx.password}" />

<!-- <arg value="-Dflyway.baselineOnMigrate='true'" />-->

<arg value="init" />

<arg value="-Dflyway.initialVersion=xxxxxx” />

<arg value="-Dflyway.initialDescription='Base version'" />

</exec>

<exec executable="./${flyway_sh}" dir="flyway-commandline-1.1"
failonerror="true">

<arg value="-driver=${flyway_driver}" />

<arg value="-url=${jdbc_db_url}" />

<arg value="-user=${xxxx.username}" />

<arg value="-password=${xxxx.password}" />

<arg value="-Dflyway.schemas=‘abc'" />

<arg value="migrate" />

</exec>

abc schema is created properly registered with abc user.

<arg value="-Dflyway.baselineOnMigrate='true'" /> didn’t solve the problem

What need to be change here.

Thanks

--
Adrian Klaver
adrian.klaver@aklaver.com