Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2692

GoogleV2011_API_Upgrade: ./generate-discrepancies.sh throws exception.

    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

        Attachments

          Activity

            People

            • Assignee:
              jason.stedman Jason Stedman (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: