db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasenjit Sarkar (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1777) Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1
Date Wed, 30 Aug 2006 16:54:23 GMT
    [ 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

        

Mime
View raw message