Re: Postgresql Data corruption
Rene Romero Benavides <[email protected]> Tue, 14 Jan 2020 16:27:06 -0600
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CANaGW08=fq33OUOkNfnqfRfZrD5pZj-FCC3M4Fg3+a4ck08gtw@mail.gmail.com> |
--0000000000002f6606059c21181f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Can't help you personally right now due to work, but try these guys: https://pgexperts.com/services/emergency_help/ On Tue, Jan 14, 2020 at 4:08 PM Rene Romero Benavides < [email protected]> wrote: > On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov < > [email protected]> wrote: > >> >> >> Hi team >> >> Could you help us to sort this out please? >> >> We had some hardware problems with Datacenter and could not using >> postgresql from restored snapshots it showing "Structure needs to be >> cleaning " during startup >> , on centos7 did xfs_repair and postgresql started successfully. But >> could not select datas from it . showing below message . >> >> This is when want to login to db with postgres user . >> psql: PANIC: could not open critical system index 2662 >> >> but can logged in with another user and trying to select from some table= s >> , showing this message : >> >> ERROR: catalog is missing 11 attribute(s) for relid 113971 >> >> Could you help us to solve this problem? or could you give contact who >> can help with this? >> >> Thanks in advance. >> > > First of all, please attend to these instructions: > https://wiki.postgresql.org/wiki/Corruption > > from what you describe looks like you need to restore from backups or > promote a slave to master if you have such a setup and the slave(s) were > not affected by these hardware problems. > > -- > El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n. > Thomas Alva Edison > http://pglearn.blogspot.mx/ > > --=20 El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n. Thomas Alva Edison http://pglearn.blogspot.mx/ --0000000000002f6606059c21181f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Can't help you personally right now due to work, but t= ry these guys:<br><div><a href=3D"https://pgexperts.com/services/emergency_= help/">https://pgexperts.com/services/emergency_help/</a>=C2=A0<br></div></= div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On= Tue, Jan 14, 2020 at 4:08 PM Rene Romero Benavides <<a href=3D"mailto:r= [email protected]">[email protected]</a>> wrote:<br></div><bl= ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef= t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D= "ltr"><div>On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov <<a href=3D"m= ailto:[email protected]" target=3D"_blank">tulqin.navruzov@= finnetlimited.com</a>> wrote:<br></div></div><div class=3D"gmail_quote">= <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-= left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><br><div= class=3D"gmail_quote"><br><div dir=3D"ltr">Hi team=C2=A0<div><br></div><di= v>Could you help us to sort=C2=A0this out please?</div><div><br></div><div>= We had some hardware problems with Datacenter and could not using postgresq= l from restored snapshots it showing "Structure needs to be cleaning &= quot; during startup</div><div>, on centos7 did xfs_repair and postgresql s= tarted successfully. But could not select datas from it . showing below mes= sage .</div><div><br></div><div>This is when want to login to db with postg= res user .</div><div>psql: PANIC: =C2=A0could not open critical system inde= x 2662<br></div><div><br></div><div>but can logged in with another user and= trying to select from some tables , showing this message :</div><div><br><= /div><div>ERROR: =C2=A0catalog is missing 11 attribute(s) for relid 113971<= br></div><div><br></div><div>Could you help us to solve this=C2=A0problem? = or could you give contact who can help with=C2=A0this?</div><div><br></div>= <div>Thanks in advance.</div></div> </div></div> </blockquote></div><br clear=3D"all"><div>First of all, please attend to th= ese instructions:<div><a href=3D"https://wiki.postgresql.org/wiki/Corruptio= n" target=3D"_blank">https://wiki.postgresql.org/wiki/Corruption</a>=C2=A0= =C2=A0</div></div><div><br></div><div>from what you describe looks like you= need to restore from backups or promote a slave to master if you have such= a setup and the slave(s) were not affected by these hardware problems.=C2= =A0</div><div><br></div>-- <br><div dir=3D"ltr">El genio es 1% inspiraci=C3= =B3n y 99% transpiraci=C3=B3n.<br>Thomas Alva Edison<br><a href=3D"http://p= glearn.blogspot.mx/" target=3D"_blank">http://pglearn.blogspot.mx/</a><br><= div style=3D"padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;col= or:black;font-size:10px;text-align:left;line-height:130%"></div><div><br></= div></div></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail_signature">El genio es 1% inspiraci=C3=B3n y 99% transpirac= i=C3=B3n.<br>Thomas Alva Edison<br><a href=3D"http://pglearn.blogspot.mx/" = target=3D"_blank">http://pglearn.blogspot.mx/</a><br><div style=3D"padding:= 0px;margin-left:0px;margin-top:0px;overflow:hidden;color:black;font-size:10= px;text-align:left;line-height:130%"></div><div><br></div></div> --0000000000002f6606059c21181f--