Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 50988 invoked from network); 20 Apr 2006 17:48:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 20 Apr 2006 17:48:10 -0000 Received: (qmail 93323 invoked by uid 500); 20 Apr 2006 17:48:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 93102 invoked by uid 500); 20 Apr 2006 17:48:09 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 93093 invoked by uid 99); 20 Apr 2006 17:48:09 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Apr 2006 10:48:09 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Apr 2006 10:48:08 -0700 Received: from brutus (localhost.localdomain [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6F0597142DF for ; Thu, 20 Apr 2006 17:47:06 +0000 (GMT) Message-ID: <29246026.1145555226446.JavaMail.jira@brutus> Date: Thu, 20 Apr 2006 17:47:06 +0000 (GMT+00:00) From: "Kathey Marsden (JIRA)" To: derby-dev@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. In-Reply-To: <32664667.1145545085726.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ 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