-
Choerodon平台版本:
agile-service: 0.6.1
-
遇到问题的执行步骤:
直接部署
agile-service: 0.6.1版本初始化数据库是会报表不存在的错误，但是先部署0.5.3版本，然后再升级到0.6.1，则没问题。
helm install c7n/agile-service \
--set preJob.preConfig.mysql.host=choerodon-mysql \
--set preJob.preConfig.mysql.port=3306 \
--set preJob.preConfig.mysql.database=manager_service \
--set preJob.preConfig.mysql.username=choerodon \
--set preJob.preConfig.mysql.password=lKK66q4R9ozXvckI \
--set preJob.preInitDB.mysql.host=choerodon-mysql \
--set preJob.preInitDB.mysql.port=3306 \
--set preJob.preInitDB.mysql.database=agile_service \
--set preJob.preInitDB.mysql.username=choerodon \
--set preJob.preInitDB.mysql.password=lKK66q4R9ozXvckI \
--set env.open.SPRING_DATASOURCE_URL="jdbc:mysql://choerodon-mysql:3306/agile_service?useUnicode=true&characterEncoding=utf-8&useSSL=false" \
--set env.open.SPRING_DATASOURCE_USERNAME=choerodon \
--set env.open.SPRING_DATASOURCE_PASSWORD=lKK66q4R9ozXvckI \
--set env.open.EUREKA_CLIENT_SERVICEURL_DEFAULTZONE="http://register-server.choerodon-devops-prod:8000/eureka/" \
--set env.open.CHOERODON_EVENT_CONSUMER_KAFKA_BOOTSTRAP_SERVERS="kafka-0.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092\,kafka-1.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092\,kafka-2.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092" \
--set env.open.SPRING_CLOUD_STREAM_KAFKA_BINDER_BROKERS="kafka-0.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092\,kafka-1.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092\,kafka-2.kafka-headless.choerodon-devops-prod.svc.cluster.local:9092" \
--set env.open.SPRING_CLOUD_STREAM_KAFKA_BINDER_ZK_NODES="zookeeper-0.zookeeper-headless.choerodon-devops-prod.svc.cluster.local:2181\,zookeeper-1.zookeeper-headless.choerodon-devops-prod.svc.cluster.local:2181\,zookeeper-2.zookeeper-headless.choerodon-devops-prod.svc.cluster.local:2181" \
--set env.open.SPRING_CLOUD_CONFIG_ENABLED=true \
--set env.open.SPRING_CLOUD_CONFIG_URI="http://config-server.choerodon-devops-prod:8010/" \
--set env.open.SERVICES_ATTACHMENT_URL="http://minio.devops.crland.com.cn/agile-service/" \
--name=agile-service \
--version=0.6.1 --namespace=choerodon-devops-prod
[appuser@vm-48-2-centos ~]$ kubectl logs -f agile-service-init-db-9php2 -n choerodon-devops-prod
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v1.5.3.RELEASE)
2018-07-03 19:41:22.449 INFO 7 --- [ main] io.choerodon.liquibase.LiquibaseTools : Starting LiquibaseTools v0.5.2.RELEASE on agile-service-init-db-9php2 with PID 7 (/var/choerodon/choerodon-tool-liquibase.jar started by root in /)
2018-07-03 19:41:22.453 INFO 7 --- [ main] io.choerodon.liquibase.LiquibaseTools : No active profile set, falling back to default profiles: default
2018-07-03 19:41:22.800 INFO 7 --- [ main] s.c.a.AnnotationConfigApplicationContext : Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@59f99ea: startup date [Tue Jul 03 19:41:22 CST 2018]; root of context hierarchy
2018-07-03 19:41:23.484 WARN 7 --- [ main] o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator has been chosen, EL interpolation will not be supported
2018-07-03 19:41:23.680 WARN 7 --- [ main] o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator has been chosen, EL interpolation will not be supported
2018-07-03 19:41:24.388 INFO 7 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup
2018-07-03 19:41:24.399 INFO 7 --- [ main] i.choerodon.liquibase.LiquibaseExecutor : Jar拆解
2018-07-03 19:41:24.605 INFO 7 --- [ main] i.choerodon.liquibase.LiquibaseExecutor : Jar拆解完成
2018-07-03 19:41:25.418 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:26.130 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:26.652 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:26.667 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:26.766 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:26.794 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:26.802 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:26.843 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:26.851 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:26.859 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:26.906 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:26.916 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:26.934 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:26.984 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.005 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.025 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.167 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.193 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.205 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.241 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.249 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.258 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.295 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.309 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.318 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.354 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.363 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.378 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.417 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.424 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.440 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.485 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.492 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.518 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.574 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.583 INFO 7 --- [ main] liquibase : Successfully released change log lock
2018-07-03 19:41:27.593 INFO 7 --- [ main] liquibase : Successfully acquired change log lock
2018-07-03 19:41:27.642 INFO 7 --- [ main] liquibase : Reading from agile_service.DATABASECHANGELOG
2018-07-03 19:41:27.654 ERROR 7 --- [ main] liquibase : script/db/agile_issue_link_type.groovy: script/db/agile_issue_link_type.groovy::2018-06-25-agile-issue-link-type-init-data::dinghuang123@gmail.com: Change Set script/db/agile_issue_link_type.groovy::2018-06-25-agile-issue-link-type-init-data::dinghuang123@gmail.com failed. Error: Table 'agile_service.agile_project_info' doesn't exist [Failed SQL: INSERT INTO agile_issue_link_type ( link_name, in_ward, out_ward, project_id ) SELECT 'Blocks','is blocked by','blocks',agile_project_info.project_id FROM agile_project_info]
2018-07-03 19:41:27.659 INFO 7 --- [ main] liquibase : script/db/agile_issue_link_type.groovy::2018-06-25-agile-issue-link-type-init-data::dinghuang123@gmail.com: Successfully released change log lock
2018-07-03 19:41:27.663 ERROR 7 --- [ main] i.choerodon.liquibase.LiquibaseExecutor : Migration failed for change set script/db/agile_issue_link_type.groovy::2018-06-25-agile-issue-link-type-init-data::dinghuang123@gmail.com:
Reason: liquibase.exception.DatabaseException: Table 'agile_service.agile_project_info' doesn't exist [Failed SQL: INSERT INTO agile_issue_link_type ( link_name, in_ward, out_ward, project_id ) SELECT 'Blocks','is blocked by','blocks',agile_project_info.project_id FROM agile_project_info]
liquibase.exception.MigrationFailedException: Migration failed for change set script/db/agile_issue_link_type.groovy::2018-06-25-agile-issue-link-type-init-data::dinghuang123@gmail.com:
Reason: liquibase.exception.DatabaseException: Table 'agile_service.agile_project_info' doesn't exist [Failed SQL: INSERT INTO agile_issue_link_type ( link_name, in_ward, out_ward, project_id ) SELECT 'Blocks','is blocked by','blocks',agile_project_info.project_id FROM agile_project_info]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:214) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:192) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:188) ~[liquibase-core-3.5.3.jar!/:na]
at io.choerodon.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:236) ~[classes!/:0.5.2.RELEASE]
at io.choerodon.liquibase.LiquibaseExecutor.simpleExec(LiquibaseExecutor.java:184) ~[classes!/:0.5.2.RELEASE]
at io.choerodon.liquibase.LiquibaseExecutor.run(LiquibaseExecutor.java:77) ~[classes!/:0.5.2.RELEASE]
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:776) [spring-boot-1.5.3.RELEASE.jar!/:1.5.3.RELEASE]
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:760) [spring-boot-1.5.3.RELEASE.jar!/:1.5.3.RELEASE]
at org.springframework.boot.SpringApplication.afterRefresh(SpringApplication.java:747) [spring-boot-1.5.3.RELEASE.jar!/:1.5.3.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-1.5.3.RELEASE.jar!/:1.5.3.RELEASE]
at io.choerodon.liquibase.LiquibaseTools.main(LiquibaseTools.java:16) [classes!/:0.5.2.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [choerodon-tool-liquibase.jar:0.5.2.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [choerodon-tool-liquibase.jar:0.5.2.RELEASE]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [choerodon-tool-liquibase.jar:0.5.2.RELEASE]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [choerodon-tool-liquibase.jar:0.5.2.RELEASE]
Caused by: liquibase.exception.DatabaseException: Table 'agile_service.agile_project_info' doesn't exist [Failed SQL: INSERT INTO agile_issue_link_type ( link_name, in_ward, out_ward, project_id ) SELECT 'Blocks','is blocked by','blocks',agile_project_info.project_id FROM agile_project_info]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582) ~[liquibase-core-3.5.3.jar!/:na]
... 21 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'agile_service.agile_project_info' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_121]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_121]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) ~[mysql-connector-java-5.1.41.jar!/:5.1.41]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar!/:na]
at com.sun.proxy.$Proxy53.execute(Unknown Source) ~[na:na]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307) ~[liquibase-core-3.5.3.jar!/:na]
... 26 common frames omitted
2018-07-03 19:41:27.664 ERROR 7 --- [ main] i.choerodon.liquibase.LiquibaseExecutor : 数据库初始化任务失败
2018-07-03 19:41:27.664 INFO 7 --- [ Thread-2] s.c.a.AnnotationConfigApplicationContext : Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@59f99ea: startup date [Tue Jul 03 19:41:22 CST 2018]; root of context hierarchy
2018-07-03 19:41:27.666 INFO 7 --- [ Thread-2] o.s.j.e.a.AnnotationMBeanExporter : Unregistering JMX-exposed beans on shutdown