search

go-mysql-org / go-mysql-elasticsearch

Sync MySQL data into elasticsearch
MIT License
4.12k stars 799 forks source link

当执行 ./bin/go-mysql-elasticsearch -config=./etc/river.toml 客户端断开连接 #275

Open ancientelves opened 6 years ago

ancientelves commented 6 years ago

当执行 ./bin/go-mysql-elasticsearch -config=./etc/river.tom 控制台会打印如下： 2018/07/13 17:37:39 INFO create BinlogSyncer with config {1001 mysql 10.247.35.252:3306 root utf8 false false false false 0 0s 0s 0} dial tcp 10.247.35.252:3306: connect: connection reset by peer 我去查看es，没有正常同步数据。请问为什么会出现这种情况，怎么解决？

ps: go版本：go1.10.3 linux/amd64 elasticsearch: elasticsearch:6.3.1

siddontang commented 6 years ago

dial tcp 10.247.35.252:3306: connect: connection reset by peer

连不上 MySQL

siddontang commented 6 years ago

Btw, can't support MySQL 8 now

ancientelves commented 6 years ago

我的mysql版本： MySQL 5.6.40-1.1.5

[Entrypoint] Starting MySQL 5.6.40-1.1.5 2018-07-13 07:49:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-07-13 07:49:21 0 [Note] mysqld (mysqld 5.6.40) starting as process 1

另外我使用客户端去连接mysql 都可以正常操作数据库

ancientelves commented 6 years ago

会不会是这个警告造成的？ Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.