Details
-
Type: Bug
-
Status: Closed
-
Priority: Blocker
-
Resolution: Not a Bug
-
Affects Version/s: Point Radii Implementation
-
Fix Version/s: None
-
Component/s: Point Radii Migration
-
Labels:None
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