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 !

相关帖文	回复	查看
Doesn't execute the scheduled actions, help me? subscription ir.cron	1 6月 23	2590
[help] Write field 'nextcall' in ir.cron for Schedule Action, get Timezone user in xml file, 已解决 timezone ir.cron	4 3月 22	16783
Scheduler stuck when trying to change record value ir.cron Odoo11	0 10月 20	3023
impossible to modify fetchmail properties or disabled cron task 已解决 fetchmail ir.cron	1 3月 16	5702
How to Open Calendar view in OpenERP 8 calendar openerpv8	0 3月 15	3222

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！