[
https://issues.apache.org/jira/browse/FALCON-2148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15516328#comment-15516328
]
Praveen Adlakha edited comment on FALCON-2148 at 9/23/16 12:36 PM:
-------------------------------------------------------------------
Hi [~pragya.mittal]
Please verify you Database is running in UTC and not local mode.Please set it
up in UTC mode either in the database level or change the jdbc connection
string to :
jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC
it will work in both the cases i.e. Mysql and Postgres.
I have done the dev testing to verify the same.
{code}
bin/falcon entity -type process -slaAlert -name
ProcessInstanceRerunTest-agregator-53 -start 2016-09-15T09:30Z -end
2016-09-15T09:40Z
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/local/falcon/falcon-0.11-SNAPSHOT/client/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/usr/local/falcon/falcon-0.11-SNAPSHOT/client/lib/falcon-shell-0.11-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
name: ProcessInstanceRerunTest-agregator-53, type: PROCESS, cluster: local,
instanceTime: 2016-09-15T09:30Z, tags: Missed-SLA-High
name: ProcessInstanceRerunTest-agregator-53, type: PROCESS, cluster: local,
instanceTime: 2016-09-15T09:35Z, tags: Missed-SLA-High
Response: default/Success!
Request Id: default/1472698051@qtp-823575379-6 -
6c0a3f23-49b7-4a3d-b58d-2e313e5f507b
bin/falcon entity -type process -slaAlert -name
ProcessInstanceRerunTest-agregator-53 -start 2016-09-15T09:30Z -end
2016-09-15T09:40Z
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/local/falcon/falcon-0.11-SNAPSHOT/client/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/usr/local/falcon/falcon-0.11-SNAPSHOT/client/lib/falcon-shell-0.11-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
No sla miss found!
Response: default/Success!
Request Id: default/2095310001@qtp-823575379-7 -
0e9862c0-ff6c-41db-b0db-06ef3b82c5ba
{code}
Thanks
Praveen
was (Author: praveen):
Hi [~pragya.mittal]
Please verify you Database is running in UTC and not local mode.Please set it
up in UTC mode either in the database level or change the jdbc connection
string to :
jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC
it will work in both the cases i.e. Mysql and Postgres.
Thanks
Praveen
> Entries not removed from sla list when instance succeeds
> --------------------------------------------------------
>
> Key: FALCON-2148
> URL: https://issues.apache.org/jira/browse/FALCON-2148
> Project: Falcon
> Issue Type: Bug
> Components: prism
> Affects Versions: trunk
> Reporter: Pragya Mittal
> Assignee: Praveen Adlakha
>
> Entries corresponding to a process sla should be removed if the process goes
> from WAITING to SUCCEEDED state. The same is not happening.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
