Re: Problems starting up postgres

From: Denis Perchine <dyp(at)perchine(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problems starting up postgres
Date: 2001-09-06 09:11:05
Message-ID: 20010906061257.EFE42202B0@mx.webmailstation.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wednesday 05 September 2001 23:23, you wrote:
> Denis Perchine <dyp(at)perchine(dot)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(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Reinhard Max 2001-09-06 09:43:12 Re: libpgtcl doesn't use UTF encoding of TCL
Previous Message Peter Harvey 2001-09-06 06:49:21 Inherited Table