[jira] [Commented] (FINERACT-1457) Fineract no longer works with MySQL 5.7 due to Flyway v8 upgrade

["Michael Vorburger (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17466576#comment-17466576 ] 

Michael Vorburger commented on FINERACT-1457:
---------------------------------------------

This was caused by the upgrade of org.flywaydb:flyway-core from 7.15.0 to 8.1.0 in https://github.com/apache/fineract/commit/03a8a9858d1c3db703675ebaeb0828863d8b35de for https://github.com/apache/fineract/pull/1990 for FINERACT-982.

https://flywaydb.org/documentation/learnmore/releaseNotes under Flyway 8.0.0-beta1 (2021-09-14) says Database compatibility: Deprecate Community support for database versions older than 5 years - the exception error message above is caused by that.

If we accept that Fineract does not support e.g. MySQL 5.7 anymore, then we could simply document this somewhere, and close this as "Working as Intended" (WAI). If this is a problem, we shuld revert Flyway.

On https://www.fineract.dev, I've been using Google Cloud SQL MySQL DB version 5.7. I probably can and will try to upgrade that to 8.0 to work around this.

PS: FINERACT-1458 created about catching database migration issues in Pull Requests.

> Fineract no longer works with MySQL 5.7 due to Flyway v8 upgrade
> ----------------------------------------------------------------
>
>                 Key: FINERACT-1457
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1457
>             Project: Apache Fineract
>          Issue Type: Bug
>          Components: Database
>    Affects Versions: 1.6.0
>            Reporter: Michael Vorburger
>            Assignee: Michael Vorburger
>            Priority: Critical
>             Fix For: 1.6.0
>
>
> https://www.fineract.dev is failing to upgrade to the latest bleeding edge Fineract code from master branch, see https://github.com/vorburger/www.fineract.dev/issues/8:
> {noformat}
> 2021-12-29 18:54:47.772 ERROR 10 --- [           main] o.s.b.web.embedded.tomcat.TomcatStarter  : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'securityConfig': Unsatisfied dependency expressed through field 'userDetailsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDetailsService': Unsatisfied dependency expressed through field 'platformUserRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'appUserRepository' defined in org.apache.fineract.useradministration.domain.AppUserRepository defined in @EnableJpaRepositories declared on PersistenceConfig: Cannot create inner bean '(inner bean)#4ab90d01' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#4ab90d01': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantDatabaseUpgradeService': Invocation of init method failed; nested exception is org.flywaydb.core.internal.license.FlywayEditionUpgradeRequiredException: Flyway Teams Edition or MySQL upgrade required: MySQL 5.7 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
> (...)
> Caused by: org.flywaydb.core.internal.license.FlywayEditionUpgradeRequiredException: Flyway Teams Edition or MySQL upgrade required: MySQL 5.7 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
>         at org.flywaydb.core.internal.database.base.Database.ensureDatabaseNotOlderThanOtherwiseRecommendUpgradeToFlywayEdition(Database.java:126)
>         at org.flywaydb.core.internal.database.mysql.MySQLDatabase.ensureSupported(MySQLDatabase.java:252)
>         at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:188)
>         at org.flywaydb.core.Flyway.repair(Flyway.java:335)
>         at org.apache.fineract.infrastructure.core.service.TenantDatabaseUpgradeService.upgradeTenantDB(TenantDatabaseUpgradeService.java:118)
>         at org.apache.fineract.infrastructure.core.service.TenantDatabaseUpgradeService.upgradeAllTenants(TenantDatabaseUpgradeService.java:63)
>         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
>         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.base/java.lang.reflect.Method.invoke(Method.java:568)
>         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
>         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
>         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
>         ... 108 common frames omitted{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)