MySQL Forums
Forum List  »  Federated Storage Engine

Federated to localhost
Posted by: Shlomo Priymak
Date: August 02, 2007 05:21AM

Hi,

I'm trying to define a FEDERATED table to another schema at the same server.
This is how the connection string looks like:
CONNECTION='mysql://root:pass@localhost:3306/schema2/table';

What I get, after ~30sec is a "Lost connection to MySQL server during query" error.

If i try to do the same to a remote server, which holds an identical schema, this works.

What could be the problem?

Thanks,
Shlomo

[edit]
I just found out it is a known bug, quite a showstopper, but it exists for quite a while.
http://bugs.mysql.com/bug.php?id=18287

It's amazing how such horrible regression bugs even appear - this is something so basic, that a simple unit test could have solved.



Edited 1 time(s). Last edit at 08/02/2007 05:42AM by Shlomo Priymak.

Options: ReplyQuote


Subject
Views
Written By
Posted
Federated to localhost
6513
August 02, 2007 05:21AM
4295
February 28, 2008 03:17AM


Sorry, you can't reply to this topic. It has been closed.

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.