[DERBY-7055] Infinite loop triggered by failed network connection - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.15.1.3
Fix Version/s: None
Component/s: Network Server
Labels:
None

Urgency:
Normal
Issue & fix info:

Workaround attached
Bug behavior facts:

Crash, Seen in production

Description

Geraldine McCormack reports the following infinite loop during a network connection failure (see http://apache-database.10148.n7.nabble.com/Constants-for-CHAR-FOR-BIT-DATA-td150532.html#a150542):

3XMTHREADINFO      "pool-2-thread-312 [TransBlockRunner-470056]" 
J9VMThread:0x0000000003BCA600, omrthread_t:0x00007F3FC00573B8, 
java/lang/Thread:0x0000000507D4CD28, state:R, prio=5
3XMJAVALTHREAD            (java/lang/Thread getId:0x5A3D, isDaemon:false)
3XMTHREADINFO1            (native thread ID:0x2767, native priority:0x5, 
native policy:UNKNOWN, vmstate:CW, vm thread flags:0x00000081)
3XMTHREADINFO2            (native stack address range 
from:0x00007F40106F8000, to:0x00007F4010739000, size:0x41000)
3XMCPUTIME               CPU usage total: 4.320964374 secs, current 
category="Application"
3XMHEAPALLOC             Heap bytes allocated since last GC cycle=212912 
(0x33FB0)
3XMTHREADINFO3           Java callstack:
4XESTACKTRACE                at 
java/lang/Throwable.printStackTrace(Throwable.java:547(Compiled Code))
4XESTACKTRACE                at 
java/lang/Throwable.printStackTrace(Throwable.java:318(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:450(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 17)
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 16)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:21(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.completeSqlca(Bytecode 
PC:59(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:176)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepare(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepare_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
10)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getMessage(Bytecode PC:68(Compiled Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
9)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getJDBCMessage(Bytecode PC:19(Compiled 
Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetSqlca@0x0000000752653EB8, entry count: 1)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.getMessage(Bytecode PC:32(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:91(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 15)
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:85(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 14)
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 13)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:63(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:29(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:6(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode 
PC:19(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode PC:9)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:235)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepare(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepare_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
8)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getMessage(Bytecode PC:68(Compiled Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
7)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getJDBCMessage(Bytecode PC:19(Compiled 
Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetSqlca@0x00000007479C3350, entry count: 1)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.getMessage(Bytecode PC:32(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:91(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 12)
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:85(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 11)
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 10)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:63(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:29(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:6(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode 
PC:19(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode PC:9)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:235)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepare(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepare_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
6)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getMessage(Bytecode PC:68(Compiled Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
5)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getJDBCMessage(Bytecode PC:19(Compiled 
Code))
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetSqlca@0x0000000750E34480, entry count: 1)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.getMessage(Bytecode PC:32(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:91(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 9)
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:85(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 8)
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
5XESTACKTRACE                   (entered lock: 
java/io/PrintWriter@0x0000000506E667E8, entry count: 7)
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:63(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:29(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:6(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode 
PC:19(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode PC:9)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:235)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepare(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepare_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
5XESTACKTRACE                   (entered lock: 
org/apache/derby/client/net/NetConnection@0x000000050B778868, entry count: 
4XESTACKTRACE                at 

...

org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getMessage(Bytecode PC:68(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getJDBCMessage(Bytecode PC:19(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.getMessage(Bytecode PC:32(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:91(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:85(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:63(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:29(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:6(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode 
PC:19(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode PC:9)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:235)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepare(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepare_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepare(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.readPrepareDescribeInput(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.flowPrepareDescribeInputOutput(Bytecode 
PC:29(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientPreparedStatement.prepare(Bytecode 
PC:1(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareCallX(Bytecode 
PC:33(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientConnection.prepareMessageProc(Bytecode 
PC:16)
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getMessage(Bytecode PC:68(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/Sqlca.getJDBCMessage(Bytecode PC:19(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.getMessage(Bytecode PC:32(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:91(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ExceptionFormatter.printTrace(Bytecode 
PC:85(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/LogWriter.traceDiagnosable(Bytecode 
PC:32(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:63(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:29(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/SqlException.<init>(Bytecode PC:6(Compiled 
Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode 
PC:19(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/DisconnectException.<init>(Bytecode PC:9)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetConnectionReply.parseCMDCHKRM(Bytecode 
PC:235)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePrepareError(Bytecode 
PC:82)
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.parsePRPSQLSTTreply(Bytecode 
PC:107(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatementReply.readPrepareDescribeOutput(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/StatementReply.readPrepareDescribeOutput(Bytecode 
PC:7(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/net/NetStatement.readPrepareDescribeOutput_(Bytecode 
PC:11(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.readPrepareDescribeOutput(Bytecode 
PC:6(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.flowExecute(Bytecode 
PC:629(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.executeQueryX(Bytecode 
PC:3(Compiled Code))
4XESTACKTRACE                at 
org/apache/derby/client/am/ClientStatement.executeQuery(Bytecode 
PC:40(Compiled Code))

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Richard N. Hillegas

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 07/Oct/19 22:59

Updated:: 08/Oct/19 12:48