last week, my Astaros pgsql-Database died, ive got the system running again with deleting the whole DB:
root #/etc/init.d/postgresql stop
#rm -rf /var/storage/pgsql/data /var/log/reporting/pgsql/*
#/etc/init.d/postgresql start
Did anyone see why this happened, and is the above Method the only one who works to get pgsql running again?
My /var/log is mounted on /dev/sdb1 (1TB).
Thanks for any help
2009:05:05-18:10:44 (none) postgres[3197]: [1-1] LOG: could not create IPv6 socket: Address family not supported by protocol
2009:05:05-18:10:44 (none) postgres[3202]: [2-1] LOG: database system shutdown was interrupted; last known up at 2009-05-04 23:27:23 CEST
2009:05:05-18:10:44 (none) postgres[3202]: [3-1] LOG: database system was not properly shut down; automatic recovery in progress
2009:05:05-18:10:44 (none) postgres[3202]: [4-1] LOG: redo starts at 0/6FAFE8
2009:05:05-18:10:44 (none) postgres[3203]: [2-1] FATAL: the database system is starting up
2009:05:05-18:10:45 (none) postgres[3202]: [5-1] LOG: record with zero length at 0/4EB34F4
2009:05:05-18:10:45 (none) postgres[3202]: [6-1] LOG: redo done at 0/4EB34C8
2009:05:05-18:10:45 (none) postgres[3202]: [7-1] LOG: last completed transaction was at log time 2009-05-04 23:27:20.080273+02
2009:05:05-18:10:45 (none) postgres[3204]: [2-1] FATAL: the database system is starting up
2009:05:05-18:10:45 (none) postgres[3207]: [2-1] LOG: autovacuum launcher started
2009:05:05-18:10:45 (none) postgres[3197]: [2-1] LOG: database system is ready to accept connections
2009:05:05-19:00:04 HORUS postgres[5961]: [3-1] ERROR: duplicate key value violates unique constraint "websec_au_pkey"
2009:05:05-19:00:04 HORUS postgres[5961]: [3-2] STATEMENT: INSERT INTO websec_au (dayabs, secabs, clientip, clientusername, duration, transfer, requests) VALUES
2009:05:05-19:00:04 HORUS postgres[5961]: [3-3] ($1,$2,$3,$4,$5,$6,$7)
2009:05:05-19:00:04 HORUS postgres[5961]: [4-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2009:05:05-19:00:04 HORUS postgres[5961]: [4-2] STATEMENT: INSERT INTO websec_aud (dayabs, secabs, clientip, clientusername, serverdomain, duration, transfer, requests) VALUES
2009:05:05-19:00:04 HORUS postgres[5961]: [4-3] ($1,$2,$3,$4,$5,$6,$7,$8)
2009:05:05-19:00:04 HORUS postgres[5961]: [5-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [6-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [7-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [8-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [9-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [10-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [11-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:04 HORUS postgres[5961]: [12-1] ERROR: prepared statement "dbdpg_2" does not exist
2009:05:05-19:00:48 HORUS postgres[3205]: [2-1] ERROR: xlog flush request 0/1436FAE4 is not satisfied --- flushed only to 0/4FE14C4
2009:05:05-19:00:48 HORUS postgres[3205]: [2-2] CONTEXT: writing block 0 of relation 16519/16520/16780
2009:05:05-19:00:49 HORUS postgres[3205]: [3-1] ERROR: xlog flush request 0/1436FAE4 is not satisfied --- flushed only to 0/4FE14C4
2009:05:05-19:00:49 HORUS postgres[3205]: [3-2] CONTEXT: writing block 0 of relation 16519/16520/16780
2009:05:05-19:00:49 HORUS postgres[3205]: [4-1] WARNING: could not write block 0 of 16519/16520/16780
2009:05:05-19:00:49 HORUS postgres[3205]: [4-2] DETAIL: Multiple failures --- write error might be permanent.
2009:05:05-19:00:50 HORUS postgres[3205]: [5-1] ERROR: xlog flush request 0/1436FAE4 is not satisfied --- flushed only to 0/4FE14C4
2009:05:05-19:00:50 HORUS postgres[3205]: [5-2] CONTEXT: writing block 0 of relation 16519/16520/16780
2009:05:05-19:00:50 HORUS postgres[3205]: [6-1] WARNING: could not write block 0 of 16519/16520/16780
2009:05:05-19:00:50 HORUS postgres[3205]: [6-2] DETAIL: Multiple failures --- write error might be permanent.
2009:05:07-19:30:44 (none) postgres[3181]: [1-1] LOG: could not create IPv6 socket: Address family not supported by protocol
2009:05:07-19:30:45 (none) postgres[3186]: [2-1] LOG: database system shutdown was interrupted; last known up at 2009-05-06 22:31:39 CEST
2009:05:07-19:30:45 (none) postgres[3186]: [3-1] LOG: database system was not properly shut down; automatic recovery in progress
2009:05:07-19:30:45 (none) postgres[3186]: [4-1] LOG: redo starts at 0/7C49208
2009:05:07-19:30:45 (none) postgres[3187]: [2-1] FATAL: the database system is starting up
2009:05:07-19:30:45 (none) postgres[3186]: [5-1] LOG: record with zero length at 0/ADD8CAC
2009:05:07-19:30:45 (none) postgres[3186]: [6-1] LOG: redo done at 0/ADD8C80
2009:05:07-19:30:45 (none) postgres[3186]: [7-1] LOG: last completed transaction was at log time 2009-05-06 22:31:36.199764+02
2009:05:07-19:30:45 (none) postgres[3186]: [8-1] FATAL: failed to re-find parent key in index "17418" for split pages 6/7
2009:05:07-19:30:45 (none) postgres[3181]: [2-1] LOG: startup process (PID 3186) exited with exit code 1
2009:05:07-19:30:45 (none) postgres[3181]: [3-1] LOG: aborting startup due to startup process failure
This thread was automatically locked due to age.