dbTalk Databases Forums  

page x is unitialized

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss page x is unitialized in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Guerin
 
Posts: n/a

Default page x is unitialized - 06-16-2004 , 09:10 AM






Is this message the sign of trouble, or is it harmless?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: page x is unitialized - 06-16-2004 , 09:28 AM






Michael Guerin <guerin (AT) rentec (DOT) com> writes:
Quote:
Is this message the sign of trouble, or is it harmless?
It's not good. The least bad explanation is that you had a system crash
recently that occurred between extending a table by one page and filling
that page with useful data. (The page is filled with zeroes on creation.)
If you haven't had any crashes lately then I'd wonder about whether your
disk is dropping data.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
  #3  
Old   
Michael Guerin
 
Posts: n/a

Default Re: page x is unitialized - 06-16-2004 , 02:29 PM



Tom Lane wrote:

Quote:
Michael Guerin <guerin (AT) rentec (DOT) com> writes:


Is this message the sign of trouble, or is it harmless?



It's not good. The least bad explanation is that you had a system crash
recently that occurred between extending a table by one page and filling
that page with useful data. (The page is filled with zeroes on creation.)
If you haven't had any crashes lately then I'd wonder about whether your
disk is dropping data.

regards, tom lane


Could this lead to the invalid page header problems that I've been
having lately?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
  #4  
Old   
Tom Lane
 
Posts: n/a

Default Re: page x is unitialized - 06-18-2004 , 10:17 AM



Michael Guerin <guerin (AT) rentec (DOT) com> writes:
Quote:
Tom Lane wrote:
It's not good. The least bad explanation is that you had a system crash
recently that occurred between extending a table by one page and filling
that page with useful data. (The page is filled with zeroes on creation.)

Could this lead to the invalid page header problems that I've been
having lately?
No, more the other way around. IIRC, "page n is uninitialized" is
VACUUM's report that it is fixing an invalid page header.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.