Re: deadlock problem
От | Kevin Brown |
---|---|
Тема | Re: deadlock problem |
Дата | |
Msg-id | 20030331234128.GL1833@filer обсуждение исходный текст |
Ответ на | deadlock problem ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Список | pgsql-hackers |
Christopher Kings-Lynne wrote: > I'm always getting deadlocks like this: > > [30-Mar-2003 19:19:51] PHP Fatal error: postgres7 error: [0: ERROR: > deadlock detected > ] in EXECUTE("INSERT INTO users_foods (user_id, date, meal_id, quantity, > eaten, food_id) VALUES ('55283', '2003-04-07', '1', '1.00', 'f', '779')") > in /usr/local/www/generic/lib/adodb/adodb-errorhandler.inc.php on line 71 > > > Why would an INSERT cause a deadlock problem? Is this due to the FOR UPDATE > problem with foreign keys? I don't suppose a VACUUM is happening at the same time? I've found that 7.2.4 likes to give deadlocks during inserts into a table when it's being VACUUMed (haven't tried it on 7.3.2 yet). -- Kevin Brown kevin@sysexperts.com
В списке pgsql-hackers по дате отправления: