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