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

TimeZone:While running the Admax.sh for CSC , .mysql.jdbc.exceptions.MySQLSyntaxErrorException occurs.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Daily Data Availability Phase 2
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      While running the Admax.sh for CSC , .mysql.jdbc.exceptions.MySQLSyntaxErrorException occurs.

      Prerequisite:

      Account Time is : Pacific/Auckland

      saapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./admax.sh -t 61 --date 2011-11-04 -d3

      2011-11-06 08:50:54.219 INFO [BusApplicationContext]: Refreshing org.apache.cxf.bus.spring.BusApplicationContext@37bd2664: display name [org.apache.cxf.bus.spring.BusApplicationContext@37bd2664]; startup date [Sun Nov 06 08:50:54 PST 2011]; root of context hierarchy

      Nov 6, 2011 8:50:54 AM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources

      INFO: No cxf.xml configuration file detected, relying on defaults.

      2011-11-06 08:50:54.982 INFO [DefaultListableBeanFactory]: Overriding bean definition for bean 'org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder': replacing [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/83/tsa-build-bidmgr-2011-11-05-p83-r30844/libs/cxf/cxf.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/83/tsa-build-bidmgr-2011-11-05-p83-r30844/libs/cxf/cxf.jar!/META-INF/cxf/cxf-extension-http.fixml]]

      .

      .

      .

      011-11-06 08:51:12.941 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

      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.Connection.execSQL(Connection.java:3099)

      at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)

      at com.carldunham.jst.db.Database.executeQuery(Database.java:356)

      at com.carldunham.jst.db.Database.executeQuery(Database.java:308)

      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180)

      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169)

      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:163)

      at com.thesearchagency.searchengines.SearchEngineAccountDispatcher.getEnabledSEAccounts(SearchEngineAccountDispatcher.java:251)

      at com.thesearchagency.admax.algorithms.AdMaxAlgorithm.checkDataSources(AdMaxAlgorithm.java:799)

      at com.thesearchagency.admax.algorithms.AdMaxWACPAlgorithm.applyAlgorithm(AdMaxWACPAlgorithm.java:104)

      at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.run(AdMaxSummarizer.java:531)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)

      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)

      at java.util.concurrent.FutureTask.run(FutureTask.java:123)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)

      at java.lang.Thread.run(Thread.java:595)

      ================= Detailed log has attached===========

      gsingh@tvvm-staging-xml1:/var/local/tsa/log/2011-11-01$ grep 'error' .

      admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:15.741 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

      admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:23.370 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

      admax.sh_d_3_T_2011_10_31__timezoneid_61_03:37:00.log:2011-11-01 03:37:29.384 (2) [P1T1]: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1 (code:1064)

      -------------------------------------------------------------------------

      gsingh@tvvm-staging-xml1:/var/local/tsa/log/2011-11-05$ grep 'error' .

      admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:35.948 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

      admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:47.540 (2) [P1T1]: Exception [handling search engine user]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1

      admax.sh_d_3_T_2011_11_04__timezoneid_61_03:25:10.log:2011-11-05 03:25:53.492 (2) [P1T1]: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priorit' at line 1 (code:1064)

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: