Comment 3 for bug 394355

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Rossi wrote:
> Since I have the message ids of those 12 messages in the log and the
> emails are still present in the filesystem, I'm going to attempt to
> manually requeue them in the pending.db. Does that seem like a
> reasonable thing to do, Tres?

I would first check the blogs of the affected communities to ensure that
the messages didn't in fact get through.

If in fact those blog entries weren't created, re-adding the message IDs
to the sqlite pending queue would probably work. You might should apply
the following patch first, to ensure that changes to the pending table
get committed only if the ZODB transaction commits.

- --- osi/scripts/mailin.py (revision 3376)
+++ osi/scripts/mailin.py (working copy)
@@ -272,8 +272,8 @@
             print
         if not self.dry_run:
             import transaction
+ transaction.commit()
             self.pending.sql.commit()
- - transaction.commit()

 def main():
     MailinRunner(sys.argv)()

I will then look at using a mechanism which coordinates the two
transactions more cleanly.

Tres.
- --
===================================================================
Tres Seaver +1 540-429-0999 <email address hidden>
Palladion Software "Excellence by Design" http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKS9MK+gerLs4ltQ4RAno5AJ9Tc+rvrqdVxMEUMmLkHGfgi9gElACeK7n/
QMinMk02Gd2xisc+X1OLkF4=
=It6c
-----END PGP SIGNATURE-----