[xCluster][DB-Scope] Restart replication is throwing database is being accessed by other users

[agsh-yb]

Jira Link: DB-14139

Description

In current DR stress test we are facing this issue Version: 2024.2.1.0-b40 Attached logs in Jira nemesis are being performed in parallel
Currently this is only observed with 2024.2.1.0, recent run was on 2.25.0.0-b306 and it passed there

Error:

During restart replication from YBA I saw this kind of error

 Error ERROR:  database "db_scope_3" is being accessed by other users
DETAIL:  There are 5 other sessions using the database.
 occurred while cleaning up DB db_scope_3 .

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• [X] I confirm this issue does not contain any sensitive information.