Postgresql BUG / Help Needed
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
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
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:
Show quoted text
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
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?
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:
Show quoted text
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?
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:
/messages/by-id/CACoPQdbEoQrusU4RC1o2zEC8CEm4PVdhy6xbH2x_hQPwPOdO=Q@mail.gmail.com
and/or this one:
/messages/by-id/CACoPQdZWnrc1ZBGpUBTFE_3Eo2sOV3w+5RqPhMHgDe6zNV_1DQ@mail.gmail.com
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
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
Import Notes
Reply to msg id not found: CACoPQdbN5tCtgOJaNtAyDa1QS=DtsEP2r7QY_-f4b3CK=N+1qQ@mail.gmail.com