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	3131
[help] Write field 'nextcall' in ir.cron for Schedule Action, get Timezone user in xml file, 해결 완료 timezone ir.cron	4 3월 22	17786
Scheduler stuck when trying to change record value ir.cron Odoo11	0 10월 20	3349
impossible to modify fetchmail properties or disabled cron task 해결 완료 fetchmail ir.cron	1 3월 16	6049
How to Open Calendar view in OpenERP 8 calendar openerpv8	0 3월 15	3410

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!