Errant primary key constraint on missing_symbols table

RESOLVED FIXED

Status

RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: selenamarie, Assigned: selenamarie)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

issue reported in IRC:

2015-01-09 16:43:07,873 DEBUG - processor -  - Thread-4 - Rule socorro.processor.mozilla_transform_rules.MissingSymbolsRule action failed because of "duplicate key value violates unique constraint "missing_symbols_pkey"
DETAIL:  Key (debug_file)=(app_process) already exists.
"
Traceback (most recent call last):
  File "/data/socorro/socorro-virtualenv/lib/python2.7/site-packages/socorro-master-py2.7.egg/socorro/lib/transform_rules.py", line 94, in action
    return self._action(*args, **kwargs)
  File "/data/socorro/socorro-virtualenv/lib/python2.7/site-packages/socorro-master-py2.7.egg/socorro/processor/mozilla_transform_rules.py", line 788, in _action
    module['debug_id']
  File "/data/socorro/socorro-virtualenv/lib/python2.7/site-packages/socorro-master-py2.7.egg/socorro/database/transaction_executor.py", line 114, in __call__
    result = function(connection, *args, **kwargs)
  File "/data/socorro/socorro-virtualenv/lib/python2.7/site-packages/socorro-master-py2.7.egg/socorro/external/postgresql/dbapi2_util.py", line 62, in execute_no_results
    a_cursor.execute(sql, parameters)
IntegrityError: duplicate key value violates unique constraint "missing_symbols_pkey"
DETAIL:  Key (debug_file)=(app_process) already exists.

Comment 1

4 years ago
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/c1ec6f0428ecc7f50d49b75149e01609d9e96e78
Fixes bug 1119840 - remove PK from missing_symbols

https://github.com/mozilla/socorro/commit/7edcae2c0c651eb116c2e3c17589eb93e02274e4
Merge pull request #2558 from selenamarie/bug1119840-remove-missing-symbols-pk

Fixes bug 1119840 - remove PK from missing_symbols

Updated

4 years ago
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.