Handle email-in Message ID unicode failure

[Paul Everitt]

Email-in stopped working today:

  https://bugs.launchpad.net/karl3/+bug/356351/comments/8

...due to:

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@????>'

Write tests for this failure mode and provide a graceful degradation mode.

[Chris Rossi (chris-archimedeanco)]

FWIW, I just checked in a fix on the 1.0 branch of repoze.mailin that should fix this problem. Tres, you could still evaluate my fix and see if you agree with it, and then maybe cut a new release of repoze.mailin to get it in the pipe for Karl.

[Tres Seaver (tseaver)]

Fix for this is in repoze.mailin 0.2, now released to PyPI and the lemonade index.