My Oracle Support Banner

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 MAY 01, 2018

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


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<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
Could not obtain block:
BP-<id>-<private ip>-<#>:blk_111222_1234

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:



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.