PI49138: ANALYZE FAILS WITH INSUFFICIENT ACCESS ISSUES WITH READ-ONLY HDFS ACCESS TO TABLE DIRECTORY

APAR status

• Closed as program error.

Error description

• Analyze fails with insufficient access issues with read-only
  HDFS access to table directory
  
  
  [bigsql@bdvm351 ?]$ db2 "analyze table bigsql.ext1 compute
  statistics for columns c1"
  DB21034E  The command was processed as an SQL statement because
  it was not a
  valid Command Line Processor command.  During SQL processing it
  returned:
  SQL5105N  The statement failed because a Big SQL component
  encountered an
  error. Component receiving the error: "DDL". Component returning
  the error:
  "DDL". Log entry identifier: "[BSL-0-3ef97071b]".
  SQLSTATE=58040
  
  
  Log snippets:
  2015-03-06 07:02:22,453 WARN
  com.ibm.biginsights.catalog.translator.hive.HiveExceptionTransla
  tor [Thread-3] : [BSL-0-3ef9bd5f4]: Job Submission failed with
  exception
  'org.apache.hadoop.security.AccessControlException(Permission
  denied: user=bigsql, access=READ_EXECUTE,
  inode="/tmp/newloc/._biginsights_stats":bigsql:biadmin:dr--r--r-
  -
          at
  org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check
  (FSPermissionChecker.java:234)
          at
  org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check
  Permission(FSPermissionChecker.java:164)
          at
  org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermiss
  ion(FSNamesystem.java:5185)
          at
  org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermiss
  ion(FSNamesystem.java:5167)
          at
  org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPathAcc
  ess(FSNamesystem.java:5129)
          at
  org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListingIn
  t(FSNamesystem.java:3885)
          at
  org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListing(F
  SNamesystem.java:3864)
          at
  org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getList
  ing(NameNodeRpcServer.java:737)
          at
  org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSi
  deTranslatorPB.getListing(ClientNamenodeProtocolServerSideTransl
  atorPB.java:514)
          at
  org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProt
  os$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodePro
  tocolProtos.java:59600)
          at
  org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoke
  r.call(ProtobufRpcEngine.java:585)
          at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:928)
          at
  org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2048)
          at
  org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2044)
          at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:366)
          at javax.security.auth.Subject.doAs(Subject.java:572)
          at
  org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupIn
  formation.java:1502)
          at
  org.apache.hadoop.ipc.Server$Handler.run(Server.java:2042)
  )'
  FAILED: Execution Error, return code 1 from
  org.apache.hadoop.hive.ql.exec.mr.MapRedTask
  

Local fix

Problem summary

• See error description
  

Problem conclusion

• This problem is fixed in Version 4.1.0 FP2 and later fix packs
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• None
  NA
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R410 PSY

     UP