Date: Wed, 26 Feb 2025 07:21:14 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: o1bigtenor <o1bigtenor@gmail.com>, 
	Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Pgsql-general <pgsql-general@postgresql.org>
Message-ID: <38220057.102774.1740554474431@mail.yahoo.com>
In-Reply-To: <595456242.3981765.1740551787912@mail.yahoo.com>
References: <611536258.144285.1740484963829.ref@mail.yahoo.com> <611536258.144285.1740484963829@mail.yahoo.com> <CAPpdf5-3fj-JCmQesVJoqdRO_Anab+usxMpnsuFGeXrZu_9uSw@mail.gmail.com> <4536e07d-b846-4965-b0b1-e384b4915513@aklaver.com> <595456242.3981765.1740551787912@mail.yahoo.com>
Subject: Re: Corruption of few tables
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_102773_1254768812.1740554474430"
Content-Length: 7426
Archived-At: <https://www.postgresql.org/message-id/38220057.102774.1740554474431%40mail.yahoo.com>
Precedence: bulk

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

 Since we rectified the issue in ver 11, I couldn't get more details.=C2=A0=
 =C2=A0
Now we are getting the same [ or similar ] issue in=C2=A0PostgreSQL 15.7 (U=
buntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 1=
3.2.0-23ubuntu4) 13.2.0, 64-bit
When we ran the following query, in PGAdmin
Select releasenumber, buildnumberFrom=C2=A0 =C2=A0public.co_versionWhere=C2=
=A0 modulename =3D 'ALL';
We got the following errorERROR: SSL error: bad lengthSSL SYSCALL error: No=
 error (0x00000000/0)
When we try to run the same above query by opening another window [ same PG=
Admin, in another window ], we get correct expected result and NOT the erro=
r.
Couldn't identify whether this is related to network or corruption.=C2=A0=
=C2=A0
Happiness Always
BKR Sivaprakash
    On Wednesday 26 February, 2025 at 12:07:00 pm IST, sivapostgres@yahoo.c=
om <sivapostgres@yahoo.com> wrote: =20
=20
  Yes, we are planning to upgrade to Ver 17 soon.Yesterday, we got the simi=
lar error in one more client place where version 15 is running in Ubuntu Se=
rver.=C2=A0 =C2=A0We are trying to figure out whether it's a network issue =
or corruption issue.=C2=A0 =C2=A0
    On Tuesday 25 February, 2025 at 08:24:44 pm IST, Adrian Klaver <adrian.=
klaver@aklaver.com> wrote: =20
=20
 On 2/25/25 04:39, o1bigtenor wrote:
> On Tue, Feb 25, 2025 at 6:03=E2=80=AFAM sivapostgres@yahoo.com

> Not really a direct answer - - - but - - - have you considered
> updating Postgresql.
> Version 11 was EOL (end of life) over a year ago. Version 17 according
> to the charts I've found
> is the current version.

Actually the current community supported versions are 13-17.

The time lines for support can be found here:

https://www.postgresql.org/support/versioning/

>=20
> HTH
>=20
>=20

--=20
Adrian Klaver
adrian.klaver@aklaver.com


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

<html><head></head><body><div class=3D"ydp602410c2yahoo-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">Since we rectified the issue=
 in ver 11, I couldn't get more details.&nbsp; &nbsp;</div><div dir=3D"ltr"=
 data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Now=
 we are getting the same [ or similar ] issue in&nbsp;<span>PostgreSQL 15.7=
 (Ubuntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubunt=
u 13.2.0-23ubuntu4) 13.2.0, 64-bit</span></div><div><br></div><div dir=3D"l=
tr" data-setdir=3D"false">When we ran the following query, in PGAdmin</div>=
<div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setd=
ir=3D"false"><div><div>Select releasenumber, buildnumber</div><div>From&nbs=
p; &nbsp;public.co_version</div><div>Where&nbsp; modulename =3D 'ALL';</div=
><div><br></div></div>We got the following error</div><div dir=3D"ltr" data=
-setdir=3D"false"><div><div>ERROR: SSL error: bad length</div><div>SSL SYSC=
ALL error: No error (0x00000000/0)</div><div><br></div></div><div dir=3D"lt=
r" data-setdir=3D"false">When we try to run the same above query by opening=
 another window [ same PGAdmin, in another window ], we get correct expecte=
d result and NOT the error.</div><div dir=3D"ltr" data-setdir=3D"false"><br=
></div><div dir=3D"ltr" data-setdir=3D"false">Couldn't identify whether thi=
s is related to network or corruption.&nbsp;&nbsp;</div><div dir=3D"ltr" da=
ta-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Happin=
ess Always<br>BKR Sivaprakash</div><div dir=3D"ltr" data-setdir=3D"false"><=
br></div></div>
       =20
        </div><div id=3D"yahoo_quoted_0712459998" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Wednesday 26 February, 2025 at 12:07:00 pm IST, =
sivapostgres@yahoo.com &lt;sivapostgres@yahoo.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div id=3D"yiv4013616829"><div><div style=3D"font-fami=
ly:times new roman, new york, times, serif;font-size:16px;" class=3D"yiv401=
3616829ydp13582144yahoo-style-wrap"><div></div>
        <div dir=3D"ltr">Yes, we are planning to upgrade to Ver 17 soon.</d=
iv><div dir=3D"ltr">Yesterday, we got the similar error in one more client =
place where version 15 is running in Ubuntu Server.&nbsp; &nbsp;We are tryi=
ng to figure out whether it's a network issue or corruption issue.&nbsp; &n=
bsp;</div><div><br clear=3D"none"></div>
       =20
        </div><div id=3D"yiv4013616829yqt76930" class=3D"yiv4013616829yqt95=
24048441"><div id=3D"yiv4013616829yahoo_quoted_1072984967" class=3D"yiv4013=
616829yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Tuesday 25 February, 2025 at 08:24:44 pm IST, Ad=
rian Klaver &lt;adrian.klaver@aklaver.com&gt; wrote:
                    </div>
                    <div><br clear=3D"none"></div>
                    <div><br clear=3D"none"></div>
               =20
               =20
                <div><div dir=3D"ltr">On 2/25/25 04:39, o1bigtenor wrote:<b=
r clear=3D"none">&gt; On Tue, Feb 25, 2025 at 6:03=E2=80=AFAM <a rel=3D"nof=
ollow noopener noreferrer" shape=3D"rect" ymailto=3D"mailto:sivapostgres@ya=
hoo.com" target=3D"_blank" href=3D"mailto:sivapostgres@yahoo.com">sivapostg=
res@yahoo.com</a><br clear=3D"none"><br clear=3D"none">&gt; Not really a di=
rect answer - - - but - - - have you considered<br clear=3D"none">&gt; upda=
ting Postgresql.<br clear=3D"none">&gt; Version 11 was EOL (end of life) ov=
er a year ago. Version 17 according<br clear=3D"none">&gt; to the charts I'=
ve found<br clear=3D"none">&gt; is the current version.<br clear=3D"none"><=
br clear=3D"none">Actually the current community supported versions are 13-=
17.<br clear=3D"none"><br clear=3D"none">The time lines for support can be =
found here:<br clear=3D"none"><br clear=3D"none"><a rel=3D"nofollow noopene=
r noreferrer" shape=3D"rect" target=3D"_blank" href=3D"https://www.postgres=
ql.org/support/versioning/">https://www.postgresql.org/support/versioning/<=
/a><div id=3D"yiv4013616829yqtfd47711" class=3D"yiv4013616829yqt9671463183"=
><br clear=3D"none"><br clear=3D"none">&gt; <br clear=3D"none">&gt; HTH</di=
v><br clear=3D"none">&gt; <br clear=3D"none">&gt; <br clear=3D"none"><br cl=
ear=3D"none">-- <br clear=3D"none">Adrian Klaver<br clear=3D"none"><a rel=
=3D"nofollow noopener noreferrer" shape=3D"rect" ymailto=3D"mailto:adrian.k=
laver@aklaver.com" target=3D"_blank" href=3D"mailto:adrian.klaver@aklaver.c=
om">adrian.klaver@aklaver.com</a><div id=3D"yiv4013616829yqtfd07083" class=
=3D"yiv4013616829yqt9671463183"><br clear=3D"none"><br clear=3D"none"><br c=
lear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></div></div></div></div>
            </div>
        </div></body></html>
------=_Part_102773_1254768812.1740554474430--