dbTalk Databases Forums  

Re: Release 7.4.5

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


Discuss Re: Release 7.4.5 in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bruce Momjian
 
Posts: n/a

Default Re: Release 7.4.5 - 08-30-2004 , 09:05 AM






Rajan Bhide wrote:
Quote:
Hi,

The recent Postgres7.4.5 mentions a fix for a crash.
http://www.postgresql.org/docs/7.4/s...#RELEASE-7-4-5
"Repair possible crash during concurrent btree index insertions
This patch fixes a rare case in which concurrent insertions into a btree
index could result in a server panic. No permanent damage would result,
but it's still worth a re-release. The bug does not exist in pre-7.4
releases."

Is this crash anyway related to :
WARNING: specified item offset is too large
PANIC: failed to add item to the page for "<table_index_key>"
LOG: server process (PID 3786) was terminated by signal 6
LOG: terminating any other active server processes

I have been getting this crash for a while.
My app uses Postgres 7.4.3 on SunOS 5.9 Generic_112233-01 sun4u sparc
SUNW,UltraAX-i2

Is it worth to upgrade it to use 7.4.5?
Not sure but you should upgrade anyway. It is easy.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



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

Default Re: Release 7.4.5 - 08-30-2004 , 09:42 AM






"Rajan Bhide" <rbhide (AT) starentnetworks (DOT) com> writes:
Quote:
The recent Postgres7.4.5 mentions a fix for a crash.

Is this crash anyway related to :
WARNING: specified item offset is too large
PANIC: failed to add item to the page for "<table_index_key>"
LOG: server process (PID 3786) was terminated by signal 6
Yup, that looks like the same thing.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



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.