Thread: I/O Bug

I/O Bug

From
"Ken Egervari"
Date:
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

Stack Trace:



java.net.SocketException: Connection reset

            at java.net.SocketInputStream.read(SocketInputStream.java:168)

            at
java.io.BufferedInputStream.fill(BufferedInputStream.java:183)

            at
java.io.BufferedInputStream.read(BufferedInputStream.java:201)

            at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:166)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1C
onnection.java:291)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con
nection.java:213)

            at org.postgresql.Driver.connect(Driver.java:139)

            at java.sql.DriverManager.getConnection(DriverManager.java:512)

            at java.sql.DriverManager.getConnection(DriverManager.java:171)

            at
com.upfactor.core.test.ResourceTestCaseDetails.getDatabaseConnection(Resourc
eTestCaseDetails.java:59)

            at
com.upfactor.core.test.ResourceTestCase.getConnection(ResourceTestCase.java:
62)

            at
org.dbunit.DatabaseTestCase.executeOperation(DatabaseTestCase.java:84)

            at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:104)

            at
com.upfactor.rns.service.BusinessServicesTest.setUp(BusinessServicesTest.jav
a:36)

            at junit.framework.TestCase.runBare(TestCase.java:125)

            at junit.framework.TestResult$1.protect(TestResult.java:106)

            at junit.framework.TestResult.runProtected(TestResult.java:124)

            at junit.framework.TestResult.run(TestResult.java:109)

            at junit.framework.TestCase.run(TestCase.java:118)

            at junit.framework.TestSuite.runTest(TestSuite.java:208)

            at junit.framework.TestSuite.run(TestSuite.java:203)

            at junit.framework.TestSuite.runTest(TestSuite.java:208)

            at junit.framework.TestSuite.run(TestSuite.java:203)

            at junit.textui.TestRunner.doRun(TestRunner.java:116)

            at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57
)

            at junit.textui.TestRunner.start(TestRunner.java:172)

            at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTest
Runner2.java:23)

            at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitSt
arter.java:97)

            at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)

End of Stack Trace

org.postgresql.util.PSQLException: An I/O error occured while reading from
backend - Exception: java.net.SocketException: Connection reset

Stack Trace:



java.net.SocketException: Connection reset

            at java.net.SocketInputStream.read(SocketInputStream.java:168)

            at
java.io.BufferedInputStream.fill(BufferedInputStream.java:183)

            at
java.io.BufferedInputStream.read(BufferedInputStream.java:201)

            at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:166)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1C
onnection.java:291)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con
nection.java:213)

            at org.postgresql.Driver.connect(Driver.java:139)

            at java.sql.DriverManager.getConnection(DriverManager.java:512)

            at java.sql.DriverManager.getConnection(DriverManager.java:171)

            at
com.upfactor.core.test.ResourceTestCaseDetails.getDatabaseConnection(Resourc
eTestCaseDetails.java:59)

            at
com.upfactor.core.test.ResourceTestCase.getConnection(ResourceTestCase.java:
62)

            at
org.dbunit.DatabaseTestCase.executeOperation(DatabaseTestCase.java:84)

            at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:104)

            at
com.upfactor.rns.service.BusinessServicesTest.setUp(BusinessServicesTest.jav
a:36)

            at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57
)

            at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTest
Runner2.java:23)

            at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitSt
arter.java:97)

            at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)

End of Stack Trace



            at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:172)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1C
onnection.java:291)

            at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con
nection.java:213)

            at org.postgresql.Driver.connect(Driver.java:139)

            at java.sql.DriverManager.getConnection(DriverManager.java:512)

            at java.sql.DriverManager.getConnection(DriverManager.java:171)

            at
com.upfactor.core.test.ResourceTestCaseDetails.getDatabaseConnection(Resourc
eTestCaseDetails.java:59)

            at
com.upfactor.core.test.ResourceTestCase.getConnection(ResourceTestCase.java:
62)

            at
org.dbunit.DatabaseTestCase.executeOperation(DatabaseTestCase.java:84)

            at org.dbunit.DatabaseTestCase.setUp(DatabaseTestCase.java:104)

            at
com.upfactor.rns.service.BusinessServicesTest.setUp(BusinessServicesTest.jav
a:36)

            at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at
com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)

Re: I/O Bug

From
Richard Huxton
Date:
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