E-mail notification on file add does not seem to be working

[Anthony]

I uploaded 3 files to my new community with the send mail alert turned on, but I have not received any messages in my inbox. It has been 30 minutes since the posting.

[Paul Everitt (paul-agendaless)]

Hi Anthony. I just restarted delivery of messages. Did you get the alerts that you had generated earlier?

[Anthony (agalietti)]

Hi Paul,

No, I did not receive any messages from Carlos.

-A

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of
Paul Everitt
Sent: Monday, April 06, 2009 5:32 PM
To: Anthony Galietti
Subject: [Bug 356351] Re: E-mail notification on file add does not seem
to beworking

Hi Anthony. I just restarted delivery of messages. Did you get the
alerts that you had generated earlier?

** Changed in: karl3
     Assignee: Paul Everitt (paul-agendaless) => Anthony (agalietti)

--
E-mail notification on file add does not seem to be working
https://bugs.launchpad.net/bugs/356351
You received this bug notification because you are a direct subscriber
of the bug.

Status in Porting KARL to a new architecture: New

Bug description:
I uploaded 3 files to my new community with the send mail alert turned
on, but I have not received any messages in my inbox. It has been 30
minutes since the posting.

[Paul Everitt (paul-agendaless)]

Anthony later confirmed that this was because the profile email address had gotten overwritten.

[Anthony (agalietti)]

Another Bug Reported by Chipp Winston:

I sent an email into a community about 9 minutes ago, and it never made it into the community, nor did it get sent out into alerts.

[Anthony (agalietti)]

FYI, Chipps community is Web-team, but this is probably happening to all communities.

[Paul Everitt (paul-agendaless)]

Hi Chris. Anthony reported that email is wedged again. Running the script, I got:

=================================================================
Processing mail-in content
=================================================================
Maildir root: /home/zope
Pending queue: /home/zope/Maildir/pending.db
ZODB URI: zeo://localhost:8884
=================================================================
Traceback (most recent call last):
  File "bin/mailin", line 74, in <module>
    osi.scripts.mailin.main()
  File "/var/db/karl3/src/osi/osi/scripts/mailin.py", line 279, in main
    MailinRunner(sys.argv)()
  File "/var/db/karl3/src/osi/osi/scripts/mailin.py", line 262, in __call__
    message_id = list(self.pending.pop())[0]
  File "/var/db/karl3/eggs/repoze.mailin-0.1.5-py2.5.egg/repoze/mailin/pending.py", line 44, in pop
    cursor = self.sql.execute('select id, message_id from pending '
sqlite3.OperationalError: Could not decode to UTF-8 column 'message_id' with text '<086801c9f304$8a00d960$d958485f@????>'

[Chris Rossi (chris-archimedeanco)]

There was a single message containing invalid characters in the Message-Id field which was causing the mail-in to back up.
The message in question was a pharmaceutical spam message from China. I have manually removed this message from the pending queue, and that has got mail-in working again.

This is a new failure vector, though, that we'll want to figure out how to be fault tolerant on.

[Paul Everitt (paul-agendaless)]

Marked as completed. Split of today's wrapup as 390836.

[Tres Seaver (tseaver)]

repoze.mailin 0.2 is now released to PyPI:

 http://pypi.python.org/pypi/repoze.mailin/0.2

and is available in the lemonade/dev index.