SYSTEM ERROR - production] - FAILED job ChainHostJob. Job failed with exception Mysql::Error: Duplicate entry '587-8010760' for key 'unique_index': INSERT INTO `engagements_counts` (`dms`, `created_at`, `user_dms`, `mentions`, `user_replies`, `updated_at`, `retweets`, `user_mentions`, `user_id`, `user_retweets`, `user_favorites`, `replies`, `member_id`) VALUES(NULL, '2012-05-08 11:19:57', NULL, NULL, NULL, '2012-05-08 11:19:57', NULL, NULL, 587, NULL, NULL, NULL, 8010760).

Failed job - chain: BasicChain, subchain: UpdateHighValueMembers, type: ChainHostJob, job id: 478072692, user_id: 587

/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log_without_newrelic_instrumentation'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/instrumentation/active_record.rb:31:in `log'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/instrumentation/active_record.rb:28:in `log'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/database_statements.rb:259:in `insert_sql'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/mysql_adapter.rb:334:in `insert_sql'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'/va r/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:142:in `send'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:142:in `send_to_master'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/query_cache_compat.rb:12:in `insert_without_query_dirty'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:2961:in `create_without_timestamps'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/timestamp.rb:53:in `create_without_callbacks'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/callbacks.rb:266:in `create'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:2927:in `create_or_update_without_callbacks'/var/lib/gems/1.8/gems/acti verecord-2.3.10/lib/active_record/callbacks.rb:250:in `create_or_update'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/base.rb:2577:in `save_without_validation'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/validations.rb:1090:in `save_without_dirty'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/dirty.rb:79:in `save_without_transactions'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:229:in `send'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:104:in `transaction'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/connection_proxy.rb:97:in `with_master'/var/lib/gems/1.8/gems/schoefmax-multi_db-0.2.1/lib/multi_db/conn ection_proxy.rb:104:in `transaction'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:182:in `transaction_without_deadlock_handling'/var/lib/gems/1.8/gems/deadlock_retry-1.1.1/lib/deadlock_retry.rb:36:in `transaction_without_trace_ActiveRecord_self_name_transaction'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/method_tracer.rb:491:in `transaction'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/method_tracer.rb:242:in `trace_execution_scoped'/var/lib/gems/1.8/gems/newrelic_rpm-3.3.2.1/lib/new_relic/agent/method_tracer.rb:486:in `transaction'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:196:in `save'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'/var/lib/gems/1.8/gems/activerecord-2.3.10/lib/active_reco rd/transactions.rb:196:in `save'/var/lib/gems/1