db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6336) AssertionFailedError in testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest)
Date Tue, 12 Aug 2014 08:13:12 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093876#comment-14093876
] 

Knut Anders Hatlen commented on DERBY-6336:
-------------------------------------------

Failed again with the extra diagnostics. http://download.java.net/javadesktop/derby/request_5594417/javadb-task-3909544.html

The full plan looks like this (uses an index scan instead of the expected table scan):

{noformat}
Statement Name: 
	null
Statement Text: 
	select count(c1 + c2) from t where c1 = 1
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text: 
Project-Restrict ResultSet (5):
Number of opens = 2
Rows seen = 2
Rows filtered = 0
restriction = false
projection = true
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0
	next time (milliseconds) = 0
	close time (milliseconds) = 0
	restriction time (milliseconds) = 0
	projection time (milliseconds) = 0
	optimizer estimated row count: 1.00
	optimizer estimated cost: 1542.90
Source result set:
	Scalar Aggregate ResultSet:
	Number of opens = 2
	Rows input = 2500
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
		optimizer estimated row count: 85.00
		optimizer estimated cost: 1542.90
	Index Key Optimization = false
	Source result set:
		Project-Restrict ResultSet (4):
		Number of opens = 2
		Rows seen = 2500
		Rows filtered = 0
		restriction = false
		projection = true
			constructor time (milliseconds) = 0
			open time (milliseconds) = 0
			next time (milliseconds) = 0
			close time (milliseconds) = 0
			restriction time (milliseconds) = 0
			projection time (milliseconds) = 0
			optimizer estimated row count: 85.00
			optimizer estimated cost: 1542.90
		Source result set:
			Index Row to Base Row ResultSet for T:
			Number of opens = 2
			Rows seen = 2500
			Columns accessed from heap = {0, 1}
				constructor time (milliseconds) = 0
				open time (milliseconds) = 0
				next time (milliseconds) = 0
				close time (milliseconds) = 0
				optimizer estimated row count: 85.00
				optimizer estimated cost: 1542.90
				Index Scan ResultSet for T using index IDX at read committed isolation level using instantaneous
share row locking chosen by the optimizer
				Number of opens = 2
				Rows seen = 2500
				Rows filtered = 0
				Fetch Size = 16
					constructor time (milliseconds) = 0
					open time (milliseconds) = 0
					next time (milliseconds) = 0
					close time (milliseconds) = 0
					next time in milliseconds/row = 0

				scan information:
					Bit set of columns fetched=All
					Number of columns fetched=2
					Number of deleted rows visited=0
					Number of pages visited=15
					Number of rows qualified=1250
					Number of rows visited=1251
					Scan type=btree
					Tree height=2
					start position:
						>= on first 1 column(s).
						Ordered null semantics on the following columns: 
					stop position:
						> on first 1 column(s).
						Ordered null semantics on the following columns: 
					qualifiers:
						None
					optimizer estimated row count: 85.00
					optimizer estimated cost: 1542.90
{noformat}

> AssertionFailedError in testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest)
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6336
>                 URL: https://issues.apache.org/jira/browse/DERBY-6336
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.11.1.1
>         Environment: Windows 2008, ibm 1.7 SR5.
>            Reporter: Myrna van Lunteren
>         Attachments: d6336-more-info.diff
>
>
> Saw this in nightly testing of trunk (10.11 alpha at revision 1520189): 
> testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest)junit.framework.AssertionFailedError
> 	at org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest.testStalePlansOnLargeTable(StalePlansTest.java:252)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:76)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message