Uploaded image for project: 'Yell'
  1. Yell
  2. YELL-864

Exception Unknown database 'content_editor_google' while running remove location targets script

    Details

      Description

      when we are running remove location script then it throwing exception Unknown database 'content_editor_google'.

      Log

      root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/location-target-remover-0.0.1-SNAPSHOT# java -jar location-target-remover-0.0.1-SNAPSHOT.jar -b 1 -s 83078 -d3 -h4
      [23 Dec 2013 06:52:03,181-ClassPathXmlApplicationContext:INFO:main] Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@77c99159: display name [org.springframework.context.support.ClassPathXmlApplicationContext@77c99159]; startup date [Mon Dec 23 06:52:03 GMT 2013]; root of context hierarchy
      [23 Dec 2013 06:52:03,267-XmlBeanDefinitionReader:INFO:main] Loading XML bean definitions from class path resource [googleDataSourceBeans.xml]
      [23 Dec 2013 06:52:03,580-ClassPathXmlApplicationContext:INFO:main] Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@77c99159]: org.springframework.beans.factory.support.DefaultListableBeanFactory@5cac6a45
      [23 Dec 2013 06:52:03,599-DefaultListableBeanFactory:INFO:main] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5cac6a45: defining beans [googleDataSourceShard1,googleDataSourceShard2,googleDataSourceShard3,googleDataSourceShard12,locationSummaryDAOShard1,locationSummaryDAOShard2,locationSummaryDAOShard3,contentEditorTargetDAOShard1,contentEditorTargetDAOShard2,contentEditorTargetDAOShard3,locationSummaryDAOShard12,contentEditorTargetDAOShard12]; root of factory hierarchy
      [23 Dec 2013 06:52:03,603-ClassPathXmlApplicationContext:INFO:pool-1-thread-1] Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@4476128: display name [org.springframework.context.support.ClassPathXmlApplicationContext@4476128]; startup date [Mon Dec 23 06:52:03 GMT 2013]; root of context hierarchy
      [23 Dec 2013 06:52:03,609-XmlBeanDefinitionReader:INFO:pool-1-thread-1] Loading XML bean definitions from class path resource [googleDataSourceBeans.xml]
      [23 Dec 2013 06:52:03,726-ClassPathXmlApplicationContext:INFO:pool-1-thread-1] Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@4476128]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1cec6b00
      [23 Dec 2013 06:52:03,730-DefaultListableBeanFactory:INFO:pool-1-thread-1] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1cec6b00: defining beans [googleDataSourceShard1,googleDataSourceShard2,googleDataSourceShard3,googleDataSourceShard12,locationSummaryDAOShard1,locationSummaryDAOShard2,locationSummaryDAOShard3,contentEditorTargetDAOShard1,contentEditorTargetDAOShard2,contentEditorTargetDAOShard3,locationSummaryDAOShard12,contentEditorTargetDAOShard12]; root of factory hierarchy
      [23 Dec 2013 06:52:03,798-DriverManagerDataSource:INFO:pool-1-thread-1] Loaded JDBC driver: com.mysql.jdbc.Driver
      [23 Dec 2013 06:52:03,813-GoogleLocationSummaryDAO:INFO:pool-1-thread-1] Retrieving Locations in batches...
      [23 Dec 2013 06:52:03,986-LocationTargetRemover:ERROR:pool-1-thread-1] LocationTargetRemover aborted!
      org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'content_editor_google'
      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
      at com.thesearchagency.tools.migrator.dao.GoogleLocationSummaryDAO.getLocationsInBatches(GoogleLocationSummaryDAO.java:86)
      at com.thesearchagency.tools.migrator.GoogleLocationTargetRemover.getLocationTargets(GoogleLocationTargetRemover.java:32)
      at com.thesearchagency.tools.migrator.LocationTargetRemover.run(LocationTargetRemover.java:99)
      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)
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'content_editor_google'
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
      at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
      at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
      at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
      at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
      at java.sql.DriverManager.getConnection(DriverManager.java:525)
      at java.sql.DriverManager.getConnection(DriverManager.java:140)
      at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
      at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
      at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
      at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
      at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
      ... 14 more
      [23 Dec 2013 06:52:03,990-LocationTargetRemover:INFO:LocationTargetRemover Shutdown Hook] LocationTargetRemover recieved a shutdown signal

        Attachments

          Activity

            People

            • Assignee:
              anil.kumar Anil Kumar Halmadgi
              Reporter:
              anil.kumar Anil Kumar Halmadgi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: