gitlab-test-tracking bot failing due to database uniqueness constraint
The most recent trace from journald:
``` Mar 09 00:39:53 gitlab gitlab-test-tracking-start[3151685]: 127.0.0.1 - - [09/Mar/2023 00:39:53] "POST / HTTP/1.1" 500 38 Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: INFO:root:project 1 job 1398893 finished Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: INFO:root:Job 1398893 (x86_64-darwin-validate, 281fddac) has JUnit output junit.xml Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: 2023-03-09 00:41:28 [FALCON] [ERROR] POST / => Traceback (most recent call last): Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "falcon/app.py", line 365, in falcon.app.App.__call__ Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/gitlab_webhook/__init__.py", line 45, in on_post Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: self.handle_event(decoded) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/gitlab_webhook/__init__.py", line 35, in handle_event Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: self.handle_job_event(event) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/test_tracking/webhook.py", line 24, in handle_job_event Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: self.ingest_job(proj_id, job_id) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/test_tracking/webhook.py", line 47, in ingest_job Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: loop.run_until_complete(ingest_junit.ingest(self.conn, job_name=job_name, commit_sha=sha, el=parsed)) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/5axq6aw8j3vcs2m7gi440cwpcckl7ql9-python3-3.10.9/lib/python3.10/asyncio/base_events.py", line 649, in run_until_complete Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: return future.result() Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/test_tracking/ingest_junit.py", line 77, in ingest Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: await ingest_testcase(conn, test_run_id, case) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/j4l5s7fsj549yz1y3qrv5mw51f47gw17-gitlab-triage-label-service-0.1/lib/python3.10/site-packages/test_tracking/ingest_junit.py", line 54, in ingest_testcase Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: await conn.execute(""" Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/fzdf75s9nwykwx3nmd0kc9hybv9adsyj-python3.10-asyncpg-0.27.0/lib/python3.10/site-packages/asyncpg/connection.py", line 319, in execute Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: _, status, _ = await self._execute( Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/fzdf75s9nwykwx3nmd0kc9hybv9adsyj-python3.10-asyncpg-0.27.0/lib/python3.10/site-packages/asyncpg/connection.py", line 1658, in _execute Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: result, _ = await self.__execute( Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/fzdf75s9nwykwx3nmd0kc9hybv9adsyj-python3.10-asyncpg-0.27.0/lib/python3.10/site-packages/asyncpg/connection.py", line 1683, in __execute Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: return await self._do_execute( Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "/nix/store/fzdf75s9nwykwx3nmd0kc9hybv9adsyj-python3.10-asyncpg-0.27.0/lib/python3.10/site-packages/asyncpg/connection.py", line 1730, in _do_execute Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: result = await executor(stmt, None) Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: File "asyncpg/protocol/protocol.pyx", line 201, in bind_execute Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: asyncpg.exceptions.UniqueViolationError: duplicate key value violates unique constraint "test_results_test_run_id_test_id_key" Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: DETAIL: Key (test_run_id, test_id)=(173932, 115042) already exists. Mar 09 00:41:28 gitlab gitlab-test-tracking-start[3151685]: 127.0.0.1 - - [09/Mar/2023 00:41:28] "POST / HTTP/1.1" 500 38 ```This happened a few times in a row, so GitLab disabled the webhook.
NB: this is a different bot—not ghc_perf_import—so it doesn't impact spurious failure retries.