Hello, What version of NiFi Registry are you trying to use with MariaDB?
There is a known issue in 1.16.0 that is addressed in 1.16.1: https://issues.apache.org/jira/browse/NIFI-9950 Thanks, Bryan On Wed, May 11, 2022 at 2:44 PM John Wise <[email protected]> wrote: > > We'd like to move from the built-in H2 database to MariaDB, but the > migration process doesn't appear to work when I specify the migration path > & URL. The Flyway scripts fail on the V2 sql script because it's claiming > that MariaDB only supports 768 char columns, rather than the 1000 char > columns in the script. I can manually create the tables from the scripts, > but then Flyway gets stuck in a migration loop on the next restart. > > We're using Git as the backend storage, and can recreate the H2 database > from it at-will. If I change to MariaDB and try that, it gets stuck on the > Flyway errors again. > > The documentation on the site doesn't really go into a whole lot of detail > on how to accomplish either method. Is there a better way to accomplish > this? > > Thanks! > -John > > John Wise > Principal Software Engineer > Momentum Engineering
