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/10/16 12:22:52 UTC
[GitHub] [shardingsphere-elasticjob] lvqiushi opened a new issue #1563: elastic job start error
lvqiushi opened a new issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563
the elastic job pom
<dependency>
<groupId>com.dangdang</groupId>
<artifactId>elastic-job-lite-core</artifactId>
<version>2.1.5</version>
<exclusions>
<exclusion>
<artifactId>curator-client</artifactId>
<groupId>org.apache.curator</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>com.dangdang</groupId>
<artifactId>elastic-job-lite-spring</artifactId>
<version>2.1.5</version>
</dependency>
---------------------------------------------
when i use elastic job,i receive the error log.
Elastic job: create JobEventListener failure, error is:
com.dangdang.ddframe.job.event.JobEventListenerConfigurationException: java.sql.SQLSyntaxErrorException: SELECT command denied to user 'xxxx' for table 'job_status_trace_log'
at com.dangdang.ddframe.job.event.rdb.JobEventRdbConfiguration.createJobEventListener(JobEventRdbConfiguration.java:48)
at com.dangdang.ddframe.job.event.JobEventBus.register(JobEventBus.java:57)
at com.dangdang.ddframe.job.event.JobEventBus.<init>(JobEventBus.java:52)
at com.dangdang.ddframe.job.lite.api.JobScheduler.<init>(JobScheduler.java:79)
at com.dangdang.ddframe.job.lite.spring.api.SpringJobScheduler.<init>(SpringJobScheduler.java:46)
at com.qk.activity.config.job.JobConfig.slackActivitySchdule(JobConfig.java:71)
at com.qk.activity.config.job.JobConfig$$EnhancerBySpringCGLIB$$7f7bce11.CGLIB$slackActivitySchdule$3(<generated>)
at com.qk.activity.config.job.JobConfig$$EnhancerBySpringCGLIB$$7f7bce11$$FastClassBySpringCGLIB$$f58264bb.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
....
Caused by: java.sql.SQLSyntaxErrorException: SELECT command denied to user 'qingkamain'@'172.16.65.58' for table 'job_status_trace_log'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at com.mysql.cj.jdbc.DatabaseMetaData$6.forEach(DatabaseMetaData.java:2718)
at com.mysql.cj.jdbc.DatabaseMetaData$6.forEach(DatabaseMetaData.java:2705)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2775)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbStorage.createTaskIdIndexIfNeeded(JobEventRdbStorage.java:93)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbStorage.createJobStatusTraceTableAndIndexIfNeeded(JobEventRdbStorage.java:88)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbStorage.initTablesAndIndexes(JobEventRdbStorage.java:67)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbStorage.<init>(JobEventRdbStorage.java:61)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbListener.<init>(JobEventRdbListener.java:37)
at com.dangdang.ddframe.job.event.rdb.JobEventRdbConfiguration.createJobEventListener(JobEventRdbConfiguration.java:46)
I have given relevant permissions in the database,How can I handle this situation？
----------------------------------------------------------------
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] lvqiushi edited a comment on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi edited a comment on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with `GRANT SELECT *.* TO 'admin'@'%'`
I think the elastic job must require the ' SELECT *.* ' auth instead of ' SELECT database.* '
----------------------------------------------------------------
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] lvqiushi commented on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi commented on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with " GRANT SELECT *.* to 'admin'@'%' ".
I think the elastic job must require the ' SELECT *.* ' auth instead of ' SELECT database.* '
----------------------------------------------------------------
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] lvqiushi edited a comment on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi edited a comment on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with "` GRANT` SELECT *.* to 'admin'@'%' `".
I think the elastic job must require the ' SELECT *.* ' auth instead of ' SELECT database.* '
----------------------------------------------------------------
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] lvqiushi edited a comment on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi edited a comment on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with `GRANT SELECT *.* TO 'admin'@'%'`
I think the elastic job must require the ` SELECT *.* ` auth instead of ` SELECT database.* `
----------------------------------------------------------------
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] lvqiushi edited a comment on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi edited a comment on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with " `GRANT` SELECT *.* to 'admin'@'%' ".
I think the elastic job must require the ' SELECT *.* ' auth instead of ' SELECT database.* '
----------------------------------------------------------------
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] wwj-go commented on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
wwj-go commented on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-710060771
Maybe you should execute
` flush privileges`
for your mysql server?
----------------------------------------------------------------
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] terrymanu commented on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-715234875
Please set correct permission for the database
----------------------------------------------------------------
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] lvqiushi edited a comment on issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
lvqiushi edited a comment on issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563#issuecomment-711616108
its work when I change the mysql auth with " `GRANT` SELECT *.* to 'admin'@'%' `".
I think the elastic job must require the ' SELECT *.* ' auth instead of ' SELECT database.* '
----------------------------------------------------------------
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] terrymanu closed issue #1563: elastic job start error
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #1563:
URL: https://github.com/apache/shardingsphere-elasticjob/issues/1563
----------------------------------------------------------------
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