Ken Egervari wrote:
> Hi,
>
>
>
> I've been using Postgres version 8 beta and while everything has been
> perfect so far, I've noticed that I get a connection reset error when the
> database is hit pretty hard. For instance, I have several unit tests in
> Java running DBUnit and it inserts and cleans up the database state after
> every test case. After many test cases, it eventually makes the database
> crash. I'm using the latest JDBC 3 driver that comes with the version 8
> installer at PGFoundry. Below is a stackstace in Java on what's happening
> after 220 test cases have run. All other test cases give the same exception
> as Postgres needs time to load back up again unless I'm only testing under
> 200 test cases. Have you guys heard of this before from other testers? Is
> there a fix? Thanks.
>
>
>
> org.postgresql.util.PSQLException: An I/O error occured while reading from
> backend - Exception: java.net.SocketException: Connection reset
Ken, is there anything interesting in the postgresql logs?
Oh, and what platform is this on?
--
Richard Huxton
Archonet Ltd