Mysql Error 1159
>Description: Every 60 seconds, the replication slave gets an error 1159 from the master server. Thirty seconds later, it reconnects to the master. Then the cycle starts all over again. I have master-connect-retry=30 in the config file. Here is an extract of the replication slave's error log: 020715 12:05:33 Error reading packet from server: (server_errno=1159) 020715 12:06:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:06:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 020715 12:06:33 Error reading packet from server: (server_errno=1159) 020715 12:07:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:07:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 In between disconnections, replication *appears* to be occurring correctly, but it is rather disturbing that there seems to be some kind of communication problem between the master and slave servers. This problem did not occur in version 3.23.49, by the way. It appeared when we upgraded to 3.23.51. >How-To-Repeat: Set up a master/slave replication pair of servers. >Fix: Not known. >Submitter-Id:
Becla Email Updates: Status: Duplicate Impact on me: None Category:MySQL Server Severity:S3 (Non-critical) Version:5.0.20-BK, 5.0.19-max, 5.1.19-BK OS:Linux (RedHat Enterprise 4) Assigned to: Assigned Account Tags: federated, sr5_1 View Add Comment Files Developer Edit Submission View Progress Log Contributions [16 Mar 2006 19:48] Jacek Becla Description: Creation of a federated table consistently fails after 30 sec. I even tried to create federated http://lists.mysql.com/mysql/114580 table that points to another table that is managed by the same server. The 'source' table is empty, it is hard to believe 30 sec timeout is not sufficient. show processlist shows two queries during these 30 sec: State: creating table Info: create table f (x int) ENGINE=FEDERATED .... State: https://bugs.mysql.com/bug.php?id=18287 Opening tables Info: "SELECT * FROM `test` WHERE 1=0" The exact error is: ERROR 1434 (HY000): Can't create federated table. Foreign data src error: error: 1159 '' How to repeat: use testDB; create table test (x int); create table f (x int) ENGINE=FEDERATED CONNECTION='mysql://
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/16319529/error-1159-with-mysql-federated-table-and-one-kind-of-query and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation https://bugs.launchpad.net/bugs/1276671 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; mysql error it only takes a minute: Sign up Error #1159 with MySQL FEDERATED table and one kind of query up vote 1 down vote favorite I have one problem with FEDERATED table in MySQL. I have one server (MySQL version 5.0.51a), who serve to store client data and actually nothing more. The logic database are stored in another server (version 5.1.56), mysql error 1159 sometimes it should handle that data from first server. So the second server have one FEDERATED table, which connect to the first server. Actually, it has worked without any problems, but recently I got strange errors with this solution. Some kind of queries on second server cannot be performed correctly. For example SELECT * FROM table - doesn't work. It hangs exactly 3 minutes and then gives: Error Code: 1159 Got timeout reading communication packets Ok, I checked table on the first server and it's Ok. Then I tried some another queries to FEDERATED table and they work... For example, query like SELECT * FROM table WHERE id=x returns the result. Probably it could have problem with size of result, so I tried query with dummy WHERE-clause like SELECT * FROM table WHERE id > 0 - and it also works... Finally I found a "solution", which helped only for two days - on the first server I made a copy of table, and on second server I re-declared a new FEDERATED table with new connection string to
Assigned to Milestone Percona Server Edit Invalid Undecided Unassigned Edit You need to log in to change this bug's status. Affecting: Percona Server Filed here by: Andrew Ernst When: 2014-02-05 Completed: 2014-02-06 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Ubuntu Linaro Evaluation Build Ubuntu RTM Package (Find…) Project (Find…) Status Importance Invalid Undecided Assigned to Nobody Me Comment on this change (optional) Email me about changes to this bug report Also affects project (?) Also affects distribution/package Nominate for series Bug Description a number of tables defined and being federated from one db host to another. These were defined in Percona Server 5.5, but then we've been seeing problems upon upgrading to Percona Server 5.6 (both hosts are running the same version of the Percona Server software) I have seen a mix of Error 1160, Error 1158 and Error 1159. My [MYSQL] options in my configuration file are: [user@db ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 322033 Server version: 5.6.15-56-log Percona Server (GPL), Release rel63.0, Revision 519 Copyright (c) 2009-2013 Percona LLC and/or its affiliates Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use federated; Database changed mysql> select count(1) from v_citation; ERROR 1160 (08S01): Got an error writing communication packets mysql> select count(1) from v_citation; +----------+ | count(1) | +----------+ | 30452 | +----------+ 1 row in set (19.07 sec) Tags: federated Edit Tag help Andrew Ernst (ubuntubugs-x) wrote on 2014-02-05: