OSCH on Exadata Client Raises Block Errors when Connecting to a BDA over Infiniband with: client.local.interfaces="ib0,ib1" (Doc ID 1915121.1)

Last updated on AUGUST 07, 2014

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Oracle SQL Connector for Hadoop Distributed File System - Version 3.0 and later
x86_64

Symptoms


OSCH on Exadata Client raises block errors as below when connecting to a BDA over an Infiniband with: client.local.interfaces="ib0,ib1":

SQL> select /*+ parallel (96) */ count(*) from tif_text;
select /*+ parallel (96) */ count(*) from tif_text
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P129, instance bdanode1.example.com:<client> (1)
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /opt/oracle/orahdfs-3.0.0/bin/hdfs_stream
encountered error "OSCH: Error processing URI
hdfs://<path>/user/<path>/part-m-<#>
Could not obtain block:
BP-<id>-<private ip>-<#>:blk_111222_1234
file=/user/<path>/part-m-<#>


a) The same query executes in Hive, Impala, and 'hadoop cat'.
b) FSCK shows that the filesystem under path '/user/<path>/part-m-<#>' is healthy.
c) Connection through the 10G interface is successful i.e.

Executing the command over 10G interface works:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms