콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
3 답글
8210 화면

Hello,

 

My current version is Openerp V8 and pgsql server 9.3.

 

I keep getting this error from the log file and it seems to be the cause of slow operation on my system (confirming delivery orders and checking availability,...)

 

2014-08-11 10:29:05 ICT ERROR:  deadlock detected
2014-08-11 10:29:05 ICT DETAIL:  Process 38270 waits for ShareLock on transaction 36549; blocked by process 23702.
        Process 23702 waits for ShareLock on transaction 36548; blocked by process 38270.
        Process 38270: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33840)
        Process 23702: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33703)
2014-08-11 10:29:05 ICT HINT:  See server log for query details.

2014-08-11 10:29:05 ICT STATEMENT:  update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33840)

2014-08-11 10:29:27 ICT ERROR:  could not obtain lock on row in relation "res_users"
2014-08-11 10:29:27 ICT STATEMENT:  SELECT id FROM res_users WHERE id=1 FOR UPDATE NOWAIT

2014-08-11 10:29:25 ICT ERROR:  could not serialize access due to concurrent update
2014-08-11 10:29:25 ICT STATEMENT:  update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33799)

 

Is this a coding issue or hardware / server configuration issue ?

 

 

Thank you.

 

 

아바타
취소
베스트 답변

I have the same issue, could someone fix it ?

any help would be apreciated, thank you

아바타
취소
베스트 답변

i am using odoo8 with very large server for db - RDS -AWS and also ec2 for odoo server 8 core processor. 

i am using worker 8 only. and parallel pushing updating for product hit the database dead lock.

ERROR: deadlock detected DETAIL: Process 5329 waits for ShareLock on transaction 313080; blocked by process 9099. Process 9099 waits for ShareLock on transaction 313082; blocked by process 5329. HINT: See server log for query details. CONTEXT: while updating tuple (134,10) in relation "product_product"

any solutions, pls help....very very thanks and it is big big stopper for us and have to change the other erp if we can't overcome the problem?
아바타
취소
베스트 답변

Same issue.

Any solutions?

Thanks

아바타
취소
관련 게시물 답글 화면 활동
0
7월 25
1601
2
11월 24
6734
2
10월 24
3622
2
8월 24
2082
3
7월 24
8477