com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT COUNT(*) FROM retl.retl_mark WHERE id BETWEEN 0 AND 999]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: **SELECT command denied to user 'username'@'10.151.132.116' for table 'retl_mark'**

GitHub | Fredwt | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    双向同步时库select报错

    GitHub | 8 months ago | Fredwt
    com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT COUNT(*) FROM retl.retl_mark WHERE id BETWEEN 0 AND 999]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: **SELECT command denied to user 'username'@'10.151.132.116' for table 'retl_mark'**

    Root Cause Analysis

    1. com.alibaba.otter.node.etl.load.exception.LoadException

      java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT COUNT(*) FROM retl.retl_mark WHERE id BETWEEN 0 AND 999]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: **SELECT command denied to user 'username'@'10.151.132.116' for table 'retl_mark'**

      at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate()
    2. Spring Framework
      JdbcTemplate.queryForInt
      1. org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
      5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
      6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
      7. org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:472)
      8. org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:477)
      9. org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:486)
      9 frames
    3. etl module for otter
      AbstractOperationInterceptor.transactionBegin
      1. com.alibaba.otter.node.etl.load.loader.db.interceptor.operation.AbstractOperationInterceptor.init(AbstractOperationInterceptor.java:76)
      2. com.alibaba.otter.node.etl.load.loader.db.interceptor.operation.AbstractOperationInterceptor.updateMark(AbstractOperationInterceptor.java:148)
      3. com.alibaba.otter.node.etl.load.loader.db.interceptor.operation.AbstractOperationInterceptor.transactionBegin(AbstractOperationInterceptor.java:119)
      3 frames