ERROR 1158 (08S01): Leaf Error (): Error reading packet ### from the connection socket (): Connection timed out

Issue

The presence of extremely large numbers of duplicates in combination with LOAD DATA IGNORE can cause the leaves to have to wait so long they time out.

Solution

If you see this error when running LOAD DATA IGNORE, verify that the data does not have a lot of duplicates.