Page MenuHomePhabricator

Remove 'quick autoreviewed' entity tag
Closed, ResolvedPublic

Description

Minor help on disk & remove minor annoyance

Event Timeline

IN digging into this I found that of the old 'system' for tagging for review we have the following tags in our system:

`SELECT tag.id, tag.name, count(et.id) as c FROM civicrm_entity_tag et RIGHT JOIN civicrm_tag tag ON tag.id=tag_id WHERE tag.name LIKE '%reviewed%' AND tag.id < 30 GROUP BY tag.id ORDER BY c DESC;

idnamecount
17Quick autoreviewed10610860
16Autoreviewed - Unique0
22Manually reviewed - Revert address0
21Manually reviewed - Revert name0
20Manually reviewed - Revert email0
19Manually reviewed - Perform action0
23Manually reviewed - Revert language0

7 rows in set (2.62 sec)

In other words the 6 manual tags are not being used while around 10million contacts are tagged with Quick autoreviewed

I checked our codebase and we are not still assigning these tags & only 4 have been added since we turned logging on (presumably by user accident)
select * from log_civicrm_entity_tag WHERE tag_id =17 AND log_action = 'Insert' ORDER by log_date DESC LIMIT 10\G

ERGO I feel pretty confident doing the following

  1. untagging all contacts tagged with Quick autoreviewed
  2. deleting all references to the above from our audit log
  3. removing the 7 tags listed above

Ping @MBeat33 & @NNichols

@Eileenmcnaughton I'm good with this plan!

Jgreen moved this task from Triage to Watching on the fundraising-tech-ops board.Feb 19 2020, 10:40 PM
Eileenmcnaughton closed this task as Resolved.Mar 2 2020, 10:08 PM

We can't get a number on the DB reclaimed just yet though...

Jgreen moved this task from Watching to Done on the fundraising-tech-ops board.Mon, Jun 15, 3:07 PM