From: | "sergey" <opium(at)ydk(dot)com(dot)ua> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4758: deadlock.c:944 |
Date: | 2009-04-16 11:09:10 |
Message-ID: | 200904161109.n3GB9ABg079804@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4758
Logged by: sergey
Email address: opium(at)ydk(dot)com(dot)ua
PostgreSQL version: 8.4beta1
Operating system: Linux 2.6.25-gentoo-r8
Description: deadlock.c:944
Details:
i have table with 15 records
Table "public.test"
Column | Type | Modifiers
--------+---------+-----------
y | integer |
then i run 3 followng commands in parralel:
./bin/psql billy < sql.sql
in file sql.sql only 10000 statements "UPDATE test SET y=1;"
and what i see in log:
ERROR: 40P01: deadlock detected
DETAIL: Process 10237 waits for ShareLock on transaction 165664; blocked by
process 10242.
Process 10242 waits for ShareLock on transaction 165691; blocked by
process 10237.
Process 10237: UPDATE test SET y=1;
Process 10242: UPDATE test SET y=1;
HINT: See server log for query details.
LOCATION: DeadLockReport, deadlock.c:944
approximately one message per second
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Steffens | 2009-04-16 12:22:46 | Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?) |
Previous Message | Albe Laurenz | 2009-04-16 09:22:46 | Re: need information |