From: Frank Morton <fmorton@mail.base2inc.com>
To: pgsql-interfaces@postgreSQL.org
Cc: Jason Venner <jason@idiom.com>
Cc: Peter T Mount <peter@retep.org.uk>
Subject: Broken Pipe Repaired
Date: Sun, 30 Aug 1998 00:29:58 -0500
Message-ID: <008301bdd3d7$3b817090$8355e5ce@tesla.base2inc.com> (raw)
Thanks to all who responded to my JDBC "Broken Pipe"
problem. It turned out to be caused by a combination of
two things.
1. I was just on the edge of my available swap space and
at times under load I ran out. Bad things began to happen,
leading to IOExceptions and "Broken Pipes." My application
is an image management one and it used imagemagik
to convert images...100mb of swap space can disappear
nearly instantly.
2. I learned from Jason Venner something that I did not think
would matter as I thought garbage collection would take care
of it. Jason found that he had continuous problems until
he specifically did a close() on any open statements. In my
case, it seems to have helped considerably to specifically
close() any completed result sets after I am through. Like
I said, I thought gc would take care of it, but it doesn't.
Thanks all.
_________________________________
Frank Morton (fmorton@mail.base2inc.com)
Voice: (317) 876-3355
FAX: (317) 876-3398
Home: (317) 574-0815
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: fmorton@mail.base2inc.com, jason@idiom.com, peter@retep.org.uk
Subject: Re: Broken Pipe Repaired
In-Reply-To: <008301bdd3d7$3b817090$8355e5ce@tesla.base2inc.com>
* 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