分布式部署并启动confservice报错：Unknown column 'serverconf0_.Cluster' in 'field list'

[hywaljp]

2022-06-06 22:49:03.942 ERROR 4699 --- [main] o.h.engine.jdbc.spi.SqlExceptionHelper : Unknown column 'serverconf0_.Cluster' in 'field list'
2022-06-06 22:49:04.142 ERROR 4699 --- [main] o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'configServiceAutoConfiguration' defined in URL [jar:file:/data/leeonelli_project/apollo/apollo_config/apollo-configservice.jar!/BOOT-INF/classes!/com/ctrip/framework/apollo/configservice/ConfigServiceAutoConfiguration.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bizConfig': Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

[nobodyiam]

see #3177

[hywaljp]

Thanks, I created two ApolloConfigDB in a same database server(different db name). I create Apps, make a new configuration and release in Dev, config value in database is correct, but show in front page is instable when I refresh it, sometime it show in dev ,sometime show in uat and even release status turn into not release.

[nobodyiam]

Each env should register its services into its own eureka server. It sounds like they are registering to one eureka server.
You may check the system info page for more information.

[hywaljp]

Thanks,I register all eureka server in different environment. I just modify database eureka.service.url ,it doesn't take effect, when I restart server is ok. Change eureka.service.url support hot refresh？When I restart server, It will take some time to display the correct value, both System Information and configuration. Has your team tested how long it takes to work properly?

[nobodyiam]

Change eureka.service.url support hot refresh？

It takes up to 1 min to be effective.

It will take some time to display the correct value, both System Information and configuration

I think the eureka sync function will take up to 90 secs to display the correct value.

[hywaljp]

Hello,I use docker to start apollo, but portal connect admin/config server failure.

[jnanuzhang]

I found that the new version apollo(2.1.0) DB tables have new column(for exemple: The ApolloConfigDB 's table Item of have new column DletedAt and Type),If you import old DB data and use new version of apollo ,you will see this error.