[ bug ]V1.7.13，工具插件中的binlog2sql功能异常

[yuandajn578]

在提交 issue 前，请查阅以下资源，请先进行搜索来保证没有类似的 issue。
文档 | FAQ

重现步骤

版本信息

应用版本/分支：

部署方式：Docker、手工部署

[zhituanchen]

请问这个有解决方法么

[zhituanchen]

我之前是同步过lickhouse-mysql-data报错的：
处理方法：
docker exec -it archery bash
cd /opt/venv4archery/lib/python3.6/site-packages/pymysql
vi charset.py
后面添加：
#TODO: remove this
def charset_to_encoding(name):
"""Convert MySQL's charset name to Python's codec name"""
if name in ('utf8mb4', 'utf8mb3'):
return 'utf8'
return name

docker stop archery
docker start archery
然后出现其他报错，继续查看中......：

[zhituanchen]

查看：danfengcao/binlog2sql#66
安装PyMySQL==0.9.3即可：
步骤：
docker exec -it archery bash
source /opt/venv4archery/bin/activate
pip list
PyMySQL 0.10.0
(venv4archery) [root@00111dac9d42 archery]# pip uninstall PyMySQL
Found existing installation: PyMySQL 0.10.0
Uninstalling PyMySQL-0.10.0:
Would remove:
/opt/venv4archery/lib/python3.6/site-packages/PyMySQL-0.10.0.dist-info/*
/opt/venv4archery/lib/python3.6/site-packages/pymysql/*
Proceed (y/n)? y
Successfully uninstalled PyMySQL-0.10.0
(venv4archery) [root@00111dac9d42 archery]# pip install PyMySQL==0.9.3
Collecting PyMySQL==0.9.3
Downloading PyMySQL-0.9.3-py2.py3-none-any.whl (47 kB)
|████████████████████████████████| 47 kB 38 kB/s
Installing collected packages: PyMySQL
Successfully installed PyMySQL-0.9.3
(venv4archery) [root@00111dac9d42 archery]# pip list
PyMySQL 0.9.3
(venv4archery) [root@00111dac9d42 archery]# exit
exit
[root@mytestuse ~]# docker stop archery
archery
[root@mytestuse ~]# docker start archery
archery
[root@mytestuse ~]#
解析binlog：

[yuandajn578]

多谢多谢！ 发自我的iPhone

…

------------------ 原始邮件 ------------------ 发件人: zhituanchen <notifications@github.com&gt; 发送时间: 2020年10月13日 18:34 收件人: hhyo/Archery <Archery@noreply.github.com&gt; 抄送: yuandajn578 <12173670@qq.com&gt;, Author <author@noreply.github.com&gt; 主题: 回复：[hhyo/Archery] [ bug ]V1.7.13，工具插件中的binlog2sql功能异常 (#899) 查看：danfengcao/binlog2sql#66 安装PyMySQL==0.9.3即可： 步骤： docker exec -it archery bash source /opt/venv4archery/bin/activate pip list PyMySQL 0.10.0 (venv4archery) [root@00111dac9d42 archery]# pip uninstall PyMySQL Found existing installation: PyMySQL 0.10.0 Uninstalling PyMySQL-0.10.0: Would remove: /opt/venv4archery/lib/python3.6/site-packages/PyMySQL-0.10.0.dist-info/* /opt/venv4archery/lib/python3.6/site-packages/pymysql/* Proceed (y/n)? y Successfully uninstalled PyMySQL-0.10.0 (venv4archery) [root@00111dac9d42 archery]# pip install PyMySQL==0.9.3 Collecting PyMySQL==0.9.3 Downloading PyMySQL-0.9.3-py2.py3-none-any.whl (47 kB) |████████████████████████████████| 47 kB 38 kB/s Installing collected packages: PyMySQL Successfully installed PyMySQL-0.9.3 (venv4archery) [root@00111dac9d42 archery]# pip list PyMySQL 0.9.3 (venv4archery) [root@00111dac9d42 archery]# exit exit [root@mytestuse ~]# docker stop archery archery [root@mytestuse ~]# docker start archery archery [root@mytestuse ~]# 解析binlog： — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[hhyo]

感谢定位，应该是新版本升级了依赖导致，可以提交pr修改下

[mawenbin666]

查看：danfengcao/binlog2sql#66
安装PyMySQL==0.9.3即可：
步骤：
docker exec -it archery bash
source /opt/venv4archery/bin/activate
pip list
PyMySQL 0.10.0
(venv4archery) [root@00111dac9d42 archery]# pip uninstall PyMySQL
Found existing installation: PyMySQL 0.10.0
Uninstalling PyMySQL-0.10.0:
Would remove:
/opt/venv4archery/lib/python3.6/site-packages/PyMySQL-0.10.0.dist-info/*
/opt/venv4archery/lib/python3.6/site-packages/pymysql/*
Proceed (y/n)? y
Successfully uninstalled PyMySQL-0.10.0
(venv4archery) [root@00111dac9d42 archery]# pip install PyMySQL==0.9.3
Collecting PyMySQL==0.9.3
Downloading PyMySQL-0.9.3-py2.py3-none-any.whl (47 kB)
|████████████████████████████████| 47 kB 38 kB/s
Installing collected packages: PyMySQL
Successfully installed PyMySQL-0.9.3
(venv4archery) [root@00111dac9d42 archery]# pip list
PyMySQL 0.9.3
(venv4archery) [root@00111dac9d42 archery]# exit
exit
[root@mytestuse ~]# docker stop archery
archery
[root@mytestuse ~]# docker start archery
archery
[root@mytestuse ~]#
解析binlog：

pymysql==0.93 支持mysql 8.0 的版本吗？

[zhituanchen]

Hi:
从实验看是可以的，数据库测试版本：docker mysql 8.0.21;
具体查看：https://github.com/danfengcao/binlog2sql的查看相关issues