Site5 - Built For Designers & Developers MENU

MYSQL ERROR 1160 error

[2 Grey Star Level]

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

Answer #1


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.

Answers Answered By: jdavey [359 Blue Star Level]

Answer #2


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


SET GLOBAL max_allowed_packet = 1024 * 1024 * 256;

Also this issue is discussed on these sites below. Check them:!topic/mysql-repair/16ibF_g3dYg

I hope i could help you

Good luck!

Answers Answered By: enomoto [2 Grey Star Level]

Answer #3

Thanks for answer!

Answers Answered By: AlbanMaurice [2 Grey Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.