om.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:tbuser 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - 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 'from tbuser where 1=2' at line 1

GitHub | swit1983 | 3 months ago
  1. 0

    获取字段的元信息时失败. 请联系 DBA 核查该库、表信息?

    GitHub | 3 months ago | swit1983
    om.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:tbuser 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - 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 'from tbuser where 1=2' at line 1

    Root Cause Analysis

    1. om.alibaba.datax.common.exception.DataXException

      Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:tbuser 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - 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 'from tbuser where 1=2' at line 1

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
    2. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      4 frames
    3. MySQL jdbc
      StatementImpl.executeQuery
      1. com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      2. com.mysql.jdbc.Util.getInstance(Util.java:360)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
      9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
      10. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
      10 frames
    4. com.alibaba.datax
      Engine.main
      1. com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:563)
      2. com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:125)
      3. com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:140)
      4. com.alibaba.datax.plugin.rdbms.writer.util.OriginalConfPretreatmentUtil.doPretreatment(OriginalConfPretreatmentUtil.java:35)
      5. com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Job.init(CommonRdbmsWriter.java:41)
      6. com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Job.init(MysqlWriter.java:31)
      7. com.alibaba.datax.core.job.JobContainer.initJobWriter(JobContainer.java:704)
      8. com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:304)
      9. com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:113)
      10. com.alibaba.datax.core.Engine.start(Engine.java:92)
      11. com.alibaba.datax.core.Engine.entry(Engine.java:171)
      12. com.alibaba.datax.core.Engine.main(Engine.java:204)
      12 frames