Issue while reading from Read Replica

[karunagoyal]

@kwon37xi First of all, I want to thank you for putting code together. I am trying to use this code in my spring boot application but keeps running in circular dependency:

Cannot create inner bean '(inner bean)#1fdff2f5' 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)#1fdff2f5': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$FlywayConfiguration': Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$FlywayConfiguration$$EnhancerBySpringCGLIB$$69437e9e]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'replicationDataSourceConfig': Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCurrentlyInCreationException: Error creating bean with name 'writeDataSource': Requested bean is currently in creation: Is there an unresolvable circular reference?

Could you please help with this?
Thanks in advance.

[kwon37xi]

Did you try with my https://github.com/kwon37xi/replication-datasource-boot source?
Or you changed the source by yourself?

First of all, try disabling flyway. You can do this with the following property in your application.yml.

spring.flyway.enabled=false # property key can be different by springboot version. check your boot version

If it does not work, please show me your configuration code.

[karunagoyal]

Thanks @kwon37xi . I can't disable flyway as we are using it for migration. I did use your code as -is.I tried to set bean to @lazy still didn't solve the problem.We have Postgres db set up in AWS and using Aurora RDS.

[karunagoyal]

Config file
application.yml.zip

[kwon37xi]

Please try to disable flyway for distinguishing if it's a problem of the flyway module or not.
And what's the exact version of SpringBoot?

[kwon37xi]

Also I recommend using flyway gradle plugin for migration not the SpringBoot flyway module.

[karunagoyal]

Thanks @kwon37xi for response. We are using spring boot version : 2.0.4.RELEASE. I disabled the flyway, still the error persist.
One more thing, I am creating DataSource for both writeDataSource and readDataSource as below: DataSourceBuilder.create().build();

I dont think that should be an issue but just wanted to let you know.

Thanks
Karuna

[karunagoyal]

Hi @kwon37xi any idea for this error?