Date: Sat, 19 Apr 2025 13:06:27 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Pgsql-general <pgsql-general@postgresql.org>, 
	Laurenz Albe <laurenz.albe@cybertec.at>
Message-ID: <1111108452.3502529.1745067987293@mail.yahoo.com>
In-Reply-To: <05820f63079333ff7e475e61b44c8378a03aa8e2.camel@cybertec.at>
References: <1385521371.3160626.1744955370756.ref@mail.yahoo.com> <1385521371.3160626.1744955370756@mail.yahoo.com> <02e2740edf821e2ce84773c83065b45e9be890cc.camel@cybertec.at> <1852089030.3173833.1744961512201@mail.yahoo.com> <24bb716bbdb6dbb8ac02c501db26731a101d21d3.camel@cybertec.at> <1365122733.3205645.1744975213857@mail.yahoo.com> <45879321.3496225.1745066329503@mail.yahoo.com> <05820f63079333ff7e475e61b44c8378a03aa8e2.camel@cybertec.at>
Subject: Re:  Error while updating a table
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3502528_1202772894.1745067987292"
Content-Length: 6354
Archived-At: <https://www.postgresql.org/message-id/1111108452.3502529.1745067987293%40mail.yahoo.com>
Precedence: bulk

------=_Part_3502528_1202772894.1745067987292
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Thanks Laurenz,
>=C2=A0it is 100% clear that an earlier statement in the same transaction m=
usthave got an error.=C2=A0 Write your application so that it logs *every* =
error
that comes from the database, then you are sure to catch that error.

There is an option to log every sql statement that's executed from the appl=
ication.=C2=A0 Unfortunately, that option was not set at that time.=C2=A0 =
=C2=A0Even I enable it now, I can't figure out that error.=C2=A0 =C2=A0By a=
ny chance, if I get that statement, what should I do?=C2=A0 What are the St=
eps (or documentation) to correct this issue?
Happiness Always
BKR Sivaprakash
    On Saturday 19 April, 2025 at 06:25:37 pm IST, Laurenz Albe <laurenz.al=
be@cybertec.at> wrote: =20
=20
 On Sat, 2025-04-19 at 12:38 +0000, sivapostgres@yahoo.com wrote:
> So far, I couldn't find the query that caused the error.=C2=A0 =C2=A0Is t=
here any way to unlock it?=C2=A0=C2=A0
>=20
> Re-start, Format and fresh install of windows, etc. ?

On Windows you have to reboot, bow three times toward sunset,
say a prayer to Bill Gates, then reboot again.

No, seriously: randomly messing around with your machine rarely ever
gets you closer to a solution.

If you get the error

=C2=A0 current transaction is aborted, commands ignored until end of transa=
ction block

it is 100% clear that an earlier statement in the same transaction must
have got an error.=C2=A0 Write your application so that it logs *every* err=
or
that comes from the database, then you are sure to catch that error.

Also, if "log_min_messages" is "warning" (the default) or "error", you
will find the error in the PostgreSQL log.=C2=A0 That's all I can say to yo=
u.

Yours,
Laurenz Albe


 =20
------=_Part_3502528_1202772894.1745067987292
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpe726b46cyahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks Laurenz,</div><div di=
r=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"f=
alse">&gt;&nbsp;<span style=3D"color: rgb(38, 40, 42); font-family: Helveti=
ca Neue, Helvetica, Arial, sans-serif;">it is 100% clear that an earlier st=
atement in the same transaction must</span><div><span style=3D"color: rgb(3=
8, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">hav=
e got an error.&nbsp; Write your application so that it logs *every* error<=
/span><br clear=3D"none" style=3D"color: rgb(38, 40, 42); font-family: Helv=
etica Neue, Helvetica, Arial, sans-serif;"><span style=3D"color: rgb(38, 40=
, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">that com=
es from the database, then you are sure to catch that error.</span><br clea=
r=3D"none" style=3D"color: rgb(38, 40, 42); font-family: Helvetica Neue, He=
lvetica, Arial, sans-serif;"></div><div><span style=3D"color: rgb(38, 40, 4=
2); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></span>=
</div><div dir=3D"ltr" data-setdir=3D"false"><span style=3D"color: rgb(38, =
40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">There =
is an option to log every sql statement that's executed from the applicatio=
n.&nbsp; Unfortunately, that option was not set at that time.&nbsp; &nbsp;E=
ven I enable it now, I can't figure out that error.&nbsp; &nbsp;</span></di=
v><div dir=3D"ltr" data-setdir=3D"false">By any chance, if I get that state=
ment, what should I do?&nbsp; What are the Steps (or documentation) to corr=
ect this issue?</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div =
dir=3D"ltr" data-setdir=3D"false">Happiness Always<br>BKR Sivaprakash</div>=
<div><span style=3D"color: rgb(38, 40, 42); font-family: Helvetica Neue, He=
lvetica, Arial, sans-serif;"><br></span></div></div>
       =20
        </div><div id=3D"ydp9041f3ceyahoo_quoted_5960931157" class=3D"ydp90=
41f3ceyahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Saturday 19 April, 2025 at 06:25:37 pm IST, Laur=
enz Albe &lt;laurenz.albe@cybertec.at&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">On Sat, 2025-04-19 at 12:38 +0000, <a=
 shape=3D"rect" href=3D"mailto:sivapostgres@yahoo.com" rel=3D"nofollow" tar=
get=3D"_blank">sivapostgres@yahoo.com</a> wrote:<br clear=3D"none">&gt; So =
far, I couldn't find the query that caused the error.&nbsp; &nbsp;Is there =
any way to unlock it?&nbsp;&nbsp;<br clear=3D"none">&gt; <br clear=3D"none"=
>&gt; Re-start, Format and fresh install of windows, etc. ?<br clear=3D"non=
e"><br clear=3D"none">On Windows you have to reboot, bow three times toward=
 sunset,<br clear=3D"none">say a prayer to Bill Gates, then reboot again.<b=
r clear=3D"none"><br clear=3D"none">No, seriously: randomly messing around =
with your machine rarely ever<br clear=3D"none">gets you closer to a soluti=
on.<br clear=3D"none"><br clear=3D"none">If you get the error<br clear=3D"n=
one"><br clear=3D"none">&nbsp; current transaction is aborted, commands ign=
ored until end of transaction block<br clear=3D"none"><br clear=3D"none">it=
 is 100% clear that an earlier statement in the same transaction must<br cl=
ear=3D"none">have got an error.&nbsp; Write your application so that it log=
s *every* error<br clear=3D"none">that comes from the database, then you ar=
e sure to catch that error.<br clear=3D"none"><br clear=3D"none">Also, if "=
log_min_messages" is "warning" (the default) or "error", you<br clear=3D"no=
ne">will find the error in the PostgreSQL log.&nbsp; That's all I can say t=
o you.<div class=3D"ydp9041f3ceyqt5168490231" id=3D"ydp9041f3ceyqtfd61231">=
<br clear=3D"none"><br clear=3D"none">Yours,<br clear=3D"none">Laurenz Albe=
<br clear=3D"none"><br clear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_3502528_1202772894.1745067987292--