Multiple primary key defined -> issue with invisible_primary_key

Feedback and Requests
1

Hi everyone,

A feedback for people installing a fresh metabase.

If you encounter such errors from a clean install on a 8.0+ MySQL :

  • Migration failed
  • Multiple primary key defined
  • liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException
  • Metabase Initialization FAILED

It is highly possible that your MySQL server runs with the option sql_generate_invisible_primary_key set to 1 (true)

You need to turn off this feature.

Azure MySQL has it on by default. If you want to deactivate it Go to your Flexible MySQL admin -> parameters -> click on "all")

If you cannot deactivate it, well, change database :slight_smile:

(thanks to the metabase team for your great product)

about the option : https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_sql_generate_invisible_primary_key