From: Tom Lane <tgl@sss.pgh.pa.us>
To: "=?gb18030?B?MTAyNA==?=" <453539222@qq.com>
cc: "=?gb18030?B?cGdzcWwtYnVncw==?=" <pgsql-bugs@lists.postgresql.org>
Subject: Re: An update deadlock bug
In-reply-to: <tencent_639AC1C2CA95490C1CE28F9F9AC74C6BE406@qq.com>
References: <tencent_639AC1C2CA95490C1CE28F9F9AC74C6BE406@qq.com>
Comments: In-reply-to "=?gb18030?B?MTAyNA==?=" <453539222@qq.com>
	message dated "Thu, 23 Mar 2023 16:32:04 +0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1827659.1679586725.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 23 Mar 2023 11:52:05 -0400
Message-ID: <1827660.1679586725@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1827660.1679586725%40sss.pgh.pa.us>
Precedence: bulk

"=3D?gb18030?B?MTAyNA=3D=3D?=3D" <453539222@qq.com> writes:
> Recently I found a parallel update bug=C2=A3=C2=ACThe steps to recurrenc=
e are as follows:
> 1,create table t1(a int, b varchar(20));
>    insert into t1 values(generate_series(1,5), 'abc');
> 2, use pgbench to run parallel update:
>     pgbench -U postgres -p 5432 postgres -n -r -c 10 -j 1 -T 100 -P 1 -f=
 test.sql
>     test.sql:  update t1 set a =3D 123 where b =3D 'abc';
> 3, We will find "deadlock detected" in log file or terminal.

I don't see any bug here.  You've got multiple clients all trying
to update the same set of rows in an unspecified order.  It's
unsurprising that some of them sometimes arrive at the same pair of
rows in a different order.

> I want to figure out that if every update use sequence scan ,why deadloc=
k happened?

Even though they're all using seqscans, there will be different
updates committing at different instants, and the live rows and
available free space will soon become wildly scrambled.  If you
are expecting that "all the plans are seqscans" means "all the
sessions will operate in lockstep", you're mistaken.

			regards, tom lane