Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page - Mailing list pgsql-novice

From Rajan Bhide
Subject Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
Date
Msg-id FF851C7EEB75954F9BCFB5CA117AB1ECFC3237@delta.nulinkinc.com
Whole thread Raw
In response to Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page  ("Rajan Bhide" <rbhide@nulinkinc.com>)
Responses Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
List pgsql-novice
> I've looked at the code fairly carefully and I don't see how this
could happen.  Can you provide a self-contained test case that makes it
happen?

I would try to build a test program. Currently this is happening with my
production app on longevity run.
But still would like to know the reason to get such error. Any Postgres
document or other links would be helpful.
Is there any help from the stat stuff provided in the earliar mail?
Any fine tuning or changes in postgresql.conf file required?
My app makes 18 conncurrent connection with the Postgres server?
I was using periodic reindexing, but that too did'nt helped much, so I
have disbled it again. Jes doing VACCUM ANALYSE on every table after
every 10 mins.

BTW the source code was compiled on SunOS5.8 using Sun Forte's cc
compiler:
/configure --prefix=/usr/local/pgsql --enable-thread-safety
--without-readline CFLAGS='-D_REENTRANT'  CPPFLAGS='-mt'
cc=/export/home/uxapps/workshop/SUNWspro/bin/cc
Does this helps?

Thanks,
Rajan Bhide


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page
Next
From: Tom Lane
Date:
Subject: Re: Error msgs from PostgreSQL server : specified item offset is too large, failed to add item to the page