Chia Sẽ Kinh Nghiệm Về IT



Tìm Kiếm Với Google
-


ERP - Odoo Thảo luận chung về Vtiger CRM, Sugar CRM

Gởi Ðề Tài Mới  Gửi trả lời
 
Công Cụ Xếp Bài
Tuổi 18-12-2021, 09:03 AM   #1
hoctinhoc
Guest
 
Trả Lời: n/a
ERROR: could not obtain lock on row in relation "ir_cron"
ERROR: could not obtain lock on row in relation "ir_cron"


i'm encountering an error message when accessing postgresql log. The message appear to be like this one :

ERROR: could not obtain lock on row in relation "ir_cron" 2020-09-28 06:25:35.787 WITA [61738] odrmt@database STATEMENT: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=14 FOR UPDATE NOWAIT

After doing some research, as mentioned here on github the problem are caused by cron job that can't handle or execute the job in time. The cron restarts and if another one is running then it will lock (causing a long time loading until one is done)

The solution is editing odoo-server.conf file in /etc/odoo-server.conf and change max_cron_threads to "1" value so "the handler" of the job is only one to avoid this kind of lock in near future.
Nguồn: https://www.projectflakes.com/2020/0...on-row-in.html
  Trả lời ngay kèm theo trích dẫn này
Gửi trả lời


Công Cụ
Xếp Bài

Quyền Hạn Của Bạn
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is Mở
Hình Cảm xúc đang Mở
[IMG] đang Mở
Mã HTML đang Tắt




Bây giờ là 10:03 PM. Giờ GMT +7



Diễn đàn tin học QuantriNet
quantrinet.com | quantrimang.co.cc
Founded by Trương Văn Phương | Developed by QuantriNet's members.
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.