I am using the following sqldao in conf:

sqldao {
  # Slick database driver, full classpath
  slick-driver = scala.slick.driver.PostgresDriver

  # JDBC driver, full classpath
  jdbc-driver = org.postgresql.Driver

  jdbc {
    url = "jdbc:postgresql://xxxxx"
    user = "xxx"
    password = "xxxx"
  }

  dbcp {
    maxactive = 20
    maxidle = 10
    initialsize = 10
  }
}
flyway.locations="db/postgresql/migration"

Maybe dropping the database and re-creating it would fix it.

I created a dedicated db for spark-jobserver and it worked fine, thanks noorul.

Getting next issue which seems to be #486

Migration V0_7_0__init_tables.sql failed

SQL State : 42601
Error Code : 0
Message : ERROR: syntax error at or near "AUTO_INCREMENT"
Position: 55
Location : db/h2/migration/V0_7_0__init_tables.sql (/file:/app/spark-job-server.jar!/db/h2/migration/V0_7_0__init_tables.sql)

Since you are using postgresql, you should not see this getting executed.

This flyway.locations="db/postgresql/migration" should be at the root level, not inside jobserver namespace

I moved flyway.locations outside jobserver scope but didn't change anything :(

EDIT: worked fine @noorul !
while reading code I noticed that I was setting flyway.locations in spark scope and not root level :) Thanks! We should specify that in README, also shouldn't we open a GH issue tagged as "improvement" for having flyway working with already existing database (first issue that I was getting in this topic). We can close the ticket! Thanks!

cdde1ca

Closing