question

iain-frisealach avatar image
iain-frisealach asked

MYSQL ERROR 1160 error

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.
mysqlerror-messageerror
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sorry but this forum is best suited for any queries related to MS SQL Server. For solutions on MySQL, you may wish to try any of the MySQL dedicated forums.
3 Likes 3 ·

1 Answer

·
AdrienMeilleur avatar image
AdrienMeilleur answered
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][1] [ https://www.fixtoolbox.com/repairtoolformysql.html][2] [ http://www.filerepairforum.com/forum/databases/databases-aa/mysql][3] I hope i could help you Good luck! [1]: https://groups.google.com/forum/?hl=en#!topic/mysql-repair/16ibF_g3dYg [2]: https://www.fixtoolbox.com/repairtoolformysql.html [3]: http://www.filerepairforum.com/forum/databases/databases-aa/mysql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.