Rép. : deadlock detected
От | Erwan DUROSELLE |
---|---|
Тема | Rép. : deadlock detected |
Дата | |
Msg-id | 69b22f1ee498036aacdaac9901a880933da2a24a@ обсуждение исходный текст |
Список | 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@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 --------------------------------------------------------
В списке pgsql-general по дате отправления: