Below is debug log\worklog -bash-4.2$ mysqlfabric manage setup [INFO] 1419754260.399950 - MainThread - Initializing persister: user (fabric), server (localhost:3306), database (fabric). [DEBUG] 1419754260.410922 - MainThread - Statement (CREATE DATABASE fabric DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.417645 - MainThread - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754260.419416 - MainThread - Create database objects for Checkpoint [DEBUG] 1419754260.420436 - MainThread - Statement (CREATE TABLE checkpoints (proc_uuid VARCHAR(40) NOT NULL, lockable_objects BLOB NULL, job_uuid VARCHAR(40) NOT NULL, sequence INTEGER NOT NULL, action_fqn TEXT NOT NULL, param_args BLOB NULL, param_kwargs BLOB NULL, started DOUBLE(16, 6) NULL, finished DOUBLE(16, 6) NULL, CONSTRAINT pk_checkpoint PRIMARY KEY (proc_uuid, job_uuid)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.431542 - MainThread - Create database objects for MySQLHandler [DEBUG] 1419754260.432227 - MainThread - Statement (CREATE TABLE log (subject VARCHAR(40) NOT NULL, reported TIMESTAMP /*!50604 (6) */ NOT NULL, reporter VARCHAR(64) NOT NULL, message TEXT, category int NOT NULL, type int NOT NULL, INDEX key_subject_reported (subject, reported), INDEX key_reporter (reporter), INDEX key_reported (reported), INDEX key_category (category), INDEX key_type (type)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.446147 - MainThread - Statement (CREATE EVENT prune_log ON SCHEDULE EVERY 3600 SECOND DO DELETE FROM log WHERE TIMEDIFF(UTC_TIMESTAMP(), reported) > MAKETIME(3600,0,0), Params(()). [DEBUG] 1419754260.448416 - MainThread - Statement (CREATE VIEW group_view AS SELECT subject as group_id, (SELECT COUNT(*) FROM log as in_log WHERE in_log.subject = group_id AND in_log.category = 3 AND in_log.type = 3) as promote_count, (SELECT COUNT(*) FROM log as in_log WHERE in_log.subject = group_id AND in_log.category = 3 AND in_log.type = 4) as demote_count FROM log as out_log WHERE out_log.category = 3 GROUP BY out_log.subject, Params(()). [DEBUG] 1419754260.452449 - MainThread - Statement (CREATE VIEW proc_view AS SELECT out_log.subject as proc_name, (SELECT COUNT(*) FROM log as in_log WHERE in_log.subject = proc_name AND in_log.category = 1 AND in_log.type = 0) as call_count, (SELECT COUNT(*) FROM log as in_log WHERE in_log.subject = proc_name AND in_log.category = 1 AND in_log.type = 2) as abort_count FROM log as out_log WHERE out_log.category = 1 GROUP BY out_log.subject, Params(()). [DEBUG] 1419754260.455640 - MainThread - Create database objects for User [DEBUG] 1419754260.456349 - MainThread - Statement (CREATE TABLE `users` ( `user_id` int unsigned NOT NULL AUTO_INCREMENT, `username` varchar(100) NOT NULL, `protocol` varchar(200) NOT NULL DEFAULT 'xmlrpc', `password` varchar(128) DEFAULT NULL, PRIMARY KEY (user_id), UNIQUE KEY (`username`, `protocol`)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.465907 - MainThread - Statement (CREATE TABLE `roles` ( `role_id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL, `description` varchar(1000), PRIMARY KEY (role_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.474549 - MainThread - Statement (CREATE TABLE `permissions` ( `permission_id` int unsigned NOT NULL AUTO_INCREMENT, `subsystem` varchar(60) NOT NULL, `component` varchar(60) DEFAULT NULL, `function` varchar(60) DEFAULT NULL, `description` varchar(1000), PRIMARY KEY (permission_id), UNIQUE INDEX (`subsystem`, `component`, `function`)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.484077 - MainThread - Statement (CREATE TABLE `role_permissions` ( `role_id` int unsigned NOT NULL, `permission_id` int unsigned NOT NULL, PRIMARY KEY (`role_id`, `permission_id`)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.493777 - MainThread - Statement (CREATE TABLE `user_roles` ( `user_id` int unsigned NOT NULL, `role_id` int unsigned NOT NULL, PRIMARY KEY (`user_id`, `role_id`)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.502989 - MainThread - Statement (ALTER TABLE user_roles ADD CONSTRAINT fk_user_roles_user_id FOREIGN KEY (user_id) REFERENCES users (user_id) ON DELETE CASCADE, ADD CONSTRAINT fk_user_roles_role_id FOREIGN KEY (role_id) REFERENCES roles (role_id) ON DELETE CASCADE, Params(()). [DEBUG] 1419754260.523893 - MainThread - Statement (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), Params(()). [DEBUG] 1419754260.543947 - MainThread - Statement (INSERT INTO users (user_id, username, password, protocol) VALUES (%(user_id)s, %(username)s, %(password)s, %(protocol)s), Params({'username': 'admin', 'protocol': 'xmlrpc', 'password': None, 'user_id': 1}). [DEBUG] 1419754260.549419 - MainThread - Statement (INSERT INTO users (user_id, username, password, protocol) VALUES (%(user_id)s, %(username)s, %(password)s, %(protocol)s), Params({'username': 'admin', 'protocol': 'mysql', 'password': None, 'user_id': 2}). [DEBUG] 1419754260.552755 - MainThread - Statement (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), Params({'subsystem': 'core', 'function': None, 'permission_id': 1, 'component': None, 'description': 'Full access to all core Fabric functionality'}). [DEBUG] 1419754260.555358 - MainThread - Statement (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), Params({'subsystem': 'core', 'function': None, 'permission_id': 2, 'component': 'dump', 'description': 'Access to dump commands'}). [DEBUG] 1419754260.558345 - MainThread - Statement (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), Params({'subsystem': 'core', 'function': None, 'permission_id': 3, 'component': 'user', 'description': 'User administration'}). [DEBUG] 1419754260.561421 - MainThread - Statement (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), Params({'subsystem': 'core', 'function': None, 'permission_id': 4, 'component': 'role', 'description': 'Role administration'}). [DEBUG] 1419754260.563756 - MainThread - Statement (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), Params({'subsystem': 'core', 'function': None, 'permission_id': 5, 'component': 'threat', 'description': 'Reporting to Fabric'}). [DEBUG] 1419754260.565603 - MainThread - Statement (INSERT INTO roles (role_id, name, description) VALUES (%(role_id)s, %(name)s, %(description)s), Params({'description': 'Role for Administrative users', 'name': 'superadmin', 'role_id': 1}). [DEBUG] 1419754260.568057 - MainThread - Statement (INSERT INTO roles (role_id, name, description) VALUES (%(role_id)s, %(name)s, %(description)s), Params({'description': 'Role for users dealing with user administration', 'name': 'useradmin', 'role_id': 2}). [DEBUG] 1419754260.571052 - MainThread - Statement (INSERT INTO roles (role_id, name, description) VALUES (%(role_id)s, %(name)s, %(description)s), Params({'description': 'Role for MySQL Connectors', 'name': 'connector', 'role_id': 3}). [DEBUG] 1419754260.572654 - MainThread - Statement (INSERT INTO role_permissions (role_id, permission_id) VALUES (%(role_id)s, %(permission_id)s), Params({'permission_id': 1, 'role_id': 1}). [DEBUG] 1419754260.575655 - MainThread - Statement (INSERT INTO role_permissions (role_id, permission_id) VALUES (%(role_id)s, %(permission_id)s), Params({'permission_id': 3, 'role_id': 2}). [DEBUG] 1419754260.578256 - MainThread - Statement (INSERT INTO role_permissions (role_id, permission_id) VALUES (%(role_id)s, %(permission_id)s), Params({'permission_id': 4, 'role_id': 2}). [DEBUG] 1419754260.580675 - MainThread - Statement (INSERT INTO role_permissions (role_id, permission_id) VALUES (%(role_id)s, %(permission_id)s), Params({'permission_id': 2, 'role_id': 3}). [DEBUG] 1419754260.582832 - MainThread - Statement (INSERT INTO role_permissions (role_id, permission_id) VALUES (%(role_id)s, %(permission_id)s), Params({'permission_id': 5, 'role_id': 3}). [DEBUG] 1419754260.584748 - MainThread - Statement (INSERT INTO user_roles (user_id, role_id) VALUES (%(user_id)s, %(role_id)s), Params({'user_id': 1, 'role_id': 1}). [DEBUG] 1419754260.587671 - MainThread - Statement (INSERT INTO user_roles (user_id, role_id) VALUES (%(user_id)s, %(role_id)s), Params({'user_id': 2, 'role_id': 1}). [DEBUG] 1419754260.589524 - MainThread - Create database objects for ErrorLog [DEBUG] 1419754260.589878 - MainThread - Statement (CREATE TABLE error_log (server_uuid VARCHAR(40) NOT NULL, reported TIMESTAMP /*!50604 (6) */ NOT NULL, reporter VARCHAR(64) NOT NULL, error TEXT, INDEX key_server_uuid_reported (server_uuid, reported), INDEX key_reporter (reporter)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.601499 - MainThread - Statement (CREATE EVENT prune_error_log ON SCHEDULE EVERY 3600 SECOND DO DELETE FROM error_log WHERE TIMEDIFF(UTC_TIMESTAMP(), reported) > MAKETIME(3600,0,0), Params(()). [DEBUG] 1419754260.602593 - MainThread - Create database objects for Group [DEBUG] 1419754260.603167 - MainThread - Statement (CREATE TABLE groups(group_id VARCHAR(64) NOT NULL, description VARCHAR(256), master_uuid VARCHAR(40), master_defined TIMESTAMP /*!50604 (6) */ NULL, status BIT(1) NOT NULL, CONSTRAINT pk_group_id PRIMARY KEY (group_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.612352 - MainThread - Statement (CREATE TABLE group_replication(master_group_id VARCHAR(64) NOT NULL, slave_group_id VARCHAR(64) NOT NULL, CONSTRAINT pk_master_slave_group_id PRIMARY KEY(master_group_id, slave_group_id), CONSTRAINT FOREIGN KEY(master_group_id) REFERENCES groups(group_id), CONSTRAINT FOREIGN KEY(slave_group_id) REFERENCES groups(group_id), INDEX idx_slave_group_id(slave_group_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.625163 - MainThread - Create database objects for MySQLServer [DEBUG] 1419754260.626221 - MainThread - Statement (CREATE TABLE servers (server_uuid VARCHAR(40) NOT NULL, server_address VARCHAR(128) NOT NULL, mode INTEGER NOT NULL, status INTEGER NOT NULL, weight FLOAT NOT NULL, group_id VARCHAR(64), CONSTRAINT pk_server_uuid PRIMARY KEY (server_uuid), INDEX idx_group_id (group_id), UNIQUE INDEX idx_server_address (server_address)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.637731 - MainThread - Create database objects for ShardMapping [DEBUG] 1419754260.638337 - MainThread - Statement (CREATE TABLE shard_tables(shard_mapping_id INT NOT NULL, table_name VARCHAR(64) NOT NULL, column_name VARCHAR(64) NOT NULL, PRIMARY KEY (table_name, column_name), INDEX(shard_mapping_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.648204 - MainThread - Statement (CREATE TABLE shard_maps(shard_mapping_id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, type_name ENUM ('RANGE','RANGE_INTEGER','RANGE_STRING','RANGE_DATETIME','HASH') NOT NULL, global_group VARCHAR(64)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.657612 - MainThread - Create database objects for Shards [DEBUG] 1419754260.658290 - MainThread - Statement (CREATE TABLE shards (shard_id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, group_id VARCHAR(64) NOT NULL, state ENUM('DISABLED', 'ENABLED') NOT NULL) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.667334 - MainThread - Create database objects for RangeShardingSpecification [DEBUG] 1419754260.668128 - MainThread - Statement (CREATE TABLE shard_ranges (shard_mapping_id INT NOT NULL, lower_bound VARBINARY(16) NOT NULL, INDEX(lower_bound), UNIQUE(shard_mapping_id, lower_bound), shard_id INT NOT NULL) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.678474 - MainThread - Create database objects for HashShardingSpecification [DEBUG] 1419754260.678695 - MainThread - Create database objects for Machine [DEBUG] 1419754260.679291 - MainThread - Statement (CREATE TABLE machines (machine_uuid VARCHAR(40) NOT NULL, provider_id VARCHAR(128) NOT NULL, av_zone VARCHAR(256), addresses TEXT, INDEX idx_machine_provider_id (provider_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.688716 - MainThread - Create database objects for Provider [DEBUG] 1419754260.690225 - MainThread - Statement (CREATE TABLE providers (provider_id VARCHAR(128) NOT NULL, type INT NOT NULL, username VARCHAR(100) NOT NULL, password VARCHAR(128) NOT NULL, url VARCHAR(256) NOT NULL, tenant VARCHAR(100), default_image VARCHAR(256), default_flavor VARCHAR(256), extra TEXT, CONSTRAINT pk_provider_id PRIMARY KEY (provider_id)) DEFAULT CHARSET=utf8, Params(()). [DEBUG] 1419754260.698873 - MainThread - Create constraints for ErrorLog [DEBUG] 1419754260.700138 - MainThread - Statement (ALTER TABLE error_log ADD CONSTRAINT fk_server_uuid_error_log FOREIGN KEY(server_uuid) REFERENCES servers(server_uuid), Params(()). [DEBUG] 1419754260.721703 - MainThread - Create constraints for Group [DEBUG] 1419754260.722397 - MainThread - Statement (ALTER TABLE groups ADD CONSTRAINT fk_master_uid_servers FOREIGN KEY(master_uuid) REFERENCES servers(server_uuid), Params(()). [DEBUG] 1419754260.742120 - MainThread - Create constraints for MySQLServer [DEBUG] 1419754260.743097 - MainThread - Statement (ALTER TABLE servers ADD CONSTRAINT fk_group_id_servers FOREIGN KEY(group_id) REFERENCES groups(group_id), Params(()). [DEBUG] 1419754260.764264 - MainThread - Create constraints for ShardMapping [DEBUG] 1419754260.765155 - MainThread - Statement (ALTER TABLE shard_maps ADD CONSTRAINT fk_shard_mapping_global_group FOREIGN KEY(global_group) REFERENCES groups(group_id), Params(()). [DEBUG] 1419754260.784677 - MainThread - Statement (ALTER TABLE shard_tables ADD CONSTRAINT fk_shard_mapping_id FOREIGN KEY(shard_mapping_id) REFERENCES shard_maps(shard_mapping_id), Params(()). [DEBUG] 1419754260.804856 - MainThread - Create constraints for Shards [DEBUG] 1419754260.806201 - MainThread - Statement (ALTER TABLE shards ADD CONSTRAINT fk_shards_group_id FOREIGN KEY(group_id) REFERENCES groups(group_id), Params(()). [DEBUG] 1419754260.825949 - MainThread - Create constraints for RangeShardingSpecification [DEBUG] 1419754260.827218 - MainThread - Statement (ALTER TABLE shard_ranges ADD CONSTRAINT fk_shard_mapping_id_sharding_spec FOREIGN KEY(shard_mapping_id) REFERENCES shard_maps(shard_mapping_id), Params(()). [DEBUG] 1419754260.848229 - MainThread - Statement (ALTER TABLE shard_ranges ADD CONSTRAINT fk_shard_id_sharding_spec FOREIGN KEY(shard_id) REFERENCES shards(shard_id), Params(()). [DEBUG] 1419754260.869412 - MainThread - Create constraints for HashShardingSpecification [DEBUG] 1419754260.869605 - MainThread - Create constraints for Machine [DEBUG] 1419754260.870825 - MainThread - Statement (ALTER TABLE machines ADD CONSTRAINT fk_provider_id_providers FOREIGN KEY(provider_id) REFERENCES providers(provider_id), Params(()). [DEBUG] 1419754260.894395 - MainThread - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754260.896036 - MainThread - Statement (SELECT password, username, protocol, user_id FROM users WHERE username = %s AND protocol = %s, Params(('admin', 'mysql')). [DEBUG] 1419754260.900260 - MainThread - Statement (SELECT password, username, protocol, user_id FROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754260.903544 - MainThread - Statement (BEGIN, Params(()). [INFO] 1419754260.905083 - MainThread - Initial password for admin/mysql set [DEBUG] 1419754260.905204 - MainThread - Statement (BEGIN, Params(()). [DEBUG] 1419754260.905694 - MainThread - Statement (UPDATE users SET password = %s WHERE username = %s AND protocol = %s, Params(('CB4AFD4AA6D15B1B4B2F249F7386275638D906B8', 'admin', 'mysql')). [DEBUG] 1419754260.906526 - MainThread - Statement (COMMIT, Params(()). [DEBUG] 1419754260.908780 - MainThread - Statement (COMMIT, Params(()). Password set for admin/mysql from configuration file. [INFO] 1419754260.909399 - MainThread - Password set for admin/mysql from configuration file. [DEBUG] 1419754260.909730 - MainThread - Statement (BEGIN, Params(()). [INFO] 1419754260.910190 - MainThread - Initial password for admin/xmlrpc set [DEBUG] 1419754260.910314 - MainThread - Statement (BEGIN, Params(()). [DEBUG] 1419754260.910872 - MainThread - Statement (UPDATE users SET password = %s WHERE username = %s AND protocol = %s, Params(('c780013e43e6649e9b7c10111c023874', 'admin', 'xmlrpc')). [DEBUG] 1419754260.911661 - MainThread - Statement (COMMIT, Params(()). [DEBUG] 1419754260.913952 - MainThread - Statement (COMMIT, Params(()). Password set for admin/xmlrpc from configuration file. [INFO] 1419754260.914466 - MainThread - Password set for admin/xmlrpc from configuration file. No result returned -bash-4.2$ mysqlfabric manage start & [1] 10084 -bash-4.2$ [INFO] 1419754271.628685 - MainThread - Initializing persister: user (fabric), server (localhost:3306), database (fabric). [DEBUG] 1419754271.638546 - MainThread - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754271.640529 - MainThread - Statement (SELECT password, username, protocol, user_id FROM users WHERE username = %s AND protocol = %s, Params(('admin', 'mysql')). [DEBUG] 1419754271.646152 - MainThread - Statement (SELECT password, username, protocol, user_id FROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754271.649561 - MainThread - Module mysql.fabric.providers.null has got __name__ mysql.fabric.providers.null [DEBUG] 1419754272.042374 - MainThread - Module mysql.fabric.providers.openstack has got __name__ mysql.fabric.providers.openstack [DEBUG] 1419754272.042852 - MainThread - Providers {'NULLPROVIDER': {'machine': , 'snapshot': , 'idx': 1}, 'OPENSTACK': {'machine': , 'snapshot': , 'idx': 2}}. [INFO] 1419754272.043138 - MainThread - Loading Services. [DEBUG] 1419754272.044179 - MainThread - Module mysql.fabric.services.event has got __name__ mysql.fabric.services.event [DEBUG] 1419754272.044179 - MainThread - Registering blocks [] for event under name REPORT_ERROR [DEBUG] 1419754272.044820 - MainThread - Registering blocks [] for event under name REPORT_FAILURE [DEBUG] 1419754272.045106 - MainThread - Module mysql.fabric.services.failure_tracker has got __name__ mysql.fabric.services.failure_tracker [DEBUG] 1419754272.047020 - MainThread - Module mysql.fabric.services.handler has got __name__ mysql.fabric.services.handler [DEBUG] 1419754272.047772 - MainThread - Module mysql.fabric.services.health has got __name__ mysql.fabric.services.health [DEBUG] 1419754272.049248 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.049469 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.049601 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.049733 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.049900 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050077 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050214 - MainThread - Registering blocks [] for event under name FAIL_OVER [DEBUG] 1419754272.050346 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050465 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050594 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050713 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.050869 - MainThread - Module mysql.fabric.services.highavailability has got __name__ mysql.fabric.services.highavailability [DEBUG] 1419754272.051915 - MainThread - Registering blocks [] for event under name CREATE_MACHINE [DEBUG] 1419754272.052063 - MainThread - Registering blocks [] for event under name DESTROY_MACHINE [DEBUG] 1419754272.052200 - MainThread - Registering blocks [] for event under name CREATE_SNAPSHOT [DEBUG] 1419754272.052334 - MainThread - Registering blocks [] for event under name DESTROY_SNAPSHOT [DEBUG] 1419754272.052502 - MainThread - Module mysql.fabric.services.machine has got __name__ mysql.fabric.services.machine [DEBUG] 1419754272.054060 - MainThread - Module mysql.fabric.services.manage has got __name__ mysql.fabric.services.manage [DEBUG] 1419754272.057464 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.057635 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.057766 - MainThread - Module mysql.fabric.services.provider has got __name__ mysql.fabric.services.provider [DEBUG] 1419754272.059141 - MainThread - Module mysql.fabric.services.provisioning has got __name__ mysql.fabric.services.provisioning [DEBUG] 1419754272.060651 - MainThread - Registering blocks [] for event under name PRUNE_SHARD_TABLES [DEBUG] 1419754272.060855 - MainThread - Registering blocks [] for event under name CHECK_SHARD_INFORMATION [DEBUG] 1419754272.060980 - MainThread - Registering blocks [] for event under name BACKUP_SOURCE_SHARD [DEBUG] 1419754272.061110 - MainThread - Registering blocks [] for event under name RESTORE_SHARD_BACKUP [DEBUG] 1419754272.061231 - MainThread - Registering blocks [] for event under name SETUP_REPLICATION [DEBUG] 1419754272.061351 - MainThread - Registering blocks [] for event under name SETUP_SYNC [DEBUG] 1419754272.061481 - MainThread - Registering blocks [] for event under name SETUP_RESHARDING_SWITCH [DEBUG] 1419754272.061672 - MainThread - Registering blocks [] for event under name PRUNE_SHARDS [DEBUG] 1419754272.061839 - MainThread - Module mysql.fabric.services.resharding has got __name__ mysql.fabric.services.resharding [DEBUG] 1419754272.064521 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.064521 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.064521 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.064521 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.066440 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.066642 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.066875 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.067795 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.068012 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.068138 - MainThread - Registering blocks [] for event under name None [DEBUG] 1419754272.068269 - MainThread - Registering blocks [] for event under name BACKUP_SERVER [DEBUG] 1419754272.068390 - MainThread - Registering blocks [] for event under name RESTORE_SERVER [DEBUG] 1419754272.068543 - MainThread - Module mysql.fabric.services.server has got __name__ mysql.fabric.services.server [DEBUG] 1419754272.071638 - MainThread - Registering blocks [] for event under name DEFINE_SHARD_MAPPING [DEBUG] 1419754272.071847 - MainThread - Registering blocks [] for event under name ADD_SHARD_MAPPING [DEBUG] 1419754272.072022 - MainThread - Registering blocks [] for event under name REMOVE_SHARD_MAPPING [DEBUG] 1419754272.072194 - MainThread - Registering blocks [] for event under name REMOVE_SHARD_MAPPING_DEFN [DEBUG] 1419754272.072442 - MainThread - Registering blocks [] for event under name ADD_SHARD [DEBUG] 1419754272.072575 - MainThread - Registering blocks [] for event under name REMOVE_SHARD [DEBUG] 1419754272.072757 - MainThread - Registering blocks [] for event under name SHARD_ENABLE [DEBUG] 1419754272.072889 - MainThread - Registering blocks [] for event under name SHARD_DISABLE [DEBUG] 1419754272.073013 - MainThread - Module mysql.fabric.services.sharding has got __name__ mysql.fabric.services.sharding [DEBUG] 1419754272.073764 - MainThread - Module mysql.fabric.services.utils has got __name__ mysql.fabric.services.utils [DEBUG] 1419754272.073974 - MainThread - Registering statistics.node. [INFO] 1419754272.074155 - MainThread - MySQL-RPC protocol server started, listening on localhost:32275 [DEBUG] 1419754272.074349 - MainThread - Registering statistics.group. [DEBUG] 1419754272.074512 - MainThread - Registering statistics.procedure. [DEBUG] 1419754272.074512 - MainThread - Registering group.activate. [DEBUG] 1419754272.074512 - MainThread - Registering group.description. [DEBUG] 1419754272.074512 - MainThread - Registering group.deactivate. [DEBUG] 1419754272.074512 - MainThread - Registering group.create. [DEBUG] 1419754272.074893 - MainThread - Registering group.remove. [DEBUG] 1419754272.075739 - MainThread - Registering group.add. [DEBUG] 1419754272.076039 - MainThread - Registering group.health. [DEBUG] 1419754272.076223 - MainThread - Registering group.lookup_servers. [DEBUG] 1419754272.076418 - MainThread - Registering group.destroy. [DEBUG] 1419754272.076696 - MainThread - Registering group.demote. [DEBUG] 1419754272.076891 - MainThread - Registering group.promote. [DEBUG] 1419754272.077135 - MainThread - Registering group.lookup_groups. [DEBUG] 1419754272.077379 - MainThread - Registering dump.fabric_nodes. [DEBUG] 1419754272.077558 - MainThread - Registering dump.shard_index. [DEBUG] 1419754272.077808 - MainThread - Registering dump.sharding_information. [DEBUG] 1419754272.077999 - MainThread - Registering dump.servers. [DEBUG] 1419754272.078238 - MainThread - Registering dump.shard_tables. [DEBUG] 1419754272.078489 - MainThread - Registering dump.shard_maps. [DEBUG] 1419754272.078675 - MainThread - Registering manage.stop. [DEBUG] 1419754272.078991 - MainThread - Registering manage.ping. [DEBUG] 1419754272.079290 - MainThread - Registering manage.logging_level. [DEBUG] 1419754272.079476 - MainThread - Registering server.set_mode. [DEBUG] 1419754272.079717 - MainThread - Registering server.clone. [DEBUG] 1419754272.080020 - MainThread - Registering server.list. [DEBUG] 1419754272.080272 - MainThread - Registering server.set_weight. [DEBUG] 1419754272.080479 - MainThread - Registering server.lookup_uuid. [DEBUG] 1419754272.080712 - MainThread - Registering server.set_status. [DEBUG] 1419754272.081029 - MainThread - Registering server.destroy. [DEBUG] 1419754272.081271 - MainThread - Registering server.create. [DEBUG] 1419754272.081978 - MainThread - Registering role.list. [DEBUG] 1419754272.082217 - MainThread - Registering user.roles. [DEBUG] 1419754272.082415 - MainThread - Registering user.usercommand. [DEBUG] 1419754272.082638 - MainThread - Registering user.list. [DEBUG] 1419754272.082806 - MainThread - Registering user.add. [DEBUG] 1419754272.082985 - MainThread - Registering user.password. [DEBUG] 1419754272.083215 - MainThread - Registering user.delete. [DEBUG] 1419754272.083420 - MainThread - Registering threat.report_error. [DEBUG] 1419754272.083778 - MainThread - Registering threat.report_failure. [DEBUG] 1419754272.084037 - MainThread - Registering provider.unregister. [DEBUG] 1419754272.085531 - MainThread - Registering provider.register. [DEBUG] 1419754272.085852 - MainThread - Registering provider.list. [DEBUG] 1419754272.086048 - MainThread - Registering sharding.list_definitions. [DEBUG] 1419754272.086210 - MainThread - Registering sharding.remove_definition. [DEBUG] 1419754272.086458 - MainThread - Registering sharding.move_shard. [DEBUG] 1419754272.086772 - MainThread - Registering sharding.disable_shard. [DEBUG] 1419754272.087014 - MainThread - Registering sharding.remove_table. [DEBUG] 1419754272.087206 - MainThread - Registering sharding.split_shard. [DEBUG] 1419754272.087515 - MainThread - Registering sharding.create_definition. [DEBUG] 1419754272.087699 - MainThread - Registering sharding.add_shard. [DEBUG] 1419754272.087945 - MainThread - Registering sharding.add_table. [DEBUG] 1419754272.088137 - MainThread - Registering sharding.lookup_table. [DEBUG] 1419754272.088363 - MainThread - Registering sharding.enable_shard. [DEBUG] 1419754272.088545 - MainThread - Registering sharding.remove_shard. [DEBUG] 1419754272.088832 - MainThread - Registering sharding.list_tables. [DEBUG] 1419754272.089060 - MainThread - Registering sharding.prune_shard. [DEBUG] 1419754272.089251 - MainThread - Registering sharding.lookup_servers. [DEBUG] 1419754272.089495 - MainThread - Registering snapshot.destroy. [DEBUG] 1419754272.089685 - MainThread - Registering snapshot.create. [DEBUG] 1419754272.089981 - MainThread - Registering event.trigger. [DEBUG] 1419754272.090154 - MainThread - Registering event.wait_for_procedures. [DEBUG] 1419754272.097328 - MainThread - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754272.099999 - MainThread - Statement (SELECT group_id FROM groups WHERE status = %s, Params((1,)). [DEBUG] 1419754272.102675 - MainThread - Statement (SELECT @@GLOBAL.max_connections, Params(()). [INFO] 1419754272.104206 - MainThread - Fabric node starting. [DEBUG] 1419754272.104597 - MainThread - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('0', datetime.datetime(2014, 12, 28, 8, 11, 12), 'mysql.fabric.services.manage', 'Fabric node starting.', 0, 0)). [INFO] 1419754272.108583 - MainThread - Starting Executor. [INFO] 1419754272.108713 - MainThread - Setting 5 executor(s). [INFO] 1419754272.110456 - Executor-0 - Started. [INFO] 1419754272.113945 - Executor-1 - Started. [DEBUG] 1419754272.125309 - Executor-0 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754272.129946 - Executor-1 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [INFO] 1419754272.131583 - Executor-2 - Started. [INFO] 1419754272.135239 - Executor-3 - Started. [DEBUG] 1419754272.139052 - Executor-2 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754272.143033 - Executor-3 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [INFO] 1419754272.144608 - Executor-4 - Started. [INFO] 1419754272.146492 - MainThread - Executor started. [DEBUG] 1419754272.147485 - MainThread - Statement (SELECT DISTINCT proc_uuid FROM checkpoints WHERE proc_uuid IN (SELECT DISTINCT chk_info.proc_uuid FROM checkpoints as chk_info WHERE chk_info.finished is NOT NULL) and proc_uuid NOT IN (SELECT DISTINCT chk_info.proc_uuid FROM checkpoints as chk_info WHERE chk_info.finished is NULL), Params(()). [DEBUG] 1419754272.151274 - MainThread - Statement (SELECT chk_info.proc_uuid, chk_info.lockable_objects, chk_info.job_uuid, chk_info.sequence, chk_info.action_fqn, chk_info.param_args, chk_info.param_kwargs, chk_info.started, chk_info.finished FROM (SELECT proc_uuid, max(sequence) as sequence FROM checkpoints WHERE started is NOT NULL AND finished is NULL GROUP BY proc_uuid) AS chk_core INNER JOIN (SELECT proc_uuid, lockable_objects, job_uuid, sequence, action_fqn, param_args, param_kwargs, started, finished FROM checkpoints) AS chk_info ON chk_info.proc_uuid = chk_core.proc_uuid and chk_info.sequence = chk_core.sequence, Params(()). [DEBUG] 1419754272.155301 - MainThread - Statement (SELECT proc_uuid, lockable_objects, job_uuid, sequence, action_fqn, param_args, param_kwargs, started, finished FROM checkpoints WHERE finished is NULL ORDER BY proc_uuid, sequence, Params(()). [INFO] 1419754272.156573 - MainThread - Starting failure detector. [DEBUG] 1419754272.156858 - MainThread - Statement (SELECT group_id FROM groups WHERE status = %s, Params((1,)). [DEBUG] 1419754272.160094 - MainThread - MySQL-RPC server thread created [DEBUG] 1419754272.162567 - Executor-4 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [INFO] 1419754272.164334 - XML-RPC-Server - XML-RPC protocol server ('127.0.0.1', 32274) started. [DEBUG] 1419754272.164900 - MainThread - XML-RPC server thread created [INFO] 1419754272.165637 - XML-RPC-Server - Setting 1 XML-RPC session(s). [INFO] 1419754272.167321 - XML-RPC-Session-0 - Started XML-RPC-Session. [DEBUG] 1419754272.171312 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). -bash-4.2$ mysqlfabric group create test [DEBUG] 1419754281.931232 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60268)) through thread (). [DEBUG] 1419754281.931860 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60268)) through thread (). [DEBUG] 1419754281.936786 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60268)) through thread (). [DEBUG] 1419754281.941406 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60270)) through thread (). [DEBUG] 1419754281.941635 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60270)) through thread (). [DEBUG] 1419754281.943887 - XML-RPC-Session-0 - Statement (SELECT username, protocol, passwordFROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754281.949734 - XML-RPC-Session-0 - Statement (SELECT p.subsystem, p.component, p.functionFROM users AS u LEFT JOIN user_roles AS ur USING (user_id) LEFT JOIN role_permissions AS rp USING (role_id) LEFT JOIN permissions AS p USING (permission_id)WHERE u.username = %s AND protocol = %s, Params((u'admin', u'xmlrpc')). [DEBUG] 1419754281.952631 - XML-RPC-Session-0 - Started command (group, create). [DEBUG] 1419754281.953036 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.create', datetime.datetime(2014, 12, 28, 8, 11, 21), 'mysql.fabric.command', 'Started command (group, create).', 1, 0)). [DEBUG] 1419754281.956843 - XML-RPC-Session-0 - Triggering event in handler [DEBUG] 1419754281.957019 - XML-RPC-Session-0 - Triggering event [DEBUG] 1419754281.957460 - XML-RPC-Session-0 - Created procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.957909 - XML-RPC-Session-0 - Created job (1d23e138-6edd-4531-8b52-588e30adba99, 50cde808-30c0-449c-b968-ddc0b6b12c97, mysql.fabric.services.server._create_group, Success). [DEBUG] 1419754281.958836 - XML-RPC-Session-0 - Statement (BEGIN, Params(()). [DEBUG] 1419754281.960588 - XML-RPC-Session-0 - Statement (INSERT INTO checkpoints(proc_uuid, lockable_objects, job_uuid, sequence, action_fqn, param_args, param_kwargs) VALUES (%s, %s, %s, %s, %s, %s, %s), Params(('1d23e138-6edd-4531-8b52-588e30adba99', "c__builtin__\nset\np0\n((lp1\nS'lock'\np2\natp3\nRp4\n.", '50cde808-30c0-449c-b968-ddc0b6b12c97', 0, 'mysql.fabric.services.server._create_group', "(S'test'\np0\nNtp1\n.", '(dp0\n.')). [DEBUG] 1419754281.961370 - XML-RPC-Session-0 - Statement (COMMIT, Params(()). [DEBUG] 1419754281.962975 - XML-RPC-Session-0 - Enqueued procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.963268 - Executor-0 - Locking procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.963391 - Executor-0 - LockManager - Enqueuing request for procedure () on objects(set(['lock'])). [DEBUG] 1419754281.963651 - Executor-0 - Locked procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.963816 - Executor-0 - Executing procedure (). [DEBUG] 1419754281.963960 - Executor-0 - Reading next job from queue, found .', 'success': 2}]>. [DEBUG] 1419754281.964142 - Executor-0 - Processing job (1d23e138-6edd-4531-8b52-588e30adba99, 50cde808-30c0-449c-b968-ddc0b6b12c97, mysql.fabric.services.server._create_group, Success). [DEBUG] 1419754281.964509 - Executor-0 - Statement (UPDATE checkpoints set started = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754281.964244, '1d23e138-6edd-4531-8b52-588e30adba99', '50cde808-30c0-449c-b968-ddc0b6b12c97')). [DEBUG] 1419754281.966993 - Executor-0 - Statement (BEGIN, Params(()). [DEBUG] 1419754281.967495 - Executor-0 - Executing _create_group [DEBUG] 1419754281.967649 - Executor-0 - Statement (SELECT group_id, description, master_uuid, master_defined, status FROM groups WHERE group_id = %s, Params(('test',)). [DEBUG] 1419754281.968681 - Executor-0 - Statement (INSERT INTO groups(group_id, description, status) VALUES(%s, %s, %s), Params(('test', None, 0)). [DEBUG] 1419754281.969397 - Executor-0 - Added group (). [DEBUG] 1419754281.969567 - Executor-0 - Statement (UPDATE checkpoints set finished = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754281.96952, '1d23e138-6edd-4531-8b52-588e30adba99', '50cde808-30c0-449c-b968-ddc0b6b12c97')). [DEBUG] 1419754281.970349 - Executor-0 - Statement (COMMIT, Params(()). [DEBUG] 1419754281.972469 - Executor-0 - Complete job (1d23e138-6edd-4531-8b52-588e30adba99, 50cde808-30c0-449c-b968-ddc0b6b12c97, mysql.fabric.services.server._create_group, Success). [DEBUG] 1419754281.972927 - Executor-0 - Statement (DELETE FROM checkpoints WHERE proc_uuid = %s, Params(('1d23e138-6edd-4531-8b52-588e30adba99',)). [DEBUG] 1419754281.974578 - Executor-0 - Complete procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.974775 - Executor-0 - LockManager - Dequeuing request for procedure (). [DEBUG] 1419754281.974923 - Executor-0 - Released procedure - objects set(['lock']). [DEBUG] 1419754281.975111 - Executor-0 - Possible affected procedures set([]). [DEBUG] 1419754281.975224 - Executor-0 - Unlocked procedure (1d23e138-6edd-4531-8b52-588e30adba99). [DEBUG] 1419754281.975530 - XML-RPC-Session-0 - Result after wait: uuid='1d23e138-6edd-4531-8b52-588e30adba99', status='[{'diagnosis': '', 'state': 3, 'when': 1419754281.957891, 'description': 'Triggered by .', 'success': 2}, {'diagnosis': '', 'state': 4, 'when': 1419754281.964126, 'description': 'Executing action (_create_group).', 'success': 2}, {'diagnosis': '', 'state': 5, 'when': 1419754281.972448, 'description': 'Executed action (_create_group).', 'success': 2}]', result='True' [DEBUG] 1419754281.975608 - XML-RPC-Session-0 - Success: uuid='1d23e138-6edd-4531-8b52-588e30adba99', result='True' [DEBUG] 1419754281.975665 - XML-RPC-Session-0 - Finished command (group, create). [DEBUG] 1419754281.978864 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.create', datetime.datetime(2014, 12, 28, 8, 11, 21), 'mysql.fabric.command', 'Finished command (group, create).', 1, 1)). [DEBUG] 1419754281.980569 - XML-RPC-Session-0 - Encoded packet: [1, '5ca1ab1e-a007-feed-f00d-cab3fe13249e', 1, '', [{'info': {'names': ['uuid', 'finished', 'success', 'result']}, 'rows': [('1d23e138-6edd-4531-8b52-588e30adba99', True, True, True)]}, {'info': {'names': ['state', 'success', 'when', 'description']}, 'rows': [(3, 2, 1419754281.957891, 'Triggered by .'), (4, 2, 1419754281.964126, 'Executing action (_create_group).'), (5, 2, 1419754281.972448, 'Executed action (_create_group).')]}]] [DEBUG] 1419754281.981451 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60270)) through thread (). Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 uuid finished success result ------------------------------------ -------- ------- ------ 1d23e138-6edd-4531-8b52-588e30adba99 1 1 1 state success when description ----- ------- ------------- ------------------------------------------------------------- 3 2 1419754281.96 Triggered by . 4 2 1419754281.96 Executing action (_create_group). 5 2 1419754281.97 Executed action (_create_group). -bash-4.2$ mysqlfabric group add test 12.0.0.11 [DEBUG] 1419754293.819703 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60272)) through thread (). [DEBUG] 1419754293.820403 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60272)) through thread (). [DEBUG] 1419754293.823563 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60272)) through thread (). [DEBUG] 1419754293.829185 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60274)) through thread (). [DEBUG] 1419754293.829422 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60274)) through thread (). [DEBUG] 1419754293.831205 - XML-RPC-Session-0 - Statement (SELECT username, protocol, passwordFROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754293.836147 - XML-RPC-Session-0 - Statement (SELECT p.subsystem, p.component, p.functionFROM users AS u LEFT JOIN user_roles AS ur USING (user_id) LEFT JOIN role_permissions AS rp USING (role_id) LEFT JOIN permissions AS p USING (permission_id)WHERE u.username = %s AND protocol = %s, Params((u'admin', u'xmlrpc')). [DEBUG] 1419754293.839450 - XML-RPC-Session-0 - Started command (group, add). [DEBUG] 1419754293.840227 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.add', datetime.datetime(2014, 12, 28, 8, 11, 33), 'mysql.fabric.command', 'Started command (group, add).', 1, 0)). [DEBUG] 1419754293.843746 - XML-RPC-Session-0 - Triggering event in handler [DEBUG] 1419754293.843914 - XML-RPC-Session-0 - Triggering event [DEBUG] 1419754293.844329 - XML-RPC-Session-0 - Created procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.844603 - XML-RPC-Session-0 - Created job (69af11ce-7148-4ca8-8e16-92dfe63e6786, 10001079-1a0f-4e6d-92d3-7436dec83751, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754293.847846 - XML-RPC-Session-0 - Statement (BEGIN, Params(()). [DEBUG] 1419754293.848943 - XML-RPC-Session-0 - Statement (INSERT INTO checkpoints(proc_uuid, lockable_objects, job_uuid, sequence, action_fqn, param_args, param_kwargs) VALUES (%s, %s, %s, %s, %s, %s, %s), Params(('69af11ce-7148-4ca8-8e16-92dfe63e6786', "c__builtin__\nset\np0\n((lp1\nS'lock'\np2\natp3\nRp4\n.", '10001079-1a0f-4e6d-92d3-7436dec83751', 0, 'mysql.fabric.services.server._add_server', "(S'test'\np0\nS'12.0.0.11'\np1\nNI00\ntp2\n.", '(dp0\n.')). [DEBUG] 1419754293.850015 - XML-RPC-Session-0 - Statement (COMMIT, Params(()). [DEBUG] 1419754293.852161 - XML-RPC-Session-0 - Enqueued procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.852474 - Executor-1 - Locking procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.852589 - Executor-1 - LockManager - Enqueuing request for procedure () on objects(set(['lock'])). [DEBUG] 1419754293.852795 - Executor-1 - Locked procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.852957 - Executor-1 - Executing procedure (). [DEBUG] 1419754293.853112 - Executor-1 - Reading next job from queue, found .', 'success': 2}]>. [DEBUG] 1419754293.853370 - Executor-1 - Processing job (69af11ce-7148-4ca8-8e16-92dfe63e6786, 10001079-1a0f-4e6d-92d3-7436dec83751, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754293.854987 - Executor-1 - Statement (UPDATE checkpoints set started = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754293.853477, '69af11ce-7148-4ca8-8e16-92dfe63e6786', '10001079-1a0f-4e6d-92d3-7436dec83751')). [DEBUG] 1419754293.857892 - Executor-1 - Statement (BEGIN, Params(()). [DEBUG] 1419754293.858418 - Executor-1 - Executing _add_server [DEBUG] 1419754293.858569 - Executor-1 - Statement (SELECT group_id, description, master_uuid, master_defined, status FROM groups WHERE group_id = %s, Params(('test',)). [DEBUG] 1419754293.859786 - Executor-1 - Start executing function: discover_uuid((), {'connection_timeout': 1, 'address': '12.0.0.11'}). [DEBUG] 1419754293.863419 - Executor-1 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754293.865495 - Executor-1 - Finish executing function: discover_uuid. [DEBUG] 1419754293.865673 - Executor-1 - Statement (SELECT server_uuid, server_address, mode, status, weight, group_id FROM servers WHERE server_uuid = %s, Params(('a6dcd87a-8e64-11e4-a8b6-0800277db20d',)). [DEBUG] 1419754293.872668 - Executor-1 - Using connection (). [DEBUG] 1419754293.872894 - Executor-1 - Statement (SELECT @@GLOBAL.SERVER_UUID as SERVER_UUID, Params(()). [DEBUG] 1419754293.874226 - Executor-1 - Statement (SELECT @@GLOBAL.SERVER_ID as SERVER_ID, Params(()). [DEBUG] 1419754293.875494 - Executor-1 - Statement (SELECT @@GLOBAL.VERSION as VERSION, Params(()). [DEBUG] 1419754293.876857 - Executor-1 - Statement (SELECT @@GLOBAL.GTID_MODE as GTID_MODE, Params(()). [DEBUG] 1419754293.877994 - Executor-1 - Statement (SELECT @@GLOBAL.LOG_BIN as LOG_BIN, Params(()). [DEBUG] 1419754293.879649 - Executor-1 - Statement (SELECT @@GLOBAL.READ_ONLY as READ_ONLY, Params(()). [DEBUG] 1419754293.881028 - Executor-1 - Connected to server with uuid (a6dcd87a-8e64-11e4-a8b6-0800277db20d), server_id (11), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754293.881211 - Executor-1 - Statement (SHOW GRANTS, Params(()). [DEBUG] 1419754293.882840 - Executor-1 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754293.884729 - Executor-1 - Statement (INSERT INTO servers(server_uuid, server_address, mode, status, weight, group_id) values(%s, %s, %s, %s, %s, %s), Params(('a6dcd87a-8e64-11e4-a8b6-0800277db20d', '12.0.0.11', 1, 2, 1.0, None)). [DEBUG] 1419754293.885890 - Executor-1 - Statement (UPDATE servers SET group_id = %s WHERE server_uuid = %s, Params(('test', 'a6dcd87a-8e64-11e4-a8b6-0800277db20d')). [DEBUG] 1419754293.887553 - Executor-1 - Added server () to group (). [DEBUG] 1419754293.887754 - Executor-1 - Disconnecting from server with uuid (a6dcd87a-8e64-11e4-a8b6-0800277db20d), server_id (11), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754293.887963 - Executor-1 - Statement (UPDATE checkpoints set finished = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754293.887908, '69af11ce-7148-4ca8-8e16-92dfe63e6786', '10001079-1a0f-4e6d-92d3-7436dec83751')). [DEBUG] 1419754293.891297 - Executor-1 - Statement (COMMIT, Params(()). [DEBUG] 1419754293.893657 - Executor-1 - Complete job (69af11ce-7148-4ca8-8e16-92dfe63e6786, 10001079-1a0f-4e6d-92d3-7436dec83751, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754293.894930 - Executor-1 - Statement (DELETE FROM checkpoints WHERE proc_uuid = %s, Params(('69af11ce-7148-4ca8-8e16-92dfe63e6786',)). [DEBUG] 1419754293.897501 - Executor-1 - Complete procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.897708 - Executor-1 - LockManager - Dequeuing request for procedure (). [DEBUG] 1419754293.897879 - Executor-1 - Released procedure - objects set(['lock']). [DEBUG] 1419754293.898049 - Executor-1 - Possible affected procedures set([]). [DEBUG] 1419754293.898178 - Executor-1 - Unlocked procedure (69af11ce-7148-4ca8-8e16-92dfe63e6786). [DEBUG] 1419754293.898357 - XML-RPC-Session-0 - Result after wait: uuid='69af11ce-7148-4ca8-8e16-92dfe63e6786', status='[{'diagnosis': '', 'state': 3, 'when': 1419754293.844577, 'description': 'Triggered by .', 'success': 2}, {'diagnosis': '', 'state': 4, 'when': 1419754293.853354, 'description': 'Executing action (_add_server).', 'success': 2}, {'diagnosis': '', 'state': 5, 'when': 1419754293.893632, 'description': 'Executed action (_add_server).', 'success': 2}]', result='True' [DEBUG] 1419754293.898623 - XML-RPC-Session-0 - Success: uuid='69af11ce-7148-4ca8-8e16-92dfe63e6786', result='True' [DEBUG] 1419754293.898866 - XML-RPC-Session-0 - Finished command (group, add). [DEBUG] 1419754293.899286 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.add', datetime.datetime(2014, 12, 28, 8, 11, 33), 'mysql.fabric.command', 'Finished command (group, add).', 1, 1)). [DEBUG] 1419754293.901758 - XML-RPC-Session-0 - Encoded packet: [1, '5ca1ab1e-a007-feed-f00d-cab3fe13249e', 1, '', [{'info': {'names': ['uuid', 'finished', 'success', 'result']}, 'rows': [('69af11ce-7148-4ca8-8e16-92dfe63e6786', True, True, True)]}, {'info': {'names': ['state', 'success', 'when', 'description']}, 'rows': [(3, 2, 1419754293.844577, 'Triggered by .'), (4, 2, 1419754293.853354, 'Executing action (_add_server).'), (5, 2, 1419754293.893632, 'Executed action (_add_server).')]}]] [DEBUG] 1419754293.902497 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60274)) through thread (). Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 uuid finished success result ------------------------------------ -------- ------- ------ 69af11ce-7148-4ca8-8e16-92dfe63e6786 1 1 1 state success when description ----- ------- ------------- ------------------------------------------------------------- 3 2 1419754293.84 Triggered by . 4 2 1419754293.85 Executing action (_add_server). 5 2 1419754293.89 Executed action (_add_server). -bash-4.2$ mysqlfabric group add test 12.0.0.12 [DEBUG] 1419754296.476857 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60278)) through thread (). [DEBUG] 1419754296.477726 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60278)) through thread (). [DEBUG] 1419754296.482131 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60278)) through thread (). [DEBUG] 1419754296.488454 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60280)) through thread (). [DEBUG] 1419754296.488741 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60280)) through thread (). [DEBUG] 1419754296.491230 - XML-RPC-Session-0 - Statement (SELECT username, protocol, passwordFROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754296.495647 - XML-RPC-Session-0 - Statement (SELECT p.subsystem, p.component, p.functionFROM users AS u LEFT JOIN user_roles AS ur USING (user_id) LEFT JOIN role_permissions AS rp USING (role_id) LEFT JOIN permissions AS p USING (permission_id)WHERE u.username = %s AND protocol = %s, Params((u'admin', u'xmlrpc')). [DEBUG] 1419754296.498906 - XML-RPC-Session-0 - Started command (group, add). [DEBUG] 1419754296.499319 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.add', datetime.datetime(2014, 12, 28, 8, 11, 36), 'mysql.fabric.command', 'Started command (group, add).', 1, 0)). [DEBUG] 1419754296.503396 - XML-RPC-Session-0 - Triggering event in handler [DEBUG] 1419754296.503563 - XML-RPC-Session-0 - Triggering event [DEBUG] 1419754296.503950 - XML-RPC-Session-0 - Created procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.504224 - XML-RPC-Session-0 - Created job (5621c49f-fbae-4d86-8459-c42b6d89c217, 5eec5dab-de42-492a-8f17-f06e17598137, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754296.504675 - XML-RPC-Session-0 - Statement (BEGIN, Params(()). [DEBUG] 1419754296.505436 - XML-RPC-Session-0 - Statement (INSERT INTO checkpoints(proc_uuid, lockable_objects, job_uuid, sequence, action_fqn, param_args, param_kwargs) VALUES (%s, %s, %s, %s, %s, %s, %s), Params(('5621c49f-fbae-4d86-8459-c42b6d89c217', "c__builtin__\nset\np0\n((lp1\nS'lock'\np2\natp3\nRp4\n.", '5eec5dab-de42-492a-8f17-f06e17598137', 0, 'mysql.fabric.services.server._add_server', "(S'test'\np0\nS'12.0.0.12'\np1\nNI00\ntp2\n.", '(dp0\n.')). [DEBUG] 1419754296.506241 - XML-RPC-Session-0 - Statement (COMMIT, Params(()). [DEBUG] 1419754296.508180 - XML-RPC-Session-0 - Enqueued procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.508506 - Executor-2 - Locking procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.508665 - Executor-2 - LockManager - Enqueuing request for procedure () on objects(set(['lock'])). [DEBUG] 1419754296.508862 - Executor-2 - Locked procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.509044 - Executor-2 - Executing procedure (). [DEBUG] 1419754296.509297 - Executor-2 - Reading next job from queue, found .', 'success': 2}]>. [DEBUG] 1419754296.509443 - Executor-2 - Processing job (5621c49f-fbae-4d86-8459-c42b6d89c217, 5eec5dab-de42-492a-8f17-f06e17598137, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754296.509953 - Executor-2 - Statement (UPDATE checkpoints set started = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754296.50956, '5621c49f-fbae-4d86-8459-c42b6d89c217', '5eec5dab-de42-492a-8f17-f06e17598137')). [DEBUG] 1419754296.512896 - Executor-2 - Statement (BEGIN, Params(()). [DEBUG] 1419754296.513437 - Executor-2 - Executing _add_server [DEBUG] 1419754296.513582 - Executor-2 - Statement (SELECT group_id, description, master_uuid, master_defined, status FROM groups WHERE group_id = %s, Params(('test',)). [DEBUG] 1419754296.514780 - Executor-2 - Start executing function: discover_uuid((), {'connection_timeout': 1, 'address': '12.0.0.12'}). [DEBUG] 1419754296.518225 - Executor-2 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754296.519942 - Executor-2 - Finish executing function: discover_uuid. [DEBUG] 1419754296.520842 - Executor-2 - Statement (SELECT server_uuid, server_address, mode, status, weight, group_id FROM servers WHERE server_uuid = %s, Params(('a8c203db-8e64-11e4-a8b6-0800276f2ebe',)). [DEBUG] 1419754296.524904 - Executor-2 - Using connection (). [DEBUG] 1419754296.525058 - Executor-2 - Statement (SELECT @@GLOBAL.SERVER_UUID as SERVER_UUID, Params(()). [DEBUG] 1419754296.527128 - Executor-2 - Statement (SELECT @@GLOBAL.SERVER_ID as SERVER_ID, Params(()). [DEBUG] 1419754296.528254 - Executor-2 - Statement (SELECT @@GLOBAL.VERSION as VERSION, Params(()). [DEBUG] 1419754296.530001 - Executor-2 - Statement (SELECT @@GLOBAL.GTID_MODE as GTID_MODE, Params(()). [DEBUG] 1419754296.531334 - Executor-2 - Statement (SELECT @@GLOBAL.LOG_BIN as LOG_BIN, Params(()). [DEBUG] 1419754296.532562 - Executor-2 - Statement (SELECT @@GLOBAL.READ_ONLY as READ_ONLY, Params(()). [DEBUG] 1419754296.533940 - Executor-2 - Connected to server with uuid (a8c203db-8e64-11e4-a8b6-0800276f2ebe), server_id (12), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754296.534111 - Executor-2 - Statement (SHOW GRANTS, Params(()). [DEBUG] 1419754296.536109 - Executor-2 - Statement (SELECT @@GLOBAL.SERVER_UUID, Params(()). [DEBUG] 1419754296.537489 - Executor-2 - Statement (INSERT INTO servers(server_uuid, server_address, mode, status, weight, group_id) values(%s, %s, %s, %s, %s, %s), Params(('a8c203db-8e64-11e4-a8b6-0800276f2ebe', '12.0.0.12', 1, 2, 1.0, None)). [DEBUG] 1419754296.538618 - Executor-2 - Statement (UPDATE servers SET group_id = %s WHERE server_uuid = %s, Params(('test', 'a8c203db-8e64-11e4-a8b6-0800276f2ebe')). [DEBUG] 1419754296.540386 - Executor-2 - Added server () to group (). [DEBUG] 1419754296.540539 - Executor-2 - Disconnecting from server with uuid (a8c203db-8e64-11e4-a8b6-0800276f2ebe), server_id (12), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754296.540720 - Executor-2 - Statement (UPDATE checkpoints set finished = %s WHERE proc_uuid = %s and job_uuid = %s, Params((1419754296.540673, '5621c49f-fbae-4d86-8459-c42b6d89c217', '5eec5dab-de42-492a-8f17-f06e17598137')). [DEBUG] 1419754296.541762 - Executor-2 - Statement (COMMIT, Params(()). [DEBUG] 1419754296.543565 - Executor-2 - Complete job (5621c49f-fbae-4d86-8459-c42b6d89c217, 5eec5dab-de42-492a-8f17-f06e17598137, mysql.fabric.services.server._add_server, Success). [DEBUG] 1419754296.544207 - Executor-2 - Statement (DELETE FROM checkpoints WHERE proc_uuid = %s, Params(('5621c49f-fbae-4d86-8459-c42b6d89c217',)). [DEBUG] 1419754296.546260 - Executor-2 - Complete procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.546459 - Executor-2 - LockManager - Dequeuing request for procedure (). [DEBUG] 1419754296.546611 - Executor-2 - Released procedure - objects set(['lock']). [DEBUG] 1419754296.546752 - Executor-2 - Possible affected procedures set([]). [DEBUG] 1419754296.546873 - Executor-2 - Unlocked procedure (5621c49f-fbae-4d86-8459-c42b6d89c217). [DEBUG] 1419754296.547065 - XML-RPC-Session-0 - Result after wait: uuid='5621c49f-fbae-4d86-8459-c42b6d89c217', status='[{'diagnosis': '', 'state': 3, 'when': 1419754296.504206, 'description': 'Triggered by .', 'success': 2}, {'diagnosis': '', 'state': 4, 'when': 1419754296.509427, 'description': 'Executing action (_add_server).', 'success': 2}, {'diagnosis': '', 'state': 5, 'when': 1419754296.543533, 'description': 'Executed action (_add_server).', 'success': 2}]', result='True' [DEBUG] 1419754296.547334 - XML-RPC-Session-0 - Success: uuid='5621c49f-fbae-4d86-8459-c42b6d89c217', result='True' [DEBUG] 1419754296.547531 - XML-RPC-Session-0 - Finished command (group, add). [DEBUG] 1419754296.547920 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.add', datetime.datetime(2014, 12, 28, 8, 11, 36), 'mysql.fabric.command', 'Finished command (group, add).', 1, 1)). [DEBUG] 1419754296.550275 - XML-RPC-Session-0 - Encoded packet: [1, '5ca1ab1e-a007-feed-f00d-cab3fe13249e', 1, '', [{'info': {'names': ['uuid', 'finished', 'success', 'result']}, 'rows': [('5621c49f-fbae-4d86-8459-c42b6d89c217', True, True, True)]}, {'info': {'names': ['state', 'success', 'when', 'description']}, 'rows': [(3, 2, 1419754296.504206, 'Triggered by .'), (4, 2, 1419754296.509427, 'Executing action (_add_server).'), (5, 2, 1419754296.543533, 'Executed action (_add_server).')]}]] [DEBUG] 1419754296.550968 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60280)) through thread (). Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 uuid finished success result ------------------------------------ -------- ------- ------ 5621c49f-fbae-4d86-8459-c42b6d89c217 1 1 1 state success when description ----- ------- ------------- ------------------------------------------------------------- 3 2 1419754296.5 Triggered by . 4 2 1419754296.51 Executing action (_add_server). 5 2 1419754296.54 Executed action (_add_server). -bash-4.2$ mysqlfabric group health test [DEBUG] 1419754308.807270 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60284)) through thread (). [DEBUG] 1419754308.808070 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60284)) through thread (). [DEBUG] 1419754308.812343 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60284)) through thread (). [DEBUG] 1419754308.817253 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60286)) through thread (). [DEBUG] 1419754308.818121 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60286)) through thread (). [DEBUG] 1419754308.820112 - XML-RPC-Session-0 - Statement (SELECT username, protocol, passwordFROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754308.824535 - XML-RPC-Session-0 - Statement (SELECT p.subsystem, p.component, p.functionFROM users AS u LEFT JOIN user_roles AS ur USING (user_id) LEFT JOIN role_permissions AS rp USING (role_id) LEFT JOIN permissions AS p USING (permission_id)WHERE u.username = %s AND protocol = %s, Params((u'admin', u'xmlrpc')). [DEBUG] 1419754308.826804 - XML-RPC-Session-0 - Started command (group, health). [DEBUG] 1419754308.827772 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.health', datetime.datetime(2014, 12, 28, 8, 11, 48), 'mysql.fabric.command', 'Started command (group, health).', 1, 0)). [DEBUG] 1419754308.830444 - XML-RPC-Session-0 - Statement (SELECT group_id, description, master_uuid, master_defined, status FROM groups WHERE group_id = %s, Params(('test',)). [DEBUG] 1419754308.833009 - XML-RPC-Session-0 - Statement (SELECT server_uuid, server_address, mode, status, weight, group_id FROM servers WHERE group_id = %s, Params((u'test',)). [DEBUG] 1419754308.835636 - XML-RPC-Session-0 - Using connection (). [DEBUG] 1419754308.835840 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_UUID as SERVER_UUID, Params(()). [DEBUG] 1419754308.837275 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_ID as SERVER_ID, Params(()). [DEBUG] 1419754308.838480 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.VERSION as VERSION, Params(()). [DEBUG] 1419754308.839854 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.GTID_MODE as GTID_MODE, Params(()). [DEBUG] 1419754308.841103 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.LOG_BIN as LOG_BIN, Params(()). [DEBUG] 1419754308.842876 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.READ_ONLY as READ_ONLY, Params(()). [DEBUG] 1419754308.844211 - XML-RPC-Session-0 - Connected to server with uuid (a6dcd87a-8e64-11e4-a8b6-0800277db20d), server_id (11), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754308.844336 - XML-RPC-Session-0 - Start executing function: check_slave_issues((,), {}). [DEBUG] 1419754308.844456 - XML-RPC-Session-0 - Start executing function: get_slave_status((,), {}). [DEBUG] 1419754308.844570 - XML-RPC-Session-0 - Statement (SHOW SLAVE STATUS, Params(()). [DEBUG] 1419754308.848198 - XML-RPC-Session-0 - Finish executing function: get_slave_status. [DEBUG] 1419754308.848310 - XML-RPC-Session-0 - Finish executing function: check_slave_issues. [DEBUG] 1419754308.848413 - XML-RPC-Session-0 - Start executing function: slave_has_master((,), {}). [DEBUG] 1419754308.848461 - XML-RPC-Session-0 - Start executing function: get_slave_status((,), {}). [DEBUG] 1419754308.848461 - XML-RPC-Session-0 - Statement (SHOW SLAVE STATUS, Params(()). [DEBUG] 1419754308.852499 - XML-RPC-Session-0 - Finish executing function: get_slave_status. [DEBUG] 1419754308.852615 - XML-RPC-Session-0 - Finish executing function: slave_has_master. [DEBUG] 1419754308.853587 - XML-RPC-Session-0 - Using connection (). [DEBUG] 1419754308.853717 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_UUID as SERVER_UUID, Params(()). [DEBUG] 1419754308.855120 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_ID as SERVER_ID, Params(()). [DEBUG] 1419754308.857035 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.VERSION as VERSION, Params(()). [DEBUG] 1419754308.858371 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.GTID_MODE as GTID_MODE, Params(()). [DEBUG] 1419754308.860378 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.LOG_BIN as LOG_BIN, Params(()). [DEBUG] 1419754308.861602 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.READ_ONLY as READ_ONLY, Params(()). [DEBUG] 1419754308.862861 - XML-RPC-Session-0 - Connected to server with uuid (a8c203db-8e64-11e4-a8b6-0800276f2ebe), server_id (12), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754308.862988 - XML-RPC-Session-0 - Start executing function: check_slave_issues((,), {}). [DEBUG] 1419754308.863105 - XML-RPC-Session-0 - Start executing function: get_slave_status((,), {}). [DEBUG] 1419754308.863221 - XML-RPC-Session-0 - Statement (SHOW SLAVE STATUS, Params(()). [DEBUG] 1419754308.868386 - XML-RPC-Session-0 - Error executing function: get_slave_status. [DEBUG] 1419754308.871567 - XML-RPC-Session-0 - Error executing function: check_slave_issues. [DEBUG] 1419754308.871771 - XML-RPC-Session-0 - Disconnecting from server with uuid (a6dcd87a-8e64-11e4-a8b6-0800277db20d), server_id (11), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754308.872006 - XML-RPC-Session-0 - Disconnecting from server with uuid (a8c203db-8e64-11e4-a8b6-0800276f2ebe), server_id (12), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754308.872151 - XML-RPC-Session-0 - Finished command (group, health). [DEBUG] 1419754308.872951 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.health', datetime.datetime(2014, 12, 28, 8, 11, 48), 'mysql.fabric.command', 'Finished command (group, health).', 1, 1)). [DEBUG] 1419754308.875832 - XML-RPC-Session-0 - Encoded packet: [1, '5ca1ab1e-a007-feed-f00d-cab3fe13249e', 1, '', [{'info': {'names': ['uuid', 'is_alive', 'status', 'is_not_running', 'is_not_configured', 'io_not_running', 'sql_not_running', 'io_error', 'sql_error']}, 'rows': [('a6dcd87a-8e64-11e4-a8b6-0800277db20d', True, 'SECONDARY', False, True, False, False, 'False', 'False'), ('a8c203db-8e64-11e4-a8b6-0800276f2ebe', True, 'FAULTY', False, False, False, False, 'False', 'False')]}, {'info': {'names': ['issue']}, 'rows': []}]] [DEBUG] 1419754308.876555 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60286)) through thread (). Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 uuid is_alive status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error ------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------- --------- a6dcd87a-8e64-11e4-a8b6-0800277db20d 1 SECONDARY 0 1 0 0 False False a8c203db-8e64-11e4-a8b6-0800276f2ebe 1 FAULTY 0 0 0 0 False False issue ----- -bash-4.2$ mysqlfabric group health test [DEBUG] 1419754313.122429 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60288)) through thread (). [DEBUG] 1419754313.123323 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60288)) through thread (). [DEBUG] 1419754313.135223 - XML-RPC-Session-0 - Finishing request () from (('127.0.0.1', 60288)) through thread (). [DEBUG] 1419754313.146057 - XML-RPC-Server - Enqueuing request () from (('127.0.0.1', 60290)) through thread (). [DEBUG] 1419754313.146340 - XML-RPC-Session-0 - Processing request () from (('127.0.0.1', 60290)) through thread (). [DEBUG] 1419754313.149081 - XML-RPC-Session-0 - Statement (SELECT username, protocol, passwordFROM users WHERE username = %s AND protocol = %s, Params(('admin', 'xmlrpc')). [DEBUG] 1419754313.153747 - XML-RPC-Session-0 - Statement (SELECT p.subsystem, p.component, p.functionFROM users AS u LEFT JOIN user_roles AS ur USING (user_id) LEFT JOIN role_permissions AS rp USING (role_id) LEFT JOIN permissions AS p USING (permission_id)WHERE u.username = %s AND protocol = %s, Params((u'admin', u'xmlrpc')). [DEBUG] 1419754313.155858 - XML-RPC-Session-0 - Started command (group, health). [DEBUG] 1419754313.156272 - XML-RPC-Session-0 - Statement (INSERT INTO log (subject, reported, reporter, message, category, type) VALUES(%s, %s, %s, %s, %s, %s), Params(('group.health', datetime.datetime(2014, 12, 28, 8, 11, 53), 'mysql.fabric.command', 'Started command (group, health).', 1, 0)). [DEBUG] 1419754313.160998 - XML-RPC-Session-0 - Statement (SELECT group_id, description, master_uuid, master_defined, status FROM groups WHERE group_id = %s, Params(('test',)). [DEBUG] 1419754313.162548 - XML-RPC-Session-0 - Statement (SELECT server_uuid, server_address, mode, status, weight, group_id FROM servers WHERE group_id = %s, Params((u'test',)). [DEBUG] 1419754313.164747 - XML-RPC-Session-0 - Using connection (). [DEBUG] 1419754313.164984 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_UUID as SERVER_UUID, Params(()). [DEBUG] 1419754313.166394 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.SERVER_ID as SERVER_ID, Params(()). [DEBUG] 1419754313.167574 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.VERSION as VERSION, Params(()). [DEBUG] 1419754313.168962 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.GTID_MODE as GTID_MODE, Params(()). [DEBUG] 1419754313.170981 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.LOG_BIN as LOG_BIN, Params(()). [DEBUG] 1419754313.171959 - XML-RPC-Session-0 - Statement (SELECT @@GLOBAL.READ_ONLY as READ_ONLY, Params(()). [DEBUG] 1419754313.173836 - XML-RPC-Session-0 - Connected to server with uuid (a6dcd87a-8e64-11e4-a8b6-0800277db20d), server_id (11), version (5.6.22-log), gtid (True), binlog (True), read_only (False). [DEBUG] 1419754313.173971 - XML-RPC-Session-0 - Start executing function: check_slave_issues((,), {}). [DEBUG] 1419754313.174090 - XML-RPC-Session-0 - Start executing function: get_slave_status((,), {}). [DEBUG] 1419754313.174209 - XML-RPC-Session-0 - Statement (SHOW SLAVE STATUS, Params(()). [DEBUG] 1419754313.177593 - XML-RPC-Session-0 - Finish executing function: get_slave_status. [DEBUG] 1419754313.177701 - XML-RPC-Session-0 - Finish executing function: check_slave_issues. [DEBUG] 1419754313.177816 - XML-RPC-Session-0 - Start executing function: slave_has_master((,), {}). [DEBUG] 1419754313.177924 - XML-RPC-Session-0 - Start executing function: get_slave_status((,), {}). [DEBUG] 1419754313.178039 - XML-RPC-Session-0 - Statement (SHOW SLAVE STATUS, Params(()). [DEBUG] 1419754313.182542 - XML-RPC-Session-0 - Finish executing function: get_slave_status. [DEBUG] 1419754313.182650 - XML-RPC-Session-0 - Finish executing function: slave_has_master. [DEBUG] 1419754392.180772 - Thread-1 - purged 5 expired clients