Help Center/ Data Replication Service/ FAQs/ Data-Level Comparison/ What Do I Do If the Query Process of the Comparison Task Is Not Stopped After a DRS Comparison Task Is Canceled?
Updated on 2024-11-30 GMT+08:00

What Do I Do If the Query Process of the Comparison Task Is Not Stopped After a DRS Comparison Task Is Canceled?

Take the source MySQL database as an example. You created a row comparison task and cancelled the task later. If the query process of the comparison task in the source database is not stopped in a timely manner, perform the following steps to kill the residual process:

  1. Log in to the MySQL database as an administrator and run the show processlist command.
  2. Obtain the process ID based on Host and Command. The value of Host is the IP address of the DRS task node, and the value of Command is the query statement starting with select count (1).
  3. If the ID obtained in step 2 is 112773, run the kill 112773 command.
  4. Run the show processlist command to check whether the residual process is deleted.