Skip to content

a error con't be solved #19

@dengdajun

Description

@dengdajun

java.lang.RuntimeException: ErrorPacket[packetMarker=255,errorCode=1236,slash=#,sqlState=HY000,errorMessage=Slave can not handle replication events with the checksum that master is configured to log; the first event 'mysql-bin-log.000001' at 4, the last event read from 'D:\MySql\mysql-5.6.6-m9-winx64\log\mysql-bin-log.000001' at 120, the last byte read from 'D:\MySql\mysql-5.6.6-m9-winx64\log\mysql-bin-log.000001' at 120.]
at com.google.code.or.binlog.impl.ReplicationBasedBinlogParser.doParse(ReplicationBasedBinlogParser.java:100)
at com.google.code.or.binlog.impl.AbstractBinlogParser$Task.run(AbstractBinlogParser.java:244)
at java.lang.Thread.run(Thread.java:748)

this is my pom.xml


open-replicator
open-replicator
1.0.7


ch.qos.logback
logback-classic


ch.qos.logback
logback-core


ch.qos.logback
logback-core


org.slf4j
slf4j-api




org.codehaus.groovy
groovy-all
2.3.11


ch.qos.logback
logback-classic
1.2.3


com.google.code.gson
gson
2.8.1


mysql
mysql-connector-java
5.1.44

and coding just like your usage;
mysql version is 5.6.6
and my.ini config is
[mysql]

设置mysql客户端默认字符集

default-character-set=utf8
[mysqld]
#skip-grant-tables
#设置3306端口
port = 3306

设置mysql的安装目录

basedir=D:\MySql\mysql-5.6.6-m9-winx64

设置mysql数据库的数据的存放目录

datadir=D:\MySql\mysql-5.6.6-m9-winx64\data

log_bin=D:\MySql\mysql-5.6.6-m9-winx64\log\mysql-bin-log
server-id=1
binlog-format = row

允许最大连接数

max_connections=200

服务端使用的字符集默认为8比特编码的latin1字符集

character-set-server=utf8

创建新表时将使用的默认存储引擎

default-storage-engine=INNODB
collation-server=utf8_general_ci

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions