You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by jerome <je...@gmail.com> on 2015/12/02 06:28:22 UTC
Extract Fact Table Distinct Columns Error
Hi, I find a error at the second Step when I execute the Cube job . But I
don't know how to solve the error .
There are some logs at second step :
<http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
and there are also some errors at the tomcat logs :
<http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png>
Can you help me ? Thx !
--
View this message in context: http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
Sent from the Apache Kylin (Incubating) mailing list archive at Nabble.com.
Re: Extract Fact Table Distinct Columns Error
Posted by 周千昊 <qh...@apache.org>.
What hongbin tries to say is that the error shows only why kylin fails to
send notification when the job fails.
However you should dig into why the job fails, and the step should be a MR
job which you can see the error log through Application Master UI.
Jerome liu <je...@gmail.com>于2015年12月2日周三 下午8:13写道：
> I'm so sorry , and I coundn't understand what you mean .
> all of error logs with tomcat are print , and the step logs don't tell me
> where the errors are happen , and how to fix location 。
> Now , i execute the jobs again , the same errors appear 。
>
> 2015-12-02 15:39 GMT+08:00 hongbin ma <ma...@apache.org>:
>
> > this is not the complete log, the exception is thrown because because it
> > failed to send email notification(
> > https://issues.apache.org/jira/browse/KYLIN-1106, it is fixed later than
> > 1.1.1).
> >
> > However it is the not the root cause, you should seek prior to this
> snippet
> > to find the real exception that caused Kylin attempt to send email
> > notification
> >
> > On Wed, Dec 2, 2015 at 3:21 PM, Jerome liu <je...@gmail.com>
> > wrote:
> >
> > > Sorry， tomcat log looks like this ：
> > >
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,404][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > > - Saving resource
> /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae-01
> > > (Store kylin_metadata@hbase)
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,410][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> > > - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae-01 from RUNNING to ERROR
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,438][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > > (Store kylin_metadata@hbase)
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,464][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > > (Store kylin_metadata@hbase)
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,480][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > > (Store kylin_metadata@hbase)
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,484][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> > > - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae from RUNNING to ERROR
> > > [pool-5-thread-7]:[2015-12-02
> > >
> > >
> >
> 09:56:35,503][ERROR][org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:221)]
> > > -
> > > java.lang.NullPointerException
> > > at java.util.regex.Matcher.appendReplacement(Matcher.java:758)
> > > at java.util.regex.Matcher.replaceAll(Matcher.java:906)
> > > at java.lang.String.replaceAll(String.java:2162)
> > > at
> > >
> >
> org.apache.kylin.job.cube.CubingJob.formatNotifications(CubingJob.java:90)
> > > at
> > >
> > >
> >
> org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:211)
> > >
> > > at
> > >
> > >
> >
> org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:101)
> > >
> > > at
> > >
> org.apache.kylin.job.cube.CubingJob.onExecuteFinished(CubingJob.java:122)
> > > at
> > >
> > >
> >
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
> > >
> > > at
> > >
> > >
> >
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
> > >
> > > at
> > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > >
> > > at
> > >
> > >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > >
> > > at java.lang.Thread.run(Thread.java:745)
> > > [pool-4-thread-1]:[2015-12-02
> > >
> > >
> >
> 09:56:35,611][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> > > - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> > > [pool-4-thread-1]:[2015-12-02
> > >
> > >
> >
> 09:56:51,750][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> > > - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> > > [http-bio-7070-exec-3]:[2015-12-02
> > >
> > >
> >
> 09:56:59,270][DEBUG][org.apache.kylin.rest.service.AdminService.getConfigAsString(AdminService.java:90)]
> > > - Get Kylin Runtime Config
> > > [http-bio-7070-exec-2]:[2015-12-02
> > >
> > >
> >
> 09:56:59,274][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> > >
> > >
> >
> 17:56:59;URI=/kylin/api/user/authentication;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> > >
> > > [http-bio-7070-exec-5]:[2015-12-02
> > >
> > >
> >
> 09:56:59,275][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> > >
> > >
> >
> 17:56:59;URI=/kylin/api/projects;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> > >
> > > [http-bio-7070-exec-3]:[2015-12-02
> > >
> > >
> >
> 09:56:59,278][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> > >
> > >
> >
> 17:56:59;URI=/kylin/api/admin/config;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> > >
> > > [http-bio-7070-exec-3]:[2015-12-02
> > >
> > >
> >
> 09:56:59,475][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> > >
> > >
> >
> 17:56:59;URI=/kylin/api/jobs;METHOD=GET;QUERY_STRING=limit=15&offset=0&projectName=chuizisanguo;PAYLOAD=;RESP_STATUS=200;
> > >
> > >
> > > --------------------------------------------------
> > > Best regards!
> > >
> > > 2015-12-02 15:00 GMT+08:00 hongbin ma <ma...@apache.org>:
> > >
> > > > cannot see tomcat log
> > > >
> > > > On Wed, Dec 2, 2015 at 1:28 PM, jerome <je...@gmail.com>
> > wrote:
> > > >
> > > > > Hi, I find a error at the second Step when I execute the Cube job
> .
> > > But
> > > > I
> > > > > don't know how to solve the error .
> > > > > There are some logs at second step :
> > > > >
> > > > > <
> > http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
> > > > > and there are also some errors at the tomcat logs :
> > > > >
> > > > > <
> > http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png
> > > >
> > > > >
> > > > >
> > > > >
> > > > > Can you help me ? Thx !
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > View this message in context:
> > > > >
> > > >
> > >
> >
> http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
> > > > > Sent from the Apache Kylin (Incubating) mailing list archive at
> > > > Nabble.com.
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Regards,
> > > >
> > > > *Bin Mahone | 马洪宾*
> > > > Apache Kylin: http://kylin.io
> > > > Github: https://github.com/binmahone
> > > >
> > >
> > >
> > >
> > > --
> > > Welcome to jerome.liuheng@gmail.com ！
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
> > Apache Kylin: http://kylin.io
> > Github: https://github.com/binmahone
> >
>
>
>
> --
> Welcome to jerome.liuheng@gmail.com ！
>
Re: Extract Fact Table Distinct Columns Error
Posted by Jerome liu <je...@gmail.com>.
I'm so sorry , and I coundn't understand what you mean .
all of error logs with tomcat are print , and the step logs don't tell me
where the errors are happen , and how to fix location 。
Now , i execute the jobs again , the same errors appear 。
2015-12-02 15:39 GMT+08:00 hongbin ma <ma...@apache.org>:
> this is not the complete log, the exception is thrown because because it
> failed to send email notification(
> https://issues.apache.org/jira/browse/KYLIN-1106, it is fixed later than
> 1.1.1).
>
> However it is the not the root cause, you should seek prior to this snippet
> to find the real exception that caused Kylin attempt to send email
> notification
>
> On Wed, Dec 2, 2015 at 3:21 PM, Jerome liu <je...@gmail.com>
> wrote:
>
> > Sorry， tomcat log looks like this ：
> >
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,404][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae-01
> > (Store kylin_metadata@hbase)
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,410][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> > - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae-01 from RUNNING to ERROR
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,438][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > (Store kylin_metadata@hbase)
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,464][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > (Store kylin_metadata@hbase)
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,480][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> > - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> > (Store kylin_metadata@hbase)
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,484][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> > - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae from RUNNING to ERROR
> > [pool-5-thread-7]:[2015-12-02
> >
> >
> 09:56:35,503][ERROR][org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:221)]
> > -
> > java.lang.NullPointerException
> > at java.util.regex.Matcher.appendReplacement(Matcher.java:758)
> > at java.util.regex.Matcher.replaceAll(Matcher.java:906)
> > at java.lang.String.replaceAll(String.java:2162)
> > at
> >
> org.apache.kylin.job.cube.CubingJob.formatNotifications(CubingJob.java:90)
> > at
> >
> >
> org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:211)
> >
> > at
> >
> >
> org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:101)
> >
> > at
> > org.apache.kylin.job.cube.CubingJob.onExecuteFinished(CubingJob.java:122)
> > at
> >
> >
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
> >
> > at
> >
> >
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
> >
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> >
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> >
> > at java.lang.Thread.run(Thread.java:745)
> > [pool-4-thread-1]:[2015-12-02
> >
> >
> 09:56:35,611][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> > - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> > [pool-4-thread-1]:[2015-12-02
> >
> >
> 09:56:51,750][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> > - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> > [http-bio-7070-exec-3]:[2015-12-02
> >
> >
> 09:56:59,270][DEBUG][org.apache.kylin.rest.service.AdminService.getConfigAsString(AdminService.java:90)]
> > - Get Kylin Runtime Config
> > [http-bio-7070-exec-2]:[2015-12-02
> >
> >
> 09:56:59,274][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> >
> >
> 17:56:59;URI=/kylin/api/user/authentication;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> >
> > [http-bio-7070-exec-5]:[2015-12-02
> >
> >
> 09:56:59,275][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> >
> >
> 17:56:59;URI=/kylin/api/projects;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> >
> > [http-bio-7070-exec-3]:[2015-12-02
> >
> >
> 09:56:59,278][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> >
> >
> 17:56:59;URI=/kylin/api/admin/config;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
> >
> > [http-bio-7070-exec-3]:[2015-12-02
> >
> >
> 09:56:59,475][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> > - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
> >
> >
> 17:56:59;URI=/kylin/api/jobs;METHOD=GET;QUERY_STRING=limit=15&offset=0&projectName=chuizisanguo;PAYLOAD=;RESP_STATUS=200;
> >
> >
> > --------------------------------------------------
> > Best regards!
> >
> > 2015-12-02 15:00 GMT+08:00 hongbin ma <ma...@apache.org>:
> >
> > > cannot see tomcat log
> > >
> > > On Wed, Dec 2, 2015 at 1:28 PM, jerome <je...@gmail.com>
> wrote:
> > >
> > > > Hi, I find a error at the second Step when I execute the Cube job .
> > But
> > > I
> > > > don't know how to solve the error .
> > > > There are some logs at second step :
> > > >
> > > > <
> http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
> > > > and there are also some errors at the tomcat logs :
> > > >
> > > > <
> http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png
> > >
> > > >
> > > >
> > > >
> > > > Can you help me ? Thx !
> > > >
> > > >
> > > >
> > > > --
> > > > View this message in context:
> > > >
> > >
> >
> http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
> > > > Sent from the Apache Kylin (Incubating) mailing list archive at
> > > Nabble.com.
> > > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > >
> > > *Bin Mahone | 马洪宾*
> > > Apache Kylin: http://kylin.io
> > > Github: https://github.com/binmahone
> > >
> >
> >
> >
> > --
> > Welcome to jerome.liuheng@gmail.com ！
> >
>
>
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*
> Apache Kylin: http://kylin.io
> Github: https://github.com/binmahone
>
--
Welcome to jerome.liuheng@gmail.com ！
Re: Extract Fact Table Distinct Columns Error
Posted by hongbin ma <ma...@apache.org>.
this is not the complete log, the exception is thrown because because it
failed to send email notification(
https://issues.apache.org/jira/browse/KYLIN-1106, it is fixed later than
1.1.1).
However it is the not the root cause, you should seek prior to this snippet
to find the real exception that caused Kylin attempt to send email
notification
On Wed, Dec 2, 2015 at 3:21 PM, Jerome liu <je...@gmail.com> wrote:
> Sorry， tomcat log looks like this ：
>
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,404][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae-01
> (Store kylin_metadata@hbase)
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,410][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae-01 from RUNNING to ERROR
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,438][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> (Store kylin_metadata@hbase)
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,464][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> (Store kylin_metadata@hbase)
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,480][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
> - Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
> (Store kylin_metadata@hbase)
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,484][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
> - job id:527c5afa-bb2d-4410-b53c-917739bbb1ae from RUNNING to ERROR
> [pool-5-thread-7]:[2015-12-02
>
> 09:56:35,503][ERROR][org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:221)]
> -
> java.lang.NullPointerException
> at java.util.regex.Matcher.appendReplacement(Matcher.java:758)
> at java.util.regex.Matcher.replaceAll(Matcher.java:906)
> at java.lang.String.replaceAll(String.java:2162)
> at
> org.apache.kylin.job.cube.CubingJob.formatNotifications(CubingJob.java:90)
> at
>
> org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:211)
>
> at
>
> org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:101)
>
> at
> org.apache.kylin.job.cube.CubingJob.onExecuteFinished(CubingJob.java:122)
> at
>
> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
>
> at
>
> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
>
> at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>
> at java.lang.Thread.run(Thread.java:745)
> [pool-4-thread-1]:[2015-12-02
>
> 09:56:35,611][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> [pool-4-thread-1]:[2015-12-02
>
> 09:56:51,750][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> - Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
> [http-bio-7070-exec-3]:[2015-12-02
>
> 09:56:59,270][DEBUG][org.apache.kylin.rest.service.AdminService.getConfigAsString(AdminService.java:90)]
> - Get Kylin Runtime Config
> [http-bio-7070-exec-2]:[2015-12-02
>
> 09:56:59,274][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
>
> 17:56:59;URI=/kylin/api/user/authentication;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
>
> [http-bio-7070-exec-5]:[2015-12-02
>
> 09:56:59,275][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
>
> 17:56:59;URI=/kylin/api/projects;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
>
> [http-bio-7070-exec-3]:[2015-12-02
>
> 09:56:59,278][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
>
> 17:56:59;URI=/kylin/api/admin/config;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
>
> [http-bio-7070-exec-3]:[2015-12-02
>
> 09:56:59,475][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> - REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
>
> 17:56:59;URI=/kylin/api/jobs;METHOD=GET;QUERY_STRING=limit=15&offset=0&projectName=chuizisanguo;PAYLOAD=;RESP_STATUS=200;
>
>
> --------------------------------------------------
> Best regards!
>
> 2015-12-02 15:00 GMT+08:00 hongbin ma <ma...@apache.org>:
>
> > cannot see tomcat log
> >
> > On Wed, Dec 2, 2015 at 1:28 PM, jerome <je...@gmail.com> wrote:
> >
> > > Hi, I find a error at the second Step when I execute the Cube job .
> But
> > I
> > > don't know how to solve the error .
> > > There are some logs at second step :
> > >
> > > <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
> > > and there are also some errors at the tomcat logs :
> > >
> > > <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png
> >
> > >
> > >
> > >
> > > Can you help me ? Thx !
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > >
> >
> http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
> > > Sent from the Apache Kylin (Incubating) mailing list archive at
> > Nabble.com.
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
> > Apache Kylin: http://kylin.io
> > Github: https://github.com/binmahone
> >
>
>
>
> --
> Welcome to jerome.liuheng@gmail.com ！
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
Re: Extract Fact Table Distinct Columns Error
Posted by Jerome liu <je...@gmail.com>.
Sorry， tomcat log looks like this ：
[pool-5-thread-7]:[2015-12-02
09:56:35,404][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
- Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae-01
(Store kylin_metadata@hbase)
[pool-5-thread-7]:[2015-12-02
09:56:35,410][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
- job id:527c5afa-bb2d-4410-b53c-917739bbb1ae-01 from RUNNING to ERROR
[pool-5-thread-7]:[2015-12-02
09:56:35,438][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
- Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
(Store kylin_metadata@hbase)
[pool-5-thread-7]:[2015-12-02
09:56:35,464][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
- Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
(Store kylin_metadata@hbase)
[pool-5-thread-7]:[2015-12-02
09:56:35,480][DEBUG][org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:195)]
- Saving resource /execute_output/527c5afa-bb2d-4410-b53c-917739bbb1ae
(Store kylin_metadata@hbase)
[pool-5-thread-7]:[2015-12-02
09:56:35,484][INFO][org.apache.kylin.job.manager.ExecutableManager.updateJobOutput(ExecutableManager.java:241)]
- job id:527c5afa-bb2d-4410-b53c-917739bbb1ae from RUNNING to ERROR
[pool-5-thread-7]:[2015-12-02
09:56:35,503][ERROR][org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:221)]
-
java.lang.NullPointerException
at java.util.regex.Matcher.appendReplacement(Matcher.java:758)
at java.util.regex.Matcher.replaceAll(Matcher.java:906)
at java.lang.String.replaceAll(String.java:2162)
at
org.apache.kylin.job.cube.CubingJob.formatNotifications(CubingJob.java:90)
at
org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:211)
at
org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:101)
at
org.apache.kylin.job.cube.CubingJob.onExecuteFinished(CubingJob.java:122)
at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:113)
at
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:130)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
[pool-4-thread-1]:[2015-12-02
09:56:35,611][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
[pool-4-thread-1]:[2015-12-02
09:56:51,750][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 12 others
[http-bio-7070-exec-3]:[2015-12-02
09:56:59,270][DEBUG][org.apache.kylin.rest.service.AdminService.getConfigAsString(AdminService.java:90)]
- Get Kylin Runtime Config
[http-bio-7070-exec-2]:[2015-12-02
09:56:59,274][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
- REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
17:56:59;URI=/kylin/api/user/authentication;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
[http-bio-7070-exec-5]:[2015-12-02
09:56:59,275][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
- REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
17:56:59;URI=/kylin/api/projects;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
[http-bio-7070-exec-3]:[2015-12-02
09:56:59,278][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
- REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
17:56:59;URI=/kylin/api/admin/config;METHOD=GET;QUERY_STRING=null;PAYLOAD=;RESP_STATUS=200;
[http-bio-7070-exec-3]:[2015-12-02
09:56:59,475][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
- REQUEST: REQUESTER=ADMIN;REQ_TIME=GMT-08:00 2015-12-01
17:56:59;URI=/kylin/api/jobs;METHOD=GET;QUERY_STRING=limit=15&offset=0&projectName=chuizisanguo;PAYLOAD=;RESP_STATUS=200;
--------------------------------------------------
Best regards!
2015-12-02 15:00 GMT+08:00 hongbin ma <ma...@apache.org>:
> cannot see tomcat log
>
> On Wed, Dec 2, 2015 at 1:28 PM, jerome <je...@gmail.com> wrote:
>
> > Hi, I find a error at the second Step when I execute the Cube job . But
> I
> > don't know how to solve the error .
> > There are some logs at second step :
> >
> > <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
> > and there are also some errors at the tomcat logs :
> >
> > <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png>
> >
> >
> >
> > Can you help me ? Thx !
> >
> >
> >
> > --
> > View this message in context:
> >
> http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
> > Sent from the Apache Kylin (Incubating) mailing list archive at
> Nabble.com.
> >
>
>
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*
> Apache Kylin: http://kylin.io
> Github: https://github.com/binmahone
>
--
Welcome to jerome.liuheng@gmail.com ！
Re: Extract Fact Table Distinct Columns Error
Posted by hongbin ma <ma...@apache.org>.
cannot see tomcat log
On Wed, Dec 2, 2015 at 1:28 PM, jerome <je...@gmail.com> wrote:
> Hi, I find a error at the second Step when I execute the Cube job . But I
> don't know how to solve the error .
> There are some logs at second step :
>
> <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/E7.png>
> and there are also some errors at the tomcat logs :
>
> <http://apache-kylin-incubating.74782.x6.nabble.com/file/n2635/296.png>
>
>
>
> Can you help me ? Thx !
>
>
>
> --
> View this message in context:
> http://apache-kylin-incubating.74782.x6.nabble.com/Extract-Fact-Table-Distinct-Columns-Error-tp2635.html
> Sent from the Apache Kylin (Incubating) mailing list archive at Nabble.com.
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone