Re: HUGE Stack space is gettiing consumed - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: HUGE Stack space is gettiing consumed
Date
Msg-id 20060415135144.GF22736@svana.org
Whole thread Raw
In response to HUGE Stack space is gettiing consumed  ("Mavinakuli, Prasanna (STSD)" <prasanna.b-m@hp.com>)
Responses Re: HUGE Stack space is gettiing consumed  ("Mavinakuli, Prasanna (STSD)" <prasanna.b-m@hp.com>)
List pgsql-general
On Fri, Apr 14, 2006 at 09:13:26AM +0530, Mavinakuli, Prasanna (STSD) wrote:
> Hello All,
>
> We are getting very strange problem ..
>
> ********************************************************
> We Have one data field in some table..type of this field
> Is *TEXT*.
> We are storing around 1,000 (One Thousand) lines of text
> In that field.
>
> If it's run though separate thread,
> When we say select <columnname> from <tablename>
> We are getting
> *could not receive data from server: No such file or directory *
> messages without Result
>
> If it was in main thread,
> It Works fine.
> ********************************************************

So you have a multithreaded program. Have you setup something so that
you don't have two threads trying to do things with libpq at the same
time? Because that won't work.

Secondly, it can't have anything to do with stack-space because when
you run out of stack space you get a segmentation fault, not a nice
error.

Either post a complete example of the failure (with source code) or
perhaps the strace output would be enough.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Christian Kratzer
Date:
Subject: Re: 21 bit number for sequence
Next
From: "chris smith"
Date:
Subject: Re: Comparing text field