-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/26419/#review55941
-----------------------------------------------------------
I can't seem to upgrade from a sqoop2 repo. to the from/to repo.
2014-10-08 19:22:49,007 ERROR core.SqoopServer
[org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:56)] Server
startup failure
org.apache.sqoop.common.SqoopException: DERBYREPO_0003:Unable to run specified
query - RENAME COLUMN SQOOP.SQ_CONFIG.SQ_CFG_OPERATION TO SQ_CFG_DIRECTION
at
org.apache.sqoop.repository.derby.DerbyRepositoryHandler.runQuery(DerbyRepositoryHandler.java:2157)
at
org.apache.sqoop.repository.derby.DerbyRepositoryHandler.createOrUpgradeRepositorySchemaAndData(DerbyRepositoryHandler.java:405)
at
org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:131)
at
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:90)
at
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:61)
at
org.apache.sqoop.repository.JdbcRepository.createOrUpgradeRepositorySchemaAndData(JdbcRepository.java:127)
at
org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:122)
at
org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:75)
at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:50)
at
org.apache.sqoop.server.ServerInitializer.contextInitialized(ServerInitializer.java:38)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at
org.apache.catalina.core.StandardService.start(StandardService.java:525)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement
from pool failed
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at
org.apache.sqoop.repository.derby.DerbyRepositoryHandler.runQuery(DerbyRepositoryHandler.java:2133)
... 33 more
Caused by: java.sql.SQLSyntaxErrorException: 'RENAME COLUMN' cannot be
performed on 'SQOOP.SQ_CONFIG' because it does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
... 36 more
Caused by: java.sql.SQLException: 'RENAME COLUMN' cannot be performed on
'SQOOP.SQ_CONFIG' because it does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 52 more
Caused by: ERROR 42Y55: 'RENAME COLUMN' cannot be performed on
'SQOOP.SQ_CONFIG' because it does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.compile.DDLStatementNode.justGetDescriptor(Unknown
Source)
t
org.apache.derby.impl.sql.compile.DDLStatementNode.getTableDescriptor(Unknown
Source)
- Abraham Elmahrek
On Oct. 8, 2014, 11:29 p.m., Veena Basavaraj wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/26419/
> -----------------------------------------------------------
>
> (Updated Oct. 8, 2014, 11:29 p.m.)
>
>
> Review request for Sqoop.
>
>
> Repository: sqoop-SQOOP-1367
>
>
> Description
> -------
>
> Few more pending renames as per the agreement on Sqoop 1551
>
> - Mainly fix the upgrade logic for 1498 changes
> - rename the repository upgrader to Configurable upgrader - agreed by Jarcec.
>
> - rename configuration utils to MRConfigurationUtils, so it is not be
> confused with the sqoop configuration/ configs
> - rename mapreduce to MR ( if this is not acceptable, happy to change it back)
>
>
> Diffs
> -----
>
> common/src/main/java/org/apache/sqoop/model/ConfigUtils.java 290e7fc
> common/src/main/java/org/apache/sqoop/model/MConfigurable.java PRE-CREATION
> common/src/main/java/org/apache/sqoop/model/MConfigurableType.java
> PRE-CREATION
> common/src/main/java/org/apache/sqoop/model/MConnector.java 2f42191
> common/src/main/java/org/apache/sqoop/model/MDriver.java 685439e
> common/src/main/java/org/apache/sqoop/utils/ClassUtils.java 0be4d41
> common/src/main/java/org/apache/sqoop/validation/ConfigValidator.java
> eac789e
>
> connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnector.java
> 87ac2af
>
> connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/GenericJdbcConnectorUpgrader.java
> a069b3e
>
> connector/connector-hdfs/src/main/java/org/apache/sqoop/connector/hdfs/HdfsConfigUpgrader.java
> b17aa21
>
> connector/connector-hdfs/src/main/java/org/apache/sqoop/connector/hdfs/HdfsConnector.java
> 606b9fa
>
> connector/connector-hdfs/src/main/java/org/apache/sqoop/connector/hdfs/HdfsConnectorUpgrader.java
> PRE-CREATION
> core/src/main/java/org/apache/sqoop/connector/ConnectorError.java d544fb1
> core/src/main/java/org/apache/sqoop/connector/ConnectorHandler.java 54bdd13
> core/src/main/java/org/apache/sqoop/connector/ConnectorManager.java 5226926
> core/src/main/java/org/apache/sqoop/driver/Driver.java f1b45bb
> core/src/main/java/org/apache/sqoop/driver/DriverConfigUpgrader.java
> 847b73d
> core/src/main/java/org/apache/sqoop/driver/DriverUpgrader.java PRE-CREATION
> core/src/main/java/org/apache/sqoop/driver/JobManager.java df2a5ab
> core/src/main/java/org/apache/sqoop/driver/JobRequest.java 2666320
> core/src/main/java/org/apache/sqoop/repository/JdbcRepository.java 3ade247
> core/src/main/java/org/apache/sqoop/repository/JdbcRepositoryHandler.java
> 97de893
> core/src/main/java/org/apache/sqoop/repository/Repository.java 95c7a4d
> core/src/main/java/org/apache/sqoop/repository/RepositoryManager.java
> c2f8505
> core/src/main/resources/driver-config.properties 78c3b38
> core/src/test/java/org/apache/sqoop/driver/TestDriverConfigUpgrader.java
> dc4e8c8
> core/src/test/java/org/apache/sqoop/driver/TestDriverUpgrader.java
> PRE-CREATION
> core/src/test/java/org/apache/sqoop/driver/TestJobManager.java 3b475c6
> core/src/test/java/org/apache/sqoop/repository/TestJdbcRepository.java
> e6e4760
>
> execution/mapreduce/src/main/java/org/apache/sqoop/execution/mapreduce/MapreduceExecutionEngine.java
> 47f8478
> execution/mapreduce/src/main/java/org/apache/sqoop/job/JobConstants.java
> 349bb60
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/MRExecutionError.java
> PRE-CREATION
> execution/mapreduce/src/main/java/org/apache/sqoop/job/MRJobConstants.java
> PRE-CREATION
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/MapreduceExecutionError.java
> 1dc12d1
> execution/mapreduce/src/main/java/org/apache/sqoop/job/io/Data.java 5423b7b
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/ConfigurationUtils.java
> 0fa07f7
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/MRConfigurationUtils.java
> PRE-CREATION
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopDestroyerExecutor.java
> 8d2a1da
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopFileOutputFormat.java
> ca77e16
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopInputFormat.java
> 1c1133a
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopMapper.java
> 03d84d4
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopNullOutputFormat.java
> 594b5e9
>
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopOutputFormatLoadExecutor.java
> 1ebd3e4
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopReducer.java
> a55534a
> execution/mapreduce/src/main/java/org/apache/sqoop/job/mr/SqoopSplit.java
> dca4c90
> execution/mapreduce/src/test/java/org/apache/sqoop/job/TestMapReduce.java
> e3b68e2
> execution/mapreduce/src/test/java/org/apache/sqoop/job/TestMatching.java
> 7f9a147
>
> execution/mapreduce/src/test/java/org/apache/sqoop/job/io/SqoopWritableTest.java
> f5742a2
>
> execution/mapreduce/src/test/java/org/apache/sqoop/job/mr/TestConfigurationUtils.java
> 501e32c
>
> execution/mapreduce/src/test/java/org/apache/sqoop/job/mr/TestMRConfigurationUtils.java
> PRE-CREATION
>
> execution/mapreduce/src/test/java/org/apache/sqoop/job/mr/TestSqoopOutputFormatLoadExecutor.java
> 1f411d2
>
> repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbyRepoConstants.java
> 74e41df
>
> repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbyRepositoryHandler.java
> 73d8387
>
> repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaConstants.java
> ad749ed
>
> repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
> 478afe2
>
> repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/DerbyTestCase.java
> 2da084f
>
> repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestDriverHandling.java
> d597bd8
>
> repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestInternals.java
> 0eb9df4
>
> repository/repository-derby/src/test/java/org/apache/sqoop/repository/derby/TestRespositorySchemaUpgrade.java
> PRE-CREATION
> server/src/main/java/org/apache/sqoop/handler/ConnectorRequestHandler.java
> 7109ae5
>
> server/src/main/java/org/apache/sqoop/handler/DriverConfigRequestHandler.java
> aa773a9
> server/src/main/java/org/apache/sqoop/handler/JobRequestHandler.java
> 462579c
> server/src/main/java/org/apache/sqoop/handler/LinkRequestHandler.java
> 80e65b8
> shell/src/main/java/org/apache/sqoop/shell/SqoopCommand.java cbd34f5
> spi/src/main/java/org/apache/sqoop/connector/spi/ConfigurableUpgrader.java
> PRE-CREATION
> spi/src/main/java/org/apache/sqoop/connector/spi/RepositoryUpgrader.java
> 879e428
> spi/src/main/java/org/apache/sqoop/connector/spi/SqoopConnector.java
> 849f091
>
> submission/mapreduce/src/main/java/org/apache/sqoop/submission/mapreduce/MapreduceSubmissionEngine.java
> 0c492ef
>
> Diff: https://reviews.apache.org/r/26419/diff/
>
>
> Testing
> -------
>
> yes test pass
>
>
> Thanks,
>
> Veena Basavaraj
>
>
