pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql BUG / Help Needed
7+ messages / 4 participants
[nested] [flat]

* Postgresql BUG / Help Needed
@ 2024-02-01 05:48 Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
  0 siblings, 1 reply; 7+ messages in thread

From: Johnathan Tiamoh @ 2024-02-01 05:48 UTC (permalink / raw)
  To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

Hello,

I am having the  following issue below.  Please, I need help to fix it.

[image: User]

*ERROR:  could not access status of transaction 756525298*
*Could not open file "pg_xact/02C8": No such file or directory.*


Thank You
Johnathan T

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
@ 2024-02-01 07:36 ` Laurenz Albe <laurenz.albe@cybertec.at>
  2024-02-01 13:28   ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Laurenz Albe @ 2024-02-01 07:36 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> I am having the  following issue below.  Please, I need help to fix it.
> 
> ERROR:  could not access status of transaction 756525298
> Could not open file "pg_xact/02C8": No such file or directory.

That is data corruption, and you should restore your backup.

Yours,
Laurenz Albe





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
@ 2024-02-01 13:28   ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 14:06     ` Re: Postgresql BUG / Help Needed Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Johnathan Tiamoh @ 2024-02-01 13:28 UTC (permalink / raw)
  To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

Thank you Laurenz!

Is there a way of preventing this from happening ?

On Thu, Feb 1, 2024 at 2:36 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:

> On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> > I am having the  following issue below.  Please, I need help to fix it.
> >
> > ERROR:  could not access status of transaction 756525298
> > Could not open file "pg_xact/02C8": No such file or directory.
>
> That is data corruption, and you should restore your backup.
>
> Yours,
> Laurenz Albe
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
  2024-02-01 13:28   ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
@ 2024-02-01 14:06     ` Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
  2024-02-01 14:10       ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Jehan-Guillaume de Rorthais @ 2024-02-01 14:06 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

On Thu, 1 Feb 2024 08:28:45 -0500
Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:

> Thank you Laurenz!
> 
> Is there a way of preventing this from happening ?

This could either come from a hardware issue, or easily from your own actions
or procedures.

Did you have some difficulties with your instance lately? exceptional
intervention? backup restoration? failover?





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
  2024-02-01 13:28   ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 14:06     ` Re: Postgresql BUG / Help Needed Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
@ 2024-02-01 14:10       ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 16:19         ` Re: Postgresql BUG / Help Needed Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Johnathan Tiamoh @ 2024-02-01 14:10 UTC (permalink / raw)
  To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

I haven't had difficulties in this cluster recently.

However I upgraded it from  version 9.5 to 14.10  about 3 weeks ago.



On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
wrote:

> On Thu, 1 Feb 2024 08:28:45 -0500
> Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
>
> > Thank you Laurenz!
> >
> > Is there a way of preventing this from happening ?
>
> This could either come from a hardware issue, or easily from your own
> actions
> or procedures.
>
> Did you have some difficulties with your instance lately? exceptional
> intervention? backup restoration? failover?
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
  2024-02-01 13:28   ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 14:06     ` Re: Postgresql BUG / Help Needed Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
  2024-02-01 14:10       ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
@ 2024-02-01 16:19         ` Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-01 17:33           ` Re: Postgresql BUG / Help Needed Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Adrian Klaver @ 2024-02-01 16:19 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; Jehan-Guillaume de Rorthais <jgdr@dalibo.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>

On 2/1/24 06:10, Johnathan Tiamoh wrote:
> I haven't had difficulties in this cluster recently.
> 
> However I upgraded it from  version 9.5 to 14.10  about 3 weeks ago.
> 

Have you being doing any of the things that got you in trouble in this 
thread:

https://www.postgresql.org/message-id/CACoPQdbEoQrusU4RC1o2zEC8CEm4PVdhy6xbH2x_hQPwPOdO%3DQ%40mail.g...

and/or this one:

https://www.postgresql.org/message-id/CACoPQdZWnrc1ZBGpUBTFE_3Eo2sOV3w%2B5RqPhMHgDe6zNV_1DQ%40mail.g...

> 
> 
> On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais 
> <jgdr@dalibo.com <mailto:jgdr@dalibo.com>> wrote:
> 
>     On Thu, 1 Feb 2024 08:28:45 -0500
>     Johnathan Tiamoh <johnathantiamoh@gmail.com
>     <mailto:johnathantiamoh@gmail.com>> wrote:
> 
>      > Thank you Laurenz!
>      >
>      > Is there a way of preventing this from happening ?
> 
>     This could either come from a hardware issue, or easily from your
>     own actions
>     or procedures.
> 
>     Did you have some difficulties with your instance lately? exceptional
>     intervention? backup restoration? failover?
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Postgresql BUG / Help Needed
  2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 07:36 ` Re: Postgresql BUG / Help Needed Laurenz Albe <laurenz.albe@cybertec.at>
  2024-02-01 13:28   ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 14:06     ` Re: Postgresql BUG / Help Needed Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
  2024-02-01 14:10       ` Re: Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
  2024-02-01 16:19         ` Re: Postgresql BUG / Help Needed Adrian Klaver <adrian.klaver@aklaver.com>
@ 2024-02-01 17:33           ` Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Adrian Klaver @ 2024-02-01 17:33 UTC (permalink / raw)
  To: Johnathan Tiamoh <johnathantiamoh@gmail.com>; +Cc: pgsql-general

Reply to list also.
Ccing list.

On 2/1/24 09:11, Johnathan Tiamoh wrote:
> No. I  have done any of this in the present cluster, I'm facing this issue.
> 

Do you have some sort of replication or backup system running on this 
cluster?


-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2024-02-01 17:33 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-01 05:48 Postgresql BUG / Help Needed Johnathan Tiamoh <johnathantiamoh@gmail.com>
2024-02-01 07:36 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-02-01 13:28   ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2024-02-01 14:06     ` Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
2024-02-01 14:10       ` Johnathan Tiamoh <johnathantiamoh@gmail.com>
2024-02-01 16:19         ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-02-01 17:33           ` Adrian Klaver <adrian.klaver@aklaver.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox