Bug #72432 "MYSQLFABRIC MANAGE SETUP" RESULTS IN A LOST CONNECTION ERROR
Submitted: 23 Apr 2014 14:46 Modified: 13 Jan 2015 7:53
Reporter: Alfranio Correia Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Fabric Severity:S3 (Non-critical)
Version:1.4.0 OS:Any
Assigned to: Alfranio Correia CPU Architecture:Any

[23 Apr 2014 14:46] Alfranio Correia
Description:
After installing mysql-utilities-1.4.2-1.el6.noarch.rpm from
http://clustra.no.oracle.com/~bteam/my/build-201402251850-1.4.2/mysql-utilitie
s-1.4.2-build/

when "mysqlfabric manage setup " is run, the following issue is noticed:

mysqlfabric manage setup
[INFO] 1395741409.391366 - MainThread - Initializing persister: user (root),
server (localhost:3306), database (fabric).

Error: ("Command (ALTER TABLE role_permissions ADD CONSTRAINT
fk_role_permissions_role_id FOREIGN KEY (role_id) REFERENCES roles (role_id),
ADD CONSTRAINT fk_role_permissions_permission_id FOREIGN KEY (permission_id)
REFERENCES permissions (permission_id), ()) failed: 2055: Lost connection to
MySQL server at 'localhost:3306', system error: timed out", 2055)

How to repeat:
-- Install the RPM
-- Make changes in /etc/mysql/fabric.cfg (
   In [storage] section user = root
   In [servers] section user = root
-- run "mysqlfabric manage setup" to notice the issue.

Suggested fix:
As per development there are two issues:

-- the timeout is too short for some cases and
-- there is a missing cleanup when there is a timeout