Query regarding deadlock
От | Yogesh Sharma |
---|---|
Тема | Query regarding deadlock |
Дата | |
Msg-id | 8F86F8F397DDD345B25EA2EF3E2164829ECC85D7@EXCH-MB02-U1.nectechnologies.in обсуждение исходный текст |
Ответы |
Re: Query regarding deadlock
Re: Query regarding deadlock Re: Query regarding deadlock Re: Query regarding deadlock |
Список | pgsql-general |
Dear All, Thanks in advance. I found below deadlock in postgresql logs. I cannot change calling of REINDEX and insert query sequence because it is execute automatically through some cron script. ERROR: deadlock detected DETAIL: Process 2234 waits for AccessShareLock on relation 16459 of database 16385; blocked by process 4111. Process 4111 waits for ShareLock on relation 16502 of database 16385; blocked by process 2234. Process 2234: INSERT INTO table1 ( id , unique_id )VALUES( '1', '4') Process 4111: REINDEX TABLE table1 Could you please provide any solution to resolve this deadlock. Regards, Yogesh
В списке pgsql-general по дате отправления: