H2 to mysql fails

I tried to do the migration and get Command failed with exception: Data truncation: Data too long for column ‘object’ at row 1

with Transfering 560 instances of Revision…BatchUpdateException:

Also I can’t the local db files to start with docker anymore on the system but it does load with just running java with the jre file.

Similar issues has come up over time. If you search this forum for “H2 MySQL” you will see them.

For reference on what kind of information is needed to reproduce the problem I’d like to point to this thread:

Please provide:

  • Version of MySQL you are using for this
  • Metabase version
  • Exact Setup of environment and the exact command line you use to run the migration. (The thread above has a relatively good example of this)
  • Your OS