From: Martin Mueller <martinmueller@northwestern.edu>
To: Postgres General <pgsql-general@postgresql.org>
Subject: an error message that I don't understand
Thread-Topic: an error message that I don't understand
Thread-Index: AQHbu5+fiSb1DZlgpkqCiAelVHCaQw==
Date: Fri, 2 May 2025 20:24:52 +0000
Message-ID: <BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2@BN6PR05MB3667.namprd05.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?OsMn+u5NSBGJX/ZmMit8oZKs56V7X5kZZSY2V3qpikceol+tiGD5c3i3?=
 =?Windows-1252?Q?QAuzSqkddBwvMFQn6awt7IylKLYuYpjhwY56AhEOELk2lhAalMuzEAs4?=
 =?Windows-1252?Q?XGOlecIUdv/kQJmaxI+4aF2cWBeEtW9A80dgAU2sMoEOjTCIMwPcLv66?=
 =?Windows-1252?Q?BPGU+SSfYwypL/Hig6iRrGz+mFknCrgK/zXFQGzZ+jakQ+jazEtDPW2x?=
 =?Windows-1252?Q?ZMMcL5MrcjFMpoNrYoFDwO4xIT6p7H/mO7EwFaQ5PuVreloOlmFkcFC4?=
 =?Windows-1252?Q?ctDqye/NNnkJ/3EvzWW2VL+qpnqFIuQ04cwXWscF0Zbgwwg/ab5pWjTX?=
 =?Windows-1252?Q?CTvFB+C8XdxfNFxFPAlSQJAjDR+IBa1sMS7Tq84ls4SX5effS51wY3hR?=
 =?Windows-1252?Q?I+vdRGuUwF50Wrd0+urjjjAM077OSh8VtVLm9MT4C7CfWpspx/7pUAlP?=
 =?Windows-1252?Q?KafDlEmYmdSJrTRGrjKRrvPd+kwSOCzVHE8koE1vJ/tQbnss/mIOfhnl?=
 =?Windows-1252?Q?XR+eMxO2uI+u4r83+mRjxdbBzrZ5fe8ufaj/cGr4nGwIjkpyu3TBUpTC?=
 =?Windows-1252?Q?7Siv0KWBoD1IfreDJ78NTrEmmAuaPqZ2+LsIA2hVhvwQg62Ylv+gkK+l?=
 =?Windows-1252?Q?7ot2kCBDGU9YPlhKnGn5CxMa3dXniw1+frj9vxuzRWldid8JU7If22iw?=
 =?Windows-1252?Q?dpkQ9VdZnAk+Rn17c8ZwGwzEUiVMuSKDScxnt5hrjDxDuXi4VIULnRv/?=
 =?Windows-1252?Q?dhO0vhSHYe1+aGnnJyFMOXEDVOAaAF6NNgl0l+i/VP7w9TEm67Tg5GJd?=
 =?Windows-1252?Q?TpVxegYVi4qZiKQJHU1kfRHy+f1yx4JTSo8CUyS3itpkLx9Ls4zp5crC?=
 =?Windows-1252?Q?LS8qTsv6Qq6t4rXTCTRAc71dEjcwR1oi4ITVMUcvOA32bFozpLRH+v4P?=
 =?Windows-1252?Q?cLZWMKsIrsfsLIxi/ivLe+hu6dohNkJ/MqJiNCgbeoWzZk6ChQhHLb77?=
 =?Windows-1252?Q?mY1aeMAT9OWv5VtIu+hzpl+n+J91XdDqQ50gJvSVdWN0giX4DZI+E/iH?=
 =?Windows-1252?Q?BFvEMX/vaomfJPSlH/cgvwdU2wOY0NIJqliABsyVeOdU7+kV9JzatUwS?=
 =?Windows-1252?Q?BCwybW/zLtcaMRJO2uO4dZssQixQVPyQSZFDmGBxJYiJ7KCoLoaVpef8?=
 =?Windows-1252?Q?9HGd66QkF1ef1U3jUKDk0hu0uRF46TtBUNq0f3nlABD+ShHceYRwyrv2?=
 =?Windows-1252?Q?7xGP4kKIhsLF+qj0MRjqFTXhyQi1FM1BQ+8OiQjhXfnKMldufCw9MVxY?=
 =?Windows-1252?Q?jH+yo1AiIVYSyuJuDCgfSslcqs0dFx5GDZrd1DhGLsNu48hte21+LB2B?=
 =?Windows-1252?Q?QT6CY1r1ivJZZpqa4fuGnKBhBrgbLYT0XD8wKI8C+0AP0SoMdMT9HgEX?=
 =?Windows-1252?Q?MtTcZ2jcKaL7l6yGXDu4w3gcbHpj3vDHRw3XYZmz8ZN27umSRDGC8v2n?=
 =?Windows-1252?Q?QMgsX1G2bNFMGBzVtFNLRrLIOLCLEvMC2WUQHfYTo0W/Qlp6YzUK0Ssb?=
 =?Windows-1252?Q?8ylJ8QFZ8E2UCvPAOP+c6SLeSO5jgCFevPJCcA603afyL+YD9NbN0dre?=
 =?Windows-1252?Q?ksBd2MelCaD7LxVeCuIFpadh0IKRtJMDtJgzm5zoHvpp+YnA7xNj9Psa?=
 =?Windows-1252?Q?zwOh/MMDvUaV8et99W5DdyFtSAFj0DLVbvw1borCt25kg1GPiafmXYBM?=
 =?Windows-1252?Q?+NCHLLjhVLeefzMJFxQ=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2BN6PR05MB3667namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BN6PR05MB3667.namprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: b136c3b5-27ea-4a34-813f-08dd89b76532
X-MS-Exchange-CrossTenant-originalarrivaltime: 02 May 2025 20:24:52.6192
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7d76d361-8277-4708-a477-64e8366cd1bc
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: S2GmTmC2x5hZrujeiZtbxAL2/sGr0mjrt9t5IEaigy/OHx1KxKCw5zFXsKv/DBpiPutJHhNvEcSJpCWePH6mlpMQUK588aOqvEgH7hJ1sdE=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR05MB8117
X-OriginatorOrg: northwestern.edu
X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUwNTAyMDE2NSBTYWx0ZWRfXyiO1FgctvQ17 3hB1eLiSUQA47Wdzb5GhIaaBIc4Z5Ruj/zbg3hlldPUaNmitnRM8nx2TS9BXwQWBEV3aoItrNI+ TLNq33KSHSKVAR6pvXDUOfoFqg9F4oZkGe23gKhQ4n/AxiE0OVXnXEHiGMVrNBd6PMXLARgQ4Ud
 xJFgwr84mKcfdwPzeBtdOgNArx9/lQz+4Vye4TH0bPDgEHAVCxzdSbX3ii0jaOGyjh4yCOG1Mcu sh+x3gUksjmukp2icvhlrJxhbTvnj+ROQ7c9Iyo9GxJPEKVnp9o6V3kvsfcMf6hvb9mNNjXUwEv 5wgnpAPm3KNhHwTNPtDo8a8lXp8gBGzWpDE5+rhaS3eOWkQzUYgQCh0+jhzpylanyoKDFurblja izH7kix+
X-Proofpoint-ORIG-GUID: 8r62f3bp-XWiOdFi6LZrSJ3X6I8Ta43G
X-Proofpoint-GUID: 8r62f3bp-XWiOdFi6LZrSJ3X6I8Ta43G
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1099,Hydra:6.0.736,FMLib:17.12.80.40
 definitions=2025-05-02_04,2025-04-30_01,2025-02-21_01
X-Proofpoint-Spam-Reason: safe
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2%40BN6PR05MB3667.namprd05.prod.outlook.com>
Precedence: bulk

--_000_BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2BN6PR05MB3667namp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I get this error message:

table tid from new index tuple (32586,21) overlaps with invalid duplicate t=
uple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx"

from an update query of the
update table 1 set columnx =3D =91yes=92
where table1.xmlid in (select xmlid from table2)

I have no idea what is going on or how to deal with it and will be grateful=
 for advice


--_000_BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2BN6PR05MB3667namp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;
	panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
	{font-family:"Times New Roman \(Body CS\)";
	panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:12.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">I get this error me=
ssage:<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">table tid from new =
index tuple (32586,21) overlaps with invalid duplicate tuple at offset 120 =
of block 4398 in index &quot;aacorrections_tcpreading_idx&quot;<o:p></o:p><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">from an update quer=
y of the <o:p>
</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">update table 1 set =
columnx =3D =91yes=92<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">where table1.xmlid =
in (select xmlid from table2)<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt">I have no idea what=
 is going on or how to deal with it and will be grateful for advice<o:p></o=
:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:14.0pt"><o:p>&nbsp;</o:p></=
span></p>
</div>
</body>
</html>

--_000_BN6PR05MB36674534FFDF5E41A6CAFCA4C48D2BN6PR05MB3667namp_--