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 2021/03/01 06:36:56 UTC
[GitHub] [shardingsphere-elasticjob-ui] little-yellow opened a new issue #110: Two tables needed are not created in mysql database
little-yellow opened a new issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110
## Bug Report
### Which version of ElasticJob did you use?
apache-shardingsphere-elasticjob-3.0.0-RC1-lite-ui-bin
### Expected behavior
Founction in Job history available.
### Actual behavior
[ERROR] 14:11:44.745 [http-nio-8088-exec-8] o.a.s.e.l.u.w.h.RestExceptionHandler - Table 'demo.job_execution_log' doesn't exist
Two tables needed are not created in my demo database.
### Steps to reproduce the behavior.
windows10 + elasticjob-lite-3.0.0-RC1(core & ui) + mysql5.7.24-log MySQL Community Server (GPL) + apache-zookeeper-3.6.2-bin + java 1.8.0_281 + mysql-connector-java-8.0.23
Both registry center and event trace data source are connected.
At first I think it may be caused by connector, so I try to change mysql-connector to mysql-connector-java-5.1.49, but this time I even can't add a data source.
----------------------------------------------------------------
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-ui] little-yellow edited a comment on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
little-yellow edited a comment on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-790553951
Thank for your guilding, but there is still a problem.
If I don't use Druid, things all go well.
----------------------------------------------------------------
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-ui] tanglinyan removed a comment on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
tanglinyan removed a comment on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-891445138
应用版本：apache-shardingsphere-elasticjob-3.0.0-lite-ui-bin
问题：Job history->Job trace和 Job history->History status 无法使用，缺失job_execution_log、job_status_trace_log表，使用的是默认提供的org.postgresql.Driver，postgresql 11版本
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob-ui] little-yellow commented on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
little-yellow commented on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-790553951
Thank for your guilding, but there is still a problem.
----------------------------------------------------------------
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-ui] TeslaCN commented on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-789683512
Hi @little-yellow
`com.mysql.cj.jdbc.Driver` is a new Driver class in mysql-connector-java-8.x.
The UI won't create the tables you mentioned. Those tables will be created when running a job with TracingConfiguration.
----------------------------------------------------------------
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-ui] tanglinyan commented on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
tanglinyan commented on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-891445138
应用版本：apache-shardingsphere-elasticjob-3.0.0-lite-ui-bin
问题：Job history->Job trace和 Job history->History status 无法使用，缺失job_execution_log、job_status_trace_log表，使用的是默认提供的org.postgresql.Driver，postgresql 11版本
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere-elasticjob-ui] little-yellow commented on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
little-yellow commented on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-790465406
So how to config a job to be traced? I've already set monitorExecution as true, still nothing happens.
----------------------------------------------------------------
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-ui] TeslaCN commented on issue #110: Two tables needed are not created in mysql database
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #110:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/110#issuecomment-790482390
Please refer to https://shardingsphere.apache.org/elasticjob/current/en/user-manual/elasticjob-lite/usage/tracing/
----------------------------------------------------------------
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