[Bug] hot standby, with remote_apply level, it will cause dead lock in test_repo

[tuhaihe]

Cloudberry Database version

main

What happened

with the remote_apply level of synchronous_commit, enable hot_standby. Query the table on the standby while altering the table on the master it may cause deadlock.

What you think should happen instead

No response

How to reproduce

/home/gpadmin/workspace/cbdb_testrepo/test_framework/tinc.py discover mpp/common
GPToolKit.test_concurrent_heap

Operating System

Default

Anything else

No response

Are you willing to submit PR?

• [ ] Yes, I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct.