db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1233) We get a org.apache.derby.client.am.DisconnectException. The Derby Service appears to shut down connections while running many queries.
Date Thu, 20 Apr 2006 17:47:06 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1233?page=all ]

Kathey Marsden updated DERBY-1233:
----------------------------------

    Description: 

We run a rather large set of regression tests each night.  This will probably stress Cloudscape
we we do make a great deal of calls to the database.  At some point in our
tests they start to fail.  If the tests are separately and not back to back they will pass
it seems that it is running alot of tests all at once that causes this problem.

com.ibm.ac.si.ap.service.ServiceException: ACUASI0139E SQL Exception: A communication error
has been detected. Communication protocol being used: Reply.fill(). Communication API being
used: InputStream.read(). Location where the error was detected: insufficient data. Communication
function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS 

We have run our tests with the following derby settings:
derby.drda.traceAll=true
derby.stream.error.logSeverityLevel=0
derby.stream.error.file=D:/Programs/Cloudscape/Temp/mylog3.txt                         (Change
this to your directory and output file name)
derby.drda.logConnections=true
derby.language.logStatementText=true


  was:
This is a new different problem that was discovered while testing a fix for PMR 90974,999,000.
 This is also delaying the completion of our test stage and is being tracked as a HOT problem
here.  I was told to have this immediately escalated by passing it to the REDB,18Z queue where
Ken Gee can continue to work on this.

We run a rather large set of regression tests each night.  This will probably stress Cloudscape
we we do make a great deal of calls to the database.  At some point in our
tests they start to fail.  If the tests are separately and not back to back they will pass
it seems that it is running alot of tests all at once that causes this problem.

We have been working with Ken Gee who provided a fix for PMR 90974,999,000.  This allows our
tests to progress farther and we no longer see the DDM errors we have seen originally but
now there seems to be a point where we get the error: 

com.ibm.ac.si.ap.service.ServiceException: ACUASI0139E SQL Exception: A communication error
has been detected. Communication protocol being used: Reply.fill(). Communication API being
used: InputStream.read(). Location where the error was detected: insufficient data. Communication
function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS 

We have run our tests with the following derby settings:
derby.drda.traceAll=true
derby.stream.error.logSeverityLevel=0
derby.stream.error.file=D:/Programs/Cloudscape/Temp/mylog3.txt                         (Change
this to your directory and output file name)
derby.drda.logConnections=true
derby.language.logStatementText=true

And I have sent in a separate note to Ken the information on how he can FTP the logs that
were produced on this. 
Please contact me if you need more information.





>  We get a org.apache.derby.client.am.DisconnectException.  The Derby Service appears
to shut down connections while running many queries.
> -----------------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1233
>          URL: http://issues.apache.org/jira/browse/DERBY-1233
>      Project: Derby
>         Type: Bug

>   Components: Network Server
>     Versions: 10.1.1.2
>  Environment: This can be consistently recreated on at least 2 machines that run our
nightly tests.  We have not tried it on other machines yet.  The 2 machines environments are:
> 1) OS = SuSE Linux Enterprise Server 9     JAVA =  J2RE 1.4.2 IBM build cxia32142-20050929
(SR3)
> 2) OS =  Red Hat Enterprise Linux AS release 4 (Nahant)   JAVA = ava version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05) Java HotSpot(TM) Server
VM (build 1.5.0_06-b05, mixed mode)
>     Reporter: Barry Myers
>     Priority: Critical

>
> We run a rather large set of regression tests each night.  This will probably stress
Cloudscape we we do make a great deal of calls to the database.  At some point in our
> tests they start to fail.  If the tests are separately and not back to back they will
pass it seems that it is running alot of tests all at once that causes this problem.
> com.ibm.ac.si.ap.service.ServiceException: ACUASI0139E SQL Exception: A communication
error has been detected. Communication protocol being used: Reply.fill(). Communication API
being used: InputStream.read(). Location where the error was detected: insufficient data.
Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS

> We have run our tests with the following derby settings:
> derby.drda.traceAll=true
> derby.stream.error.logSeverityLevel=0
> derby.stream.error.file=D:/Programs/Cloudscape/Temp/mylog3.txt                      
  (Change this to your directory and output file name)
> derby.drda.logConnections=true
> derby.language.logStatementText=true

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message