Closed Bug 601679 Opened 14 years ago Closed 14 years ago

Add unique key to support-stage.mozilla.com database

Categories

(mozilla.org Graveyard :: Server Operations, task)

Product:
mozilla.org Graveyard
Component:
Server Operations
Type:
task
Priority:
Not set
Severity:
critical

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: abuchanan, Assigned: fox2mike)

References

Details

The support-stage database is missing a unique key definition that is causing duplicate tweets.

Please run this SQL on the support-stage.m.c DB...


TRUNCATE `customercare_tweet`; ALTER TABLE `customercare_tweet` ADD UNIQUE KEY (`tweet_id`);
Done.

mysql> TRUNCATE `customercare_tweet`; ALTER TABLE `customercare_tweet` ADD UNIQUE KEY
Query OK, 0 rows affected (0.05 sec)

    -> (`tweet_id`);
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0
Assignee: server-ops → shyam
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Verified FIXED; duplicate tweets are gone from https://support-stage.mozilla.org/en-US/army-of-awesome.
Status: RESOLVED → VERIFIED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.