Mysql Error Code 1429
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting unable to connect to foreign data source host is not allowed to connect to this mysql server ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a mysql federated table question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL error 1429, federation up vote 1 down vote favorite 1 I use MySQL federation to let one MySQL database access another's data tables. This has worked fine for more than a year, but today (from out of the blue) a stored routine reported this MySQL error: Error Code: 1429. Unable to connect to foreign data source: Too many connections If I try to access the federated table with a SELECT, I get Error Code: 1030 Got error 1 from storage engine Moving on to the MySQL server which hosts the data, I can actually SELECT the desired data, so it seems to be working. The server accessing the data is version 5.0.51a24 and the host server is 5.0.96-0. Old stuff, that is. How do I solve the problem? Couldn't find much help in the MySQL documention. mysql federated share|improve this question edited Feb 1 '13 at 7:40 asked Jan 31 '13 at 8:26 Gruber 1319 1 Check the following bug reports to see if these are the cases with you bugs.mysql.com/bug.php?id=27180 (querying a big table) bugs.mysql.com/bug.php?id=28269 (use of a reserve word in table definition) –Wasif Feb 1 '13 at 6:46 @mwasif: Thanks a lot. I've updated the question to include the versions of MySQL I use. Apparently those old versions may have some bugs. One (tedious and risky) option could be to upgrade my servers to modern versions. Perhaps I'll try using ALTER TABLE as described in your linked article. –Gruber Feb 1 '13 at 7:44 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted Check the number of active connections on the remote/destination server. Looking at the source code (of newer versions) I think it's a good bet that the "Too many connections" message is actually being returned from the remote end -- as opposed to originating on the local server (where the FEDERATED engine is being used). SHOW STATUS LIKE '%connect%'; Threads_connected is the current count, Max_used_connections is the highest value seen since the last time FLUSH STATUS was issued. If that max value is the same as (or 1 more than) the value returned b
2011 16:36 Reporter: Santo Leto Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Information schema Severity:S1 (Critical) Version:5.1.23-beta, 5.0.58, 5.0.60-BK, 5.1.25-BK OS:Any Assigned to: Christopher Powers Tags: federated, metadata Triage: Triaged: D2 (Serious) / R3 (Medium) / E3 (Medium) View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Mar 2008 11:59] Santo Leto Description: If a Federated Table can't connect to the remote http://serverfault.com/questions/474116/mysql-error-1429-federation host, can't select over the local table information_schema.tables. How to repeat: We will use 2 servers: a 'remote' server and a local server. First we create a table on the remote server and then we create a federated table on the local server and we make sure all is working fine. Then https://bugs.mysql.com/bug.php?id=35333 we'll shutdown the remote server and we'll use the Test Script to simulate the bug. *** PRELIMINARY SCRIPT *** Remote Server: SELECT CURRENT_USER(), VERSION(); DROP DATABASE IF EXISTS `federated`; CREATE DATABASE `federated`; DROP TABLE IF EXISTS `federated`.`test_table`; CREATE TABLE `federated`.`test_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `other` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `other_key` (`other`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `federated`.`test_table` (`name`,`other`) VALUES ('remote_value1', '1'); SELECT * FROM `federated`.`test_table`; Local Server: SELECT CURRENT_USER(), VERSION(); DROP TABLE IF EXISTS `test`.`federated_table`; CREATE TABLE `test`.`federated_table` ( `id` int(20) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `other` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `other_key` (`other`) ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://sleto@localhost:6004/federated/test_table'; INSERT INTO `test`.`federated_table` (`name`,`other`) VALUES ('local_value1', '1'); SELECT * FROM `test`.`federated_table`; *** END PRELIMINARY SCRIPT *** *** TEST SCRIPT *** Local Server SELECT * FROM `information_schema`.`tables` LIMIT 1\G
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: Unable to connect to foreign data source New Topic Advanced Search Unable to connect to foreign data source Posted by: Jacek Szymanski () Date: May 24, 2013 01:01PM http://forums.mysql.com/read.php?10,587287 Hi, I am trying to set up a FEDERATED table between two MySQL servers. I have created a separate user for this and enabled remote connection to the host server. On the client server (meaning on the one where I create the FEDERATED table that connects to a table on the host server) I have enabled the FEDERATED enginge. From the client server I can connect to the host database if I run mysql error mysql -h myhost -u myuser -p. I can select from all tables without issue. Now the problem is that I can not access the data via the FEDERATED table. I can create it without problem and I get no error message. However, when I try SELECT * from myfederatedtable; then I get: ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on '196.168.2.224' (110) What can be mysql error code the reason for this? Best regards Jacek Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Unable to connect to foreign data source Jacek Szymanski 05/24/2013 01:01PM Re: Unable to connect to foreign data source Peter Brawley 05/24/2013 01:55PM Re: Unable to connect to foreign data source Jacek Szymanski 05/25/2013 05:01AM Re: Unable to connect to foreign data source Peter Brawley 05/25/2013 01:07PM Re: Unable to connect to foreign data source Jacek Szymanski 05/25/2013 09:41AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides My