Page MenuHomePhabricator

Based on the new log find out why those contact with donation get deleted
Open, Needs TriagePublic2 Estimated Story Points

Description

Since we should have 0 result for this query, which then our delete deleted contact can run smoothly
https://civicrm.wikimedia.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22contact_type:name%22,%22%3D%22,%22Individual%22%5D,%5B%22is_deleted%22,%22%3D%22,true%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5B%22Contribution%20AS%20Contact_Contribution_contact_id_01%22,%22INNER%22,%5B%22id%22,%22%3D%22,%22Contact_Contribution_contact_id_01.contact_id%22%5D%5D%5D,%22having%22:%5B%5D%7D
need to find out why those contact get deleted, can check the contact id from log after the parent ticket pr get merged
based on the log
2022-09-09 22:48:16,968 INFO This contact id is not able to be deleted: 8072059
2022-09-09 22:48:16,968 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,968 ERROR 8072059
2022-09-09 22:48:16,970 INFO This contact id is not able to be deleted: 7560321
2022-09-09 22:48:16,970 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,970 ERROR 7560321
2022-09-09 22:48:16,972 INFO This contact id is not able to be deleted: 7144044
2022-09-09 22:48:16,972 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,973 ERROR 7144044
2022-09-09 22:48:16,974 INFO This contact id is not able to be deleted: 6880091
2022-09-09 22:48:16,975 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,975 ERROR 6880091
2022-09-09 22:48:16,977 INFO This contact id is not able to be deleted: 6304870
2022-09-09 22:48:16,977 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,977 ERROR 6304870
2022-09-09 22:48:16,979 INFO This contact id is not able to be deleted: 4190267
2022-09-09 22:48:16,979 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,980 ERROR 4190267
2022-09-09 22:48:16,981 INFO This contact id is not able to be deleted: 3634198
2022-09-09 22:48:16,982 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,982 ERROR 3634198
2022-09-09 22:48:16,984 INFO This contact id is not able to be deleted: 3640571
2022-09-09 22:48:16,984 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,984 ERROR 3640571
2022-09-09 22:48:16,986 INFO This contact id is not able to be deleted: 'rOPUP230945703e92'
2022-09-09 22:48:16,987 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,987 ERROR 'rOPUP230945703e92'
2022-09-09 22:48:16,989 INFO This contact id is not able to be deleted: 2309680
2022-09-09 22:48:16,989 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,989 ERROR 2309680
2022-09-09 22:48:16,991 INFO This contact id is not able to be deleted: 2311599
2022-09-09 22:48:16,991 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,992 ERROR 2311599
2022-09-09 22:48:16,993 INFO This contact id is not able to be deleted: 2311609
2022-09-09 22:48:16,994 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,994 ERROR 2311609
2022-09-09 22:48:16,996 INFO This contact id is not able to be deleted: 2311619
2022-09-09 22:48:16,996 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,996 ERROR 2311619
2022-09-09 22:48:16,998 INFO This contact id is not able to be deleted: 2311630
2022-09-09 22:48:16,998 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:16,998 ERROR 2311630
2022-09-09 22:48:17,001 INFO This contact id is not able to be deleted: 2231364
2022-09-09 22:48:17,001 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,001 ERROR 2231364
2022-09-09 22:48:17,003 INFO This contact id is not able to be deleted: 2231369
2022-09-09 22:48:17,003 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,003 ERROR 2231369
2022-09-09 22:48:17,005 INFO This contact id is not able to be deleted: 2246932
2022-09-09 22:48:17,006 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,006 ERROR 2246932
2022-09-09 22:48:17,008 INFO This contact id is not able to be deleted: 2221100
2022-09-09 22:48:17,008 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,008 ERROR 2221100
2022-09-09 22:48:17,010 INFO This contact id is not able to be deleted: 1527003
2022-09-09 22:48:17,010 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,011 ERROR 1527003
2022-09-09 22:48:17,013 INFO This contact id is not able to be deleted: 1112492
2022-09-09 22:48:17,013 ERROR WD civicrm_cleanup_logs: This contact id is not able to be deleted: [notice]
2022-09-09 22:48:17,013 ERROR 1112492

Event Timeline

AnnWF removed AnnWF as the assignee of this task.Sep 7 2022, 10:22 PM
AnnWF created this task.
AnnWF updated the task description. (Show Details)
AnnWF updated the task description. (Show Details)
Dwisehaupt set the point value for this task to 2.Sep 12 2022, 8:36 PM

Moving to near future along with T317257: Create a cron job that query those contacts with donation get deleted, and send failmail to alert us to address in a thematically themed sprint on database maintenance