643321 - cron share_count_totals job failing on FK

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Maintenance Scripts, defect, P3)

Description

[Wil Clouser [:clouserw]]

[amo-developers] Cron <apache@mradm02> cd	/data/amo/www/addons.mozilla.org-remora/bin;	/usr/bin/python26 maintenance.py share_count_totals


Traceback (most recent call last):
  File "maintenance.py", line 217, in <module>
    main()
  File "maintenance.py", line 211, in main
    num_rows = f()
  File "/data/amo/www/addons.mozilla.org-remora/bin/utils.py", line 84, in wrapper
    return f()
  File "maintenance.py", line 66, in share_count_totals
    ','.join('"%s"' % x for x in LINK_SHARING_SERVICES))
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`addons_remora/stats_share_counts_totals`, CONSTRAINT `stats_share_counts_totals_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`))')

Comment 1

[Andy McKay]

r87302