pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 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