openerp-india team mailing list archive

["Olivier Dony \(OpenERP\)" <1086396@xxxxxxxxxxxxxxxxxx>]

** Summary changed:

- the process_email_queue scheduled task sends mail twice, on mass-mailing
+ ir.cron's lock is discarded by scheduled jobs performing batch transactions, wreaking havoc

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1086396

Title:
  ir.cron's lock is discarded by scheduled jobs performing batch
  transactions, wreaking havoc

Status in OpenERP Server:
  Confirmed

Bug description:
  Hello,

  we discovered that the "mail" addon is sending some messages twice.

  This is because the cron task "commits" the cursor after each message,
  and it releases the lock which was acquired on "ir_cron" table.

    # Try to grab an exclusive lock on the job row from within the task transaction
    "SELECT * FROM ir_cron WHERE id=%s FOR UPDATE NOWAIT"

  So the same cron will be launched again without waiting the end of the
  previous one. and the "search" will grab some mail.messages which are
  already processed by the first job.

  We just sent some thousands of e-mails, and we had few of them which
  were sent twice.

  The fix should be simple: do not use the main cursor to send the
  e-mails.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1086396/+subscriptions