Page MenuHomePhabricator

Stop logging & drop log_civicrm_omnimail_job_progress
Closed, ResolvedPublic2 Estimate Story Points

Description

Patch merged to remove it from triggers - need to

  1. regenerate triggers
  2. reload triggers (frtech-ops)
  3. get a 'before DB size'
  4. drop the table
  5. get an after db size
  6. update the 'epic' or wherever we are tracking progress on this

Details

Related Gerrit Patches:
wikimedia/fundraising/crm : masterRemove triggers from omnimail_job_progress

Event Timeline

Change 571845 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Remove triggers from omnimail_job_progress

https://gerrit.wikimedia.org/r/571845

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

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_insert

DELIMITER ;

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_update

DELIMITER ;

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_delete

DELIMITER ;

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_insert

DELIMITER ;

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_update

DELIMITER ;

DELIMITER
DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_delete

DELIMITER ;

Change 571845 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Remove triggers from omnimail_job_progress

https://gerrit.wikimedia.org/r/571845

These triggers have been dropped. Only the first three were present.

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_insert;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_update;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_before_delete;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_insert;
Query OK, 0 rows affected (0.01 sec)

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_update;
Query OK, 0 rows affected (0.00 sec)

MariaDB [civicrm]> DROP TRIGGER IF EXISTS civicrm_omnimail_job_progress_after_delete;
Query OK, 0 rows affected (0.01 sec)

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

Ah just saw IRC :-)

Jgreen moved this task from Triage to Watching on the fundraising-tech-ops board.Feb 19 2020, 10:42 PM
Eileenmcnaughton closed this task as Resolved.Feb 24 2020, 8:17 PM
Eileenmcnaughton set the point value for this task to 2.
Eileenmcnaughton set Final Story Points to 2.