How Do I Fix Mysql Error 1160 Error?

Question

0.00/5 (No votes)

See more:

Hello.
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 not always 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.

Posted 11-Mar-15 4:42am

RoccoBraiden

Add a Solution

Comments

ZurdoDev 11-Mar-15 11:42am

I'd suggest googling the error.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TasSt · Accepted Answer · 2015-03-11T09:29:00

Issue may happen even if FEDERATED tables are not actually replicated (FEDERATED turned ON, but database which contains FEDERATED tables excluded using any of the repliate* or binlog* do/ignore options).
I would try increasing (temporarily) your net_read_timeout, net_write_timeout, and max_allowed_packet variables. When reloading a mysqldump file dies, it's generally caused by one of those.
Inserting too many data can even give you the error
Try to set the max_allowed_packet to 256M, you can add it to /etc/my.cnf or my.ini
[mysqld]
max_allowed_packet=256M

SET GLOBAL max_allowed_packet = 1024 * 1024 * 256;

Also i recommend you to read comments on this forum:

http://www.filerepairforum.com/forum/databases/databases-aa/mysql/713-%E2%80%8Bhow-to-fix-a-corrupted-server-configuration-in-mysql[^]