Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group