cronscripts/rosetta-approve-imports.py aborting with "duplicate key value violation"

Bug #613695 reported by Steve McInerney
This bug report is a duplicate of:  Bug #613821: Approver violates unique constraint. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
New
Undecided
Unassigned

Bug Description

...

2010-08-05 01:33:57 WARNING Found 2 competing templates with translation domain 'kdgantt': "kdgantt in Ubuntu Maverick package "kdepim""; "kdgantt in Ubuntu Maverick package "koffice"".
2010-08-05 01:33:57 WARNING Found 2 competing templates with translation domain 'kdgantt': "kdgantt in Ubuntu Maverick package "kdepim""; "kdgantt in Ubuntu Maverick package "koffice"".
2010-08-05 01:33:57 WARNING Found 2 competing templates with translation domain 'kdgantt': "kdgantt in Ubuntu Maverick package "kdepim""; "kdgantt in Ubuntu Maverick package "koffice"".
2010-08-05 01:33:57 WARNING Found 2 competing templates with translation domain 'kdgantt': "kdgantt in Ubuntu Maverick package "kdepim""; "kdgantt in Ubuntu Maverick package "koffice"".
2010-08-05 01:33:57 DEBUG Removing lock file: /var/lock/launchpad-translations-import-queue-gardener.lock
Traceback (most recent call last):
  File "/srv/launchpad.net/production/launchpad/cronscripts/rosetta-approve-imports.py", line 19, in <module>
    script.lock_and_run()
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/lp/services/scripts/base.py", line 285, in lock_and_run
    implicit_begin=implicit_begin, isolation=isolation)
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/lp/services/scripts/base.py", line 243, in run
    self.main()
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/lp/translations/scripts/import_queue_gardener.py", line 32, in main
    if translation_import_queue.executeOptimisticApprovals(self.txn):
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/lp/translations/model/translationimportqueue.py", line 1200, in executeOptimisticApprovals
    getUtility(ILaunchpadCelebrities).rosetta_experts)
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/canonical/launchpad/utilities/celebrities.py", line 75, in __get__
    celebrity = self._getCelebrityByName(utility)
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/canonical/launchpad/utilities/celebrities.py", line 62, in _getCelebrityByName
    return utility.getByName(self.name)
  File "/srv/launchpad.net/production/launchpad-rev-9518/lib/lp/registry/model/person.py", line 2586, in getByName
    return Person.selectOne(query)
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/sqlobject.py", line 352, in selectOne
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/sqlobject.py", line 516, in _one
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/sqlobject.py", line 505, in _result_set
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/sqlobject.py", line 489, in _finish_result_set
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/sqlobject.py", line 483, in _prepare_result_set
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/store.py", line 206, in find
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/store.py", line 486, in flush
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/store.py", line 548, in _flush_one
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/databases/postgres.py", line 249, in execute
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/database.py", line 217, in execute
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/databases/postgres.py", line 259, in raw_execute
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/database.py", line 299, in raw_execute
  File "/home/pqm/for_rollouts/production/eggs/storm-0.15danilo_storm_launchpad_r342-py2.5-linux-x86_64.egg/storm/database.py", line 342, in _check_disconnect
psycopg2.IntegrityError: duplicate key value violates unique constraint "translationimportqueueentry__entry_per_importer__unq"

Steve McInerney (spm)
tags: added: canonical-losa-lp
Revision history for this message
Данило Шеган (danilo) wrote :

You did file it first, but I didn't notice it right away. I will transfer your tag to the other bug :)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.