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

Julian Hyde jhyde at pentaho.org
Wed Feb 6 15:36:09 EST 2008


Mondrian regress is getting better. We're down to 15 distinct failures:

testUnknownUsages
testUnknownUsages1
testRollupPolicyAllAsDefault
testRollupBottomLevel
testRollupPolicySimultaneous
testNoTotalForMeasureWithCrossJoinOfJoiningAndNonJoiningDims
testFemaleCustomerCountWithConstraints
testParentChildDrillThrough
testAggregationOnCJofMembersGeneratesOptimalQuery
testAggregateDistinctCount3
testAggregateDistinctCount4
testRankExpandNonNative
testCountExpandNonNative
testCountOverTimeExpandNonNative
testNoTotalForMeasureWithCrossJoinOfJoiningAndNonJoiningDims 

Can I have volunteers to fix some of these tests?

Julian


-----Original Message-----
From: Cron Daemon [mailto:root at marmalade.hydromatic.net] 
Sent: Wednesday, February 06, 2008 2:30 AM
To: julianhyde at gmail.com
Subject: Cron <jhyde at marmalade> nice bash --login
/home/jhyde/open2/mondrian/bin/megatest --nightly

LD_LIBRARY_PATH is:
/home/jhyde/open2/thirdparty/stlport/lib
/home/jhyde/open2/thirdparty/boost/lib
/home/jhyde/open2/aspen/cpp/aspen/farrago/.libs
/home/jhyde/open2/aspen/cpp/aspen/test/.libs
/home/jhyde/open2/aspen/cpp/aspen/libaspen/.libs
/lib
/home/jhyde/open2/fennel/../thirdparty/stlport/lib
/home/jhyde/open2/fennel/../thirdparty/boost/lib
/home/jhyde/open2/fennel/lucidera/farrago/.libs
/home/jhyde/open2/fennel/disruptivetech/farrago/.libs
/home/jhyde/open2/fennel/farrago/.libs
/home/jhyde/open2/fennel/test/.libs
/home/jhyde/open2/fennel/lucidera/libfennel_lu/.libs
/home/jhyde/open2/fennel/disruptivetech/libfennel_dt/.libs
/home/jhyde/open2/fennel/libfennel/.libs
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
 

//open/mondrian/src/main/mondrian/rolap/BitKey.java#14 - updating
/home/jhyde/open2/mondrian/src/main/mondrian/rolap/BitKey.java
No file(s) to resolve.
At revision 72.

::: Summary :::::::::::::::::::::::::::::::::::::
Tests completed at Wed Feb 6 07:29:38 PST 2008.
Running test with JDK=jdk1.6 retroweave= database=oracle props={}
     [java] OK (1758 tests)
    [junit] Tests run: 25, Failures: 0, Errors: 23, Time elapsed: 0.591 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.369 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.208 sec
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.865 sec
    [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.219 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.219 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.21 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.223 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.447 sec
    [junit] Tests run: 25, Failures: 25, Errors: 0, Time elapsed: 0.412 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.419 sec
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.362 sec
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.721 sec
    [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.271 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.247 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.247 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.216 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.324 sec
Running test with JDK=jdk1.5 retroweave= database=oracle props={}
     [java] OK (1758 tests)
    [junit] Tests run: 25, Failures: 0, Errors: 23, Time elapsed: 0.973 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.919 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.514 sec
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.896 sec
    [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.272 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.284 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.409 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.266 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.498 sec
    [junit] Tests run: 25, Failures: 25, Errors: 0, Time elapsed: 0.555 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.864 sec
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.276 sec
    [junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.993 sec
    [junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.323 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.395 sec
    [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.342 sec
    [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.294 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.501 sec
Running test with JDK=jdk1.5 retroweave= database=derby props={
mondrian.test.VUsers=1}
     [java] OK (1758 tests)
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}
     [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: 1758,  Failures: 2,  Errors: 0
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)
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: 1758,  Failures: 2,  Errors: 0
Running test with JDK=jdk1.4 retroweave=true database=oracle props={
mondrian.test.VUsers=1}
     [java] OK (1758 tests)
Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.test.VUsers=1}
     [java] OK (1758 tests)
Running test with JDK=jdk1.6 retroweave= database=oracle props={
mondrian.test.VUsers=1}
     [java] OK (1758 tests)
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}
     [java] 1)
testRollupPolicyAllAsDefault(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '[Store]'
     [java] 2)
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].[CA]'
     [java] 3)
testRollupPolicySimultaneous(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '[Measures].[Unit Sales]'
     [java] 1)
testNoTotalForMeasureWithCrossJoinOfJoiningAndNonJoiningDims(mondrian.test.I
gnoreMeasureForNonJoiningDimensionInAggregationTest)junit.framework.Comparis
onFailure: Expected:
     [java] Tests run: 1758,  Failures: 1,  Errors: 3
Running test with JDK=jdk1.5 retroweave= database=derby props={
mondrian.test.Class=mondrian.rolap.FastBatchingCellReaderTest}
     [java] OK (36 tests)
Running test with JDK=jdk1.5 retroweave= database=mysql props={
mondrian.test.Class=mondrian.rolap.FastBatchingCellReaderTest}
     [java] OK (36 tests)
Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true}
     [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: 1758,  Failures: 2,  Errors: 0
Running test with JDK=jdk1.5 retroweave= database=oracle props={
mondrian.olap.case.sensitive=false}
     [java] OK (1758 tests)
Running test with JDK=jdk1.5 retroweave=true database=oracle props={
mondrian.rolap.star.disableCaching=true mondrian.expCache.enable=false
mondrian.olap.fun.crossjoin.optimizer.size=10000
mondrian.rolap.groupingsets.enable=true
mondrian.olap.NullMemberRepresentation=TheNullMember}
     [java] 1)
testFemaleCustomerCountWithConstraints(mondrian.rolap.TestAggregationManager
)junit.framework.AssertionFailedError: expected:<694> but was:<1122>
     [java] 2)
testParentChildDrillThrough(mondrian.test.ParentChildHierarchyTest)junit.fra
mework.ComparisonFailure: expected:<...39,431.67> but was:<...239,893.59>
     [java] 3)
testAggregationOnCJofMembersGeneratesOptimalQuery(mondrian.rolap.agg.Aggrega
tionOnDistinctCountMeasuresTest)junit.framework.AssertionFailedError:
expected query [select "time_by_day"."the_year" as "c0", count(distinct
"sales_fact_1997"."customer_id") as "m0" from "time_by_day" "time_by_day",
"sales_fact_1997" "sales_fact_1997", "customer" "customer" where
"sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 and "sales_fact_1997"."customer_id" =
"customer"."customer_id" and "customer"."gender" in ('F', 'M') group by
"time_by_day"."the_year"] did not occur
     [java] 4)
testAggregateDistinctCount3(mondrian.rolap.FastBatchingCellReaderTest)junit.
framework.AssertionFailedError: expected query [select
"time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1",
"promotion"."media_type" as "c2", count(distinct
"sales_fact_1997"."customer_id") as "m0" from "time_by_day" "time_by_day",
"sales_fact_1997" "sales_fact_1997", "promotion" "promotion" where
"sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 and "time_by_day"."quarter" = 'Q1' and
"sales_fact_1997"."promotion_id" = "promotion"."promotion_id" and
"promotion"."media_type" in ('Radio', 'TV') group by
"time_by_day"."the_year", "time_by_day"."quarter", "promotion"."media_type"]
did not occur
     [java] Tests run: 1758,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.6 retroweave=true database=mysql props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.rolap.star.disableCaching=true
mondrian.rolap.SparseSegmentValueThreshold=10
mondrian.rolap.groupingsets.enable=true
mondrian.olap.NullMemberRepresentation=TheNullMember}
     [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] 3)
testAggregateDistinctCount4(mondrian.rolap.FastBatchingCellReaderTest)junit.
framework.AssertionFailedError: expected query [select count(distinct
`sales_fact_1997`.`customer_id`) as `m0` from `store` as `store`,
`sales_fact_1997` as `sales_fact_1997`, `time_by_day` as `time_by_day` where
`sales_fact_1997`.`store_id` = `store`.`store_id` and
`store`.`store_country` = 'USA' and `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))] did
not occur
     [java] Tests run: 1758,  Failures: 3,  Errors: 0
Running test with JDK=jdk1.5 retroweave= database=derby props={
mondrian.rolap.star.disableCaching=true
mondrian.native.crossjoin.enable=false mondrian.native.topcount.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.expCache.enable=false mondrian.rolap.SparseSegmentValueThreshold=10
mondrian.olap.fun.crossjoin.optimizer.size=0
mondrian.rolap.groupingsets.enable=true}
     [java] 1)
testRankExpandNonNative(mondrian.test.clearview.SummaryTest)junit.framework.
ComparisonFailure: expected:<...Bologna].[American].[American Low Fat
Bologna], [Store Size in SQFT].[All Store Size in SQFTs].[21215]}
     [java] 2)
testCountExpandNonNative(mondrian.test.clearview.SummaryTest)junit.framework
.ComparisonFailure: expected:<...Bologna].[American].[American Low Fat
Bologna]}
     [java] 3)
testCountOverTimeExpandNonNative(mondrian.test.clearview.SummaryTest)junit.f
ramework.ComparisonFailure: expected:<...Bologna].[American].[American Low
Fat Bologna]}
     [java] 4)
testNoTotalForMeasureWithCrossJoinOfJoiningAndNonJoiningDims(mondrian.test.I
gnoreMeasureForNonJoiningDimensionInAggregationTest)junit.framework.Comparis
onFailure: Expected:
     [java] Tests run: 1657,  Failures: 4,  Errors: 0
    [junit] Tests run: 25, Failures: 0, Errors: 23, Time elapsed: 0.591 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.369 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.447 sec
    [junit] Tests run: 25, Failures: 25, Errors: 0, Time elapsed: 0.412 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.419 sec
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.362 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.324 sec
    [junit] Tests run: 25, Failures: 0, Errors: 23, Time elapsed: 0.973 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.919 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.498 sec
    [junit] Tests run: 25, Failures: 25, Errors: 0, Time elapsed: 0.555 sec
    [junit] Tests run: 20, Failures: 20, Errors: 0, Time elapsed: 0.864 sec
    [junit] Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 0.276 sec
    [junit] Tests run: 19, Failures: 0, Errors: 17, Time elapsed: 0.501 sec
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 2,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 2,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 1,  Errors: 3
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 2,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1758,  Failures: 3,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1657,  Failures: 4,  Errors: 0
There were failures.





More information about the Mondrian mailing list