MIME-Version: 1.0
Date: Fri, 08 Sep 2023 12:18:33 -0300
From: Carlos Alves <carlos.alves@tecnisys.com.br>
To: dyuzenn98@gmail.com, pgsql-bugs@lists.postgresql.org
Cc: PG Bug reporting form <noreply@postgresql.org>
Subject: Re: BUG #18099: ERROR:  could not access status of transaction
 4007513275
In-Reply-To: <18099-cb4ffa6e2874d039@postgresql.org>
References: <18099-cb4ffa6e2874d039@postgresql.org>
Message-ID: <ba3a12ee7b3579d1d81e13f783357c2c@tecnisys.com.br>
User-Agent: Roundcube Webmail/1.4.11
Content-Type: multipart/alternative;
 boundary="=_4fd1bad97a21a8b0116b55b629c8d091"
Archived-At: 
 <https://www.postgresql.org/message-id/ba3a12ee7b3579d1d81e13f783357c2c%40tecnisys.com.br>
Precedence: bulk

--=_4fd1bad97a21a8b0116b55b629c8d091
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=UTF-8

Em 08/09/2023 03:36, PG Bug reporting form escreveu:

> The following bug has been logged on the website:
> 
> Bug reference:      18099
> Logged by:          Dogukan Yuzen
> Email address:      dyuzenn98@gmail.com
> PostgreSQL version: 14.8
> Operating system:   Red Hat Enterprise Linux Server release 7.9 (Maipo
> Description:        
> 
> A few days ago , we had  some problems in our production database. 
> We can't read the table. 
> 
> We can't solve this problem.
> ERROR:  could not access status of transaction 4007513275
> DETAIL:  Could not open file "pg_xact/0EED": No such file or directory.
> 
> Please, help us.

Try to remove all files stored in pg_twophase directory and than restart
the service. I had similar situation and doing that, solved the problem.


Somethimes, old prepared transactios can cause this problem and removing
the files of pg_twophase should fix. 

best regards, 

---

 Carlos Alves 
Especialista

Sia Trecho 08, lotes 245 / 255 / 265 || +55 (61) 3039-9700
71205-080 || Guará || Brasília, DF 0800-6020097 

www.tecnisys.com.br [1] 

 
Links:
------
[1] http://www.tecnisys.com.br
--=_4fd1bad97a21a8b0116b55b629c8d091
Content-Type: multipart/related;
 boundary="=_4fba22e0312432e9124bef8a34e2d5b9"

--=_4fba22e0312432e9124bef8a34e2d5b9
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen=
eva,sans-serif'>
<p>Em 08/09/2023 03:36, PG Bug reporting form escreveu:</p>
<blockquote type=3D"cite" style=3D"padding: 0 0.4em; border-left: #1010ff 2=
px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ig=
nored -->
<div class=3D"pre" style=3D"margin: 0; padding: 0; font-family: monospace">=
The following bug has been logged on the website:<br /> <br /> Bug referenc=
e: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18099<br /> Logged by: &nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dogukan Yuzen<br /> Email address: &nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;<a href=3D"mailto:dyuzenn98@gmail.com">dyuzenn98@g=
mail.com</a><br /> PostgreSQL version: 14.8<br /> Operating system: &nbsp;&=
nbsp;Red Hat Enterprise Linux Server release 7.9 (Maipo<br /> Description: =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br /> <br /> A few days ago , we=
 had &nbsp;some problems in our production database. <br /> We can't read t=
he table. <br /> <br /> We can't solve this problem.<br /> ERROR: &nbsp;cou=
ld not access status of transaction 4007513275<br /> DETAIL: &nbsp;Could no=
t open file "pg_xact/0EED": No such file or directory.<br /> <br /> Please,=
 help us.</div>
</blockquote>
<p><br /></p>
<p>Try to remove all files stored in pg_twophase directory and than restart=
 the service. I had similar situation and doing that, solved the problem.</=
p>
<p><br />Somethimes, old prepared transactios can cause this problem and re=
moving the files of pg_twophase should fix.</p>
<p><br /></p>
<p>best regards,</p>
<p>---</p>
<div>
<table style=3D"margin-left: 0; width: 550px; color: #003087; font-family: =
Calibri,Helvetica,Verdana; font-size: 10pt; letter-spacing: 0.1px;">
<tbody>
<tr>
<td style=3D"width: 35.5667px;"><img style=3D"width: 5px; height: 225px;" s=
rc=3D"cid:f62593aa02f7ca1140303fb9eff147bc@tecnisys.com.br" /></td>
<td style=3D"vertical-align: middle; padding: 15px; width: 479.433px;"><str=
ong>Carlos Alves</strong> <br />Especialista<br /><br /> <img style=3D"heig=
ht: 35px;" src=3D"cid:04237a95e4ba3d087c62288085bb774d@tecnisys.com.br" alt=
=3D"Logo
Tecnisys" /><br /><br /> Sia Trecho 08, lotes 245 / 255 / 265 || +55 (61) 3=
039-9700<br /> 71205-080 || Guar&aacute; || Bras&iacute;lia, DF 0800-602009=
7 <br /><br /> <a style=3D"text-decoration: none;" title=3D"Tecnisys" href=
=3D"http://www.tecnisys.com.br">www.tecnisys.com.br</a></td>
</tr>
</tbody>
</table>
</div>
<p><br /></p>
<p><br /></p>
</body></html>

--=_4fba22e0312432e9124bef8a34e2d5b9
Content-Transfer-Encoding: base64
Content-ID: <f62593aa02f7ca1140303fb9eff147bc@tecnisys.com.br>
Content-Type: image/gif;
 name=f62593aa.gif
Content-Disposition: inline;
 filename=f62593aa.gif;
 size=43

R0lGODlhAQABAJEAAAEuhwAAAAAAAAAAACwAAAAAAQABAAAIBAABBAQAOw==
--=_4fba22e0312432e9124bef8a34e2d5b9
Content-Transfer-Encoding: base64
Content-ID: <04237a95e4ba3d087c62288085bb774d@tecnisys.com.br>
Content-Type: image/gif;
 name=04237a95.gif
Content-Disposition: inline;
 filename=04237a95.gif;
 size=3169

R0lGODlh/AAnAPcAAP////7+//39/vz8/vv7/fr7/fn6/Pj5/Pf4+/b3+/X2+vT2+vP1+fL0+fHz
+PDy+O/y9+7x9+3w9+zv9uvu9urt9ent9ejs9Ofr9Obq8+Xp8+To8uPo8uLn8eHm8eDl8N/k8N7k
793j79zi7tvh7trg7tnf7djf7dfe7Nbd7NXc69Tb69Pa6tLa6tDY6c/X6M7W6M3W58zV58vU5srT
5snS5sjR5cfR5cbQ5MXP5MTO48PN48LM4sHM4sDL4b/K4b7J4L3I4LzI37vH37rG3rnF3rjE3bfD
3bbD3bXC3LTB3LPA27K/27G+2rC+2q+92a682a272Ky62Ku616q516m41qi31qe21aa11aW11aS0
1KOz1KKy06Gx06Cx0p+w0p6v0Z2u0Zyt0Jus0Jqsz5mrz5iqzpaozZWnzZSnzJOmzJKlzJGky5Cj
y4+jyo6iyo2hyYygyYufyIqeyImex4idx4ecxoabxoWaxYSZxYOZxIKYxICWw3+Vw36Vwn2UwnyT
wXuSwXqRwHmQwHiQv3ePv3aOvnWNvnSMvXOLvXKLvHGKvHCJu2+Iu26Hu22HumuFuWqEuWmDuGiC
uGeCt2WAtmR/tmN+tWJ9tWF9tGB8tF97s156s115slx5slt4sll2sVh1sFd0sFZ0r1Vzr1RyrlNx
rlJwrVFwrVBvrE9urE5tq01sq0xrqktrqkpqqklpqUdnqEZmqEVmp0Rlp0NkpkJjpkFipUBipT9h
pD5gpD1fozxeoztdojpdojlcoThboTdaoTZZoDVYoDRYnzNXnzJWnjFVnjBUnS9UnS5TnC1SnCxR
mytQmypPmilPmihOmSdNmSZMmSVLmCRKmCNKlyJJlyFIliBHlh9GlR1FlBxElBtDkxpCkxlBkhhB
khdAkRY/kRU+kBQ9kBM8kBI8jxE7jxA6jg85jg44jQ04jQw3jAs2jAo1iwk0iwgzigczigYyiQUx
iQQwiAMviAIviAEuhwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAkAAPcALAAAAAD8ACcA
AAj+AO8JHEiwIMESBhMqXMiwocOHECNKnEixosWLGB/6UpCxo8ePIEOKHEkyITlKJVOqXMmypcuC
5Ow1eUmzps2bLgPg4FNFYMxxhooQwEm0qNGjChvYyWbPnrsY92I2tReOUAWkWLNqTanl29Sm1iJI
/aoujoCtaNOqfYjg01d76VoFsjFmjyemX21RWMu3b9oGvL4Ok1LAIIAboehNlbbBr+PHOAvcmqqO
DICBDFCguDqwRrSp0CJAHk1a5aGp21gIhEAHWT3Uk1TfYxBrqqvLpR0CiNDhxIkPFc6mPZChRIoT
ITg0wDqggogUKUZ0iBAA4o7X9sYhvMeF3DJ7tHT+pCBET5m7RwbuHcA1VQzDGofiy59Pvz79HQPN
2N9vH8dCATjgkcoy67xlzzzeBIOJGSEUtIN8aQwVEQ7y3TGQCvIVYtgPiOgCDnZvvdNNMJ3AIUN1
98hQ3xMTCYAGfYM0JhAKeriizTwGHihOMqfwYQQCCQEQTFP1GCEQIuEsAYksEt6zxjUvANPLchR0
01Q4CyxERo5cdtlUGwNN5uWYZyREQiPgjGmgME4M1MZXyNAQ0RlTYTNQE1PFU9ANyqhpoDZ7nNWE
N2918gBEIgQGpwsCYYAKiH7as04lGBSUxFScCESHNiOAkE4QToBhxhY8NEOHAa7EUl0VU7GhZaT/
aoIpkJiwvlUmQQ9QIk+tX5ni5lv0PLKcQ3Q2ZadAeDal50A4vMPrVxzdI4FbX2Xzg0NkqPNVPH0U
dg8E1Tw71UwEpdKUPCDc0wI7MNiQC5fhUNHAM2ncA0Cf9iyzkBbe9Ovvv2PZU86/BHszRphTrVPw
wgR7QVAL2BiojiyMqEFFEkpIIQYem0jT669/ttlQsfYce0+y9iwrkKJgVQKHF08ggcQTXcSRyCjN
7DpVtAJB4dVU9CwCZEIXsPIWMowOxMdX5pCShxhTKHFEE1qkEcgmwRQ4LkEJuNOUKwKp8oglahoj
CDgJ3JPGVNtNlMNXQ0BE6yEYpVDOV/SgckST/gqREEcx9vgq0JtcpiKjQiSbjLLKAuDYlCkoMpSA
EH8MQw/PAk0gylvMwGBQFOJs221BskyljQMOBeBCG7C4Q65AQUxlxj0YzBOuPe/0kcQYTfWBgxjO
KFZPPT11MBUXFb09VdwPzX0RAcl8tQxUErEgBcj2qGPOW+msIZxBid+Z50ABwDNVM0lDhEHkBE0R
zrZ5DCCQA5m8pYznBsEyFTtPyA+RAocSyA64MZUX3AML9qiHJtDQDIEMoSloEEgiHhEFK2VCIIRa
BN8iorymMM8htNpFHkZIwhKaED8EucJXjDGsixDOHtGwwCYgZY9gpI8g4UPW+AbyireE4xeq/vgE
JRTxhzuwgQtHSEF6HEKBUbzlFyT4QcTyNLqEvOEt7CjGK0RxiUYMYg9vCAMTYIC6ggBgDjprCgTu
8Qd7OOwLshAIESAoEDeM4h4e4IYwBDILK1ykg/b4YENoVas9FCQUX5lBR14YDYH0oBlvkcchMHeP
HJ5shwIpwftgFY9h7IEDDqFC6KbSDsVM5X4MOUAvalWPaUBCTgJJwyxmSUv5MQIZAjHDKgTyg6aQ
QSBnUIVA9iANXgrhmMcMwgYZAkhBMoSQsDIkQX6xP48wciAEqAM73mINIw3EkosrCAc+4axawYMO
DrGAKXLELW8xBAF+GGWtREFJe8VhOX7I/4b84CgQGzRlC3W84z0icQyBrHIq5mCCRJopt6nMwx0Q
jahEJ2ohgvSQSBdY5FQaSRAPqMJAoMhoJeskPmUlxAFSKAQqipENc7iDhgZyj0OwMI6vKIN6ECEA
EPAAil9UYxzqcFyXQlGQCKzCHi3gjj0mQYAkJEMgKmgKFARCCEjcowryEOg2poKMEbgNbg1tCt0s
QoevVEKjTeFoQZZwjbeUQwwAACcmG7BEhQDgABHYgAl0AIZRgAgaECnCV8rIxIYQ4AEZGIENqtAI
bRGpAwMRAV7CgMd6cIMYaHhHYTTQFCAIpBWR+EQ41DE7zjZFFUNbKFibN5WxVoQC5/iKI/7qChEO
HAF7ai1IAgJhvq/owhEk1aFJBSIDZOAvIp2Yijwg4oOvpO0h1LjCRLrwFR8MZARTOYVAaGEILkDD
HpnYghGaEgYn9AEd77CEFNZxqC015bYUYShrxYqRLEBKGlugrUIesAVYzENw97jmQk5Qiy4pDpMy
OFAnaoCbhiQAcE3xBnOdC5Ht7cIJ7mwIcKeyAoJMQ1kZuMcN2MECAYRiG7vgxmvEUYxibEMCBkhG
HgQijKaw47lfXV5Y7YEMSfj4x0AO8o97QJA1mBKhoUCDDzrgrQJ4QAhxgEVvA4fbmVrJQAceboqq
lYkz+GAEDRAOAB5QAiMAoq1TwcSEp/6C44ZsrynoSAUdlICCCLgzAR/YwRt88RVssG9pTYmEQARR
DQ3Q4BwTuMdWgTQLPghAFLxIjxKm8gmLdLAcItjxs+ThWYIEYYpckkcaDQTgF1baIQ5ohFCNVdIa
DiTBXpIHPGDaFHFA9iHNbUo5MsyQN3OJHvA4MrBeJ5ALeO1AOrhHACqRjRyUAnLFWMc9xNANFMTC
GIl2AJrrIQNL67rbmq6VPHpikAO4wRriIurgmpIKXjMEBsDoc0mHsUaBGGANt+PVMVIQkVyXA9wP
ScIuaD2mcEQhIYVADSjjmg5a2GMUwfAGHeQhjHRsIksCMFpT1F0RGEyjGQB/iCemQf/ykpv85Ccn
t0ICwINDFGPKXGJHLxAxhCZ5YRqfWGZDAmCGZ5AcFwMRwjRoUW+CAIAGe5iFPLsEDlJEgX0OqcHH
Qw4REKzBFNcg+P5ssYYWFoQB6G6KNBp0Dwr04TNTSUcobmBvUkylHLfOjUIKMAIifGENdahDG8og
BR18AOpGeYALmBCGNMzhDnRIgxaAEIIG2wQBJyBCF84QBzzcoQ1fQMIK3G2QGxw7O9cbiAVu4AMU
+O8eKRjGVOpxcLm7/vUVocKoaSEEwN8DBZKAeR1gz/vePyQK2/yKNjYBBy2Y4AyNiB7e4OD75jvf
IC+AZI40YAwDcYMIz89+9gsgh6VENyUCILibjRMRQO2bv/kK8MIsPi+aJMQDGHFI9Pnn//wDROL7
AjkA/fe//SGJhv8A+HwfUA7/F4AG2HtNUH4HuIBYERAAOw==
--=_4fba22e0312432e9124bef8a34e2d5b9--

--=_4fd1bad97a21a8b0116b55b629c8d091--