sqoop2 org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception

启动sqoop2后,启动客户端创建连接时,报如下错误
sqoop2 org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception 重新启动客户端,执行 :set option --name verbose --value true
查看错误信息如下:
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:129)
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:175)
at org.apache.sqoop.client.request.LinkResourceRequest (LinkResourceRequest.java:68)
at org.apache.sqoop.client.request.SqoopResourceRequests (SqoopResourceRequests.java:109)
at org.apache.sqoop.client.SqoopClient (SqoopClient.java:325)
at org.apache.sqoop.shell.CreateLinkFunction (CreateLinkFunction.java:83)
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:135)
at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:111)
at org.codehaus.groovy.tools.shell.Commandexecute(null:1)atorg.codehaus.groovy.runtime.callsite.CallSiteArray(CallSiteArray.java:42)atorg.codehaus.groovy.tools.shell.Commandexecute (null:-1) at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:42) at org.codehaus.groovy.tools.shell.Commandexecute (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.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)
at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:498)
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.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)
at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:498)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSitePogoCachedMethodSiteNoUnwrapNoCoerce(PogoMetaMethodSite.java:267)atorg.codehaus.groovy.runtime.callsite.PogoMetaMethodSite(PogoMetaMethodSite.java:52)atorg.codehaus.groovy.runtime.callsite.AbstractCallSite(AbstractCallSite.java:141)atorg.codehaus.groovy.tools.shell.Groovysh(Groovysh.groovy:121)atorg.codehaus.groovy.tools.shell.Shell(Shell.groovy:114)atorg.codehaus.groovy.tools.shell.ShellPogoCachedMethodSiteNoUnwrapNoCoerce (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.ShellleftShift0(null:1)atorg.codehaus.groovy.tools.shell.ShellRunner(ShellRunner.groovy:88)atorg.codehaus.groovy.tools.shell.InteractiveShellRunner(InteractiveShellRunner.groovy:1)atsun.reflect.NativeMethodAccessorImpl(NativeMethodAccessorImpl.java:2)atsun.reflect.NativeMethodAccessorImpl(NativeMethodAccessorImpl.java:62)atsun.reflect.DelegatingMethodAccessorImpl(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method(Method.java:498)atorg.codehaus.groovy.reflection.CachedMethod(CachedMethod.java:90)atgroovy.lang.MetaMethod(MetaMethod.java:233)atgroovy.lang.MetaClassImpl(MetaClassImpl.java:1054)atorg.codehaus.groovy.runtime.ScriptBytecodeAdapter(ScriptBytecodeAdapter.java:128)atorg.codehaus.groovy.runtime.ScriptBytecodeAdapter(ScriptBytecodeAdapter.java:148)atorg.codehaus.groovy.tools.shell.InteractiveShellRunner(InteractiveShellRunner.groovy:100)atsun.reflect.NativeMethodAccessorImpl(NativeMethodAccessorImpl.java:2)atsun.reflect.NativeMethodAccessorImpl(NativeMethodAccessorImpl.java:62)atsun.reflect.DelegatingMethodAccessorImpl(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method(Method.java:498)atorg.codehaus.groovy.runtime.callsite.PogoMetaMethodSite0 (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.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2) at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method (Method.java:498) 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.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2) at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method (Method.java:498) at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSitePogoCachedMethodSiteNoUnwrapNoCoerce (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:62)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:498)
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:130)
Caused by: Exception: org.apache.sqoop.common.SqoopException Message: COMMON_0016:Unable to create new link data -
Stack trace:
at org.apache.sqoop.repository.common.CommonRepositoryHandler (CommonRepositoryHandler.java:414)
at org.apache.sqoop.repository.JdbcRepository8(JdbcRepository.java:272)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:92)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:63)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:265)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:180)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:69)atorg.apache.sqoop.server.v1.LinkServlet(LinkServlet.java:72)atorg.apache.sqoop.server.SqoopProtocolServlet(SqoopProtocolServlet.java:63)atjavax.servlet.http.HttpServlet(HttpServlet.java:727)atjavax.servlet.http.HttpServlet(HttpServlet.java:820)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:594)atorg.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter(DelegationTokenAuthenticationFilter.java:291)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:553)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11Processor(Http11Processor.java:859)atorg.apache.coyote.http11.Http11Protocol8 (JdbcRepository.java:272) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:92) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:63) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:265) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:180) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:69) at org.apache.sqoop.server.v1.LinkServlet (LinkServlet.java:72) at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:63) at javax.servlet.http.HttpServlet (HttpServlet.java:727) at javax.servlet.http.HttpServlet (HttpServlet.java:820) 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:594) at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291) at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:553) 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:859) at org.apache.coyote.http11.Http11ProtocolHttp11ConnectionHandler (Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:503)
at java.lang.Thread (Thread.java:748)
Caused by: Exception: java.sql.SQLIntegrityConstraintViolationException Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘FK_SQ_LNK_NAME_UNIQUE’ defined on ‘SQ_LINK’.
Stack trace:
at org.apache.derby.impl.jdbc.SQLExceptionFactory40 (null:-1)
at org.apache.derby.impl.jdbc.Util (null:-1)
at org.apache.derby.impl.jdbc.TransactionResourceImpl (null:-1)
at org.apache.derby.impl.jdbc.TransactionResourceImpl (null:-1)
at org.apache.derby.impl.jdbc.EmbedConnection (null:-1)
at org.apache.derby.impl.jdbc.ConnectionChild (null:-1)
at org.apache.derby.impl.jdbc.EmbedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.sqoop.repository.common.CommonRepositoryHandler (CommonRepositoryHandler.java:391)
at org.apache.sqoop.repository.JdbcRepository8(JdbcRepository.java:272)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:92)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:63)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:265)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:180)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:69)atorg.apache.sqoop.server.v1.LinkServlet(LinkServlet.java:72)atorg.apache.sqoop.server.SqoopProtocolServlet(SqoopProtocolServlet.java:63)atjavax.servlet.http.HttpServlet(HttpServlet.java:727)atjavax.servlet.http.HttpServlet(HttpServlet.java:820)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:594)atorg.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter(DelegationTokenAuthenticationFilter.java:291)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:553)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11Processor(Http11Processor.java:859)atorg.apache.coyote.http11.Http11Protocol8 (JdbcRepository.java:272) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:92) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:63) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:265) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:180) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:69) at org.apache.sqoop.server.v1.LinkServlet (LinkServlet.java:72) at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:63) at javax.servlet.http.HttpServlet (HttpServlet.java:727) at javax.servlet.http.HttpServlet (HttpServlet.java:820) 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:594) at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291) at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:553) 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:859) at org.apache.coyote.http11.Http11ProtocolHttp11ConnectionHandler (Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:503)
at java.lang.Thread (Thread.java:748)
Caused by: Exception: java.lang.Throwable Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘FK_SQ_LNK_NAME_UNIQUE’ defined on ‘SQ_LINK’.
Stack trace:
at org.apache.derby.impl.jdbc.SQLExceptionFactory (null:-1)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40 (null:-1)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40 (null:-1)
at org.apache.derby.impl.jdbc.Util (null:-1)
at org.apache.derby.impl.jdbc.TransactionResourceImpl (null:-1)
at org.apache.derby.impl.jdbc.TransactionResourceImpl (null:-1)
at org.apache.derby.impl.jdbc.EmbedConnection (null:-1)
at org.apache.derby.impl.jdbc.ConnectionChild (null:-1)
at org.apache.derby.impl.jdbc.EmbedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.sqoop.repository.common.CommonRepositoryHandler (CommonRepositoryHandler.java:391)
at org.apache.sqoop.repository.JdbcRepository8(JdbcRepository.java:272)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:92)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:63)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:265)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:180)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:69)atorg.apache.sqoop.server.v1.LinkServlet(LinkServlet.java:72)atorg.apache.sqoop.server.SqoopProtocolServlet(SqoopProtocolServlet.java:63)atjavax.servlet.http.HttpServlet(HttpServlet.java:727)atjavax.servlet.http.HttpServlet(HttpServlet.java:820)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:594)atorg.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter(DelegationTokenAuthenticationFilter.java:291)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:553)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11Processor(Http11Processor.java:859)atorg.apache.coyote.http11.Http11Protocol8 (JdbcRepository.java:272) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:92) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:63) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:265) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:180) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:69) at org.apache.sqoop.server.v1.LinkServlet (LinkServlet.java:72) at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:63) at javax.servlet.http.HttpServlet (HttpServlet.java:727) at javax.servlet.http.HttpServlet (HttpServlet.java:820) 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:594) at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291) at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:553) 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:859) at org.apache.coyote.http11.Http11ProtocolHttp11ConnectionHandler (Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:503)
at java.lang.Thread (Thread.java:748)
Caused by: Exception: java.lang.Throwable Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘FK_SQ_LNK_NAME_UNIQUE’ defined on ‘SQ_LINK’.
Stack trace:
at org.apache.derby.iapi.error.StandardException (null:-1)
at org.apache.derby.impl.sql.execute.IndexChanger (null:-1)
at org.apache.derby.impl.sql.execute.IndexChanger (null:-1)
at org.apache.derby.impl.sql.execute.IndexChanger (null:-1)
at org.apache.derby.impl.sql.execute.IndexSetChanger (null:-1)
at org.apache.derby.impl.sql.execute.RowChangerImpl (null:-1)
at org.apache.derby.impl.sql.execute.InsertResultSet (null:-1)
at org.apache.derby.impl.sql.execute.InsertResultSet (null:-1)
at org.apache.derby.impl.sql.GenericPreparedStatement (null:-1)
at org.apache.derby.impl.sql.GenericPreparedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement (null:-1)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement (DelegatingPreparedStatement.java:105)
at org.apache.sqoop.repository.common.CommonRepositoryHandler (CommonRepositoryHandler.java:391)
at org.apache.sqoop.repository.JdbcRepository8(JdbcRepository.java:272)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:92)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:63)atorg.apache.sqoop.repository.JdbcRepository(JdbcRepository.java:265)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:180)atorg.apache.sqoop.handler.LinkRequestHandler(LinkRequestHandler.java:69)atorg.apache.sqoop.server.v1.LinkServlet(LinkServlet.java:72)atorg.apache.sqoop.server.SqoopProtocolServlet(SqoopProtocolServlet.java:63)atjavax.servlet.http.HttpServlet(HttpServlet.java:727)atjavax.servlet.http.HttpServlet(HttpServlet.java:820)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:594)atorg.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter(DelegationTokenAuthenticationFilter.java:291)atorg.apache.hadoop.security.authentication.server.AuthenticationFilter(AuthenticationFilter.java:553)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11Processor(Http11Processor.java:859)atorg.apache.coyote.http11.Http11Protocol8 (JdbcRepository.java:272) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:92) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:63) at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:265) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:180) at org.apache.sqoop.handler.LinkRequestHandler (LinkRequestHandler.java:69) at org.apache.sqoop.server.v1.LinkServlet (LinkServlet.java:72) at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:63) at javax.servlet.http.HttpServlet (HttpServlet.java:727) at javax.servlet.http.HttpServlet (HttpServlet.java:820) 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:594) at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291) at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:553) 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:859) at org.apache.coyote.http11.Http11ProtocolHttp11ConnectionHandler (Http11Protocol.java:610)
at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:503)
at java.lang.Thread (Thread.java:748)
a duplicate key value in a unique or primary key constraint or unique index identified by ‘FK_SQ_LNK_NAME_UNIQUE’ defined on ‘SQ_LINK’.(重复键值在唯一键或主键约束或惟一索引被“FK_SQ_LNK_NAME_UNIQUE”定义在“SQ_LINK”上)。

解决方法:查看创建数据库表中的字段是否除主键外设置了其他字段不能为空,修改之后,重启服务端,再次创建连接不再报错。