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
