Database conflict error in mailin drops emails?

Tres, can you take a look at this? I'm making this a high priority because it means a possible loss of customer data.

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?

-----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-----

I have gotten the 12 emails from the original error distributed to where
they need to go.

Thanks,
Chris

Scheduling for this week.

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

 status fixcommitted

See revision 3483 in the karl trunk.

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

iD8DBQFKVMIu+gerLs4ltQ4RArdjAJ4uYHW5IXq4yuIkpMlDxcR+m1DbVgCcDEi4
56L1tyYFufnfkhCecEhJHhM=
=nq7O
-----END PGP SIGNATURE-----