[jira] [Created] (KYLIN-3324) NegativeArraySizeException in CreateDictionaryJob$2.getDictionary()

2018-03-28 Thread liyang (JIRA)
liyang created KYLIN-3324:
-

 Summary: NegativeArraySizeException in 
CreateDictionaryJob$2.getDictionary()
 Key: KYLIN-3324
 URL: https://issues.apache.org/jira/browse/KYLIN-3324
 Project: Kylin
  Issue Type: Bug
Reporter: liyang
Assignee: liyang


During cube build, got following exception:
{noformat}
2018-01-31 09:58:14,982 ERROR [Scheduler 311988476 Job 
b931b081-3b44-462b-9bce-e15bf245f1b9-862] common.HadoopShellExecutable : error 
execute HadoopShellExecutable{id=b931b081-3b44-462b-9bce-e15bf245f1b9-03, 
name=Build Dimension Dictionary, state=RUNNING}
java.lang.NegativeArraySizeException
at 
org.apache.hadoop.io.BytesWritable.setCapacity(BytesWritable.java:144)
at org.apache.hadoop.io.BytesWritable.setSize(BytesWritable.java:123)
at org.apache.hadoop.io.BytesWritable.readFields(BytesWritable.java:179)
at 
org.apache.hadoop.io.SequenceFile$Reader.getCurrentValue(SequenceFile.java:2259)
at org.apache.hadoop.io.SequenceFile$Reader.next(SequenceFile.java:2387)
at 
org.apache.kylin.engine.mr.steps.CreateDictionaryJob$2.getDictionary(CreateDictionaryJob.java:87)
at 
org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:62)
at 
org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:49)
at 
org.apache.kylin.engine.mr.steps.CreateDictionaryJob.run(CreateDictionaryJob.java:66)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
at 
org.apache.kylin.engine.mr.common.HadoopShellExecutable.doWork(HadoopShellExecutable.java:62)
at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125)
at 
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:64)
at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:125)
at 
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:156)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745){noformat}
Root cause seems to be 
https://stackoverflow.com/questions/24127304/negativearraysizeexception-when-creating-a-sequencefile-with-large-1gb-bytesw



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (KYLIN-3297) sql在解析>大值 and <小值的时候,kylin出现内存溢出。

2018-03-28 Thread JIRA

[ 
https://issues.apache.org/jira/browse/KYLIN-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16417047#comment-16417047
 ] 

陈家宇 commented on KYLIN-3297:


cube是正常创建的,就是执行select f.plant_code,f.report_business_area,f.orderby,sum(f.a)a,
 case when sum(f.a)=0 then 0 else sum(f.qty)/sum(f.a) end zt from (
 select h.business_area_desc,h.plant_code,
  case when p.report_business_area like '%切大片%' then '切大片'
  else p.report_business_area end report_business_area,
   case when p.report_business_area like '%切大片%' then '00'
  else p.orderby end orderby,
 sum(p.quantity) qty,sum(a)a from pkn_kpi p
 inner join hcm_area h on p.plant_id=h.plant_id
 where 1=1
  and h.business_area_desc='上海'
  and h.plant_code='S1'
  and p.calendar_day>='2018-03-19'
  and p.calendar_day<='2018-03-18'
 and trim(p.report_business_area) is not null
 group by h.business_area_desc,h.plant_code,p.report_business_area,p.orderby
 ) f
 group by f.plant_code,f.report_business_area,f.orderby
 order by orderby

时,kylin出现奔溃的情况,javadump分析的结果也指示这个query出现问题。

以上语句的问题是 and p.calendar_day>='2018-03-19' and p.calendar_day<='2018-03-18'值写反了。

> sql在解析>大值 and <小值的时候,kylin出现内存溢出。
> -
>
> Key: KYLIN-3297
> URL: https://issues.apache.org/jira/browse/KYLIN-3297
> Project: Kylin
>  Issue Type: Bug
>  Components: RDBMS Source
>Affects Versions: v2.2.0
> Environment: oracle linux 6.8  
> cup 8C
> memory 48G
> apache kylin v2.2.0
>Reporter: 陈家宇
>Priority: Major
>
> select f.plant_code,f.report_business_area,f.orderby,sum(f.a)a,
> case when sum(f.a)=0 then 0 else sum(f.qty)/sum(f.a) end zt from (
> select h.business_area_desc,h.plant_code,
>  case when p.report_business_area like '%切大片%' then '切大片'
>  else p.report_business_area end report_business_area,
>   case when p.report_business_area like '%切大片%' then '00'
>  else p.orderby end orderby,
> sum(p.quantity) qty,sum(a)a from pkn_kpi p
> inner join hcm_area h on p.plant_id=h.plant_id
> where 1=1
>  and h.business_area_desc='上海'
>  and h.plant_code='S1'
>  and p.calendar_day>='2018-03-19'
>  and p.calendar_day<='2018-03-18'
> and trim(p.report_business_area) is not null
> group by h.business_area_desc,h.plant_code,p.report_business_area,p.orderby
> ) f
> group by f.plant_code,f.report_business_area,f.orderby
> order by orderby
> 以上的calendar_day条件,顺序输入反了,变成calendar_day>大值 and 
> calendar_day<小值,出现了kylin内存溢出,并且崩溃。正常这种情况是没有数据输出才对。
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (KYLIN-3323) Allow debugTomcat add more arguments

2018-03-28 Thread ASF GitHub Bot (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16417012#comment-16417012
 ] 

ASF GitHub Bot commented on KYLIN-3323:
---

coveralls commented on issue #125: KYLIN-3323 allow debugTomcat add more 
arguments
URL: https://github.com/apache/kylin/pull/125#issuecomment-376798999
 
 
   ## Pull Request Test Coverage Report for [Build 
3093](https://coveralls.io/builds/16218689)
   
   * **0** of **6**  **(0.0%)** changed or added relevant lines in **1** file 
are covered.
   * **5** unchanged lines in **1** file lost coverage.
   * Overall coverage decreased (**-0.004%**) to **23.962%**
   
   ---
   
   |  Changes Missing Coverage | Covered Lines | Changed/Added Lines | % |
   | :-|--||---: |
   | 
[server/src/main/java/org/apache/kylin/rest/DebugTomcat.java](https://coveralls.io/builds/16218689/source?filename=server%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Frest%2FDebugTomcat.java#L108)
 | 0 | 6 | 0.0%
   
   
   |  Files with Coverage Reduction | New Missed Lines | % |
   | :-|--|--: |
   | 
[core-cube/src/main/java/org/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://coveralls.io/builds/16218689/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Finmemcubing%2FMemDiskStore.java#L439)
 | 5 | 77.81% |
   
   
   |  Totals | [![Coverage 
Status](https://coveralls.io/builds/16218689/badge)](https://coveralls.io/builds/16218689)
 |
   | :-- | --: |
   | Change from base [Build 3091](https://coveralls.io/builds/16197822): |  
-0.004% |
   | Covered Lines: | 14341 |
   | Relevant Lines: | 59848 |
   
   ---
   #   - [Coveralls](https://coveralls.io)
   


This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> Allow debugTomcat add more arguments
> 
>
> Key: KYLIN-3323
> URL: https://issues.apache.org/jira/browse/KYLIN-3323
> Project: Kylin
>  Issue Type: Improvement
>Reporter: yongjie zhao
>Assignee: yongjie zhao
>Priority: Minor
> Attachments: Screen Shot 2018-03-28 at 3.05.00 PM.png
>
>
> On current, debugTomcat only accepts port argument. I must edit 
> kylin.property for execute remote command, such as 
> kylin.job.use-remote-cli=true.  This issue can be passed arguments for 
> debugTomcat



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (KYLIN-3323) Allow debugTomcat add more arguments

2018-03-28 Thread ASF GitHub Bot (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16416928#comment-16416928
 ] 

ASF GitHub Bot commented on KYLIN-3323:
---

asfgit commented on issue #125: KYLIN-3323 allow debugTomcat add more arguments
URL: https://github.com/apache/kylin/pull/125#issuecomment-376784840
 
 
   Can one of the admins verify this patch?


This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> Allow debugTomcat add more arguments
> 
>
> Key: KYLIN-3323
> URL: https://issues.apache.org/jira/browse/KYLIN-3323
> Project: Kylin
>  Issue Type: Improvement
>Reporter: yongjie zhao
>Assignee: yongjie zhao
>Priority: Minor
> Attachments: Screen Shot 2018-03-28 at 3.05.00 PM.png
>
>
> On current, debugTomcat only accepts port argument. I must edit 
> kylin.property for execute remote command, such as 
> kylin.job.use-remote-cli=true.  This issue can be passed arguments for 
> debugTomcat



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (KYLIN-3323) Allow debugTomcat add more arguments

2018-03-28 Thread yongjie zhao (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

yongjie zhao updated KYLIN-3323:

Attachment: Screen Shot 2018-03-28 at 3.05.00 PM.png

> Allow debugTomcat add more arguments
> 
>
> Key: KYLIN-3323
> URL: https://issues.apache.org/jira/browse/KYLIN-3323
> Project: Kylin
>  Issue Type: Improvement
>Reporter: yongjie zhao
>Assignee: yongjie zhao
>Priority: Minor
> Attachments: Screen Shot 2018-03-28 at 3.05.00 PM.png
>
>
> On current, debugTomcat only accepts port argument. I must edit 
> kylin.property for execute remote command, such as 
> kylin.job.use-remote-cli=true.  This issue can be passed arguments for 
> debugTomcat



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (KYLIN-3323) Allow debugTomcat add more arguments

2018-03-28 Thread yongjie zhao (JIRA)
yongjie zhao created KYLIN-3323:
---

 Summary: Allow debugTomcat add more arguments
 Key: KYLIN-3323
 URL: https://issues.apache.org/jira/browse/KYLIN-3323
 Project: Kylin
  Issue Type: Improvement
Reporter: yongjie zhao
Assignee: yongjie zhao


On current, debugTomcat only accepts port argument. I must edit kylin.property 
for execute remote command, such as kylin.job.use-remote-cli=true.  This issue 
can be passed arguments for debugTomcat



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)