Re: 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(dot)klaver(at)aklaver(dot)com