Postgres Pro
Downloads
Home   >   mailing lists

Thread: Log error at server startup

Log error at server startup

From
Gastón Simone
Date:
Hello!
Please help me!!

My pgsql installation is having a problem during startup and I don't konw
how to solve it. postmaster is reporting this:

LOG:  database system shutdown was interrupted at 2003-09-04T
LOG:  checkpoint record is at 0/44C3FC0
LOG:  redo record is at 0/44C3FC0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 27046; next oid: 28452
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  ReadRecord: unexpected pageaddr 0/24C4000 in log file 0, segment 4,
offse0
LOG:  redo is not required
PANIC:  XLogWrite: write request 0/44C4000 is past end of log 0/44C4000
LOG:  startup process (pid 22347) was terminated by signal 6
LOG:  aborting startup due to startup process failure

How can I solve it?
Thanks a lot!

Gastón.

Re: Log error at server startup

From
Bruce Momjian
Date:
Gast�n Simone wrote:
> Hello!
> Please help me!!
>
> My pgsql installation is having a problem during startup and I don't konw
> how to solve it. postmaster is reporting this:
>
> LOG:  database system shutdown was interrupted at 2003-09-04T
> LOG:  checkpoint record is at 0/44C3FC0
> LOG:  redo record is at 0/44C3FC0; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 27046; next oid: 28452
> LOG:  database system was not properly shut down; automatic recovery in
> progress
> LOG:  ReadRecord: unexpected pageaddr 0/24C4000 in log file 0, segment 4,
> offse0
> LOG:  redo is not required
> PANIC:  XLogWrite: write request 0/44C4000 is past end of log 0/44C4000
> LOG:  startup process (pid 22347) was terminated by signal 6
> LOG:  aborting startup due to startup process failure

What PostgreSQL version are you using.  If it is 7.3.X, please upgrade
to 7.3.4.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Log error at server startup

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Gast�n Simone wrote:
>> PANIC:  XLogWrite: write request 0/44C4000 is past end of log 0/44C4000
>> LOG:  startup process (pid 22347) was terminated by signal 6
>> LOG:  aborting startup due to startup process failure

> What PostgreSQL version are you using.  If it is 7.3.X, please upgrade
> to 7.3.4.

I believe the above is the symptom of 7.3.3's startup bug.

            regards, tom lane