Skip site navigation (1) Skip section navigation (2)

COPY error

From: root <craigw(at)zip(dot)com(dot)au>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: COPY error
Date: 1999-05-29 07:11:48
Message-ID: 374F9334.6AA36FA7@zip.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
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



pgsql-interfaces by date

Next:From: NahuelDate: 1999-05-29 13:09:01
Subject: Clarion and postgresql
Previous:From: JT KirkpatrickDate: 1999-05-28 22:04:39
Subject: illegal page fault errors when adding records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group