Unix Technical Forum

Re: [7.4.1] signal 11 while accesing DB

This is a discussion on Re: [7.4.1] signal 11 while accesing DB within the Pgsql General forums, part of the PostgreSQL category; --> Marcin <migor@op.pl> writes: > Okay, then pg_filedump 1262: > and suddenly: > Block 4 ************************************************** ****** > <Header> ----- ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 07:06 PM
Tom Lane
 
Posts: n/a
Default Re: [7.4.1] signal 11 while accesing DB

Marcin <migor@op.pl> writes:
> Okay, then pg_filedump 1262:


> and suddenly:
> Block 4 ************************************************** ******
> <Header> -----
> Block Offset: 0x00008000 Offsets: Lower 0 (0x0000)
> Block: Size 0 Version 0 Upper 0 (0x0000)
> LSN: logid 0 recoff 0x00000000 Special 0 (0x0000)
> Items: 0 Free Space: 0
> Length (including item array): 24


> Error: Invalid header information.


Ah-hah. This case should be coped with by 7.4.3 and later, due to this patch:

2004-06-05 13:42 tgl

* src/include/storage/: bufpage.h (REL7_4_STABLE), bufpage.h:
Adjust PageGetMaxOffsetNumber to ensure sane behavior on
uninitialized pages, even when the macro's result is stored into an
unsigned variable.

In the meantime a VACUUM of pg_database should get you out of trouble.

regards, tom lane

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:40 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com