cloudera manager - Error while committing the transaction

最新推荐文章于 2024-11-26 11:50:54 发布

原创

最新推荐文章于 2024-11-26 11:50:54 发布 · 9.9k 阅读

2 ·

CC 4.0 BY-SA版权

当使用Cloudera Manager编辑组件配置时，可能会遇到'Error while committing the transaction'的错误。该问题源于CM元数据库字符集不兼容，导致字段'VALUE'和'MESSAGE'无法写入。解决方法是修改元数据库的相关表，将'VALUE'和'MESSAGE'字段的字符集更改为utf8。具体操作包括修改CONFIGS, CONFIGS_AUD, GLOBAL_SETTINGS, USER_SETTINGS, AUDITS和REVISIONS表。" 80795071,5720435,Ubuntu 14.04 安装指南 - Mac & Linux,"['Linux安装', 'Ubuntu', '虚拟机', '操作系统', '分区管理']

现象：

在用cloudera manager编辑各个组件配置的时候

有可能会出现报错信息：

Error while committing the transaction

cloudera server 端日志：

Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE5\xB7\xB2\xE6\x9B\xB4...' for column 'VALUE' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
... 98 more
Caused by: java.sql.SQLException: Incorrect string value: '\xE5\xB7\xB2\xE6\x9B\xB4...' for column 'VALUE' at row 1