Uploaded image for project: 'Qt Quality Assurance Infrastructure'
  1. Qt Quality Assurance Infrastructure
  2. QTQAINFRA-6293

coin_scraper.py violates UNIQUE constraint, tries to insert duplicate changes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • P0: Blocker
    • None
    • production
    • Metrics / Test Results
    • None

    Description

      Happens consistently, after the recent long maintenance break.

       [ 1489475]    ERROR proc_update_tasks_needing_initial_details/root:  Unexpected Exception caught:
      Traceback (most recent call last):
        File "/home/jimis/coin_scraper/coin_scraper.py", line 344, in looping_process
          target_func()
        File "/home/jimis/coin_scraper/coin_scraper.py", line 253, in proc_update_tasks_needing_initial_details
          db.update_tasks_changes(tasks_details)
        File "/home/jimis/coin_scraper/postgres_storage_backend.py", line 375, in update_tasks_changes
          self.curs.execute(query)
        File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 236, in execute
          return super().execute(query, vars)
      psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "changes_unique_1"
      DETAIL:  Key (project_n, branch_n, changeid, sha) = (2, 1, I1147978a05bfedb63037c7f4437921f85a6aabb1, ef7b855388876b990b53b1b37168f51dd6ddc3c0) already exists.
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            jimis Dimitrios Apostolou
            jimis Dimitrios Apostolou
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes