chukwa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cheng (JIRA)" <j...@apache.org>
Subject [jira] Created: (CHUKWA-329) user daily aggregation sql error
Date Tue, 23 Jun 2009 21:03:07 GMT
user daily aggregation sql error
--------------------------------

                 Key: CHUKWA-329
                 URL: https://issues.apache.org/jira/browse/CHUKWA-329
             Project: Hadoop Chukwa
          Issue Type: Bug
    Affects Versions: 0.2.0
            Reporter: Cheng
             Fix For: 0.2.0


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)


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message