Re: Could not receive data from server

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Amin Abdulghani <amin(at)quantiva(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Could not receive data from server
Date: 2003-08-07 00:40:38
Message-ID: 200308070040.h770ecG29454@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


7.4 has a --enable-thread-safety which compiles libpq and ecpg for
threading, with that flag on operating systems that need it.

---------------------------------------------------------------------------

Amin Abdulghani wrote:
> Compiling postgres client with -D_REENTRANT seems to
> remove
> this problem. It seems to have been a thread issue with
> webware (and more specfically errno associated the
> pqReadData).
> On a side note, I noticed that the configure.in for 7.2.1
> doesnt seem to have any option for compiling with the
> above flag. Is it available for the next releases 7.3/7.4?
>
> Thanks..
> Amin
> On Tue, 05 Aug 2003 12:10:31 -0400
> Amin Abdulghani <amin(at)quantiva(dot)com> wrote:
> >Hi,
> >
> >Running Postgres 7.2.1 with python/psycopg (python
> >interface for postgres using libpq)/webware application
> >server on Solaris, I get a postgres error "could not
> >receive data from server Error 0 " when I try to retrieve
> >a large text column (16 K) from a table. The query I use
> >is "select col from table". However, if I avoid the
> >webware application server, this seems to work ok. I am
> >just wondering what effect webware could have on the
> >postgres client libraries. The postgres server is on a
> >different machine. It doesnt seem to be a memory related
> >issue as web-ware uses only 5-6 MB on a machine having
> >256 MB.
> >
> >Thanks..
> >Amin
> >
> >---------------------------(end of
> >broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Robert Norris 2003-08-07 00:56:36 Re: ext3 block size
Previous Message Tom Lane 2003-08-07 00:05:13 Re: v7.4 Beta 1 fails regression on Digital Unix/Tru64 4.0