Andreas Adamides created NIFI-9948:
--------------------------------------
Summary: Upgrading Nifi Registry from 1.15.3 to 1.16.0 keeps
failing with Flyway migration errors
Key: NIFI-9948
URL: https://issues.apache.org/jira/browse/NIFI-9948
Project: Apache NiFi
Issue Type: Bug
Components: NiFi Registry
Affects Versions: 1.16.0
Reporter: Andreas Adamides
When upgrading from version 1.15.3 to 1.16.0, the upgrade keeps failing.
Looking at the logs the issue seems to be related with Flyway(database is
Postgres 12.8) migration failures and checksum mismatches. The suggestion to
fix this is to run the flyway.repair() commands, but flyway is embedded as Java
code in the Nifi registry code itself.
*Error logs:*
{code:java}
2022-04-21 16:03:48,445 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut
2022-04-21 16:03:48,445 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut Apache NiFi _ _
2022-04-21 16:03:48,445 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut _ __ ___ __ _(_)___| |_ _ __ _ _
2022-04-21 16:03:48,446 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut | '__/ _ \/ _` | / __| __| '__| | | |
2022-04-21 16:03:48,450 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut | | | __/ (_| | \__ \ |_| | | |_| |
2022-04-21 16:03:48,450 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut |_| \___|\__, |_|___/\__|_| \__, |
2022-04-21 16:03:48,450 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut ==========|___/================|___/=
2022-04-21 16:03:48,450 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut v1.16.0
2022-04-21 16:03:48,532 INFO [NiFi logging handler]
org.apache.nifi.registry.StdOut
2022-04-21 16:04:09,064 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr Failed to start web server:
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'accessPolicyResource' defined in file
[/opt/nifi/nifi-registry-1.16.0/work/jetty/nifi-registry-web-api-1.16.0.war/webapp/WEB-INF/classes/org/apache/nifi/registry/web/api/AccessPolicyResource.class]:
Unsatisfied dependency expressed through constructor parameter 0; nested
exception is org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'standardServiceFacade' defined in file
[/opt/nifi/nifi-registry-1.16.0/work/jetty/nifi-registry-web-api-1.16.0.war/webapp/WEB-INF/classes/org/apache/nifi/registry/web/service/StandardServiceFacade.class]:
Unsatisfied dependency expressed through constructor parameter 0; nested
exception is org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'registryService' defined in URL
[jar:file:/opt/nifi/nifi-registry-1.16.0/work/jetty/nifi-registry-web-api-1.16.0.war/webapp/WEB-INF/lib/nifi-registry-framework-1.16.0.jar!/org/apache/nifi/registry/service/RegistryService.class]:
Unsatisfied dependency expressed through constructor parameter 0; nested
exception is org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'databaseMetadataService' defined in URL
[jar:file:/opt/nifi/nifi-registry-1.16.0/work/jetty/nifi-registry-web-api-1.16.0.war/webapp/WEB-INF/lib/nifi-registry-framework-1.16.0.jar!/org/apache/nifi/registry/db/DatabaseMetadataService.class]:
Unsatisfied dependency expressed through constructor parameter 0; nested
exception is org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'flywayInitializer' defined in class path resource
[org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]:
Invocation of init method failed; nested exception is
org.flywaydb.core.api.exception.FlywayValidateException: Validate failed:
Migrations have failed validation
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr Migration checksum mismatch for migration
version 6
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr -> Applied to database : -260833722
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr -> Resolved locally : -1218242517. Either
revert the changes to the migration, or run repair to update the schema history.
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr Migration checksum mismatch for migration
version 8
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr -> Applied to database : -2057645592
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr -> Resolved locally : -1726468007. Either
revert the changes to the migration, or run repair to update the schema history.
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr Need more flexibility with validation rules?
Learn more: https://rd.gt/3AbJUZE
2022-04-21 16:04:09,065 ERROR [NiFi logging handler]
org.apache.nifi.registry.StdErr Shutting down...
2022-04-21 16:04:09,738 INFO [main] o.a.n.registry.bootstrap.RunNiFiRegistry
NiFi Registry never started. Will not restart NiFi Registry
{code}
I spotted this issue(https://issues.apache.org/jira/browse/NIFI-9836) which in
the title seems similar, but not sure if related.
Can you suggest any way I could fix this or if its an actual bug?
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
