@Ejegg - yes and the emails should have been copied over to the merged-to contact unless they duplicated

We just deployed the 1st 3 & got DB reduction 933.5G to 819.8G

@CDenes_WMF I think I've approved all the ones that you indicated were approved & am going to deploy them

Great - that sounds iminent!

Thanks @Jgreen - any idea about timeframes?

Ohh I'm excited to close this - we are on the verge of getting back to an unpatched version of Civi & not needing to use the half-baked version of this we have

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

@CDenes_WMF I see a few things have been deployed - are we still tracking via this phab or is it just all happening on IRC (& we should close the phab now)?

Ah just saw IRC :-)

@Dwisehaupt thanks -- so there are no triggers on civicrm_omnimail_job_progress at all now? (should be the case - just double checking)

@Dwisehaupt @Jgreen Can one of you please drop the following triggers on live Civi DB

@LeanneS OK to close - if you enter DAF now it should clear the no thank you field by javascript to help not make mistakes going fowards

Looks like I created a patch for this a long time ago - https://github.com/civicrm/civicrm-drupal/pull/529/files - need to get Tim to discuss with me

Per comment on the ticket I just merged into this

I just reviewed this for EFF & merged it - https://github.com/civicrm/civicrm-core/pull/15824 - pretty sure it will resolve this bug next civi upgrade - probably sooner than later since at this time of year we like to keep CIvi up to datte

@Dwisehaupt @Jeff_G @DStrine @Ejegg I've updated the document / response above and created a bunch of subtasks for the steps that I think we should take first. I haven't created a task for the review of backups / separate DB issue because I know Jeff & Dallas are already digging & perhaps there is a task.

So on digging into this & some notes

@LeanneS @NNichols - I've restored what I think makes sense to restore - see https://phabricator.wikimedia.org/T232636#5818528 for what is not included in that

Code changes for this are deployed - I set the thank you mail date range up from 60 days to 73 temporarily & re-ran the job & this query

@MBeat33 is this OK to close?

Regarding "Do we know when we'll hit a critical point? Is it knowable? If so, when?" -

@Ejegg do you want to take a look at https://phabricator.wikimedia.org/T243870#5871061 - I will convert it into tasks once I have some feedback

I'm working on my thoughts here https://docs.google.com/document/d/1PAHrjf1Z6iBrpqGR5xGQWW89c7aT1MZs7DogRerY3Kg/edit - only because I haven't figured out if there is anything in them I shouldn't post to phab

@Ppena the question I had I didn't get an answer to - ie is the goal to get the usd value of all donations that meet the criteria?

no idea what this means after all this time

I've created a bunch of subtasks to break this down - I'm never sure what to do with the parent task as the sub tasks get resolved