0.21安装mysql问题

dongasai · 2020 年4 月 7 日 01:09

Choerodon平台版本: 0.21
遇到问题的执行步骤:
一键部署,在这个的时候
[INFO] job base-service-init-db haven’t finished yet. please wait patiently

分布部署,在不是 base-service 的时候

环境信息(如:节点信息):
报错日志:

一键部署
liquibase.executor.jvm.JdbcExecutor : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES (‘2019-10-31-lov-grid-add-column’, ‘bgzyy’, ‘script/db/fd_lov.groovy’, NOW(), 28, ‘8:136edb56f0c12425c94335924e8debe7’, ‘addColumn tableName=FD_LOV_GRID_FIELD’, ‘’, ‘EXECUTED’, NULL, NULL, ‘3.6.3’, ‘6172986407’)
2020-04-06 19:36:40.144 WARN 7 — [ main] com.zaxxer.hikari.pool.ProxyConnection : HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@295b17a6 marked as broken because of SQLSTATE(08S01), ErrorCode(0)

分部部署也卡在这,采用nfs部署的mysql 存在这个问题
使用外部mysql 存在,无法连接的问题
http://choerodon.io/zh/docs/installation-configuration/steps/install/parts/choerodon/
分布部署,到了这一步,能够创建数据库(采用外部数据库),到了 部署 base service的时候就无法连接了,

原因分析:

提出您分析问题的过程,以便我们能更准确的找到问题所在
疑问:

提出您对于遇到和解决该问题时的疑问

Vista · 2020 年4 月 7 日 01:36

一键部署报错的原因是 Liquibase 被锁住了，建议直接删掉 mysql 和它的 PVC 重新尝试一下。

分步安装使用外部数据库无法连接建议你看一下具体的报错日志。

dongasai · 2020 年4 月 7 日 01:54

@Vista 重试了大约7遍

Vista · 2020 年4 月 7 日 01:56

能贴一下完整的日志吗？

包括 c7nctl 安装的日志，以及 base-service-init-db 的日志

dongasai · 2020 年4 月 7 日 08:06



2020-04-08 00:13:07.390  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.392  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-09-06-add-table-fd_prompt', 'hailor', 'script/db/fd_lov_lookupcode_prompt.groovy', NOW(), 56, '8:b2e7c0012d81b9d77d52759770912f23', 'createTable tableName=FD_PROMPT; addUniqueConstraint constraintName=UK_FD_PROMPT_U1, tableName=FD_PROMPT', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987368')
2020-04-08 00:13:07.397  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.399  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.400  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.401  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM base_service.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-08 00:13:07.403  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2020-04-08 00:13:07.457  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM base_service.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-08 00:13:07.458  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.458  INFO 6 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from base_service.DATABASECHANGELOG
2020-04-08 00:13:07.459  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM base_service.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-08 00:13:07.474  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE base_service.FD_REMOTE_CONNECTION_RECORD (ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, REMOTE_TOKEN_ID BIGINT UNSIGNED NOT NULL COMMENT '远程连接Token主键', SOURCE_IP VARCHAR(64) NOT NULL COMMENT '来源IP', OPERATION VARCHAR(32) DEFAULT 'configure_and_test' NOT NULL COMMENT '操作类型。配置并测试、断开连接、重新连接。', OBJECT_VERSION_NUMBER BIGINT UNSIGNED DEFAULT 1 NULL, CREATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, CREATION_DATE datetime DEFAULT NOW() NULL, LAST_UPDATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, LAST_UPDATE_DATE datetime DEFAULT NOW() NULL, CONSTRAINT PK_FD_REMOTE_CONNECTION_RECORD PRIMARY KEY (ID)) COMMENT='远程连接记录表'
2020-04-08 00:13:07.481  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.FD_REMOTE_CONNECTION_RECORD COMMENT = '远程连接记录表'
2020-04-08 00:13:07.485  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_CONNECTION_RECORD created
2020-04-08 00:13:07.486  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_connection_record.groovy::2019-07-30-fd_remote_connection_record::longhe6699@gmail.com ran successfully in 14ms
2020-04-08 00:13:07.487  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.489  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-07-30-fd_remote_connection_record', 'longhe6699@gmail.com', 'script/db/fd_remote_connection_record.groovy', NOW(), 57, '8:e36169abb096471c7c8ffd6d88b73d2a', 'createTable tableName=FD_REMOTE_CONNECTION_RECORD', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987466')
2020-04-08 00:13:07.494  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP TABLE base_service.FD_REMOTE_CONNECTION_RECORD
2020-04-08 00:13:07.498  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_CONNECTION_RECORD dropped
2020-04-08 00:13:07.499  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_connection_record.groovy::2020-01-03-fd-remote-connection-record-drop::wanghao ran successfully in 6ms
2020-04-08 00:13:07.500  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2020-01-03-fd-remote-connection-record-drop', 'wanghao', 'script/db/fd_remote_connection_record.groovy', NOW(), 58, '8:159f692fa34eb73adb1979b311f181c6', 'dropTable tableName=FD_REMOTE_CONNECTION_RECORD', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987466')
2020-04-08 00:13:07.504  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.507  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.508  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.509  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM base_service.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-08 00:13:07.513  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2020-04-08 00:13:07.571  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM base_service.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-08 00:13:07.571  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.572  INFO 6 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from base_service.DATABASECHANGELOG
2020-04-08 00:13:07.572  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM base_service.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-08 00:13:07.589  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE base_service.FD_REMOTE_TOKEN (ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, ORGANIZATION_ID BIGINT UNSIGNED NOT NULL COMMENT '组织ID', NAME VARCHAR(64) NOT NULL COMMENT 'TOKEN的名称', EMAIL VARCHAR(128) NOT NULL COMMENT '联系邮箱', REMOTE_TOKEN VARCHAR(128) NOT NULL COMMENT '远程连接的UUID', IS_EXPIRED TINYINT UNSIGNED DEFAULT 0 NOT NULL COMMENT 'token是否过期。0：（默认）没有过期；1：已过期。', LATEST_EXPIRATION_TIME datetime NULL COMMENT '最近一次的失效时间', OBJECT_VERSION_NUMBER BIGINT UNSIGNED DEFAULT 1 NULL, CREATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, CREATION_DATE datetime DEFAULT NOW() NULL, LAST_UPDATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, LAST_UPDATE_DATE datetime DEFAULT NOW() NULL, CONSTRAINT PK_FD_REMOTE_TOKEN PRIMARY KEY (ID), CONSTRAINT UK_FD_REMOTE_TOKEN_U1 UNIQUE (REMOTE_TOKEN)) COMMENT='远程连接令牌表'
2020-04-08 00:13:07.597  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.FD_REMOTE_TOKEN COMMENT = '远程连接令牌表'
2020-04-08 00:13:07.601  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_TOKEN created
2020-04-08 00:13:07.601  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_token.groovy::2019-07-30-fd_remote_token::longhe6699@gmail.com ran successfully in 14ms
2020-04-08 00:13:07.602  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.603  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-07-30-fd_remote_token', 'longhe6699@gmail.com', 'script/db/fd_remote_token.groovy', NOW(), 59, '8:5013f370f209d6b9089d00f515c8baaf', 'createTable tableName=FD_REMOTE_TOKEN', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987577')
2020-04-08 00:13:07.607  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP TABLE base_service.FD_REMOTE_TOKEN
2020-04-08 00:13:07.610  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_TOKEN dropped
2020-04-08 00:13:07.611  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_token.groovy::2020-01-03-fd-remote-token-drop::wanghao ran successfully in 5ms
2020-04-08 00:13:07.612  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2020-01-03-fd-remote-token-drop', 'wanghao', 'script/db/fd_remote_token.groovy', NOW(), 60, '8:56ad773327ee44983b9d96deaca3fe2f', 'dropTable tableName=FD_REMOTE_TOKEN', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987577')
2020-04-08 00:13:07.616  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.620  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.620  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.621  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM base_service.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-08 00:13:07.624  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2020-04-08 00:13:07.692  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM base_service.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-08 00:13:07.693  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.694  INFO 6 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from base_service.DATABASECHANGELOG
2020-04-08 00:13:07.694  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM base_service.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-08 00:13:07.708  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE base_service.FD_REMOTE_TOKEN_AUTHORIZATION (ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, NAME VARCHAR(64) NOT NULL COMMENT 'TOKEN名称', EMAIL VARCHAR(128) NOT NULL COMMENT '联系邮箱', REMOTE_TOKEN VARCHAR(128) NOT NULL COMMENT '远程连接的UUID', AUTHORIZATION_URL VARCHAR(255) NOT NULL COMMENT 'TOKEN校验地址', STATUS VARCHAR(16) NOT NULL COMMENT 'token状态。 success：成功；failed：失败；break: 中断', ORGANIZATION_NAME VARCHAR(32) NOT NULL COMMENT 'SaaS组织名', ORGANIZATION_CODE VARCHAR(15) NOT NULL COMMENT 'SaaS组织code', OBJECT_VERSION_NUMBER BIGINT UNSIGNED DEFAULT 1 NULL, CREATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, CREATION_DATE datetime DEFAULT NOW() NULL, LAST_UPDATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, LAST_UPDATE_DATE datetime DEFAULT NOW() NULL, CONSTRAINT PK_FD_REMOTE_TOKEN_AUTHORIZATION PRIMARY KEY (ID)) COMMENT='Pass平台远程连接授权记录表'
2020-04-08 00:13:07.715  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.FD_REMOTE_TOKEN_AUTHORIZATION COMMENT = 'Pass平台远程连接授权记录表'
2020-04-08 00:13:07.719  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_TOKEN_AUTHORIZATION created
2020-04-08 00:13:07.719  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_token_authorization.groovy::2019-08-05-fd_remote_token_authorization::zongw.lee@gmail.com ran successfully in 13ms
2020-04-08 00:13:07.720  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.721  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-08-05-fd_remote_token_authorization', 'zongw.lee@gmail.com', 'script/db/fd_remote_token_authorization.groovy', NOW(), 61, '8:63692ee3a396cdcd311d460b5a14a8b0', 'createTable tableName=FD_REMOTE_TOKEN_AUTHORIZATION', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987699')
2020-04-08 00:13:07.725  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP TABLE base_service.FD_REMOTE_TOKEN_AUTHORIZATION
2020-04-08 00:13:07.731  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REMOTE_TOKEN_AUTHORIZATION dropped
2020-04-08 00:13:07.731  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_remote_token_authorization.groovy::2020-01-03-fd-remote-token-authorization-drop::wanghao ran successfully in 6ms
2020-04-08 00:13:07.732  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2020-01-03-fd-remote-token-authorization-drop', 'wanghao', 'script/db/fd_remote_token_authorization.groovy', NOW(), 62, '8:8596c9ecfb71148a51e96be0a453a3c8', 'dropTable tableName=FD_REMOTE_TOKEN_AUTHORIZATION', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987699')
2020-04-08 00:13:07.737  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.743  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.743  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.744  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM base_service.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-08 00:13:07.747  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2020-04-08 00:13:07.783  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM base_service.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-08 00:13:07.785  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.785  INFO 6 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from base_service.DATABASECHANGELOG
2020-04-08 00:13:07.786  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM base_service.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-08 00:13:07.799  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE base_service.FD_REPORT (ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, REPORT_TYPE VARCHAR(64) NULL COMMENT '类型', ICON MEDIUMTEXT NULL COMMENT '图标', TITLE VARCHAR(64) NULL COMMENT '标题', `DESCRIPTION` VARCHAR(128) NULL COMMENT '描述', `PATH` VARCHAR(128) NULL COMMENT '路径', SORT BIGINT UNSIGNED NULL COMMENT '排序', OBJECT_VERSION_NUMBER BIGINT UNSIGNED DEFAULT 1 NULL, CREATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, CREATION_DATE datetime DEFAULT NOW() NULL, LAST_UPDATED_BY BIGINT UNSIGNED DEFAULT 0 NULL, LAST_UPDATE_DATE datetime DEFAULT NOW() NULL, CONSTRAINT PK_FD_REPORT PRIMARY KEY (ID))
2020-04-08 00:13:07.806  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_REPORT created
2020-04-08 00:13:07.806  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_report.groovy::2019-09-10-fd-report::xausky@163.com ran successfully in 10ms
2020-04-08 00:13:07.807  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.808  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-09-10-fd-report', 'xausky@163.com', 'script/db/fd_report.groovy', NOW(), 63, '8:bf5dcc454e6a4a0ee819e627fd638fc0', 'createTable tableName=FD_REPORT', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987790')
2020-04-08 00:13:07.813  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.815  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.816  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOGLOCK
2020-04-08 00:13:07.817  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM base_service.DATABASECHANGELOGLOCK WHERE ID=1
2020-04-08 00:13:07.820  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2020-04-08 00:13:07.869  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM base_service.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2020-04-08 00:13:07.871  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.872  INFO 6 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from base_service.DATABASECHANGELOG
2020-04-08 00:13:07.872  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM base_service.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-04-08 00:13:07.893  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE base_service.FD_ROUTE (ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, SERVICE_CODE VARCHAR(64) NOT NULL COMMENT '服务编码', BACKEND_PATH VARCHAR(240) NULL COMMENT '后端路由', FRONTEND_PATH VARCHAR(240) NULL COMMENT '前端路由', OBJECT_VERSION_NUMBER BIGINT DEFAULT 1 NULL, CREATED_BY BIGINT DEFAULT -1 NULL, CREATION_DATE datetime DEFAULT NOW() NULL, LAST_UPDATED_BY BIGINT DEFAULT -1 NULL, LAST_UPDATE_DATE datetime DEFAULT NOW() NULL, CONSTRAINT PK_FD_ROUTE PRIMARY KEY (ID)) COMMENT='服务路由表'
2020-04-08 00:13:07.902  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.FD_ROUTE COMMENT = '服务路由表'
2020-04-08 00:13:07.905  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Table FD_ROUTE created
2020-04-08 00:13:07.906  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.FD_ROUTE ADD CONSTRAINT UK_FD_ROUTE_U1 UNIQUE (SERVICE_CODE)
2020-04-08 00:13:07.912  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : Unique constraint added to FD_ROUTE(SERVICE_CODE)
2020-04-08 00:13:07.912  INFO 6 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet script/db/fd_service.groovy::2019-09-10-add-fd-route::xausky ran successfully in 21ms
2020-04-08 00:13:07.912  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM base_service.DATABASECHANGELOG
2020-04-08 00:13:07.914  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO base_service.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2019-09-10-add-fd-route', 'xausky', 'script/db/fd_service.groovy', NOW(), 64, '8:f1511ad5a739d365b3279e0d783212f9', 'createTable tableName=FD_ROUTE; addUniqueConstraint constraintName=UK_FD_ROUTE_U1, tableName=FD_ROUTE', '', 'EXECUTED', NULL, NULL, '3.6.3', '6275987876')
2020-04-08 00:13:07.919  INFO 6 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE base_service.fd_route ADD STRIP_PREFIX INT UNSIGNED NULL COMMENT '是否去前缀' , ADD SENSITIVE_HEADERS TEXT NULL COMMENT '敏感头部列表' , ADD ROUTE_ID VARCHAR(64) NOT NULL COMMENT '路由ID'
2020-04-08 00:13:07.920 ERROR 6 --- [           main] liquibase.changelog.ChangeSet            : Change Set script/db/fd_service.groovy::2019-10-26-fd-route-add-column::zongw.lee@gmail.com failed.  Error: Table 'base_service.fd_route' doesn't exist [Failed SQL: ALTER TABLE base_service.fd_route ADD STRIP_PREFIX INT UNSIGNED NULL COMMENT '是否去前缀' , ADD SENSITIVE_HEADERS TEXT NULL COMMENT '敏感头部列表' , ADD ROUTE_ID VARCHAR(64) NOT NULL COMMENT '路由ID']
2020-04-08 00:13:07.922  INFO 6 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2020-04-08 00:13:07.927 ERROR 6 --- [           main] i.choerodon.liquibase.LiquibaseExecutor  : 数据库初始化任务失败, message: Migration failed for change set script/db/fd_service.groovy::2019-10-26-fd-route-add-column::zongw.lee@gmail.com:
     Reason: liquibase.exception.DatabaseException: Table 'base_service.fd_route' doesn't exist [Failed SQL: ALTER TABLE base_service.fd_route ADD STRIP_PREFIX INT UNSIGNED NULL COMMENT '是否去前缀' , ADD SENSITIVE_HEADERS TEXT NULL COMMENT '敏感头部列表' , ADD ROUTE_ID VARCHAR(64) NOT NULL COMMENT '路由ID'], exception: 

liquibase.exception.MigrationFailedException: Migration failed for change set script/db/fd_service.groovy::2019-10-26-fd-route-add-column::zongw.lee@gmail.com:
     Reason: liquibase.exception.DatabaseException: Table 'base_service.fd_route' doesn't exist [Failed SQL: ALTER TABLE base_service.fd_route ADD STRIP_PREFIX INT UNSIGNED NULL COMMENT '是否去前缀' , ADD SENSITIVE_HEADERS TEXT NULL COMMENT '敏感头部列表' , ADD ROUTE_ID VARCHAR(64) NOT NULL COMMENT '路由ID']
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.Liquibase.update(Liquibase.java:202) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.Liquibase.update(Liquibase.java:179) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.Liquibase.update(Liquibase.java:175) ~[liquibase-core-3.6.3.jar!/:na]
	at io.choerodon.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:292) ~[choerodon-liquibase-0.15.0-SNAPSHOT.jar!/:0.15.0-SNAPSHOT]
	at io.choerodon.liquibase.LiquibaseExecutor.runToDb(LiquibaseExecutor.java:208) ~[choerodon-liquibase-0.15.0-SNAPSHOT.jar!/:0.15.0-SNAPSHOT]
	at io.choerodon.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:111) ~[choerodon-liquibase-0.15.0-SNAPSHOT.jar!/:0.15.0-SNAPSHOT]
	at io.choerodon.liquibase.StartupRunner.run(StartupRunner.java:28) [classes!/:0.15.0-SNAPSHOT]
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:779) [spring-boot-2.1.6.RELEASE.jar!/:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:763) [spring-boot-2.1.6.RELEASE.jar!/:2.1.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:318) [spring-boot-2.1.6.RELEASE.jar!/:2.1.6.RELEASE]
	at io.choerodon.liquibase.LiquibaseTools.main(LiquibaseTools.java:18) [classes!/:0.15.0-SNAPSHOT]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_242]
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_242]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_242]
	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_242]
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:47) [choerodon-tool-liquibase.jar:0.15.0-SNAPSHOT]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:86) [choerodon-tool-liquibase.jar:0.15.0-SNAPSHOT]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [choerodon-tool-liquibase.jar:0.15.0-SNAPSHOT]
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [choerodon-tool-liquibase.jar:0.15.0-SNAPSHOT]
Caused by: liquibase.exception.DatabaseException: Table 'base_service.fd_route' doesn't exist [Failed SQL: ALTER TABLE base_service.fd_route ADD STRIP_PREFIX INT UNSIGNED NULL COMMENT '是否去前缀' , ADD SENSITIVE_HEADERS TEXT NULL COMMENT '敏感头部列表' , ADD ROUTE_ID VARCHAR(64) NOT NULL COMMENT '路由ID']
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600) ~[liquibase-core-3.6.3.jar!/:na]
	... 21 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Table 'base_service.fd_route' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.16.jar!/:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar!/:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.16.jar!/:8.0.16]
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) ~[mysql-connector-java-8.0.16.jar!/:8.0.16]
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) ~[mysql-connector-java-8.0.16.jar!/:8.0.16]
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.2.0.jar!/:na]
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.2.0.jar!/:na]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ~[liquibase-core-3.6.3.jar!/:na]
	... 26 common frames omitted

2020-04-08 00:13:07.935  INFO 6 --- [       Thread-5] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2020-04-08 00:13:07.946  INFO 6 --- [       Thread-5] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.

这是base-service-init-db的日志,采用分步安装

dongasai · 2020 年4 月 7 日 08:07

之前一键安装也遇到了这种问题,

Vista · 2020 年4 月 7 日 08:09

你安装的 base-service 版本是 0.21.2 吗？升级到 0.21.5 试一下

ping @ChangpingShi

dongasai · 2020 年4 月 7 日 08:12

helm install c7n/base-service -f base-service.yaml --name base-service --version 0.21.5 --namespace c7n-system

就是0.21.5

dongasai · 2020 年4 月 7 日 08:15

服务器版本： 5.7.29 - MySQL Community Server (GPL)

ChangpingShi · 2020 年4 月 7 日 08:56

直接install 0.21.5版本出现问题？

dongasai · 2020 年4 月 7 日 09:03

对的，

Vista · 2020 年4 月 7 日 09:11

你把 base-servcie 的数据删除，重新创建。再尝试安装 base-service

dongasai · 2020 年4 月 7 日 09:34

我能说试了好几次了么？

dongasai · 2020 年4 月 7 日 09:34

重装mysql试下吧

ChangpingShi · 2020 年4 月 7 日 09:41

我们在本地进行了0.21.5的数据初始化是正常的，即使从0.21.2升级到0.21.5初始化数据也是正常的；目前是怀疑是否有脏数据来着

ChangpingShi · 2020 年4 月 7 日 09:59

请问 mysql有关闭大小写敏感么？

ChangpingShi · 2020 年4 月 7 日 10:03

sorry，按照官网文档是有关闭大小写敏感，忘记问这茬

dongasai · 2020 年4 月 8 日 02:13

大小写敏感的问题,原因不详,我有设置不区分大小写

在使用一键部署的时候,部署的那个mysql应该是不区分大小写的吧,也遇到问题了呀,
在运维的操作下,使用了我那个不行的config.yml(没用外部mysql)也行了呀,我看着它弄得,真的啥都不差
回滚vm,我再来一遍使用外部mysql 的也行了,… 感谢我去年买了个华为手表

dongasai · 2020 年4 月 8 日 02:13

这个问题,是因为:我当时使用的 base-service.yaml :

      SPRING_DATASOURCE_URL: jdbc:mysql://192.168.0.203:33307/base_service?useUnicode=true&characterEncoding=utf-8&useSSL=false&useInformationSchema=true&remarks=true&allowMultiQueries=true&serverTimezone=Asia/Shanghai

是这个url,端口是33307,就不能访问,原因不详去掉端口就好了(这个33307的数据库我在我的pc,以及集群其他节点都能访问)