Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 0.2.0
    • Fix Version/s: 0.5.0
    • Component/s: None
    • Labels:
      None

      Description

      2009-06-23 16:26:08,700 ERROR main Aggregator - Invalid query:replace into [user_job_summary_month] (select FLOOR(UNIX_TIMESTAMP(timestamp)/300),userid, sum(totalJobs), sum(dataLocalMaps), sum(rackLocalMaps), sum(remoteMaps), sum(mapInputBytes), sum(reduceOutputRecords), sum(mapSlotHours), sum(reduceSlotHours), sum(totalMaps), sum(totalReduces) from [user_job_summary_week] where timestamp between '[past_15_minutes]' and '[now]' group by FLOOR(UNIX_TIMESTAMP(timestamp)/300),userid);
      2009-06-23 16:26:08,701 ERROR main DatabaseWriter - com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '692096' for column 'timestamp' at row 1
      com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '692096' for column 'timestamp' at row 1
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
      at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
      at org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:88)
      at org.apache.hadoop.chukwa.database.Aggregator.process(Aggregator.java:81)
      at org.apache.hadoop.chukwa.database.Aggregator.process(Aggregator.java:91)
      at org.apache.hadoop.chukwa.database.Aggregator.main(Aggregator.java:137)

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Cheng
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development