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 !

Bài viết liên quan	Trả lời	Lượt xem
Doesn't execute the scheduled actions, help me? subscription ir.cron	1 thg 6 23	3165
[help] Write field 'nextcall' in ir.cron for Schedule Action, get Timezone user in xml file, Đã xử lý timezone ir.cron	4 thg 3 22	17842
Scheduler stuck when trying to change record value ir.cron Odoo11	0 thg 10 20	3359
impossible to modify fetchmail properties or disabled cron task Đã xử lý fetchmail ir.cron	1 thg 3 16	6078
How to Open Calendar view in OpenERP 8 calendar openerpv8	0 thg 3 15	3425

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!