Comments (10)
@whhe
太感谢了,用你的代码可以了。
这次是我的问题,我在配置数据表时配错了,原来配置表时只需要写表名就行了,我给写成库名,表名了。
现在成功跳过xa事务,任务跑起来了。
最后再次感谢你的帮助,周末愉快。
from otter.
我用master编译成4.2.19版本后,还是不支持xa事务。
from otter.
目前是不支持XA的,你看看 #1129 能不能跳过
from otter.
目前是不支持XA的,你看看 #1129 能不能跳过
好的,我重新编译试一下
from otter.
from otter.
我这么写也不对,反而编译不过去了:
EventType eventType = EventType.valueOf(rowChange.getEventType().name());
if (eventType == "XACOMMIT" ) {
logger.warn("Discard unsupported event type: {}", rowChange.getEventType());
return null;
}
from otter.
我的错,这里要判断名字。我更新了下,再试试
from otter.
感谢回复,我用了你第二次的代码编译后,还是把所有的event全部跳过了,最终导致一条数据都没有同步过来。
我确认我的binlog position设置是对的,并且position后面有新增数据,因为我可用my2sql工具能解析出具体新增sql。
我用的这个代码编译的:https://github.com/whhe/otter/tree/discard-unsupported-event
from otter.
感谢回复,我用了你第二次的代码编译后,还是把所有的event全部跳过了,最终导致一条数据都没有同步过来。 我确认我的binlog position设置是对的,并且position后面有新增数据,因为我可用my2sql工具能解析出具体新增sql。
我用的这个代码编译的:https://github.com/whhe/otter/tree/discard-unsupported-event
跳过的时候有打印日志吗?Discard unsupported event type
这个
理论上新加的这个过滤只会丢弃 GTID, XACOMMIT, XAROLLBACK, MHEARTBEAT
这四种
from otter.
有日志,我应该怎么排错
2024-05-25 12:14:17.810 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:17.816 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:17.816 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:36.160 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:36.160 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:36.160 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:55.164 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:55.164 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:14:55.165 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:15:00.899 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:15:00.899 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
2024-05-25 12:15:00.899 [pipelineId = 6,taskName = ProcessSelect] WARN com.alibaba.otter.node.etl.select.selector.MessageParser - Discard unsupported event type: XACOMMIT
from otter.
Related Issues (20)
- 我的线程正常但是监控出了问题,不更新位点信息了 HOT 1
- canal客户端连接otter服务端 HOT 1
- 使用canal每次拉取的binlog日志时间比当前时间慢
- Otter改造 增加springboot模块和HTTP调用功能 HOT 1
- otter能根据唯一索引同步吗?想规避自增主键冲突的问题 HOT 2
- nid有更高效的设置方式吗?现在每部署一个node之前先在manager增加nid,部署多个node容器很不方便
- 突然让manager所在主机重启后,再次打开web界面会出现问题,会显示503 HOT 3
- zookeeper升级到3.7.2会有问题吗
- otter怎么支持kakfa作为binlog缓存?
- otter能支持XA事务吗 HOT 3
- 首页的原理图无法展示,验签失败了
- otter延迟情况下这个row_select日志正常么 HOT 2
- 有办法监听到数据的变化, 然后做相应的操作吗? HOT 1
- otter如何进行zookeeper版本升级
- retl密码问题 HOT 4
- 登陆管理页面报错:HTTP ERROR 500 HOT 1
- 如何多个otter集群共用相同的zk?
- 主备机房双向同步配置,主机房A故障切换到机房B,故障恢复,切换回到机房A,故障期间机房B产生的变更数据,机房A可以追上机房B吗? HOT 1
- otter开启tsdb报错 ClassNotFoundException
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from otter.