Comments (2)
也碰到了类似的情况
server 搭好了,客户端代码使用的是 sample
最后在 mysql 中 insert 或者 update,客户端打印出来的如下
================> binlog[mysql-bin.000013 : 4720],name[canal,user], eventType: 2 update user set
age=302 where
name='title'
查看了 example 和 canal 下的日志
example 下只有
2020-10-09 11:33:23.768 [MultiStageCoprocessor-other-example-0] WARN c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - dup apply for sql : create table if not exists user( name char(24), age int(8) ) 2020-10-09 11:34:13.304 [New I/O server worker #1-1] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 11:34:13.304 [New I/O server worker #1-1] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 15:01:48.521 [New I/O server worker #1-2] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 15:01:48.535 [New I/O server worker #1-2] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 15:21:43.401 [New I/O server worker #1-1] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 15:21:43.402 [New I/O server worker #1-1] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 15:22:37.589 [New I/O server worker #1-2] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 15:22:37.589 [New I/O server worker #1-2] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 15:23:20.347 [New I/O server worker #1-1] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 15:23:20.347 [New I/O server worker #1-1] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 16:14:09.370 [New I/O server worker #1-2] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 16:14:09.375 [New I/O server worker #1-2] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$ 2020-10-09 16:21:56.942 [New I/O server worker #1-1] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - subscribe filter change to .*\..* 2020-10-09 16:21:56.942 [New I/O server worker #1-1] WARN c.a.o.canal.parse.inbound.mysql.dbsync.LogEventConvert - --> init table filter : ^.*\..*$
canal.log下没有报错信息
from canal-php.
已经解决了,MySQL 配置 binlog-format 的问题,配置了 /etc/my.cnf 之后重启并没有生效,在 mysql 客户端中才检查出来。
配置之后就能够拿到,需要注意的是 mysql 的配置有 global 和 session 两个级别。
from canal-php.
Related Issues (20)
- $client->connect($canalHost, $canalPort) HOT 1
- 启动 两个或以上的任务 为什么不能监控成功
- Connection reset by peer HOT 3
- 请问支持 HA 吗?
- 默认案例配置,运行时间久了就提示:Socket operation failed: Broken pipe (SOCKET_EPIPE) HOT 1
- 能够拿到sql,但是RowData为空 HOT 1
- 不能同步mysql blob类型的字符串数据 HOT 1
- 拉取消息提示packet type=CLIENTAUTHENTICATION is NOT supported! HOT 4
- unpack(): Type N: not enough input, need 4, have 0 HOT 1
- Fmt::println 里的 $rowChange->getSql() sql语句为什么没有打印出来呢 HOT 1
- 如何获取 thread_id ?
- 如何获取 thread_id ?
- PHP Warning: unpack(): Type N: not enough input, need 4, have 0 in HOT 1
- 测试成功了,但是没有答应出SQL 语句 HOT 2
- 消费失败导致canal-php退出,重启后无法继续消费可以如何处理? HOT 1
- 总是提示 Socket operation failed:Broken pipe(SOCKET_EPIPE) php fatal error: Uncaught Socket\Raw\Exception:Socket operation failed:Broken pipe(SOCKET_EPIPE) in vendor/clue/socket-raw/src/Exception.php:59 HOT 1
- 类CanalClient找不到,demo跑不起来
- 请问我可以查询到队列里的条数吗?
- 我使用您的项目连接不上 HOT 1
- 执行一段时间 一直报 batchId:1007 is not the firstly:854
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 canal-php.