Skip to content

部分配置情况下开启主从复制线程会导致服务hang住 #146

Description

@cnjiang334

5.7版本下,在集群中同时存在duckdb表和innodb表时且参数配置为duckdb_multi_trx_in_batch=OFF
duckdb_source_set_insert_only_to_binlog=OFF
duckdb_dml_in_batch=OFF
slave_parallel_workers=18
slave_preserve_commit_order=1 时开启主从复制线程会导致服务hang住,原因可能为duckdb事务提交破坏了事务提交顺序,在slave_preserve_commit_order=1时会死锁hang住,在slave_preserve_commit_order=0时不会hang住,但是会导致事务空洞,开启攒批有关参数时则不会,原因应该是开启攒批参数slave_parallel_workers失效,不会死锁

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions