2010/11/29 Tom Lane <t...@sss.pgh.pa.us> > Anderson Valadares <anderva...@gmail.com> writes: > > I am facing problems starting the database. Following is the error > message. > > Can anyone help me? > > > 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL: XX000: failed to > > re-find parent key in index "22723655" for split pages 370836/370837 > > The only way you're going to get out of that is with pg_resetxlog, > which is a fairly blunt instrument :-(. It's possible that you will > have database corruption afterwards. I'd recommend doing a dump and > reload to see if any problems appear. It'd also be a good idea to save > a tarball copy of the $PGDATA file tree beforehand, so at least you can > get back to where you are in case things turn into a complete mess. > > Can you tell us anything about how you got into this state? > > regards, tom lane >
Thanks Tom, is strange because the database was shut down normally. I wanted to understand why this error. I noticed that this table has an index GIST. 27/11/2010 13:16:49 PDT [] - [13019]: [3-1] LOG: received smart shutdown request 27/11/2010 13:16:49 PDT [] - [3891]: [1-1] FATAL: terminating connection due to administrator command 27/11/2010 13:16:49 PDT [] - [28117]: [1-1] FATAL: terminating connection due to administrator command 27/11/2010 13:16:49 PDT [] - [25348]: [8597-1] FATAL: terminating connection due to administrator command 27/11/2010 13:16:49 EDT [- [3557]: [8-1] FATAL: terminating connection due to administrator command 27/11/2010 13:16:49 PDT [] - [26900]: [1-1] FATAL: terminating connection due to administrator command 27/11/2010 13:16:49 PDT [] - [27051]: [1-1] FATAL: terminating connection due to administrator command
