From: root <craigw@zip.com.au>
To: pgsql-interfaces@postgresql.org
Subject: COPY error
Date: Sat, 29 May 1999 17:11:48 +1000
Message-ID: <374F9334.6AA36FA7@zip.com.au> (raw)
Hi,
I've just installed 6.4.2 on Solaris and tried to use the COPY facility
via the C interface. However my program fails when performing a flush
(within one
of the 'put' API calls).
I've traced the system calls being made by the application (...happens
to be
a java 1.2 app) and noticed the last few system calls reported include
a series
of failed sends to the backed - error EAGAIN ( 'congested' ?). I've
tried
it with and without the -i flag on the postmaster - same error.
Interesting
thing is when I truss (solaris trace command) the app, it runs okay.
Until
I open a pqsql session on the db and issue a count(*). Then even the
trussed
app barfs.
I'm a pgsql newbie, so any comments on how to keep my application
up & running while its driving the backend (hard) would be much
appreciated.
Thanks in advance.
Craig
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: craigw@zip.com.au
Subject: Re: COPY error
In-Reply-To: <374F9334.6AA36FA7@zip.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox