public inbox for [email protected]
help / color / mirror / Atom feedRe: Corruption of few tables
3+ messages / 3 participants
[nested] [flat]
* Re: Corruption of few tables
@ 2025-02-26 07:21 [email protected] <[email protected]>
2025-02-26 14:06 ` Re: Corruption of few tables Greg Sabino Mullane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: [email protected] @ 2025-02-26 07:21 UTC (permalink / raw)
To: o1bigtenor <[email protected]>; Adrian Klaver <[email protected]>; +Cc: pgsql-general
Since we rectified the issue in ver 11, I couldn't get more details.
Now we are getting the same [ or similar ] issue in PostgreSQL 15.7 (Ubuntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit
When we ran the following query, in PGAdmin
Select releasenumber, buildnumberFrom public.co_versionWhere modulename = '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 PGAdmin, in another window ], we get correct expected result and NOT the error.
Couldn't identify whether this is related to network or corruption.
Happiness Always
BKR Sivaprakash
On Wednesday 26 February, 2025 at 12:07:00 pm IST, [email protected] <[email protected]> wrote:
Yes, we are planning to upgrade to Ver 17 soon.Yesterday, we got the similar error in one more client place where version 15 is running in Ubuntu Server. We are trying to figure out whether it's a network issue or corruption issue.
On Tuesday 25 February, 2025 at 08:24:44 pm IST, Adrian Klaver <[email protected]> wrote:
On 2/25/25 04:39, o1bigtenor wrote:
> On Tue, Feb 25, 2025 at 6:03 AM [email protected]
> 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/
>
> HTH
>
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Corruption of few tables
2025-02-26 07:21 Re: Corruption of few tables [email protected] <[email protected]>
@ 2025-02-26 14:06 ` Greg Sabino Mullane <[email protected]>
2025-02-26 14:28 ` Re: Corruption of few tables Ron Johnson <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Sabino Mullane @ 2025-02-26 14:06 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: o1bigtenor <[email protected]>; Adrian Klaver <[email protected]>; pgsql-general
On Wed, Feb 26, 2025 at 2:21 AM [email protected] <
[email protected]> wrote:
> issue in PostgreSQL 15.7
>
Still missing a ton of bug fixes - Postgres 15 is on version 15.12. Try to
get that upgraded.
> We got the following error
> ERROR: SSL error: bad length
> SSL SYSCALL error: No error (0x00000000/0)
>
This is a network error, not data corruption. How much time passes from
starting the query until you see the error? Make sure all your related
programs are up to date (esp. pgadmin, openssl). Check the Postgres logs to
see if there is more information or perhaps other information about why the
SSL connection is failing.
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Corruption of few tables
2025-02-26 07:21 Re: Corruption of few tables [email protected] <[email protected]>
2025-02-26 14:06 ` Re: Corruption of few tables Greg Sabino Mullane <[email protected]>
@ 2025-02-26 14:28 ` Ron Johnson <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Ron Johnson @ 2025-02-26 14:28 UTC (permalink / raw)
To: pgsql-general
On Wed, Feb 26, 2025 at 9:06 AM Greg Sabino Mullane <[email protected]>
wrote:
> On Wed, Feb 26, 2025 at 2:21 AM [email protected] <
> [email protected]> wrote:
>
>> issue in PostgreSQL 15.7
>>
>
> Still missing a ton of bug fixes - Postgres 15 is on version 15.12. Try to
> get that upgraded.
>
And it takes less than five minutes to stop the instance, install the
packages then restart the instance.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-26 14:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-26 07:21 Re: Corruption of few tables [email protected] <[email protected]>
2025-02-26 14:06 ` Greg Sabino Mullane <[email protected]>
2025-02-26 14:28 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox