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
