How do I query the verification result files of the Checker component of OMS?

This topic describes how to find the verification result files of the Checker component of OceanBase Migration Service (OMS). The result files can be divided into .diff files and .sql files. A .diff file stores the inconsistent records identified through verification, and an .sql file stores the revised SQL statements to be executed on the destination.

Run the following command to log on to the Docker container of OMS:

# Obtain the name of the OMS Docker container.
sudo docker ps
# Assume that the name of the OMS Docker container is oms. Enter the Docker container.
sudo docker exec -it oms bash

• Location of .diff files:

  /home/ds/run/{ID of the checker}/verify/{subId}/{dbname}/diff/{table_name}.diff

  {}Variable	Description
  ID of the checker	For more information, see How do I query the ID of a checker.
  subId	Run grep "task.subId" /home/ds/run/{ID of the checker}/conf/checker.conf to obtain the ID.
  dbname	The name of the source database owner or schema.
  table_name	The name of the table.

• Location of .sql files:

  /home/ds/run/{ID of the checker}/verify/{subId}/{dbname}/sql/{table_name}.sql

  {}Variable	Description
  ID of the checker	For more information, see How do I query the ID of a checker.
  subId	Run grep "task.subId" /home/ds/run/{ID of the checker}/conf/checker.conf to obtain the ID.
  dbname	The name of the source database owner or schema.
  table_name	The name of the table.