• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • MySQLSyntaxErrorException: Multiple primary key defined

    I’ve got an installation of OpenSpecimen 4.1.
    When starting the Openspecimen webapp from within Tomcat8 I get the following error in the tomcat log.

    Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set db/2.0/audit-mysql.xml::1429178687139-50::slakhani:
    Reason: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Multiple primary key defined

    Any know what might be causing this and how I might fix this?

    Many thanks,

    Len

    Hi Len,

    It seems like the DB is in an inconsistent state. Can you please delete existing DB, create new DB with same name and then restart the server?