[
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)
