| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Greg Stark <gsstark(at)mit(dot)edu> |
| Cc: | Brendan Duddridge <brendan(at)clickspace(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: App very unresponsive while performing simple update |
| Date: | 2006-06-01 03:18:05 |
| Message-ID: | 20060601031805.GI53487@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, May 31, 2006 at 11:24:05AM -0400, Greg Stark wrote:
> stark=> begin;
> BEGIN
> stark=> begin;
> BEGIN
> stark=> update t1 set a = 0;
> UPDATE 1
> stark=> update t1 set a = 1;
> UPDATE 1
>
> stark=> update t2 set b = 0;
> UPDATE 1
> stark=> update t2 set b = 2;
> UPDATE 1
> stark=> commit;
> stark=> commit;
> ERROR: deadlock detected
> DETAIL: Process 16531 waits for ShareLock on transaction 245131; blocked by process 16566
> Process 16566 waits for ShareLock on transaction 245132; blocked by process 16531.
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."t1" x WHERE "a" = $1 FOR SHARE OF x"
> stark=> >
> COMMIT
I tried duplicating this but couldn't. What's the data in the tables?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2006-06-01 04:30:46 | Re: App very unresponsive while performing simple update |
| Previous Message | Jan de Visser | 2006-05-31 17:43:40 | Re: App very unresponsive while performing simple update |