[Mondrian] Failed tests on hudson

Julian Hyde jhyde at pentaho.com
Mon Jun 22 13:56:05 EDT 2009

So, we have:

*	 6 failures on MySQL, all of them 'expected query did not occur';
*	 4 failures on PostgreSQL, 3 of which are 'expected query did not
occur', but different than MySQL, and an error in testNullCollation; and
*	 1 failure on Oracle, in testNullCollation.

I don't view any of these as serious. The 'expected query did not occur'
probably just requires someone to fix a hard-coded string in a test, and
testNullCollation is fairly esoteric unless you're writing queries that sort
null values and need to run on more than one DBMS.
But, it's irritating to have test exceptions. I'll look into the MySQL
exceptions (since it's probably me that introduced them) and
testNullCollation. Can someone look into the PostgreSQL errors?


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of kcheng
Sent: Friday, June 12, 2009 11:04 PM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Failed tests on hudson

Hi all,
         I run the unit test again with PostgreSQL 8.3  and I got 4
failures, the failures in PostgreSQL are totally different from MySQL( There
are 6 failures with MySQL) . Below are the failures in PostgreSQL

     [java] 1)
est)junit.framework.ComparisonFailure: Row tuple 32 member 0; ;
expected=[Promotions].[All Promotions].[Sale Winners];
actual=[Promotions].[All Promotions].[Sales Days]
     [java] Query: select {Generate([Time].[Year].Members,
{[Time].CurrentMember, [Time].CurrentMember.Children})} ON COLUMNS,
     [java]   [Promotions].[All Promotions].Children ON ROWS
     [java] from [Sales]
     [java] where [Measures].[Unit Sales]

     [java] 2)
framework.ComparisonFailure: Row tuple 32 member 0; ;
expected=[Promotions].[All Promotions].[Sale Winners];
actual=[Promotions].[All Promotions].[Sales Days]
     [java] Query: select {[Measures].[Store Sales]} ON COLUMNS,
     [java]   Generate([Product].[All Products].[Drink].Children,
Crossjoin([Promotions].Children, {[Product].CurrentMember})) ON ROWS
     [java] from [Sales]

     [java] 3)
ork.ComparisonFailure: expected:<...ll Promotions].[Sale[ Winners],
[Measures].[Unit Sales]}
     [java] 4)
Failure: Expected:


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

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/#>    	
ualCubeTest/testNonEmptyCJConstraintOnVirtualCube> 	 1.038	 40	
0.342	 40	
mptyTest/testMultiLevelMemberConstraintNonNullParent> 	 0.47	 40	
mptyTest/testMultiLevelMemberConstraintNullParent> 	 0.276	 40	
mptyTest/testMultiLevelMemberConstraintMixedNullNonNullParent> 	 0.31	 40

0.273	 40	
Mondrian mailing list
Mondrian at pentaho.org

Mondrian mailing list
Mondrian at pentaho.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090622/a2f65930/attachment.html 

More information about the Mondrian mailing list