Found non-empty schema without metadata table error while migrating

From: Abhra Kar <abhra(dot)kar(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Found non-empty schema without metadata table error while migrating
Date: 2018-02-06 06:52:58
Message-ID: CAFNULEd-KOWBeq4uy_RC+=K2311uBKYunKwTgLF4PjbvYiNUBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2018-02-06 07:19:48 Re: Alter table set logged hanging after writing out all WAL
Previous Message Jeremy Finzel 2018-02-06 06:50:56 Alter table set logged hanging after writing out all WAL