I faced the issue with PutdatabaseRecord. This processor always delete miss some record, just some records. Could you help me give some advise >>>
Looks like there is on a table 2 or more PRIMERY_KEY columns.
You can check it with:
SHOW CREATE TABLE MYSQL_TABLE_NAME
The Problem occurs if the same value is entered for several primary key columns.
So you have to remove some of them
Thanks for your response.
But it have only 1 primary key on my table and as i checked, just some id are not deleted @@.
Now i use PutSQL instead of PutdatabaseRecord to delete these records, it work well.