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	Відповіді	Переглядів
Doesn't execute the scheduled actions, help me? subscription ir.cron	1 черв. 23	3118
[help] Write field 'nextcall' in ir.cron for Schedule Action, get Timezone user in xml file, Вирішено timezone ir.cron	4 бер. 22	17769
Scheduler stuck when trying to change record value ir.cron Odoo11	0 жовт. 20	3343
impossible to modify fetchmail properties or disabled cron task Вирішено fetchmail ir.cron	1 бер. 16	6040
How to Open Calendar view in OpenERP 8 calendar openerpv8	0 бер. 15	3405

Це запитання позначене

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