Re: [GENERAL] Postmaster cannot start

2006-05-16 Thread Chun Yit\(Chronos\)
some doubt on my mind. Regards Beh - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Chun Yit(Chronos)" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 16, 2006 1:03 PM Subject: Re: [GENERAL] Postmaster cannot start "Chun Yit\(Chr

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Qingqing Zhou
""Chun Yit(Chronos)"" <[EMAIL PROTECTED]> wrote > postmaster give me error every time i try to start it > LOG: redo starts at A/46315F50 > PANIC: btree_delete_page_redo: uninitialized right sibling > So the last resort I can think of is to use pg_resetxlog to pass the startup failure -- but no

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Tom Lane
"Chun Yit\(Chronos\)" <[EMAIL PROTECTED]> writes: > PANIC: btree_delete_page_redo: uninitialized right sibling > LOG: startup process (PID 5043) was terminated by signal 6 > LOG: aborting startup due to startup process failure That's pretty ugly :-(. I think your only hope to get out of it is

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Chun Yit\(Chronos\)
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: But not sure why it reports the following error message (which looks like a post-commit cleanup caused error): DEBUG: AbortCurrentTransaction PANIC: cannot abort transaction 14135438, it was already committed I think this is an artifact o

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Chun Yit\(Chronos\)
4) how can i solve this problem? The base table pg_class should be ok(pg_class_oid_ind indicates both have the same cardinality). Try to reindex pg_class as the superuser. but not i not be able to reindex the table because i cannot start the postmaster. postmaster give me error every time

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Tom Lane
"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > But not sure why it reports the following error > message (which looks like a post-commit cleanup caused error): > DEBUG: AbortCurrentTransaction > PANIC: cannot abort transaction 14135438, it was already committed I think this is an artifa

Re: [GENERAL] Postmaster cannot start

2006-05-15 Thread Qingqing Zhou
""Chun Yit(Chronos)"" <[EMAIL PROTECTED]> wrote > saw from the log file, it's possible that server crash during > vacuum process... > > Question : > 1) what happen to my database server? what the error meaning? > It looks like index "pg_class_relname_nsp_index" (which is an index on pg_class) is

[GENERAL] Postmaster cannot start

2006-05-15 Thread Chun Yit\(Chronos\)
Hi,   my postgresql version 7.4.5 cannot start until this morning, when i check the log file, it give me this error this is part of my log file   DEBUG:  vacuuming "pg_catalog.pg_class"DEBUG:  "pg_class": found 9823 removable, 1017 nonremovable row versions in 205 pagesDETAIL:  0 dead row ver