Thanks for the reporting; This is a cache issue in v1.5.1; the fix will be
released in next version.
2016-04-26 13:43 GMT+08:00 Roy <aqinnxuk...@163.com>:
> of course, bulid cube successful ,choose insight tab display not result
> and refresh again. not working. finally click reload metadata. Below is
> detail logs:
>
> 2016-04-26 13:32:48,174 DEBUG [http-bio-7070-exec-9]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:32:48,175 DEBUG [http-bio-7070-exec-9]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:32:48,182 DEBUG [http-bio-7070-exec-9]
> service.QueryService:321 : done column metas
> 2016-04-26 13:32:56,245 DEBUG [http-bio-7070-exec-4]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:32:56,247 DEBUG [http-bio-7070-exec-4]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:32:56,260 DEBUG [http-bio-7070-exec-4]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:03,083 DEBUG [http-bio-7070-exec-10]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:03,085 DEBUG [http-bio-7070-exec-10]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:03,095 DEBUG [http-bio-7070-exec-10]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:07,162 DEBUG [http-bio-7070-exec-8]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:07,163 DEBUG [http-bio-7070-exec-8]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:07,170 DEBUG [http-bio-7070-exec-8]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:07,966 DEBUG [http-bio-7070-exec-5]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:12,125 INFO [pool-4-thread-1]
> threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running,
> 0 ready, 43 others
> 2016-04-26 13:33:14,516 DEBUG [http-bio-7070-exec-2]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:19,512 DEBUG [http-bio-7070-exec-1]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:19,539 DEBUG [http-bio-7070-exec-7]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:19,540 DEBUG [http-bio-7070-exec-7]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:19,549 DEBUG [http-bio-7070-exec-7]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:37,470 DEBUG [http-bio-7070-exec-10]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:37,485 DEBUG [http-bio-7070-exec-8]
> service.AdminService:90 : Get Kylin Runtime Config
> 2016-04-26 13:33:37,489 DEBUG [http-bio-7070-exec-2]
> service.AdminService:52 : Get Kylin Runtime environment
> 2016-04-26 13:33:39,408 INFO [http-bio-7070-exec-1]
> controller.CacheController:64 : wipe cache type: ALL event:UPDATE name:all
> 2016-04-26 13:33:39,409 INFO [http-bio-7070-exec-1]
> service.CacheService:171 : rebuild cache type: ALL name:all
> 2016-04-26 13:33:39,409 WARN [http-bio-7070-exec-1]
> service.CacheService:116 : cleaning all storage cache
> 2016-04-26 13:33:39,410 INFO [http-bio-7070-exec-1]
> service.CacheService:134 : removeAllOLAPDataSources is called.
> 2016-04-26 13:33:44,510 DEBUG [http-bio-7070-exec-9]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:44,510 INFO [http-bio-7070-exec-7] cube.CubeManager:124
> : Initializing CubeManager with config kylin_metadata@hbase
> 2016-04-26 13:33:44,511 INFO [http-bio-7070-exec-7]
> hbase.HBaseConnection:139 : connection is null or closed, creating a new one
> 2016-04-26 13:33:44,630 DEBUG [http-bio-7070-exec-7] cube.CubeManager:811
> : Loading Cube from folder kylin_metadata(key='/cube')@kylin_metadata@hbase
> 2016-04-26 13:33:44,632 INFO [http-bio-7070-exec-7]
> cube.CubeDescManager:91 : Initializing CubeDescManager with config
> kylin_metadata@hbase
> 2016-04-26 13:33:44,633 INFO [http-bio-7070-exec-7]
> cube.CubeDescManager:197 : Reloading Cube Metadata from folder
> kylin_metadata(key='/cube_desc')@kylin_metadata@hbase
> 2016-04-26 13:33:44,656 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:315 : Reloading SourceTable from folder
> kylin_metadata(key='/table')@kylin_metadata@hbase
> 2016-04-26 13:33:44,753 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:324 : Loaded 13 SourceTable(s)
> 2016-04-26 13:33:44,753 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:256 : Reloading SourceTable exd info from folder
> kylin_metadata(key='/table_exd')@kylin_metadata@hbase
> 2016-04-26 13:33:44,809 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:265 : Loaded 10 SourceTable EXD(s)
> 2016-04-26 13:33:44,809 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:429 : Reloading DataModel from folder
> kylin_metadata(key='/model_desc')@kylin_metadata@hbase
> 2016-04-26 13:33:44,840 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:443 : Loaded 5 DataModel(s)
> 2016-04-26 13:33:44,841 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:301 : Reloading ExternalFilter from folder
> kylin_metadata(key='/ext_filter')@kylin_metadata@hbase
> 2016-04-26 13:33:44,845 DEBUG [http-bio-7070-exec-7]
> metadata.MetadataManager:310 : Loaded 0 SourceTable(s)
> 2016-04-26 13:33:44,857 DEBUG [http-bio-7070-exec-7]
> cube.CubeDescManager:222 : Loaded 5 Cube(s)
> 2016-04-26 13:33:44,858 DEBUG [http-bio-7070-exec-7] cube.CubeManager:846
> : Reloaded new cube: DCMemberOrder_Cube with reference
> beingCUBE[name=DCMemberOrder_Cube] having 1 segments:KYLIN_NNB02YZR7D
> 2016-04-26 13:33:44,860 DEBUG [http-bio-7070-exec-7] cube.CubeManager:846
> : Reloaded new cube: DCMemberOrder_Cube_FR with reference
> beingCUBE[name=DCMemberOrder_Cube_FR] having 1 segments:KYLIN_NYFXRB59D4
> 2016-04-26 13:33:44,862 DEBUG [http-bio-7070-exec-7] cube.CubeManager:846
> : Reloaded new cube: Me_Test_Cube with reference
> beingCUBE[name=Me_Test_Cube] having 1 segments:KYLIN_3CG1RSZRC2
> 2016-04-26 13:33:44,864 DEBUG [http-bio-7070-exec-7] cube.CubeManager:846
> : Reloaded new cube: Member_Cube with reference beingCUBE[name=Member_Cube]
> having 1 segments:KYLIN_XF5Q7BSLIL
> 2016-04-26 13:33:44,867 DEBUG [http-bio-7070-exec-7] cube.CubeManager:846
> : Reloaded new cube: kylin_sales_cube with reference
> beingCUBE[name=kylin_sales_cube] having 1 segments:KYLIN_3DMDD1WIXN
> 2016-04-26 13:33:44,867 DEBUG [http-bio-7070-exec-7] cube.CubeManager:817
> : Loaded 5 Cube(s)
> 2016-04-26 13:33:44,867 DEBUG [http-bio-7070-exec-7]
> service.CacheService:144 : Creating a new data source, OLAP data source
> pointing to kylin_metadata@hbase
> 2016-04-26 13:33:44,868 INFO [http-bio-7070-exec-7]
> project.ProjectManager:88 : Initializing ProjectManager with metadata url
> kylin_metadata@hbase
> 2016-04-26 13:33:44,885 DEBUG [http-bio-7070-exec-7]
> project.ProjectManager:104 : Loading Project from folder
> kylin_metadata(key='/project')@kylin_metadata@hbase
> 2016-04-26 13:33:44,891 DEBUG [http-bio-7070-exec-7]
> project.ProjectManager:109 : Loaded 4 Project(s)
> 2016-04-26 13:33:44,891 INFO [http-bio-7070-exec-7]
> project.ProjectL2Cache:172 : Loading L2 project cache for MEMBER_CUBE
> 2016-04-26 13:33:44,891 INFO [http-bio-7070-exec-7]
> realization.RealizationRegistry:75 : Initializing RealizationRegistry with
> metadata url kylin_metadata@hbase
> 2016-04-26 13:33:45,647 INFO [http-bio-7070-exec-7]
> reflections.Reflections:224 : Reflections took 727 ms to scan 18 urls,
> producing 274 keys and 2131 values
> 2016-04-26 13:33:45,648 INFO [http-bio-7070-exec-7]
> hybrid.HybridManager:82 : Initializing HybridManager with config
> kylin_metadata@hbase
> 2016-04-26 13:33:45,653 DEBUG [http-bio-7070-exec-7]
> hybrid.HybridManager:92 : Loading Hybrid from folder
> kylin_metadata(key='/hybrid')@kylin_metadata@hbase
> 2016-04-26 13:33:45,654 DEBUG [http-bio-7070-exec-7]
> hybrid.HybridManager:98 : Loaded 0 Hybrid(s)
> 2016-04-26 13:33:45,654 INFO [http-bio-7070-exec-7]
> invertedindex.IIManager:101 : Initializing IIManager with config
> kylin_metadata@hbase
> 2016-04-26 13:33:45,659 DEBUG [http-bio-7070-exec-7]
> invertedindex.IIManager:226 : Loading II from folder
> kylin_metadata(key='/invertedindex')@kylin_metadata@hbase
> 2016-04-26 13:33:45,659 DEBUG [http-bio-7070-exec-7]
> invertedindex.IIManager:232 : Loaded 0 II(s)
> 2016-04-26 13:33:45,659 INFO [http-bio-7070-exec-7]
> realization.RealizationRegistry:103 : RealizationRegistry is
> {INVERTED_INDEX=org.apache.kylin.invertedindex.IIManager@6b9606d2,
> HYBRID=org.apache.kylin.storage.hybrid.HybridManager@4699fc2c,
> CUBE=org.apache.kylin.cube.CubeManager@277ad0ea}
> 2016-04-26 13:33:45,661 INFO [http-bio-7070-exec-7]
> schema.OLAPSchemaFactory:135 : Schema json:{
> "version": "1.0",
> "defaultSchema": "DIMDATA",
> "schemas": [
> {
> "type": "custom",
> "name": "DB_KYLIN",
> "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory",
> "operand": {
> "project": "MEMBER_CUBE"
> },
> "functions": [
> {
> name: 'MASSIN',
> className: 'org.apache.kylin.query.udf.MassInUDF'
> }
> ]
> }
> ,
> {
> "type": "custom",
> "name": "DIMDATA",
> "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory",
> "operand": {
> "project": "MEMBER_CUBE"
> },
> "functions": [
> {
> name: 'MASSIN',
> className: 'org.apache.kylin.query.udf.MassInUDF'
> }
> ]
> }
> ]
> }
> 2016-04-26 13:33:45,661 DEBUG [http-bio-7070-exec-7]
> service.CacheService:149 : The new temp olap json is :{
> "version": "1.0",
> "defaultSchema": "DIMDATA",
> "schemas": [
> {
> "type": "custom",
> "name": "DB_KYLIN",
> "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory",
> "operand": {
> "project": "MEMBER_CUBE"
> },
> "functions": [
> {
> name: 'MASSIN',
> className: 'org.apache.kylin.query.udf.MassInUDF'
> }
> ]
> }
> ,
> {
> "type": "custom",
> "name": "DIMDATA",
> "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory",
> "operand": {
> "project": "MEMBER_CUBE"
> },
> "functions": [
> {
> name: 'MASSIN',
> className: 'org.apache.kylin.query.udf.MassInUDF'
> }
> ]
> }
> ]
> }
>
> 2016-04-26 13:33:45,682 DEBUG [http-bio-7070-exec-7]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:45,683 INFO [http-bio-7070-exec-7]
> project.ProjectL2Cache:172 : Loading L2 project cache for Member_Cube
> 2016-04-26 13:33:45,685 DEBUG [http-bio-7070-exec-7]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:45,695 DEBUG [http-bio-7070-exec-7]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:54,556 DEBUG [http-bio-7070-exec-9]
> service.AdminService:90 : Get Kylin Runtime Config
> 2016-04-26 13:33:54,556 DEBUG [http-bio-7070-exec-10]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:54,671 DEBUG [http-bio-7070-exec-1]
> controller.ProjectController:97 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:54,758 DEBUG [http-bio-7070-exec-9]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:54,761 DEBUG [http-bio-7070-exec-9]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:54,774 DEBUG [http-bio-7070-exec-9]
> service.QueryService:321 : done column metas
> 2016-04-26 13:33:56,732 DEBUG [http-bio-7070-exec-6]
> service.AdminService:90 : Get Kylin Runtime Config
> 2016-04-26 13:33:56,732 DEBUG [http-bio-7070-exec-3]
> controller.UserController:64 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:56,826 DEBUG [http-bio-7070-exec-8]
> controller.ProjectController:97 : authentication.getPrincipal() is
> org.springframework.security.core.userdetails.User@3b40b2f: Username:
> ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true;
> credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities:
> ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER
> 2016-04-26 13:33:56,891 DEBUG [http-bio-7070-exec-1]
> service.QueryService:289 : getting table metas
> 2016-04-26 13:33:56,893 DEBUG [http-bio-7070-exec-1]
> service.QueryService:307 : getting column metas
> 2016-04-26 13:33:56,905 DEBUG [http-bio-7070-exec-1]
> service.QueryService:321 : done column metas
> 2016-04-26 13:34:12,127 INFO [pool-4-thread-1]
> threadpool.DefaultScheduler:106 : Job Fetcher: 0 running, 0 actual running,
> 0 ready, 43 others
>
>
>
>
>
>
> At 2016-04-25 17:00:28, "Roger Shi" <rogershijich...@hotmail.com> wrote:
> >Hi Roy,
> >
> >Would you please provide all related logs fetched from
> >$KYLIN_HOME/logs/kylin.log? It will help in reproducing the issue and
> >finding the root cause.
> >
> >--
> >View this message in context:
> http://apache-kylin.74782.x6.nabble.com/No-detail-message-when-Error-tp4152p4260.html
> >Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Best regards,
Shaofeng Shi
