cloudera manager - Error while committing the transaction

当使用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
   

fatal: [uklvadfdp004a.pi.dev.net]: FAILED! => {"changed": true, "cmd": "sudo /usr/bin/yum update -y --disablerepo=\"*\" --enablerepo=\"cloudera-repo\" cloudera-manager-server", "delta": "0:00:51.341265", "end": "2025-08-01 11:30:31.486874", "msg": "non-zero return code", "rc": 1, "start": "2025-08-01 11:29:40.145609", "stderr": "Error in PREIN scriptlet in rpm package cloudera-manager-daemons\nError in PREIN scriptlet in rpm package cloudera-manager-agent\nError in PREIN scriptlet in rpm package cloudera-manager-server\nError: Transaction failed", "stderr_lines": ["Error in PREIN scriptlet in rpm package cloudera-manager-daemons", "Error in PREIN scriptlet in rpm package cloudera-manager-agent", "Error in PREIN scriptlet in rpm package cloudera-manager-server", "Error: Transaction failed"], "stdout": "Updating Subscription Management repositories.\nUnable to read consumer identity\n\nThis system is not registered with an entitlement server. You can use subscription-manager to register.\n\ncloudera-repo 35 kB/s | 3.0 kB 00:00 \nDependencies resolved.\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nUpgrading:\n cloudera-manager-agent x86_64 7.11.3.36-67636814.el8 cloudera-repo 80 M\n cloudera-manager-daemons x86_64 7.11.3.36-67636814.el8 cloudera-repo 1.4 G\n cloudera-manager-server x86_64 7.11.3.36-67636814.el8 cloudera-repo 20 k\n\nTransaction Summary\n================================================================================\nUpgrade 3 Packages\n\nTotal size: 1.4 G\nTotal download size: 1.4 G\nDownloading Packages:\n[SKIPPED] cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64.rpm: Already downloaded\n[SKIPPED] cloudera-manager-server-7.11.3.36-67636814.el8.x86_64.rpm: Already downloaded\n(3/3): cloudera-manager-daemons-7.11.3.36-67636 72 MB/s | 1.4 GB 00:19 \n--------------------------------------------------------------------------------\nTotal 72 MB/s | 1.4 GB 00:19 \nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n Preparing : 1/1 \n Running scriptlet: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 1/1 \n Running scriptlet: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 1/6 \n+=================================================================+\n| WARNING: ptrace_scope is disabled. Please enable ptrace before |\n| continuing with Cloudera Manager upgrades. |\n| |\n| To disable check for ptrace_scope, use the below and try again: |\n| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |\n+=================================================================+\nerror: %prein(cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1\n\n Running scriptlet: cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 2/6 \nerror: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64: install failed\n+=================================================================+\n| WARNING: ptrace_scope is disabled. Please enable ptrace before |\n| continuing with Cloudera Manager upgrades. |\n| |\n| To disable check for ptrace_scope, use the below and try again: |\n| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |\n+=================================================================+\nerror: %prein(cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1\n\n Running scriptlet: cloudera-manager-server-7.11.3.36-67636814.el8.x86_6 3/6 \nerror: cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64: install failed\n+=======================================================================+\n| WARNING: Upgrading to this version of Cloudera Manager is only |\n| supported with a valid Cloudera Enterprise or Cloudera Data Platform |\n| (CDP) license. If you are using Cloudera Express, a Trial license or |\n| an expired Cloudera Enterprise / CDP license, please roll back to an |\n| older version of Cloudera Manager. |\n+=======================================================================+\n+=================================================================+\n| WARNING: ptrace_scope is disabled. Please enable ptrace before |\n| continuing with Cloudera Manager upgrades. |\n| |\n| To disable check for ptrace_scope, use the below and try again: |\n| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |\n+=================================================================+\nerror: %prein(cloudera-manager-server-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1\n\n Verifying : cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 1/6 \n Verifying : cloudera-manager-agent-7.6.1-28822345p.el8.x86_64 2/6 \n Verifying : cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 3/6 \n Verifying : cloudera-manager-daemons-7.6.1-28822345p.el8.x86_64 4/6 \n Verifying : cloudera-manager-server-7.11.3.36-67636814.el8.x86_6 5/6 \n Verifying : cloudera-manager-server-7.6.1-28822345p.el8.x86_64 6/6 \nInstalled products updated.\n\nFailed:\n cloudera-manager-agent-7.6.1-28822345p.el8.x86_64 \n cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 \n cloudera-manager-daemons-7.6.1-28822345p.el8.x86_64 \n cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64 \n cloudera-manager-server-7.6.1-28822345p.el8.x86_64 \n cloudera-manager-server-7.11.3.36-67636814.el8.x86_64 ", "stdout_lines": ["Updating Subscription Management repositories.", "Unable to read consumer identity", "", "This system is not registered with an entitlement server. You can use subscription-manager to register.", "", "cloudera-repo 35 kB/s | 3.0 kB 00:00 ", "Dependencies resolved.", "================================================================================", " Package Arch Version Repository Size", "================================================================================", "Upgrading:", " cloudera-manager-agent x86_64 7.11.3.36-67636814.el8 cloudera-repo 80 M", " cloudera-manager-daemons x86_64 7.11.3.36-67636814.el8 cloudera-repo 1.4 G", " cloudera-manager-server x86_64 7.11.3.36-67636814.el8 cloudera-repo 20 k", "", "Transaction Summary", "================================================================================", "Upgrade 3 Packages", "", "Total size: 1.4 G", "Total download size: 1.4 G", "Downloading Packages:", "[SKIPPED] cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64.rpm: Already downloaded", "[SKIPPED] cloudera-manager-server-7.11.3.36-67636814.el8.x86_64.rpm: Already downloaded", "(3/3): cloudera-manager-daemons-7.11.3.36-67636 72 MB/s | 1.4 GB 00:19 ", "--------------------------------------------------------------------------------", "Total 72 MB/s | 1.4 GB 00:19 ", "Running transaction check", "Transaction check succeeded.", "Running transaction test", "Transaction test succeeded.", "Running transaction", " Preparing : 1/1 ", " Running scriptlet: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 1/1 ", " Running scriptlet: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 1/6 ", "+=================================================================+", "| WARNING: ptrace_scope is disabled. Please enable ptrace before |", "| continuing with Cloudera Manager upgrades. |", "| |", "| To disable check for ptrace_scope, use the below and try again: |", "| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |", "+=================================================================+", "error: %prein(cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1", "", " Running scriptlet: cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 2/6 ", "error: cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64: install failed", "+=================================================================+", "| WARNING: ptrace_scope is disabled. Please enable ptrace before |", "| continuing with Cloudera Manager upgrades. |", "| |", "| To disable check for ptrace_scope, use the below and try again: |", "| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |", "+=================================================================+", "error: %prein(cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1", "", " Running scriptlet: cloudera-manager-server-7.11.3.36-67636814.el8.x86_6 3/6 ", "error: cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64: install failed", "+=======================================================================+", "| WARNING: Upgrading to this version of Cloudera Manager is only |", "| supported with a valid Cloudera Enterprise or Cloudera Data Platform |", "| (CDP) license. If you are using Cloudera Express, a Trial license or |", "| an expired Cloudera Enterprise / CDP license, please roll back to an |", "| older version of Cloudera Manager. |", "+=======================================================================+", "+=================================================================+", "| WARNING: ptrace_scope is disabled. Please enable ptrace before |", "| continuing with Cloudera Manager upgrades. |", "| |", "| To disable check for ptrace_scope, use the below and try again: |", "| $ sudo touch /tmp/CLOUDERA_SKIP_PTRACE_CHECK_ON_UPGRADES |", "+=================================================================+", "error: %prein(cloudera-manager-server-7.11.3.36-67636814.el8.x86_64) scriptlet failed, exit status 1", "", " Verifying : cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 1/6 ", " Verifying : cloudera-manager-agent-7.6.1-28822345p.el8.x86_64 2/6 ", " Verifying : cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_ 3/6 ", " Verifying : cloudera-manager-daemons-7.6.1-28822345p.el8.x86_64 4/6 ", " Verifying : cloudera-manager-server-7.11.3.36-67636814.el8.x86_6 5/6 ", " Verifying : cloudera-manager-server-7.6.1-28822345p.el8.x86_64 6/6 ", "Installed products updated.", "", "Failed:", " cloudera-manager-agent-7.6.1-28822345p.el8.x86_64 ", " cloudera-manager-agent-7.11.3.36-67636814.el8.x86_64 ", " cloudera-manager-daemons-7.6.1-28822345p.el8.x86_64 ", " cloudera-manager-daemons-7.11.3.36-67636814.el8.x86_64 ", " cloudera-manager-server-7.6.1-28822345p.el8.x86_64 ", " cloudera-manager-server-7.11.3.36-67636814.el8.x86_64 "]} 是什么问题。
最新发布
08-02
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值