Site5 Q&A » MYSQL ERROR 1160 error

MYSQL ERROR 1160 error

In: MySQL Asked By: AlbanMaurice [2

]

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

3 Answers Answer this Question Now

May 5, 2015

Answer #1

Hello,

The error you are describing is a complex one, and your best bet would be to contact our support team via a ticket, entered in Backstage. We will need to take a closer look at what is happening to determine the cause.

Answered By: jdavey [359

]

Answer #2

Hello!

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).

Did you checked the link provided its majorly timeout issue

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 this issue is discussed on these sites below. Check them:

https://groups.google.com/forum/?hl=en#!topic/mysql-repair/16ibF_g3dYg
https://www.fixtoolbox.com/repairtoolformysql.html
http://www.filerepairforum.com/forum/databases/databases-aa/mysql

I hope i could help you

Good luck!

Answered By: enomoto [2

]

Answer #3

Thanks for answer!

Answered By: AlbanMaurice [2

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »