search

apache / shardingsphere-elasticjob-ui

Administrator console of ElasticJob
https://shardingsphere.apache.org/
Apache License 2.0
162 stars 97 forks source link

Two tables needed are not created in mysql database #110

Open little-yellow opened 3 years ago

little-yellow commented 3 years ago

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. image image

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. image image image

TeslaCN commented 3 years ago

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.

little-yellow commented 3 years ago

So how to config a job to be traced? I've already set monitorExecution as true, still nothing happens. image image

TeslaCN commented 3 years ago

Please refer to https://shardingsphere.apache.org/elasticjob/current/en/user-manual/elasticjob-lite/usage/tracing/

little-yellow commented 3 years ago

Thank for your guilding, but there is still a problem. image image image If I don't use Druid, things all go well.