I have received MySQL error 1160 'error writing communication packets'. I have a stored procedure that does this: Step 1: compares the data from two tables and
insert into a tmp table. Step 2: Results from tmp table will then copied over to a table with FEDERATED engine. This Federated table is connected to another table on a different server.I wish to know if there is anything wrong with step 1 or 2 from above that may cause this error? The error does notalways pop up. Once in a while it will pop up but is random. I also wish
to know if this error will cause major data integrity issue or errors in my data.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!