PDA

View Full Version : test failed access



ffo_uci
08-31-2003, 10:35 PM
Just try to test the software, run the mondrian and some errors occured.
tests run 379 Failures:10 error:8
testBigQuery: error
Internal error: Error while executing query [select {[Measures].[Unit Sales]} ON columns, {[Product].Members} ON rows from [Sales] ]
mondrian.resource.ChainableRuntimeException: Internal error: Error while executing query [select {[Measures].[Unit Sales]} ON columns,
{[Product].Members} ON rows
from [Sales]
]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.olap.Util.newError(Util.java:445)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:257)
at mondrian.test.FoodMartTestCase.runQuery(FoodMartTestCase.java:39)
at mondrian.test.BasicQueryTest.testBigQuery(BasicQueryTest.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: mondrian.resource.ChainableRuntimeException: Internal error: while populating member cache with members for level '[Product].[Brand Name]'; sql=[select `product_class`.`product_family` as `c0`, `product_class`.`product_department` as `c1`, `product_class`.`product_category` as `c2`, `product_class`.`product_subcategory` as `c3`, `product`.`brand_name` as `c4` from `product` as `product`, `product_class` as `product_class` where `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` group by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category`, `product_class`.`product_subcategory`, `product`.`brand_name` order by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category`, `product_class`.`product_subcategory`, `product`.`brand_name`]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:538)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:442)
at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:126)
at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:143)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:321)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:315)
at mondrian.olap.fun.BuiltinFunTable$73.evaluate(BuiltinFunTable.java:2872)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.olap.fun.SetFunDef.evaluate(SetFunDef.java:56)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:162)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:86)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:242)
... 18 more
Caused by: mondrian.resource.ChainableRuntimeException: Internal error: mondrian.rolap.SmartMemberReader$ChildrenList@e29820 is not registered
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
at mondrian.olap.Util.newInternal(Util.java:429)
at mondrian.rolap.CachePool.checkRegistered(CachePool.java:461)
at mondrian.rolap.CachePool.validate(CachePool.java:575)
at mondrian.rolap.CachePool.tick(CachePool.java:179)
at mondrian.rolap.CachePool.register(CachePool.java:209)
at mondrian.rolap.CachePool.register(CachePool.java:194)
at mondrian.rolap.SmartMemberReader.putChildren(SmartMemberReader.java:336)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:502)
... 32 more
caused by
mondrian.resource.ChainableRuntimeException: Internal error: while populating member cache with members for level '[Product].[Brand Name]'; sql=[select `product_class`.`product_family` as `c0`, `product_class`.`product_department` as `c1`, `product_class`.`product_category` as `c2`, `product_class`.`product_subcategory` as `c3`, `product`.`brand_name` as `c4` from `product` as `product`, `product_class` as `product_class` where `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` and `product`.`product_class_id` = `product_class`.`product_class_id` group by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category`, `product_class`.`product_subcategory`, `product`.`brand_name` order by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category`, `product_class`.`product_subcategory`, `product`.`brand_name`]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:538)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:442)
at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:126)
at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:143)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:321)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:315)
at mondrian.olap.fun.BuiltinFunTable$73.evaluate(BuiltinFunTable.java:2872)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.olap.fun.SetFunDef.evaluate(SetFunDef.java:56)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:162)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:86)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:242)
at mondrian.test.FoodMartTestCase.runQuery(FoodMartTestCase.java:39)
at mondrian.test.BasicQueryTest.testBigQuery(BasicQueryTest.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: mondrian.resource.ChainableRuntimeException: Internal error: mondrian.rolap.SmartMemberReader$ChildrenList@e29820 is not registered
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
at mondrian.olap.Util.newInternal(Util.java:429)
at mondrian.rolap.CachePool.checkRegistered(CachePool.java:461)
at mondrian.rolap.CachePool.validate(CachePool.java:575)
at mondrian.rolap.CachePool.tick(CachePool.java:179)
at mondrian.rolap.CachePool.register(CachePool.java:209)
at mondrian.rolap.CachePool.register(CachePool.java:194)
at mondrian.rolap.SmartMemberReader.putChildren(SmartMemberReader.java:336)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:502)
... 32 more
caused by
mondrian.resource.ChainableRuntimeException: Internal error: mondrian.rolap.SmartMemberReader$ChildrenList@e29820 is not registered
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:42)
at mondrian.olap.Util.newInternal(Util.java:429)
at mondrian.rolap.CachePool.checkRegistered(CachePool.java:461)
at mondrian.rolap.CachePool.validate(CachePool.java:575)
at mondrian.rolap.CachePool.tick(CachePool.java:179)
at mondrian.rolap.CachePool.register(CachePool.java:209)
at mondrian.rolap.CachePool.register(CachePool.java:194)
at mondrian.rolap.SmartMemberReader.putChildren(SmartMemberReader.java:336)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:502)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:442)
at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:126)
at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:143)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:321)
at mondrian.olap.fun.FunUtil.addMembers(FunUtil.java:315)
at mondrian.olap.fun.BuiltinFunTable$73.evaluate(BuiltinFunTable.java:2872)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.olap.fun.SetFunDef.evaluate(SetFunDef.java:56)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:129)
at mondrian.olap.FunCall.evaluate(FunCall.java:239)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:162)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:86)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:242)
at mondrian.test.FoodMartTestCase.runQuery(FoodMartTestCase.java:39)
at mondrian.test.BasicQueryTest.testBigQuery(BasicQueryTest.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

jhyde
09-01-2003, 09:05 PM
This is a bug caused by a race condition. I'm guessing you have a multi-CPU machine.