You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/11/29 09:18:01 UTC
[GitHub] [shardingsphere-elasticjob] johnny2002 opened a new issue #1742: Has no job trace and history
johnny2002 opened a new issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742
## Bug Report
I use elasticjob with spring-boot, datasource config correctly, while I cannot get any job trace data and job history data.
### Which version of ElasticJob did you use?
3.0.0-beta
### Which project did you use? ElasticJob-Lite or ElasticJob-Cloud?
ElasticJob-Lite
### Expected behavior
Can see job trance and history in ui console at: http://localhost:8088/#/history-trace
### Actual behavior
Empty table
### Reason analyze (If you can)
RDB job trace doesn't work.
### Steps to reproduce the behavior.
Use the official example, "elasticjob-example-lite-springboot“, datasource as:
```yaml
spring:
datasource:
driver-class-name: org.h2.Driver
url: jdbc:h2:tcp://localhost/~/test
username: sa
password:
```
### Example codes for reproduce this issue (such as a github link).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735367420
Have you specify the tracing type "RDB"?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] johnny2002 commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735368316
Do you mean this?
```yaml
elasticjob:
streaming.process: true
tracing:
type: RDB
regCenter:
serverLists: localhost:2181
namespace: elasticjob-lite-springboot
maxRetries: 3
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN closed issue #1742: Tracing Module may be unavailable if overwrite is false in 3.0.0-beta
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] Technoboy- commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
Technoboy- commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-738678825
@johnny2002 Could you leave your email here or on your GitHub page?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735403542
I'm not familiar with H2 database. But I tried the SpringBoot example and connecting to my local MySQL instance, tracing module works fine.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735496136
I tried it on the latest master branch.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] johnny2002 commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735495430
> I'm not familiar with H2 database. But I tried the SpringBoot example and connecting to my local MySQL instance, tracing module works fine.
I also tried mysql, unforunately, neigther work.
Which version are you using? 3.0.0-beta or SNAPSHOT?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] johnny2002 commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735633737
> Thanks for your feedback, it is a bug. If the option `overwrite` is false, the extraConfiguration will lost.
Yes, As I tested, only xxxNoticeYyyJob has jobConfig.getExtraConfigurations(), other jobs like SimpleJob or ScriptJob, jobConfig.getExtraConfigurations() return empty set.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] johnny2002 commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735369115
> The current job trace page requires jobName parameter to search job.
1. I can't see any data in database.
2. I can see the sql on console: SELECT t0.id, t0.complete_time, t0.execution_source, t0.failure_cause, t0.hostname, t0.ip, t0.is_success, t0.job_name, t0.sharding_item, t0.start_time, t0.task_id FROM JOB_EXECUTION_LOG t0 WHERE (t0.ip = ? AND t0.job_name = ?) LIMIT ? [params=?, ?, ?]
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735368730
The current job trace page requires jobName parameter to search job.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN edited a comment on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735503100
Thanks for your feedback, it is a bug. If the option `overwrite` is false, the extraConfiguration will lost.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] TeslaCN commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735503100
Thanks for your feedback, it is a bug. If the option `overwrite ` is false, the extraConfiguration will lost.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob] johnny2002 commented on issue #1742: Has no job trace and history
Posted by GitBox <gi...@apache.org>.
johnny2002 commented on issue #1742:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1742#issuecomment-735497119
> I tried it on the latest master branch.
I am using 3.0.0-beta, so, let me try master branch later.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org