[Mondrian] FW: Cron <jhyde at marmalade> nice bash --login /home/jhyde/open2/mondrian/bin/megatest --nightly

Rushan Chen rchen at lucidera.com
Thu Dec 6 17:44:48 EST 2007


Hi Julian,

What revision range does this run cover?

I tried to bucket the failures with the associated test setup.

Many errors come in groups indicating problem in common code path from 
those tests.
There are 10 distinct groups of failures.

Some failures are unique to certain combination of JDK and DB:

JDK1.4 mysql: 1,2,3,8
JDK1.5 mysql: 1,3
JDK1.6 mysql: 1,5,6
JDK1.5 oracle: 2,3,4,9
JDK1.6 oracle: 2,3,6,7
JDK1.6 derby: 10

I will start looking at the JDK1.5+mysql group then move on to 
JDK1.5+oracle group. If you checked in code which could have caused any 
of these failures, please help analyzing the other groups. Thanks!

Rushan

(1)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.4 retroweave=true database=mysql props={
mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true}

Running test with JDK=jdk1.5 retroweave= database=mysql props={
mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true}

Running test with JDK=jdk1.6 retroweave= database=mysql props={
mondrian.rolap.star.disableCaching=true
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1
mondrian.olap.fun.crossjoin.optimizer.size=10000}


testPredicatesAreNotOptimizedWhenPropertyIsFalse(mondrian.rolap.sql.SqlQuery
Test)junit.framework.AssertionFailedError: expected query [select
`time_by_day`.`the_year` as `c0`, `time_by_day`.`quarter` as `c1`,
sum(`sales_fact_1997`.`unit_sales`) as `m0` from `time_by_day` as
`time_by_day`, `sales_fact_1997` as `sales_fact_1997` where
`sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and
`time_by_day`.`the_year` = 1997 and `time_by_day`.`quarter` in ('Q1', 'Q2',
'Q3') group by `time_by_day`.`the_year`, `time_by_day`.`quarter`] did not
occur
     [java] 4)
testPredicatesAreOptimizedWhenAllTheMembersAreIncluded(mondrian.rolap.sql.Sq
lQueryTest)junit.framework.AssertionFailedError: expected query [select
`time_by_day`.`the_year` as `c0`, `time_by_day`.`quarter` as `c1`,
sum(`sales_fact_1997`.`unit_sales`) as `m0` from `time_by_day` as
`time_by_day`, `sales_fact_1997` as `sales_fact_1997` where
`sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and
`time_by_day`.`the_year` = 1997 group by `time_by_day`.`the_year`,
`time_by_day`.`quarter`] did not occur
     [java] 5)
testPredicatesAreOptimizedWhenPropertyIsTrue(mondrian.rolap.sql.SqlQueryTest
)junit.framework.AssertionFailedError: expected query [select
`time_by_day`.`the_year` as `c0`, `time_by_day`.`quarter` as `c1`,
sum(`sales_fact_1997`.`unit_sales`) as `m0` from `time_by_day` as
`time_by_day`, `sales_fact_1997` as `sales_fact_1997` where
`sales_fact_1997`.`time_id` = `time_by_day`.`time_id` and
`time_by_day`.`the_year` = 1997 group by `time_by_day`.`the_year`,
`time_by_day`.`quarter`] did not occur
     [java] Tests run: 1566,  Failures: 5,  Errors: 1

(2)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=-1
mondrian.expCache.enable=false}

Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.test.ExpDependencies=100
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=15583
mondrian.expCache.enable=false}

Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false}

Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.expCache.enable=false
mondrian.rolap.SparseSegmentValueThreshold=25000}

Running test with JDK=jdk1.4 retroweave=true database=mysql props={
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1000
mondrian.rolap.SparseSegmentValueThreshold=10}

Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.rolap.aggregates.ChooseByVolume=true
mondrian.rolap.star.disableCaching=true
mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.SparseSegmentValueThreshold=25000}

Running test with JDK=jdk1.5 retroweave=true database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.star.disableCaching=true
mondrian.native.topcount.enable=false mondrian.native.filter.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=25000}

     [java] 1)
testRollupPolicySimultaneous(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '([Measures].[Unit Sales], [Customers].[All
Customers].[USA].[CA])'
     [java] Tests run: 1566,  Failures: 0,  Errors: 1


(3)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true}

Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.expCache.enable=false
mondrian.rolap.SparseSegmentValueThreshold=25000}

Running test with JDK=jdk1.4 retroweave=true database=mysql props={
mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true}

Running test with JDK=jdk1.5 retroweave= database=mysql props={
mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true}

     [java] 1)
testMultipleDimensionUsages(mondrian.test.SchemaTest)mondrian.olap.MondrianE
xception: Mondrian Error:Too many errors, '1', while loading/reloadin
aggregates.
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] Tests run: 1566,  Failures: 2,  Errors: 1

(4)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.test.ExpDependencies=100 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=15583 mondrian.expCache.enable=false}

     [java] 1)
testRollupBottomLevel(mondrian.test.AccessControlTest)mondrian.olap.Mondrian
Exception: Mondrian Error:Internal error: Error while executing query [with
member [Measures].[Foo] as '[Customers].[All Customers].[USA]'
     [java] 2)

(5)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.6 retroweave= database=mysql props={
mondrian.native.crossjoin.enable=false
mondrian.native.topcount.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1}

lots of tests with NPE

(6)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.6 retroweave= database=mysql props={
mondrian.rolap.star.disableCaching=true
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1
mondrian.olap.fun.crossjoin.optimizer.size=10000}

Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true
mondrian.rolap.aggregates.Read=true
mondrian.rolap.aggregates.ChooseByVolume=true
mondrian.rolap.star.disableCaching=true
mondrian.native.filter.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.olap.fun.crossjoin.optimizer.size=0
mondrian.rolap.groupingsets.enable=true}


GC limit exceeded

(7)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false}

     [java] 1)
testGroupBatchesForTwoSetOfGroupableBatches(mondrian.rolap.FastBatchingCellR
eaderTest)junit.framework.AssertionFailedError: expected:<2> but was:<4>
     [java] 2)
testCanBatchForBatchesFromSameAggregationButDifferentRollupOption(mondrian.r
olap.FastBatchingCellReaderTest)junit.framework.AssertionFailedError
     [java] Tests run: 1465,  Failures: 2,  Errors: 1


(8)
--------------------------------------------------------------------------------

Running test with JDK=jdk1.4 retroweave=true database=mysql props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1000
mondrian.rolap.SparseSegmentValueThreshold=10}

testFlush(mondrian.rolap.CacheControlTest)junit.framework.ComparisonFailure:
Expected:
     [java] Tests run: 1465,  Failures: 1,  Errors: 1


(9)
--------------------------------------------------------------------------------


Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.rolap.aggregates.ChooseByVolume=true
mondrian.rolap.star.disableCaching=true mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.SparseSegmentValueThreshold=25000}

Running test with JDK=jdk1.5 retroweave=true database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.star.disableCaching=true
mondrian.native.topcount.enable=false mondrian.native.filter.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=25000}


Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.rolap.star.disableCaching=true}


OOM

(10)
--------------------------------------------------------------------------------


Running test with JDK=jdk1.6 retroweave= database=derby props={
mondrian.native.crossjoin.enable=false mondrian.native.topcount.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false}
     [java] 1)
testAggregateDistinctCount4(mondrian.rolap.FastBatchingCellReaderTest)junit.
framework.AssertionFailedError: expected query [select count(distinct
"sales_fact_1997"."customer_id") as "m0" from "time_by_day" as
"time_by_day", "sales_fact_1997" as "sales_fact_1997", "store" as "store"
where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and
(("time_by_day"."month_of_year" = 7 and "time_by_day"."quarter" = 'Q3' and
"time_by_day"."the_year" = 1997) or ("time_by_day"."quarter" = 'Q1' and
"time_by_day"."the_year" = 1997)) and "sales_fact_1997"."store_id" =
"store"."store_id" and ("store"."store_country" = 'USA' or
("store"."store_state" = 'CA' and "store"."store_country" = 'USA'))] did not
occur







More information about the Mondrian mailing list