NiFi Registry - migrate from H2 to MariaDB

[John Wise <jw...@momentumengineering.io>]

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

Re: NiFi Registry - migrate from H2 to MariaDB

[Bryan Bende <bb...@gmail.com>]

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 <jw...@momentumengineering.io> 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