MYSQL ERROR 1160 error

[Former Member]

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

Update by Moderator:
Please keep in mind that this forum is about SAP MaxDB topics, not MySQL, although you inded got a reply here concerning your question 🙂

[Former Member · Accepted solution]

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!