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

gtid= orgSql=内容显示不完整 #1

Open
jimsoft1000 opened this issue Nov 16, 2023 · 6 comments
Open

gtid= orgSql=内容显示不完整 #1

jimsoft1000 opened this issue Nov 16, 2023 · 6 comments

Comments

@jimsoft1000
Copy link

使用my2sql解析binlog日志之后
-- datetime=2023-11-15_09:46:00 database=test table=test_log binlog=binlog.000016 startpos=291074778 stoppos=291076022 gtid= orgSql=
这里的gtid和orgSql没有内容显示

@fulldb
Copy link
Owner

fulldb commented Mar 5, 2024

可以分享下你的数据库版本和使用的配置文件吗?我测试一下,看看有空的时候能不能复现并修正下。

@fulldb
Copy link
Owner

fulldb commented Apr 25, 2024

猜测可能是没有设置
binlog_rows_query_log_events = 1

@jimsoft1000
Copy link
Author

猜测可能是没有设置 binlog_rows_query_log_events = 1

我配置一下这个参数,测试一下,很有可能

@hellobob
Copy link

我的版本是mysql5.7.26
参数也是binlog_rows_query_log_events=on的
但是也是gtid= orgSql= 这样的

@hellobob
Copy link

log-bin = /export/data/mysql/bin-logs/mysql-bin
relay-log = /export/data/mysql/relay-logs/relay-bin
relay-log-index = /export/data/mysql/relay-logs/relay-bin.index

MySQL 5.7 does not enable the binary log by default, and

binlog_format = row
log-bin = /export/data/mysql/bin-logs/mysql-bin
sync_binlog = 1
relay-log = /export/data/mysql/relay-logs/relay-bin
relay-log-index = /export/data/mysql/relay-logs/relay-bin.index
log_bin_trust_function_creators = 1
binlog_rows_query_log_events =on
binlog_row_image = full

@fulldb
Copy link
Owner

fulldb commented May 30, 2024

可以提供下你使用my2sql的命令行文本吗?连接信息记得用xxx等代替。

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

No branches or pull requests

3 participants