MYSQL 1160 error: Can someone help me out?

15 pts.
Tags:
MySQL
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 notalways 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.


Software/Hardware used:
MySQL
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • AvanNs
    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;

    10 pointsBadges:
    report
  • LuuKjed
    Thanks for reply!
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: