Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No heartbeat and restart on MySQL 5.1.54 #373

Closed
abo opened this issue Jul 5, 2016 · 1 comment · Fixed by #385
Closed

No heartbeat and restart on MySQL 5.1.54 #373

abo opened this issue Jul 5, 2016 · 1 comment · Fixed by #385

Comments

@abo
Copy link

abo commented Jul 5, 2016

MySQL 5.1.54,JDK 1.8

bin/maxwell --host='192.168.1.106' --user='xxx' --password='xxx' --producer=stdout --include_dbs='web'

Replicator restart again and again:

15:02:30,218 INFO  TransportImpl - connecting to host: 192.168.1.106, port: 3306
15:02:30,346 INFO  TransportImpl - connected to host: 192.168.1.106, port: 3306, context: AbstractTransport.Context[threadId=19,scramble=wk4aiooauLZ^J7r[PasB,protocolVersion=10,serverHost=192.168.1.106,serverPort=3306,serverStatus=2,serverCollation=33,serverVersion=5.1.54-log,serverCapabilities=63487]
15:02:30,347 INFO  AuthenticatorImpl - start to login, user: webcast, host: 192.168.1.106, port: 3306
15:02:30,352 INFO  AuthenticatorImpl - login successfully, user: webcast, detail: OKPacket[packetMarker=0,affectedRows=0,insertId=0,serverStatus=2,warningCount=0,message=<null>]
15:02:31,108 DEBUG MysqlPositionStore - Writing binlog position to maxwell.positions: BinlogPosition[mysql-bin.000045:515930]
15:02:33,194 WARN  MaxwellReplicator - no heartbeat heard from server in 2042ms.  restarting replication.
15:02:33,195 INFO  TransportImpl - disconnected from 192.168.1.106:3306
15:02:33,196 INFO  TransportImpl - connecting to host: 192.168.1.106, port: 3306
15:02:33,214 INFO  TransportImpl - connected to host: 192.168.1.106, port: 3306, context: AbstractTransport.Context[threadId=20,scramble=Z7A$,R9eq(r&dEnw/"Z#,protocolVersion=10,serverHost=192.168.1.106,serverPort=3306,serverStatus=2,serverCollation=33,serverVersion=5.1.54-log,serverCapabilities=63487]
15:02:33,214 INFO  AuthenticatorImpl - start to login, user: webcast, host: 192.168.1.106, port: 3306
15:02:33,419 INFO  AuthenticatorImpl - login successfully, user: webcast, detail: OKPacket[packetMarker=0,affectedRows=0,insertId=0,serverStatus=2,warningCount=0,message=<null>]
15:02:33,519 WARN  MaxwellReplicator - Started replication stream outside of transaction.  This shouldn't normally happen.
15:02:35,578 WARN  MaxwellReplicator - no heartbeat heard from server in 2059ms.  restarting replication.
15:02:35,579 INFO  TransportImpl - disconnected from 192.168.1.106:3306
15:02:35,580 INFO  TransportImpl - connecting to host: 192.168.1.106, port: 3306
15:02:35,665 INFO  TransportImpl - connected to host: 192.168.1.106, port: 3306, context: AbstractTransport.Context[threadId=21,scramble=u6JQ8er04T,|OU<k'}bR,protocolVersion=10,serverHost=192.168.1.106,serverPort=3306,serverStatus=2,serverCollation=33,serverVersion=5.1.54-log,serverCapabilities=63487]
15:02:35,665 INFO  AuthenticatorImpl - start to login, user: webcast, host: 192.168.1.106, port: 3306
15:02:35,667 INFO  AuthenticatorImpl - login successfully, user: webcast, detail: OKPacket[packetMarker=0,affectedRows=0,insertId=0,serverStatus=2,warningCount=0,message=<null>]
15:02:36,160 DEBUG MysqlPositionStore - Writing binlog position to maxwell.positions: BinlogPosition[mysql-bin.000045:516212]
15:02:38,226 WARN  MaxwellReplicator - no heartbeat heard from server in 2056ms.  restarting replication.
15:02:38,227 INFO  TransportImpl - disconnected from 192.168.1.106:3306
@osheroff
Copy link
Collaborator

osheroff commented Jul 9, 2016

buh, it wasn't clear to me that replication heartbeating was a 5.5+ feature. will have to code an off-switch for 5.1

osheroff pushed a commit that referenced this issue Jul 14, 2016
osheroff pushed a commit that referenced this issue Jul 14, 2016
This is a bugfix release, which fixes:
- #376, a problem parsing
  RENAME INDEX
- #371, a problem with the
  SERIAL datatype
- #362, we now preserve the
  original casing of columns
- #373, we were incorrectly
  expecting heartbeats to work under 5.1
osheroff pushed a commit that referenced this issue Jul 14, 2016
This is a bugfix release, which fixes:
- #376, a problem parsing
  RENAME INDEX
- #371, a problem with the
  SERIAL datatype
- #362, we now preserve the
  original casing of columns
- #373, we were incorrectly
  expecting heartbeats to work under 5.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants