[Mondrian] Failed tests on hudson

kcheng xwcheng at gmail.com
Fri Jun 12 19:34:12 EDT 2009


it's the test result with my environment: mysql, ubuntu 8.0.4


  [java] There were 6 failures:
     [java] 1)
testNonEmptyCJConstraintOnVirtualCube(mondrian.rolap.VirtualCubeTest)junit.framework.AssertionFailedError:
expected query [select `time_by_day`.`the_year` as `c0`,
`time_by_day`.`quarter` as `c1`, `time_by_day`.`month_of_year` as `c2`,
`store`.`store_country` as `c3` from `time_by_day` as `time_by_day`,
`sales_fact_1997` as `sales_fact_1997`, `store` as `store`, `product_class`
as `product_class`, `product` as `product` where `sales_fact_1997`.`time_id`
= `time_by_day`.`time_id` and `sales_fact_1997`.`store_id` =
`store`.`store_id` and `sales_fact_1997`.`product_id` =
`product`.`product_id` and `product`.`product_class_id` =
`product_class`.`product_class_id` and `product_class`.`product_family` =
'Food' and (`store`.`store_country` = 'USA') group by
`time_by_day`.`the_year`, `time_by_day`.`quarter`,
`time_by_day`.`month_of_year`, `store`.`store_country` union select
`time_by_day`.`the_year` as `c0`, `time_by_day`.`quarter` as `c1`,
`time_by_day`.`month_of_year` as `c2`, `store`.`store_country` as `c3` from
`time_by_day` as `time_by_day`, `inventory_fact_1997` as
`inventory_fact_1997`, `store` as `store`, `product_class` as
`product_class`, `product` as `product` where
`inventory_fact_1997`.`time_id` = `time_by_day`.`time_id` and
`inventory_fact_1997`.`store_id` = `store`.`store_id` and
`inventory_fact_1997`.`product_id` = `product`.`product_id` and
`product`.`product_class_id` = `product_class`.`product_class_id` and
`product_class`.`product_family` = 'Food' and (`store`.`store_country` =
'USA') group by `time_by_day`.`the_year`, `time_by_day`.`quarter`,
`time_by_day`.`month_of_year`, `store`.`store_country` order by ISNULL(1), 1
ASC, ISNULL(2), 2 ASC, ISNULL(3), 3 ASC, ISNULL(4), 4 ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:336)
     [java]     at
mondrian.rolap.VirtualCubeTest.testNonEmptyCJConstraintOnVirtualCube(VirtualCubeTest.java:1217)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] 2)
testNonEmptyConstraintOnVirtualCubeWithCalcMeasure(mondrian.rolap.VirtualCubeTest)junit.framework.AssertionFailedError:
expected query [select `product_class`.`product_family` as `c0` from
`product` as `product`, `product_class` as `product_class`,
`sales_fact_1997` as `sales_fact_1997`, `store` as `store` where
`product`.`product_class_id` = `product_class`.`product_class_id` and
`sales_fact_1997`.`product_id` = `product`.`product_id` and
`sales_fact_1997`.`store_id` = `store`.`store_id` and
`store`.`store_country` = 'USA' group by `product_class`.`product_family`
union select `product_class`.`product_family` as `c0` from `product` as
`product`, `product_class` as `product_class`, `inventory_fact_1997` as
`inventory_fact_1997`, `store` as `store` where `product`.`product_class_id`
= `product_class`.`product_class_id` and `inventory_fact_1997`.`product_id`
= `product`.`product_id` and `inventory_fact_1997`.`store_id` =
`store`.`store_id` and `store`.`store_country` = 'USA' group by
`product_class`.`product_family` order by ISNULL(1), 1 ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:336)
     [java]     at
mondrian.rolap.VirtualCubeTest.testNonEmptyConstraintOnVirtualCubeWithCalcMeasure(VirtualCubeTest.java:1285)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] 3)
testMultiLevelMemberConstraintNonNullParent(mondrian.rolap.NonEmptyTest)junit.framework.AssertionFailedError:
expected query [select `store`.`store_country` as `c0`,
`store`.`store_state` as `c1`, `store`.`store_city` as `c2`,
`product_class`.`product_family` as `c3` from `store` as `store`,
`sales_fact_1997` as `sales_fact_1997`, `product` as `product`,
`product_class` as `product_class` where `sales_fact_1997`.`store_id` =
`store`.`store_id` and `product`.`product_class_id` =
`product_class`.`product_class_id` and `sales_fact_1997`.`product_id` =
`product`.`product_id` and ((`store`.`store_city`,`store`.`store_state`) in
(('Portland','OR'),('Salem','OR'),('San Francisco','CA'),('Tacoma','WA')))
and (`product_class`.`product_family` = 'Food') group by
`store`.`store_country`, `store`.`store_state`, `store`.`store_city`,
`product_class`.`product_family` order by ISNULL(`store`.`store_country`),
`store`.`store_country` ASC, ISNULL(`store`.`store_state`),
`store`.`store_state` ASC, ISNULL(`store`.`store_city`),
`store`.`store_city` ASC, ISNULL(`product_class`.`product_family`),
`product_class`.`product_family` ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:287)
     [java]     at
mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNonNullParent(NonEmptyTest.java:1491)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] 4)
testMultiLevelMemberConstraintNullParent(mondrian.rolap.NonEmptyTest)junit.framework.AssertionFailedError:
expected query [select `warehouse`.`wa_address3` as `c0`,
`warehouse`.`wa_address2` as `c1`, `warehouse`.`wa_address1` as `c2`,
`warehouse`.`warehouse_name` as `c3`, `product_class`.`product_family` as
`c4` from `warehouse` as `warehouse`, `inventory_fact_1997` as
`inventory_fact_1997`, `product` as `product`, `product_class` as
`product_class` where `inventory_fact_1997`.`warehouse_id` =
`warehouse`.`warehouse_id` and `product`.`product_class_id` =
`product_class`.`product_class_id` and `inventory_fact_1997`.`product_id` =
`product`.`product_id` and ((`warehouse`.`wa_address2` is null and
(`warehouse`.`warehouse_name`,`warehouse`.`wa_address1`) in (('Arnold and
Sons','5617 Saclan Terrace'),('Jones International','3377 Coachman
Place')))) and (`product_class`.`product_family` = 'Food') group by
`warehouse`.`wa_address3`, `warehouse`.`wa_address2`,
`warehouse`.`wa_address1`, `warehouse`.`warehouse_name`,
`product_class`.`product_family` order by ISNULL(`warehouse`.`wa_address3`),
`warehouse`.`wa_address3` ASC, ISNULL(`warehouse`.`wa_address2`),
`warehouse`.`wa_address2` ASC, ISNULL(`warehouse`.`wa_address1`),
`warehouse`.`wa_address1` ASC, ISNULL(`warehouse`.`warehouse_name`),
`warehouse`.`warehouse_name` ASC, ISNULL(`product_class`.`product_family`),
`product_class`.`product_family` ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:304)
     [java]     at
mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNullParent(NonEmptyTest.java:1574)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] 5)
testMultiLevelMemberConstraintMixedNullNonNullParent(mondrian.rolap.NonEmptyTest)junit.framework.AssertionFailedError:
expected query [select `warehouse`.`warehouse_fax` as `c0`,
`warehouse`.`wa_address1` as `c1`, `warehouse`.`warehouse_name` as `c2`,
`product_class`.`product_family` as `c3` from `warehouse` as `warehouse`,
`inventory_fact_1997` as `inventory_fact_1997`, `product` as `product`,
`product_class` as `product_class` where
`inventory_fact_1997`.`warehouse_id` = `warehouse`.`warehouse_id` and
`product`.`product_class_id` = `product_class`.`product_class_id` and
`inventory_fact_1997`.`product_id` = `product`.`product_id` and
((`warehouse`.`warehouse_name`,`warehouse`.`wa_address1`,`warehouse`.`warehouse_fax`)
in (('Jones International','3377 Coachman Place','971-555-6213')) or
(`warehouse`.`warehouse_fax` is null and
(`warehouse`.`warehouse_name`,`warehouse`.`wa_address1`) in (('Freeman And
Co','234 West Covina Pkwy')))) and (`product_class`.`product_family` =
'Food') group by `warehouse`.`warehouse_fax`, `warehouse`.`wa_address1`,
`warehouse`.`warehouse_name`, `product_class`.`product_family` order by
ISNULL(`warehouse`.`warehouse_fax`), `warehouse`.`warehouse_fax` ASC,
ISNULL(`warehouse`.`wa_address1`), `warehouse`.`wa_address1` ASC,
ISNULL(`warehouse`.`warehouse_name`), `warehouse`.`warehouse_name` ASC,
ISNULL(`product_class`.`product_family`), `product_class`.`product_family`
ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:304)
     [java]     at
mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintMixedNullNonNullParent(NonEmptyTest.java:1664)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java] 6)
testMultiLevelMemberConstraintWithMixedNullNonNullChild(mondrian.rolap.NonEmptyTest)junit.framework.AssertionFailedError:
expected query [select `warehouse`.`wa_address3` as `c0`,
`warehouse`.`wa_address2` as `c1`, `warehouse`.`warehouse_fax` as `c2`,
`product_class`.`product_family` as `c3` from `warehouse` as `warehouse`,
`inventory_fact_1997` as `inventory_fact_1997`, `product` as `product`,
`product_class` as `product_class` where
`inventory_fact_1997`.`warehouse_id` = `warehouse`.`warehouse_id` and
`product`.`product_class_id` = `product_class`.`product_class_id` and
`inventory_fact_1997`.`product_id` = `product`.`product_id` and
((`warehouse`.`warehouse_fax` = '971-555-6213' or
`warehouse`.`warehouse_fax` is null) and `warehouse`.`wa_address2` is null
and `warehouse`.`wa_address3` is null) and (`product_class`.`product_family`
= 'Food') group by `warehouse`.`wa_address3`, `warehouse`.`wa_address2`,
`warehouse`.`warehouse_fax`, `product_class`.`product_family` order by
ISNULL(`warehouse`.`wa_address3`), `warehouse`.`wa_address3` ASC,
ISNULL(`warehouse`.`wa_address2`), `warehouse`.`wa_address2` ASC,
ISNULL(`warehouse`.`warehouse_fax`), `warehouse`.`warehouse_fax` ASC,
ISNULL(`product_class`.`product_family`), `product_class`.`product_family`
ASC] did not occur
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:420)
     [java]     at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:304)
     [java]     at
mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintWithMixedNullNonNullChild(NonEmptyTest.java:1751)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
     [java]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java]
     [java] FAILURES!!!
     [java] Tests run: 2123,  Failures: 6,  Errors: 0
     [java]
     [java] Time: 653.897
     [java] Test stopped due to errors.
     [java] Java Result: 1

Thanks,
kcheng


On Fri, Jun 12, 2009 at 6:53 PM, Eric McDermid <mcdermid at stonecreek.com>wrote:

> I believe Hudson is running against MySQL, so if you're running against
> another RDBMS that might be the reason.  I do get the same 6 failures on my
> synced-to-latest sandbox (MySQL 5.1.35 on OSX 10.5.7).
> Haven't looked into the failures yet, as I'm just starting to move code
> over from a Mondrian 2.4-based project.
>  -- Eric
>
> On Jun 12, 2009, at 2:57 PM, Matt Campbell wrote:
>
> We've had 6 failed tests in hudson for a very long time.  These tests don't
> fail in my environment.  Does anyone know why they're failing on hudson?
>  Test Name    <http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#>
> Duration    <http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#>
> Age    <http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#>
> mondrian.rolap.VirtualCubeTest.testNonEmptyCJConstraintOnVirtualCube<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyCJConstraintOnVirtualCube>
> 1.038 40
> mondrian.rolap.VirtualCubeTest.testNonEmptyConstraintOnVirtualCubeWithCalcMeasure<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyConstraintOnVirtualCubeWithCalcMeasure>
> 0.342 40
> mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNonNullParent<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNonNullParent>
> 0.47 40
> mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNullParent<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNullParent>
> 0.276 40
> mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintMixedNullNonNullParent<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintMixedNullNonNullParent>
> 0.31 40
> mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintWithMixedNullNonNullChild<http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintWithMixedNullNonNullChild>
> 0.273 40
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090612/2e7ea702/attachment.html 


More information about the Mondrian mailing list