protected function run1($stage)
{
$this->console->out('Updating `scaling_metrics`.`env_id`; Deleting broken records.');
$this->db->Execute('UPDATE `scaling_metrics` SET `env_id` = NULL WHERE `env_id` = 0');
$affected = $this->db->Affected_Rows();
$this->console->out("Updated {$affected} metrics.");
$this->db->Execute("\n DELETE FROM scaling_metrics\n WHERE env_id > 0 AND NOT EXISTS (\n SELECT 1 FROM client_environments\n WHERE client_environments.id = scaling_metrics.env_id\n )\n ");
$affected = $this->db->Affected_Rows();
$this->console->out("Deleted {$affected} outdated metrics.");
}