maxwell常见问题

发布时间 2023-12-19 13:25:25作者: DogLeftover
  • 错误描述
# 启动maxwell,jps查看没有显示maxwell的进程
/opt/software/maxwell/bin/maxwell --config /opt/software/maxwell/config.properties --daemon

# 使用前台启动
/opt/software/maxwell/bin/maxwell --config /opt/software/maxwell/config.properties
# 显示如下
2083 [INFO] TaskManager: Stopping 4 tasks
2084 [ERROR] TaskManager: cause: 
java.lang.RuntimeException: error: unhandled character set 'utf8mb3'
	at com.zendesk.maxwell.schema.columndef.StringColumnDef.charsetForCharset(StringColumnDef.java:61) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.schema.columndef.StringColumnDef.asJSON(StringColumnDef.java:75) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorEvent.writeData(BinlogConnectorEvent.java:112) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorEvent.buildRowMap(BinlogConnectorEvent.java:162) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorEvent.jsonMaps(BinlogConnectorEvent.java:191) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getTransactionRows(BinlogConnectorReplicator.java:486) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:626) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:178) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:255) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.Maxwell.start(Maxwell.java:183) ~[maxwell-1.29.2.jar:1.29.2]
	at com.zendesk.maxwell.Maxwell.main(Maxwell.java:286) ~[maxwell-1.29.2.jar:1.29.2]
  • 解决方案
# 方法1:降低mysql的版本为5.7
# 方式2:将maxwell-1.29.2.jar替换到
mv maxwell-1.29.2.jar /opt/software/maxwell/lib