Failed to prepare TableSyncChunk plugin: Cannot chunk table `ccda`.`pending_0` using the character c
来源:互联网 发布:linux 修改主机名 编辑:程序博客网 时间:2024/05/18 03:39
当我用pt-table-sync命令--print或者--execute时,报如下错误:
[root@PC ~]# pt-table-sync --replicate=ccda.checksums --tables=pending_0 --charset=utf8 h=127.0.0.1,u=root,p=system@123 h=192.168.1.202 u=root,p=system@123 --port 3307 --print > /download/diff.log
Failed to prepare TableSyncChunk plugin: Cannot chunk table `ccda`.`pending_0` using the character column _id, most likely because all values start with the same character. This table must be synced separately by specifying a list of --algorithms without the Chunk algorithm at /usr/local/bin/pt-table-sync line 4049. while doing ccda.pending_0 on 192.168.1.202
而且,我发现,当差异量小时,并不报该错误。差异量大时,才报了这个错误。
虽然报错,但是用--execute发现,实际上也同步了大部分数据,会丢失部分数据。比如,我测试的表差异数据应该是45万条记录,但是发现只同步了34万数据。
pt-table-sync --help
查看algorithms
--algorithms=s Algorithm to use when comparing the tables, in
order of preference (default Chunk,Nibble,GroupBy,
Stream)
--解决办法:
用Nibble算法同步(其他算法我没有试验,不知是否可行)。
pt-table-sync --algorithms=Nibble --replicate=ccda.checksums --tables=pending_0 --charset=UTF8 h=127.0.0.1,u=root,p=system@123 h=192.168.1.202 u=root,p=system@123 --port 3307 --execute
--注意:--charset=UTF8最好指定是大写的UTF8,因为我发现在有的机器上指定了小写的utf8,还是会出现中文乱码。
- Failed to prepare TableSyncChunk plugin: Cannot chunk table `ccda`.`pending_0` using the character c
- Using the HybridFox plugin to manage Openstack Nova
- Error: Failed to load plugin angular: Cannot find module 'eslint-plugin-angular'
- Using the NDK plugin
- Using the NDK plugin
- Using the NDK plugin
- from c to c++: using the boolean
- 关于解决 Failed to prepare partial IU:
- How to prepare the Good Presenation
- php 5.3:connection failed:SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using old auth
- How to sovle "tableExistException when creating hbase table" but cannot show the table by "list" in
- [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- Can't open the mysql.plugin table. Please run mysql_upgrade to create it
- Mysql :Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- Adb failed to restart! Make sure the plugin is properly configured.
- Adb failed to restart! Make sure the plugin is properly configured. .
- This application failed to start because it could not find or load the Qt platform plugin
- This application failed to start because it could not find or load the Qt platform plugin “...
- How to: Create and Initialize Trace Listeners
- UIButton中setTitleEdgeInsets和setImageEdgeInsets的使用
- 什么时候该用成员变量、什么时候用方法变量?
- Swift3中方法可变参数语法的一些改变
- Swift3中方法可变参数语法的一些改变
- Failed to prepare TableSyncChunk plugin: Cannot chunk table `ccda`.`pending_0` using the character c
- 研究网络标准组织
- 【poj】3687 Labeling Balls【拓扑排序】
- 显示串行接口时,常见以下几种状态
- 如何使用RecyclerView
- 初始配置配置 IPv6 并检验连通性
- HTML表单标签属性
- 初始化并重新加载路由器和交换机
- Integer