Hi Eric, I found a typo in my jdbc fine and that fixed it! Thanks again for the help.
-Elise On 08/22/11, Eric Yang <[email protected]> wrote: > 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) > > > > > > >
