MySQL Forums
Forum List  »  Federated Storage Engine

Insert into Federated tables using mysql triggers
Posted by: Saravanan Ramasamy
Date: January 16, 2019 04:01PM

Hi,
I have a local table A and a federated table B.
I'm trying to insert into federated table B using After trigger Insert on local table A.
Everything works as long as both servers are connected.
Whenever the other server is either down or unavailable during insert action it gets hung or something. I'm not sure whether it is waiting for the server. It gets hung and as long as i reconnect back to other server the action resumes.

I would like to throw an error and keep going.
I tried RESIGNAL as below
DECLARE EXIT HANDLER FOR SQLEXCEPTION
RESIGNAL;
But doesn't seem to help. Any ideas?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Insert into Federated tables using mysql triggers
242
January 16, 2019 04:01PM


Sorry, only registered users may post in this forum.

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.