Batch deleting nodes breaks database
You need to increase max_allowed_packets in my.cnf file. to insert big data from cache tables. The best practice to avoid this is, never export cache prefixed tables data.