首页 新闻 会员 周边 捐助

sqoop2 连接问题

0
悬赏园豆:50 [已关闭问题] 关闭于 2016-05-12 11:25

我用公司 集成的sqoop2 发现一个问题。 当我创建一个 link 的时候

create link --cid 3

接着再删除他

delete link -l 3

然后再创建 就无法创建了。 

会报错。

sqoop:000> create link --cid 3
Creating link for connector with id 3
Exception has occurred during processing command 
Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception
Stack trace:
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:113) 
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:47) 
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:144) 
at org.apache.sqoop.client.request.ConnectorResourceRequest (ConnectorResourceRequest.java:38) 
at org.apache.sqoop.client.request.SqoopResourceRequests (SqoopResourceRequests.java:92) 
at org.apache.sqoop.client.SqoopClient (SqoopClient.java:188) 
at org.apache.sqoop.client.SqoopClient (SqoopClient.java:140) 
at org.apache.sqoop.client.SqoopClient (SqoopClient.java:283) 
at org.apache.sqoop.shell.CreateLinkFunction (CreateLinkFunction.java:63) 
at org.apache.sqoop.shell.CreateLinkFunction (CreateLinkFunction.java:55) 
at org.apache.sqoop.shell.SqoopFunction (SqoopFunction.java:51) 
at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:127) 
at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:103) 
at org.codehaus.groovy.tools.shell.Command$execute (null:-1) 
at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:42) 
at org.codehaus.groovy.tools.shell.Command$execute (null:-1) 
at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:101) 
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:-1) 
at sun.reflect.GeneratedMethodAccessor18 (null:-1) 
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method (Method.java:606) 
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90) 
at groovy.lang.MetaMethod (MetaMethod.java:233) 
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054) 
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128) 
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:173) 
at sun.reflect.GeneratedMethodAccessor17 (null:-1) 
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method (Method.java:606) 
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:267) 
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:52) 
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:141) 
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:121) 
at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:114) 
at org.codehaus.groovy.tools.shell.Shell$leftShift$0 (null:-1) 
at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:88) 
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1) 
at sun.reflect.GeneratedMethodAccessor15 (null:-1) 
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method (Method.java:606) 
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90) 
at groovy.lang.MetaMethod (MetaMethod.java:233) 
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054) 
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128) 
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:148) 
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:100) 
at sun.reflect.GeneratedMethodAccessor14 (null:-1) 
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method (Method.java:606) 
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:267) 
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:52) 
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:137) 
at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:57) 
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1) 
at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2) 
at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:57) 
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method (Method.java:606) 
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90) 
at groovy.lang.MetaMethod (MetaMethod.java:233) 
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054) 
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128) 
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:148) 
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:66) 
at java_lang_Runnable$run (null:-1) 
at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:42) 
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:108) 
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:112) 
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:463) 
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:402) 
at org.apache.sqoop.shell.SqoopShell (SqoopShell.java:128) 
Caused by: Exception: java.lang.Throwable Message: Invalid connector id 3
Stack trace:
at org.apache.sqoop.handler.ConnectorRequestHandler (ConnectorRequestHandler.java:85) 
at org.apache.sqoop.server.v1.ConnectorServlet (ConnectorServlet.java:49) 
at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:48) 
at javax.servlet.http.HttpServlet (HttpServlet.java:617) 
at javax.servlet.http.HttpServlet (HttpServlet.java:723) 
at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:290) 
at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206) 
at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:592) 
at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:555) 
at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:235) 
at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206) 
at org.apache.catalina.core.StandardWrapperValve (StandardWrapperValve.java:233) 
at org.apache.catalina.core.StandardContextValve (StandardContextValve.java:191) 
at org.apache.catalina.core.StandardHostValve (StandardHostValve.java:127) 
at org.apache.catalina.valves.ErrorReportValve (ErrorReportValve.java:103) 
at org.apache.catalina.core.StandardEngineValve (StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter (CoyoteAdapter.java:293) 
at org.apache.coyote.http11.Http11Processor (Http11Processor.java:861) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler (Http11Protocol.java:606) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:489) 
at java.lang.Thread (Thread.java:745)

 

此时 假如是 create link --cid 1 

是可以正常创建的。不会报错。

再show link 可以看到

 

sqoop:000> show link
+----+------------+-----------+---------+
| Id | Name | Connector | Enabled |
+----+------------+-----------+---------+
| 9 | hdfs_info | 1 | true |
| 10 | mysql_info | 2 | true |
+----+------------+-----------+---------+
sqoop:000>

 按道理  假如 1能创建  那么3 也能创建。 为什么会无法创建。

情不知所起一往而深的主页 情不知所起一往而深 | 初学一级 | 园豆:87
提问于:2016-05-11 15:11
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册