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
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 |