Date: Fri, 18 Apr 2025 05:49:30 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Pgsql-general <pgsql-general@postgresql.org>
Message-ID: <1385521371.3160626.1744955370756@mail.yahoo.com>
Subject: Re:  Error while updating a table
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3160625_1426554441.1744955370755"
References: <1385521371.3160626.1744955370756.ref@mail.yahoo.com>
Content-Length: 4352
Archived-At: <https://www.postgresql.org/message-id/1385521371.3160626.1744955370756%40mail.yahoo.com>
Precedence: bulk

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

Hello,
We use PowerBuilder along with PostgreSQL.
PostgreSQL 15.7 (Ubuntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compile=
d by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit

Suddenly, one system starts throwing an error while updating a record from =
PowerBuilder.=C2=A0 The same update statement (window) works fine, when run=
 from other computers.=C2=A0 Error occurs only when the statement is run fr=
om a particular computer.=C2=A0 The SQL Statement is
Update public.co_voucherseries_transaction_branchSet=C2=A0 =C2=A0 vouchernu=
mber=C2=A0 =C2=A0=3D <new number>Where=C2=A0 companycode=C2=A0 =C2=A0 =C2=
=A0=3D '100'And=C2=A0 =C2=A0 branchcode=C2=A0 =C2=A0 =C2=A0 =3D '001'And=C2=
=A0 =C2=A0 accountperiodid =3D 1And=C2=A0 =C2=A0 voucherseries=C2=A0 =C2=A0=
=3D 'SERIES'And=C2=A0 =C2=A0 voucherversion=C2=A0 =3D 'version'And=C2=A0 =
=C2=A0 activestatus=C2=A0 =C2=A0 =3D 'Y'=C2=A0 ;
The error isSQLSTATE=3D25P02ERROR: current transaction is aborted, commands=
 ignored until end of transaction block;Error while executing the query
Through googling, I found that last transaction was not properly rolled bac=
k.The (Postgresql) Linux server will be shut down every night and re-booted=
 next day morning.=C2=A0 =C2=A0
Don't know when this error has occurred.=C2=A0=C2=A0
Now I need to rectify this error?=C2=A0 How to do it?=C2=A0 Any help is rea=
lly appreciated.
Happiness Always
BKR Sivaprakash

------=_Part_3160625_1426554441.1744955370755
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:times new roman, new york, times, serif;font-size:16px;"><div dir=3D"ltr=
" data-setdir=3D"false">Hello,</div><div dir=3D"ltr" data-setdir=3D"false">=
<br></div><div dir=3D"ltr" data-setdir=3D"false">We use PowerBuilder along =
with PostgreSQL.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div=
 dir=3D"ltr" data-setdir=3D"false"><span>PostgreSQL 15.7 (Ubuntu 15.7-1.pgd=
g24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4)=
 13.2.0, 64-bit</span><br></div><div dir=3D"ltr" data-setdir=3D"false"><br>=
</div><div dir=3D"ltr" data-setdir=3D"false">Suddenly, one system starts th=
rowing an error while updating a record from PowerBuilder.&nbsp; The same u=
pdate statement (window) works fine, when run from other computers.&nbsp; E=
rror occurs only when the statement is run from a particular computer.&nbsp=
; The SQL Statement is</div><div dir=3D"ltr" data-setdir=3D"false"><br></di=
v><div dir=3D"ltr" data-setdir=3D"false"><div><div>Update public.co_voucher=
series_transaction_branch</div><div>Set&nbsp; &nbsp; vouchernumber&nbsp; &n=
bsp;=3D &lt;new number&gt;</div><div>Where&nbsp; companycode&nbsp; &nbsp; &=
nbsp;=3D '100'</div><div>And&nbsp; &nbsp; branchcode&nbsp; &nbsp; &nbsp; =
=3D '001'</div><div>And&nbsp; &nbsp; accountperiodid =3D 1</div><div>And&nb=
sp; &nbsp; voucherseries&nbsp; &nbsp;=3D 'SERIES'</div><div>And&nbsp; &nbsp=
; voucherversion&nbsp; =3D 'version'</div><div>And&nbsp; &nbsp; activestatu=
s&nbsp; &nbsp; =3D 'Y'&nbsp; ;</div><div><br></div></div>The error is</div>=
<div dir=3D"ltr" data-setdir=3D"false"><div><div>SQLSTATE=3D25P02</div><div=
>ERROR: current transaction is aborted, commands ignored until end of trans=
action block;</div><div>Error while executing the query</div><div><br></div=
></div><div dir=3D"ltr" data-setdir=3D"false">Through googling, I found tha=
t last transaction was not properly rolled back.</div>The (Postgresql) Linu=
x server will be shut down every night and re-booted next day morning.&nbsp=
; &nbsp;</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"=
ltr" data-setdir=3D"false">Don't know when this error has occurred.&nbsp;&n=
bsp;</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr"=
 data-setdir=3D"false">Now I need to rectify this error?&nbsp; How to do it=
?&nbsp; Any help is really appreciated.</div><div dir=3D"ltr" data-setdir=
=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Happiness Alway=
s<br>BKR Sivaprakash</div><div dir=3D"ltr" data-setdir=3D"false"><br></div>=
</div></body></html>
------=_Part_3160625_1426554441.1744955370755--