Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id E6E8E200C0A for ; Fri, 13 Jan 2017 13:35:30 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id E5DF3160B3F; Fri, 13 Jan 2017 12:35:30 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 4460E160B32 for ; Fri, 13 Jan 2017 13:35:30 +0100 (CET) Received: (qmail 29181 invoked by uid 500); 13 Jan 2017 12:35:29 -0000 Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@sqoop.apache.org Delivered-To: mailing list dev@sqoop.apache.org Received: (qmail 29142 invoked by uid 99); 13 Jan 2017 12:35:29 -0000 Received: from Unknown (HELO jira-lw-us.apache.org) (207.244.88.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2017 12:35:29 +0000 Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 8462E25289 for ; Fri, 13 Jan 2017 12:35:26 +0000 (UTC) Date: Fri, 13 Jan 2017 12:35:26 +0000 (UTC) From: "Jordi (JIRA)" To: dev@sqoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (SQOOP-1226) --password-file option triggers FileSystemClosed exception at end of Oozie action MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 13 Jan 2017 12:35:31 -0000 [ https://issues.apache.org/jira/browse/SQOOP-1226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15821723#comment-15821723 ] Jordi commented on SQOOP-1226: ------------------------------ I have fixed the issue implementing a custom CryptoFileLoader class in my project. Issue fix is explained in this JIRA: https://issues.apache.org/jira/browse/SQOOP-2997 I will work on it to fix it for sqoop project. > --password-file option triggers FileSystemClosed exception at end of Oozie action > --------------------------------------------------------------------------------- > > Key: SQOOP-1226 > URL: https://issues.apache.org/jira/browse/SQOOP-1226 > Project: Sqoop > Issue Type: Bug > Affects Versions: 1.4.3 > Environment: Centos 6.2 + jdk-1.6.0_31-fcs.x86_64 > Reporter: David Morel > Assignee: Jarek Jarcec Cecho > Fix For: 1.4.5 > > Attachments: SQOOP-1226.patch, SQOOP-1226.patch > > > When using the --password-file option, a Sqoop action running inside an Oozie workflow will ERROR out at the very end, like so: > {noformat} > 2013-10-31 13:38:45,095 INFO org.apache.sqoop.hive.HiveImport: Hive import complete. > 2013-10-31 13:38:45,098 INFO org.apache.sqoop.hive.HiveImport: Export directory is empty, removing it. > 2013-10-31 13:38:45,213 INFO org.apache.hadoop.mapred.TaskLogsTruncater: Initializing logs' truncater with mapRetainSize=-1 and reduceRetainSize=-1 > 2013-10-31 13:38:45,217 ERROR org.apache.hadoop.security.UserGroupInformation: PriviledgedActionException as:mapred (auth:SIMPLE) cause:java.io.IOException: Filesystem closed > 2013-10-31 13:38:45,218 WARN org.apache.hadoop.mapred.Child: Error running child > java.io.IOException: Filesystem closed > at org.apache.hadoop.hdfs.DFSClient.checkOpen(DFSClient.java:565) > at org.apache.hadoop.hdfs.DFSInputStream.close(DFSInputStream.java:589) > at java.io.FilterInputStream.close(FilterInputStream.java:155) > at org.apache.hadoop.util.LineReader.close(LineReader.java:149) > at org.apache.hadoop.mapred.LineRecordReader.close(LineRecordReader.java:243) > at org.apache.hadoop.mapred.MapTask$TrackedRecordReader.close(MapTask.java:222) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:421) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > 2013-10-31 13:38:45,234 INFO org.apache.hadoop.mapred.Task: Runnning cleanup for the task > {noformat} > With the --password option, the job completes with no error. I believe the --password-file option handling closes the FS which happens to be shared with the Oozie launcher, which can't write to it anymore on completion. The solution I found was adding: > {noformat} > > fs.hdfs.impl.disable.cache > true > > {noformat} > in the sqoop action definition in the oozie workflow, and that works, but isn't really handy. > Details are at https://groups.google.com/a/cloudera.org/d/msg/cdh-user/pdsxiy5C_IY/OD8wR0rhHgMJ -- This message was sent by Atlassian JIRA (v6.3.4#6332)