You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@chukwa.apache.org by "Cheng (JIRA)" <ji...@apache.org> on 2009/06/23 23:03:07 UTC
[jira] Created: (CHUKWA-329) user daily aggregation sql error
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.
[jira] Updated: (CHUKWA-329) user daily aggregation sql error
Posted by "Ari Rabkin (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CHUKWA-329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ari Rabkin updated CHUKWA-329:
------------------------------
Fix Version/s: (was: 0.2.0)
0.3.0
> 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.4.0
>
> Attachments: chukwa-329.patch
>
>
> 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.
[jira] Updated: (CHUKWA-329) user daily aggregation sql error
Posted by "Cheng (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CHUKWA-329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cheng updated CHUKWA-329:
-------------------------
Attachment: chukwa-329.patch
patch submitted.
> 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
>
> Attachments: chukwa-329.patch
>
>
> 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.
[jira] Updated: (CHUKWA-329) user daily aggregation sql error
Posted by "Ari Rabkin (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CHUKWA-329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ari Rabkin updated CHUKWA-329:
------------------------------
Fix Version/s: 0.5.0
(was: 0.4.0)
> 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.5.0
>
> Attachments: chukwa-329.patch
>
>
> 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.
[jira] Updated: (CHUKWA-329) user daily aggregation sql error
Posted by "Ari Rabkin (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CHUKWA-329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ari Rabkin updated CHUKWA-329:
------------------------------
Fix Version/s: (was: 0.3.0)
0.4.0
> 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.4.0
>
> Attachments: chukwa-329.patch
>
>
> 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.