Cannot write to database while cron job is running

Question

Dear guys,
I have a scheduler ( ir.cron ) that runs a function that will send email to some users.
Basically, everytime my code send the email to the user, it will write to each object ( email_sent = True ) so that the next time the scheduler run it won't send email to that user again.
But when I check, the database will only be written after the scheduler has finished running( All emails has been sent )
I need it to write to database everytime the email is sent to each user.
Anyone know how to

Atul Makwana · Accepted Answer

In order to save the save the data between the scheduler run you can use *cr.commit() *below the code of mail send*. *
Or
in *mail.mail* object's send method you can pass *auto_commit* to *True*. Here is a sample code
self.pool.get('mail.mail').send(cr, uid, mail_ids, *auto_commit=True*, raise_exception=False, context=context)

Wilbert Tan · Answer

Hi Atul, I can't comment on your submission ( not enough karma ) .
And btw, using  cr.commit() actually works. But from what from what I read, it is actually not recommended to be used.
Refer here : https://www.odoo.com/forum/help-1/question/what-is-the-cr-commit-risk-how-to-safe-db-write-60885

I haven't tried the *auto_commit = True *as I am using ir.mail_server object to send email. Will try later.
Thank you !

Related Posts	Replies	Views
Doesn't execute the scheduled actions, help me? subscription ir.cron	1 Jun 23	1562
[help] Write field 'nextcall' in ir.cron for Schedule Action, get Timezone user in xml file, Solved timezone ir.cron	4 Mar 22	14999
Scheduler stuck when trying to change record value ir.cron Odoo11	0 Oct 20	2457
impossible to modify fetchmail properties or disabled cron task Solved fetchmail ir.cron	1 Mar 16	4989
How to Open Calendar view in OpenERP 8 calendar openerpv8	0 Mar 15	2693

This question has been flagged

Enjoying the discussion? Don't just read, join in!