[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12431623 ] Prasenjit Sarkar commented on DERBY-1777: -----------------------------------------
All of them fail with the same stack trace. All failures are repeatable and affect only certain queries and not others. Here is the derby.log for one failure that indicates an optimizer problem rather than a connection problem 2006-08-30 00:57:44.062 GMT Thread[DRDAConnThread_3,5,main] (XID = 47607), (SESSIONID = 0), (DATABASE = Aperi), (DRDAID = NF000001.H18F-520727550015307819{2}), Failed Statement is: SELECT DISTINCT FABRIC.FABRIC_ID FROM T_VIEW_VOTHER2PORT OTHER2PORT, T_VIEW_PORT2ZSET PORT2ZSET, T_RES_ZSET, T_RES_FABRIC FABRIC WHERE OTHER2PORT.PREFIX_ID = 'x' and OTHER2PORT.OTHER_ID = 1 and OTHER2PORT.PORT_ID = PORT2ZSET.PORT_ID and PORT2ZSET.ZSET_ID = T_RES_ZSET.ZSET_ID and T_RES_ZSET.FABRIC_WWN = FABRIC.FABRIC_WWN java.lang.NullPointerException at org.apache.derby.impl.sql.compile.FromBaseTable.uniqueJoin(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.uniqueJoin(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.uniqueJoinWithOuterTable(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.JoinNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Unknown Source) at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.optimize(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(Unknown Source) at org.apache.derby.impl.drda.DRDAStatement.prepare(Unknown Source) at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) I will try increase the severity log and report the results > Regression: query works in 10.1.2.1 but fails with NullPointerException in > 10.2.1.1 > ----------------------------------------------------------------------------------- > > Key: DERBY-1777 > URL: http://issues.apache.org/jira/browse/DERBY-1777 > Project: Derby > Issue Type: Bug > Environment: WinXP SP2 dualcore 2.8 GHz 2 GBmemory > Reporter: Prasenjit Sarkar > Fix For: 10.2.1.0 > > > However, here's a query that works in 10.1.2.1 but not in 10.2.1.1 -- > database can be assumed to be the same in Derby - 1205 > SELECT DISTINCT > ZONE.ZONE_ID ZONE_ID, > PORT.PORT_ID PORT_ID, > ENTITY_TO_PORT.TYPE, > ENTITY_TO_PORT.PREFIX_ID, > ENTITY_TO_PORT.ENTITY_ID, > ENTITY_TO_PORT.DISPLAY_NAME, > ENTITY_TO_PORT.PORT_DISPLAY_NAME, > PORT2ZONE.MEMBER_NAME, > PORT2ZONE.ZONE_MEMBER_ID, > PORT.PORT_NUMBER > FROM > T_RES_ZONE ZONE left outer join T_VIEW_PORT2ZONE PORT2ZONE on > ZONE.ZONE_ID = PORT2ZONE.ZONE_ID left outer join T_RES_PORT PORT on > PORT2ZONE.PORT_ID = PORT.PORT_ID left outer join T_VIEW_ENTITY_TO_PORT > ENTITY_TO_PORT on > PORT2ZONE.PORT_ID = ENTITY_TO_PORT.PORT_ID and > PORT2ZONE.ZONE_ID = ENTITY_TO_PORT.ZONE_ID, T_RES_FABRIC FABRIC > WHERE PORT2ZONE.ZONE_ID = ZONE.ZONE_ID and > ZONE.FABRIC_WWN = FABRIC.FABRIC_WWN and > FABRIC.FABRIC_ID = 1 > Same db as before. > In 10.2.1.1 it gives the following error (should this be a new issue?) > java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, > SQLERRMC: java.lang.NullPointerExceptionXJ001.U > 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.Connection.prepareStatement(Unknown Source) > at > org.eclipse.aperi.server.guireq.topology.views.ViewerSanL1.init(ViewerSanL1.java:1828) > > at > org.eclipse.aperi.server.guireq.topology.views.ViewerInit.init(ViewerInit.java:41) > > at > org.eclipse.aperi.server.guireq.topology.views.ViewerInit.main(ViewerInit.java:69) > > Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: > -1, SQLSTATE: XJ001, SQLERRMC: java.lang.NullPointerExceptionXJ001.U > at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) > at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown > Source) > at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown > Source) > at > org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown > Source) > at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown > Source) > at > org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown > Source) > at > org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown > Source) > at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) > at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) > ... 4 more -- 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