Re: Deadlock in PostgreSQL 7.3.4

Поиск
Список
Период
Сортировка
От Philipp Reisner
Тема Re: Deadlock in PostgreSQL 7.3.4
Дата
Msg-id 200308191152.36232.philipp.reisner@linbit.com
обсуждение исходный текст
Ответ на Re: Deadlock in PostgreSQL 7.3.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Deadlock in PostgreSQL 7.3.4
Список pgsql-bugs
Am Montag, 18. August 2003 15:38 schrieb Tom Lane:
> Philipp Reisner <philipp.reisner@linbit.com> writes:
> > Now if the applications issues one delete statement concurrently on
> > two connections both block forever.
> >
> > Please correct me if I am wrong, but should not one of the statements
> > succeed and the other simply fail ?
> >
> > Aug 18 10:34:25 nut1 postgres[4934]: [44389] LOG:
> >                      query: delete from Calls where objID = 2268645
> >
> > Aug 18 10:34:25 nut1 postgres[4933]: [44071] LOG:
> >                      query: delete from Calls where objID = 2268645
> >
> >  4933 ?        S      5:20 postgres: sd sd 10.2.1.5 idle in transaction
> >  4934 ?        S      5:08 postgres: sd sd 10.2.1.5 DELETE waiting
>
> I see no deadlock.  4933 is waiting for its client to issue another
> command.  4934 is waiting to see if it can delete the row.
>
>             regards, tom lane

Hi Tom,

Right, thanks for pointing it out for me. It seems to be somwhere in
the application code or PostgreSQL's jdbc driver.

Finally we are able to reproduce the "Lockup" and we will continue
to work out if it is in the App or in the jdbc driver.

-Philipp
--
: Dipl-Ing Philipp Reisner                      Tel +43-1-8178292-50 :
: LINBIT Information Technologies GmbH          Fax +43-1-8178292-82 :
: Schönbrunnerstr 244, 1120 Vienna, Austria    http://www.linbit.com :

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Marcus England"
Дата:
Сообщение: Re: Database Grants Bug
Следующее
От: Arnold Mavromatis
Дата:
Сообщение: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - PK v iolation