Re: Found non-empty schema without metadata table error whilemigrating

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