TableCreator and DataExpiration utilities are not able to create database tables or drop existing partitions. This may be caused by missing mysql connector jar file (we can't bundle this jar due to license incompatible with ASF). You will need to manually copy mysql connector jar file to CHUKWA_HOME/lib. In addition, make sure CHUKWA_HOME/conf/jdbc.properties is setup correctly.
regards, Eric On Aug 22, 2011, at 8:31 AM, Elise Gale wrote: > Hello Eric, > > Thanks for the quick reply. I actually made those changes already when I was > setting up the collector, and I have not had version mismatch errors in my > namenode log since then. I deleted /chukwa on HDFS and recompiled the fix > for CHUKWA-543. I am running dbAdmin.sh in the background on the same > machine as hicc and I am now getting this error message. I am still getting > "No Data Available" in HICC. Any thoughts? > > -Elise > > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:87) > at > org.apache.hadoop.chukwa.database.DataExpiration.dropTables(DataExpiration.java:69) > at > org.apache.hadoop.chukwa.database.DataExpiration.main(DataExpiration.java:111) > Invalid date format or time window size. > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.query(DatabaseWriter.java:137) > at > org.apache.hadoop.chukwa.database.TableCreator.createTables(TableCreator.java:72) > at > org.apache.hadoop.chukwa.database.TableCreator.main(TableCreator.java:125) > TableCreator usage: > java -jar chukwa-core.jar org.apache.hadoop.chukwa.TableCreator <date> <time > window size> > date format: YYYY-MM-DD > time window size: 7, 30, 91, 365, 3650 > Invalid date format or time window size. > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.query(DatabaseWriter.java:137) > at > org.apache.hadoop.chukwa.database.TableCreator.createTables(TableCreator.java:72) > at > org.apache.hadoop.chukwa.database.TableCreator.main(TableCreator.java:125) > TableCreator usage: > java -jar chukwa-core.jar org.apache.hadoop.chukwa.TableCreator <date> <time > window size> > Invalid date format or time window size. > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.query(DatabaseWriter.java:137) > at > org.apache.hadoop.chukwa.database.TableCreator.createTables(TableCreator.java:72) > at > org.apache.hadoop.chukwa.database.TableCreator.main(TableCreator.java:125) > TableCreator usage: > java -jar chukwa-core.jar org.apache.hadoop.chukwa.TableCreator <date> <time > window size> > date format: YYYY-MM-DD > time window size: 7, 30, 91, 365, 3650 > Invalid date format or time window size. > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.query(DatabaseWriter.java:137) > at > org.apache.hadoop.chukwa.database.TableCreator.createTables(TableCreator.java:72) > at > org.apache.hadoop.chukwa.database.TableCreator.main(TableCreator.java:125) > TableCreator usage: > java -jar chukwa-core.jar org.apache.hadoop.chukwa.TableCreator <date> <time > window size> > date format: YYYY-MM-DD > time window size: 7, 30, 91, 365, 3650 > date format: YYYY-MM-DD > time window size: 7, 30, 91, 365, 3650 > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:87) > at > org.apache.hadoop.chukwa.database.DataExpiration.dropTables(DataExpiration.java:69) > at > org.apache.hadoop.chukwa.database.DataExpiration.main(DataExpiration.java:111) > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:87) > at > org.apache.hadoop.chukwa.database.DataExpiration.dropTables(DataExpiration.java:69) > at > org.apache.hadoop.chukwa.database.DataExpiration.main(DataExpiration.java:111) > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:87) > at > org.apache.hadoop.chukwa.database.DataExpiration.dropTables(DataExpiration.java:69) > at > org.apache.hadoop.chukwa.database.DataExpiration.main(DataExpiration.java:111) > Invalid date format or time window size. > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.query(DatabaseWriter.java:137) > at > org.apache.hadoop.chukwa.database.TableCreator.createTables(TableCreator.java:72) > at > org.apache.hadoop.chukwa.database.TableCreator.main(TableCreator.java:125) > TableCreator usage: > java -jar chukwa-core.jar org.apache.hadoop.chukwa.TableCreator <date> <time > window size> > date format: YYYY-MM-DD > time window size: 7, 30, 91, 365, 3650 > java.lang.NullPointerException > at > org.apache.hadoop.chukwa.util.DatabaseWriter.execute(DatabaseWriter.java:87) > at > org.apache.hadoop.chukwa.database.DataExpiration.dropTables(DataExpiration.java:69) > at > org.apache.hadoop.chukwa.database.DataExpiration.main(DataExpiration.java:111) > >
