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