Thread: Rép. : deadlock detected

Rép. : deadlock detected

From
"Erwan DUROSELLE"
Date:
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@seafrance.fr
-------------------------------------------------------------------------------


>>> "Henrik Steffen" <steffen@city-map.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@topconcepts.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
--------------------------------------------------------