[ https://issues.apache.org/jira/browse/DERBY-7055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard N. Hillegas updated DERBY-7055: --------------------------------------- Issue & fix info: Workaround attached > Infinite loop triggered by failed network connection > ---------------------------------------------------- > > Key: DERBY-7055 > URL: https://issues.apache.org/jira/browse/DERBY-7055 > Project: Derby > Issue Type: Bug > Components: Network Server > Affects Versions: 10.15.1.3 > Reporter: Richard N. Hillegas > Priority: Major > > 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): > {noformat} > 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)) > {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)