Antonio Marques

I think they got COVID and left

The function `fix_group_counters()` is where the process is interrupted. But how is that value a duplicated PK ? Why the repair process stops and cleans up instead of warning?

``` postgres=# UPDATE sentry_groupedmessage SET num_comments = ( postgres(# SELECT COUNT(*) from sentry_activity postgres(# WHERE type = 8 and group_id = sentry_groupedmessage.id); ERROR: duplicate key value violates unique constraint "sentry_groupedmessage_pkey"...

> This seems to be a duplicate issue of something you posted a few months ago here: > > [getsentry/self-hosted#1498](https://github.com/getsentry/self-hosted/issues/1498) > > What's the status of your db? @hubertdeng123 my...

Now I got a new error updating from 22.8.0 to 22.9.0 Note that duplicated key is not the previous one. Every time it changes. Why and when is this PK...

Running migrations: Applying sentry.0314_bit_int_for_org_and_project_id... OK Applying sentry.0315_add_type_to_group... OK Applying sentry.0316_add_context_field_to_groupowner... OK Creating missing DSNs Correcting Group.num_comments counter ▶ Migrating file storage ... Done.

> Sorry, must've missed this in my notification feed. What was your fix for this? I did all recommendations here https://github.com/getsentry/self-hosted/issues/1498 without success. Removing all registers related to that ID...

> How do you do this if your trying to write something that only modifies a project level merge request approver rule. We have rules for merging to master and...

> I verified that this should be approvalrules and not approval_rules. According to the documentation if you try this it will fail because its hitting ProjectApprovalManager.set_approvers: > > ``` >...

up