From: | "Erwan DUROSELLE" <EDuroselle(at)seafrance(dot)fr> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Rép. : deadlock detected |
Date: | 2002-10-08 09:12:17 |
Message-ID: | 69b22f1ee498036aacdaac9901a880933da2a24a@ |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It means that 2 sessions were waiting for each other:
E.G.:
Session 1: lock table A
=> OK
Session 2: lock table B
=> OK
Session 1: lock table B
=> WAIT until B releases the lock
Session 2: lock table A
=> WAIT until A releases the lock
Everbody is waiting, until sth/so breaks this.
AFAIK, Pg has a builtin deadlock detection, which will rollback one of the sessions and let the other work.
Erwan
-------------------------------------------------------------------------------
Erwan DUROSELLE // SEAFRANCE DSI
Responsable Bases de Données // Databases Manager
Tel: +33 (0)1 55 31 59 70 // Fax: +33 (0)1 55 31 85 28
email: eduroselle(at)seafrance(dot)fr
-------------------------------------------------------------------------------
>>> "Henrik Steffen" <steffen(at)city-map(dot)de> 08/10/2002 08:31 >>>
hi,
what does the error message "deadlock detected" mean?
thanks,
Kind regards
Henrik Steffen
top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-10-08 09:21:05 | Re: PLTCL return_null crash... |
Previous Message | Richard Huxton | 2002-10-08 08:54:01 | Re: Design question, Does postgres provide a simpler solution than the obvious? |