You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Michael Vorburger (Jira)" <ji...@apache.org> on 2021/12/29 21:26:00 UTC
[jira] [Commented] (FINERACT-1459) Data Migration issue (Subquery returns more than 1 row) in V370__message_gateway_hook_template.sql
[ https://issues.apache.org/jira/browse/FINERACT-1459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17466600#comment-17466600 ]
Michael Vorburger commented on FINERACT-1459:
---------------------------------------------
I've attempted to debug this issue:
_Subquery returns more than 1 row_ seems to mean that {{select id from m_hook_templates where name = 'Message Gateway'}} returns more than 1 row - except it does not, on that database.
That (entire) statement actually does work when executed manually. But my DB in question actually already had that row, so I'm not sure why Flyway thinks it needs to re-run this.
But https://github.com/apache/fineract/search?q=m_hook_templates shows no obvious duplicates or anything like that.
I'm giving up on this, and pursuing the https://www.fineract.dev by simply entirely resetting the database.
This may or may not be a fluke issue on the demo server, only. I'll keep this issue open as a Minor - just in case others hit this as well, and can investigate further. (I won't be further debugging this myself.)
> Data Migration issue (Subquery returns more than 1 row) in V370__message_gateway_hook_template.sql
> --------------------------------------------------------------------------------------------------
>
> Key: FINERACT-1459
> URL: https://issues.apache.org/jira/browse/FINERACT-1459
> Project: Apache Fineract
> Issue Type: Bug
> Affects Versions: 1.6.0
> Reporter: Michael Vorburger
> Priority: Minor
>
> https://www.fineract.dev was failing to upgrade to the latest bleeding edge Fineract code from master branch, see https://github.com/vorburger/www.fineract.dev/issues/8, due to the following:
> {noformat}Caused by: 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)#3636f2a7' 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)#3636f2a7': 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.api.FlywayException: Migration V370__message_gateway_hook_template.sql failed
> --------------------------------------------------------
> SQL State : 21000
> Error Code : 1242
> Message : (conn=492) Subquery returns more than 1 row
> Location : sql/migrations/core_db/V370__message_gateway_hook_template.sql (/app/sql/migrations/core_db/V370__message_gateway_hook_template.sql)
> Line : 25
> Statement : INSERT INTO m_hook_schema
> (hook_template_id, field_type, field_name, placeholder, optional)
> VALUES( (select id from m_hook_templates where name = 'Message Gateway'), 'string', 'SMS Provider Id', NULL, 0)
> ; for Tenant DB URL: jdbc:mariadb://10.103.176.16:3306/fineract_default, username: root
> at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659)
> at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639)
> at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
> at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619)
> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
> at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
> at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
> at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1380)
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1300)
> at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656)
> ... 62 common frames omitted
> Caused by: 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)#3636f2a7' 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)#3636f2a7': 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.api.FlywayException: Migration V370__message_gateway_hook_template.sql failed{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)