You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "geyf (JIRA)" <ji...@apache.org> on 2016/08/30 06:30:22 UTC
[jira] [Updated] (SQOOP-3004) Can not delete job once it completed
one time
[ https://issues.apache.org/jira/browse/SQOOP-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
geyf updated SQOOP-3004:
------------------------
Description:
First, my hadoop envirionment version is 2.6.0.
After I create a job in Sqoop2-server and run it one time, I cannot run it again and I cannot delete this job either.
My job name is Or2HD,and the shell give me these description below:
Exception has occurred during processing command
Exception: org.apache.sqoop.common.SqoopException Message: JDBCREPO_0022:Given job id is in use - Name in use: Or2HD
Stack trace:
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:137)
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:69)
at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:191)
at org.apache.sqoop.client.request.JobResourceRequest (JobResourceRequest.java:101)
at org.apache.sqoop.client.request.SqoopResourceRequests (SqoopResourceRequests.java:162)
at org.apache.sqoop.client.SqoopClient (SqoopClient.java:450)
at org.apache.sqoop.shell.DeleteJobFunction (DeleteJobFunction.java:46)
at org.apache.sqoop.shell.SqoopFunction (SqoopFunction.java:51)
at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:134)
at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:110)
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.GeneratedMethodAccessor30 (null:-1)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:497)
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
at groovy.lang.MetaMethod (MetaMethod.java:324)
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:254)
at sun.reflect.GeneratedMethodAccessor29 (null:-1)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:497)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:207)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:56)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:161)
at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:153)
at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:119)
at org.codehaus.groovy.tools.shell.Shell$leftShift$0 (null:-1)
at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:94)
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1)
at sun.reflect.GeneratedMethodAccessor25 (null:-1)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:497)
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
at groovy.lang.MetaMethod (MetaMethod.java:324)
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:150)
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:123)
at sun.reflect.GeneratedMethodAccessor24 (null:-1)
at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method (Method.java:497)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:207)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:56)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:153)
at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:58)
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:497)
at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
at groovy.lang.MetaMethod (MetaMethod.java:324)
at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:150)
at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:82)
at java_lang_Runnable$run (null:-1)
at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:45)
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:585)
at org.apache.sqoop.shell.SqoopShell (SqoopShell.java:156)
Caused by: Exception: org.apache.sqoop.common.SqoopException Message: JDBCREPO_0022:Given job id is in use - Name in use: Or2HD
Stack trace:
at org.apache.sqoop.repository.JdbcRepository$19 (JdbcRepository.java:482)
at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:91)
at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:62)
at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:475)
at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:147)
at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:121)
at org.apache.sqoop.server.v1.JobServlet (JobServlet.java:89)
at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:97)
at javax.servlet.http.HttpServlet (HttpServlet.java:713)
at javax.servlet.http.HttpServlet (HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder (ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain (ServletHandler.java:1669)
at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:572)
at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:269)
at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:542)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain (ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ContextHandler (ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:515)
at org.eclipse.jetty.server.handler.ContextHandler (ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler (ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper (HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server (Server.java:499)
at org.eclipse.jetty.server.HttpChannel (HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection (HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2 (AbstractConnection.java:540)
at java.util.concurrent.ThreadPoolExecutor (ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker (ThreadPoolExecutor.java:617)
at java.lang.Thread (Thread.java:745)
was:
First, my hadoop envirionment version is 2.6.0.
After I create a job in Sqoop2-server and run it one times, I cannot run it again and I cannot delete this job either.
My job name is Or2HD,and the shell give me these description below:
Exception has occurred during processing command
Exception: org.apache.sqoop.common.SqoopException Message: JDBCREPO_0022:Given job id is in use - Name in use: Or2HD
> Can not delete job once it completed one time
> ---------------------------------------------
>
> Key: SQOOP-3004
> URL: https://issues.apache.org/jira/browse/SQOOP-3004
> Project: Sqoop
> Issue Type: Test
> Components: connectors/generic, connectors/hdfs
> Affects Versions: 1.99.7
> Reporter: geyf
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> First, my hadoop envirionment version is 2.6.0.
> After I create a job in Sqoop2-server and run it one time, I cannot run it again and I cannot delete this job either.
> My job name is Or2HD,and the shell give me these description below:
> Exception has occurred during processing command
> Exception: org.apache.sqoop.common.SqoopException Message: JDBCREPO_0022:Given job id is in use - Name in use: Or2HD
> Stack trace:
> at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:137)
> at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:69)
> at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:191)
> at org.apache.sqoop.client.request.JobResourceRequest (JobResourceRequest.java:101)
> at org.apache.sqoop.client.request.SqoopResourceRequests (SqoopResourceRequests.java:162)
> at org.apache.sqoop.client.SqoopClient (SqoopClient.java:450)
> at org.apache.sqoop.shell.DeleteJobFunction (DeleteJobFunction.java:46)
> at org.apache.sqoop.shell.SqoopFunction (SqoopFunction.java:51)
> at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:134)
> at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:110)
> 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.GeneratedMethodAccessor30 (null:-1)
> at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method (Method.java:497)
> at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
> at groovy.lang.MetaMethod (MetaMethod.java:324)
> at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
> at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:254)
> at sun.reflect.GeneratedMethodAccessor29 (null:-1)
> at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method (Method.java:497)
> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:207)
> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:56)
> at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:161)
> at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:153)
> at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:119)
> at org.codehaus.groovy.tools.shell.Shell$leftShift$0 (null:-1)
> at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:94)
> at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1)
> at sun.reflect.GeneratedMethodAccessor25 (null:-1)
> at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method (Method.java:497)
> at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
> at groovy.lang.MetaMethod (MetaMethod.java:324)
> at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:150)
> at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:123)
> at sun.reflect.GeneratedMethodAccessor24 (null:-1)
> at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method (Method.java:497)
> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:207)
> at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:56)
> at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:153)
> at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:58)
> 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:497)
> at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)
> at groovy.lang.MetaMethod (MetaMethod.java:324)
> at groovy.lang.MetaClassImpl (MetaClassImpl.java:1208)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:130)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:150)
> at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:82)
> at java_lang_Runnable$run (null:-1)
> at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:45)
> 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:585)
> at org.apache.sqoop.shell.SqoopShell (SqoopShell.java:156)
> Caused by: Exception: org.apache.sqoop.common.SqoopException Message: JDBCREPO_0022:Given job id is in use - Name in use: Or2HD
> Stack trace:
> at org.apache.sqoop.repository.JdbcRepository$19 (JdbcRepository.java:482)
> at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:91)
> at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:62)
> at org.apache.sqoop.repository.JdbcRepository (JdbcRepository.java:475)
> at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:147)
> at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:121)
> at org.apache.sqoop.server.v1.JobServlet (JobServlet.java:89)
> at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:97)
> at javax.servlet.http.HttpServlet (HttpServlet.java:713)
> at javax.servlet.http.HttpServlet (HttpServlet.java:790)
> at org.eclipse.jetty.servlet.ServletHolder (ServletHolder.java:808)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain (ServletHandler.java:1669)
> at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:572)
> at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:269)
> at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:542)
> at org.eclipse.jetty.servlet.ServletHandler$CachedChain (ServletHandler.java:1652)
> at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:585)
> at org.eclipse.jetty.server.handler.ContextHandler (ContextHandler.java:1127)
> at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:515)
> at org.eclipse.jetty.server.handler.ContextHandler (ContextHandler.java:1061)
> at org.eclipse.jetty.server.handler.ScopedHandler (ScopedHandler.java:141)
> at org.eclipse.jetty.server.handler.HandlerWrapper (HandlerWrapper.java:97)
> at org.eclipse.jetty.server.Server (Server.java:499)
> at org.eclipse.jetty.server.HttpChannel (HttpChannel.java:310)
> at org.eclipse.jetty.server.HttpConnection (HttpConnection.java:257)
> at org.eclipse.jetty.io.AbstractConnection$2 (AbstractConnection.java:540)
> at java.util.concurrent.ThreadPoolExecutor (ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker (ThreadPoolExecutor.java:617)
> at java.lang.Thread (Thread.java:745)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)