Null Rows with pt-table-sync

34 views
Skip to first unread message

Hiraedd

unread,
Apr 13, 2012, 10:00:15 AM4/13/12
to percona-d...@googlegroups.com


Hi all,
I'm using pt-table-sync to sync a table between two servers.
The source is a server that is acting as slave in a cluster, the destination is a standalone server.
When syncing a specific table with about 50M rows, I get a set of empty rows
at the end of the dest table. Only the id field is not null, while 
all other fields are null. 
If I use the --print option, I can see the null rows:

...
INSERT INTO `db`.`table`() VALUES () /*percona-toolkit ... lock:0 transaction:1 changing_src:0 replicate:0 bidirectional:0 ...*/; 
...
The number varies, but is around a few hundreds.


These rows appear always at the end of the table. I tried to modify the chunk-size, but so far no success.

Any idea why I get these rows and how to avoid them?

TIA

M.




Reply all
Reply to author
Forward
0 new messages