druid.io在安装过程出现元数据库异常问题

最新推荐文章于 2022-05-30 08:30:00 发布

Xlucas

最新推荐文章于 2022-05-30 08:30:00 发布

阅读量1k

点赞数

分类专栏： druid 文章标签： druid

本文链接：https://blog.csdn.net/paicMis/article/details/87927788

版权

druid 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

在我们启动coordinator的时候用来刷新元数据库，但是发现出现表刷入失败，可以在日志里查看到字符编码问题
可以使用mysql的修改字符编码，这个地方和官网的字符编码有点不一样

ALTER DATABASE druid DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci



2019-02-26T00:20:54,163 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table
org.skife.jdbi.v2.exceptions.CallbackFailedException: io.druid.java.util.common.ISE: Database default character set is not UTF-8.
  Druid requires its MySQL database to be created using UTF-8 as default character set.
        at org.skife.jdbi.v2.DBI.withHandle(DBI.java:284) ~[jdbi-2.63.1.jar:2.63.1]
        at io.druid.metadata.SQLMetadataConnector$2.call(SQLMetadataConnector.java:135) ~[druid-server-0.12.0.jar:0.12.0]
        at io.druid.java.util.common.RetryUtils.retry(RetryUtils.java:63) ~[java-util-0.12.0.jar:0.12.0]
        at io.druid.java.util.common.RetryUtils.retry(RetryUtils.java:81) ~[java-util-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:139) ~[druid-server-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:148) ~[druid-server-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataConnector.createTable(SQLMetadataConnector.java:189) [druid-server-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataConnector.createRulesTable(SQLMetadataConnector.java:287) [druid-server-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataConnector.createRulesTable(SQLMetadataConnector.java:553) [druid-server-0.12.0.jar:0.12.0]
        at io.druid.metadata.SQLMetadataRuleManagerProvider$1.start(SQLMetadataRuleManagerProvider.java:71) [druid-server-0.12.0.jar:0.12.0]