[HACKERS] XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

2004-07-18 Thread lists
this is 7.3.3 (PGDG rpm's) on red hat 7.2: i had a lot of debugging enabled. i went to create an index, and pgsql dumped on me. i tried restarting several times - no luck. starting postgresql gives LOG: database system shutdown was interrupted at 2004-07-16 01:11:56 EDT LOG: checkpoint record

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log

2004-07-16 Thread Tom Lane
lists <[EMAIL PROTECTED]> writes: > Alvaro Herrera wrote: >>> this is 7.3.3 (PGDG rpm's) on red hat 7.2 >> >> Get 7.3.6 and try again. IIRC this is a known bug that was repaired in >> 7.3.4. > to get the data back, is it a matter of just upgrading and starting the > db (ie will it perform recov

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

2004-07-15 Thread Alvaro Herrera
On Fri, Jul 16, 2004 at 01:55:13AM -0400, lists wrote: > thank you for replying. > > Alvaro Herrera wrote: > >>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment > >>5, offset 3817472 > >>LOG: redo is not required > >>PANIC: XLogWrite: write request 0/53A4000 is past end of

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

2004-07-15 Thread Alvaro Herrera
On Fri, Jul 16, 2004 at 02:09:33PM +0800, Christopher Kings-Lynne wrote: > >>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment > >>5, offset 3817472 > >>LOG: redo is not required > >>PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000 > >>LOG: startup pro

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log

2004-07-15 Thread Christopher Kings-Lynne
>>LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment 5, offset 3817472 LOG: redo is not required PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000 LOG: startup process (pid 16068) was terminated by signal 6 LOG: aborting startup due to startup process f

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log

2004-07-15 Thread lists
thank you for replying. Alvaro Herrera wrote: LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment 5, offset 3817472 LOG: redo is not required PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000 LOG: startup process (pid 16068) was terminated by signal 6 LOG

Re: [HACKERS] XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

2004-07-15 Thread Alvaro Herrera
On Fri, Jul 16, 2004 at 01:32:01AM -0400, lists wrote: > LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment > 5, offset 3817472 > LOG: redo is not required > PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000 > LOG: startup process (pid 16068) was termin

[HACKERS] XLogWrite: write request 0/53A4000 is past end of log 0/53A4000

2004-07-15 Thread lists
i had a lot of debugging enabled. i went to create an index, and pgsql dumped on me. i tried restarting several times - no luck. starting postgresql gives: LOG: database system shutdown was interrupted at 2004-07-16 01:11:56 EDT LOG: checkpoint record is at 0/53A3FC0 LOG: redo record is at 0