postgres unable to start

From: tommaso <tommasodb(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres unable to start
Date: 2011-07-28 11:51:59
Message-ID: 1311853919.2153.2.camel@tommaso-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

one of our users killed a postgres process with kill -9 "PID"
after that the DB server is not longer able to start.

Here is the log:

Jul 28 13:06:46 hdmisv03 postgres[7916]: [1790-1] user=,db=,host= DEBUG:
00000: server process (PID 7918) exited with exit code 0
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1790-2] user=,db=,host=
LOCATION: LogChildExit, postmaster.c:2707
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1795-1] user=,db=,host=
WARNING: 01000: could not open directory "base/34728840": No such file
or directory
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1795-2] user=,db=,host=
CONTEXT: xlog redo drop db: dir 34728840/1663
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1795-3] user=,db=,host=
LOCATION: pgfnames, dirmod.c:323
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1796-1] user=,db=,host=
WARNING: 01000: some useless files may be left behind in old database
directory "base/34728840"
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1796-2] user=,db=,host=
CONTEXT: xlog redo drop db: dir 34728840/1663
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1796-3] user=,db=,host=
LOCATION: dbase_redo, dbcommands.c:2058
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1797-1] user=,db=,host= DEBUG:
00000: page 1 of relation base/35531019/35671296 is uninitialized
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1797-2] user=,db=,host=
CONTEXT: xlog redo Insert item, node: 1663/35531019/35671296 blkno: 1
offset: 4 nitem: 1 isdata: F isleaf F isdelete F updateBlkno:11
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1797-3] user=,db=,host=
LOCATION: log_invalid_page, xlogutils.c:74
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1798-1] user=,db=,host= PANIC:
XX001: corrupted page pointers: lower = 59234, upper = 3, special =
59235
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1798-2] user=,db=,host=
CONTEXT: xlog redo Insert item, node: 1663/35531019/35671296 blkno: 1
offset: 4 nitem: 1 isdata: F isleaf F isdelete F updateBlkno:11
Jul 28 13:06:46 hdmisv03 postgres[7917]: [1798-3] user=,db=,host=
LOCATION: PageAddItem, bufpage.c:144
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1791-1] user=,db=,host= DEBUG:
00000: reaping dead processes
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1791-2] user=,db=,host=
LOCATION: reaper, postmaster.c:2238
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1792-1] user=,db=,host= LOG:
00000: startup process (PID 7917) was terminated by signal 6: Aborted
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1792-2] user=,db=,host=
LOCATION: LogChildExit, postmaster.c:2727
Jul 28 13:06:46 hdmisv03 postgres[7916]: [1793-1] user=,db=,host= LOG:
00000: aborting startup due to startup process failure

Has anybody an idea how to fix that error ?

TIA
Tommaso

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-07-28 12:02:53 Re: postgres unable to start
Previous Message Sim Zacks 2011-07-28 11:18:15 eval function