/usr/local/mysql/libexec/mysqld, Version: 5.0.18-debug-log. started with: Tcp port: 0 Unix socket: (null) Time Id Command Argument 060221 15:29:56 1 Connect tomcat@192.168.6.104 on readytalk 1 Query SET NAMES latin1 1 Query SET character_set_results = NULL 1 Query SHOW VARIABLES 1 Query SHOW COLLATION 1 Prepare [1] 1 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx18' 1 Query SET autocommit=1 1 Prepare [2] 1 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 1 1 Query SET autocommit=1 1 Prepare [3] 1 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 1 or machines_and_groups.machine = 1 1 Query SET autocommit=1 1 Prepare [4] 1 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx18' 060221 15:29:57 3 Connect tomcat@192.168.6.104 on readytalk 3 Query SET NAMES latin1 3 Query SET character_set_results = NULL 3 Query SHOW VARIABLES 2 Connect tomcat@192.168.6.106 on readytalk 3 Query SHOW COLLATION 3 Prepare [1] 3 Execute [1] update servers set ip_address = '192.168.6.104' where id = 1 3 Prepare [2] 3 Execute [2] update machines set last_ping = now() where server = 1 3 Prepare [3] 3 Execute [3] update machines set alive = 1 where server = 1 2 Query SET NAMES latin1 2 Query SET character_set_results = NULL 2 Query SHOW VARIABLES 2 Query SHOW COLLATION 2 Prepare [1] 2 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx20' 4 Connect tomcat@192.168.6.107 on readytalk 2 Query SET autocommit=1 2 Prepare [2] 2 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 3 2 Query SET autocommit=1 4 Query SET NAMES latin1 2 Prepare [3] 2 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 3 or machines_and_groups.machine = 3 4 Query SET character_set_results = NULL 4 Query SHOW VARIABLES 2 Query SET autocommit=1 2 Prepare [4] 2 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx20' 4 Query SHOW COLLATION 5 Connect tomcat@192.168.6.105 on readytalk 4 Prepare [1] 4 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx21' 4 Query SET autocommit=1 4 Prepare [2] 4 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 4 4 Query SET autocommit=1 4 Prepare [3] 4 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 4 or machines_and_groups.machine = 4 6 Connect tomcat@192.168.6.108 on readytalk 7 Connect tomcat@192.168.6.106 on readytalk 7 Query SET NAMES latin1 7 Query SET character_set_results = NULL 7 Query SHOW VARIABLES 4 Query SET autocommit=1 7 Query SHOW COLLATION 4 Prepare [4] 4 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx21' 7 Prepare [1] 7 Execute [1] update servers set ip_address = '192.168.6.106' where id = 3 7 Prepare [2] 7 Execute [2] update machines set last_ping = now() where server = 3 7 Prepare [3] 7 Execute [3] update machines set alive = 1 where server = 3 6 Query SET NAMES latin1 6 Query SET character_set_results = NULL 6 Query SHOW VARIABLES 6 Query SHOW COLLATION 6 Prepare [1] 6 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx22' 8 Connect tomcat@192.168.6.107 on readytalk 8 Query SET NAMES latin1 8 Query SET character_set_results = NULL 8 Query SHOW VARIABLES 8 Query SHOW COLLATION 6 Query SET autocommit=1 6 Prepare [2] 6 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 5 8 Prepare [1] 8 Execute [1] update servers set ip_address = '192.168.6.107' where id = 4 8 Prepare [2] 8 Execute [2] update machines set last_ping = now() where server = 4 6 Query SET autocommit=1 8 Prepare [3] 6 Prepare [3] 8 Execute [3] update machines set alive = 1 where server = 4 6 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 5 or machines_and_groups.machine = 5 9 Connect tomcat@192.168.6.109 on readytalk 5 Query SET NAMES latin1 6 Query SET autocommit=1 6 Prepare [4] 6 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx22' 9 Query SET NAMES latin1 5 Query SET character_set_results = NULL 5 Query SHOW VARIABLES 9 Query SET character_set_results = NULL 9 Query SHOW VARIABLES 9 Query SHOW COLLATION 5 Query SHOW COLLATION 9 Prepare [1] 9 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx23' 11 Connect tomcat@192.168.6.108 on readytalk 11 Query SET NAMES latin1 10 Connect tomcat@192.168.6.110 on readytalk 11 Query SET character_set_results = NULL 11 Query SHOW VARIABLES 11 Query SHOW COLLATION 11 Prepare [1] 9 Query SET autocommit=1 11 Execute [1] update servers set ip_address = '192.168.6.108' where id = 5 9 Prepare [2] 11 Prepare [2] 9 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 6 11 Execute [2] update machines set last_ping = now() where server = 5 11 Prepare [3] 11 Execute [3] update machines set alive = 1 where server = 5 10 Query SET NAMES latin1 9 Query SET autocommit=1 9 Prepare [3] 9 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 6 or machines_and_groups.machine = 6 5 Prepare [1] 5 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx19' 10 Query SET character_set_results = NULL 10 Query SHOW VARIABLES 9 Query SET autocommit=1 9 Prepare [4] 9 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx23' 10 Query SHOW COLLATION 5 Query SET autocommit=1 5 Prepare [2] 5 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 2 5 Query SET autocommit=1 5 Prepare [3] 5 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 2 or machines_and_groups.machine = 2 10 Prepare [1] 10 Execute [1] select id, name, ip_address, port from servers inner join machines on servers.id = machines.server where name = 'lnx24' 5 Query SET autocommit=1 5 Prepare [4] 5 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx19' 10 Query SET autocommit=1 10 Prepare [2] 10 Execute [2] select groups.type - 1, servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join servers on machines_and_groups.group_ = servers.id inner join groups on servers.id = groups.server where machines_and_groups.machine = 7 10 Query SET autocommit=1 10 Prepare [3] 10 Execute [3] select server_properties.server, groups.type - 1, server_properties.key_, server_properties.value from servers left join machines_and_groups on servers.id = machines_and_groups.group_ left join groups on machines_and_groups.group_ = groups.server left join server_properties on servers.id = server_properties.server where server_properties.server = 7 or machines_and_groups.machine = 7 12 Connect tomcat@192.168.6.109 on readytalk 12 Query SET NAMES latin1 12 Query SET character_set_results = NULL 12 Query SHOW VARIABLES 10 Query SET autocommit=1 10 Prepare [4] 10 Execute [4] select servers.id from services_available left join servers on services_available.server = servers.id where services_available.service ='media' and servers.name = 'lnx24' 12 Query SHOW COLLATION 12 Prepare [1] 12 Execute [1] update servers set ip_address = '192.168.6.109' where id = 6 12 Prepare [2] 12 Execute [2] update machines set last_ping = now() where server = 6 12 Prepare [3] 12 Execute [3] update machines set alive = 1 where server = 6 13 Connect tomcat@192.168.6.105 on readytalk 13 Query SET NAMES latin1 13 Query SET character_set_results = NULL 13 Query SHOW VARIABLES 14 Connect tomcat@192.168.6.110 on readytalk 14 Query SET NAMES latin1 14 Query SET character_set_results = NULL 14 Query SHOW VARIABLES 13 Query SHOW COLLATION 13 Prepare [1] 13 Execute [1] update servers set ip_address = '192.168.6.105' where id = 2 14 Query SHOW COLLATION 13 Prepare [2] 13 Execute [2] update machines set last_ping = now() where server = 2 13 Prepare [3] 13 Execute [3] update machines set alive = 1 where server = 2 14 Prepare [1] 14 Execute [1] update servers set ip_address = '192.168.6.110' where id = 7 14 Prepare [2] 14 Execute [2] update machines set last_ping = now() where server = 7 14 Prepare [3] 14 Execute [3] update machines set alive = 1 where server = 7 060221 15:29:58 3 Prepare [4] 3 Execute [4] select 1 from blacklist where listed = 1 3 Query SET autocommit=0 3 Prepare [5] 3 Execute [5] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 1) 3 Prepare [6] 3 Execute [6] insert into messages_and_servers (message, server) select 3, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 3 Query commit 3 Query SET autocommit=1 3 Prepare [7] 3 Execute [7] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 1 3 Query SET autocommit=0 3 Prepare [8] 3 Prepare [9] 3 Execute [8] delete from messages_and_servers where message = 3 and server = 1 3 Execute [9] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 3 Query commit 8 Prepare [4] 3 Query SET autocommit=1 7 Prepare [4] 11 Prepare [4] 8 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 4 7 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 3 11 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 5 12 Prepare [4] 12 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 6 3 Prepare [10] 13 Prepare [4] 13 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 2 8 Query SET autocommit=0 7 Query SET autocommit=0 11 Query SET autocommit=0 3 Execute [10] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 1 or group_leaders.leader = 1 3 Query SET autocommit=1 8 Prepare [5] 7 Prepare [5] 11 Prepare [5] 3 Prepare [11] 8 Prepare [6] 12 Query SET autocommit=0 3 Execute [11] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 1 or group_leaders.leader = 1 7 Prepare [6] 3 Query SET autocommit=1 11 Prepare [6] 8 Execute [5] delete from messages_and_servers where message = 3 and server = 4 3 Prepare [12] 12 Prepare [5] 8 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 8 Query commit 7 Execute [5] delete from messages_and_servers where message = 3 and server = 3 11 Execute [5] delete from messages_and_servers where message = 3 and server = 5 8 Query SET autocommit=1 3 Execute [12] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 1 and groups.type = 1 11 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 11 Query commit 12 Prepare [6] 11 Query SET autocommit=1 13 Query SET autocommit=0 12 Execute [5] delete from messages_and_servers where message = 3 and server = 6 12 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 12 Query commit 8 Prepare [7] 12 Query SET autocommit=1 13 Prepare [5] 11 Prepare [7] 13 Prepare [6] 8 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 4 or group_leaders.leader = 4 12 Prepare [7] 8 Query SET autocommit=1 13 Execute [5] delete from messages_and_servers where message = 3 and server = 2 11 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 5 or group_leaders.leader = 5 8 Prepare [8] 13 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 13 Query commit 13 Query SET autocommit=1 11 Query SET autocommit=1 8 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 4 or group_leaders.leader = 4 12 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 6 or group_leaders.leader = 6 8 Query SET autocommit=1 11 Prepare [8] 8 Prepare [9] 11 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 5 or group_leaders.leader = 5 12 Query SET autocommit=1 11 Query SET autocommit=1 8 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 4 and groups.type = 1 11 Prepare [9] 8 Query SET autocommit=1 12 Prepare [8] 11 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 5 and groups.type = 1 12 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 6 or group_leaders.leader = 6 12 Query SET autocommit=1 12 Prepare [9] 8 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 4 or group_leaders.leader = 4 12 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 6 and groups.type = 1 13 Prepare [7] 13 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 2 or group_leaders.leader = 2 13 Query SET autocommit=1 14 Prepare [4] 14 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 7 13 Prepare [8] 13 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 2 or group_leaders.leader = 2 13 Query SET autocommit=1 14 Query SET autocommit=0 13 Prepare [9] 7 Query commit 7 Query SET autocommit=1 14 Prepare [5] 13 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 2 and groups.type = 1 13 Query SET autocommit=1 14 Prepare [6] 7 Prepare [7] 13 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 2 or group_leaders.leader = 2 14 Execute [5] delete from messages_and_servers where message = 3 and server = 7 14 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 7 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 3 or group_leaders.leader = 3 7 Query SET autocommit=1 14 Query commit 14 Query SET autocommit=1 7 Prepare [8] 7 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 3 or group_leaders.leader = 3 7 Query SET autocommit=1 7 Prepare [9] 14 Prepare [7] 7 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 3 and groups.type = 1 14 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 7 or group_leaders.leader = 7 7 Query SET autocommit=1 7 Prepare [10] 7 Execute [10] select 1 from blacklist where listed = 3 14 Query SET autocommit=1 14 Prepare [8] 7 Query SET autocommit=0 14 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 7 or group_leaders.leader = 7 7 Prepare [11] 14 Query SET autocommit=1 7 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 3) 14 Prepare [9] 7 Prepare [12] 14 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 7 and groups.type = 1 7 Execute [12] insert into messages_and_servers (message, server) select 4, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 7 Query commit 7 Query SET autocommit=1 8 Query SET autocommit=1 11 Query SET autocommit=1 12 Query SET autocommit=1 13 Query SET autocommit=1 7 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 3 8 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 4 14 Query SET autocommit=1 11 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 5 13 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 2 12 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 6 8 Query SET autocommit=0 7 Query SET autocommit=0 14 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 7 11 Query SET autocommit=0 12 Query SET autocommit=0 8 Execute [5] delete from messages_and_servers where message = 4 and server = 4 13 Query SET autocommit=0 14 Query SET autocommit=0 7 Execute [5] delete from messages_and_servers where message = 3 and server = 3 3 Query SET autocommit=1 11 Execute [5] delete from messages_and_servers where message = 4 and server = 5 7 Execute [5] delete from messages_and_servers where message = 4 and server = 3 12 Execute [5] delete from messages_and_servers where message = 4 and server = 6 14 Execute [5] delete from messages_and_servers where message = 4 and server = 7 3 Execute [7] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 1 3 Query SET autocommit=0 7 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 3 and messages_and_servers.message is null 3 Execute [8] delete from messages_and_servers where message = 4 and server = 1 13 Execute [5] delete from messages_and_servers where message = 4 and server = 2 7 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 4 and messages_and_servers.message is null 7 Query commit 7 Query SET autocommit=1 7 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 3 or group_leaders.leader = 3 7 Query SET autocommit=1 3 Query commit 3 Query SET autocommit=1 7 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 3 or group_leaders.leader = 3 7 Query SET autocommit=1 7 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 3) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 3 or (machines_and_groups.machine = 3 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 3 and groups.type = 1 3 Execute [10] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 1 or group_leaders.leader = 1 3 Query SET autocommit=1 3 Execute [11] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 1 or group_leaders.leader = 1 3 Query SET autocommit=1 3 Execute [12] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 1) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 1 or (machines_and_groups.machine = 1 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 1 and groups.type = 1 12 Query commit 12 Query SET autocommit=1 12 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 6 or group_leaders.leader = 6 12 Query SET autocommit=1 12 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 6 or group_leaders.leader = 6 12 Query SET autocommit=1 12 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 6 and groups.type = 1 13 Query commit 13 Query SET autocommit=1 14 Query commit 14 Query SET autocommit=1 13 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 2 or group_leaders.leader = 2 13 Query SET autocommit=1 14 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 7 or group_leaders.leader = 7 14 Query SET autocommit=1 13 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 2 or group_leaders.leader = 2 13 Query SET autocommit=1 14 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 7 or group_leaders.leader = 7 14 Query SET autocommit=1 13 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 2 and groups.type = 1 14 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 7 and groups.type = 1 8 Query commit 8 Query SET autocommit=1 8 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 4 or group_leaders.leader = 4 8 Query SET autocommit=1 8 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 4 or group_leaders.leader = 4 8 Query SET autocommit=1 8 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 4 and groups.type = 1 11 Query commit 11 Query SET autocommit=1 11 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 5 or group_leaders.leader = 5 11 Query SET autocommit=1 11 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 5 or group_leaders.leader = 5 11 Query SET autocommit=1 11 Execute [9] select servers.id, servers.name, servers.ip_address, servers.port from machines_and_groups inner join groups on machines_and_groups.group_ = groups.server inner join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ inner join servers on group_leaders.leader = servers.id where machines_and_groups.machine = 5 and groups.type = 1 060221 15:29:59 12 Query SET autocommit=1 12 Prepare [10] 12 Execute [10] select 1 from blacklist where listed = 6 12 Query SET autocommit=0 12 Prepare [11] 12 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 6) 12 Prepare [12] 14 Query SET autocommit=1 14 Prepare [10] 14 Execute [10] select 1 from blacklist where listed = 7 12 Execute [12] insert into messages_and_servers (message, server) select 5, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 12 Query commit 14 Query SET autocommit=0 14 Prepare [11] 14 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 7) 14 Prepare [12] 12 Query SET autocommit=1 13 Query SET autocommit=1 13 Prepare [10] 13 Execute [10] select 1 from blacklist where listed = 2 7 Query SET autocommit=1 12 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 6 3 Query SET autocommit=1 11 Query SET autocommit=1 14 Execute [12] insert into messages_and_servers (message, server) select 6, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 7) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 7 or (machines_and_groups.machine = 7 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 7 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 3 11 Prepare [10] 14 Query commit 12 Query SET autocommit=0 3 Execute [7] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 1 14 Query SET autocommit=1 7 Query SET autocommit=0 11 Execute [10] select 1 from blacklist where listed = 5 12 Execute [5] delete from messages_and_servers where message = 4 and server = 6 3 Query SET autocommit=0 7 Execute [5] delete from messages_and_servers where message = 5 and server = 3 13 Query SET autocommit=0 12 Execute [5] delete from messages_and_servers where message = 5 and server = 6 8 Query SET autocommit=1 13 Prepare [11] 3 Execute [8] delete from messages_and_servers where message = 4 and server = 1 14 Execute [4] select server_messages.id, key_ - 1, value, reference, servers.id, servers.name, servers.ip_address, servers.port from server_messages inner join messages_and_servers on server_messages.id = messages_and_servers.message inner join servers on server_messages.source = servers.id where messages_and_servers.server = 7 8 Prepare [10] 8 Execute [10] select 1 from blacklist where listed = 4 13 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 2) 12 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 4 and messages_and_servers.message is null 8 Query SET autocommit=0 8 Prepare [11] 13 Prepare [12] 12 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 5 and messages_and_servers.message is null 11 Query SET autocommit=0 8 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 4) 12 Query commit 11 Prepare [11] 12 Query SET autocommit=1 11 Execute [11] insert into server_messages (key_, value, reference, source) values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 5) 14 Query SET autocommit=0 8 Prepare [12] 14 Execute [5] delete from messages_and_servers where message = 4 and server = 7 14 Execute [5] delete from messages_and_servers where message = 5 and server = 7 11 Prepare [12] 14 Execute [5] delete from messages_and_servers where message = 6 and server = 7 7 Query commit 7 Query SET autocommit=1 12 Execute [7] select servers.id, servers.name, servers.ip_address, servers.port, services_provided.service - 1, services_provided.account from services_provided left join (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_leaders.leader) as leader from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on servers.id = group_leaders.group_ where valid_machines.machine or group_leaders.leader) as leaders on services_provided.provider = leaders.id left join servers on leaders.id = servers.id left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_provided.dependency = group_leaders.group_ where services_provided.dependency = 6 or group_leaders.leader = 6 14 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 4 and messages_and_servers.message is null 12 Query SET autocommit=1 14 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 5 and messages_and_servers.message is null 14 Execute [6] delete from server_messages using server_messages left join messages_and_servers on server_messages.id = messages_and_servers.message where server_messages.id = 6 and messages_and_servers.message is null 14 Query commit 14 Query SET autocommit=1 11 Execute [12] insert into messages_and_servers (message, server) select 9, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 5) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 5 or (machines_and_groups.machine = 5 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 11 Query commit 8 Execute [12] insert into messages_and_servers (message, server) select 8, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 4) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 4 or (machines_and_groups.machine = 4 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 8 Query commit 13 Execute [12] insert into messages_and_servers (message, server) select 7, members.member from (select servers.id as id, if(valid_machines.machine, valid_machines.machine, group_members.member) as member from servers left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on servers.id = valid_machines.machine left join (select group_, valid_machines.machine as member from machines_and_groups cross join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 2) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 2 or (machines_and_groups.machine = 2 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine) as group_members on servers.id = group_members.group_ where valid_machines.machine or group_members.member) as members where members.id = 10 13 Query commit 12 Execute [8] select services_required.service - 1, services_required.account from services_required left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select if(groups.type = 1, group_leaders.leader, servers.id) as blacklister from servers cross join machines_and_groups on servers.id = machines_and_groups.machine left join groups on machines_and_groups.group_ = groups.server left join (select group_, valid_machines.machine as leader from machines_and_groups left join (select machines.server as machine from machines left join blacklist on blacklist.lister in (select 6) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on groups.server = group_leaders.group_ where servers.id = 6 or (machines_and_groups.machine = 6 and groups.type = 1)) and blacklist.listed = machines.server where machines.alive and blacklist.listed is null ) as valid_machines on machines_and_groups.machine = valid_machines.machine where valid_machines.machine group by group_) as group_leaders on services_required.dependency = group_leaders.group_ where services_required.dependency = 6 or group_leaders.leader = 6 12 Query SET autocommit=1 11 Query SET autocommit=1