MySQL Forums
Forum List  »  Federated Storage Engine

Error 1156 on federated table
Posted by: Ruaraidh Hamilton
Date: May 01, 2013 06:53PM

Can anyone explain "Error Code: 1156. Got packets out of order" when querying a federated table? More details:

First on the remote server with an SSH connection:

/********************************************************/
CREATE TABLE `testremote`.`test` (
`c1` varchar(10) NOT NULL,
PRIMARY KEY (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `testremote`.`test` (`c1`) VALUES ('a');
/********************************************************/

Then on the local server:

/********************************************************/
CREATE TABLE `test`.`test` (
`c1` varchar(10) NOT NULL,
PRIMARY KEY (`c1`)
) engine=federated DEFAULT CHARSET=utf8
CONNECTION='mysql://user:password@IP_address:port/testremote/test';

select c1 from test.test;
/********************************************************/

That final select generates the error.

I am using MySQL Workbench 5.2.39 CE. Variable version=5.5.28-log for the remote server, and 5.6.11-log for the local server. user is the "SSH Username", and IP_address:port is the SSH Hostname as shown in the "Connect to Database" window of MySQL Workbench

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 1156 on federated table
4367
May 01, 2013 06:53PM


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.