Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Google v201101
-
Fix Version/s: Google v201101
-
Component/s: Google
-
Labels:None
-
Environment:
tsa-build-bidmgr-2011-06-20-p17-r29717 on Staging-xml1
Description
While running the ./generate-discrepancies.sh script, it throws exception..
tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./generate-discrepancies.sh -d 3 --accountid 17 --distribution 3 -T 2011-05-17 -E 2011-06-04 2>&1| tee /tmp/test.log
2011-06-18 00:38:48.238 (3) [main]: Debug Level set to 3
log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle).
log4j:WARN Please initialize the log4j system properly.
2011-06-18 00:39:10.030 (3) [main]: getAbsolutePath() returned /tmp/abtl24412.csv
2011-06-18 00:39:10.157 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_329919.csv"
2011-06-18 00:39:11.146 (3) [main]: getAbsolutePath() returned /tmp/abtl24412.csv
2011-06-18 00:39:13.566 (3) [main]: DatabasePool with a limit of 80 created
2011-06-18 00:39:14.290 (3) [main]: getAbsolutePath() returned /tmp/abtl24412.csv
2011-06-18 00:39:14.398 (1) [main]: Exception [Error in createTempTable2()]:java.sql.SQLException: Table './staging/googleDailyCheck' is marked as crashed and should be repaired
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at com.carldunham.jst.db.Database.executeUpdate(Database.java:401)
at com.carldunham.jst.db.Database.executeUpdate(Database.java:378)
at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepanciesReport$FileGenerator.createTempTable2(DataCheckerDiscrepanciesReport.java:1151)
at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepanciesReport$FileGenerator.generate(DataCheckerDiscrepanciesReport.java:846)
at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepanciesReport.putFile(DataCheckerDiscrepanciesReport.java:353)
at com.thesearchagency.searchengines.datachecker.DataCheckerDiscrepanciesReport.main(DataCheckerDiscrepanciesReport.java:99)
2011-06-18 00:39:14.414 (3) [main]: Writing file to /var/local/tsa/datachecker/2011-06-18-tsa-DiscrepancyReport-D3.csv
2011-06-18 00:39:14.426 (3) [main]: ... done
2011-06-18 00:39:14.426 (3) [main]: Report generated successfully at following location /var/local/tsa/datachecker/2011-06-18-tsa-DiscrepancyReport-D3.csv