Comment 1 for bug 1359460

Revision history for this message
Kevin Benton (kevinbenton) wrote :

Current code was emitting queries like this.

SELECT routerl3agentbindings.id AS routerl3agentbindings_id, routerl3agentbindings.router_id AS routerl3agentbindings_router_id, routerl3agentbindings.l3_agent_id AS routerl3agentbindings_l3_agent_id
FROM routerl3agentbindings, agents
WHERE agents.heartbeat_timestamp < '2014-08-20 23:21:27.289744' AND agents.admin_state_up;