Page MenuHomePhabricator

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

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

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

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

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

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

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