newrelic@nr00-s00026 ~/current $ rake maint:tstables:cleanup
(in /data/rpm/releases/20081107164550)
Working on shard: mysql50-staging
  Removing 63 tables left over from account 144...
    deleting ts_144_08305_17...done.
    deleting ts_144_08305_18...done.
    deleting ts_144_08305_21...done.
    deleting ts_144_08305_22...done.
    deleting ts_144_08305_23...done.
    deleting ts_144_08306_00...done.
    deleting ts_144_08306_01...done.
    deleting ts_144_08306_02...done.
    deleting ts_144_08306_03...done.
    deleting ts_144_08306_04...done.
    deleting ts_144_08306_05...done.
    deleting ts_144_08306_06...done.
    deleting ts_144_08306_07...done.
    deleting ts_144_08306_08...done.
    deleting ts_144_08306_09...done.
    deleting ts_144_08306_10...done.
    deleting ts_144_08306_11...done.
    deleting ts_144_08306_12...done.
    deleting ts_144_08306_13...done.
    deleting ts_144_08306_14...done.
    deleting ts_144_08306_15...done.
    deleting ts_144_08306_16...done.
    deleting ts_144_08306_17...done.
    deleting ts_144_08306_18...done.
    deleting ts_144_08306_19...done.
    deleting ts_144_08306_20...done.
    deleting ts_144_08306_21...done.
    deleting ts_144_08306_22...done.
    deleting ts_144_08306_23...done.
    deleting ts_144_08307_00...done.
    deleting ts_144_08307_01...done.
    deleting ts_144_08307_02...done.
    deleting ts_144_08307_03...done.
    deleting ts_144_08307_04...done.
    deleting ts_144_08307_05...done.
    deleting ts_144_08307_06...done.
    deleting ts_144_08307_07...done.
    deleting ts_144_08307_08...done.
    deleting ts_144_08307_09...done.
    deleting ts_144_08307_10...done.
    deleting ts_144_08307_11...done.
    deleting ts_144_08307_12...done.
    deleting ts_144_08307_13...done.
    deleting ts_144_08307_14...done.
    deleting ts_144_08307_15...done.
    deleting ts_144_08307_16...done.
    deleting ts_144_08307_17...done.
    deleting ts_144_08307_18...done.
    deleting ts_144_08307_19...done.
    deleting ts_144_08307_1h...done.
    deleting ts_144_08307_20...done.
    deleting ts_144_08307_21...done.
    deleting ts_144_08307_22...done.
    deleting ts_144_08307_23...done.
    deleting ts_144_08308_00...done.
    deleting ts_144_08308_01...done.
    deleting ts_144_08308_02...done.
    deleting ts_144_08308_03...done.
    deleting ts_144_08308_04...done.
    deleting ts_144_08308_05...done.
    deleting ts_144_08308_06...done.
    deleting ts_144_08308_07...done.
    deleting ts_144_08308_1h...done.
  Expired tables for NewRelic Administration:
    deleting ts_1_08282_08...done.
    deleting ts_1_08282_09...done.
    deleting ts_1_08282_10...done.
    deleting ts_1_08282_11...done.
    deleting ts_1_08282_12...done.
    deleting ts_1_08282_13...done.
    deleting ts_1_08282_14...done.
    deleting ts_1_08282_15...done.
    deleting ts_1_08282_16...done.
    deleting ts_1_08282_17...done.
    deleting ts_1_08282_18...done.
    deleting ts_1_08282_19...done.
    deleting ts_1_08282_20...done.
    deleting ts_1_08282_21...done.
    deleting ts_1_08282_22...done.
    deleting ts_1_08282_23...done.
  Expired tables for Canary Lite:
    deleting ts_147_08311_08...done.
    deleting ts_147_08311_09...done.
    deleting ts_147_08311_10...done.
    deleting ts_147_08311_11...done.
    deleting ts_147_08311_12...done.
    deleting ts_147_08311_13...done.
    deleting ts_147_08311_14...done.
    deleting ts_147_08311_15...done.
    deleting ts_147_08311_16...done.
    deleting ts_147_08311_17...done.
    deleting ts_147_08311_18...done.
    deleting ts_147_08311_19...done.
    deleting ts_147_08311_20...done.
    deleting ts_147_08311_21...done.
    deleting ts_147_08311_22...done.
    deleting ts_147_08311_23...done.
Found 95 expired tables out of a total of 1502 tables in shard.
Working on shard: mysql50-staging
Found 0 expired tables out of a total of 11 tables in shard.

Analyzed  tables across all shards.
                                   Shard   Dropped Remaining
                         mysql50-staging        95      1407
                         mysql50-staging         0        11
===============================================================================
                                   Total        95      1418
Caught an exception accessing the shard newrelic_db@mysql50-staging:rpm_staging_shard.
The current shard connection is closed!
rake aborted!
Mysql::Error: Cannot delete or update a parent row: a foreign key constraint fails (`rpm_staging_shard/heuristic_fired_events`, CONSTRAINT `heuristic_fired_events_ibfk_3` FOREIGN KEY (`incident_id`) REFERENCES `incidents` (`id`)): DELETE FROM `incidents` WHERE (opened_at < '2008-08-10 00:36:43')

(See full trace by running task with --trace)