Re: Problems starting up postgres - Mailing list pgsql-hackers

From Denis Perchine
Subject Re: Problems starting up postgres
Date
Msg-id 20010906061257.EFE42202B0@mx.webmailstation.com
Whole thread Raw
In response to Re: Problems starting up postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problems starting up postgres
List pgsql-hackers
On Wednesday 05 September 2001 23:23, you wrote: 
> Denis Perchine <dyp@perchine.com> writes: 
> Hmm.  I think you must be running into some kind of logic bug (boundary 
> condition maybe?) in XLogFlush.  Could you add some debugging printouts, 
> along the line of 
Sep  6 02:09:28 mx postgres[13468]: [2] DEBUG:  CheckPoint record at (23, 2431142676) 
Sep  6 02:09:28 mx postgres[13468]: [3] DEBUG:  Redo record at (23, 2431142676); Undo record at (0, 0); Shutdown TRUE 
Sep  6 02:09:28 mx postgres[13468]: [4] DEBUG:  NextTransactionId: 13932307; NextOid: 9127687 
Sep  6 02:09:28 mx postgres[13468]: [5] DEBUG:  database system was not properly shut down; automatic recovery in
progress...
 
Sep  6 02:09:29 mx postgres[13468]: [6] DEBUG:  redo starts at (23, 2431142740) 
Sep  6 02:09:30 mx postgres[13468]: [7] DEBUG:  ReadRecord: record with zero len at (23, 2432317444) 
Sep  6 02:09:30 mx postgres[13468]: [8] DEBUG:  redo done at (23, 2432317408) 
Sep  6 02:09:30 mx postgres[13468]: [9] FATAL 2:  XLogFlush: request(1494286336, 786458) is not satisfied -- 
flushed to (23, 2432317444) 
> BTW, how did you get into this state --- did you have a system crash? 
Yes. I was forced to fsck. 
--  
Sincerely Yours, 
Denis Perchine 
---------------------------------- 
E-Mail: dyp@perchine.com 
HomePage: http://www.perchine.com/dyp/ 
FidoNet: 2:5000/120.5 
---------------------------------- 


pgsql-hackers by date:

Previous
From: Peter Harvey
Date:
Subject: Inherited Table
Next
From: Peter Eisentraut
Date:
Subject: Re: Log rotation?