Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7794810A1A for ; Mon, 7 Sep 2015 08:43:52 +0000 (UTC) Received: (qmail 79900 invoked by uid 500); 7 Sep 2015 08:43:46 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 79874 invoked by uid 500); 7 Sep 2015 08:43:46 -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 79861 invoked by uid 99); 7 Sep 2015 08:43:46 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Sep 2015 08:43:46 +0000 Date: Mon, 7 Sep 2015 08:43:46 +0000 (UTC) From: "Ashlesha (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-6831) org.apache.derby.client.am.DisconnectException: A communications error has been detected: Read timed out. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14733410#comment-14733410 ] Ashlesha commented on DERBY-6831: --------------------------------- We can not run in embedded configuration. We don't have that capability. > org.apache.derby.client.am.DisconnectException: A communications error has been detected: Read timed out. > ---------------------------------------------------------------------------------------------------------- > > Key: DERBY-6831 > URL: https://issues.apache.org/jira/browse/DERBY-6831 > Project: Derby > Issue Type: Bug > Affects Versions: 10.5.3.0 > Environment: Windows 2003 > Reporter: Ashlesha > Attachments: derby_Allstmt.zip > > > We are using derby server 10.5.3.0 version with our product where we are consistently getting below connection timed out error : > Caused by: java.sql.SQLException: A communications error has been detected: Read timed out. > at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Source) > at com.ibm.ac.si.iuregistry.IUTypeDatabaseImpl.orderInstanceIDsByTimeStamp(IUTypeDatabaseImpl.java:7359) > at com.ibm.ac.si.iuregistry.IUTypeDatabaseImpl.listUndoOrder(IUTypeDatabaseImpl.java:10124) > ... 18 more > Caused by: org.apache.derby.client.am.DisconnectException: A communications error has been detected: Read timed out. > at org.apache.derby.client.net.NetAgent.throwCommunicationsFailure(Unknown Source) > at org.apache.derby.client.net.Reply.fill(Unknown Source) > at org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown Source) > at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source) > at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source) > at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source) > at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source) > at org.apache.derby.client.am.Statement.readOpenQuery(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source) > at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source) > ... 21 more > Caused by: java.net.SocketTimeoutException: Read timed out > at java.net.SocketInputStream.socketRead0(Native Method) > at java.net.SocketInputStream.read(SocketInputStream.java:155) > ... 31 more > The derby logs doesn't show any error message but for the last prepared statement query it waits for sometime (around 5 mins) and then our program comes out i.e it ends with connection timed out error . > Derby log statements : > 2015-09-03 09:40:01.308 GMT Thread[DRDAConnThread_8,5,derby.daemons] (XID = 6580), (SESSIONID = 3), (DATABASE = IURegistryDB), (DRDAID = NF000001.G418-1011056675071531060{4}), Begin compiling prepared statement: SELECT IUI.INSTANCE_ID FROM IU_INSTANCE IUI WHERE IUI.INSTANCE_ID IN (?,?) ORDER BY IUI.CREATED_TIME DESC :End prepared statement > 2015-09-03 09:40:01.308 GMT Thread[DRDAConnThread_8,5,derby.daemons] (XID = 6580), (SESSIONID = 3), (DATABASE = IURegistryDB), (DRDAID = NF000001.G418-1011056675071531060{4}), End compiling prepared statement: SELECT IUI.INSTANCE_ID FROM IU_INSTANCE IUI WHERE IUI.INSTANCE_ID IN (?,?) ORDER BY IUI.CREATED_TIME DESC :End prepared statement > 2015-09-03 09:40:01.324 GMT Thread[DRDAConnThread_8,5,derby.daemons] (XID = 6580), (SESSIONID = 3), (DATABASE = IURegistryDB), (DRDAID = NF000001.G418-1011056675071531060{4}), Executing prepared statement: SELECT IUI.INSTANCE_ID FROM IU_INSTANCE IUI WHERE IUI.INSTANCE_ID IN (?,?) ORDER BY IUI.CREATED_TIME DESC :End prepared statement with 2 parameters begin parameter #1: NULL :end parameter begin parameter #2: f26326912b681e5b:77389106:14f73d7488b:-778a :end parameter > 2015-09-03 09:42:03.105 GMT Thread[DRDAConnThread_9,5,derby.daemons] (XID = 424), (SESSIONID = 3), (DATABASE = TouchPointRegistryDB), (DRDAID = NF000001.G534-868067386902462499{5}), Rolling back > 2015-09-03 09:42:03.105 GMT Thread[DRDAConnThread_9,5,derby.daemons] (XID = 424), (SESSIONID = 3), (DATABASE = TouchPointRegistryDB), (DRDAID = NF000001.G534-868067386902462499{5}), Rolling back > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_7,5,derby.daemons] (XID = 382), (SESSIONID = 1), (DATABASE = TouchPointRegistryDB), (DRDAID = NF000001.H380-508905316620002396{3}), Committing > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_5,5,derby.daemons] (XID = 6545), (SESSIONID = 1), (DATABASE = IURegistryDB), (DRDAID = NF000001.H37F-592784859679789228{2}), Committing > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_7,5,derby.daemons] (XID = 382), (SESSIONID = 1), (DATABASE = TouchPointRegistryDB), (DRDAID = NF000001.H380-508905316620002396{3}), Rolling back > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_7,5,derby.daemons] (XID = 382), (SESSIONID = 1), (DATABASE = TouchPointRegistryDB), (DRDAID = NF000001.H380-508905316620002396{3}), Rolling back > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_5,5,derby.daemons] (XID = 6545), (SESSIONID = 1), (DATABASE = IURegistryDB), (DRDAID = NF000001.H37F-592784859679789228{2}), Rolling back > 2015-09-03 09:48:54.777 GMT Thread[DRDAConnThread_5,5,derby.daemons] (XID = 6545), (SESSIONID = 1), (DATABASE = IURegistryDB), (DRDAID = NF000001.H37F-592784859679789228{2}), Rolling back > Not sure why derby connection is timed out. Could you please go through the derby log and help us to understand the cause of failure? -- This message was sent by Atlassian JIRA (v6.3.4#6332)