Bharath and Francis,
The issue with users who are unable to login to their instances seems to be because of some complex methods in REST controllers are executing multiple changes in DB through JPA repositories. For some reasons calls to these interfaces resulted in a growing number of "freezed" active connections, exhausting the pool. Either annotating these methods as @Transactional …or enveloping all the logic in a single call to transactional service method seems to solve the problem. You can apply it to the relevant methods as there are a growing number of issues surrounding failed connections. Regards, Sifiso From: hitesh prajapati <hitesh.kams.prajap...@gmail.com> Sent: Sunday, 28 November 2021 4:24 PM To: dev@fineract.apache.org Subject: Re: Fineract Startup issue - latest develop branch Hi Petri, Thanks for your suggestion. I don't have any data in my database. So I deleted my db and re-created them again. After that i run bootRun and the application is running fine. But I forgot to check the c_configurations table for an entry with name = custom-account-number-length, before deleting it and recreating it. Thanks, Hitesh On Sun, Nov 28, 2021 at 4:26 PM hitesh prajapati <hitesh.kams.prajap...@gmail.com <mailto:hitesh.kams.prajap...@gmail.com> > wrote: Hi Petri, Thanks for your reply. I will check and let you know. On Sun, 28 Nov 2021, 16:21 Petri Tuomola, <petri.tuom...@gmail.com <mailto:petri.tuom...@gmail.com> > wrote: Hi - can you check if your table c_configurations already has an entry with name = custom-account-number-length? For some reason it seems Flyway is trying to insert a config entry that is already there. Perhaps a previous startup failed? If the record is there, then remove that row and retry… Regards Petri On 28 Nov 2021, at 18:26, hitesh prajapati <hitesh.kams.prajap...@gmail.com <mailto:hitesh.kams.prajap...@gmail.com> > wrote: Hi All, I have taken the latest develop branch from community and run bootRun. The last commit https://github.com/apache/fineract/commit/8dc5789607dfa51a9186e1971998550df8e85374 But the fineract application is failing while starting. Lookslike some issue with sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql Below the error, I am getting 2021-11-28 15:48:13.797 INFO 19340 --- [ main] org.apache.fineract.ServerApplication : Starting ServerApplication using Java 11.0.12 on DESKTOP-92RI6NG with PID 19340 (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main started by hites in D:\Work\fineract\source\fineract\fineract-provider) 2021-11-28 15:48:13.797 INFO 19340 --- [ main] org.apache.fineract.ServerApplication : No active profile set, falling back to default profiles: basicauth 2021-11-28 15:48:21.279 INFO 19340 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 8443 (https) 2021-11-28 15:48:22.950 WARN 19340 --- [ main] o.f.core.internal.command.DbMigrate : outOfOrder mode is active. Migration of schema `fineract_tenants` may not be reproducible. 2021-11-28 15:48:23.963 WARN 19340 --- [ main] o.f.core.internal.command.DbMigrate : outOfOrder mode is active. Migration of schema `fineract_default` may not be reproducible. 2021-11-28 15:48:24.007 WARN 19340 --- [ main] o.d.jdbc.internal.mysql.MySQLProtocol : Could not execute query org.drizzle.jdbc.internal.common.query.DrizzleQuery@4e4af370 <mailto:org.drizzle.jdbc.internal.common.query.DrizzleQuery@4e4af370> : Duplicate entry 'custom-account-number-length' for key 'name_UNIQUE' 2021-11-28 15:48:24.039 ERROR 19340 --- [ main] o.f.core.internal.command.DbMigrate : Migration of schema `fineract_default` to version "378 - configuration for variable length acoountNumber" failed! Please restore backups and roll back database and code! 2021-11-28 15:48:24.097 ERROR 19340 --- [ 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)#6f17dd06' 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)#6f17dd06': 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 V378__configuration_for_variable_length_acoountNumber.sql failed -------------------------------------------------------------------------- SQL State : 23000 Error Code : 1062 Message : Duplicate entry 'custom-account-number-length' for key 'name_UNIQUE' Location : sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main\sql\migrations\core_db\V378__configuration_for_variable_length_acoountNumber.sql) Line : 20 Statement : -- -- Licensed to the Apache Software Foundation (ASF) under one -- or more contributor license agreements. See the NOTICE file -- distributed with this work for additional information -- regarding copyright ownership. The ASF licenses this file -- to you under the Apache License, Version 2.0 (the -- "License"); you may not use this file except in compliance -- with the License. You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, -- software distributed under the License is distributed on an -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY -- KIND, either express or implied. See the License for the -- specific language governing permissions and limitations -- under the License. -- INSERT INTO c_configuration ( name, description) VALUES ( 'custom-account-number-length', 'if enabled, the value if this configuration will set accounnumber length') ; for Tenant DB URL: jdbc:mysql:thin://localhost:3306/fineract_default, username: root 2021-11-28 15:48:24.134 WARN 19340 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [fineract-provider] appears to have started a thread named [HikariPool-1 housekeeper] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native <mailto:java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native> Method) java.base@11.0.12/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) <mailto:java.base@11.0.12/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)> java.base@11.0.12/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) <mailto:java.base@11.0.12/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)> java.base@11.0.12/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182) <mailto:java.base@11.0.12/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)> java.base@11.0.12/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899) <mailto:java.base@11.0.12/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)> java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054) <mailto:java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1054)> java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) <mailto:java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114)> java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) <mailto:java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)> java.base@11.0.12/java.lang.Thread.run(Thread.java:829) <mailto:java.base@11.0.12/java.lang.Thread.run(Thread.java:829)> 2021-11-28 15:48:24.134 WARN 19340 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [fineract-provider] appears to have started a thread named [HikariPool-1 connection adder] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native <mailto:java.base@11.0.12/jdk.internal.misc.Unsafe.park(Native> Method) java.base@11.0.12/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234) <mailto:java.base@11.0.12/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:234)> java.base@11.0.12/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123) <mailto:java.base@11.0.12/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2123)> java.base@11.0.12/java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:458) <mailto:java.base@11.0.12/java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:458)> java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1053) <mailto:java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1053)> java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1114) java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) <mailto:java.base@11.0.12/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)> java.base@11.0.12/java.lang.Thread.run(Thread.java:829) <mailto:java.base@11.0.12/java.lang.Thread.run(Thread.java:829)> 2021-11-28 15:48:24.142 WARN 19340 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat 2021-11-28 15:48:24.191 ERROR 19340 --- [ main] o.s.boot.SpringApplication : Application run failed org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:163) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:577) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412) at org.springframework.boot.SpringApplication.run(SpringApplication.java:302) at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:164) at org.apache.fineract.ServerApplication.main(ServerApplication.java:58) Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:142) at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:104) at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:473) at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:206) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:182) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:160) ... 7 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: 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)#6f17dd06' 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)#6f17dd06': 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 V378__configuration_for_variable_length_acoountNumber.sql failed -------------------------------------------------------------------------- SQL State : 23000 Error Code : 1062 Message : Duplicate entry 'custom-account-number-length' for key 'name_UNIQUE' Location : sql/migrations/core_db/V378__configuration_for_variable_length_acoountNumber.sql (D:\Work\fineract\source\fineract\fineract-provider\build\classes\java\main\sql\migrations\core_db\V378__configuration_for_variable_length_acoountNumber.sql) Line : 20 Statement : --