Deadlock with tsearch2 index ...
От | Marc G. Fournier |
---|---|
Тема | Deadlock with tsearch2 index ... |
Дата | |
Msg-id | 20050531143855.K933@ganymede.hub.org обсуждение исходный текст |
Ответы |
Re: Deadlock with tsearch2 index ...
Re: Deadlock with tsearch2 index ... |
Список | pgsql-hackers |
Just want to make sure that this is, in fact, what is expected: client1: begin; client1: update articles set some_col = <foo> where id = <bar>; client2: update articles set some_col2 = <foo2> where id = <bar>; client1: update articles set some_col3 = <foo> where id = <bar>; client1: ** deadlock ** client2 can't finish its 'transaction', and is therefore preventing client1 from continuing ... ? Assuming that this is, in fact, 'normal', is there a way of breaking the deadlock? If this is *not*, in fact, 'normal', is there any more information that I can provide to debug this? This is a 7.4.6 database right now ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
В списке pgsql-hackers по дате отправления: