Page MenuHomePhabricator
Create Task
Maniphest T266253

Add extra logging to provide more info on silverpop export missing email failure
Closed, ResolvedPublic
Actions

Description

The silverpop export job has failed a couple of times due to the following error:

2020-10-22 03:19:39,907 ERROR   pymysql.err.IntegrityError: (1048, "Column 'email' cannot be null")

The error itself isn't very useful so let's see if we can capture this in the scripts and log instances with some more specifics.

Original discussion over on T265352

Related Objects

Event Timeline

jgleeson created this task.Oct 22 2020, 4:29 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 22 2020, 4:29 PM
jgleeson mentioned this in T265352: Civi to IBM export: Yesterday's files were sent today.Oct 22 2020, 8:02 PM
jgleeson added a subscriber: Eileenmcnaughton.
• DStrine moved this task from Triage to Sprint +3 on the Fundraising-Backlog board.Oct 23 2020, 5:52 PM
jgleeson added a comment.Nov 4 2020, 12:06 PM

this happened again today:

See the logs for more information: /var/log/process-control/silverpop_emails_build_export_files/silverpop_emails_build_export_files-20201104-030002.log

Eileenmcnaughton added a comment.Nov 4 2020, 7:22 PM

Hmm I had a feeling it was just bumped down from one table to the next last fix

jgleeson closed this task as Resolved.Nov 10 2020, 6:38 PM
jgleeson claimed this task.

Closing this as it looks like @Eileenmcnaughton fixed it in this patch

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL