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

binlog_loader 数据 不同步 #104

Open
excel555 opened this issue Aug 21, 2018 · 7 comments
Open

binlog_loader 数据 不同步 #104

excel555 opened this issue Aug 21, 2018 · 7 comments

Comments

@excel555
Copy link

miner 已经能读取到log的更新,但是binlog_loader不会自动 把数据更新到目标库;
当我把 binlog_loader 进程杀掉,再 执行 ./binlog_loader 数据就会同步过去,这是什么原因?

@thompsonGuo
Copy link

我也遇到这个问题了

@zhangnew
Copy link

我这边操作看到的是,mysql update 一条数据,会同步过去,如果再 udpate 一次,就会卡住,log一直显示为

task x table public.xx wait for other loader sync data

你们也是这样吗

@koalas1105
Copy link

我也是碰到这个问题,怎么解决的呢?

miner 已经能读取到log的更新,但是binlog_loader不会自动 把数据更新到目标库;
当我把 binlog_loader 进程杀掉,再 执行 ./binlog_loader 数据就会同步过去,这是什么原因?

@wjzeng
Copy link
Member

wjzeng commented Jun 15, 2020

可能是每批同步过程中有bug,我排查下。

@zhonghai2810
Copy link

mysql版本5.7.30,grennplum版本greenplum-db-6.5.0-rhel7-x86_64.rpm,从mysql同步到gp时遇到同样的问题。

@wenzexie
Copy link

./binlog_loader
Adding table: mysql_use_sql
target schema is test
mysql_dbname is xwz
[binlog_loader_main] load_batch 10 row load_batch_gap 10 second
NOTICE: relation "binlog_washer_status" already exists, skipping
NOTICE: relation "binlog_load_table_status" already exists, skipping
[binlog_loader_main] begin binlog load from 0
[binlog_loader_main] applyid binlog from 0
[loader] can not get table mysql_use_sql index column name
[binlog_loader_main] thread exit, proc exit

我这里没有索引,不知道为啥会报错~

@thompsonGuo
Copy link

thompsonGuo commented Aug 22, 2022 via email

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

7 participants