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
