:DTS-1051003: the MySQL log Reader binlog_format verification failed

Problem description

DTS reports a DTS-1051003 error. The following error message is returned: Where insert into table_name values( 1,2,3) is the corresponding DML statement.

DTS-1051003 Found statement format binary, SQL: insert into table_name values(1,2,3).

Cause

Currently, the Binlog format of DTS incremental migration and synchronization is ROW and the binlog_row_image is FULL. You can run the following SQL statement to view the Binlog log format.

show variables like 'binlog_format'; 
show variables like 'binlog_row_image';

Solution

1. Run the following SQL statement to set the Binlog format to ROW:

   set global binlog_format='ROW';

2. Run the following SQL statement to check existing sessions:
   

   show processlist

3. Run the following SQL statement to terminate the session:
   

   kill [$ID]

   Note:[$ID] indicates the session ID obtained in the previous step.

Application scope

• Data Transmission Service (DTS)