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 | 4 months ago
  1. 0

    双向同步时库select报错

    GitHub | 4 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'**
  2. 0

    NODE节点在LOAD数据,报语法错误,同步链路挂起

    GitHub | 7 months ago | bskllzh
    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: PreparedStatementCallback; **bad SQL grammar [update moonmall.mall_wx_redpacket_apply_details set where ( `applyid` = ? and `redpacket_no` = ? )];** nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ( `applyid` = 'HB16051500001' and `redpacket_no` = '9832' )' at line 1
  3. 0

    日期时间报错

    GitHub | 3 years ago | niuliwei
    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.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into scms_0801.sc_fsm_entity_state(`CREATE_BY` , `CREATE_TIME` , `UPDATE_BY` , `UPDATE_TIME` , `ENTITY` , `ENTITY_ID` , `STATE_ID` , `ID`) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `ID`=values(`ID`) , `CREATE_BY`=values(`CREATE_BY`) , `CREATE_TIME`=values(`CREATE_TIME`) , `UPDATE_BY`=values(`UPDATE_BY`) , `UPDATE_TIME`=values(`UPDATE_TIME`) , `ENTITY`=values(`ENTITY`) , `ENTITY_ID`=values(`ENTITY_ID`) , `STATE_ID`=values(`STATE_ID`)]; Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    全量同步时tinyint字段类型转换错误

    GitHub | 3 years ago | goodayforme
    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.apache.commons.beanutils.ConversionException: Error converting from 'String' to 'BigInteger' For input string: "true"
  6. 0

    GitHub comment 30#35330966

    GitHub | 3 years ago | niuliwei
    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.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into scms_0801.sc_fsm_entity_state(`CREATE_BY` , `CREATE_TIME` , `UPDATE_BY` , `UPDATE_TIME` , `ENTITY` , `ENTITY_ID` , `STATE_ID` , `ID`) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `ID`=values(`ID`) , `CREATE_BY`=values(`CREATE_BY`) , `CREATE_TIME`=values(`CREATE_TIME`) , `UPDATE_BY`=values(`UPDATE_BY`) , `UPDATE_TIME`=values(`UPDATE_TIME`) , `ENTITY`=values(`ENTITY`) , `ENTITY_ID`=values(`ENTITY_ID`) , `STATE_ID`=values(`STATE_ID`)]; Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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