GitLab postgres instance reports duplicate keys (namespace_id in namespace_aggregation_schedules by ScheduleAggregationWorker)

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

On Alpine Linux GitLab instance (from source 12.4.7 (5159b8de4a6) ) we are seeing more and more duplicate keys errors from postgres. I am unable to find any reference in the issue tracker or on internet. Below is a small sample of postgres docker console:

postgres_1  | 2019-12-15 00:19:59.780 UTC [2816] ERROR:  duplicate key value violates unique constraint "namespace_aggregation_schedules_pkey"
postgres_1  | 2019-12-15 00:19:59.780 UTC [2816] DETAIL:  Key (namespace_id)=(2) already exists.
postgres_1  | 2019-12-15 00:19:59.780 UTC [2816] STATEMENT:  INSERT INTO "namespace_aggregation_schedules" ("namespace_id") VALUES ($1) RETURNING "namespace_id"
postgres_1  | 2019-12-15 18:14:18.472 UTC [4669] ERROR:  duplicate key value violates unique constraint "namespace_aggregation_schedules_pkey"
postgres_1  | 2019-12-15 18:14:18.472 UTC [4669] DETAIL:  Key (namespace_id)=(1282) already exists.
postgres_1  | 2019-12-15 18:14:18.472 UTC [4669] STATEMENT:  INSERT INTO "namespace_aggregation_schedules" ("namespace_id") VALUES ($1) RETURNING "namespace_id"
postgres_1  | 2019-12-15 21:00:32.850 UTC [4959] ERROR:  duplicate key value violates unique constraint "namespace_aggregation_schedules_pkey"
postgres_1  | 2019-12-15 21:00:32.850 UTC [4959] DETAIL:  Key (namespace_id)=(1282) already exists.
postgres_1  | 2019-12-15 21:00:32.850 UTC [4959] STATEMENT:  INSERT INTO "namespace_aggregation_schedules" ("namespace_id") VALUES ($1) RETURNING "namespace_id"
postgres_1  | 2019-12-15 21:28:47.885 UTC [4932] ERROR:  duplicate key value violates unique constraint "namespace_aggregation_schedules_pkey"
postgres_1  | 2019-12-15 21:28:47.885 UTC [4932] DETAIL:  Key (namespace_id)=(1654) already exists.
postgres_1  | 2019-12-15 21:28:47.885 UTC [4932] STATEMENT:  INSERT INTO "namespace_aggregation_schedules" ("namespace_id") VALUES ($1) RETURNING "namespace_id"